Loading...
HomeMy WebLinkAbout2019-10 Combined Financials October 2019TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 2019 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 329,851 18,050 1,247,487 TOTAL ASSETS 1,595,388 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 1,247,493 1,247,493 603,769 (255,874) 347,895 1,595,388 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 122 Trophy Club MUD Fire Dept. Account 1 1 122-40010-000-000 1 122-40011-000-000 1 Description Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Trophy Club MUD No.1 Budget Summary with Amendment Department: Fire Revenues Period Ending: 10/2019 Program: Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,214,230.00- 1,214,230.00- 15,522.86- 1,367.73 15,522.86- 1,367.73 1.278 1,198,707.14- 1,367.73 - Page 1 122-40020-000-000 Property Taxes/Fire P&i 68.47- 68.47- 68.47 Subtotal: 1,214,230.00- 1,214,230.00- 14,223.60- 14,223.60- 1.171 1,200,006.40 - Program number: 1,214,230.00- 1,214,230.00- 14,223.60- 14,223.60- 1.171 1,200,006.40 - Department number: Fire Revenues 1,214,230.00- 1,214,230.00- 14,223.60- 14,223.60- 1.171 1,200,006.40 - Revenues Subtotal 1,214,230.00- 1,214,230.00- 14,223.60- 14,223.60- 1.171 1,200,006.40- glbase_tbam skrolczyk 17:07 11/07/19 Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Trophy Club MUD No.1 Page 2 Budget Summary with Amendment 122-60030-045-000 Rent And/Or Usage 218,004.00 218,004.00 122-60055-045-000 Insurance 21,000.00 21,000.00 122-60337-045-000 Transfer to Town/Fire Budget Subtotal: 122-69005-045-000 122-69009-045-000 122-69195-045-000 122-69305-045-000 Subtotal: Program number: Capital Outlays Short Term Debt -Interest GASB34/Reserve for Replacement Capital Leases Department number: Fire Expenditures Subtotal Fund number: 122 Trophy Club MUD Fire Dept. 239,004.00 239,004.00 48,000.00 48,000.00 81,420.00 81,420.00 127,149.00 127,149.00 256,569.00 256,569.00 495,573.00 495,573.00 495,573.00 495,573.00 718,657.00- 495,573.00 495,573.00 718,657.00- 1,640.88 59,888.08 1,640.88 59,888.08 61,528.96 61,528.96 11,958.24 81,420.00 115,190.36 11,958.24 81,420.00 115,190.36 208,568.60 208,568.60 270,097.56 270,097.56 270,097.56 270,097.56 255,873.96 270,097.56 270,097.56 255,873.96 7.814 25.744 100.000 90.595 81.291 54.502 54.502 54.502 -35.604 218,004.00 19,359.12 59,888.08- 177,475.04 48,000.00 11,958.24- 11,958.64 48,000.40 225,475.44 225,475.44 225,475.44 974,530.96- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 1 188 10/02/2019 Property Taxes 191 10/08/2019 Property Taxes 192 10/09/2019 Property Taxes 193 10/10/2019 Property Taxes 194 10/11/2019 Property Taxes 196 10/15/2019 Property Taxes 197 10/16/2019 Property Taxes 198 10/17/2019 Property Taxes 199 10/18/2019 Property Taxes 200 10/21/2019 Property Taxes 201 10/22/2019 Property Taxes 202 10/24/2019 Property Taxes 203 10/25/2019 Property Taxes 204 10/28/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes 207 10/31/2019 Property Taxes (48.87) (48.87) GL (461.55) (510.42) GL (165.03) (675.45) GL (241.22) (916.67) GL (828.17) (1,744.84) GL (228.14) (1,972.98) GL (8.15) (1,981.13) GL (415.89) (2,397.02) GL (716.66) (3,113.68) GL (896.42) (4,010.10) GL (186.42) (4,196.52) GL (1,275.47) (5,471.99) GL (555.43) (6,027.42) GL (6,276.64) (12,304.06) GL (388.32) (12,692.38) GL (1,119.70) (13,812.08) GL (1,710.78) (15,522.86) GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (15,522.86) (15,522.86) ** (1,214,230.00) Budgeted (1,198,707.14) Remaining 1 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 189 10/03/2019 Property Taxes 190 10/07/2019 Property Taxes 193 10/10/2019 Property Taxes 194 10/11/2019 Property Taxes 196 10/15/2019 Property Taxes 199 10/18/2019 Property Taxes 201 10/22/2019 Property Taxes 202 10/24/2019 Property Taxes 203 10/25/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes 942.30 942.30 GL (15.66) 926.64 GL 33.98 960.62 GL (35.06) 925.56 GL (3.62) 921.94 GL 664.09 1,586.03 GL (180.43) 1,405.60 GL (.52) 1,405.08 GL (10.24) 1,394.84 GL (13.20) 1,381.64 GL (13.91) 1,367.73 GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 1,367.73 1,367.73 ** .00 Budgeted (1,367.73) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire PSI 190 10/07/2019 Property Taxes 194 10/11/2019 Property Taxes (3.21) (3.21) GL (7.37) (10.58) GL glpdatb2 skrolczyk Trophy Club MUD No.1 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) 196 10/15/2019 Property Taxes 201 10/22/2019 Property Taxes 203 10/25/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes (.65) (11.23) (48.83) (60.06) (1.84) (61.90) (1.98) (63.88) (4.59) (68.47) Page 2 Check Source Number GL GL GL GL GL Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (68.47) (68.47) ** Department Totals: .00 Budgeted (14,223.60) Monthly Total 68.47 Remaining 0 % Used (14,223.60) ** (1,214,230.00) Budgeted (1,200,006.40) Remaining 1 % Used glpdatb2 skrolczyk 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2019 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: 218,004.00 Budgeted Account: 122-60055-045-000 Insurance 66 10/01/2019 Insurance/Wrk Comp Expense Oct Account: 122-60055-045-000 218,004.00 Remaining 0 % Used Insurance Totals: 21,000.00 Budgeted .00 .00 .00 .00 ** 1,640.88 1,640.88 GL 19,359.12 Remaining 8 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 48 10/11/2019 October A/P Fire admin -Oct Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: .00 Budgeted (59,888.08) Remaining 1,640.88 1,640.88 ** 59,888.08 59,888.08 TOWN OF TROPHY CLUB 5821 AP 0 9 Used 59,888.08 59,888.08 ** Account: 122-69005-045-000 Capital Outlays .00 .00 Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 48,000.00 Budgeted 48,000.00 Remaining 0 8 Used Account: 122-69009-045-000 Short Term Debt -Interest 129 10/11/2019 Sep Out Int/Prin Fire Trk FY20 Seperate Interest in Cap Lease Account: 122-69009-045-000 ' Short Term Debt -Interest Totals: .00 Budgeted (11,958.24) Remaining Account: 122-69195-045-000 GASB34/Reserve for Replacement 151 10/01/2019 GASB 34 Transfers FY 2020 Fire Truck Future Replacement Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 Budgeted .00 Remaining 11,958.24 11,958.24 GL 11,958.24 11,958.24 ** 0 % Used 81,420.00 81,420.00 GL 81,420.00 81,420.00 ** 100 % Used Account: 122-69305-045-000 Capital Leases glpdatb2 skrolczyk 17:07 11/07/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Department: 45 Fire JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: Page 4 Period Ending: 10/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) 48 10/11/2019 October A/P lease payment FD ladder -T681 129 10/11/2019 Sep Out Int/Prin Fire Trk FY20 127,148.60 (11,958.24) 127,148.60 PNC Bank, N.A. 115,190.36 5820 AP GL Account: 122-69305-045-000 Capital Leases Totals: 115,190.36 115,190.36 ** 127,149.00 Budgeted 11,958.64 Remaining 91 % Used Department 45 Totals: Fund 122 Totals: 270,097.56 Monthly Total 495,573.00 Budgeted 270,097.56 ** 225,475.44 Remaining 55 % Used 255,873.96 255,873.96 Monthly Total (718,657.00) Budgeted (974,530.96) Remaining -36 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET OCTOBER 2019 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,298,274 2,298,274 CASH IN BANK -SAVINGS -CASH RESERVE 1,397,251 1,397,251 INVESTMENTS-TEXPOOL 4,317,837 919,266 5,237,103 PREPAID EXPENSES 102,342 102,342 ADVALOREM PROPERTY TAXES RECEIVABLE 138,406 138,406 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,190,325 1,190,325 TOTAL ASSETS 9,445,035 919,266 10,364,301 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 138,406 138,406 ACCOUNTS AND OTHER PAYABLES 373,176 373,176 CUSTOMER DEPOSITS 319,829 319,829 TOTAL LIABILITIES 831,411 831,411 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 2,072,098 2,072,098 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 270,000 270,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 30,000 30,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 127,805 127,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 391,461 391,461 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 100,000 100,000 UNASSIGNED FUND BALANCE 6,325,800 6,325,800 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 212,239 212,239 TOTAL FUND BALANCE 8,613,624 919,266 9,532,890 TOTAL LIABILITIES AND FUND BALANCE 9,445,035 919,266 10,364,301 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund Account 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Description Property Taxes Property Taxes/Delinquent Property Taxes/P & i PID Surcharges Department: Adopted Budget 134,871.00- 300.00- 300.00- 164,253.00- Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 10/2019 Amended Total Budget Encumb. 134,871.00- 300.00- 300.00- 164,253.00- Current Month Program: YTD Total 1,723.24- 1,723.24- 155.66 155.66 7.82- 7.82- % of Budget 1.278 -51.887 2.607 Remaining Budget 133,147.76- 455.66- 292.18- 164,253.00- Page 3 Subtotal: 299,724.00- 299,724.00- 1,575.40- 1,575.40- .526 298,148.60- 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-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income Subtotal: Program number: Department number: Revenues Revenues Subtotal 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 10,171,516.00- 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 7,000.00- 173,837.00- 10,645,077.00- 10,645,077.00- 10,645,077.00 - 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 10,171,516.00- 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 7,000.00- 173,837.00- 10,645,077.00- 10,645,077.00- 10,645,077.00 - 536,379.28- 536,379.28- 221,960.36- 221,960.36- 9,981.43- 9,981.43- 1,075.00- 1,075.00- 1,800.00- 1,800.00- 400.00- 400.00- 15,036.00- 15,036.00- 786,632.07- 786,632.07- 11,765.78- 11,765.78- 583.33- 583.33- 5,355.28- 5,355.28- 7,372.29- 7,372.29- 25,076.68- 813,284.15- 813,284.15- 813,284.15- 25,076.68- 813,284.15- 813,284.15- 813,284.15- 8.269 6.335 8.864 7.096 240.000 16.000 30.072 5,950,243.72- 3,281,924.64- 102,626.57- 14,075.00- 1,050.00 2,100.00- 34,964.00- 7.734 9,384,883.93- 9.805 8.333 42.197 105.318 14.425 7.640 7.640 7.640 108,234.22- 14,146.00- 6,416.67- 13,000.00- 7,335.72- 372.29 08,234.22-14,146.00-6,416.67-13,000.00- 7,335.72- 372.29 148,760.32- 9,831,792.85- 9,831,792.85- 9,831,792.85- Page 48,760.32-9,831,792.85-9,831,792.85- 9,831,792.85- glbase_tbam skrolczyk 17:07 11/07/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 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 Department: Adopted Budget 350,267.00 17,000.00 3,920.00 5,400.00 34,863.00 84,326.00 4,725.00 767.00 3,132.00 23,348.00 5,461.00 1,080.00 11,850.00 400.00 300.00 10 Water Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 10/2019 Total Encumb. Amended Budget 350,267.00 17,000.00 3,920.00 5,400.00 34,863.00 84,326.00 4,725.00 767.00 3,132.00 23,348.00 5,461.00 1,080.00 11,850.00 400.00 300.00 Current Month Program: YTD Total % of Budget 10,227.68 10,227.68 2.920 821.89 821.89 4.835 350.00 350.00 6.481 2,135.12 2,135.12 6.124 3,821.04 3,821.04 4.531 243.97 243.97 5.163 38.90 38.90 5.072 189.67 189.67 6.056 693.28 693.28 2.969 162.14 162.14 2.969 .80 .80 .074 771.49 771.49 6.510 Remaining Budget 340,039.32 16,178.11 3,920.00 5,050.00 32,727.88 80,504.96 4,481.03 728.10 2,942.33 22,654.72 5,298.86 1,079.20 11,078.51 400.00 300.00 Page 4 Subtotal: 546,839.00 546,839.00 19,455.98 19,455.98 3.558 527,383.02 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 Engineering Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 1,000.00 7,500.00 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 1,000.00 7,500.00 2,926.83 2,926.83 2.927 207.88 207.88 4.158 87.50 87.50 8.750 20,000.00 97,073.17 3,000.00 4,792.12 3,500.00 912.50 7,500.00 Subtotal: 140,000.00 140,000.00 3,222.21 3,222.21 2.302 136,777.79 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 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 5,000.00 125,677.00 1,000.00 500.00 7,426.00 400.00 2,845.00 1,500.00 63,000.00 2,714,710.00 200.00 3,000.00 14,750.00 527,381.00 55,193.00 180,000.00 5,000.00 125,677.00 1,000.00 500.00 7,426.00 400.00 2,845.00 1,500.00 63,000.00 2,714,710.00 200.00 3,000.00 14,750.00 527,381.00 55,193.00 180,000.00 364.16 364.16 7.283 14,721.00 14,721.00 11.713 295.00 295.00 3.973 462.00 47,943.74 4,600.00 462.00 47,943.74 4,600.00 15.400 9.091 8.334 4,635.84 110,956.00 1,000.00 500.00 7,131.00 400.00 2,845.00 1,500.00 63,000.00 2,714,710.00 200.00 2,538.00 14,750.00 479,437.26 50,593.00 180,000.00 glbase_tbam skrolczyk 17:07 11/07/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 3,705,082.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 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 913,618.00 Program number: 5,504,929.00 10 Water Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 10/2019 Total Encumb. Amended Budget 2,500.00 3,705,082.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 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 913,618.00 5,504,929.00 Current Month Program: YTD Total 68,385.90 68,385.90 773.48 773.48 819.99 819.99 1,689.24 1,689.24 8,875.28 8,875.28 12,157.99 12,157.99 18,651.60 75,000.00 93,651.60 196,873.68 18,651.60 75,000.00 93,651.60 196,873.68 % of Budget 1.846 5.157 15.799 8.446 12.679 6.098 2.723 100.000 10.251 3.576 Remaining Budget 2,500.00 3,636,696.10 14,226.52 4,370.01 18,310.76 1,200.00 1,000.00 61,124.72 87,000.00 187,232.01 666,223.40 30,512.00 3,231.00 120,000.00 819,966.40 5,308,055.32 Page 5 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 17:07 11/07/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/2019 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,506,929.00 5,506,929.00 196,873.68 196,873.68 3.575 2,000.00 2,000.00 2,000.00 5,310,055.32 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 17:07 11/07/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 441,799.00 441,799.00 135-50010-020-000 Overtime 33,000.00 33,000.00 135-50016-020-000 Longevity 8,035.00 8,035.00 135-50017-020-000 Certification 9,000.00 9,000.00 135-50020-020-000 Retirement 45,531.00 45,531.00 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 135-50028-020-000 Vision Insurance 948.00 948.00 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 Subtotal: 708,447.00 708,447.00 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-55081-020-000 Mainten & Re/Pairs Collections 10,000.00 10,000.00 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 Subtotal: 309,500.00 309,500.00 12,956.76 649.08 625.00 2,854.98 5,987.13 358.15 59.22 337.14 803.96 188.01 12,956.76 649.08 625.00 2,854.98 5,987.13 358.15 59.22 337.14 803.96 188.01 1,110.20 1,110.20 25,929.63 25,929.63 3,704.54 7,925.25 47.02 856.24- 87.50 4,806.24 2,389.60 3,704.54 7,925.25 2.933 1.967 6.944 6.270 5.710 6.157 6.247 7.492 2.636 2.636 7.222 3.660 4.210 79.253 47.02 1.176 856.24- 87.50 4,806.24 2,389.60 18,103.91 18,103.91 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 372.84 372.84 135-60020-020-000 Electricity 160,067.00 160,067.00 11,761.29 11,761.29 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 4,990.00 4,990.00 840.00 840.00 16.834 135-60090-020-000 Safety Program 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,545.00 1,545.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 15,000.00 15,000.00 9,888.02 9,888.02 65.920 -28.541 5.833 4.806 5.974 5.849 7.457 7.348 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 428,842.24 32,350.92 8,035.00 8,375.00 42,676.02 98,870.87 5,458.85 888.78 4,162.86 29,690.04 6,943.99 1,260.00 14,262.80 400.00 300.00 682,517.37 30,000.00 15,000.00 84,295.46 2,074.75 10,000.00 3,952.98 8,000.00 3,856.24 1,412.50 95,193.76 37,610.40 291,396.09 4,627.16 148,305.71 200.00 300.00 4,150.00 1,000.00 1,545.00 5,000.00 2,500.00 5,111.98 450.00 5,000.00 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund Account 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Description Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 Department: Adopted Budget 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 Trophy Club MUD No.1 Budget Summary with Amendment 20 Wastewater Period Ending: 10/2019 Amended Total Budget Encumb. 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 Current Month Program: YTD Total 10,414.81 10,414.81 61,260.70 61,260.70 5,750.00 5,750.00 % of Budget 9.091 9.091 4.593 Remaining Budget 14,000.00 104,148.19 612,606.30 119,437.00 180,000.00 2,000.00 Page 8 Subtotal: 1,310,669.00 1,310,669.00 100,287.66 100,287.66 7.652 1,210,381.34 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65031-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 Fuel & Lube Uniforms Chemicals Chemicals Collections Small Tools Safety E uipment Lab Supplies Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Subtotal: Program number: Department number: Wastewater 12,500.00 5,495.00 20,000.00 17,500.00 1,200.00 1,200.00 20,000.00 77,895.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 12,500.00 5,495.00 20,000.00 17,500.00 1,200.00 1,200.00 20,000.00 77,895.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 923.61 923.61 892.41 892.41 2,825.96 2,825.96 2,983.01 2,983.01 7,624.99 7,624.99 5,789.00 5,789.00 130,000.00 130,000.00 135,789.00 135,789.00 287,735.19 287,735.19 287,735.19 287,735.19 7.389 16.240 14.130 14.915 9.789 1.091 100.000 18.083 9.113 9.113 11,576.39 4,602.59 17,174.04 17,500.00 1,200.00 1,200.00 17,016.99 70,270.01 524,711.00 79,133.00 11,277.00 615,121.00 2,869,685.81 2,869,685.81 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 17:07 11/07/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Period Ending: 10/2019 Account Description Adopted Amended Total Current YTD % of Budget Budget Encumb. Month Total Budget Program: 135-50045-026-000 Subtotal: Workman's Compensation 30.00 30.00 30.00 30.00 135-60066-026-000 Publications/Books/Subscripts 150.00 135-60070-026-000 Dues & Memberships 750.00 135-60075-026-000 Meetings 1,300.00 135-60080-026-000 Schools & Training 4,000.00 135-60100-026-000 Travel & per diem 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 Subtotal: 13,200.00 Program number: 13,230.00 Department number: Board of Directors 13,230.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 13,200.00 13,230.00 13,230.00 1.99 1.99 1.99 1.99 6.633 Remaining Budget 28.01 6.633 28.01 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 13,200.00 1.99 1.99 .015 13,228.01 1.99 1.99 .015 13,228.01 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 17:07 11/07/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2019 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 628,298.00 2,000.00 2,208.00 58,554.00 124,394.00 6,464.00 1,035.00 4,500.00 39,215.00 9,171.00 1,440.00 1,775.00 500.00 8,000.00 628,298.00 2,000.00 2,208.00 58,554.00 124,394.00 6,464.00 1,035.00 4,500.00 39,215.00 9,171.00 1,440.00 1,775.00 500.00 8,000.00 13,565.85 2,760.64 5,488.81 306.40 48.77 292.42 782.00 182.91 104.82 178.85 13,565.85 2,760.64 5,488.81 306.40 48.77 292.42 782.00 182.91 104.82 178.85 2.159 4.715 4.412 4.740 4.712 6.498 1.994 1.994 5.905 2.236 614,732.15 2,000.00 2,208.00 55,793.36 118,905.19 6,157.60 986.23 4,207.58 38,433.00 8,988.09 1,440.00 1,670.18 500.00 7,821.15 Subtotal: 887,554.00 887,554.00 23,711.47 23,711.47 2.672 863,842.53 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 134,681.00 135,000.00 15,000.00 10,000.00 10,000.00 65,600.00 9,000.00 134,681.00 135,000.00 15,000.00 10,000.00 10,000.00 65,600.00 9,000.00 65,525.85 515.00 869.06 582.15 65,525.85 515.00 869.06 582.15 48.653 3.433 8.691 6.468 69,155.15 135,000.00 14,485.00 10,000.00 9,130.94 65,600.00 8,417.85 Subtotal: 379,281.00 379,281.00 67,492.06 67,492.06 17.795 311,788.94 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,680.00 4,000.00 6,879.00 1,500.00 30,000.00 67,000.00 1,500.00 84,000.00 1,000.00 6,000.00 400.00 6,000.00 6,850.00 3,545.00 200.00 2,500.00 1,288.00 23,680.00 4,000.00 6,879.00 1,500.00 30,000.00 67,000.00 1,500.00 84,000.00 1,000.00 6,000.00 400.00 6,000.00 6,850.00 3,545.00 200.00 2,500.00 1,288.00 1,479.80 238.02 66.78 1,726.61 7,047.93 6,998.39 200.00 349.75 777.71 91.78 24.00 1,479.80 238.02 66.78 1,726.61 7,047.93 6.249 5.951 4.452 5.755 10.519 6,998.39 8.331 200.00 3.333 349.75 777.71 91.78 5.829 11.353 2.589 24.00 1.863 22,200.20 3,761.98 6,879.00 1,433.22 28,273.39 59,952.07 1,500.00 77,001.61 1,000.00 5,800.00 400.00 5,650.25 6,072.29 3,453.22 200.00 2,500.00 1,264.00 glbase_tbam skrolczyk 17:07 11/07/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: 10/2019 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: 266,342.00 266,342.00 19,000.77 19,000.77 7.134 247,341.23 135-65010-030-000 135-65055-030-000 135-65085-030-000 135-65090-030-000 135-65095-030-000 135-65105-030-000 Uniforms Hardware Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing 2,050.00 26,485.00 6,000.00 3,500.00 4,000.00 2,500.00 2,050.00 26,485.00 6,000.00 3,500.00 4,000.00 2,500.00 561.33 428.00 561.33 428.00 9.356 10.700 2,050.00 26,485.00 5,438.67 3,500.00 3,572.00 2,500.00 Subtotal: 44,535.00 44,535.00 989.33 989.33 2.221 43,545.67 135-69005-030-000 Capital Outlays 195,000.00 195,000.00 195,000.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 253.84 253.84 6.346 3,746.16 Subtotal: 199,000.00 199,000.00 253.84 253.84 .128 198,746.16 Program number: 1,776,712.00 1,776,712.00 111,447.47 111,447.47 6.273 1,665,264.53 Department number: Administration 1,776,712.00 1,776,712.00 111,447.47 111,447.47 6.273 1,665,264.53 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund Department: Account Description Adopted Budget Trophy Club MUD No.1 Page 12 Budget Summary with Amendment 39 Non Departmental Program: Period Ending: 10/2019 Amended Total Current YTD % of Budget Encumb. Month Total Budget 135-55045-039-000 Legal 135,000.00 135,000.00 135-55055-039-000 Auditing 33,800.00 33,800.00 5,000.00 5,000.00 135-55060-039-000 Appraisal 11,761.00 11,761.00 13.35- 13.35- 135-55065-039-000 Tax Admin Fees 4,000.00 4,000.00 Subtotal: 184,561.00 184,561.00 4,986.65 4,986.65 Program number: 184,561.00 184,561.00 4,986.65 4,986.65 Department number: Non Departmental 184,561.00 184,561.00 4,986.65 4,986.65 Expenditures Subtotal 10,638,853.00 10,638,853.00 601,044.98 601,044.98 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 212,239.17- 212,239.17- 14.793 -.114 Remaining Budget 135,000.00 28,800.00 11,774.35 4,000.00 2.702 179,574.35 2.702 179,574.35 2.702 179,574.35 5.650 10,037,808.02 3,410.012 206,015.17 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 137 MUD 1 Consolidated GASB Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 10/2019 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 205,000.00- 81,420.00- 205,000.00- 81,420.00- 205,000.00 81,420.00 Subtotal: 286,420.00- 286,420.00- 286,420.00 Program number: 286,420.00- 286,420.00- 286,420.00 Department number: 286,420.00- 286,420.00- 286,420.00 Revenues Subtotal 286,420.00- 286,420.00- 286,420.00 Fund number: 137 MUD 1 Consolidated GASB 286,420.00- 286,420.00- 286,420.00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 188 10/02/2019 Property Taxes 191 10/08/2019 Property Taxes 192 10/09/2019 Property Taxes 193 10/10/2019 Property Taxes 194 10/11/2019 Property Taxes 196 10/15/2019 Property Taxes 197 10/16/2019 Property Taxes 198 10/17/2019 Property Taxes 199 10/18/2019 Property Taxes 200 10/21/2019 Property Taxes 201 10/22/2019 Property Taxes 202 10/24/2019 Property Taxes 203 10/25/2019 Property Taxes 204 10/28/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes 207 10/31/2019 Property Taxes (5.43) (5.43) GL (51.24) (56.67) GL (18.32) (74.99) GL (26.77) (101.76) GL (91.94) (193.70) GL (25.33) (219.03) GL (.90) (219.93) GL (46.17) (266.10) GL (79.56) (345.66) GL (99.51) (445.17) GL (20.70) (465.87) GL (141.59) (607.46) GL (61.66) (669.12) GL (696.78) (1,365.90) GL (43.12) (1,409.02) GL (124.30) (1,533.32) GL (189.92) (1,723.24) GL Account: 135-40000-000-000 Property Taxes Totals: (1,723.24) (1,723.24) ** (134,871.00) Budgeted (133,147.76) Remaining 1 6 Used Account: 135-40002-000-000 Property Taxes/Delinquent 189 10/03/2019 Property Taxes 190 10/07/2019 Property Taxes 193 10/10/2019 Property Taxes 194 10/11/2019 Property Taxes 196 10/15/2019 Property Taxes 199 10/18/2019 Property Taxes 201 10/22/2019 Property Taxes 202 10/24/2019 Property Taxes 203 10/25/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes 107.29 107.29 GL (1.78) 105.51 GL 3.88 109.39 GL (3.99) 105.40 GL (.41) 104.99 GL 75.61 180.60 GL (20.62) 159.98 GL (.06) 159.92 GL (1.17) 158.75 GL (1.50) 157.25 GL (1.59) 155.66 GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 155.66 155.66 ** (300.00) Budgeted (455.66) Remaining -52 % Used Account: 135-40015-000-000 Property Taxes/P & I 190 10/07/2019 Property Taxes 194 10/11/2019 Property Taxes (.37) (.37) GL (.84) (1.21) GL glpdatb2 skrolczyk Trophy Club MUD No.1 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 6 196 10/15/2019 Property Taxes 201 10/22/2019 Property Taxes 203 10/25/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes (.07) (5.58) (.21) (.22) (.53) (1.28) (6.86) (7.07) (7.29) (7.82) GL GL GL GL GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (536,379.28) (7.82) ** (300.00) Budgeted (292.18) Remaining 3 8 Used Account: 135-40025-000-000 PID Surcharges 135-47005-000-000 Sewer i 119 10/01/2019 Reversed Accrued UB JE2182 29 10/07/2019 UB 10/07/2019 Water adjustment UB20191007-20191007 User: 172 10/31/2019 UB 10/31/2019 Billing UB20191031-20191031 User: .00 .00 44,805.28 52.00 (266,817.64) Account: 135-40025-000-000 PID Surcharges Totals: Account: .00 .00 ** (221,960.36) (164,253.00) Budgeted (164,253.00) Remaining 0 % Used (3,503,885.00) Budgeted (3,281,924.64) Remaining 6 % Account: 135-47000-000-000 Water Account: 135-47025-000-000 Penalties 119 10/01/2019 Reversed Accrued UB JE2182 29 10/07/2019 UB 10/07/2019 Water adjustment UB20191007-20191007 User: 182 10/15/2019 Adj-16 Timberline Dr UB20191015-20191015 User: 172 10/31/2019 UB 10/31/2019 Billing UB20191031-20191031 User: 123,626.59 17.15 169.02 (660,192.04) 123,626.59 123,643.74 123,812.76 (536,379.28) GL UB UB UB Account: 135-47000-000-000 Water Totals: (536,379.28) (536,379.28) ** (6,486,623.00) Budgeted (5,950,243.72) Remaining 8 % Used Account: 135-47005-000-000 Sewer i 119 10/01/2019 Reversed Accrued UB JE2182 29 10/07/2019 UB 10/07/2019 Water adjustment UB20191007-20191007 User: 172 10/31/2019 UB 10/31/2019 Billing UB20191031-20191031 User: 44,805.28 52.00 (266,817.64) 44,805.28 44,857.28 (221,960.36) GL UB UB Account: 135-47005-000-000 ■ Sewer Totals: (221,960.36) (221,960.36) ** (3,503,885.00) Budgeted (3,281,924.64) Remaining 6 % Used Account: 135-47025-000-000 Penalties 55 10/14/2019 ub 10/14/2019 Penalty removal UB20191014-20191014 User: 114 10/22/2019 UB 10/22/2019 Penalties UB20191022-20191022 User: 125 10/24/2019 UB 10/24/2019 Penalty Removal UB20191024-20191024 User: 149 10/30/2019 UB 10/30/2019 Penalty removal UB20191030-20191030 User: 96.21 (10,315.11) 226.02 11.45 96.21 (10,218.90) (9,992.88) (9,981.43) UB UB UB UB Account: 135-47025-000-000 Penalties Totals: (9,981.43) (9,981.43) ** (112,608.00) Budgeted (102,626.57) Remaining 9 % Used glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Account: 135-47030-000-000 Service Charges 35 10/08/2019 DB 10/08/2019 Disconnect Fees UB20191008-20191008 User: 124 10/22/2019 UB 10/22/2019 NSF Check UB20191022-20191022 User: Account: 135-47030-000-000 Service Charges (15,150.00) Budgeted (14,075.00) Remaining Account: 135-47035-000-000 Plumbing Inspections 175 10/02/2019 Permits -TC Town Center Assoc 2210 State Hwy 114 175 10/02/2019 176 10/09/2019 177 10/10/2019 177 10/10/2019 178 10/18/2019 178 10/18/2019 Account: 135-47035-000-000 Permits -TC Town Center Assoc Permits-Irrig TC townhome HOA Permits -16 & 29 Katie Lane Permits -16 & 29 Katie Lane permits -CB Jeni Townhomes permits -CB Jeni Townhomes 2210 State Hwy 114 Lot 47X Block A Claire Dr 16 Katie Lane 29 Katie Lane 100 Claire Drive multiple addresses -Claire Dr Plumbing Inspections (750.00) Budgeted Totals: 1,050.00 Remaining 7 % Used Program: Transaction Detail (1,050.00) (25.00) (1,075.00) Transaction Vendor_Name Detail (SUBTOTAL) (1,050.00) (1,075.00) (1,075.00) ** (150.00) (150.00) (300.00) (450.00) (150.00) (600.00) (150.00) (750.00) (150.00) (900.00) (150.00) (1,050.00) (750.00) (1,800.00) 240 % Used (1,800.00) (1,800.00) Trophy Clunb Town Center Assoc Trophy Club Town Center Assoc TC Town Center Townhome HOA Drees Homes Drees Homes CB Jeni Homes CB Jeni Homes Page 7 Check Source Number UB UB CR CR CR CR CR CR CR Account: 135-47045-000-000 Sewer Inspections 177 10/10/2019 Permits -16 & 29 Katie Lane 177 10/10/2019 Permits -16 & 29 Katie Lane 178 10/18/2019 permits -CB Jeni Townhomes 178 10/18/2019 permits -CB Jeni Townhomes Account: 135-47045-000-000 16 Katie Lane 29 Katie Lane 100 Claire Drive mulitple addresses -Claire Dr Sewer Inspections (2,500.00) Budgeted Totals: (2,100.00) Remaining Account: 135-47070-000-000 TCCC Effluent Charges 172 10/31/2019 UB 10/31/2019 Billing UB20191031-20191031 User: Account: 135-47070-000-000 TCCC Effluent Charges Totals: (50,000.00) Budgeted (34,964.00) Remaining Account: 135-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October 217 10/31/2019 Bank Interest- October 217 10/31/2019 Bank Interest- October 16 % Used 30 8 Used (50.00) (50.00) (50.00) (250.00) (400.00) (15,036.00) (15,036.00) (1,001.06) (1,304.16) (9,460.56) (50.00) Drees Homes (100.00) Drees Homes (150.00) CB Jeni Homes (400.00) CB Jeni Homes (400.00) ** (15,036.00) (15,036.00) ** (1,001.06) (2,305.22) (11,765.78) CR CR CR CR UB GL GL GL glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-49011-000-000 JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Interest Income (120,000.00) Budgeted Account: 135-49016-000-000 Cell Tower Revenue Account: 135-49016-000-000 Cell Tower Revenue (14,146.00) Budgeted Account: 135-49018-000-000 Building Rent Income 219 10/31/2019 Town Billed Invoices 1710-1713 AR 20191031-20191031 User: Totals: (108,234.22) Remaining Totals: (14,146.00) Remaining Account: 135-49018-000-000 Account: 135-49026-000-000 Account: 135-49026-000-000 Account: 135-49075-000-000 175 10/02/2019 175 10/02/2019 176 10/09/2019 177 10/10/2019 177 10/10/2019 178 10/18/2019 178 10/18/2019 Account: 135-49075-000-000 Building Rent Income (7,000.00) Budgeted Totals: (6,416.67) Remaining Proceeds from Sale of Assets Proceeds from Sale of Assets Totals: (13,000.00) Budgeted (13,000.00) Remaining Oversize Meter Reimbursement Permits -TC Town Center Assoc Permits -TC Town Center Assoc Permits-Irrig TC townhome HOA Permits -16 & 29 Katie Lane Permits -16 & 29 Katie Lane permits -CB Jeni Townhomes permits -CB Jeni Townhomes 2210 State Hwy 114 2210 state hwy 114 Lot 47X Block A Claire Dr 16 Katie Lane 29 Katie Lane 100 Claire Drive multiple addresses -Claire Dr Oversize Meter Reimbursement Totals: (12,691.00) Budgeted (7,335.72) Remaining Account: 135-49900-000-000 Miscellaneous Income 178 10/18/2019 permits -CB Jeni Townhomes 100 Claire Drive 178 10/18/2019 permits -CB Jeni Townhomes various addresses -Claire Dr 172 10/31/2019 UB 10/31/2019 Billing UB20191031-20191031 User: Program: Transaction Detail 10 % Used 0 % Used 8 % Used 0 % Used 42 % Used (11,765.78) .00 .00 (583.33) (583.33) .00 .00 Transaction Vendor_Name Detail (SUBTOTAL) (11,765.78) ** .00 .00 ** (583.33) (583.33) ** .00 .00 ** (353.00) (353.00) (1,825.28) (2,178.28) (353.00) (2,531.28) (353.00) (2,884.28) (353.00) (3,237.28) (353.00) (3,590.28) (1,765.00) (5,355.28) (5,355.28) (1,200.00) (6,000.00) (172.29) Trophy Clunb Town Center Assoc Trophy Club Town Center Assoc TC Town Center Townhome HOA Drees Homes Drees Homes CB Jeni Homes CB Jeni Homes (5,355.28) ** (1,200.00) CB Jeni Homes (7,200.00) CB Jeni Homes (7,372.29) Page 8 Check Source Number AR CR CR CR CR CR CR CR CR CR UB glpdatb2 skrolczyk 17:07 11/07/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: 10/2019 Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 9 Check Source Number Account: 135-49900-000-000 Miscellaneous Income Totals: (7,372.29) (7,372.29) ** (7,000.00) Budgeted 372.29 Remaining 105 % Used Department Totals: (813,284.15) Monthly Total (813,284.15) ** (10,645,077.00) Budgeted (9,831,792.85) Remaining 8 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2019 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 5 10/04/2019 MUD Payroll 10/04/2019 Salaries & Wages 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Salaries & Wages 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 9,638.70 9,638.70 PR (9,638.70) .00 GL 11,382.64 11,382.64 PR (1,154.96) 10,227.68 GL Account: 135-50005-010-000 Salaries 6 Wages Totals: 10,227.68 10,227.68 ** 350,267.00 Budgeted Account: 135-50010-010-000 Overtime 5 10/04/2019 MUD Payroll 10/04/2019 Overtime 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Overtime 340,039.32 Remaining 3 % Used 889.18 889.18 PR (889.18) .00 GL 821.89 821.89 PR Account: 135-50010-010-000 Overtime Totals: 821.89 821.89 ** 17,000.00 Budgeted 16,178.11 Remaining 5 o Used Account: 135-50016-010-000 Longevity .00 .00 Account: 135-50016-010-000 Longevity Totals: .00 .00 ** 3,920.00 Budgeted Account: 135-50017-010-000 Certification 65 10/18/2019 MUD Payroll 10/18/2019 Certification Account: 135-50017-010-000 3,920.00 Remaining 0 % Used Certification Totals: 5,400.00 Budgeted Account: 135-50020-010-000 Retirement 5 10/04/2019 MUD Payroll 10/04/2019 Retirement 65 10/18/2019 MUD Payroll 10/18/2019 Retirement 5,050.00 Remaining 6 6 Used 350.00 350.00 PR 350.00 350.00 ** 973.82 973.82 1,161.30 2,135.12 PR PR Account: 135-50020-010-000 Retirement Totals: 2,135.12 2,135.12 ** 34,863.00 Budgeted Account: 135-50026-010-000 Medical Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Medical Insurance 32,727.88 Remaining 6 6 Used 1,558.33 1,558.33 PR glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 65 10/18/2019 MUD Payroll 10/18/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Medical Insurance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 2,262.71 3,821.04 Page 11 Check Source Number PR 5 10/04/2019 MUD Payroll 10/04/2019 Social Security Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Social Security Taxes 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 653.26 (653.26) 763.35 (70.07) 653.26 .00 763.35 693.28 PR GL PR GL Account: 135-50030-010-000 Social Security Taxes Totals: 693.28 693.28 ** 23,348.00 Budgeted 22,654.72 Remaining 3 % Used Account: 135-50035-010-000 Medicare Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Medicare Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 152.78 152.78 (152.78) .00 PR GL Account: 135-50026-010-000 Medical Insurance Totals: 3,821.04 3,821.04 ** 84,326.00 Budgeted 80,504.96 Remaining 5 % Used Account: 135-50027-010-000 Dental Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Dental Insurance 65 10/18/2019 MUD Payroll 10/18/2019 Dental Insurance 105.42 138.55 105.42 243.97 PR PR Account: 135-50027-010-000 Dental Insurance Totals: 243.97 243.97 ** 4,725.00 Budgeted 4,481.03 Remaining 5 % Used Account: 135-50028-010-000 11111 Vision Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Vision Insurance 65 10/18/2019 MUD Payroll 10/18/2019 Vision Insurance 16.16 22.74 16.16 38.90 PR PR Account: 135-50028-010-000 ' Vision Insurance Totals: 38.90 38.90 ** 767.00 Budgeted 728.10 Remaining 5 % Used Account: 135-50029-010-000 Life Insurance & Other 3 10/15/2019 Payroll Benefits October 3 10/15/2019 Payroll Benefits October 91.11 98.56 91.11 189.67 METLIFE GROUP BENEFITS Humana Inc 5796 5790 AP AP Account: 135-50029-010-000 Life Insurance & Other Totals: 189.67 189.67 ** 3,132.00 Budgeted 2,942.33 Remaining 6 % Used Account: 135-50030-010-000 Social Security Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Social Security Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Social Security Taxes 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 653.26 (653.26) 763.35 (70.07) 653.26 .00 763.35 693.28 PR GL PR GL Account: 135-50030-010-000 Social Security Taxes Totals: 693.28 693.28 ** 23,348.00 Budgeted 22,654.72 Remaining 3 % Used Account: 135-50035-010-000 Medicare Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Medicare Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 152.78 152.78 (152.78) .00 PR GL glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 10/2019 Page 12 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) 65 10/18/2019 MUD Payroll 10/18/2019 Medicare Taxes 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 178.53 (16.39) 178.53 162.14 PR GL Account: 135-50035-010-000 Medicare Taxes Totals: 162.14 162.14 ** 5,461.00 Budgeted 5,298.86 Remaining 3 % Used Account: 135-50040-010-000 Unemployment Taxes 65 10/18/2019 MUD Payroll 10/18/2019 Unemployment Taxes .80 .80 PR Account: 135-50040-010-000 Unemployment Taxes Totals: .80 .80 ** 1,080.00 Budgeted 1,079.20 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 66 10/01/2019 Insurance/Wrk Comp Expense Oct 771.49 771.49 GL Account: 135-50045-010-000 Workman's Compensation Totals: 771.49 771.49 ** 11,850.00 Budgeted 11,078.51 Remaining 7 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations .00 .00 Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs glpdatb2 skrolczyk Trophy Club MUD No.1 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 13 91 10/17/2019 October A/P 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 141 10/29/2019 October A/P 141 10/29/2019 October A/P parts infared interface adapter toilet seat adapters, coupling, elbow, tee relays parts 1,132.30 189.00 29.98 45.04 759.51 771.00 1,132.30 Core & Main LP 1,321.30 ACTISYS CORPORATION 1,351.28 THE HOME DEPOT #6581 1,396.32 THE HOME DEPOT #6581 2,155.83 NORTH TEXAS PUMP CO. 2,926.83 Core & Main LP 5834 AP PC PC PC 5864 AP 5852 AP Account: 135-55080-010-000 Maintenance & Repairs Totals: 2,926.83 2,926.83 ** 100,000.00 Budgeted 97,073.17 Remaining 3 % Used 4 % Used Account: 135-55085-010-000 Generator Maint. and Repair Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 .00 ** 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 3,000.00 Budgeted 3,000.00 Remaining 0 % Used .00 ** Account: 135-55090-010-000 Vehicle Maintenance 3,500.00 Budgeted 3,500.00 Remaining 0 % Used 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 Vehicle Registration Vehicle Registration Fee 22IN Trico Force Blades Terra Cair def oil change inspection 8.25 8.25 DENTON VEHREG 2.00 10.25 TX.GOV*SERVICEFEE-DIR 107.96 118.21 ROANOKE AUTO SUPPLY LT 20.00 138.21 ROANOKE AUTO SUPPLY LT 44.17 182.38 KWIK KAR LUBE & TUNE 0 25.50 207.88 KWIK KAR LUBE & TUNE 0 PC PC PC PC PC PC Account: 135-55090-010-000 _ Vehicle Maintenance Totals: 207.88 207.88 ** 5,000.00 Budgeted 4,792.12 Remaining 4 % 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 224 10/31/2019 October A/P janitorial svc-October 87.50 87.50 MEMBER'S BUILDING MAINTENANCE 5895 AP Account: 135-55120-010-000 Cleaning Services Totals: 87.50 87.50 ** 1,000.00 Budgeted 912.50 Remaining 9 8 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-000 Lab Analysis Account: 135-55135-010-000 Lab Analysis Totals: 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60010-010-000 _ Communications/Mobiles 48 10/11/2019 October A/P cell phones-Ocotber 173 10/28/2019 PCards 10/1/19-10/28/19 Tablet case Account: 135-60010-010-000 .00 .00 .00 .00 ** 338.17 338.17 VERIZON WIRELESS 5822 AP 25.99 364.16 AMZN MKTP US*R06FB8QX3 _ Communications/Mobile Totals: NE 364.16 364.16 ** 5,000.00 Budgeted 4,635.84 Remaining 7 % Used PC Account: 135-60020-010-000 Electricity 91 10/17/2019 October A/P Electricity- 9/10-10/10 14,721.00 Account: 135-60020-010-000 Electricity 125,677.00 Budgeted 14,721.00 HUDSON ENERGY SERVICES, LLC 5837 AP 14,721.00 14,721.00 ** 110,956.00 Remaining 12 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 173 10/28/2019 PCards 10/1/19-10/28/19 Clayton H. Water license train 295.00 295.00 NCTCOG RTC TRAINING PC Account: 135-60080-010-000 Schools & Training Totals: 295.00 295.00 ** Account: 135-60090-010-000 7,426.00 Budgeted Safety Program 7,131.00 Remaining 4 % Used glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-60090-010-000 Account: 135-60100-010-000 Account: 135-60100-010-000 Account: 135-60105-010-000 Account: 135-60105-010-000 Account: 135-60135-010-000 Account: 135-60135-010-000 Account: 135-60150-010-000 Account: 135-60150-010-000 Account: 135-60245-010-000 Account: 135-60245-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 10/2019 JE Detail Description/Comment Page 15 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) .00 .00 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Travel & per diem .00 .00 Travel & per diem Totals: .00 .00 ** 2,845.00 Budgeted 2,845.00 Remaining 0 6 Used Rent/Lease Equipment .00 .00 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 6 Used TCEQ Fees & Permits .00 .00 TCEQ Fees & Permits Totals: .00 .00 ** 63,000.00 Budgeted 63,000.00 Remaining 0 % Used Wholesale Water .00 .00 Wholesale Water Totals: .00 .00 ** 2,714,710.00 Budgeted 2,714,710.00 Remaining 0 6 Used Miscellaneous Expenses .00 .00 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted Account: 135-60280-010-000 Property Maintenance 173 10/28/2019 PCards 10/1/19-10/28/19 cushion sand 200.00 Remaining 0 % Used 126.00 126.00 DENTON SAND & GRAVEL, PC glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 173 10/28/2019 PCards 10/1/19-10/28/19 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment top soil Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 336.00 462.00 DENTON SAND & GRAVEL, Page 16 Check Source Number PC Account: 135-60280-010-000 Property Maintenance Totals: 462.00 462.00 ** 3,000.00 Budgeted 2,538.00 Remaining 15 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 14,750.00 Budgeted 14,750.00 Remaining 0 % Used Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S 158 10/31/2019 TexPool Transfers October TexPool O&M to 16Swift Rev I&S 158 10/31/2019 TexPool Transfers October TexPool O&M to 19 W&WW Rev I&S 25,047.72 22,896.02 25,047.72 47,943.74 GL GL Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 47,943.74 47,943.74 ** 527,381.00 Budgeted 479,437.26 Remaining 9 % Used Account: 135-60333-010-000 Interfund Transfer Out -Reserve 158 10/31/2019 TexPool Transfers October TexPool O&M to Rev Bond Resevr 4,600.00 4,600.00 GL Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 4,600.00 4,600.00 ** 55,193.00 Budgeted 50,593.00 Remaining 8 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 180,000.00 Budgeted 180,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 139 10/24/2019 Fuel- October Account: 135-65005-010-000 Account: 135-65010-010-000 173 10/28/2019 PCards 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 Account: 135-65010-010-000 PCards PCards PCards PCards PCards Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Fuel -October Fuel & Lube 15,000.00 Budgeted Uniforms 10/1/19-10/28/19 jacket tax 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 Account: 135-65030-010-000 141 10/29/2019 October A/P 224 10/31/2019 October A/P Account: 135-65030-010-000 Account: 135-65035-010-000 Account: 135-65035-010-000 Account: 135-65040-010-000 Account: 135-65040-010-000 Account: 135-65050-010-000 91 10/17/2019 October A/P 224 10/31/2019 October A/P jacket Matt C. Shoes Michael H. SHoes Clayton H. Shoes Jason R. Shoes Uniforms 5,190.00 Budgeted Chemicals chlorine testing supplies Chemicals 20,000.00 Budgeted Small Tools Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,000.00 Budgeted Meter Expense meters meters Totals: 14,226.52 Remaining Totals: 4,370.01 Remaining Totals: 18,310.76 Remaining Totals: 1,200.00 Remaining Totals: 1,000.00 Remaining Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 17 Check Source Number 773.48 773.48 US Bank Voyager Fleet Systems 5873 AP 5 % Used 16 % Used 8 % Used 0 % Used 0 % Used 773.48 (9.90) 129.89 175.00 175.00 175.00 175.00 819.99 781.77 907.47 1,689.24 .00 .00 .00 773.48 ** (9.90) CARHARTT 119.99 CARHARTT 294.99 RED WING 469.99 RED WING 644.99 RED WING 819.99 RED WING 819.99 ** SHOES #573 SHOES #573 SHOES #573 SHOES #573 781.77 DPC INDUSTRIES, INC 1,689.24 HACH COMPANY 1,689.24 ** .00 .00 ** .00 .00 ** PC PC PC PC PC PC 5854 AP 5890 AP 1,825.28 1,825.28 ATLAS UTILITY SUPPLY CO. 5833 AP 7,050.00 8,875.28 ATLAS UTILITY SUPPLY CO. 5882 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65050-010-000 Meter Expense Totals: 70,000.00 Budgeted Account: 135-65053-010-000 Meter Change Out Program Account: 135-65053-010-000 Account: 135-69005-010-000 143 10/29/2019 October A/P 224 10/31/2019 October A/P 224 10/31/2019 October A/P 229 10/31/2019 October A?P 61,124.72 Remaining 13 % Used Meter Change Out Program Totals: 87,000.00 Budgeted 87,000.00 Remaining Capital Outlays VFD upgrade Beacon software Beacon software Straight Creek/Carnoustie O % Used 8,875.28 .00 8,875.28 ** .00 .00 .00 ** 10,092.60 3,800.00 3,500.00 1,259.00 10,092.60 REY-MAR CONSTRUCTION 13,892.60 ATLAS UTILITY SUPPLY CO. 17,392.60 ATLAS UTILITY SUPPLY CO. 18,651.60 Halff Associates, INC 5867 AP 5882 AP 5882 AP 5889 AP Account: 135-69005-010-000 Capital Outlays Totals: 18,651.60 18,651.60 ** 684,875.00 Budgeted 666,223.40 Remaining 3 5 Used Account: 135-69008-010-000 Short Term Debt -Principal .00 .00 Account: 135-69008-010-000 Short Term Debt -Principal Totals: .00 .00 ** 30,512.00 Budgeted 30,512.00 Remaining Account: 135-69009-010-000 Short Term Debt -Interest Account: 135-69009-010-000 Short Term Debt -Interest Totals: 3,231.00 Budgeted 3,231.00 Remaining O % Used .00 .00 O % Used .00 Account: 135-69195-010-000 Gasb34/Reserve for Replacement 151 10/01/2019 GASB 34 Transfers FY 2020 Town Elevated Tank 45,000.00 45,000.00 GL 151 10/01/2019 GASB 34 Transfers FY 2020 Water Replacement 30,000.00 75,000.00 GL Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 75,000.00 75,000.00 ** 100 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69281-010-000 Water Tank Inspection Contract .00 .00 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 .00 ** 120,000.00 Budgeted 120,000.00 Remaining 0 % Used glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 20 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/2019 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 .00 .00 Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 10 Totals: 196,873.68 ** 196,873.68 Monthly Total 5,506,929.00 Budgeted 5,310,055.32 Remaining 4 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2019 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 5 10/04/2019 MUD Payroll 10/04/2019 Salaries 6 Wages 14,490.58 14,490.58 PR 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 (14,490.58) .00 GL 65 10/18/2019 MUD Payroll 10/18/2019 Salaries & Wages 14,509.18 14,509.18 PR 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 (1,552.42) 12,956.76 GL Account: 135-50005-020-000 Salaries 6 Wages Totals: 12,956.76 12,956.76 ** 441,799.00 Budgeted Account: 135-50010-020-000 Overtime 5 10/04/2019 MUD Payroll 10/04/2019 Overtime 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Overtime Account: 135-50010-020-000 Account: 135-50016-020-000 Account: 135-50016-020-000 428,842.24 Remaining 3 % Used 590.87 590.87 PR (590.87) .00 GL 649.08 649.08 PR Overtime Totals: 649.08 649.08 ** 33,000.00 Budgeted 32,350.92 Remaining 2 % Used Longevity Longevity Totals: 8,035.00 Budgeted Account: 135-50017-020-000 Certification 65 10/18/2019 MUD Payroll 10/18/2019 Certification Account: 135-50017-020-000 8,035.00 Remaining 0 % Used Certification Totals: 9,000.00 Budgeted Account: 135-50020-020-000 Retirement 5 10/04/2019 MUD Payroll 10/04/2019 Retirement 65 10/18/2019 MUD Payroll 10/18/2019 Retirement 8,375.00 Remaining 7 % Used .00 .00 .00 .00 ** 625.00 625.00 PR 625.00 625.00 ** 1,395.03 1,395.03 1,459.95 2,854.98 PR PR Account: 135-50020-020-000 Retirement Totals: 2,854.98 2,854.98 ** 45,531.00 Budgeted Account: 135-50026-020-000 Medical Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Medical Insurance 42,676.02 Remaining 6 % Used 2,993.58 2,993.58 PR glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 65 10/18/2019 MUD Payroll 10/18/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Medical Insurance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 2,993.55 5,987.13 Page 22 Check Source Number PR 5 10/04/2019 MUD Payroll 10/04/2019 Social Security Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Social Security Taxes 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 889.61 (889.61) 892.07 (88.11) 889.61 .00 892.07 803.96 PR GL PR GL Account: 135-50030-020-000 Social Security Taxes Totals: 803.96 803.96 ** 30,494.00 Budgeted 29,690.04 Remaining 3 % Used Account: 135-50035-020-000 Medicare Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Medicare Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 208.06 208.06 (208.06) .00 PR GL Account: 135-50026-020-000 Medical Insurance Totals: 5,987.13 5,987.13 ** 104,858.00 Budgeted 98,870.87 Remaining 6 % Used Account: 135-50027-020-000 Dental Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Dental Insurance 65 10/18/2019 MUD Payroll 10/18/2019 Dental Insurance 179.09 179.06 179.09 358.15 PR PR Account: 135-50027-020-000 Dental Insurance Totals: 358.15 358.15 ** 5,817.00 Budgeted 5,458.85 Remaining 6 % Used Account: 135-50028-020-000 11111 Vision Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Vision Insurance 65 10/18/2019 MUD Payroll 10/18/2019 Vision Insurance 29.62 29.60 29.62 59.22 PR PR Account: 135-50028-020-000 ' Vision Insurance Totals: 59.22 59.22 ** 948.00 Budgeted 888.78 Remaining 6 % Used Account: 135-50029-020-000 Life Insurance & Other 3 10/15/2019 Payroll Benefits October 3 10/15/2019 Payroll Benefits October 162.14 175.00 162.14 337.14 METLIFE GROUP BENEFITS Humana Inc 5796 5790 AP AP Account: 135-50029-020-000 Life Insurance & Other Totals: 337.14 337.14 ** 4,500.00 Budgeted 4,162.86 Remaining 7 % Used Account: 135-50030-020-000 Social Security Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Social Security Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Social Security Taxes 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 889.61 (889.61) 892.07 (88.11) 889.61 .00 892.07 803.96 PR GL PR GL Account: 135-50030-020-000 Social Security Taxes Totals: 803.96 803.96 ** 30,494.00 Budgeted 29,690.04 Remaining 3 % Used Account: 135-50035-020-000 Medicare Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Medicare Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 208.06 208.06 (208.06) .00 PR GL glpdatb2 skrolczyk 17:07 11/07/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 Program: Period Ending: 10/2019 Page 23 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) 65 10/18/2019 MUD Payroll 10/18/2019 Medicare Taxes 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 208.63 (20.62) 208.63 188.01 PR GL Account: 135-50035-020-000 Medicare Taxes Totals: 188.01 188.01 ** 7,132.00 Budgeted 6,943.99 Remaining 3 % 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 % Used Account: 135-50045-020-000 Workman's Compensation 66 10/01/2019 Insurance/Wrk Comp Expense Oct 1,110.20 1,110.20 GL Account: 135-50045-020-000 Workman's Compensation Totals: 1,110.20 1,110.20 ** 15,373.00 Budgeted 14,262.80 Remaining 7 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .00 .00 Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Account: 135-55070-020-000 Independent Labor 15,000.00 Budgeted Account: 135-55080-020-000 48 10/11/2019 October A/P 140 10/11/2019 Reverse Exp Oct A/P- Sept Exp 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 141 10/29/2019 October A/P 141 10/29/2019 October A/P 143 10/29/2019 October A/P 224 10/31/2019 October A/P Maintenance & Repairs air solenoid valve replacement Reversing JE 48- Moving to Sep Insulation, winterizing Barrel Pump Sponge, Valve, tape, batteries quick connect cable LS VFD for RAS pump Longo bags Filters/Filter wraps Account: 135-55080-020-000 Totals: 15,000.00 Remaining Maintenance & Repairs Totals: 88,000.00 Budgeted 84,295.46 Remaining Account: 135-55081-020-000 Mainten & Repairs Collections 173 10/28/2019 PCards 10/1/19-10/28/19 APC BK350 350VA UPS System 141 10/29/2019 October A/P Avenue Twenty LS 141 10/29/2019 October A/P 143 10/29/2019 October A/P 224 10/31/2019 October A/P Account: 135-55081-020-000 Account: 135-55085-020-000 Account: 135-55085-020-000 • parts for LS 20 Ball valves soc LS #20 LS #20 Mainten & Repairs Collections Totals: 10,000.00 Budgeted 2,074.75 Remaining Generator Maint. and Repair Generator Maint. and Repair Totals: 10,000.00 Budgeted 10,000.00 Remaining Account: 135-55090-020-000 ■ Vehicle Maintenance 173 10/28/2019 PCards 10/1/19-10/28/19 belt dressing, dsl f additive 173 10/28/2019 PCards 10/1/19-10/28/19 Terra Cair Def Program: Transaction Detail .00 0 % Used .00 Transaction Vendor_Name Detail (SUBTOTAL) .00 .00 ** 490.00 490.00 (490.00) .00 47.84 47.84 39.99 87.83 100.13 187.96 1,773.46 1,961.42 668.00 2,629.42 744.00 3,373.42 331.12 3,704.54 4 % Used 79 % Used 0 % Used 3,704.54 85.69 6,676.20 567.40 179.90 416.06 7,925.25 .00 .00 DHS AUTOMATION, INC THE HOME DEPOT #6581 O'REILLY AUTO PARTS 55 THE HOME DEPOT 6581 DHS AUTOMATION, INC SES Group, LLC Huber Technology Inc Filter Element Store 3,704.54 ** 85.69 6,761.89 7,329.29 7,509.19 7,925.25 AMAZON.COM*KP6QZ6K03 REY-MAR CONSTRUCTION SMITH PUMP COMPANY, INC. HD SUPPLY FACILITIES MAINT LTD SMITH PUMP COMPANY, INC. 7,925.25 ** .00 .00 ** 27.02 27.02 ROANOKE AUTO SUPPLY LT 20.00 47.02 ROANOKE AUTO SUPPLY LT Page 24 Check Source Number 5815 AP GL PC PC PC 5853 AP 5869 AP 5858 AP 5887 AP PC 5867 AP 5870 AP 5857 AP 5900 AP PC PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090-020-000 Vehicle Maintenance Totals: 47.02 47.02 ** 4,000.00 Budgeted 3,952.98 Remaining 1 % Used Account: 135-55091-020-000 Veh Maintenance Collections Account: 135-55091-020-000 Veh Maintenance Collections Totals: 8,000.00 Budgeted 8,000.00 Remaining Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 171 10/30/2019 Credit Expense A/P Refund .00 .00 .00 .00 ** 0 % Used (856.24) (856.24) GL Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: (856.24) (856.24) ** 3,000.00 Budgeted 3,856.24 Remaining Account: 135-55120-020-000 Cleaning Services 224 10/31/2019 October A/P janitorial svc-October Account: 135-55120-020-000 -29 o Used 87.50 87.50 MEMBER'S BUILDING MAINTENANCE 5895 AP Cleaning Services Totals: 87.50 87.50 ** 1,500.00 Budgeted 1,412.50 Remaining 6 % Used Account: 135-55125-020-000 Dumpster Services 91 10/17/2019 October A/P sludge haul off 1,240.00 1,240.00 L.H. CHANEY MATERIALS, INC. 5839 AP 141 10/29/2019 October A/P sludge/grit 1,086.24 2,326.24 L.H. CHANEY MATERIALS, INC. 5860 AP 141 10/29/2019 October A/P SLudge/grit 1,240.00 3,566.24 L.H. CHANEY MATERIALS, INC. 5860 AP 224 10/31/2019 October A/P Sludge haul off 1,240.00 4,806.24 L.H. CHANEY MATERIALS, INC. 5894 AP Account: 135-55125-020-000 Account: 135-55135-020-000 48 10/11/2019 October A/P 48 10/11/2019 October A/P 91 10/17/2019 October A/P 141 10/29/2019 October A/P 141 10/29/2019 October A/P 224 10/31/2019 October A/P Dumpster Services 100,000.00 Budgeted Lab Analysis Lab testing lab testing algae sample lab testing lab testing Lab testing Totals: 95,193.76 Remaining 5 % Used 4,806.24 4,806.24 ** 317.40 317.40 OXIDOR LABORATORIES LLC 230.00 547.40 OXIDOR LABORATORIES LLC 200.00 747.40 SonicSolutions Algae Control 317.40 1,064.80 OXIDOR LABORATORIES LLC 230.00 1,294.80 OXIDOR LABORATORIES LLC 317.40 1,612.20 OXIDOR LABORATORIES LLC 5819 AP 5819 AP 5843 AP 5866 AP 5866 AP 5898 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 224 10/31/2019 October A/P 224 10/31/2019 October A/P 224 10/31/2019 October A/P lab testing lab testing lab testing 230.00 1,842.20 OXIDOR LABORATORIES LLC 317.40 2,159.60 OXIDOR LABORATORIES LLC 230.00 2,389.60 OXIDOR LABORATORIES LLC 5898 AP 5898 AP 5898 AP Account: 135-55135-020-000 Lab Analysis Totals: 2,389.60 2,389.60 ** 40,000.00 Budgeted 37,610.40 Remaining 6 % Used Account: 135-60010-020-000 Communications/Mobiles 48 10/11/2019 October A/P cell phones-Ocotber 372.84 372.84 VERIZON WIRELESS 5822 AP Account: 135-60010-020-000 Communications/Mobiles Totals: a � 4,627.16 Remaining 7 % Used 5,000.00 Budgeted Account: 135-60020-020-000 Electricity 91 10/17/2019 October A/P Electricity- 9/10-10/10 219 10/31/2019 Town Billed Invoices 1710-1713 AR 20191031-20191031 User: Account: 135-60020-020-000 11,935.31 11,935.31 HUDSON ENERGY SERVICES, LLC 5837 AP (174.02) 11,761.29 AR Electricity 11,761.29 11,761.29 ** 160,067.00 Budgeted 148,305.71 Remaining 7 % Used Account: 135-60066-020-000 1 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 6 Used Account: 135-60070-020-000 Dues & Memberships .00 .00 Account: 135-60070-020-000 1 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training 173 10/28/2019 PCards 10/1/19-10/28/19 Water Utilites Safety DeWayne 420.00 420.00 TEEX ECOMMERCE PC 173 10/28/2019 PCards 10/1/19-10/28/19 Water Utilities Safety Jeff 420.00 840.00 TEEX ECOMMERCE PC Account: 135-60080-020-000 Schools & Training Totals: 840.00 840.00 ** 4,990.00 Budgeted 4,150.00 Remaining 17 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60090-020-000 Safety Program Account: 135-60090-020-000 Account: 135-60100-020-000 Account: 135-60100-020-000 Account: 135-60105-020-000 Account: 135-60105-020-000 Account: 135-60125-020-000 Account: 135-60125-020-000 Account: 135-60135-020-000 141 10/29/2019 October A/P Safety Program Totals: 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Travel & per diem Travel & per diem Totals: 1,545.00 Budgeted Rent/Lease Equipment Rent/Lease Equipment Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Advertising Advertising Totals: 2,500.00 Budgeted 2,500.00 Remaining 0 % Used TCEQ Fees & Permits Permit WWTP 1,545.00 Remaining 0 % Used .00 .00 .00 .00 ** .00 .00 .00 .00 ** 1 00 .00 Account: 135-60135-020-000 Account: 135-60245-020-000 Account: 135-60245-020-000 1 .00 .00 .00 .00 9,888.02 9,888.02 TX COMMISSION ENVIRONMENTAL QU 5871 AP TCEQ Fees & Permits Totals: 9,888.02 9,888.02 ** ' 15,000.00 Budgeted 5,111.98 Remaining 66 % Used Miscellaneous Expenses Miscellaneous Expenses Totals: 450.00 Budgeted Account: 135-60280-020-000 Property Maintenance 450.00 Remaining 0 % Used .00 .00 1 .00 411.111.4 1 glpdatb2 skrolczyk 17:07 11/07/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: 10/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Page 28 Check Source Number Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 14,000.00 Budgeted 14,000.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 158 10/31/2019 TexPool Transfers October TexPool O&M to I&S- PID Debt 10,414.81 10,414.81 GL Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 10,414.81 10,414.81 ** 114,563.00 Budgeted 104,148.19 Remaining 9 % Used Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 158 10/31/2019 TexPool Transfers October TexPool O&M to Rev Bd WWTP I&S 158 10/31/2019 TexPool Transfers October TexPool O&M to 19 W&WW Rev I&S 54,421.63 6,839.07 54,421.63 61,260.70 GL GL Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 61,260.70 61,260.70 ** 673,867.00 Budgeted 612,606.30 Remaining 9 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 158 10/31/2019 TexPool Transfers October TexPool O&M to Rev Bond Resevr 5,750.00 5,750.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 5,750.00 5,750.00 ** 125,187.00 Budgeted 119,437.00 Remaining 5 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 180,000.00 Budgeted 180,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-60360-020-000 Account: 135-65005-020-000 139 10/24/2019 Fuel- October Account: 135-65005-020-000 1 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Furniture/Equipment < $5000 Totals: 2,000.00 Budgeted 2,000.00 Remaining Fuel & Lube Fuel -October Fuel & Lube 12,500.00 Budgeted Account: 135-65010-020-000 - Uniforms 173 10/28/2019 PCards 10/1/19-10/28/19 Jeff R. Shoes 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 143 10/29/2019 October A/P Account: 135-65010-020-000 Account: 135-65030-020-000 91 10/17/2019 October A/P Account: 135-65030-020-000 Account: 135-65031-020-000 Account: 135-65031-020-000 Account: 135-65035-020-000 Account: 135-65035-020-000 1 Orlando V. Shoes Frank W. Shoes Lance H. Shoes uniform/boots forms 5,495.00 Budgeted Chemicals defoamer/Bacteria Chemicals 20,000.00 Budgeted Chemicals Collections Chemicals Collections 17,500.00 Budgeted Small Tools Small Tools 1,200.00 Budgeted Totals: 11,576.39 Remaining Totals: 4,602.59 Remaining Totals: 17,174.04 Remaining Totals: 17,500.00 Remaining Program: Transaction Detail .00 0 % Used .00 Transaction Vendor_Name Detail (SUBTOTAL) .00 .00 ** Page 29 Check Source Number 923.61 923.61 US Bank Voyager Fleet Systems 5873 AP 7 8 Used 16 % Used 14 8 Used 0 8 Used 923.61 175.00 175.00 175.00 175.00 192.41 892.41 923.61 ** 175.00 350.00 525.00 700.00 892.41 RED WING SHOES #573 RED WING SHOES #573 RED WING SHOES #573 RED WING SHOES #573 Ritz Safety, LLC 892.41 ** PC PC PC PC 5868 AP 2,825.96 2,825.96 MARYLAND BIOCHEMICAL CO, INC 5841 AP 2,825.96 .00 .00 .00 Totals: 1,200.00 Remaining 0 o Used .00 2,825.96 ** .00 .00 ** .00 .00 ** glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 30 Check Source Number Account: 135-65040-020-000 Safety Equipment Account: 135-65040-020-000 Safety Equipment 1,200.00 Budgeted Account: 135-65045-020-000 18 10/04/2019 October A/P 18 10/04/2019 October A/P 173 10/28/2019 PCards 10/1/19-10/28/19 141 10/29/2019 October A/P 143 10/29/2019 October A/P 143 10/29/2019 October A/P 143 10/29/2019 October A/P 224 10/31/2019 October A/P Account: 135-65045-020-000 Account: 135-69005-020-000 141 10/29/2019 October A/P Account: 135-69005-020-000 Lab Supplies lab supplies lab supplies Nesslers Reagent lab gloves lab supllies lab supplies lab supplies biomonitoring Lab Supplies 20,000.00 Budgeted Capital Outlays LS upgrades FY 19 Capital Outlays 530,500.00 Budgeted Totals: 1,200.00 Remaining Totals: 17,016.99 Remaining Totals: 524,711.00 Remaining O % Used .00 .00 213.52 960.96 118.60 169.20 64.95 257.28 118.50 1,080.00 15 % Used 1 % Used Account: 135-69008-020-000 Short Term Debt -Principal Account: 135-69008-020-000 Short Term Debt -Principal Totals: 79,133.00 Budgeted 79,133.00 Remaining O % Used Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 Account: 135-69195-020-000 Short Term Debt -Interest Totals: 11,277.00 Budgeted 11,277.00 Remaining Gasb34/Reserve for Replacement O % Used 2,983.01 5,789.00 5,789.00 .00 .00 .00 .00 .00 .00 .00 .00 ** • 213.52 1,174.48 1,293.08 1,462.28 1,527.23 1,784.51 1,903.01 2,983.01 IDEXX DISTRIBUTION, INC IDEXX DISTRIBUTION, INC THE LAB DEPOT LOU'S GLOVES INCORPORATED HD SUPPLY FACILITIES MAINT HACH COMPANY HACH COMPANY HUTHER AND ASSOCIATES,INC 2,983.01 ** 5,789.00 DHS AUTOMATION, INC 5,789.00 ** .00 ** .00 ** 5791 AP 5791 AP PC 5861 AP LTD 5857 AP 5856 AP 5856 AP 5892 AP 5853 AP glpdatb2 skrolczyk 17:07 11/07/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 Program: Period Ending: 10/2019 Page 31 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) 151 10/01/2019 GASB 34 Transfers FY 2020 Sewer Replacement 151 10/01/2019 GASB 34 Transfers FY 2020 WWTP MBR Replacement 30,000.00 100,000.00 30,000.00 130,000.00 GL GL Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: 130,000.00 130,000.00 ** 130,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: 287,735.19 Monthly Total 287,735.19 ** 3,157,421.00 Budgeted 2,869,685.81 Remaining 9 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2019 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 66 10/01/2019 Insurance/Wrk Comp Expense Oct Account: 135-50045-026-000 Workman's Compensation Totals: Account: 135-60066-026-000 Account: 135-60066-026-000 30.00 Budgeted Publications/Books/Subscripts Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 28.01 Remaining 7 % Used 1.99 1.99 GL 1.99 1.99 ** .00 0 % Used .00 .00 .00 ** Account: 135-60070-026-000 Dues & Memberships Dues & Memberships 750.00 Budgeted Account: 135-60070-026-000 .00 Totals: 750.00 Remaining 0 % Used .00 .00 .00 ** Account: 135-60075-026-000 Meetings Account: 135-60075-026-000 Meetings 1,300.00 Budgeted Totals: 1,300.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-60080-026-000 Schools & Training Account: 135-60080-026-000 Schools & Training 4,000.00 Budgeted Totals: 4,000.00 Remaining 0 6 Used .00 .00 .00 .00 ** Account: 135-60100-026-000 Travel & per diem .00 .00 Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted Account: 135-60245-026-000 Miscellaneous Expenses 5,000.00 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2019 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 ** Department 26 Totals: 2,000.00 Budgeted 1.99 Monthly Total 2,000.00 Remaining 0 % Used 13,230.00 Budgeted 13,228.01 Remaining 1.99 ** 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 34 Account: 135-50005-030-000 Salaries & Wages 5 10/04/2019 MUD Payroll 10/04/2019 Salaries 9 Wages 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Salaries & Wages 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 14,798.28 (14,798.28) 15,046.49 (1,480.64) 14,798.28 .00 15,046.49 13,565.85 PR GL PR GL Account: 135-50005-030-000 Salaries & Wages Totals: 13,565.85 13,565.85 ** 628,298.00 Budgeted 614,732.15 Remaining 2 % Used Account: 135-50010-030-000 Overtime .00 .00 Account: 135-50010-030-000 Overtime Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-50016-030-000 Longevity .00 .00 Account: 135-50016-030-000 Longevity Totals: .00 .00 ** 2,208.00 Budgeted 2,208.00 Remaining 0 % Used Account: 135-50020-030-000 Retirement 5 10/04/2019 MUD Payroll 65 10/18/2019 MUD Payroll 10/04/2019 Retirement 10/18/2019 Retirement 1,368.84 1,391.80 1,368.84 2,760.64 PR PR Account: 135-50020-030-000 Retirement Totals: 2,760.64 2,760.64 ** 58,554.00 Budgeted 55,793.36 Remaining 5 % Used Account: 135-50026-030-000 Medical Insurance 5 10/04/2019 MUD Payroll 65 10/18/2019 MUD Payroll 10/04/2019 Medical Insurance 10/18/2019 Medical Insurance 2,744.43 2,744.38 2,744.43 5,488.81 PR PR Account: 135-50026-030-000 Medical Insurance Totals: 5,488.81 5,488.81 ** 124,394.00 Budgeted 118,905.19 Remaining 4 % Used Account: 135-50027-030-000 Dental Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Dental Insurance 153.21 153.21 PR 65 10/18/2019 MUD Payroll 10/18/2019 Dental Insurance 153.19 306.40 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-030-000 Dental Insurance Totals: 306.40 306.40 ** 6,464.00 Budgeted Account: 135-50028-030-000 Vision Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Vision Insurance 65 10/18/2019 MUD Payroll 10/18/2019 Vision Insurance 6,157.60 Remaining 5 % Used 24.40 24.40 PR 24.37 48.77 PR Account: 135-50028-030-000 Vision Insurance Totals: 48.77 48.77 ** 1,035.00 Budgeted Account: 135-50029-030-000 Life Insurance & Other 3 10/15/2019 Payroll Benefits October 3 10/15/2019 Payroll Benefits October 986.23 Remaining 5 % Used 142.90 142.90 METLIFE GROUP BENEFITS 5796 AP 149.52 292.42 Humana Inc 5790 AP Account: 135-50029-030-000 Life Insurance & Other Totals: 292.42 292.42 ** 4,500.00 Budgeted 4,207.58 Remaining 6 8 Used Account: 135-50030-030-000 Social Security Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Social Security Taxes 855.11 855.11 PR 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 (855.11) .00 GL 65 10/18/2019 MUD Payroll 10/18/2019 Social Security Taxes 867.35 867.35 PR 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 (85.35) 782.00 GL Account: 135-50030-030-000 Social Security Taxes Totals: 782.00 782.00 ** 39,215.00 Budgeted 38,433.00 Remaining 2 % Used Account: 135-50035-030-000 Medicare Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Medicare Taxes 199.97 199.97 PR 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 (199.97) .00 GL 65 10/18/2019 MUD Payroll 10/18/2019 Medicare Taxes 202.86 202.86 PR 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 (19.95) 182.91 GL Account: 135-50035-030-000 Medicare Taxes Totals: 182.91 182.91 ** 9,171.00 Budgeted 8,988.09 Remaining 2 % Used Account: 135-50040-030-000 Unemployment Taxes .00 .00 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-50040-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Unemployment Taxes Totals: 1,440.00 Budgeted 1,440.00 Remaining Account: 135-50045-030-000 Workman's Compensation 66 10/01/2019 Insurance/Wrk Comp Expense Oct Account: 135-50045-030-000 Account: 135-50060-030-000 Account: 135-50060-030-000 Workman's Compensation Totals: 1,775.00 Budgeted 1,670.18 Remaining Pre-emp Physicals/Testing Pre-emp Physicals/Testing Totals: 500.00 Budgeted 500.00 Remaining Account: 135-50070-030-000 Employee Relations 173 10/28/2019 PCards 10/1/19-10/28/19 End of year Celebration Lunch Account: 135-50070-030-000 Employee Relations Totals: 8,000.00 Budgeted 7,821.15 Remaining Account: 135-55030-030-000 2 10/01/2019 October A/P 18 10/04/2019 October A/P 18 10/04/2019 October A/P 48 10/11/2019 October A/P 48 10/11/2019 October A/P 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 141 10/29/2019 October A/P Account: 135-55030-030-000 Account: 135-55070-030-000 Software & Support Microsoft exchange -October New SCADA Computer renewal -FY Code Red renewal -10/27/19-10/2 Annual M3 Service -FY 20 internet-October Internet bill internet bill internet Adobe Subscriptions Laserfiche renewal FY 20 Software & Support Totals: 134,681.00 Budgeted Independent Labor 69,155.15 Remaining Program: Transaction Detail 0 % Used 6 % Used 0 % Used 2 % Used 49 % Used .00 104.82 104.82 .00 .00 178.85 178.85 Transaction Vendor_Name Detail (SUBTOTAL) .00 ** 104.82 104.82 ** .00 .00 ** 178.85 CRISTINA'S MEXICAN 178.85 ** 510.00 510.00 495.00 1,005.00 3,670.00 4,675.00 54,600.00 59,275.00 899.00 60,174.00 42.37 60,216.37 42.37 60,258.74 53.91 60,312.65 32.45 60,345.10 5,180.75 65,525.85 65,525.85 65,525.85 M3 Networks WIN -911 SOFTWARE Onsolve Intermediate Holding M3 Networks Charter Communications ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE ACROPRO SUBS MCCI Page 36 Check Source Number GL PC 5795 AP 5799 AP 5797 AP 5817 AP 5814 AP PC PC PC PC 5863 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2019 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-55070-030-000 Independent Labor Totals: .00 .00 ** 135,000.00 Budgeted 135,000.00 Remaining 0 % Used Account: 135-55080-030-000 Maintenance & Repairs 141 10/29/2019 October A/P 141 10/29/2019 October A/P a/c in office A/C in office 160.00 160.00 BRANDON R REED 5851 AP 355.00 515.00 BRANDON R REED 5851 AP Account: 135-55080-030-000 Maintenance & Repairs Totals: 515.00 515.00 ** 15,000.00 Budgeted 14,485.00 Remaining 3 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 224 10/31/2019 October A/P janitorial svc-October 869.06 869.06 MEMBER'S BUILDING MAINTENANCE 5895 AP Account: 135-55120-030-000 Cleaning Services Totals: 869.06 869.06 ** 10,000.00 Budgeted 9,130.94 Remaining 9 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 65,600.00 Budgeted 65,600.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 224 10/31/2019 October A/P Billings -October 582.15 582.15 DATAPROSE LLC 5885 AP Account: 135-55205-030-000 Utility Billing Contract Totals: 582.15 582.15 ** 9,000.00 Budgeted 8,417.85 Remaining 6 % Used Account: 135-60005-030-000 Telephone glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE Date 18 10/04/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 219 10/31/2019 Account: 135-60005-030-000 JE Description October A/P PCards 10/1/19-10/28/19 PCards 10/1/19-10/28/19 PCards 10/1/19-10/28/19 PCards 10/1/19-10/28/19 Town Billed Invoices 1710-1713 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Answering service -October phone bill phone bill Phone Bill Answering Service AR 20191031-20191031 User: Telephone 23,680.00 Budgeted Account: 135-60010-030-000 48 10/11/2019 October A/P 65 10/18/2019 MUD Payroll 10/18/2019 Account: 135-60010-030-000 Account: 135-60020-030-000 Account: 135-60020-030-000 Totals: 22,200.20 Remaining Communications/Mobiles cell phones-Ocoober Communications/Mobiles Communications/Mobiles Totals: 4,000.00 Budgeted 3,761.98 Remaining Electricity/Gas Electricity/Gas 6,879.00 Budgeted Totals: 6,879.00 Remaining Account: 135-60025-030-000 Water 219 10/31/2019 Town Billed Invoices 1710-1713 AR 20191031-20191031 User: 224 10/31/2019 October A/P water -October Account: 135-60025-030-000 Account: 135-60035-030-000 141 10/29/2019 October A/P 224 10/31/2019 October A/P Account: 135-60035-030-000 Account: 135-60040-030-000 Water 1,500.00 Budgeted Postage Postage lease Billings -October Postage 30,000.00 Budgeted Service Charges & Fees Totals: 1,433.22 Remaining Totals: 28,273.39 Remaining 6 % Used 6 % Used 0 % Used 4 % Used 6 % Used Program: Transaction Detail 194.75 795.42 468.33 186.31 14.99 (180.00) 1,479.80 88.02 150.00 238.02 .00 .00 (66.77) Transaction Vendor_Name Detail (SUBTOTAL) 194.75 990.17 1,458.50 1,644.81 1,659.80 1,479.80 KEYSTONE PARK SECRETARIAL ATT*BUS PHONE PMT ATT*BUS PHONE PMT ATT*BILL PAYMENT RINGCENTRAL, INC 1,479.80 ** 88.02 VERIZON WIRELESS 238.02 238.02 ** .00 .00 ** (66.77) 133.55 66.78 TROPHY CLUB MUD (WATER BILLS) 66.78 66.78 ** 102.54 102.54 FRANCOTYP-POSTALIA, INC. 1,624.07 1,726.61 DATAPROSE LLC 1,726.61 1,726.61 ** Page 38 Check Source Number 5793 AP PC PC PC PC AR 5822 AP PR AR 5902 AP 5855 AP 5885 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 157 10/31/2019 Pace Credit Card Fees 157 10/31/2019 Pace Credit Card Fees 224 10/31/2019 October A/P Account: 135-60040-030-000 Direct send fees -October Service Charges & Fees Totals: 67,000.00 Budgeted 59,952.07 Remaining 11 % Used 6,812.40 6,812.40 GL 185.53 6,997.93 GL 50.00 7,047.93 Fisery Solutions, LLC 5888 AP 7,047.93 7,047.93 ** 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 66 10/01/2019 Insurance/Wrk Comp Expense Oct 6,998.39 6,998.39 GL Account: 135-60055-030-000 Insurance Totals: 6,998.39 6,998.39 ** 84,000.00 Budgeted 77,001.61 Remaining 8 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** Account: 135-60070-030-000 141 10/29/2019 October A/P 229 10/31/2019 October A?P 1,000.00 Budgeted 1,000.00 Remaining Dues & Memberships FY 2020 renewal 0 % Used 100.00 100.00 TX COMPTROLLER 5872 AP 100.00 200.00 NORTH CENTRAL TX COG 5897 AP Account: 135-60070-030-000 Dues & Memberships Totals: 200.00 200.00 ** 6,000.00 Budgeted 5,800.00 Remaining 3 % Used Account: 135-60075-030-000 Meetings .00 .00 Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Account: 135-60079-030-000 173 10/28/2019 PCards 173 10/28/2019 PCards 173 10/28/2019 PCards 173 10/28/2019 PCards 173 10/28/2019 PCards Account: 135-60079-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment _ Public Education 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 Dist info Form & Fee Annexations and Fee Real Property Recordings & fee Parking Fee for Ft Worth Court Notice Purchaser Public Education 6,000.00 Budgeted Totals: 5,650.25 Remaining Account: 135-60080-030-000 Schools & Training 173 10/28/2019 PCards 10/1/19-10/28/19 Election Training 173 10/28/2019 PCards 10/1/19-10/28/19 Training Webinars 173 10/28/2019 PCards 10/1/19-10/28/19 Public Funds Invest training Account: 135-60080-030-000 Schools & Training 6,850.00 Budgeted Account: 135-60100-030-000 Travel & per diem 65 10/18/2019 MUD Payroll 10/18/2019 Travel & per diem Account: 135-60100-030-000 Account: 135-60110-030-000 Account: 135-60110-030-000 Account: 135-60125-030-000 Account: 135-60125-030-000 Travel & per diem 3,545.00 Budgeted Physicals/Testing Physicals/Testing 200.00 Budgeted Advertising Advertising 2,500.00 Budgeted Totals: 6,072.29 Remaining Totals: 3,453.22 Remaining Totals: 200.00 Remaining Totals: 2,500.00 Remaining 6 % Used 11 % Used 3 % Used 0 % Used 0 % Used Program: Transaction Detail 140.00 124.00 48.50 1.25 36.00 349.75 Transaction Vendor_Name Detail (SUBTOTAL) 140.00 264.00 312.50 313.75 349.75 VCN*DENTONFLOWERMOUNDC VCN*DENTONFLOWERMOUNDC VCN*DENTONFLOWERMOUNDC CFW PARKING METER NCOURT *TXTARRANTCOSWP 5 ** 210.00 210.00 TEXAS SECRETARY OF STA 432.71 642.71 GOVERNMENT FINANCE OFF 135.00 777.71 NCTCOG RTC TRAINING 777.71 91.78 91.78 .00 .00 .00 .00 777.71 ** 91.78 91.78 ** .00 .00 ** .00 .00 ** Page 40 Check Source Number PC PC PC PC PC PC PC PC PR Account: 135-60235-030-000 Security 91 10/17/2019 October A/P monitoring svc-soct 24.00 24.00 Digital Air Control, Inc 5836 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60235-030-000 Security Totals: 1,288.00 Budgeted Account: 135-60245-030-000 Miscellaneous Expenses Account: 135-60245-030-000 1,264.00 Remaining 2 % Used Miscellaneous Expenses Totals: 500.00 Budgeted Account: 135-60246-030-000 General Manager Contingency Account: 135-60246-030-000 General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining 500.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Account: 135-65010-030-000 Uniforms Account: 135-65010-030-000 Uniforms Totals: 2,050.00 Budgeted Account: 135-65055-030-000 Hardware Account: 135-65055-030-000 Account: 135-65085-030-000 91 10/17/2019 October A/P 141 10/29/2019 October A/P 0 % Used 0 % Used 2,050.00 Remaining 0 % Used Hardware Totals: 26,485.00 Budgeted Office Supplies office supplies office supplies 26,485.00 Remaining 0 % Used 24.00 .00 24.00 ** .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 .00 .00 .00 .00 61.77 61.77 OFFICE DEPOT, INC 5842 AP 499.56 561.33 OFFICE DEPOT, INC 5865 AP glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 10/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 42 Check Source Number 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 PCards PCards PCards PCards PCards PCards PCards PCards PCards PCards 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 coffee badge holders coffee coffee coffee coffee water, truvia, soap, pt, wipes air freshner coffee coffee 15.99 8.99 47.59 25.08 50.99 25.45 190.74 25.22 27.45 10.50 15.99 24.98 72.57 97.65 148.64 174.09 364.83 390.05 417.50 428.00 AMZN MKTP US*IO26K2LT3 AMZN MKTP US*DW33R73N3 AMAZON.COM*XP8XK1FY3 AMAZON.COM*2W2GT6GB3 AMZN MKTP US*PU81F4MV3 AMAZON.COM*JJ1H16P13 SAMSCLUB.COM AMZN MKTP US*VR0566TW3 AMAZON.COM*CU9JJ85M3 AMZN MKTP US*G09UDORX3 PC PC PC PC PC PC PC PC PC PC Account: 135-65095-030-000 Maintenance Supplies Totals: 428.00 428.00 Account: 135-65085-030-000 Office Supplies Totals: 561.33 561.33 ** 6,000.00 Budgeted 5,438.67 Remaining 9 % Used ' Printing Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 .00 .00 Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: Account: 135-65095-030-000 Maintenance Supplies 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 PCards PCards PCards PCards PCards PCards PCards PCards PCards PCards 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 coffee badge holders coffee coffee coffee coffee water, truvia, soap, pt, wipes air freshner coffee coffee 15.99 8.99 47.59 25.08 50.99 25.45 190.74 25.22 27.45 10.50 15.99 24.98 72.57 97.65 148.64 174.09 364.83 390.05 417.50 428.00 AMZN MKTP US*IO26K2LT3 AMZN MKTP US*DW33R73N3 AMAZON.COM*XP8XK1FY3 AMAZON.COM*2W2GT6GB3 AMZN MKTP US*PU81F4MV3 AMAZON.COM*JJ1H16P13 SAMSCLUB.COM AMZN MKTP US*VR0566TW3 AMAZON.COM*CU9JJ85M3 AMZN MKTP US*G09UDORX3 PC PC PC PC PC PC PC PC PC PC Account: 135-65095-030-000 Maintenance Supplies Totals: 428.00 428.00 ** 4,000.00 Budgeted 3,572.00 Remaining 11 % 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 .00 .00 Account: 135-69005-030-000 Capital Outlays Totals: .00 .00 ** 195,000.00 Budgeted 195,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 91 10/17/2019 October A/P 141 10/29/2019 October A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 10/2019 Page 43 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) copier lease-SOct copies 165.00 165.00 TIAA COMMERCIAL FINANCE 88.84 253.84 KYOCERA DOCUMENT SOLUTIONS 5845 AP 5859 AP Account: 135-69170-030-000 Copier Lease Installments Totals: 253.84 253.84 ** 4,000.00 Budgeted 3,746.16 Remaining 6 % Used Department 30 Totals: 111,447.47 Monthly Total 111,447.47 ** 1,776,712.00 Budgeted 1,665,264.53 Remaining 6 % Used glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 39 Non Departmental Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 44 Check Source Number Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 4,986.65 Monthly Total 4,000.00 Remaining 0 % Used 184,561.00 Budgeted 4,986.65 ** 179,574.35 Remaining 3 % Used (212,239.17) (212,239.17) Monthly Total (6,224.00) Budgeted 206,015.17 Remaining 9999999999 Account: 135-55045-039-000 Legal .00 .00 Account: 135-55045-039-000 Legal Totals: .00 .00 ** 135,000.00 Budgeted 135,000.00 Remaining 0 % Used Account: 135-55055-039-000 Auditing 165 10/01/2019 Reverse PPD Audit Retainer 5,000.00 5,000.00 GL Account: 135-55055-039-000 Auditing Totals: 5,000.00 5,000.00 ** 33,800.00 Budgeted 28,800.00 Remaining 15 % Used Account: 135-55060-039-000 Appraisal 170 10/30/2019 TAD Entity Refund (13.35) (13.35) GL Account: 135-55060-039-000 Appraisal Totals: (13.35) (13.35) ** 11,761.00 Budgeted 11,774.35 Remaining 0 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 4,986.65 Monthly Total 4,000.00 Remaining 0 % Used 184,561.00 Budgeted 4,986.65 ** 179,574.35 Remaining 3 % Used (212,239.17) (212,239.17) Monthly Total (6,224.00) Budgeted 206,015.17 Remaining 9999999999 glpdatb2 skrolczyk 17:07 11/07/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 Program: Page 45 Period Ending: 10/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer -General Fund 151 10/01/2019 GASB 34 Transfers FY 2020 151 10/01/2019 GASB 34 Transfers FY 2020 151 10/01/2019 GASB 34 Transfers FY 2020 151 10/01/2019 GASB 34 Transfers FY 2020 Town Elevated Tank Water Replacement Sewer Replacement WWTP MBR Replacement (45,000.00) (30,000.00) (30,000.00) (100,000.00) (45,000.00) (75,000.00) (105,000.00) (205,000.00) GL GL GL GL Department Totals: Fund 137 Totals: (286,420.00) Monthly Total (286,420.00) Monthly Total .00 Budgeted .00 Budgeted (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: (205,000.00) (205,000.00) ** .00 Budgeted 205,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer -Fire Dept 151 10/01/2019 GASB 34 Transfers FY 2020 Fire Truck Future Replacement (81,420.00) (81,420.00) GL Account: 137-49146-000-000 Intergov Transfer -Fire Dept Totals: (81,420.00) (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: Fund 137 Totals: (286,420.00) Monthly Total (286,420.00) Monthly Total .00 Budgeted .00 Budgeted (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - WWTP TAX BOND CONST BALANCE SHEET OCTOBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 568,105 TOTAL ASSETS 568,105 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE (118,410) NET REVENUES / EXPENDITURES 1,039 TOTAL FUND BALANCE (117,371) TOTAL LIABILITIES AND FUND BALANCE 568,105 glbase_tbam skrolczyk 17:07 11/07/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: 10/2019 Amended Total Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 14 517-49011-000-000 Interest Income 1,038.84- 1,038.84- 1,038.84 Subtotal: 1,038.84- 1,038.84- 1,038.84 Program number: 1,038.84- 1,038.84- 1,038.84 Department number: Revenues 1,038.84- 1,038.84- 1,038.84 Revenues Subtotal 1,038.84- 1,038.84- 1,038.84 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,038.84- 1,038.84- 1,038.84 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October (1,038.84) (1,038.84) GL Account: 517-49011-000-000 Interest Income Totals: (1,038.84) (1,038.84) ** .00 Budgeted 1,038.84 Remaining 0 % Used Department Totals: (1,038.84) ** (1,038.84) Monthly Total .00 Budgeted 1,038.84 Remaining 0 % Used Fund 517 Totals: (1,038.84) (1,038.84) Monthly Total .00 Budgeted 1,038.84 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET OCTOBER 2019 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 780,339 TOTAL ASSETS 780,339 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 81,691 81,691 698,648 698,648 780,339 TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET OCTOBER 2019 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 585,675 INVESTMENTS 3,869,575 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,455,250 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 4,454,290 NET REVENUES / EXPENDITURES 960 TOTAL FUND BALANCE 4,455,250 TOTAL LIABILITIES AND FUND BALANCE 4,455,250 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 10/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Trophy Club MUD No.1 Page 15 Budget Summary with Amendment 520-49011-000-000 Subtotal: Program number: Department number: Revenues Interest Income Subtotal Fund number: 520 Revenue Bond 16" Waterline 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75 959.75 959.75 959.75 959.75 959.75 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October (959.75) (959.75) GL Account: 520-49011-000-000 Interest Income Totals: (959.75) (959.75) ** .00 Budgeted 959.75 Remaining 0 % Used Department Totals: (959.75) ** (959.75) Monthly Total .00 Budgeted 959.75 Remaining 0 % Used Fund 520 Totals: (959.75) (959.75) Monthly Total .00 Budgeted 959.75 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET OCTOBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 815,113 TOTAL ASSETS 815,113 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 803,457 11,655 815,113 815,113 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 528 2015 Revenue Bond Reserve Fund Department: Account Description 528-49011-000-000 528-49142-000-000 528-49143-000-000 Subtotal: Program number: Department number: Revenues Interest Income Interfund transfer in -Water Interfund transfer in -WW Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund Trophy Club MUD No.1 Page 16 Budget Summary with Amendment Program: Period Ending: 10/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 11,000.00- 11,000.00- 307,049.00- 307,049.00- 200,417.00- 200,417.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 1,305.47- 4,600.00- 5,750.00- 1,305.47- 4,600.00- 5,750.00- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11.868 1.498 2.869 2.248 9,694.53- 302,449.00- 194,667.00- 506,810.53- 2.248 506,810.53- 2.248 2.248 2.248 506,810.53- 506,810.53- 506,810.53- glpdatb2 skrolczyk 17:07 11/07/19 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Department: JE Detail Description/Comment Account: 528-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October Account: 528-49011-000-000 Trophy Club MUD No.1 Page 48 Detailed Accounting Trial Balance Program: Period Ending: 10/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (11,000.00) Budgeted (9,694.53) Remaining 12 % Used Account: 528-49142-000-000 Interfund transfer in -Water 158 10/31/2019 TexPool Transfers October TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (307,049.00) Budgeted (302,449.00) Remaining Account: 528-49143-000-000 Interfund transfer an -WW 158 10/31/2019 TexPool Transfers October TexPool 0&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: Interfund transfer in -WW Totals: (200,417.00) Budgeted (194,667.00) Remaining (1,305.47) (1,305.47) GL (1,305.47) (1,305.47) ** (4,600.00) (4,600.00) GL 1 % Used (4,600.00) (4,600.00) ** (5,750.00) (5,750.00) GL 3 % Used (11,655.47) Monthly Total (518,466.00) Budgeted (11,655.47) Monthly Total (518,466.00) Budgeted (5,750.00) (5,750.00) ** (11,655.47) ** (506,810.53) Remaining 2 % Used (11,655.47) (506,810.53) Remaining 2 % Used TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET OCTOBER 2019 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER TOTAL ASSETS LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 101,433 701,994 803,427 701,994 701,994 82,954 18,479 101,433 803,427 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 533 MUD 1 I&S Consolidated Account Description 1 1 533-40000-000-000 1 533-40002-000-000 1 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I Trophy Club MUD No.1 Page 17 Budget Summary with Amendment Department: Revenues Program: Period Ending: 10/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 8,724.42- 839.78 42.80- 8,724.42- 839.78 42.80- 1.278 -83.978 2.140 673,716.58- 1,839.78- 1,957.20 - Subtotal: 685,441.00- 685,441.00- 7,927.44- 7,927.44- 1.157 677,513.56- 533-49011-000-000 1 533-49015-000-000 Interest Income Lease/Rental Income 5,000.00- 218,004.00- 5,000.00- 218,004.00- 136.86- 136.86- 2.737 4,863.14- 218,004.00- 533-49141-000-000 Interfund Trans In -PID Surchg 114,563.00- 114,563.00- 10,414.81- 10,414.81- 9.091 104,148.19 - Subtotal: 337,567.00- 337,567.00- 10,551.67- 10,551.67- 3.126 327,015.33 - Program number: 1,023,008.00- 1,023,008.00- 18,479.11- 18,479.11- 1.806 1,004,528.89 - Department number: Revenues 1,023,008.00- 1,023,008.00- 18,479.11- 18,479.11- 1.806 1,004,528.89 - Revenues Subtotal 1,023,008.00- 1,023,008.00- 18,479.11- 18,479.11- 1.806 1,004,528.89- glbase_tbam skrolczyk 17:07 11/07/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: 10/2019 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 18 533-70025-051-000 Bond Interest Expense -Tax 1 533-70035-051-000 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 200.00 200.00 18,479.11- 18,479.11- -9,239.555 18,679.11 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 188 10/02/2019 Property Taxes 191 10/08/2019 Property Taxes 192 10/09/2019 Property Taxes 193 10/10/2019 Property Taxes 194 10/11/2019 Property Taxes 196 10/15/2019 Property Taxes 197 10/16/2019 Property Taxes 198 10/17/2019 Property Taxes 199 10/18/2019 Property Taxes 200 10/21/2019 Property Taxes 201 10/22/2019 Property Taxes 202 10/24/2019 Property Taxes 203 10/25/2019 Property Taxes 204 10/28/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes 207 10/31/2019 Property Taxes (27.48) (27.48) GL (259.41) (286.89) GL (92.76) (379.65) GL (135.58) (515.23) GL (465.45) (980.68) GL (128.22) (1,108.90) GL (4.58) (1,113.48) GL (233.74) (1,347.22) GL (402.79) (1,750.01) GL (503.82) (2,253.83) GL (104.78) (2,358.61) GL (716.84) (3,075.45) GL (312.17) (3,387.62) GL (3,527.70) (6,915.32) GL (218.27) (7,133.59) GL (629.30) (7,762.89) GL (961.53) (8,724.42) GL Account: 533-40000-000-000 Property Taxes Totals: (8,724.42) (8,724.42) ** (682,441.00) Budgeted (673,716.58) Remaining 1 9 Used Account: 533-40002-000-000 Property Taxes/Delinquent 189 10/03/2019 Property Taxes 190 10/07/2019 Property Taxes 193 10/10/2019 Property Taxes 194 10/11/2019 Property Taxes 196 10/15/2019 Property Taxes 199 10/18/2019 Property Taxes 201 10/22/2019 Property Taxes 202 10/24/2019 Property Taxes 203 10/25/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes 579.77 579.77 GL (9.63) 570.14 GL 21.24 591.38 GL (21.57) 569.81 GL (2.22) 567.59 GL 408.60 976.19 GL (112.82) 863.37 GL (.33) 863.04 GL (6.31) 856.73 GL (8.12) 848.61 GL (8.83) 839.78 GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: 839.78 839.78 ** (1,000.00) Budgeted (1,839.78) Remaining -84 % Used Account: 533-40015-000-000 Property Taxes/P & I 190 10/07/2019 Property Taxes 194 10/11/2019 Property Taxes (1.96) (1.96) GL (4.53) (6.49) GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 ISS Consolidated Department: Revenues Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 196 10/15/2019 Property Taxes 201 10/22/2019 Property Taxes 203 10/25/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes (.39) (6.88) GL (30.65) (37.53) GL (1.14) (38.67) GL (1.22) (39.89) GL (2.91) (42.80) GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (42.80) (42.80) ** (2,000.00) Budgeted Account: 533-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October (1,957.20) Remaining 2 % Used (136.86) (136.86) GL Account: 533-49011-000-000 Interest Income Totals: (136.86) (136.86) ** (5,000.00) Budgeted (4,863.14) Remaining 3 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (218,004.00) Budgeted (218,004.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 158 10/31/2019 TexPool Transfers October TexPool O&M to I&S- PID Debt (10,414.81) (10,414.81) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (114,563.00) Budgeted (104,148.19) Remaining (10,414.81) (10,414.81) ** 9 % Used Department Totals: (18,479.11) ** (18,479.11) Monthly Total (1,023,008.00) Budgeted (1,004,528.89) Remaining 2 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2019 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: (18,479.11) (18,479.11) Monthly Total 200.00 Budgeted 18,679.11 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET OCTOBER 2019 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 78,985 TOTAL ASSETS 78,985 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 24,518 54,467 78,985 TOTAL LIABILITIES AND FUND BALANCE 78,985 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 17:07 11/07/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 10/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49011-000-000 Interest Income 2,500.00- 2,500.00- 45.27- 45.27- 1.811 2,454.73- 534-49143-000-000 Interfund Transfer In -WW Sales 598,638.00- 598,638.00- 54,421.63- 54,421.63- 9.091 544,216.37 - Subtotal: 601,138.00- 601,138.00- 54,466.90- 54,466.90- 9.061 546,671.10 - Program number: 601,138.00- 601,138.00- 54,466.90- 54,466.90- 9.061 546,671.10 - Department number: Revenues 601,138.00- 601,138.00- 54,466.90- 54,466.90- 9.061 546,671.10 - Revenues Subtotal 601,138.00- 601,138.00- 54,466.90- 54,466.90- 9.061 546,671.10- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 17:07 11/07/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 10/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 534-70040-051-000 Revenue Bond Interest Expense 208,238.00 208,238.00 208,238.00 534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 390,000.00 Subtotal: 598,638.00 598,638.00 598,638.00 Program number: 598,638.00 598,638.00 598,638.00 Department number: Administration 598,638.00 598,638.00 598,638.00 Expenditures Subtotal 598,638.00 598,638.00 598,638.00 Fund number: 534 2015 Revenue Bond I&S 2,500.00- 2,500.00- 54,466.90- 54,466.90- 2,178.676 51,966.90 glpdatb2 skrolczyk 17:07 11/07/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: 10/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 52 Check Source Number Department Totals: (598,638.00) Budgeted (54,466.90) Monthly Total (544,216.37) Remaining 9 % Used (601,138.00) Budgeted (54,466.90) ** (546,671.10) Remaining 9 % Used Account: 534-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October (45.27) (45.27) GL Account: 534-49011-000-000 Interest Income Totals: (45.27) (45.27) ** (2,500.00) Budgeted (2,454.73) Remaining 2 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 158 10/31/2019 TexPool Transfers October TexPool O&M to Rev Bd WWTP I&S (54,421.63) (54,421.63) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,421.63) (54,421.63) ** Department Totals: (598,638.00) Budgeted (54,466.90) Monthly Total (544,216.37) Remaining 9 % Used (601,138.00) Budgeted (54,466.90) ** (546,671.10) Remaining 9 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 10/2019 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: 208,238.00 Budgeted 208,238.00 Remaining O 6 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: 390,000.00 Budgeted 390,000.00 Remaining Department 51 Totals: Fund 534 Totals: .00 .00 O % Used .00 Monthly Total 598,638.00 Budgeted (54,466.90) Monthly Total .00 .00 ** .00 ** 598,638.00 Remaining 0 % Used (54,466.90) (2,500.00) Budgeted 51,966.90 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET OCTOBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB ` MUNICIPAL UTILITY DISTRICT Na. 1 535 NSII FTW SWIFT REVENUE BOND I&S 30,025 TOTAL ASSETS 30,025 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 4,967 25,058 30,025 TOTAL LIABILITIES AND FUND BALANCE 30,025 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 17:07 11/07/19 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 10/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49011-000-000 Interest Income 1,000.00- 1,000.00- 10.54- 535-49142-000-000 Interfund Tran In -Water Sales 275,525.00- 275,525.00- 25,047.72 - Subtotal: 276,525.00- 276,525.00- 25,058.26 - Program number: 276,525.00- 276,525.00- 25,058.26 - Department number: Revenues 276,525.00- 276,525.00- 25,058.26 - Revenues Subtotal 276,525.00- 276,525.00- 25,058.26- 10.54- 25,047.72- 25,058.26- 25,058.26- 25,058.26- 25,058.26- 1.054 9.091 9.062 9.062 9.062 9.062 989.46- 250,477.28- 251,466.74- 251,466.74- 251,466.74- 251,466.74- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 17:07 11/07/19 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 10/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Account Description 535-70005-051-000 Rev Bond Paying Agent Fee 800.00 800.00 535-70040-051-000 Revenue Bond Interest Expense 386,811.00 386,811.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 Subtotal: 602,611.00 602,611.00 Program number: 602,611.00 Department number: Administration Expenditures Subtotal Fund number: 535 2016 Rev Bond I&S-SWIFT 800.00 386,811.00 215,000.00 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 326,086.00 326,086.00 25,058.26- 25,058.26- -7.685 602,611.00 602,611.00 351,144.26 glpdatb2 skrolczyk 17:07 11/07/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: 10/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 54 Check Source Number Department Totals: (275,525.00) Budgeted (25,058.26) Monthly Total (250,477.28) Remaining 9 % Used (276,525.00) Budgeted (25,058.26) ** (251,466.74) Remaining 9 % Used Account: 535-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October (10.54) (10.54) GL Account: 535-49011-000-000 Interest Income Totals: (10.54) (10.54) ** (1,000.00) Budgeted (989.46) Remaining 1 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 158 10/31/2019 TexPool Transfers October TexPool O&M to 16Swift Rev I&S (25,047.72) (25,047.72) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,047.72) (25,047.72) ** Department Totals: (275,525.00) Budgeted (25,058.26) Monthly Total (250,477.28) Remaining 9 % Used (276,525.00) Budgeted (25,058.26) ** (251,466.74) Remaining 9 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 55 Account: 535-70005-051-000 Rev Bond Paying Agent Fee Account: 535-70005-051-000 Account: 535-70040-051-000 Account: 535-70040-051-000 Account: 535-70045-051-000 Account: 535-70045-051-000 Department 51 Totals: Fund 535 Totals: Rev Bond Paying Agent Fee Totals: 800.00 Budgeted 800.00 Remaining Revenue Bond Interest Expense Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 386,811.00 Remaining Revenue Bond Principal Expense Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining .00 Monthly Total O % Used .00 .00 .00 .00 ** .00 O % Used .00 O % Used .00 .00 .00 ** 602,611.00 Budgeted 602,611.00 Remaining 0 % Used (25,058.26) Monthly Total 326,086.00 Budgeted (25,058.26) 351,144.26 Remaining -8 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET OCTOBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 29,738 TOTAL ASSETS 29,738 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 29,738 TOTAL FUND BALANCE 29,738 TOTAL LIABILITIES AND FUND BALANCE 29,738 glbase_tbam skrolczyk Trophy Club MUD No.1 17:07 11/07/19 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 10/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 536-49011-000-000 536-49142-000-000 536-49143-000-000 Interest Income Interfund Tran In -Water Sales Interfund Transfer In -WW Sales 2.98- 2.98- 22,896.02- 22,896.02- 6,839.07- 6,839.07- 2.98 22,896.02 6,839.07 Page 23 Subtotal: 29,738.07- 29,738.07 - 29,738.07 Program number: 29,738.07 - Department number: Revenues Revenues Subtotal Fund number: 536 2019 Rev Bond I&S- W&WW System End of Report ********* 29,738.07- 29,738.07 29,738.07- 29,738.07- 29,738.07- 29,738.07- 29,738.07- 29,738.07- 29,738.07 29,738.07 29,738.07 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October Account: 536-49011-000-000 Interest Income Totals: .00 Budgeted 2.98 Remaining 0 6 Used Account: 536-49142-000-000 Interfund Tran In -Water Sales 158 10/31/2019 TexPool Transfers October TexPool O&M to 19 W&WW Rev I&S Account: 536-49142-000-000 (2.98) (2.98) GL (2.98) (22,896.02) Interfund Tran In -Water Sales Totals: (22,896.02) .00 Budgeted 22,896.02 Remaining Account: 536-49143-000-000 Interfund Transfer In -WW Sales 158 10/31/2019 TexPool Transfers October TexPool O&M to 19 W&WW Rev I&S Account: 536-49143-000-000 Department Totals: Fund 536 Totals: Grand Totals: Interfund Transfer In -WW Sales Totals: .00 Budgeted 6,839.07 Remaining 0 % Used (2.98) ** (22,896.02) GL (22,896.02) ** (6,839.07) (6,839.07) GL 0 9 Used (29,738.07) Monthly Total .00 Budgeted (29,738.07) Monthly Total .00 Budgeted (6,839.07) (6,839.07) ** (29,738.07) ** 29,738.07 Remaining 0 % Used (29,738.07) 29,738.07 Remaining 0 % Used (384,181.61) Monthly Total (919,561.00) Budgeted ******* End of Report ********* (384,181.61) **** (535,379.39) Remaining 42 % Used