Loading...
HomeMy WebLinkAbout2019-04 Combined Financials April 2019TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET APRIL 2019 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 808,050 PREPAID EXPENSES 7,456 ADVALOREM PROPERTY TAXES RECEIVABLE 34,358 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 849,864 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 34,358 TOTAL LIABILITIES 34,358 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 543,884 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 271,622 TOTAL FUND BALANCE 815,506 TOTAL LIABILITIES AND FUND BALANCE 849,864 glbase_tbam skrolczyk 14:47 05/15/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 122-40010-000-000 1 122-40011-000-000 1 122-40020-000-000 Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Property Taxes/Fire P&i Trophy Club MUD No.1 Page 1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 4/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,117,000.00- 1,117,000.00- 7,078.21- 51.53- 653.52- 1,094,151.34- 1,859.29- 4,027.74- 97.954 22,848.66- 1,859.29 4,027.74 Subtotal: 1,117,000.00- 1,117,000.00- 7,783.26- 1,100,038.37- 98.482 16,961.63- 122-49035-000-000 Prior Year Reserves 75,000.00- 75,000.00- 75,000.00 - Subtotal: 75,000.00- 75,000.00- 75,000.00 - Program number: 1,192,000.00- 1,192,000.00- 7,783.26- 1,100,038.37- 92.285 91,961.63 - Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 7,783.26- 1,100,038.37- 92.285 91,961.63 - Revenues Subtotal 1,192,000.00- 1,192,000.00- 7,783.26- 1,100,038.37- 92.285 91,961.63- glbase_tbam skrolczyk 14:47 05/15/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 1 122-60030-045-000 1 122-60055-045-000 1 122-60337-045-000 Rent And/Or Usage Insurance Transfer to Town/Fire Budget Trophy Club MUD No.1 Budget Summary with Amendment Department: 45 Fire Program: Period Ending: 4/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 215,979.00 18,000.00 674,452.00 215,979.00 18,000.00 674,452.00 1,491.21 112,408.66 215,979.00 10,438.47 393,429.98 100.000 57.992 58.333 7,561.53 281,022.02 Page 2 Subtotal: 908,431.00 908,431.00 113,899.87 619,847.45 68.233 288,583.55 122-69005-045-000 1 122-69195-045-000 Capital Outlays GASB34/Reserve for Replacement 75,000.00 81,420.00 75,000.00 81,420.00 81,420.00 100.000 75,000.00 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 283,569.00 283,569.00 208,568.60 73.551 75,000.40 Program number: 1,192,000.00 1,192,000.00 113,899.87 828,416.05 69.498 363,583.95 Department number: Fire 1,192,000.00 1,192,000.00 113,899.87 828,416.05 69.498 363,583.95 Expenditures Subtotal 1,192,000.00 1,192,000.00 113,899.87 828,416.05 69.498 363,583.95 Fund number: 122 Trophy Club MUD Fire Dept. 106,116.61 271,622.32- 271,622.32 glpdatb2 skrolczyk Trophy Club MUD No.1 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) Page 1 Check Source Number Account: 122-40010-000-000 Property Taxes/MUD Fire 1255 04/01/2019 Property Taxes 1256 04/02/2019 Property Taxes 1257 04/03/2019 Property Taxes 1258 04/04/2019 Property Taxes 1259 04/05/2019 Property Taxes 1260 04/08/2019 Property Taxes 1261 04/10/2019 Property Taxes 1263 04/12/2019 Property Taxes 1264 04/15/2019 Property Taxes 1265 04/16/2019 Property Taxes 1266 04/17/2019 Property Taxes 1267 04/18/2019 Property Taxes 1268 04/22/2019 Property Taxes 1269 04/23/2019 Property Taxes 1270 04/24/2019 Property Taxes 1271 04/25/2019 Property Taxes 1272 04/26/2019 Property Taxes 1273 04/29/2019 Property Taxes 1274 04/30/2019 Property Taxes (1,087,073.13) (358.02) (1,087,431.15) (1,137.62) (1,088,568.77) (763.13) (1,089,331.90) (14.05) (1,089,345.95) (1,017.19) (1,090,363.14) (45.85) (1,090,408.99) (1,823.95) (1,092,232.94) (64.99) (1,092,297.93) 16.80 (1,092,281.13) (147.96) (1,092,429.09) (290.26) (1,092,719.35) (17.95) (1,092,737.30) (723.00) (1,093,460.30) 16.80 (1,093,443.50) (45.24) (1,093,488.74) (247.27) (1,093,736.01) (333.10) (1,094,069.11) (2.35) (1,094,071.46) (79.88) (1,094,151.34) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (7,078.21) (1,094,151.34) ** (1,117,000.00) Budgeted (22,848.66) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1255 04/01/2019 Property Taxes 1256 04/02/2019 Property Taxes 1262 04/11/2019 Property Taxes 1272 04/26/2019 Property Taxes 1274 04/30/2019 Property Taxes (1,807.76) (11.00) (17.95) (.37) (11.29) (10.92) (1,818.76) (1,836.71) (1,837.08) (1,848.37) (1,859.29) GL GL GL GL GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (51.53) (1,859.29) ** .00 Budgeted 1,859.29 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire PSI 1255 04/01/2019 Property Taxes 1256 04/02/2019 Property Taxes 1257 04/03/2019 Property Taxes 1258 04/04/2019 Property Taxes 1259 04/05/2019 Property Taxes 1260 04/08/2019 Property Taxes (3,374.22) (14.67) (3,388.89) (33.76) (3,422.65) (64.92) (3,487.57) (1.12) (3,488.69) (91.86) (3,580.55) (3.21) (3,583.76) GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1261 04/10/2019 Property Taxes 1262 04/11/2019 Property Taxes 1263 04/12/2019 Property Taxes 1265 04/16/2019 Property Taxes 1266 04/17/2019 Property Taxes 1267 04/18/2019 Property Taxes 1268 04/22/2019 Property Taxes 1270 04/24/2019 Property Taxes 1271 04/25/2019 Property Taxes 1272 04/26/2019 Property Taxes 1273 04/29/2019 Property Taxes 1274 04/30/2019 Property Taxes Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: .00 Budgeted 4,027.74 Remaining Account: 122-49035-000-000 Prior Year Reserves Account: 122-49035-000-000 Department Totals: Prior Year Reserves Totals: (75,000.00) Budgeted (7,783.26) Monthly Total (3,374.22) (201.27) (3,785.03) GL (.03) (3,785.06) GL (7.15) (3,792.21) GL (40.65) (3,832.86) GL (31.93) (3,864.79) GL (1.72) (3,866.51) GL (59.01) (3,925.52) GL (12.42) (3,937.94) GL (27.19) (3,965.13) GL (48.03) (4,013.16) GL (.65) (4,013.81) GL (13.93) (4,027.74) GL 0 % Used (75,000.00) Remaining 0 % Used (653.52) .00 (4,027.74) ** .00 .00 .00 ** (1,100,038.37) ** (1,192,000.00) Budgeted (91,961.63) Remaining 92 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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-60030-045-000 Rent And/Or Usage 215,979.00 .00 215,979.00 Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 215,979.00 ** 215,979.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 131 04/01/2019 Insurance/Wrk Comp Expense Apr 8,947.26 1,491.21 10,438.47 Account: 122-60055-045-000 Insurance Totals: 1,491.21 10,438.47 ** Account: 122-60337-045-000 1155 04/18/2019 April A/P 1209 04/30/2019 April A/P Account: 122-60337-045-000 18,000.00 Budgeted 7,561.53 Remaining 58 % Used Transfer to Town/Fire Budget Fire admin -March Fire admin -April 281,021.32 56,204.33 56,204.33 GL 337,225.65 TOWN OF TROPHY CLUB 5231 AP 393,429.98 TOWN OF TROPHY CLUB 5247 AP Transfer to Town/Fire Budget Totals: 112,408.66 393,429.98 ** 674,452.00 Budgeted 281,022.02 Remaining 58 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 75,000.00 Budgeted 75,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 Budgeted .00 Remaining 81,420.00 .00 81,420.00 100 % Used .00 81,420.00 ** Account: 122-69305-045-000 Capital Leases Account: 122-69305-045-000 Capital Leases 127,149.00 Budgeted 127,148.60 .00 127,148.60 Totals: .00 127,148.60 ** .40 Remaining 100 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 45 Totals: 828,416.05 ** 113,899.87 Monthly Total 1,192,000.00 Budgeted 363,583.95 Remaining 69 % Used Fund 122 Totals: (271,622.32) 106,116.61 Monthly Total .00 Budgeted 271,622.32 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET APRIL 2019 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 1,486,328 1,486,328 CASH IN BANK -SAVINGS -CASH RESERVE 1,189,693 1,189,693 INVESTMENTS-TEXPOOL 3,513,447 516,233 4,029,680 PREPAID EXPENSES 46,226 46,226 ADVALOREM PROPERTY TAXES RECEIVABLE 3,801 3,801 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,309,583 2,309,583 TOTAL ASSETS 8,549,678 516,233 9,065,911 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,801 3,801 ACCOUNTS AND OTHER PAYABLES 426,871 426,871 CUSTOMER DEPOSITS 315,380 315,380 TOTAL LIABILITIES 746,051 746,051 FUND BALANCE NON -SPENDABLE FUND BALANCE 8,486 8,486 ASSIGNED FUND BALANCE 2,173,156 2,173,156 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 225,000 225,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT (116,613) (116,613) ASSIGNED FUND BALANCE/SEWER REPLACEMENT 97,805 97,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 310,041 310,041 UNASSIGNED FUND BALANCE 5,442,543 5,442,543 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 179,442 179,442 TOTAL FUND BALANCE 7,803,627 516,233 8,319,860 TOTAL LIABILITIES AND FUND BALANCE 8,549,678 516,233 9,065,911 glbase_tbam skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund Account 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Subtotal: 135-47000-000-000 135-47005-000-000 135-47025-000-000 135-47030-000-000 135-47035-000-000 135-47045-000-000 135-47070-000-000 Subtotal: 135-49010-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49035-000-000 135-49036-000-000 135-49075-000-000 135-49900-000-000 135-49901-000-000 Subtotal: Description Property Taxes Property Taxes/Delinquent Property Taxes/P & i PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Oversize Meter Reimbursement Miscellaneous Income Records Management Revenue Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget 132,384.00- 300.00- 300.00- 171,983.00- 304,967.00- 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 20,000.00- 14,146.00- 7,000.00- 10,000.00- 18,522.00- 7,000.00- 76,668.00- 10,613,202.00- 10,613,202.00- 10,613,202.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 4/2019 Amended Total Budget Encumb. 132,384.00- 300.00- 300.00- 171,983.00- 304,967.00- 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 80,000.00- 14,146.00- 7,000.00- 55,000.00- 358,600.00- 266,613.00- 18,522.00- 7,000.00- 806,881.00- 11,343,415.00- 11,343,415.00- 11,343,415.00 - Current Month 805.90- 28.82- 51.51- 886.23- 360,534.34- 222,606.22- 7,064.99- 1,825.00- 1,488.00- 593,518.55- 11,841.62- 2,357.62- 583.33- 266,613.00- 20,260.52- 2.00- 301,658.09- 896,062.87- 896,062.87- 896,062.87 - Program: YTD Total 124,576.02- 250.36- 443.98- 125,270.36- 2,161,832.44- 1,788,164.34- 57,608.64- 10,250.00- 750.00- 2,250.00- 1,510.40- 4,022,365.82- 75,622.78- 9,757.15- 4,083.31- 52,600.00- 266,613.00- 5,488.00- 29,888.28- 4.00- 444,056.52- 4,591,692.70- 4,591,692.70- 4,591,692.70- % of Budget 94.102 83.453 147.993 41.077 32.758 52.398 42.230 60.294 50.000 50.000 2.517 Remaining Budget 7,807.98- 49.64- 143.98 171,983.00- 179,696.64- 4,437,651.56- 1,624,500.66- 78,809.36- 6,750.00- 750.00- 2,250.00- 58,489.60- 39.313 6,209,201.18- 94.528 68.975 58.333 95.636 100.000 29.630 426.975 55.034 40.479 40.479 40.479 4,377.22- 4,388.85- 2,916.69- 2,400.00- 358,600.00- 13,034.00- 22,888.28 4.00 362,824.48- 6,751,722.30- 6,751,722.30- 6,751,722.30 - Page 3 glbase_tbam skrolczyk 14:47 05/15/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 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 Trophy Club MUD No.1 Budget Summary with Amendment 10 Water Period Ending: 4/2019 Amended Total Budget Encumb. 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 Current Month Program: YTD Total % of Budget 23,393.00 160,440.14 49.101 883.46 6,196.23 30.981 3,620.00 100.000 175.00 1,275.00 26.563 2,261.76 16,917.97 50.799 4,219.68 25,725.12 34.384 261.55 1,687.15 39.082 42.47 277.64 39.606 209.67 1,507.45 48.146 1,472.22 10,372.38 47.102 344.30 2,425.79 47.103 767.78 71.091 930.94 6,245.98 48.437 Remaining Budget 166,314.86 13,803.77 3,525.00 16,386.03 49,092.88 2,629.85 423.36 1,623.55 11,648.62 2,724.21 312.22 6,649.02 200.00 300.00 Page 4 Subtotal: 513,092.00 513,092.00 34,194.05 237,458.63 46.280 275,633.37 135-55005-010-000 135-55080-010-000 135-55085-010-000 135-55090-010-000 135-55105-010-000 135-55120-010-000 135-55135-010-000 Subtotal: 135-60010-010-000 135-60020-010-000 135-60066-010-000 135-60070-010-000 135-60080-010-000 135-60090-010-000 135-60100-010-000 135-60105-010-000 135-60135-010-000 135-60150-010-000 135-60245-010-000 135-60280-010-000 135-60285-010-000 135-60332-010-000 135-60333-010-000 135-60334-010-000 Engineering Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 5,214.00 6,500.00 143,214.00 5,000.00 154,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 3,013,494.00 200.00 3,000.00 14,750.00 585,209.00 55,193.00 200,000.00 20,000.00 153,000.00 3,000.00 5,000.00 3,500.00 5,214.00 6,500.00 196,214.00 5,000.00 154,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 3,013,494.00 200.00 3,000.00 14,750.00 585,209.00 55,193.00 200,000.00 7,310.01 97,417.55 63.672 1,906.30 63.543 502.43 2,145.23 42.905 1,877.20 5,047.40 77.652 9,689.64 106,516.48 54.286 285.29 2,166.43 43.329 8,639.51 58,617.15 38.013 61.00 12.200 1,040.00 2,036.00 43.776 309.39 309.39 13.194 4,212.30 16,336.53 28.166 126,312.22 716,651.51 23.781 336.00 11.200 2,840.00 19.254 25,172.81 176,209.67 30.111 4,600.00 32,200.00 58.341 20,000.00 55,582.45 1,093.70 2,854.77 3,500.00 5,214.00 1,452.60 89,697.52 2,833.57 95,586.85 1,000.00 439.00 2,615.00 400.00 2,035.61 1,500.00 41,663.47 2,296,842.49 200.00 2,664.00 11,910.00 408,999.33 22,993.00 200,000.00 glbase_tbam skrolczyk 14:47 05/15/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: 135-70040-010-000 Subtotal: Program number: 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 Bond Related Expenses Department: Adopted Budget 2,500.00 4,101,946.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 453,000.00 30,068.00 4,124.00 75,000.00 120,000.00 682,192.00 5,639,834.00 Trophy Club MUD No.1 Page 5 Budget Summary with Amendment 10 Water Period Ending: 4/2019 Amended Total Budget Encumb. 2,500.00 4,101,946.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 719,613.00 30,068.00 4,124.00 75,000.00 120,000.00 948,805.00 5,959,447.00 Current Month 170,571.52 1,034.84 2,011.31 780.00 3,826.15 142,322.51- 142,322.51- 75,958.85 Program: YTD Total 1,007,763.68 5,743.11 1,417.41 13,347.99 17,861.60 32,262.00 70,632.11 286,724.26 30,068.00 2,283.93 75,000.00 99,877.11 493,953.30 7,080.00 7,080.00 1,923,404.20 % of Budget 24.568 38.287 27.310 66.740 25.517 37.083 35.424 39.844 100.000 55.381 100.000 83.231 52.061 32.275 Remaining Budget 2,500.00 3,094,182.32 9,256.89 3,772.59 6,652.01 1,200.00 1,000.00 52,138.40 54,738.00 128,757.89 432,888.74 1,840.07 20,122.89 454,851.70 7,080.00- 7,080.00- 4,036,042.80 glbase_tbam skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund Department: 10 Water Trophy Club MUD No.1 Page 6 Budget Summary with Amendment Program: 1 Lab Analysis for PID Period Ending: 4/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,641,834.00 5,961,447.00 160.00 160.00 160.00 76,118.85 975.40 48.770 975.40 48.770 975.40 1,924,379.60 48.770 32.280 1,024.60 1,024.60 1,024.60 4,037,067.40 glbase tbam skrolczyk Trophy Club MUD No.1 Page 7 14:47 05/15/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 421,699.00 421,699.00 26,722.13 184,213.89 43.684 237,485.11 135-50010-020-000 Overtime 30,000.00 30,000.00 4,736.23 20,928.15 69.761 9,071.85 135-50016-020-000 Longevity 7,445.00 7,445.00 7,445.00 100.000 135-50017-020-000 Certification 8,700.00 8,700.00 700.00 5,000.00 57.471 3,700.00 135-50020-020-000 Retirement 43,276.00 43,276.00 2,974.65 21,643.50 50.013 21,632.50 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,588.48 38,294.90 41.794 53,332.10 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 340.56 2,477.91 48.548 2,626.09 135-50028-020-000 Vision Insurance 826.00 826.00 55.64 399.26 48.337 426.74 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 384.94 2,221.13 49.413 2,273.87 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 1,891.07 12,678.16 43.709 16,327.84 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 442.26 2,965.05 43.707 3,818.95 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 972.00 77.143 288.00 135-50045-020-000 Workman's Compensation 16,941.00 16,941.00 1,205.73 8,090.31 47.756 8,850.69 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 38.00 9.500 362.00 135-50070-020-000 Employee Relations 300.00 300.00 300.00 Subtotal: 667,863.00 667,863.00 45,041.69 307,367.26 46.023 360,495.74 135-55005-020-000 Engineering 30,000.00 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 2,921.00 19.473 12,079.00 135-55080-020-000 Maintenance & Repairs 88,000.00 133,000.00 4,305.09 91,113.61 68.506 41,886.39 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 4,550.82 45.508 5,449.18 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 331.15 1,450.54 18.132 6,549.46 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 7,000.00 6,803.00 97.186 197.00 135-55120-020-000 Cleaning Services 5,214.00 5,214.00 5,214.00 135-55125-020-000 Dumpster Services 75,000.00 75,000.00 3,608.58 42,314.24 56.419 32,685.76 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 3,813.82 27,545.16 78.700 7,454.84 Subtotal: 267,714.00 318,214.00 12,058.64 176,698.37 55.528 141,515.63 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 694.14 3,040.13 60.803 1,959.87 135-60020-020-000 Electricity 174,165.00 174,165.00 11,444.34 87,850.49 50.441 86,314.51 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 111.00 180.00 60.000 120.00 135-60080-020-000 Schools & Training 7,155.00 7,155.00 862.95 12.061 6,292.05 135-60090-020-000 Safety Program 1,000.00 1,000.00 100.74 10.074 899.26 135-60100-020-000 Travel & per diem 1,895.00 1,895.00 174.96 9.233 1,720.04 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 3,491.07 3,491.07 69.821 1,508.93 135-60125-020-000 Advertising 2,500.00 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 30,000.00 30,000.00 16,545.22 55.151 13,454.78 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 225.18 4.504 4,774.82 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 106.72 1,990.73 17.161 9,609.27 135-60331-020-000 Interfund Transfer Out -Tax I&S 120,053.00 120,053.00 10,913.90 76,397.30 63.636 43,655.70 glbase_tbam skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund Account 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Subtotal: 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 Subtotal: 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Subtotal: 135-70020-020-000 Subtotal: Program number: Department number: Wastewater Description Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Lab Supplies Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Capital Lease Issuance Cost Department: Adopted Budget 688,330.00 125,187.00 200,000.00 3,500.00 1,381,335.00 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 70,395.00 330,000.00 109,858.00 14,917.00 30,000.00 484,775.00 2,872,082.00 2,872,082.00 Trophy Club MUD No.1 Budget Summary with Amendment 20 Wastewater Period Ending: 4/2019 Amended Total Budget Encumb. 688,330.00 125,187.00 200,000.00 3,500.00 1,381,335.00 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 70,395.00 688,600.00 109,858.00 14,917.00 30,000.00 843,375.00 3,281,182.00 3,281,182.00 Current Month Program: YTD Total 54,203.45 379,424.15 10,432.00 73,024.00 91,396.62 643,306.92 702.44 6,898.29 2,059.90 4,497.60 20,798.84 54.95 1,095.69 3,349.83 5,200.04 34,257.50 4,420.50 490,172.37 39,858.59 3,027.55 30,000.00 4,420.50 158,117.49 158,117.49 563,058.51 1,500.00 1,500.00 1,726,188.56 1,726,188.56 % of Budget Remaining Budget 55.122 308,905.85 58.332 52,163.00 200,000.00 3,500.00 46.571 738,028.08 55.186 5,601.71 37.487 3,435.10 69.329 9,201.16 4.579 1,145.05 91.308 104.31 16.749 16,650.17 48.665 36,137.50 71.184 198,427.63 36.282 69,999.41 20.296 11,889.45 100.000 66.763 52.609 52.609 280,316.49 1,500.00- 1,500.00- 1,554,993.44 1,554,993.44 Page 8 glbase tbam skrolczyk Trophy Club MUD No.1 Page 9 14:47 05/15/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Period Ending: 4/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 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 30.00 30.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 13,200.00 13,230.00 13,230.00 2.12 14.84 2.12 14.84 2.12 2.12 650.00 34.38 920.00 338.57 1,942.95 1,957.79 1,957.79 49.467 Remaining Budget 15.16 49.467 15.16 86.667 2.645 23.000 6.771 14.719 14.798 14.798 150.00 100.00 1,265.62 3,080.00 4,661.43 2,000.00 11,257.05 11,272.21 11,272.21 glbase tbam skrolczyk Trophy Club MUD No.1 Page 10 14:47 05/15/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 441,006.00 2,000.00 1,833.00 41,148.00 81,895.00 4,291.00 701.00 4,495.00 27,580.00 6,450.00 1,260.00 1,295.00 500.00 5,000.00 441,006.00 2,000.00 1,833.00 41,148.00 81,895.00 4,291.00 701.00 4,495.00 27,580.00 6,450.00 1,260.00 1,295.00 500.00 5,000.00 28,748.44 4.13 2,659.61 5,475.60 306.40 48.77 343.58 1,678.62 392.59 94.85- 106.55 101.45 199,394.13 51.53 1,832.50 19,978.43 32,683.56 1,893.84 306.80 2,092.18 11,905.91 2,784.45 815.88 706.25 205.40 3,018.51 45.213 2.577 99.973 48.553 39.909 44.135 43.766 46.545 43.169 43.170 64.752 54.537 41.080 60.370 241,611.87 1,948.47 .50 21,169.57 49,211.44 2,397.16 394.20 2,402.82 15,674.09 3,665.55 444.12 588.75 294.60 1,981.49 Subtotal: 619,454.00 619,454.00 39,770.89 277,669.37 44.825 341,784.63 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleaning Services Professional Outside Services Utility Billing Contract 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 3,667.00 12,977.44 869.06 221.50 573.03 44,482.12 82,570.95 4,540.00 927.52 5,214.36 61,926.50 4,068.81 57.139 47.183 22.700 9.275 52.144 93.750 45.209 33,366.88 92,429.05 15,460.00 9,072.48 4,785.64 4,128.50 4,931.19 Subtotal: 367,904.00 367,904.00 18,308.03 203,730.26 55.376 164,173.74 135-60005-030-000 135-60010-030-000 135-60020-030-000 135-60025-030-000 135-60035-030-000 135-60040-030-000 135-60050-030-000 135-60055-030-000 135-60066-030-000 135-60070-030-000 135-60075-030-000 135-60079-030-000 135-60080-030-000 135-60100-030-000 135-60110-030-000 135-60125-030-000 135-60235-030-000 Telephone Communications/Mobiles Electricity/Gas Water Postage Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Advertising Security 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 2,758.02 237.45 812.54 53.86 3,198.97 4,832.31 10,333.41 1,662.57 3,879.64 387.01 13,176.38 38,440.22 6,302.73 44,119.11 95.17 24.00 43.972 13,166.59 41.564 2,337.43 44.645 4,810.36 19.351 1,612.99 43.921 16,823.62 69.187 17,119.78 1,500.00 67.876 20,880.89 1,000.00 4,109.25 68.488 1,890.75 95.17 23.793 304.83 6,000.00 135.00 1.508 8,815.00 8.70 .200 4,336.30 200.00 25,000.00 168.00 13.043 1,120.00 glbase_tbam skrolczyk 14:47 05/15/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: 4/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 124.49 24.898 375.51 17,000.00 2,500.00 Subtotal: 263,433.00 263,433.00 18,315.05 116,638.95 44.277 146,794.05 135-65010-030-000 135-65055-030-000 135-65085-030-000 135-65090-030-000 135-65095-030-000 135-65105-030-000 Uniforms Hardware Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing 2,050.00 7,064.00 6,000.00 3,500.00 4,000.00 2,500.00 2,050.00 7,064.00 6,000.00 3,500.00 4,000.00 2,500.00 376.97 418.24 3,025.81 5,305.92 2,529.01 42.834 88.432 63.225 2,050.00 4,038.19 694.08 3,500.00 1,470.99 2,500.00 Subtotal: 25,114.00 25,114.00 795.21 10,860.74 43.246 14,253.26 135-69005-030-000 Capital Outlays 280,000.00 280,000.00 40,774.00 14.562 239,226.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 245.22 1,888.99 47.225 2,111.01 Subtotal: 284,000.00 284,000.00 245.22 42,662.99 15.022 241,337.01 Program number: 1,559,905.00 1,559,905.00 77,434.40 651,562.31 41.769 908,342.69 Department number: Administration 1,559,905.00 1,559,905.00 77,434.40 651,562.31 41.769 908,342.69 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 14:47 05/15/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 137,000.00 137,000.00 10,400.34 71,215.85 51.982 135-55055-039-000 Auditing 30,800.00 30,800.00 26,459.53 85.908 135-55060-039-000 Appraisal 11,714.00 11,714.00 6,834.32 58.343 135-55065-039-000 Tax Admin Fees 4,800.00 4,800.00 3,653.00 76.104 Subtotal: 184,314.00 184,314.00 10,400.34 108,162.70 58.684 Program number: 184,314.00 184,314.00 10,400.34 108,162.70 Department number: Non Departmental 184,314.00 184,314.00 10,400.34 108,162.70 Expenditures Subtotal 10,271,365.00 11,000,078.00 322,073.20 4,412,250.96 Fund number: 135 MUD 1 General Fund 341,837.00- 343,337.00- 573,989.67- 179,441.74- 58.684 58.684 40.111 52.264 65,784.15 4,340.47 4,879.68 1,147.00 76,151.30 76,151.30 76,151.30 6,587,827.04 163,895.26- glbase_tbam skrolczyk 14:47 05/15/19 Fund: 137 MUD 1 Consolidated GASB Account 137-49145-000-000 Description Intergov Transfer -General Fund Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Program: Period Ending: 4/2019 Amended Total Current YTD Budget Encumb. Month Total 105,000.00- % of Remaining Budget Budget 105,000.00 Page 13 137-49146-000-000 Intergov Transfer -Fire Dept 81,420.00- 81,420.00 Subtotal: 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00 Revenues Subtotal 186,420.00- 186,420.00 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 14:47 05/15/19 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 10 Water Program: Period Ending: 4/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Account Description 137-69195-010-000 Subtotal: Program number: Department number: Expenditures GASB Replacement Water Subtotal Fund number: 137 MUD 1 Consolidated GASB 266,613.00 266,613.00 266,613.00 266,613.00 266,613.00 266,613.00 266,613.00 266,613.00 266,613.00 266,613.00 266,613.00 80,193.00 266,613.00- 266,613.00- 266,613.00- 266,613.00- 266,613.00- 80,193.00- glpdatb2 skrolczyk Trophy Club MUD No.1 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) Page 5 Check Source Number Account: 135-40000-000-000 Property Taxes 1255 04/01/2019 Property Taxes 1256 04/02/2019 Property Taxes 1257 04/03/2019 Property Taxes 1258 04/04/2019 Property Taxes 1259 04/05/2019 Property Taxes 1260 04/08/2019 Property Taxes 1261 04/10/2019 Property Taxes 1263 04/12/2019 Property Taxes 1264 04/15/2019 Property Taxes 1265 04/16/2019 Property Taxes 1266 04/17/2019 Property Taxes 1267 04/18/2019 Property Taxes 1268 04/22/2019 Property Taxes 1269 04/23/2019 Property Taxes 1270 04/24/2019 Property Taxes 1271 04/25/2019 Property Taxes 1272 04/26/2019 Property Taxes 1273 04/29/2019 Property Taxes 1274 04/30/2019 Property Taxes (123,770.12) (40.76) (129.53) (86.89) (1.60) (115.81) (5.22) (207.67) (7.40) 1.91 (16.85) (33.05) (2.04) (82.32) 1.91 (5.15) (28.15) (37.92) (.27) (9.09) (123,810.88) (123,940.41) (124,027.30) (124,028.90) (124,144.71) (124,149.93) (124,357.60) (124,365.00) (124,363.09) (124,379.94) (124,412.99) (124,415.03) (124,497.35) (124,495.44) (124,500.59) (124,528.74) (124,566.66) (124,566.93) (124,576.02) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-000 Property Taxes Totals: (805.90) (124,576.02) ** (132,384.00) Budgeted (7,807.98) Remaining 94 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1255 04/01/2019 Property Taxes 1256 04/02/2019 Property Taxes 1261 04/10/2019 Property Taxes 1262 04/11/2019 Property Taxes 1272 04/26/2019 Property Taxes 1274 04/30/2019 Property Taxes (221.54) (1.26) (2.06) (22.91) (.05) (1.29) (1.25) (222.80) (224.86) (247.77) (247.82) (249.11) (250.36) GL GL GL GL GL GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (28.82) (250.36) ** (300.00) Budgeted (49.64) Remaining 83 % Used Account: 135-40015-000-000 Property Taxes/P & I 1255 04/01/2019 Property Taxes 1256 04/02/2019 Property Taxes 1257 04/03/2019 Property Taxes 1258 04/04/2019 Property Taxes 1259 04/05/2019 Property Taxes (392.47) (1.68) (394.15) (3.84) (397.99) (7.39) (405.38) (.13) (405.51) (10.46) (415.97) GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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 1260 04/08/2019 Property Taxes 1263 04/12/2019 Property Taxes 1265 04/16/2019 Property Taxes 1266 04/17/2019 Property Taxes 1267 04/18/2019 Property Taxes 1268 04/22/2019 Property Taxes 1270 04/24/2019 Property Taxes 1271 04/25/2019 Property Taxes 1272 04/26/2019 Property Taxes 1273 04/29/2019 Property Taxes 1274 04/30/2019 Property Taxes (392.47) (.37) (.81) (4.62) (3.63) (.20) (6.72) (1.41) (3.10) (5.48) (.07) (1.60) (416.34) (417.15) (421.77) (425.40) (425.60) (432.32) (433.73) (436.83) (442.31) (442.38) (443.98) GL GL GL GL GL GL GL GL GL GL GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (51.51) (443.98) ** (300.00) Budgeted 143.98 Remaining 148 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 Account: 135-40025-000-000 PID Surcharges milms Totals: .00 .00 ** (171,983.00) Budgeted (171,983.00) Remaining 0 % Used Account: 135-47000-000-000 Water 1217 04/11/2019 incorrect read on march bill U820190411-20190411 User: 1218 04/15/2019 incorrect read on march bill U820190415-20190415 User: 1219 04/16/2019 incorrect read on march bill U820190416-20190416 User: 1220 04/17/2019 incorrect read on march bill UB20190417-20190417 User: 1221 04/18/2019 incorrect read on march bill U820190418-20190418 User: 1222 04/22/2019 incorrect read on march bill UB20190422-20190422 User: 1223 04/23/2019 incorrect read on march bill U320190423-20190423 User: 1225 04/25/2019 incorrect read on march bill UB20190425-20190425 User: 1226 04/26/2019 incorrect read on march bill UB20190426-20190426 User: 1227 04/29/2019 incorrect read on march bill UB20190429-20190429 User: 1214 04/30/2019 UB 05/01/2019 Billing U820190430-20190430 User: (1,801,298.10) 5,811.26 10,923.15 3,464.09 1,535.73 942.49 212.95 1,925.07 56.68 12,170.48 1,995.29 (399,571.53) (1,795,486.84) (1,784,563.69) (1,781,099.60) (1,779,563.87) (1,778,621.38) (1,778,408.43) (1,776,483.36) (1,776,426.68) (1,764,256.20) (1,762,260.91) (2,161,832.44) UB UB U8 UB UB UB UB UB UB UB U8 Account: 135-47000-000-000 Water Totals: (360,534.34) (2,161,832.44) ** (6,599,484.00) Budgeted (4,437,651.56) Remaining 33 5 Used Account: 135-47005-000-000 Sewer 1218 04/15/2019 incorrect read on march bill UB20190415-20190415 User: (1,565,558.12) 1219 04/16/2019 incorrect read on march bill U820190416-20190416 User: 9,544.50 (1,556,013.62) UB 3,087.00 (1,552,926.62) UB glpdatb2 skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund JE Number JE Date 1220 04/17/2019 1221 04/18/2019 1223 04/23/2019 1224 04/24/2019 1226 04/26/2019 1227 04/29/2019 1214 04/30/2019 Account: 135-47005-000-000 Account: 135-47025-000-000 1120 04/10/2019 1139 04/15/2019 1179 04/23/2019 1198 04/29/2019 1199 04/29/2019 JE Description incorrect read on march incorrect read on march incorrect read on march incorrect read on march incorrect read on march incorrect read on march UB 05/01/2019 Billing 1 UB 04/10/2019 UB 04/15/2019 UB 04/23/2019 UB 04/29/2019 UB 04/29/2019 Account: 135-47025-000-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 4/2019 JE Detail Beginning Balance Description/Comment bill UB20190417-20190417 User: bill UB20190418-20190418 User: bill UB20190423-20190423 User: bill UB20190424-20190424 User: bill UB20190426-20190426 User: bill UB20190429-20190429 User: UB20190430-20190430 User: Sewer Totals: (3,412,665.00) Budgeted (1,565,558.12) (1,624,500.66) Remaining Penalties Penalty removal UB20190410-20190410 User: Penalty removal UB20190415-20190415 User: Penalties UB20190423-20190423 User: Penalty removal UB20190429-20190429 User: Penalty Removal UB20190429-20190429 User: 52 % Used (50,543.65) Penalties Totals: (136,418.00) Budgeted (78,809.36) Remaining Account: 135-47030-000-000 Service Charges 1052 04/04/2019 UB 04/04/2019 Disconnect Fees UB20190404-20190404 User: 1176 04/22/2019 UB 04/22/2019 NSF Check UB20190422-20190422 User: 42 % Used (8,425.00) Program: Transaction Detail Account: 135-47030-000-000 Service Charges Totals: (17,000.00) Budgeted (6,750.00) Remaining Account: 135-47035-000-000 Account: 135-47035-000-000 Account: 135-47045-000-000 Account: 135-47045-000-000 Plumbing Inspections Plumbing Inspections (1,500.00) Budgeted Sewer Inspections Sewer Inspections (4,500.00) Budgeted Totals: (750.00) Remaining 60 % Used (750.00) 50 % Used (2,250.00) 1,341.90 825.30 1,666.49 989.10 10,674.40 762.30 (251,497.21) Transaction Vendor_Name Detail (SUBTOTAL) (1,551,584.72) (1,550,759.42) (1,549,092.93) (1,548,103.83) (1,537,429.43) (1,536,667.13) (1,788,164.34) (222,606.22) (1,788,164.34) ** 93.70 (50,449.95) 60.74 (50,389.21) (7,316.58) (57,705.79) 79.87 (57,625.92) 17.28 (57,608.64) (7,064.99) 1(57,608.64) ** (1,800.00) (10,225.00) (25.00) (10,250.00) (1,825.00) .00 (750.00) .00 .00 (2,250.00) Totals: .00 (2,250 (2,250.00) Remaining 50 % Used Page 7 Check Source Number UB UB UB UB UB UB UB UB UB UB UB UB UB UB glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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-47070-000-000 ME TCCC Effluent Charges 1214 04/30/2019 UB 05/01/2019 Billing UB20190430-20190430 User: Account: 135-47070-000-000 Account: 135-49010-000-000 1240 04/30/2019 Bank Interest- April 1240 04/30/2019 Bank Interest- April 1240 04/30/2019 Bank Interest- April TCCC Effluent Charges Totals: (60,000.00) Budgeted (58,489.60) Remaining (22.40) (1,488.00) 3 % Used (1,510.40) UB (1,488.00) (1,510.40) ** Interest Income (63,781.16) (656.64) (64,437.80) GL (1,221.03) (65,658.83) GL (9,963.95) (75,622.78) GL Account: 135-49010-000-000 Interest Income Totals: (11,841.62) (75,622.78) ** (80,000.00) Budgeted Account: 135-49016-000-000 Cell Tower Revenue 1230 04/05/2019 Cell Tower Rev AT&T April 1231 04/30/2019 Cell Tower Rev AT&T May Account: 135-49016-000-000 (4,377.22) Remaining 95 % Used (7,399.53) (1,178.81) (8,578.34) (1,178.81) (9,757.15) Cell Tower Revenue Totals: (2,357.6- (9,757.15) ** (14,146.00) Budgeted (4,388.85) Remaining 69 % Used Account: 135-49018-000-000 Building Rent Income 1285 04/30/2019 Town Billed Invoices 1684-1687 AR 20190430-20190430 User: (3,499.98) GL GL (583.33) (4,083.31) AR Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (4,083.31) ** (7,000.00) Budgeted (2,916.69) Remaining 58 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets Account: 135-49026-000-000 (52,600.00) Proceeds from Sale of Assets Totals: (55,000.00) Budgeted (2,400.00) Remaining 96 % Used .00 (52,600.00) .00 (52,600.00) ** Account: 135-49035-000-000 Prior Year Reserves Account: 135-49035-000-000 .00 .00 Prior Year Reserves Totals: .00 .00 ** (358,600.00) Budgeted (358,600.00) Remaining 0 o Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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-49036-000-000 GASB Reserves 1322 04/30/2019 Budget Amendment Acct Transfr VFD- price increase FY17 Cap Account: 135-49036-000-000 GASB Reserves (266,613.00) Budgeted Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 Remaining 100 % Used (5,488.00) (266,613.00) (266,613.00) GL (266,613.00) (266,613.00) ** .00 (5,488.00) Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 (5,488.00) ** (18,522.00) Budgeted (13,034.00) Remaining Account: 135-49900-000-000 Miscellaneous Income 1297 04/26/2019 Aetna Self Funding 2018 Recon 1214 04/30/2019 UB 05/01/2019 Billing UB20190430-20190430 User: 1322 04/30/2019 Budget Amendment Acct Transfr Offset Exps- Rey -Mar Boring 30 % Used (9,627.76) (24,142.96) (33,770.72) GL (285.71) (34,056.43) UB 4,168.15 (29,888.28) GL Account: 135-49900-000-000 Miscellaneous Income Totals: (20,260.52) (29,888.28) ** (7,000.00) Budgeted 22,888.28 Remaining 427 % Used Account: 135-49901-000-000 Records Management Revenue 1233 04/30/2019 Open Records Request Account: 135-49901-000-000 (2.00) (2.00) (4.00) GL Records Management Revenue Totals: (2.00) (4.00) ** .00 Budgeted 4.00 Remaining 0 6 Used Department Totals: (4,591,692.70) ** (896,062.87) Monthly Total (11,343,415.00) Budgeted (6,751,722.30) Remaining 40 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 1031 04/05/2019 MUD Payroll 4/5/2019 Salaries & Wages 1141 04/19/2019 MUD Payroll 04/19/2019 Salaries & Wages Account: 135-50005-010-000 137,047.14 11,413.57 148,460.71 PR 11,979.43 160,440.14 PR Salaries & Wages Totals: 23,393.00 160,440.14 ** 326,755.00 Budgeted Account: 135-50010-010-000 Overtime 1031 04/05/2019 MUD Payroll 4/5/2019 Overtime 1141 04/19/2019 MUD Payroll 04/19/2019 Overtime Account: 135-50010-010-000 166,314.86 Remaining 49 % Used 5,312.77 713.12 6,025.89 PR 170.34 6,196.23 PR Overtime Totals: 883.46 6,196.23 ** 20,000.00 Budgeted Account: 135-50016-010-000 Longevity Account: 135-50016-010-000 Longevity Totals: 3,620.00 Budgeted .00 Remaining 13,803.77 Remaining 31 % Used Account: 135-50017-010-000 Certification 1141 04/19/2019 MUD Payroll 04/19/2019 Certification Account: 135-50017-010-000 3,620.00 100 % Used 1,100.00 Certification Totals: 4,800.00 Budgeted 3,525.00 Remaining 27 % Used Account: 135-50020-010-000 Retirement 1031 04/05/2019 MUD Payroll 4/5/2019 Retirement 1141 04/19/2019 MUD Payroll 04/19/2019 Retirement 14,656.21 .00 3,620.00 .00 3,620.00 ** 175.00 1,275.00 175.00 1,275.00 ** 1,121.71 15,777.92 1,140.05 16,917.97 PR PR PR Account: 135-50020-010-000 Retirement Totals: 2,261.76 16,917.97 ** 33,304.00 Budgeted Account: 135-50026-010-000 Medical Insurance 1031 04/05/2019 MUD Payroll 4/5/2019 Medical Insurance 1141 04/19/2019 MUD Payroll 04/19/2019 Medical Insurance Account: 135-50026-010-000 16,386.03 Remaining 51 % Used 21,505.44 2,109.86 23,615.30 2,109.82 25,725.12 Medical Insurance Totals: 4,219.68 25,725.12 ** 74,818.00 Budgeted 49,092.88 Remaining 34 6 Used PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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-010-000 Dental Insurance 1031 04/05/2019 MUD Payroll 4/5/2019 Dental Insurance 1141 04/19/2019 MUD Payroll 04/19/2019 Dental Insurance Account: 135-50027-010-000 Dental Insurance Totals: 4,317.00 Budgeted Account: 135-50028-010-000 Vision Insurance 1031 04/05/2019 MUD Payroll 4/5/2019 Vision Insurance 1141 04/19/2019 MUD Payroll 04/19/2019 Vision Insurance 1,425.60 130.80 1,556.40 PR 130.75 1,687.15 PR 2,629.85 Remaining 39 % Used 5 1,687.15 ** 235.17 21.25 256.42 PR 21.22 277.64 PR Account: 135-50028-010-000 Vision Insurance Totals: 42.47 277.64 ** Account: 135-50029-010-000 1014 04/01/2019 April A/P 1026 04/01/2019 April A/P 1209 04/30/2019 April A/P 701.00 Budgeted Life Insurance & Other Employee LTD & STD Employee Benefits Caf 125 423.36 Remaining 40 % Used 1,297.78 91.11 1,388.89 METLIFE GROUP BENEFITS 98.56 1,487.45 Humana Inc 20.00 1,507.45 BenefitMall 5151 AP 5185 AP 5237 AP Account: 135-50029-010-000 Life Insurance & Other Totals: 209.67 1,507.45 ** 3,131.00 Budgeted 1,623.55 Remaining 48 % Used Account: 135-50030-010-000 Social Security Taxes 1031 04/05/2019 MUD Payroll 4/5/2019 Social Security Taxes 1141 04/19/2019 MUD Payroll 04/19/2019 Social Security Taxes Account: 135-50030-010-000 Social Security Taxes Totals: 22,021.00 Budgeted Account: 135-50035-010-000 Medicare Taxes 1031 04/05/2019 MUD Payroll 4/5/2019 Medicare Taxes 1141 04/19/2019 MUD Payroll 04/19/2019 Medicare Taxes 8,900.16 11,648.62 Remaining 47 % Used 2,081.49 742.05 730.17 1,472.22 9,642.21 10,372.38 10,372.38 ** 173.54 2,255.03 170.76 2,425.79 PR PR PR PR Account: 135-50035-010-000 Medicare Taxes Totals: 344.30 2,425.79 ** 5,150.00 Budgeted 2,724.21 Remaining 47 % Used Account: 135-50040-010-000 Unemployment Taxes 767.78 .00 767.78 glpdatb2 skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 4/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 12 Check Source Number 1059 04/04/2019 April A/P 1155 04/18/2019 April A/P 1180 04/23/2019 April A/P 1215 04/26/2019 PCard 3/27/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1322 04/30/2019 Budget Amendment Acct Transfr New tap & bore 2" valves Valve repair @ bank of america fridge part for water breakrom purple primer pvc cement 18 R/ llb roll Offset with Revenue 90,107.54 4,168.15 455.00 6,775.94 41.86 13.71 23.50 (4,168.15) 94,275.69 94,730.69 101,506.63 101,548.49 101,562.20 101,585.70 97,417.55 REY-MAR CONSTRUCTION Core & Main LP REY-MAR CONSTRUCTION AMAZON.COM*MZ3QR3Z72 THE HOME DEPOT 66581 TEX-TURF 5188 5212 5228 AP AP AP PC PC PC GL Account: 135-55080-010-000 Maintenance & Repairs Totals: 7,310.01 97,417.55 ** 153,000.00 Budgeted 55,582.45 Remaining 64 % Used Account: 135-50040-010-000 Unemployment Taxes Totals: .00 767.78 ** 1,080.00 Budgeted 312.22 Remaining 71 % Used Account: 135-50045-010-000 Workman's Compensation 131 04/01/2019 Insurance/Wrk Comp Expense Apr 5,315.04 930.94 6,245.98 GL Account: 135-50045-010-000 Workman's Compensation Totals: 930.94 6,245.98 ** 12,895.00 Budgeted 6,649.02 Remaining 48 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations .00 .00 Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1059 04/04/2019 April A/P 1155 04/18/2019 April A/P 1180 04/23/2019 April A/P 1215 04/26/2019 PCard 3/27/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1322 04/30/2019 Budget Amendment Acct Transfr New tap & bore 2" valves Valve repair @ bank of america fridge part for water breakrom purple primer pvc cement 18 R/ llb roll Offset with Revenue 90,107.54 4,168.15 455.00 6,775.94 41.86 13.71 23.50 (4,168.15) 94,275.69 94,730.69 101,506.63 101,548.49 101,562.20 101,585.70 97,417.55 REY-MAR CONSTRUCTION Core & Main LP REY-MAR CONSTRUCTION AMAZON.COM*MZ3QR3Z72 THE HOME DEPOT 66581 TEX-TURF 5188 5212 5228 AP AP AP PC PC PC GL Account: 135-55080-010-000 Maintenance & Repairs Totals: 7,310.01 97,417.55 ** 153,000.00 Budgeted 55,582.45 Remaining 64 % Used glpdatb2 skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Department: Trophy Club MUD No.1 Detailed Accounting Trial Balance 10 Water Period Ending: 4/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Account: 135-55085-010-000 Generator Maint. and Repair Account: 135-55085-010-000 Generator Maint. and Repair Totals: 3,000.00 Budgeted 1,093.70 Remaining 1,906.30 64 % Used 1 .00 .00 Transaction Vendor_Name Detail (SUBTOTAL) 1,906.30 1,906.30 ** Page 13 Check Source Number Account: 135-55090-010-000 Vehicle Maintenance 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 Account: 135-55090-010-000 Account: 135-55105-010-000 Account: 135-55105-010-000 Account: 135-55120-010-000 Account: 135-55120-010-000 Account: 135-55135-010-000 1116 04/10/2019 April A/P 1116 04/10/2019 April A/P 1209 04/30/2019 April A/P 1209 04/30/2019 April A/P 1245 04/30/2019 April A/P 1245 04/30/2019 April A/P 1307 04/30/2019 April A/P Account: 135-55135-010-000 Account: 135-60010-010-000 • oil change battery battery Vehicle Maintenance 5,000.00 Budgeted Totals: 2,854.77 Remaining Maintenance-Backhoe/SkidLoader Maintenance-Backhoe/SkidLoader Totals: 3,500.00 Budgeted 3,500.00 Remaining Cleaning Services Cleaning Services 5,214.00 Budgeted Lab Analysis chemicals chemicals lab testing lab testing Lab testing lab testing water samples Lab Analysis 6,500.00 Budgeted Communications/Mobiles Totals: 5,214.00 Remaining Totals: 1,452.60 Remaining 1,642.80 233.45 1,876.25 GIERISCH CARE 0050292 122.99 1,999.24 ROANOKE AUTO SUPPLY LT 145.99 2,145.23 ROANOKE AUTO SUPPLY LT 3,170.20 43 % Used O % Used O % Used 78 % Used 502.43 .00 .00 .00 .00 2,145.23 ** .00 .00 ** .00 .00 ** 317.40 3,487.60 230.00 3,717.60 230.00 3,947.60 317.40 4,265.00 317.40 4,582.40 230.00 4,812.40 235.00 5,047.40 PC PC PC OXIDOR LABORATORIES LLC 5202 AP OXIDOR LABORATORIES LLC 5202 AP OXIDOR LABORATORIES LLC 5244 AP OXIDOR LABORATORIES LLC 5244 AP OXIDOR LABORATORIES LLC 5258 AP OXIDOR LABORATORIES LLC 5258 AP TARRANT CTY PUBLIC HEALTH LAB AP 5,047.40 ** glpdatb2 skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1116 04/10/2019 April A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 4/2019 JE Detail Beginning Balance Description/Comment Cell phones -April 1,881.14 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 285.29 2,166.43 VERIZON WIRELESS Page 14 Check Source Number 5207 AP Account: 135-60010-010-000 Communications/Mobiles Totals: 285.29 2,166.43 ** 5,000.00 Budgeted 2,833.57 Remaining 43 % Used Account: 135-60020-010-000 Electricity 1155 04/18/2019 April A/P Electricity 3/11-4/9 49,977.64 8,639.51 58,617.15 HUDSON ENERGY SERVICES, LLC 5219 AP Account: 135-60020-010-000 Electricity Totals: 8,639.51 58,617.15 ** 154,204.00 Budgeted 95,586.85 Remaining 38 5 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 ' 61.00 .00 61.00 Account: 135-60070-010-000 Dues & Memberships Totals: .00 61.00 ** 500.00 Budgeted 439.00 Remaining 12 5 Used Account: 135-60080-010-000 Schools & Training 1215 04/26/2019 PCard 3/27/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 water utility safety class - 4/26/2019 Texas Water 996.00 485.00 555.00 1,481.00 2,036.00 SUNCOAST LEARNING SYST TEXAS WATER PC PC Account: 135-60080-010-000 Schools & Training Totals: 1,040.00 2,036.00 ** 4,651.00 Budgeted 2,615.00 Remaining 44 % Used Account: 135-60090-010-000 Safety Program .00 .00 Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1141 04/19/2019 MUD Payroll 04/19/2019 Travel & per diem 295.39 295.39 PR 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 parking 7.00 302.39 LAM PARKING II, LTD PC 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 parking 7.00 309.39 LAM PARKING II, LTD PC Account: 135-60100-010-000 • Travel & per diem Totals: 2,345.00 Budgeted 2,035.61 Remaining 13 % Used 309.39 9.39 ** Account: 135-60105-010-000 Rent/Lease Equipment Account: 135-60105-010-000 Rent/Lease Equipment 1,500.00 Budgeted Account: 135-60135-010-000 TCEQ Fees & Permits 1307 04/30/2019 April A/P well water charge .00 .00 Totals: .00 1,500.00 Remaining 0 % Used 12,124.23 4,212.30 16,336.53 North Texas Groundwater AP Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 4,212.30 16,336.53 ** 58,000.00 Budgeted Account: 135-60150-010-000 Wholesale Water 1209 04/30/2019 April A/P wholesale water 41,663.47 Remaining 28 5 Used 590,339.29 126,312.22 716,651.51 CITY OF FORT WORTH 5238 AP Account: 135-60150-010-000 Wholesale Water Totals: 126,312.22 716,651.51 ** 3,013,494.00 Budgeted Account: 135-60245-010-000 Miscellaneous Expenses 2,296,842.49 Remaining 24 % Used .00 .00 Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 336.00 .00 336.00 Account: 135-60280-010-000 Property Maintenance Totals: .00 336.00 ** 3,000.00 Budgeted 2,664.00 Remaining 11 5 Used Account: 135-60285-010-000 Lawn Equipment & Maintenance glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2,840.00 .00 2,840.00 Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 2,840.00 ** 14,750.00 Budgeted 11,910.00 Remaining Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S 1207 04/30/2019 TexPool Transfers April TexPool O&M to 16Swift Rev I&S 19 % Used 151,036.86 25,172.81 176,209.67 GL Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 585,209.00 Budgeted 408,999.33 Remaining Account: 135-60333-010-000 Interfund Transfer Out -Reserve 1207 04/30/2019 TexPool Transfers April TexPool O&M to Rev Bond Resevr Account: 135-60333-010-000 25,172.81 176,209.67 ** 30 % Used 27,600.00 4,600.00 32,200.00 GL Interfund Transfer Out -Reserve Totals: 4,600.00 32,200.00 ** 55,193.00 Budgeted 22,993.00 Remaining Account: 135-60334-010-000 Interfund Transfer Out 58 % Used .00 Account: 135-60334-010-000 Interfund Transfer Out1 Totals: .00 200,000.00 Budgeted 200,000.00 Remaining 0 5 Used Account: 135-60360-010-000 Furniture/Equipment < $5000 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 Account: 135-65005-010-000 1193 04/24/2019 Fuel Account: 135-65005-010-000 Account: 135-65010-010-000 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Fuel & Lube Fuel Fuel & Lube Totals: 15,000.00 Budgeted Uniforms .00 .00 ** .00 .00 ** 4,708.27 1,034.84 5,743.11 US Bank Voyager Fleet Systems 5249 AP 9,256.89 Remaining 38 6 Used 1,417.41 1,034.84 5,743.11 ** .00 1,417.41 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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-65010-010-000 Uniforms Totals: .00 1,417.41 ** 5,190.00 Budgeted 3,772.59 Remaining 27 % Used Account: 135-65030-010-000 Chemicals 1170 04/22/2019 April A/P testing supplies 11,336.68 746.26 12,082.94 HACH COMPANY 5217 AP 1170 04/22/2019 April A/P testing supplies 37.40 12,120.34 HACH COMPANY 5217 AP 1209 04/30/2019 April A/P ammonia 445.88 12,566.22 Valley Solvent Company, INC 5250 AP 1209 04/30/2019 April A/P chlorine 781.77 13,347.99 DPC INDUSTRIES, INC 5239 AP 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 Account: 135-65050-010-000 Chemicals 20,000.00 Budgeted Small Tools Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,000.00 Budgeted Meter Expense Totals: 6,652.01 Remaining 67 % Used 2,011.31 13,347.99 ** .00 .00 Totals: 1,200.00 Remaining 0 % Used .00 .00 ** .00 .00 Totals: 1,000.00 Remaining 0 % Used Meter Expense Totals: 70,000.00 Budgeted Account: 135-65053-010-000 Meter Change Out Program 1209 04/30/2019 April A/P meter heads Account: 135-65053-010-000 17,861.60 .00 .00 ** .00 17,861.60 52,138.40 Remaining 26 % Used Meter Change Out Program Totals: 87,000.00 Budgeted 54,738.00 Remaining Account: 135-69005-010-000 Capital Outlays .00 17,861.60 ** 31,482.00 780.00 32,262.00 ATLAS UTILITY SUPPLY CO. 37 % Used 780.00 32,262.00 ** 5236 AP glpdatb2 skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1321 04/01/2019 Due To/From -Fund 520 1312 04/30/2019 April A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 4/2019 Page 18 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) VFD water plant 429,046.77 (148,142.51) 5,820.00 280,904.26 286,724.26 CPLY/WALLACE GROUP, INC. GL AP Account: 135-69005-010-000 Capital Outlays Totals: (142,322.51) 286,724.26 ** 719,613.00 Budgeted 432,888.74 Remaining 40 % Used Account: 135-69008-010-000 Short Term Debt -Principal 30,068.00 .00 30,068.00 Account: 135-69008-010-000 Short Term Debt -Principal Totals: .00 30,068.00 ** 30,068.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt -Interest 2,283.93 .00 2,283.93 Account: 135-69009-010-000 Short Term Debt -Interest Totals: .00 2,283.93 ** 4,124.00 Budgeted 1,840.07 Remaining 55 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 99,877.11 .00 99,877.11 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 99,877.11 ** 120,000.00 Budgeted 20,122.89 Remaining 83 % Used Account: 135-70040-010-000 Bond Related Expenses 7,080.00 .00 7,080.00 Account: 135-70040-010-000 Bond Related Expenses Totals: .00 7,080.00 ** .00 Budgeted (7,080.00) Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/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-001 Lab Analysis for PID 1155 04/18/2019 April A/P water samples 1307 04/30/2019 April A/P water samples PID 815.40 80.00 895.40 TARRANT CTY PUBLIC HEALTH LAB 5229 AP 80.00 975.40 TARRANT CTY PUBLIC HEALTH LAB AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 160.00 975.40 ** 2,000.00 Budgeted 1,024.60 Remaining 49 9 Used Department 10 Totals: 1,924,379.60 ** 76,118.85 Monthly Total 5,961,447.00 Budgeted 4,037,067.40 Remaining 32 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 1031 04/05/2019 MUD Payroll 4/5/2019 Salaries & Wages 1141 04/19/2019 MUD Payroll 04/19/2019 Salaries & Wages Account: 135-50005-020-000 157,491.76 13,081.44 170,573.20 PR 13,640.69 184,213.89 PR Salaries & Wages Totals: 26,722.13 184,213.89 ** 421,699.00 Budgeted Account: 135-50010-020-000 Overtime 1031 04/05/2019 MUD Payroll 4/5/2019 Overtime 1141 04/19/2019 MUD Payroll 04/19/2019 Overtime 237,485.11 Remaining 44 9 Used 16,191.92 3,553.57 19,745.49 PR 1,182.66 20,928.15 PR Account: 135-50010-020-000 Overtime Totals: 4,736.23 20,928.15 ** 30,000.00 Budgeted Account: 135-50016-020-000 Longevity Account: 135-50016-020-000 Longevity Totals: 7,445.00 Budgeted .00 Remaining 9,071.85 Remaining 70 % Used Account: 135-50017-020-000 Certification 1141 04/19/2019 MUD Payroll 04/19/2019 Certification 7,445.00 .00 7,445.00 .00 100 % Used 4,300.00 700.00 5,000.00 PR Account: 135-50017-020-000 Certification Totals: 8,700.00 Budgeted 700.00 5,000.00 ** Account: 135-50020-020-000 Retirement 1031 04/05/2019 MUD Payroll 4/5/2019 Retirement 1141 04/19/2019 MUD Payroll 04/19/2019 Retirement 3,700.00 Remaining 57 9 Used 18,668.85 1,538.73 20,207.58 1,435.92 21,643.50 PR PR Account: 135-50020-020-000 Retirement Totals: 2,974.65 21,643.50 ** 43,276.00 Budgeted Account: 135-50026-020-000 Medical Insurance 1031 04/05/2019 MUD Payroll 4/5/2019 Medical Insurance 1141 04/19/2019 MUD Payroll 04/19/2019 Medical Insurance Account: 135-50026-020-000 21,632.50 Remaining 50 % Used 32,706.42 2,794.26 35,500.68 2,794.22 38,294.90 Medical Insurance Totals: 5,588.48 38,294.90 ** 91,627.00 Budgeted 53,332.10 Remaining 42 % Used PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-020-000 Dental Insurance 1031 04/05/2019 MUD Payroll 4/5/2019 Dental Insurance 1141 04/19/2019 MUD Payroll 04/19/2019 Dental Insurance Account: 135-50027-020-000 2,137.35 170.29 2,307.64 PR 170.27 2,477.91 PR Dental Insurance Totals: 340.56 2,477.91 ** 5,104.00 Budgeted Account: 135-50028-020-000 Vision Insurance 1031 04/05/2019 MUD Payroll 4/5/2019 Vision Insurance 1141 04/19/2019 MUD Payroll 04/19/2019 Vision Insurance 2,626.09 Remaining 49 % Used 343.62 27.83 371.45 PR 27.81 399.26 PR Account: 135-50028-020-000 Vision Insurance Totals: 55.64 399.26 ** Account: 135-50029-020-000 1014 04/01/2019 April A/P 1026 04/01/2019 April A/P 1209 04/30/2019 April A/P 826.00 Budgeted Life Insurance & Other Employee LTD & STD Employee Benefits Caf 125 426.74 Remaining 48 % Used 1,836.19 162.14 1,998.33 METLIFE GROUP BENEFITS 184.80 2,183.13 Humana Inc 38.00 2,221.13 BenefitMall 5151 AP 5185 AP 5237 AP Account: 135-50029-020-000 Life Insurance & Other Totals: 384.94 2,221.13 ** 4,495.00 Budgeted 2,273.87 Remaining 49 % Used Account: 135-50030-020-000 Social Security Taxes 1031 04/05/2019 MUD Payroll 4/5/2019 Social Security Taxes 1141 04/19/2019 MUD Payroll 04/19/2019 Social Security Taxes Account: 135-50030-020-000 Social Security Taxes Totals: 29,006.00 Budgeted Account: 135-50035-020-000 Medicare Taxes 1031 04/05/2019 MUD Payroll 4/5/2019 Medicare Taxes 1141 04/19/2019 MUD Payroll 04/19/2019 Medicare Taxes 10,787.09 16,327.84 Remaining 44 % Used 2,522.79 992.54 898.53 1,891.07 11,779.63 12,678.16 12,678.16 ** 232.13 2,754.92 210.13 2,965.05 PR PR PR PR Account: 135-50035-020-000 Medicare Taxes Totals: 442.26 2,965.05 ** 6,784.00 Budgeted 3,818.95 Remaining 44 % Used Account: 135-50040-020-000 Unemployment Taxes 972.00 .00 972.00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-50040-020-000 Unemployment Taxes Totals: 1,260.00 Budgeted 288.00 Remaining 77 % Used Account: 135-50045-020-000 Workman's Compensation 131 04/01/2019 Insurance/Wrk Comp Expense Apr 6,884.58 Account: 135-50045-020-000 Workman's Compensation Totals: 16,941.00 Budgeted Account: 135-50060-020-000 Pre-emp Physicals/Testing Account: 135-50060-020-000 Account: 135-50070-020-000 Account: 135-50070-020-000 8,850.69 Remaining 48 % Used Pre-emp Physicals/Testing Totals: 400.00 Budgeted 362.00 Remaining Employee Relations Employee Relations Totals: 300.00 Budgeted Account: 135-55005-020-000 Engineering Account: 135-55005-020-000 38.00 10 % Used 300.00 Remaining 0 % Used Engineering Totals: 30,000.00 Budgeted Account: 135-55070-020-000 Independent Labor Account: 135-55070-020-000 Account: 135-55080-020-000 1059 04/04/2019 April A/P 1116 04/10/2019 April A/P 30,000.00 Remaining 0 % Used Independent Labor Totals: 15,000.00 Budgeted Maintenance & Repairs Welding at WWTP LS #9 repairs 2,921.00 12,079.00 Remaining 19 % Used .00 972.00 ** 1,205.73 8,090.31 GL 1,205.73 8,090.31 ** .00 38.00 .00 38.00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 2,921.00 .00 2,921.00 ** 86,808.52 300.00 87,108.52 REY-MAR CONSTRUCTION 5188 AP 1,240.00 88,348.52 DHS AUTOMATION, INC 5194 AP glpdatb2 skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1116 04/10/2019 April A/P 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1307 04/30/2019 April A/P Account: 135-55080-020-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 4/2019 JE Detail Beginning Balance Description/Comment towels & rags grinding wire brush filters for blowers hose, bands, gaskets, etc clevis for chains light bulbs for barn light bulbs for barn light bulbs for barn Bags for grit dumpsters Maintenance & Repairs Totals: 133,000.00 Budgeted 41,886.39 Remaining 86,808.52 Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) 122.50 88,471.02 18.68 88,489.70 345.71 88,835.41 803.92 89,639.33 31.96 89,671.29 (89.97) 89,581.32 142.32 89,723.64 89.97 89,813.61 1,300.00 91,113.61 69 % Used 4,305.09 Ritz Safety, LLC THE HOME DEPOT 6581 FILTER ELEMENT STORE INT*IN *HOSE TECH USA TRACTOR SUPPLY COMPANY THE HOME DEPOT 6581 THE HOME DEPOT #6581 THE HOME DEPOT 6581 Huber Technology Inc 91,113.61 ** Page 23 Check Source Number 5203 AP PC PC PC PC PC PC PC AP Account: 135-55085-020-000 Generator Maint. and Repair Account: 135-55085-020-000 Account: 135-55090-020-000 Generator Maint. and Repair Totals: 10,000.00 Budgeted 5,449.18 Remaining Vehicle Maintenance 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 tires 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 oil change 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 windshield fluid Account: 135-55090-020-000 . Vehicle Maintenance Totals: 8,000.00 Budgeted 6,549.46 Remaining 4,550.82 .00 46 % Used .00 4,550.82 4,550.82 ** 1,119.39 241.50 1,360.89 DISCOUNT TIRE TXD 75 83.67 1,444.56 GIERISCH CARE 0050292 5.98 1,450.54 TRACTOR SUPPLY COMPANY 18 6 Used 331.15 1,450.54 ** Account: 135-55105-020-000 ■ . Maintenance-Backhoe/SkidLoader Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 7,000.00 Budgeted 197.00 Remaining 6,803.00 .00 97 % Used .00 6,803.00 6,803.00 ** Account: 135-55120-020-000 Cleaning Services .00 .00 Account: 135-55120-020-000 Cleaning Services Totals: .00 .00 ** 5,214.00 Budgeted 5,214.00 Remaining 0 % Used . . . . . PC PC PC glpdatb2 skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Account: 135-55125-020-000 1209 04/30/2019 April A/P 1252 04/30/2019 April A/P Account: 135-55125-020-000 Account: 135-55135-020-000 1116 04/10/2019 April A/P 1116 04/10/2019 April A/P 1116 04/10/2019 April A/P 1155 04/18/2019 April A/P 1155 04/18/2019 April A/P 1155 04/18/2019 April A/P 1155 04/18/2019 April A/P 1252 04/30/2019 April A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 4/2019 JE Detail Beginning Balance Description/Comment Dumpster Services sludge to landfill Sludge to landfill Dumpster Services 75,000.00 Budgeted Totals: 32,685.76 Remaining Lab Analysis Waste water sampling lab supplies chemicalks lab testing lab testing lab testing lab testing DO -meter cable 38,705.66 23,731.34 56 % Used Program: Transaction Detail 1,814.64 1,793.94 3,608.58 Transaction Vendor_Name Detail (SUBTOTAL) 40,520.30 L.H. CHANEY MATERIALS, INC. 42,314.24 L.H. CHANEY MATERIALS, INC. 42,314.24 ** 877.80 24,609.14 480.67 25,089.81 427.04 25,516.85 317.40 25,834.25 230.00 26,064.25 317.40 26,381.65 230.00 26,611.65 933.51 27,545.16 Centralized Water 6 Wastewater IDEXX DISTRIBUTION, INC IDEXX DISTRIBUTION, INC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC HACH COMPANY Page 24 Check Source Number 5242 AP 5256 AP 5190 5196 5196 5227 5227 5227 5227 5254 AP AP AP AP AP AP AP AP Account: 135-55135-020-000 Lab Analysis Totals: 3,813.82 27,545.16 ** Account: 135-60010-020-000 1116 04/10/2019 April A/P 1245 04/30/2019 April A/P 35,000.00 Budgeted 7,454.84 Remaining Communications/Mobiles Cell phones -April annual monitoring fee -PID 2,345.99 79 % Used 418.14 276.00 2,764.13 VERIZON WIRELESS 3,040.13 OMNISITE 5207 AP 5257 AP Account: 135-60010-020-000 Communications/Mobiles Totals: 694.14 3,040.13 ** 5,000.00 Budgeted 1,959.87 Remaining Account: 135-60020-020-000 Electricity 1126 04/11/2019 April A/P Electricity 4/4/2019 1155 04/18/2019 April A/P Electricity 3/11-4/9 1285 04/30/2019 Town Billed Invoices 1684-1687 AR 20190430-20190430 User: 1314 04/30/2019 April A/P Electricity 3/28-4/29 Account: 135-60020-020-000 Electricity 174,165.00 Budgeted Totals: 86,314.51 Remaining 61 % Used 76,406.15 586.22 76,992.37 TRI COUNTY ELECTRIC 10,663.94 87,656.31 HUDSON ENERGY SERVICES, LLC (367.51) 87,288.80 561.69 87,850.49 TRI COUNTY ELECTRIC 50 % Used 11,444.34 87,850.49 ** 5210 AP 5219 AP AR AP Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-60066-020-000 Publications/Books/Subscripts Totals: 200.00 Budgeted 200.00 Remaining Account: 135-60070-020-000 Dues & Memberships 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 orly license renewal 69.00 Account: 135-60070-020-000 Account: 135-60080-020-000 Account: 135-60080-020-000 Account: 135-60090-020-000 Account: 135-60090-020-000 Dues 6 Memberships 300.00 Budgeted Schools & Training Schools & Training 7,155.00 Budgeted Safety Program 0 6 Used Totals: 120.00 Remaining 60 6 Used 862.95 Totals: 6,292.05 Remaining 12 % Used .00 .00 ** 111.00 180.00 TCEQ IND RENEWAL LIC PC 111.00 .00 .00 100.74 .00 Safety Program Totals: .00 1,000.00 Budgeted Account: 135-60100-020-000 Travel & per diem Account: 135-60100-020-000 899.26 Remaining 10 6 Used 174.96 .00 Travel & per diem Totals: .00 1,895.00 Budgeted Account: 135-60105-020-000 Rent/Lease Equipment 1170 04/22/2019 April A/P Account: 135-60105-020-000 1,720.04 Remaining 9 6 Used 6" pump rental 3,491.07 Rent/Lease Equipment Totals: 3,491.07 5,000.00 Budgeted Account: 135-60125-020-000 Advertising 1,508.93 Remaining 70 % Used 180.00 ** 862.95 862.95 ** 100.74 100.74 ** 174.96 174.96 ** 3,491.07 United Rentals (North America) 5232 AP 3,491.07 ** .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-60125-020-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 16,545.22 .00 16,545.22 Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 16,545.22 ** 30,000.00 Budgeted 13,454.78 Remaining 55 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 225.18 .00 225.18 Account: 135-60280-020-000 Property Maintenance Totals: .00 225.18 ** 5,000.00 Budgeted 4,774.82 Remaining 5 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 fuel filter pump 1,884.01 36.99 1,921.00 KYLES SMALL ENGINE REP PC 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 roundup weed killer, diablo, o 69.73 1,990.73 THE HOME DEPOT 6581 PC Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 11,600.00 Budgeted 9,609.27 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 1207 04/30/2019 TexPool Transfers April TexPool O&M to I&S- PID Debt Account: 135-60331-020-000 Interfund Transfer Out -Tax ISS Totals: 120,053.00 Budgeted 43,655.70 Remaining Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 1207 04/30/2019 TexPool Transfers April TexPool O&M to Rev Bd WWTP I&S 106.72 1,990.73 ** 17 % Used 65,483.40 10,913.90 76,397.30 GL 10,913.90 76,397.30 ** 64 % Used 325,220.70 54,203.45 379,424.15 GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-60332-020-000 Interfund Transfer Out -Rev ISS Totals: 688,330.00 Budgeted 308,905.85 Remaining 55 % Used 54,203.45 379,424.15 ** Account: 135-60333-020-000 Interfund Transfer Out -Reserve 1207 04/30/2019 TexPool Transfers April TexPool O&M to Rev Bond Resevr 62,592.00 10,432.00 73,024.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 10,432.00 73,024.00 ** 125,187.00 Budgeted 52,163.00 Remaining 58 % Used Account: 135-60334-020-000 Interfund Transfer Out 00 .00 Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 1193 04/24/2019 Fuel Fuel 6,195.85 702.44 6,898.29 US Bank Voyager Fleet Systems 5249 AP Account: 135-65005-020-000 Account: 135-65010-020-000 Account: 135-65010-020-000 Fuel & Lube Totals: 702.44 6,898.29 ** 12,500.00 Budgeted 5,601.71 Remaining 55 % Used Uniforms 2,059.90 .00 2,059.90 Uniforms Totals: .00 2,059.90 ** 5,495.00 Budgeted 3,435.10 Remaining 37 % Used Account: 135-65030-020-000 Chemicals 1116 04/10/2019 April A/P chemicals 16,301.24 547.00 16,848.24 Valley Solvent Company, INC 1155 04/18/2019 April A/P checmicals 547.00 17,395.24 Valley Solvent Company, INC 5206 AP 5233 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1155 04/18/2019 April A/P 1209 04/30/2019 April A/P Account: 135-65030-020-000 chemicals polymer Chemicals 30,000.00 Budgeted 16,301.24 547.00 17,942.24 Valley Solvent Company, INC Totals: 9,201.16 Remaining 69 5 Used 5233 AP 2,856.60 20,798.84 POLYDYNE, INC 5245 AP 4,497.60 20,798.84 ** Account: 135-65035-020-000 Small Tools Account: 135-65035-020-000 Account: 135-65040-020-000 Account: 135-65040-020-000 Small Tools Totals: 1,200.00 Budgeted Safety Equipment Safety Equipment 1,200.00 Budgeted Account: 135-65045-020-000 Lab Supplies 1,145.05 Remaining 54.95 1,095.69 .00 5 % Used 54.95 .00 54.95 ** .00 1,095.69 Totals: 104.31 Remaining 91 % Used .00 1,095.69 ** Account: 135-65045-020-000 Lab Supplies 20,000.00 Budgeted 3,349.83 Totals: .00 3,349.83 � nn 16,650.17 Remaining 17 % Used 3,349.83 ** Account: 135-69005-020-000 Capital Outlays 1155 04/18/2019 April A/P 1178 04/23/2019 April A/P WWTP 485,751.87 1,530.00 Crane to pull MBR's 2,890.50 487,281.87 Dubois Bryant Campbell LLP 5215 AP 490,172.37 Wildcat Cranes 5235 AP Account: 135-69005-020-000 Capital Outlays Totals: 4,420.50 490,172.37 ** 688,600.00 Budgeted 198,427.63 Remaining 71 % Used Account: 135-69008-020-000 Short Term Debt -Principal 39,858.59 .00 39,858.59 Account: 135-69008-020-000 Short Term Debt -Principal Totals: .00 39,858.59 ** 109,858.00 Budgeted 69,999.41 Remaining 36 % Used Account: 135-69009-020-000 Short Term Debt -Interest glpdatb2 skrolczyk 14:47 05/15/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: 4/2019 JE Detail Beginning Balance Description/Comment 3,027.55 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 3,027.55 Page 29 Check Source Number Department 20 Totals: .00 Budgeted 158,117.49 Monthly Total (1,500.00) Remaining 0 % Used 1,726,188.56 ** 3,281,182.00 Budgeted 1,554,993.44 Remaining 53 % Used Account: 135-69009-020-000 Short Term Debt -Interest Totals: .00 3,027.55 ** 14,917.00 Budgeted 11,889.45 Remaining 20 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Account: 135-70020-020-000 Capital Lease Issuance Cost 1,500.00 .00 1,500.00 Account: 135-70020-020-000 Capital Lease Issuance Cost Totals: .00 1,500.00 ** Department 20 Totals: .00 Budgeted 158,117.49 Monthly Total (1,500.00) Remaining 0 % Used 1,726,188.56 ** 3,281,182.00 Budgeted 1,554,993.44 Remaining 53 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/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 131 04/01/2019 Insurance/Wrk Comp Expense Apr 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 12.72 2.12 14.84 GL 15.16 Remaining 49 % Used 2.12 14.84 ** .00 0 % Used .00 .00 .00 ** Account: 135-60070-026-000 Dues & Memberships Dues & Memberships 750.00 Budgeted Account: 135-60070-026-000 650.00 .00 650.00 Totals: 100.00 Remaining 87 6 Used .00 650.00 ** Account: 135-60075-026-000 Meetings Account: 135-60075-026-000 Meetings 1,300.00 Budgeted 34.38 Totals: 1,265.62 Remaining 3 % Used .00 34.38 .00 34.38 ** Account: 135-60080-026-000 Schools & Training Account: 135-60080-026-000 Schools & Training 4,000.00 Budgeted 920.00 Totals: 3,080.00 Remaining 23 % Used .00 920.00 .00 920.00 ** Account: 135-60100-026-000 Travel & per diem 338.57 .00 338.57 Account: 135-60100-026-000 Travel & per diem Totals: .00 338.57 ** 5,000.00 Budgeted Account: 135-60245-026-000 Miscellaneous Expenses 4,661.43 Remaining 7 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/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 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: 1,957.79 ** 2.12 Monthly Total 13,230.00 Budgeted 11,272.21 Remaining 15 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-030-000 Salaries & Wages 1031 04/05/2019 MUD Payroll 4/5/2019 Salaries & Wages 1141 04/19/2019 MUD Payroll 04/19/2019 Salaries & Wages 170,645.69 14,114.51 184,760.20 PR 14,633.93 199,394.13 PR Account: 135-50005-030-000 Salaries & Wages Totals: 28,748.44 199,394.13 ** 441,006.00 Budgeted 241,611.87 Remaining 45 % Used Account: 135-50010-030-000 Overtime 1031 04/05/2019 MUD Payroll 4/5/2019 Overtime 47.40 4.13 51.53 PR Account: 135-50010-030-000 Overtime Totals: 4.13 51.53 ** 2,000.00 Budgeted 1,948.47 Remaining 3 5 Used Account: 135-50016-030-000 Longevity 1,832.50 .00 1,832.50 Account: 135-50016-030-000 Longevity Totals: 1,832.50 ** .50 Remaining 100 % Used 1,833.00 Budgeted Account: 135-50020-030-000 Retirement 1031 04/05/2019 MUD Payroll 4/5/2019 Retirement 1141 04/19/2019 MUD Payroll 04/19/2019 Retirement Account: 135-50020-030-000 17,318.82 1,305.97 18,624.79 PR 1,353.64 19,978.43 PR 11111 Retirement Totals: 2,659.61 19,978.43 ** 41,148.00 Budgeted Account: 135-50026-030-000 Medical Insurance 1031 04/05/2019 MUD Payroll 4/5/2019 Medical Insurance 1141 04/19/2019 MUD Payroll 04/19/2019 Medical Insurance 21,169.57 Remaining 49 % Used 27,207.96 2,561.73 29,769.69 PR 2,913.87 32,683.56 PR Account: 135-50026-030-000 Medical Insurance Totals: 5,475.60 32,683.56 ** 81,895.00 Budgeted Account: 135-50027-030-000 Dental Insurance 1031 04/05/2019 MUD Payroll 4/5/2019 Dental Insurance 1141 04/19/2019 MUD Payroll 04/19/2019 Dental Insurance 49,211.44 Remaining 405 Used 1,587.44 144.93 1,732.37 PR 161.47 1,893.84 PR Account: 135-50027-030-000 Dental Insurance Totals: 306.40 1,893.84 ** 4,291.00 Budgeted 2,397.16 Remaining 44 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-50028-030-000 Vision Insurance 1031 04/05/2019 MUD Payroll 4/5/2019 Vision Insurance 1141 04/19/2019 MUD Payroll 04/19/2019 Vision Insurance 258.03 22.76 280.79 PR 26.01 306.80 PR Account: 135-50028-030-000 Vision Insurance Totals: 48.77 306.80 ** Account: 135-50029-030-000 1014 04/01/2019 April A/P 1026 04/01/2019 April A/P 1209 04/30/2019 April A/P Account: 135-50029-030-000 701.00 Budgeted Life Insurance & Other Employee LTD & STD Employee Benefits Caf 125 394.20 Remaining 44 % Used 1,748.60 155.58 1,904.18 METLIFE GROUP BENEFITS 168.00 2,072.18 Humana Inc 20.00 2,092.18 BenefitMall Life Insurance & Other Totals: 343.58 2,0921[8 ** 4,495.00 Budgeted 2,402.82 Remaining 47 % Used Account: 135-50030-030-000 Social Security Taxes 1031 04/05/2019 MUD Payroll 4/5/2019 Social Security Taxes 1141 04/19/2019 MUD Payroll 04/19/2019 Social Security Taxes 10,227.29 824.90 11,052.19 853.72 11,905.91 5151 AP 5185 AP 5237 AP PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 1,678.62 11,905.91 ** 27,580.00 Budgeted Account: 135-50035-030-000 Medicare Taxes 1031 04/05/2019 MUD Payroll 4/5/2019 Medicare Taxes 1141 04/19/2019 MUD Payroll 04/19/2019 Medicare Taxes Account: 135-50035-030-000 15,674.09 Remaining 43 6 Used Medicare Taxes Totals: 6,450.00 Budgeted Account: 135-50040-030-000 Unemployment Taxes 1157 04/19/2019 TWC Payroll 4/19/2019 Unemployment Taxes Account: 135-50040-030-000 2,391.86 3,665.55 Remaining 43 6 Used Unemployment Taxes Totals: 1,260.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 131 04/01/2019 Insurance/Wrk Comp Expense Apr 444.12 Remaining 910.73 65 % Used 192.94 199.65 392.59 (94.85) 2,584.80 2,784.45 2,784.45 ** PR PR 815.88 PR (94.85) 815.88 ** 599.70 106.55 706.25 GL glpdatb2 skrolczyk 14:47 05/15/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: 4/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 34 Check Source Number 1155 04/18/2019 1215 04/26/2019 1215 04/26/2019 1215 04/26/2019 1215 04/26/2019 1215 04/26/2019 1215 04/26/2019 1209 04/30/2019 1234 04/30/2019 1245 04/30/2019 1253 04/30/2019 April A/P PCard 3/27/2019 - 4/26/2019 PCard 3/27/2019 - 4/26/2019 PCard 3/27/2019 - 4/26/2019 PCard 3/27/2019 - 4/26/2019 PCard 3/27/2019 - 4/26/2019 PCard 3/27/2019 - 4/26/2019 April A/P AT&T WWTP Temp Int Acct Closed April A/P April A/P Microsoft exchange-april video convertor sub software website renewal internet internet internet adobe software subscription vision support & install -Steve Internet -April Annual license renewal 40,815.12 510.00 27.05 239.88 148.88 62.34 84.04 32.45 203.00 (4.36) 903.72 1,460.00 41,325.12 M3 Networks 41,352.17 FS *DIGITALWAVE 41,592.05 DNH*GODADDY.COM 41,740.93 ATT*BILL PAYMENT 41,803.27 ATT*BILL PAYMENT 41,887.31 ATT*BILL PAYMENT 41,919.76 ADOBE *ACROPRO SUBS 42,122.76 STW INC 42,118.40 43,022.12 Charter Communications 44,482.12 Data Management Inc. 5224 AP PC PC PC PC PC PC 5246 AP GL 5252 AP 5253 AP Account: 135-50045-030-000 Workman's Compensation Totals: 135-55030-030-000 Software & Support 106.55 706.25 ** 3,667.00 44,482.12 ** 1,295.00 Budgeted 588.75 Remaining 55 % Used 77,849.00 Budgeted 33,366.88 Remaining 57 Account: 135-50060-030-000 Pre-emp Physicals/Testing Account: 135-55070-030-000 Independent Labor 1307 04/30/2019 April A/P New employment check -Rex McCla 103.95 101.45 205.40 FIRST CHECK APPLICANT SCREENIN AP Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 69,593.51 101.45 205.40 ** 5251 5251 AP AP Account: 500.00 Budgeted 294.60 Remaining 41 % Used 12,977.44 82,570.95 Account: 135-50070-030-000 Employee Relations 175,000.00 Budgeted 92,429.05 Remaining 47 % Used 3,018.51 .00 3,018.51 Account: 135-50070-030-000 Employee Relations Totals: .00 3,018.51 ** 5,000.00 Budgeted 1,981.49 Remaining 60 o Used Account: 135-55030-030-000 Software & Support 1155 04/18/2019 1215 04/26/2019 1215 04/26/2019 1215 04/26/2019 1215 04/26/2019 1215 04/26/2019 1215 04/26/2019 1209 04/30/2019 1234 04/30/2019 1245 04/30/2019 1253 04/30/2019 April A/P PCard 3/27/2019 - 4/26/2019 PCard 3/27/2019 - 4/26/2019 PCard 3/27/2019 - 4/26/2019 PCard 3/27/2019 - 4/26/2019 PCard 3/27/2019 - 4/26/2019 PCard 3/27/2019 - 4/26/2019 April A/P AT&T WWTP Temp Int Acct Closed April A/P April A/P Microsoft exchange-april video convertor sub software website renewal internet internet internet adobe software subscription vision support & install -Steve Internet -April Annual license renewal 40,815.12 510.00 27.05 239.88 148.88 62.34 84.04 32.45 203.00 (4.36) 903.72 1,460.00 41,325.12 M3 Networks 41,352.17 FS *DIGITALWAVE 41,592.05 DNH*GODADDY.COM 41,740.93 ATT*BILL PAYMENT 41,803.27 ATT*BILL PAYMENT 41,887.31 ATT*BILL PAYMENT 41,919.76 ADOBE *ACROPRO SUBS 42,122.76 STW INC 42,118.40 43,022.12 Charter Communications 44,482.12 Data Management Inc. 5224 AP PC PC PC PC PC PC 5246 AP GL 5252 AP 5253 AP Account: 135-55030-030-000 Software & Support Totals: 3,667.00 44,482.12 ** 77,849.00 Budgeted 33,366.88 Remaining 57 % Used Account: 135-55070-030-000 Independent Labor 1250 04/30/2019 APril A/P 1250 04/30/2019 APril A/P GM April 2019 GM April 2019 69,593.51 12,960.00 17.44 82,553.51 82,570.95 Carman Consulting LLC. Carman Consulting LLC. 5251 5251 AP AP Account: 135-55070-030-000 Independent Labor Totals: 12,977.44 82,570.95 ** 175,000.00 Budgeted 92,429.05 Remaining 47 % Used glpdatb2 skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 4/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 35 Check Source Number 1011 04/01/2019 April A/P Answering svc-April 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 phone 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 phone 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 phone 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 answering service 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 phone 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 phone 7,575.39 194.75 7,770.14 KEYSTONE PARK SECRETARIAL 335.01 8,105.15 ATT*BILL PAYMENT 460.13 8,565.28 ATT*BUS PHONE PMT 771.51 9,336.79 ATT*BUS PHONE PMT 14.99 9,351.78 RINGCENTRAL, INC 700.20 10,051.98 ATT*BUS PHONE PMT 461.43 10,513.41 ATT*BUS PHONE PMT 5143 AP PC PC PC PC PC PC Account: 135-55080-030-000 Maintenance & Repairs 4,540.00 .00 4,540.00 Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 4,540.00 ** 20,000.00 Budgeted 15,460.00 Remaining 23 % Used Account: 135-55085-030-000 Generator Maint. and Repair 927.52 .00 927.52 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 927.52 ** 10,000.00 Budgeted 9,072.48 Remaining 9 % Used Account: 135-55120-030-000 Cleaning Services 1209 04/30/2019 April A/P Janitorial service -March 4,345.30 869.06 5,214.36 MEMBER'S BUILDING MAINTENANCE 5243 AP Account: 135-55120-030-000 Cleaning Services Totals: 869.06 5,214.36 ** 10,000.00 Budgeted 4,785.64 Remaining 52 % Used Account: 135-55160-030-000 Professional Outside Services 1155 04/18/2019 April A/P bond certification 61,705.00 221.50 61,926.50 LAFOLLETT & ABBOTT PLLC 5222 AP Account: 135-55160-030-000 Professional Outside Services Totals: 221.50 61,926.50 ** 66,055.00 Budgeted 4,128.50 Remaining 94 % Used Account: 135-55205-030-000 Utility Billing Contract ' 1307 04/30/2019 April A/P Water billings -April 3,495.78 573.03 4,068.81 DATAPROSE LLC AP Account: 135-55205-030-000 Utility Billing Contract Totals: 573.03 4,068.81 ** 9,000.00 Budgeted 4,931.19 Remaining 45 % Used Account: 135-60005-030-000 Telephone 1011 04/01/2019 April A/P Answering svc-April 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 phone 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 phone 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 phone 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 answering service 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 phone 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 phone 7,575.39 194.75 7,770.14 KEYSTONE PARK SECRETARIAL 335.01 8,105.15 ATT*BILL PAYMENT 460.13 8,565.28 ATT*BUS PHONE PMT 771.51 9,336.79 ATT*BUS PHONE PMT 14.99 9,351.78 RINGCENTRAL, INC 700.20 10,051.98 ATT*BUS PHONE PMT 461.43 10,513.41 ATT*BUS PHONE PMT 5143 AP PC PC PC PC PC PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1285 04/30/2019 Town Billed Invoices 1684-1687 AR 20190430-20190430 User: Account: 135-60005-030-000 Telephone 23,500.00 Budgeted 7,575.39 (180.00) 10,333.41 AR 2,758.02 10,333.41 ** 13,166.59 Remaining 44 % Used Account: 135-60010-030-000 Communications/Mobiles 1116 04/10/2019 April A/P Cell phones -April 1141 04/19/2019 MUD Payroll 04/19/2019 Communications/Mobiles Account: 135-60010-030-000 Account: 135-60020-030-000 1155 04/18/2019 April A/P Account: 135-60020-030-000 1 Communications/Mobiles Totals: 4,000.00 Budgeted 1,425.12 87.45 1,512.57 VERIZON WIRELESS 5207 AP 150.00 1,662.57 PR 2,337.43 Remaining 42 o Used Electricity/Gas Electricity admin -2/8-3/11 3,067.10 Electricity/Gas Totals: 8,690.00 Budgeted 237.45 1,662.57 ** 812.54 3,879.64 TOWN OF TROPHY CLUB 5231 AP 4,810.36 Remaining 45 % Used 812.54 3,879.64 ** Account: 135-60025-030-000 Water 1245 04/30/2019 April A/P water -April 333.15 107.71 440.86 TROPHY CLUB MUD (WATER BILLS) 5262 AP 1285 04/30/2019 Town Billed Invoices 1684-1687 AR 20190430-20190430 User: (53.85) 387.01 AR Account: 135-60025-030-000 Water Totals: 53.86 387.01 ** 2,000.00 Budgeted 1,612.99 Remaining 19 % Used Account: 135-60035-030-000 Postage 1170 04/22/2019 April A/P Postage lease 1209 04/30/2019 April A/P postage for machine 1307 04/30/2019 April A/P Water billings -April IIF 9,977.41 102.54 10,079.95 FRANCOTYP-POSTALIA, INC. 5216 AP 1,500.00 11,579.95 U.S. Postal Service (CMRS-FP) 5248 AP 1,596.43 13,176.38 DATAPROSE LLC AP Account: 135-60035-030-000 Postage Totals: 3,198.97 13,176.38 ** Account: 135-60040-030-000 1037 04/05/2019 Child Support Fee 1145 04/19/2019 Child Support Fee 1209 04/30/2019 April A/P 1237 04/30/2019 Pace Credit Card Fees 30,000.00 Budgeted 16,823.62 Remaining 44 % Used Service Charges & Fees 33,607.91 1.50 33,609.41 GL 1.50 33,610.91 GL Direct send fees -Feb & March 100.00 33,710.91 Fisery Solutions, LLC 5240 AP 4,401.62 38,112.53 GL glpdatb2 skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1237 04/30/2019 Pace Credit Card Fees 1312 04/30/2019 April A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 4/2019 Page 37 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Dig Tess -April 33,607.91 80.69 38,193.22 247.00 38,440.22 Texas Excavation Safety System GL AP 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 FOOD FOR SAFETY METING fruit for safety meeting food for safety meeting Fruit for safety meeting 39.93 8.99 33.26 12.99 39.93 KIM S DONUT 48.92 TOM THUMB #1780 82.18 KIM S DONUT 95.17 TOM THUMB #1780 PC PC PC PC Account: 135-60075-030-000 Meetings Totals: 95.17 95.17 ** 400.00 Budgeted 304.83 Remaining 24 % Used Account: 135-60040-030-000 Service Charges & Fees Totals: 4,832.31 38,440.22 ** 55,560.00 Budgeted 17,119.78 Remaining 69 % Used 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 131 04/01/2019 Insurance/Wrk Comp Expense Apr 37,816.38 6,302.73 44,119.11 GL Account: 135-60055-030-000 Insurance Totals: 6,302.73 44,119.11 ** 65,000.00 Budgeted 20,880.89 Remaining 68 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 4,109.25 .00 4,109.25 Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,109.25 ** 6,000.00 Budgeted 1,890.75 Remaining 68 % Used Account: 135-60075-030-000 Meetings 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 FOOD FOR SAFETY METING fruit for safety meeting food for safety meeting Fruit for safety meeting 39.93 8.99 33.26 12.99 39.93 KIM S DONUT 48.92 TOM THUMB #1780 82.18 KIM S DONUT 95.17 TOM THUMB #1780 PC PC PC PC Account: 135-60075-030-000 Meetings Totals: 95.17 95.17 ** 400.00 Budgeted 304.83 Remaining 24 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-60079-030-000 Public Education Account: 135-60079-030-000 Account: 135-60080-030-000 Account: 135-60080-030-000 Account: 135-60100-030-000 Account: 135-60100-030-000 Public Education Totals: 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Schools & Training Schools & Training Totals: 8,950.00 Budgeted Travel & per diem 8,815.00 Remaining 135.00 2 % Used .00 .00 .00 .00 ** .00 135.00 .00 135.00 ** 8.70 .00 8.70 Travel & per diem Totals: 4,345.00 Budgeted 4,336.30 Remaining 0 % Used .00 8.70 ** Account: 135-60110-030-000 Physicals/Testing Account: 135-60110-030-000 Physicals/Testing Totals: 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising Account: 135-60125-030-000 Advertising Totals: 25,000.00 Budgeted 25,000.00 Remaining 0 % Used .00 .00 .00 .00 ** .00 .00 .00 .00 ** Account: 135-60235-030-000 Security 1155 04/18/2019 April A/P monitoring svc-April 144.00 24.00 168.00 Digital Air Control, Inc 5214 AP Account: 135-60235-030-000 Security Totals: 24.00 168.00 ** 1,288.00 Budgeted Account: 135-60245-030-000 Miscellaneous Expenses 1,120.00 Remaining 13 % Used glpdatb2 skrolczyk 14:47 05/15/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 4/2019 JE Detail Beginning Balance Description/Comment 124.49 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 124.49 Page 39 Check Source Number Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 124.49 ** 500.00 Budgeted 375.51 Remaining 25 % Used Account: 135-60246-030-000 General Manager Contingency .00 .00 Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniforms ' .00 .00 Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 2,050.00 Budgeted 2,050.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 3,025.81 .00 3,025.81 Account: 135-65055-030-000 Hardware Totals: .00 3,025.81 ** 7,064.00 Budgeted 4,038.19 Remaining 43 % Used Account: 135-65085-030-000 Office Supplies 1170 04/22/2019 April A/P 1170 04/22/2019 April A/P 1215 04/26/2019 PCard 3/27/2019 office supplies office supplies - 4/26/2019 po books, after hrs work order 4,928.95 67.02 78.95 231.00 4,995.97 5,074.92 5,305.92 OFFICE DEPOT, INC OFFICE DEPOT, INC CARBONLESS FORMS PRINT 5226 5226 AP AP PC Account: 135-65085-030-000 Office Supplies Totals: 376.97 5,305.92 ** 6,000.00 Budgeted 694.08 Remaining 88 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 float kit for cdu/spf 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 sugar 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 coffee 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 tea 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 coffee 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 coffee 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 tea 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 water 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 bowls 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 breakroom supplies 1215 04/26/2019 PCard 3/27/2019 - 4/26/2019 coffee 2,110.77 34.21 2,144.98 AMAZON.COM*MZ8UU9QT1 9.25 2,154.23 AMZN MKTP US*MZ5JS1871 53.19 2,207.42 AMAZON.COM*MZ4133GK0 28.40 2,235.82 AMAZON.COM*MZ96U1GQ0 29.41 2,265.23 AMAZON.COM*MZ8BZ4GD0 14.71 2,279.94 AMAZON.COM*MZ4MQ2N40 14.20 2,294.14 AMAZON.COM*MZ6JT04I2 2.40 2,296.54 WAL-MART #5247 9.94 2,306.48 SAMSCLUB #4795 207.82 2,514.30 SAMSCLUB.COM 14.71 2,529.01 AMAZON.COM*MW9CO4XN2 PC PC PC PC PC PC PC PC PC PC PC Account: 135-65095-030-000 ■ Maintenance Supplies Totals: 418.24 2,529.01 ** 4,000.00 Budgeted 1,470.99 Remaining 63 % 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 40,774.00 .00 40,774.00 Account: 135-69005-030-000 Capital Outlays Totals: .00 40,774.00 ** 280,000.00 Budgeted 239,226.00 Remaining 15 % Used Account: 135-69170-030-000 Copier Lease Installments 1126 04/11/2019 April A/P 1209 04/30/2019 April A/P copier lease -April Copier lease -April 1,643.77 165.00 80.22 1,808.77 1,888.99 TIAA CObMdERCIAL FINANCE KYOCERA DOCUMENT SOLUTIONS 5209 5241 AP AP Account: 135-69170-030-000 Copier Lease Installments Totals: 245.22 1,888.99 ** 4,000.00 Budgeted 2,111.01 Remaining 47 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1 Department 30 Totals: 651,562.31 ** 77,434.40 Monthly Total 1,559,905.00 Budgeted 908,342.69 Remaining 42 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/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-55045-039-000 1155 04/18/2019 April A/P 1312 04/30/2019 April A/P 1312 04/30/2019 April A/P 1314 04/30/2019 April A/P Legal Southlake-easement Legal Legal Legal -Westlake Easement 60,815.51 1,473.00 62,288.51 WHITAKER CHALK SWINDLE 5234 AP 3,389.34 65,677.85 McLean & Howard, L.L.P. AP 1,050.00 66,727.85 McLean & Howard, L.L.P. AP 4,488.00 71,215.85 WHITAKER CHALK SWINDLE AP Account: 135-55045-039-000 Legal Totals: 10,400.34 71,215.85 ** 137,000.00 Budgeted 65,784.15 Remaining 52 % Used Account: 135-55055-039-000 Auditing 26,459.53 .00 26,459.53 Account: 135-55055-039-000 Auditing Totals: .00 26,459.53 ** 30,800.00 Budgeted 4,340.47 Remaining 86 % Used Account: 135-55060-039-000 Appraisal 6,834.32 .00 6,834.32 Account: 135-55060-039-000 Appraisal Totals: .00 6,834.32 ** 11,714.00 Budgeted 4,879.68 Remaining 58 % Used Account: 135-55065-039-000 Tax Admin Fees 3,653.00 .00 3,653.00 Account: 135-55065-039-000 Tax Adman Fees Totals: .00 3,653.00 ** 4,800.00 Budgeted 1,147.00 Remaining 76 % Used Department 39 Totals: 108,162.70 ** 10,400.34 Monthly Total 184,314.00 Budgeted 76,151.30 Remaining 59 % Used Fund 135 Totals: (179,441.74) (573,989.67) Monthly Total (343,337.00) Budgeted (163,895.26) Remaining 52 % Used glpdatb2 skrolczyk 14:47 05/15/19 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 4/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 43 Check Source Number Department Totals: .00 Budgeted .00 Monthly Total 81,420.00 Remaining 0 % Used .00 Budgeted (186,420.00) ** 186,420.00 Remaining 0 % Used Account: 137-49145-000-000 Intergov Transfer -General Fund (105,000.00) .00 (105,000.00) Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: .00 (105,000.00) ** .00 Budgeted 105,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer -Fire Dept (81,420.00) .00 (81,420.00) Account: 137-49146-000-000 Intergov Transfer -Fire Dept Totals: .00 (81,420.00) ** Department Totals: .00 Budgeted .00 Monthly Total 81,420.00 Remaining 0 % Used .00 Budgeted (186,420.00) ** 186,420.00 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 10 Water Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-010-000 GASB Replacement 1322 04/30/2019 Budget Amendment Acct Transfr VFD- price increase FY17 Cap 266,613.00 266,613.00 GL Account: 137-69195-010-000 GASB Replacement Totals: 266,613.00 266,613.00 ** .00 Budgeted (266,613.00) Remaining 0 % Used Department 10 Totals: 266,613.00 ** 266,613.00 Monthly Total .00 Budgeted (266,613.00) Remaining 0 % Used Fund 137 Totals: 80,193.00 266,613.00 Monthly Total .00 Budgeted (80,193.00) Remaining 0 % Used TROPHY CLUB MUD #1 - WWTP TAX BOND CONST BALANCE SHEET APRIL 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TOTAL ASSETS LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 1,678,862 1,678,862 (1,479,465) (199,397) (1,678,862) 0 glbase tbam skrolczyk Trophy Club MUD No.1 Page 15 14:47 05/15/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 7.29- 7.29 Subtotal: 7.29- 7.29 Program number: 7.29- 7.29 Department number: Revenues 7.29- 7.29 Revenues Subtotal 7.29- 7.29 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 14:47 05/15/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 4,091.27 199,404.59 199,404.59 - Subtotal: 4,091.27 199,404.59 199,404.59 - Program number: 4,091.27 199,404.59 199,404.59 - Department number: Wastewater 4,091.27 199,404.59 199,404.59 - Expenditures Subtotal 4,091.27 199,404.59 199,404.59 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 4,091.27 199,397.30 199,397.30- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/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-49010-000-000 Interest Income Account: 517-49010-000-000 Department Totals: (7.29) .00 (7.29) Interest Income Totals: .00 (7.29) ** .00 Budgeted 7.29 Remaining 0 % Used .00 Monthly Total .00 Budgeted (7.29) ** 7.29 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/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-69005-020-000 Capital Outlays 1312 04/30/2019 April A/P WWTP Improvements 195,313.32 4,091.27 199,404.59 CP&Y/WALLACE GROUP, INC. AP Account: 517-69005-020-000 Capital Outlays Totals: 4,091.27 199,404.59 ** Department 20 Totals: Fund 517 Totals: .00 Budgeted (199,404.59) Remaining 0 % Used 199,404.59 ** 4,091.27 Monthly Total .00 Budgeted (199,404.59) Remaining 0 % Used 199,397.30 4,091.27 Monthly Total .00 Budgeted (199,397.30) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET APRIL 2019 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 767,358 TOTAL ASSETS 767,358 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 13,158 TOTAL LIABILITIES 13,158 FUND BALANCE ASSIGNED FUND BALANCE 754,200 NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 754,200 TOTAL LIABILITIES AND FUND BALANCE 767,358 TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET APRIL 2019 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 2,935,294 INVESTMENTS 3,846,120 ACCOUNTS RECEIVABLE 45,000 TOTAL ASSETS 6,826,414 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 559,539 TOTAL LIABILITIES 559,539 FUND BALANCE ASSIGNED FUND BALANCE (366,246) NET REVENUES / EXPENDITURES 6,633,120 TOTAL FUND BALANCE 6,266,875 TOTAL LIABILITIES AND FUND BALANCE 6,826,414 glbase_tbam skrolczyk 14:47 05/15/19 Fund: 520 Revenue Bond 16" Waterline Account 520-49105-000-000 520-49110-000-000 Subtotal: Program number: Department number: Revenues Description Bond Proceeds Bond Premium Subtotal Department: Adopted Budget Trophy Club MUD No.1 Page 17 Budget Summary with Amendment Period Ending: 4/2019 Amended Total Budget Encumb. Current Month 7,003,878.61- 4,224.10- 7,008,102.71- 7,008,102.71- 7,008,102.71- 7,008,102.71 - Program: YTD Total 7,003,878.61- 4,224.10- 7,008,102.71- 7,008,102.71- 7,008,102.71- 7,008,102.71- % of Budget Remaining Budget 7,003,878.61 4,224.10 7,008,102.71 7,008,102.71 7,008,102.71 7,008,102.71 glbase tbam skrolczyk Trophy Club MUD No.1 Page 18 14:47 05/15/19 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 4/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Subtotal: 520-70005-010-000 520-70020-010-000 Capital Outlays Paying Agent Fee Bond issuance Costs 148,142.51 148,142.51 800.00 227,610.91 148,142.51 148,142.51 800.00 227,610.91 148,142.51- 148,142.51- 800.00- 227,610.91- Subtotal: 48,142.51-148,142.51-800.00- 227,610.91- Subtotal: 228,410.91 228,410.91 228,410.91 - Program number: 376,553.42 376,553.42 376,553.42 - Department number: Water Department 376,553.42 376,553.42 376,553.42 - Expenditures Subtotal 376,553.42 376,553.42 376,553.42 - Fund number: 520 Revenue Bond 16" Waterline 6,631,549.29- 6,631,549.29- 6,631,549.29 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 4/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-49010-000-000 Interest Income 1240 04/30/2019 Bank Interest- April (1,571.01) Account: 520-49010-000-000 (1,571.01) GL Interest Income Totals: (1,571.01) (1,571.01) ** .00 Budgeted 1,571.01 Remaining 0 % Used Account: 520-49105-000-000 Bond Proceeds 1286 04/23/2019 2019 Rev Bond Sale- Fund 520 (2,929,498.61) (2,929,498.61) GL 1286 04/23/2019 2019 Rev Bond Sale- Fund 520 (3,846,120.00) (6,775,618.61) GL 1286 04/23/2019 2019 Rev Bond Sale- Fund 520 (228,260.00) (7,003,878.61) GL Account: 520-49105-000-000 Bond Proceeds .00 Budgeted Totals: (7,003,878.61) (7,003,878.61) ** 7,003,878.61 Remaining 0 % Used Account: 520-49110-000-000 Bond Premium 1286 04/23/2019 2019 Rev Bond Sale- Fund 520 Net Reoffering Premium (4,224.10) (4,224.10) GL Account: 520-49110-000-000 Bond Premium Totals: (4,224.10) (4,224.10) ** .00 Budgeted 4,224.10 Remaining 0 % Used Department Totals: (7,009,673.72) ** (7,009,673.72) Monthly Total .00 Budgeted 7,009,673.72 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 4/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-69005-010-000 Capital Outlays 1321 04/01/2019 Due To/From -Fund 520 148,142.51 148,142.51 GL Account: 520-69005-010-000 Capital Outlays Totals: 148,142.51 148,142.51 ** .00 Budgeted (148,142.51) Remaining 0 5 Used Account: 520-70005-010-000 P 1286 04/23/2019 2019 Rev Bond Sale- Fund 520 Admin Fee- BOKF Account Setup 400.00 400.00 GL 1286 04/23/2019 2019 Rev Bond Sale- Fund 520 First year Agent Fee 400.00 800.00 GL Account: 520-70005-010-000 Payini111111111e Totals: 800.00 800.00 ** .00 Budgeted Account: 520-70020-010-000 Bond Issuance Costs 1286 04/23/2019 2019 Rev Bond Sale- Fund 520 1312 04/30/2019 April A/P Bond 2019 Expense (800.00) Remaining 0 % Used 227,460.00 227,460.00 GL 150.91 227,610.91 McLean & Howard, L.L.P. AP Account: 520-70020-010-000 Bond Issuance Costs Totals: 227,610.91 227,610.91 ** .00 Budgeted (227,610.91) Remaining 0 % Used Department 10 Totals: 376,553.42 ** Fund 520 Totals: 376,553.42 Monthly Total .00 Budgeted (6,633,120.30) Monthly Total (376,553.42) Remaining 0 % Used (6,633,120.30) .00 Budgeted 6,633,120.30 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET APRIL 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 721,016 TOTAL ASSETS 721,016 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 606,910 114,106 721,016 721,016 glbase tbam skrolczyk Trophy Club MUD No.1 Page 19 14:47 05/15/19 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 528-49142-000-000 528-49143-000-000 Subtotal: Program number: Department number: Revenues Interest Income Interfund transfer in -Water Interfund transfer in -WW Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund 5,000.00- 5,000.00- 55,193.00- 55,193.00- 125,187.00- 125,187.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 1,410.86- 8,882.18- 4,600.00- 32,200.00- 10,432.00- 73,024.00- 16,442.86- 114,106.18- 16,442.86- 114,106.18- 16,442.86- 114,106.18- 16,442.86- 114,106.18- 16,442.86- 114,106.18- 177.644 58.341 58.332 61.553 61.553 61.553 61.553 61.553 3,882.18 22,993.00- 52,163.00- 71,273.82- 71,273.82- 71,273.82- 71,273.82- 71,273.82- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 1240 04/30/2019 Bank Interest- April Account: 528-49010-000-000 (7,471.32) (1,410.86) (8,882.18) GL Interest Income Totals: (1,410.86) (8,882.18) ** (5,000.00) Budgeted 3,882.18 Remaining 178 % Used Account: 528-49142-000-000 Interfund transfer in -Water 1207 04/30/2019 TexPool Transfers April TexPool O&M to Rev Bond Resevr (27,600.00) Account: 528-49142-000-000 Interfund transfer in -Water Totals: (55,193.00) Budgeted (22,993.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 1207 04/30/2019 TexPool Transfers April TexPool O&M to Rev Bond Resevr Account: 528-49143-000-000 (4,600.00) (32,200.00) GL 58 % Used (62,592.00) Interfund transfer in -WW Totals: (125,187.00) Budgeted (52,163.00) Remaining (4,600.00) (32,200.00) ** (10,432.00) (73,024.00) GL 58 % Used (10,432.00) (73,024.00) ** Department Totals: (114,106.18) ** (16,442.86) Monthly Total (185,380.00) Budgeted (71,273.82) Remaining 62 % Used Fund 528 Totals: (114,106.18) (16,442.86) Monthly Total (185,380.00) Budgeted (71,273.82) Remaining 62 % Used TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET APRIL 2019 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 889,390 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 20,957 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 914,919 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 20,957 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 20,957 FUND BALANCE ASSIGNED FUND BALANCE 53,289 NET REVENUES / EXPENDITURES 840,674 TOTAL FUND BALANCE 893,962 TOTAL LIABILITIES AND FUND BALANCE 914,919 glbase_tbam skrolczyk 14:47 05/15/19 Fund: 533 MUD 1 I&S Consolidated Account 533-40000-000-000 533-40002-000-000 533-40015-000-000 Subtotal: 533-49010-000-000 533-49015-000-000 533-49141-000-000 Description Property Taxes Property Taxes/Delinquent Property Taxes/P & I Interest Income Lease/Rental Income Interfund Trans In -PID Surchg Subtotal: Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget 687,175.00- 1,800.00- 2,000.00- 690,975.00- 2,000.00- 215,979.00- 120,053.00- 338,032.00- 1,029,007.00- 1,029,007.00- 1,029,007.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 4/2019 Amended Total Budget Encumb. 687,175.00- 1,800.00- 2,000.00- 690,975.00- 2,000.00- 215,979.00- 120,053.00- 338,032.00- 1,029,007.00- 1,029,007.00- 1,029,007.00 - Current Month Program: YTD Total 4,355.03- 673,198.81- 32.90- 1,276.88- 375.42- 1,702.58- 4,763.35- 676,178.27- 1,750.62- 6,597.93- 215,979.00- 10,913.90- 76,397.30- 12,664.52- 298,974.23- 17,427.87- 975,152.50- 17,427.87- 975,152.50- 17,427.87- 975,152.50- % of Budget Remaining Budget 97.966 13,976.19- 70.938 523.12- 85.129 297.42- 97.859 14,796.73- 329.897 4,597.93 100.000 63.636 43,655.70- 88.446 39,057.77- 94.766 53,854.50- 94.766 53,854.50- 94.766 53,854.50 - Page 20 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 14:47 05/15/19 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 533-70025-051-000 Bond Interest Expense -Tax 533-70035-051-000 Bond Principal Payment -Tax Subtotal: Program number: Department number: Administration Expenditures Fund number: 533 MUD 1 I&S Consolidated Subtotal 2,150.00 266,058.00 755,000.00 2,150.00 266,058.00 755,000.00 1,023,208.00 1,023,208.00 1,450.00 133,028.75 134,478.75 1,023,208.00 1,023,208.00 134,478.75 1,023,208.00 1,023,208.00 5,799.00- 1,023,208.00 1,023,208.00 5,799.00- 134,478.75 134,478.75 67.442 50.000 700.00 133,029.25 755,000.00 13.143 888,729.25 13.143 888,729.25 13.143 13.143 17,427.87- 840,673.75- ############### 888,729.25 888,729.25 834,874.75 glpdatb2 skrolczyk Trophy Club MUD No.1 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) Page 50 Check Source Number Account: 533-40000-000-000 Property Taxes 1255 04/01/2019 Property Taxes 1256 04/02/2019 Property Taxes 1257 04/03/2019 Property Taxes 1258 04/04/2019 Property Taxes 1259 04/05/2019 Property Taxes 1260 04/08/2019 Property Taxes 1261 04/10/2019 Property Taxes 1263 04/12/2019 Property Taxes 1264 04/15/2019 Property Taxes 1265 04/16/2019 Property Taxes 1266 04/17/2019 Property Taxes 1267 04/18/2019 Property Taxes 1268 04/22/2019 Property Taxes 1269 04/23/2019 Property Taxes 1270 04/24/2019 Property Taxes 1271 04/25/2019 Property Taxes 1272 04/26/2019 Property Taxes 1273 04/29/2019 Property Taxes 1274 04/30/2019 Property Taxes (668,843.78) (220.29) (699.94) (469.53) (8.65) (625.84) (28.21) (1,122.23) (39.99) 10.33 (91.03) (178.59) (11.04) (444.84) 10.34 (27.84) (152.14) (204.95) (1.45) (49.14) (669,064.07) (669,764.01) (670,233.54) (670,242.19) (670,868.03) (670,896.24) (672,018.47) (672,058.46) (672,048.13) (672,139.16) (672,317.75) (672,328.79) (672,773.63) (672,763.29) (672,791.13) (672,943.27) (673,148.22) (673,149.67) (673,198.81) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: (4,355.03) (673,198.81) ** (687,175.00) Budgeted (13,976.19) Remaining 98 6 Used Account: 533-40002-000-000 Property Taxes/Delinquent 1255 04/01/2019 Property Taxes 1256 04/02/2019 Property Taxes 1262 04/11/2019 Property Taxes 1272 04/26/2019 Property Taxes 1273 04/29/2019 Property Taxes 1274 04/30/2019 Property Taxes (1,243.98) (6.99) (1,250.97) (11.40) (1,262.37) (.24) (1,262.61) (7.17) (1,269.78) (.16) (1,269.94) (6.94) (1,276.88) GL GL GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (32.90) (1,276.88) ** (1,800.00) Budgeted (523.12) Remaining 71 % Used Account: 533-40015-000-000 Property Taxes/P & I 1255 04/01/2019 Property Taxes 1256 04/02/2019 Property Taxes 1257 04/03/2019 Property Taxes 1258 04/04/2019 Property Taxes 1259 04/05/2019 Property Taxes (1,327.16) (9.09) (20.76) (39.95) (.69) (56.51) (1,336.25) (1,357.01) (1,396.96) (1,397.65) (1,454.16) GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 51 1260 04/08/2019 Property Taxes 1261 04/10/2019 Property Taxes 1262 04/11/2019 Property Taxes 1263 04/12/2019 Property Taxes 1265 04/16/2019 Property Taxes 1266 04/17/2019 Property Taxes 1267 04/18/2019 Property Taxes 1268 04/22/2019 Property Taxes 1270 04/24/2019 Property Taxes 1271 04/25/2019 Property Taxes 1272 04/26/2019 Property Taxes 1274 04/30/2019 Property Taxes (1,327.16) (1.97) (123.45) (.02) (4.40) (10.01) (19.65) (1.06) (36.32) (3.07) (16.74) (24.47) (7.26) (1,456.13) (1,579.58) (1,579.60) (1,584.00) (1,594.01) (1,613.66) (1,614.72) (1,651.04) (1,654.11) (1,670.85) (1,695.32) (1,702.58) GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (375.42) (1,702.58) ** (2,000.00) Budgeted (297.42) Remaining 85 a Used Account: 533-49010-000-000 Interest Income 1240 04/30/2019 Bank Interest- April (4,847.31) (1,750.62) (6,597.93) GL Account: 533-49010-000-000 Interest Income Totals: (1,750.62) (6,597.93) ** (2,000.00) Budgeted 4,597.93 Remaining 330 o Used Account: 533-49015-000-000 Lease/Rental Income (215,979.00) .00 (215,979.00) Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (215,979.00) ** (215,979.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 1207 04/30/2019 TexPool Transfers April TexPool O&M to I&S- PID Debt (65,483.40) (10,913.90) (76,397.30) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,913.90) (76,397.30) ** Department Totals: (120,053.00) Budgeted (17,427.87) Monthly Total (43,655.70) Remaining 64 % Used (975,152.50) ** (1,029,007.00) Budgeted (53,854.50) Remaining 95 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I6S Consolidated Department: 51 Administration Program: Period Ending: 4/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 1,450.00 .00 1,450.00 Paying Agent Fee Totals: .00 1,450.00 ** 2,150.00 Budgeted 700.00 Remaining 67 5 Used Account: 533-70025-051-000 Bond Interest Expense -Tax 133,028.75 .00 133,028.75 Account: 533-70025-051-000 Bond Interest Expense -Tax Totals: .00 133,028.75 ** 266,058.00 Budgeted 133,029.25 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax .00 .00 Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 .00 ** 755,000.00 Budgeted 755,000.00 Remaining 0 % Used Department 51 Totals: 134,478.75 ** .00 Monthly Total 1,023,208.00 Budgeted 888,729.25 Remaining 13 % Used Fund 533 Totals: (840,673.75) (17,427.87) Monthly Total (5,799.00) Budgeted 834,874.75 Remaining 8888888888 TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET APRIL 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 292,967 TOTAL ASSETS 292,967 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 19,562 273,405 292,967 292,967 glbase_tbam skrolczyk 14:47 05/15/19 Fund: 534 2015 Revenue Bond I&S Account 534-49010-000-000 534-49143-000-000 Description Interest Income Interfund Transfer In -WW Sales Subtotal: Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget 1,000.00- 596,238.00- 597,238.00- 597,238.00- 597,238.00- 597,238.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 4/2019 Amended Total Budget Encumb. 1,000.00- 596,238.00- 597,238.00- 597,238.00- 597,238.00- 597,238.00 - Program: Current YTD Month Total 480.57- 2,099.63- 54,203.45- 379,424.15- 54,684.02- 381,523.78- 54,684.02- 381,523.78- 54,684.02- 381,523.78- 54,684.02- 381,523.78- % of Budget Remaining Budget 209.963 1,099.63 63.636 216,813.85- 63.881 215,714.22- 63.881 215,714.22- 63.881 215,714.22- 63.881 215,714.22 - Page 22 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 14:47 05/15/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/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 534-70040-051-000 Revenue Bond Interest Expense 215,838.00 215,838.00 534-70045-051-000 Revenue Bond Principal Expense 380,000.00 380,000.00 Subtotal: 596,238.00 596,238.00 Program number: 596,238.00 596,238.00 Department number: Administration 596,238.00 596,238.00 Expenditures Subtotal 596,238.00 596,238.00 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 200.00 107,918.75 108,118.75 108,118.75 108,118.75 108,118.75 50.000 50.000 18.133 18.133 18.133 18.133 54,684.02- 273,405.03- ############### 200.00 107,919.25 380,000.00 488,119.25 488,119.25 488,119.25 488,119.25 272,405.03 glpdatb2 skrolczyk 14:47 05/15/19 Fund: 534 2015 Revenue Bond ISS JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 4/2019 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Page 53 Check Source Number Department Totals: (54,684.02) Monthly Total (381,523.78) ** (597,238.00) Budgeted (215,714.22) Remaining 64 % Used Account: 534-49010-000-000 Interest Income 1240 04/30/2019 Bank Interest- April (1,619.06) (480.57) (2,099.63) GL Account: 534-49010-000-000 Interest Income Totals: (480.57) (2,099.63) ** (1,000.00) Budgeted 1,099.63 Remaining 210 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 1207 04/30/2019 TexPool Transfers April TexPool O&M to Rev Bd WWTP ISS (325,220.70) (54,203.45) (379,424.15) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,203.45) (379,424.15) ** (596,238.00) Budgeted (216,813.85) Remaining 64 % Used Department Totals: (54,684.02) Monthly Total (381,523.78) ** (597,238.00) Budgeted (215,714.22) Remaining 64 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I68 Department: 51 Administration Program: Period Ending: 4/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 200.00 .00 200.00 Rev Bond Paying Agent Fee Totals: .00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 107,918.75 .00 107,918.75 Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 107,918.75 ** 215,838.00 Budgeted 107,919.25 Remaining 50 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 380,000.00 Budgeted 380,000.00 Remaining 0 % Used Department 51 Totals: 108,118.75 ** .00 Monthly Total 596,238.00 Budgeted 488,119.25 Remaining 18 % Used Fund 534 Totals: (273,405.03) (54,684.02) Monthly Total (1,000.00) Budgeted 272,405.03 Remaining QQQQQQQQ#8 TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET APRIL 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB ` MUNICIPAL UTILITY DISTRICT Na. 1 535 NSII FTW SWIFT REVENUE BOND I&S 148,817 TOTAL ASSETS 148,817 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 2,584 146,233 148,817 148,817 glbase_tbam skrolczyk 14:47 05/15/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 535-49010-000-000 535-49142-000-000 Subtotal: Program number: Department number: Revenues Revenues Description Interest Income Interfund Tran In -Water Sales Subtotal Department: Adopted Budget 600.00- 276,901.00- 277,501.00- 277,501.00- 277,501.00- 277,501.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 4/2019 Amended Total Budget Encumb. 600.00- 276,901.00- 277,501.00- 277,501.00- 277,501.00- 277,501.00 - Program: Current YTD Month Total 248.69- 973.92- 25,172.81- 176,209.67- 25,421.50- 177,183.59- 25,421.50- 177,183.59- 25,421.50- 177,183.59- 25,421.50- 177,183.59- % of Budget Remaining Budget 162.320 373.92 63.636 100,691.33- 63.850 100,317.41- 63.850 100,317.41- 63.850 100,317.41- 63.850 100,317.41 - Page 24 glbase_tbam skrolczyk 14:47 05/15/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 1 535-70005-051-000 Description Rev Bond Paying Agent Fee Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 4/2019 Adopted Amended Total Budget Budget Encumb. 400.00 400.00 Current Month Program: YTD Total 200.00 % of Remaining Budget Budget 50.000 200.00 Page 25 535-70040-051-000 Revenue Bond Interest Expense 1 535-70045-051-000 Revenue Bond Principal Expense 61,501.00 215,000.00 61,501.00 215,000.00 30,750.50 50.000 30,750.50 215,000.00 Subtotal: 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Program number: 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Department number: Administration 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Expenditures Subtotal 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 25,421.50- 146,233.09- ############### 145,633.09 ******* End of Report ********* glpdatb2 skrolczyk 14:47 05/15/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: 4/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 55 Check Source Number Department Totals: (276,901.00) Budgeted (25,421.50) Monthly Total (100,691.33) Remaining 64 % Used (277,501.00) Budgeted (177,183.59) ** (100,317.41) Remaining 64 % Used Account: 535-49010-000-000 Interest Income 1240 04/30/2019 Bank Interest- April (725.23) (248.69) (973.92) GL Account: 535-49010-000-000 Interest Income Totals: (248.69) (973.92) ** (600.00) Budgeted 373.92 Remaining 162 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1207 04/30/2019 TexPool Transfers April TexPool O&M to 16Swift Rev I&S (151,036.86) (25,172.81) (176,209.67) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,172.81) (176,209.67) ** Department Totals: (276,901.00) Budgeted (25,421.50) Monthly Total (100,691.33) Remaining 64 % Used (277,501.00) Budgeted (177,183.59) ** (100,317.41) Remaining 64 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 14:47 05/15/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I8S-SWIFT Department: 51 Administration Program: Period Ending: 4/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee Account: 535-70005-051-000 200.00 .00 200.00 Rev Bond Paying Agent Fee Totals: .00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 30,750.50 .00 30,750.50 Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 30,750.50 ** 61,501.00 Budgeted 30,750.50 Remaining 50 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** Department 51 Totals: Fund 535 Totals: Grand Totals: 215,000.00 Budgeted 215,000.00 Remaining 0 % Used 30,950.50 ** .00 Monthly Total 276,901.00 Budgeted 245,950.50 Remaining 11 % Used (146,233.09) (25,421.50) Monthly Total (600.00) Budgeted 145,633.09 Remaining 444####### ******* End of Report ********* (8,179,012.11) **** (6,944,265.34) Monthly Total (536,116.00) Budgeted 7,642,896.11 Remaining 4444444444