Loading...
HomeMy WebLinkAbout2020-03 Combined Financials March 2020TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 5,14 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 1,010,278 9,845 42,336 TOTAL ASSETS 1,062,460 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 42,343 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 42,343 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON -SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 603,769 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 416,349 TOTAL FUND BALANCE 1,020,118 TOTAL LIABILITIES AND FUND BALANCE 1,062,460 glbase_tbam skrolczyk 2:47 04/15/20 Fund: 122 Trophy Club MUD Fire Dept. Account Description 122-40010-000-000 122-40011-000-000 122-40020-000-000 Subtotal: Trophy Club MUD No.1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 3/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Property Taxes/MUD Fire 1,214,230.00- 1,214,230.00 - Property Taxes/Fire-Delinquent Property Taxes/Fire P51 Program number: Department number: Fire Revenues Revenues Subtotal 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- MEMII 1,214,230.00- 1,214,230.00- 11,550.61- 408.73- 713.71- 1,208,468.49- 2,830.70- 3,546.01- 12,673.05- 1,214,845.20- 99.526 100.051 5,761.51- 2,830.70 3,546.01 12,673.05- 1,214,845.20- 100.051 615.20 12,673.05- 1,214,845.20- 12,673.05- 1,214,845.20- 100.051 615.20 100.051 615.20 glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60030-045-000 Rent And/Or Usage 218,004.00 218,004.00 218,004.00 100.000 122-60055-045-000 Insurance 21,000.00 21,000.00 1,640.88 9,845.28 46.882 11,154.72 122-60337-045-000 Transfer to Town/Fire Budget 718,657.00 718,657.00 59,888.08 359,328.48 50.000 359,328.52 11111Wtota1: = 957,661.00 957,661.00 61,528.96 122-69005-045-000 Capital Outlays 48,000.00 48,000.00 2,750.00 5.729 45,250.00 122-69009-045-000 Short Term Debt -Interest 11,958.24 11,958.24- 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 115,190.36 90.595 11,958.64 Subtota1: 256,569.00 256,569.00 211,318.60 82.‘11r 45, 23011.111 Program number: 1,214,230.00 1,214,230.00 61,528.96 798,496.36 65.762 415,733.64 Department number: Fire 1,214,230.00 1,214,230.00 61,528.96 798,496.36 65.762 415,733.64 Expenditures Subtotal 1,214,230.00 1,214,230.00 61,528.96 798,496.36 65.762 415,733.64 Fund number: 122 Trophy Club MUD Fire Dept. 48,855.91 416,348.84- 416,348.84 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Account: 122-40010-000- 1024 03/02/2020 Property Taxes 1025 03/03/2020 Property Taxes 1026 03/04/2020 Property Taxes 1027 03/05/2020 Property Taxes 1029 03/06/2020 Property Taxes 1031 03/10/2020 Property Taxes 1032 03/11/2020 Property Taxes 1033 03/12/2020 Property Taxes 1034 03/13/2020 Property Taxes 1035 03/16/2020 Property Taxes 1036 03/17/2020 Property Taxes 1037 03/18/2020 Property Taxes 1038 03/19/2020 Property Taxes 1039 03/20/2020 Property Taxes 1040 03/23/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes Account: 122-40010-000-6 1025 03/03/2020 Property Taxes 1030 03/09/2020 Property Taxes 1033 03/12/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 3/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes/MUD Fire Property Taxes/MUD Fire Totals: (1,214,230.00) Budgeted (1,196,917.88) (5,761.51) Remaining 100 % Used Property Taxes/Fire-Delinquent Account: 122-40011-000- Property Taxes/Fire-Delinquent Totals: .00 Budgeted 2,830.70 Remaining Account: 122-40020-000-00' 1024 03/02/2020 Property Taxes 1025 03/03/2020 Property Taxes 1026 03/04/2020 Property Taxes 1027 03/05/2020 Property Taxes 1029 03/06/2020 Property Taxes 1030 03/09/2020 Property Taxes 1032 03/11/2020 Property Taxes 1033 03/12/2020 Property Taxes Property Taxes/Fire P41 (2,421.97) (2,832.30) (931.42) (1,197,849.30) (155.26) (1,198,004.56) (1,145.95) (1,199,150.51) (165.11) (1,199,315.62) (1,738.27) (1,201,053.89) (44.12) (1,201,098.01) (452.54) (1,201,550.55) (35.16) (1,201,585.71) (619.11) (1,202,204.82) (503.62) (1,202,708.44) (993.41) (1,203,701.85) (535.69) (1,204,237.54) (604.77) (1,204,842.31) (246.24) (1,205,088.55) (596.01) (1,205,684.56) (487.78) (1,206,172.34) (2,296.15) (1,208,468.49) (11,5.) (1,208,468.49) ** (162.95) (2,584.92) (14.36) (2,599.28) (208.79) (2,808.07) (.02) (2,808.09) (22.61) (2,830.70) 0 % Used (59.60) (2,891.90) (51.62) (2,943.52) (82.19) (3,025.71) (11.55) (3,037.26) (121.66) (3,158.92) (3.73) (3,162.65) (40.73) (3,203.38) (61.51) (3,264.89) Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL T GL GL GL GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk 12:48 04/15/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description 1034 03/13/2020 Property Taxes 1035 03/16/2020 Property Taxes 1036 03/17/2020 Property Taxes 1040 03/23/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes Account: 122-40020-000-000 Department Totals: Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 3/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes/Fire P0 .00 Budgeted (12,673.05) Monthly Total (2,832.30) 3,546.01 Remaining 0 % Used (61.31) (3,326.20) (32.11) (3,358.31) (52.92) (3,411.23) (36.11) (3,447.34) (29.39) (3,476.73) (69.28) (3,546.01) (1,214,845.20) ** (1,214,230.00) Budgeted 615.20 Remaining 100 % Used Check Source Number GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2020 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 218,004.00 .00 218,004.00 Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 218,004.00 ** 218,004.00 Budgeted .00 Remaining 100 5 Used Account: 122-60055-045-000 Insurance 71 03/01/2020 Insurance/Wrk Comp Expense Mar 8,204.40 1,640.88 9,845.28 GL Account: 122-60055-045-000 Insurance Totals: 1,640.88 9,845.28 ** 21,000.00 Budgeted 11,154.72 Remaining 47 5 Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 891 03/05/2020 March A/P Fire admin march 299,440.40 59,888.08 359,328.48 TOWN OF TROPHY CLUB 6278 AP Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 59,888.08 359,328.48 ** 718,657.00 Budgeted 359,328.52 Remaining 50 % Used Account: 122-69005-045-000 Capital Outlays 2,750.00 .00 2,750.00 Account: 122-69005-045-000 Capital Outlays Totals: .00 2,750.00 ** 48,000.00 Budgeted 45,250.00 Remaining 6 % Used Account: 122-69009-045-000 Short Term Debt -Interest 11,958.24 .00 11,958.24 Account: 122-69009-045-000 Short Term Debt -Interest Totals: .00 11,958.24 ** .00 Budgeted (11,958.24) Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 115,190.36 .00 115,190.36 Account: 122-69305-045-000 Capital Leases Totals: .00 115,190.36 ** 127,149.00 Budgeted 11,958.64 Remaining 91 % Used Department 45 Totals: 798,496.36 ++ 61,528.96 Monthly Total 1,214,230.00 Budgeted 415,733.64 Remaining 66 % Used Fund 122 Totals: (416,348.84) 48,855.91 Monthly Total .00 Budgeted 416,348.84 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET MARCH 2020 RP TROPHY CLI MUNICIPAL UTILITY DISTRICT No.1 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,787,572 2,787,572 CASH IN BANK -SAVINGS -CASH RESERVE 1,602,621 1,602,621 INVESTMENTS-TEXPOOL 3,774,203 919,266 4,693,469 PREPAID EXPENSES 57,407 57,407 ADVALOREM PROPERTY TAXES RECEIVABLE 4,636 4,636 UTILITY AND OTHER ACCOUNTS RECEIVABLE 794,494 794,494 TOTAL ASSETS 9,021,533 919,266 9,940,799 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,636 4,636 ACCOUNTS AND OTHER PAYABLES 354,869 354,869 CUSTOMER DEPOSITS 316,540 316,540 TOTAL LIABILITIES 676,045 676,045 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 2,072,098 2,072,098 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 270,000 270,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 30,000 30,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 127,805 127,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 391,461 391,461 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 100,000 100,000 UNASSIGNED FUND BALANCE 6,325,800 6,325,800 COMMITTED FUND BALANCE - NET REVENUES / EXPENDITURES (55,896) (55,896) TOTAL FUND BALANCE 8,345,488 919,266 9,264,754 TOTAL LIABILITIES AND FUND BALANCE 9,021,533 919,266 9,940,799 glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Subtotal: Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges 134,871.00- 300.00- 300.00- 164,253.00- 134,871.00- 300.00- 300.00- 164,253.00- 1,282.27- 46.51- 79.53- 134,154.72- 292.80- 384.98- 99.469 97.600 128.327 716.28- 7.20- 84.98 164,253.00- 299,724.00- 299,724.00- 1,408.31- 134,832.50- 44.986 J. 164,891.50- 135-47000-000-000 Water 6,486,623.00- 6,486,623.00- 296,299.54- 2,101,814.57- 32.402 4,384,808.43- 135-47005-000-000 Sewer 3,503,885.00- 3,503,885.00- 250,710.40- 1,501,759.99- 42.860 2,002,125.01- 135-47025-000-000 Penalties 112,608.00- 112,608.00- 6,221.03- 52,117.51- 46.282 60,490.49- 135-47030-000-000 Service Charges 15,150.00- 15,150.00- 1,000.00- 9,800.00- 64.686 5,350.00- 135-47035-000-000 Plumbing Inspections 750.00- 750.00- 2,250.00- 300.000 1,500.00 135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00- 1,350.00- 54.000 1,150.00- 135-47070-000-000 TCCC Effluent Charges 50,000.00- 50,000.00- 15,068.00- 30.136 34,932.00 - Subtotal: 10,171,516.00- 10,171,516.00- 554,230.97- 3,684,160.07- 36.220 6,487,355.93- 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income 120,000.00- 120,000.00- 14,146.00- 14,146.00- 7,000.00- 7,000.00- 13,000.00- 13,000.00- 12,691.00- 12,691.00- 7,000.00- 7,000.00- 7,296.68- 583.33- 254.44- 59,107.74- 5,894.05- 3,499.98- 49.256 41.666 50.000 7,730.28- 60.912 8,596.20- 122.803 60,892.26- 8,251.95- 3,500.02- 13,000.00- 4,960.72- 1,596.20 0,892.26-8,251.95-3,500.02-13,000.00- 4,960.72- 1,596.20 Subtotal: 173,837.00- 173,837.00- 8,134.45- 84,828.25- 48.798 89,008.75 - mm Program number: 10,645,077.00- 10,645,077.00- 563,773.73- 3,903,820.82- 36.673 6,741,256.18 - Department number: Revenues 10,645,077.00- 10,645,077.00- 563,773.73- 3,903,820.82- 36.673 6,741,256.18 - Revenues Subtotal 10,645,077.00- 10,645,077.00- 563,773.73- 3,903,820.82- 36.673 6,741,256.18- glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 350,267.00 350,267.00 135-50010-010-000 Overtime 17,000.00 17,000.00 135-50016-010-000 Longevity 3,920.00 3,920.00 135-50017-010-000 Certification 5,400.00 5,400.00 135-50020-010-000 Retirement 34,863.00 34,863.00 135-50026-010-000 Medical Insurance 84,326.00 84,326.00 135-50027-010-000 Dental Insurance 4,725.00 4,725.00 135-50028-010-000 Vision Insurance 767.00 767.00 135-50029-010-000 Life Insurance & Other 3,132.00 3,132.00 135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 135-50045-010-000 Workman's Compensation 11,850.00 11,850.00 135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-010-000 Employee Relations 300.00 300.00 30,099.11 162,362.11 1,475.58 10,337.34 5,082.50 425.00 2,500.00 2,963.16 17,765.74 5,225.04 29,603.66 316.63 1,798.11 48.18 284.29 352.89 1,905.55 1,957.27 11,047.48 457.75 2,583.66 817.03 880.68 946.99 4,804.44 46.354 60.808 129.656 46.296 50.959 35.106 38.055 37.065 60.841 47.317 47.311 81.544 40.544 FSubtotal: ' 546,839.00 546,839.00 45,084.63 250,955.56 135-55005-010-000 Engineering 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 439.19 23,715.69 23.716 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 1,114.89 1,842.56 36.851 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 907.82 1,828.19 52.234 135-55120-010-000 Cleaning Services 1,000.00 1,000.00 87.50 437.50 43.750 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 433.94 2,031.64 27.089 187,904.89 6,662.66 1,162.50- 2,900.00 17,097.26 54,722.34 2,926.89 482.71 1,226.45 12,300.52 2,877.34 199.32 7,045.56 400.00 300.00 295,883.44 20,000.00 76,284.31 3,000.00 3,157.44 1,671.81 562.50 5,468.36 140,000.00 140,000.00 2,983.34 29,855. 110,144.42 135-60010-010-000 Communications/Mobiles 5,000.00 5,000.00 135-60020-010-000 Electricity 125,677.00 125,677.00 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 135-60070-010-000 Dues & Memberships 500.00 500.00 135-60080-010-000 Schools & Training 7,426.00 7,426.00 135-60090-010-000 Safety Program 400.00 400.00 135-60100-010-000 Travel & per diem 2,845.00 2,845.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 63,000.00 63,000.00 135-60150-010-000 Wholesale Water 2,714,710.00 2,714,710.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 135-60332-010-000 Interfund Transfer Out -Rev I&S 527,381.00 527,381.00 135-60333-010-000 Interfund Transfer Out -Reserve 55,193.00 55,193.00 135-60334-010-000 Interfund Transfer Out 180,000.00 180,000.00 424.30 2,897.25 18,908.17 65,059.77 240.00 1,436.00 16,942.84 86,448.49 658,469.22 756.00 750.00 750.00 25,047.72 333,454.48 4,600.00 27,600.00 57.945 51.767 19.337 26.893 24.256 25.200 5.085 63.228 50.006 2,102.75 60,617.23 1,000.00 500.00 5,990.00 400.00 2,845.00 1,500.00 46,057.16 2,056,240.78 200.00 2,244.00 14,000.00 193,926.52 27,593.00 180,000.00 136,418.68 glbase_tbam skrolczyk 12:47 04/15/20 Department: 10 Water Account 135-60360-010-000 Description Furniture/Equipment < $5000 Trophy Club MUD No.1 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Program: Period Ending: 3/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,500.00 2,500.00 561.72 22.469 1,938.28 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 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 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 15,000.00 15,000.00 5,190.00 5,190.00 20,000.00 20,000.00 1,200.00 1,200.00 1,000.00 1,000.00 70,000.00 70,000.00 87,000.00 87,000.00 684,875.00 684,875.00 30,512.00 30,512.00 3,231.00 3,231.00 75,000.00 75,000.00 120,000.00 120,000.00 3,618.00 5,504,929.00 5, 906.24 2,287.34 12,503.46 5,421.15 2,917.33 11,303.84 16,869.78 36,900.00 189,213.49 30,512.00 1,840.00 75,000.00 102,077.11 36.141 9,578.85 56.211 2,272.67 56.519 8,696.16 1,200.00 1,000.00 24.100 53,130.22 42.414 50,100.00 27.627 100.000 56.948 100.000 85.064 7 495,661.51 1,391.00 17,922.89 glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/2020 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 PU1111111111 2,000.00 2,000.00 Department number: Water 5,506,929.00 5,506,929.00 293.94 293.94 293.94 200,477.63 841.64 841.64 841.64 1,861,634.76 42.082 1,158.36 42.082 1,158.36 42.082 1,158.36 33.805 3,645,294.2 Page 6 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 135 MUD 1 General Fund Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Program: Period Ending: 3/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 441,799.00 441,799.00 135-50010-020-000 Overtime 33,000.00 33,000.00 135-50016-020-000 Longevity 8,035.00 8,035.00 135-50017-020-000 Certification 9,000.00 9,000.00 135-50020-020-000 Retirement 45,531.00 45,531.00 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 135-50028-020-000 Vision Insurance 948.00 948.00 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 FSubtotal: 135-55005-020-000 Engineering 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 135-55081-020-000 Mainten & Revairs Collections 10,000.00 10,000.00 135-55085-020-000 Generator Meant. and Repair 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 31,844.60 182,682.53 41.350 259,116.47 1,577.13 11,342.43 34.371 21,657.57 6,872.50 85.532 1,162.50 625.00 3,825.00 42.500 5,175.00 3,152.73 20,485.72 44.993 25,045.28 7,738.24 41,528.31 39.604 63,329.69 446.90 2,432.32 41.814 3,384.68 69.74 390.17 41.157 557.83 428.07 2,214.50 49.211 2,285.50 1,955.07 11,870.39 38.927 18,623.61 457.23 2,776.13 38.925 4,355.87 936.10 995.22 78.986 264.78 1,285.70 6,836.70 44.472 8,536.30 38.00 9.500 362.00 300.00 6.51 294,289.92 111111i540 414,157.08 30,000.00 3,000.00 20.000 12,000.00 6,136.74 41,580.62 47.251 46,419.38 45.88 17,723.66 177.237 7,723.66- 10,000.00 51.00 793.98 19.850 3,206.02 24.94 2,011.88 25.149 5,988.12 272.55 832.22 27.741 2,167.78 87.50 437.50 29.167 1,062.50 4,803.76 43,283.38 43.283 56,716.62 3,995.25 19,043.90 47.610 20,956.10 417.62 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 135-60020-020-000 Electricity 160,067.00 160,067.00 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 135-60080-020-000 Schools & Training 4,990.00 4,990.00 135-60090-020-000 Safety Program 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,545.00 1,545.00 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 15,000.00 15,000.00 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 408.87 3,088.27 61.765 1,911.73 447.24 61,290.51 38.291 98,776.49 200.00 105.00 216.00 72.000 84.00 531.00 2,962.85 59.376 2,027.15 109.14 10.914 890.86 49.88 410.72 26.584 1,134.28 5,000.00 2,500.00 10,088.02 67.253 4,911.98 450.00 584.94 11.699 4,415.06 glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Subtotal: r 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 135-65010-020-000 Uniforms 5,495.00 5,495.00 135-65030-020-000 Chemicals 20,000.00 20,000.00 135-65031-020-000 Chemicals Collections 17,500.00 17,500.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 135-65045-020-000 Lab Supplies 20,000.00 20,000.00 Lawn Equipment & Maintenance 14,000.00 14,000.00 Interfund Transfer Out -Tax I&S 114,563.00 114,563.00 Interfund Transfer Out -Rev I&S 673,867.00 673,867.00 Interfund Transfer Out -Reserve 125,187.00 125,187.00 Interfund Transfer Out 180,000.00 180,000.00 Furniture/Equipment < $5000 2,000.00 2,000.00 1,310,669.00 135-69005-020-000 Capital Outlays 530,500.00 530,500.00 135-69008-020-000 Short Term Debt -Principal 79,133.00 79,133.00 135-69009-020-000 Short Term Debt -Interest 11,277.00 11,277.00 135-69195-020-000 Gasb34/Reserve for Replacement 130,000.00 130,000.00 19 750,910.00 Program number: Department number: Wastewater 3,157,421.00 1 1 1 590.00 590.00 4.214 13,410.00 10,414.81 62,488.86 54.545 52,074.14 54,421.63 381,241.74 56.575 292,625.26 5,750.00 34,500.00 27.559 90,687.00 180,000.00 190.00 9.500 1,810.00 557,761.05 42.555 752,907.95 491.70 2,204.08 54.90 5,432.82 12,510.11 12,510.11 159,346.17 159,346.17 4,246.70 33.974 8,253.30 3,507.93 63.839 1,987.07 14,928.95 74.645 5,071.05 4,994.00 28.537 12,506.00 1,200.00 1,166.53 97.211 33.47 16,270.18 81.351 3,729.82 172,538.00 32.524 357,962.00 59,604.74 75.322 19,528.26 6,122.03 54.288 5,154.97 130,000.00 100.000 368,264.77 382,645.23 1,394,137. 1,763,283.13 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 135 MUD 1 General Fund Account 135-50045-026-000 Description Workman's Compensation Trophy Club MUD No.1 Budget Summary with Amendment Department: 26 Board of Directors Period Ending: 3/2020 Adopted Amended Total Current Budget Budget Encumb. Month 30.00 30.00 1.99 Program: YTD Total 11.94 % of Remaining Budget Budget 39.800 18.06 Subtotal: 30.00 30.00 1.99 11.94 39.800 18.06 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 675.00 176.28 90.000 13.560 150.00 75.00 1,123.72 4,000.00 5,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 851.28 6.449 12,348.72 Program number: 13,230.00 13,230.00 1.99 863.22 6.525 12,366.78 L Department number: Board of Directors 13,230.00 13,230.00 1.99 863.22 6.525 12,366.78 glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 628,298.00 628,298.00 29,223.93 135-50010-030-000 Overtime 2,000.00 2,000.00 11.24 135-50016-030-000 Longevity 2,208.00 2,208.00 135-50020-030-000 Retirement 58,554.00 58,554.00 2,707.18 135-50026-030-000 Medical Insurance 124,394.00 124,394.00 6,345.77 135-50027-030-000 Dental Insurance 6,464.00 6,464.00 349.75 135-50028-030-000 Vision Insurance 1,035.00 1,035.00 51.68 135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 359.91 135-50030-030-000 Social Security Taxes 39,215.00 39,215.00 1,669.17 135-50035-030-000 Medicare Taxes 9,171.00 9,171.00 390.37 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 797.17 135-50045-030-000 Workman's Compensation 1,775.00 1,775.00 104.82 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 135-50070-030-000 Employee Relations 8,000.00 8,000.00 178,489.43 31.77 2,207.50 18,232.16 35,503.74 1,968.45 301.35 1,995.36 10,460.02 2,446.32 843.83 628.92 3,078.10 28.408 449,808.57 1.589 1,968.23 99.977 .50 31.137 40,321.84 28.541 88,890.26 30.453 4,495.55 29.116 733.65 44.341 2,504.64 26.674 28,754.98 26.675 6,724.68 58.599 596.17 35.432 1,146.08 500.00 38.476 4,921.90 42,010.99 256,186.95 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 Cleanin? Services Professional Outside Services Utility Billing Contract 134,681.00 134,681.00 135,000.00 135,000.00 15,000.00 15,000.00 10,000.00 10,000.00 10,000.00 10,000.00 65,600.00 65,600.00 9,000.00 9,000.00 135-60005-030-000 Telephone 23,680.00 23,680.00 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 135-60020-030-000 Electricity/Gas 6,879.00 6,879.00 135-60025-030-000 Water 1,500.00 1,500.00 135-60035-030-000 Postage 30,000.00 30,000.00 135-60040-030-000 Service Charges & Fees 67,000.00 67,000.00 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 135-60055-030-000 Insurance 84,000.00 84,000.00 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 135-60075-030-000 Meetings 400.00 400.00 135-60079-030-000 Public Education 6,000.00 6,000.00 135-60080-030-000 Schools & Training 6,850.00 6,850.00 135-60100-030-000 Travel & per diem 3,545.00 3,545.00 135-60110-030-000 Physicals/Testing 200.00 200.00 135-60115-030-000 Elections 135-60125-030-000 Advertising 2,500.00 2,500.00 4,833.93 2,615.53 869.06 2,500.00 1,167.23 1,480.62 237.75 753.27 126.07- 3,346.77 5,301.14 6,998.39 53.72 161.82 219.00 19.02 1,772.20 131,676.58 57,200.02 1,165.00 531.00 4,345.30 2,500.00 3,642.04 97.769 42.370 7.767 5.310 43.453 3.811 40.467 3,004.42 77,799.98 13,835.00 9,469.00 5,654.70 63,100.00 5,357.96 201,0 178,2 8,880.17 1,427.31 2,753.81 257.82 10,153.57 36,723.18 38,428.48 125.00 4,285.55 115.09 3,971.51 1,382.21 714.16 138.04 1,772.20 37.501 35.683 40.032 17.188 33.845 54.811 45.748 12.500 71.426 28.773 66.192 20.178 20.146 70.888 14,799.83 2,572.69 4,125.19 1,242.18 19,846.43 30,276.82 1,500.00 45,571.52 875.00 1,714.45 284.91 2,028.49 5,467.79 2,830.84 200.00 138.04- 727.80 glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60360-030-000 Security Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 1,288.00 1,288.00 500.00 500.00 17,000.00 17,000.00 2,500.00 2,500.00 135-65010-030-000 Uniforms 2,050.00 2,050.00 135-65055-030-000 Hardware 26,485.00 26,485.00 135-65085-030-000 Office Supplies 6,000.00 6,000.00 135-65090-030-000 Printer Supplies & Maintenance 3,500.00 3,500.00 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 135-65105-030-000 Printing 2,500.00 2,500.00 135-69005-030-000 Capital Outlays 195,000.00 135-69170-030-000 Copier Lease Installments 4,000.00 Program number: Department number: Administration 195,000.00 4,000.00 ,000.00 ,712.00 .712.00 24.00 144.00 11.180 20,241.63 111,272.10 198.01 110.83 3,235.24 12.215 2,200.25 36.671 2,809.63 70.241 1,144.00 500.00 17,000.00 2,500.00 2,050.00 23,249.76 3,799.75 3,500.00 1,190.37 2,500.00 8,245.12 2,867.91 2,915.30 1.495 192,084.70 274.86 1,546.33 38.658 2,453.67 4,461.42 194,538.37 581,225. 32.714 X195,486.26 581,225.74 32.714 1,195,486.26 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 135 MUD 1 General Fund Account Description 135-55045-039-000 135-55055-039-000 135-55060-039-000 135-55065-039-000 Le al Auditing_ Appraisal Tax Admin Fees Trophy Club MUD No.1 Budget Summary with Amendment Department: 39 Non Departmental Program: Period Ending: 3/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135,000.00 33,800.00 11,761.00 4,000.00 135,000.00 33,800.00 11,761.00 4,000.00 26,262.50 2,243.48 82,964.89 27,713.27 7,422.04 3,756.00 61.455 81.992 63.107 93.900 52,035.11 6,086.73 4,338.96 244.00 Page 12 p• Subtotal: ' 184,561.00 184,561.00 28,505.98 121,856.20 66.025 62,704.80 Program number: 184,561.00 184,561.00 28,505.98 121,856.20 66.025 62,704.80 Department number: Non Departmental 184,561.00 184,561.00 28,505.98 121,856.20 66.025 62,704.80 Expenditures Subtotal 10,638,853.00 10,638,853.00 466,021.75 3,959,717.09 37.219 6,679,135.91 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 97,751.98- 55,896.27 -898.076 62,120.27- glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASS Department: Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer -General Fund 205,000.00- 205,000.00 137-49146-000-000 Intergov Transfer -Fire Dept 81,420.00- 81,420.00 Subtot 286, H Program number: 286,420.00- 286,420.00 Department number: 286,420.00- 286,420.00 Revenues Subtotal 286,420.00- 286,420.00 Fund number: 137 MUD 1 Consolidated GASB 286,420.00- 286,420.00 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Ac0ount: 135-40000-000- 1024 03/02/2020 Property Taxes 1025 03/03/2020 Property Taxes 1026 03/04/2020 Property Taxes 1027 03/05/2020 Property Taxes 1029 03/06/2020 Property Taxes 1031 03/10/2020 Property Taxes 1032 03/11/2020 Property Taxes 1033 03/12/2020 Property Taxes 1034 03/13/2020 Property Taxes 1035 03/16/2020 Property Taxes 1036 03/17/2020 Property Taxes 1037 03/18/2020 Property Taxes 1038 03/19/2020 Property Taxes 1039 03/20/2020 Property Taxes 1040 03/23/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 3/2020 JE Detail Beginning Description/Comment Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number Property Taxes (132,872.45) (103.40) (132,975.85) (17.24) (132,993.09) (127.21) (133,120.30) (18.33) (133,138.63) (192.97) (133,331.60) (4.90) (133,336.50) (50.24) (133,386.74) (3.90) (133,390.64) (68.73) (133,459.37) (55.91) (133,515.28) (110.28) (133,625.56) (59.47) (133,685.03) (67.14) (133,752.17) (27.34) (133,779.51) (66.16) (133,845.67) (54.15) (133,899.82) (254.90) (134,154.72) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-b Property Taxes Totals: (134,871.00) Budgeted (716.28) Remaining 99 % Used Account: 135-40002-000-00 1025 03/03/2020 Property Taxes 1030 03/09/2020 Property Taxes 1033 03/12/2020 Property Taxes 1042 03/31/2020 Property Taxes Property Taxes/Delinquent Account: 135-40015-000-000 1024 03/02/2020 Property Taxes 1025 03/03/2020 Property Taxes 1026 03/04/2020 Property Taxes 1027 03/05/2020 Property Taxes 1029 03/06/2020 Property Taxes 1030 03/09/2020 Property Taxes 1032 03/11/2020 Property Taxes 1033 03/12/2020 Property Taxes 1034 03/13/2020 Property Taxes Property Taxes/Delinquent (300.00) Budgeted Property Taxes/P & I (246.29) (7.20) Remaining 98 % Used (305.45) (18.55) (1.63) (23.76) (2.57) (6.62) (5.84) (9.13) (1.28) (13.51) (.43) (4.52) (6.98) (6.81) (264.84) (266.47) (290.23) (292.80) (312.07) (317.91) (327.04) (328.32) (341.83) (342.26) (346.78) (353.76) (360.57) GL GL GL GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 1035 03/16/2020 Property Taxes 1036 03/17/2020 Property Taxes 1040 03/23/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes 135-40015n76611- Property Taxes/P & I Totals: (300.00) Budgeted (305.45) 84.98 Remaining 128 % Used (3.56) (5.87) (4.01) (3.26) (7.71) (364.13) (370.00) (374.01) (377.27) (384.98) GL GL GL GL GL Account: 135-40025-000-000 PID Surcharges Account: 135-40025-000-000 PID Surcharges (164,253.00) Budgeted Account: 135-47000-000-000 995 03/31/2020 UB 03/31/2020 Billing (164,253.00) Remaining 0 % Used UB20200331-20200331 User: (1,805,515.03) .00 .00 .00 (296,299.54) (2,101,814.57) UB Account: 135-47000-000-00 96,299.54 (6,486,623.00) Budgeted (4,384,808.43) Remaining Account: 135-47005-000-0 995 03/31/2020 UB 03/31/2020 Billing UB20200331-20200331 User: 32 % Used (1,251,049.59) (250,710.40) (1,501,759.99) UB AC (3,503,885.00) Penaltie Budgeted (2,002,125.01) Remaining 904 03/09/2020 UB 03/09/2020 Penalty removal UB20200309-20200309 User: 945 03/18/2020 UB 03/18/2020 Penalty removal UB20200318-20200318 User: 963 03/23/2020 UB 03/23/2020 Penalties UB20200323-20200323 User: 989 03/30/2020 penalty removal UB20200330-20200330 User: 990 03/31/2020 penalty removals UB20200331-20200331 User: 43 (45,896.48) Used 1,329.06 (44,567.42) 125.09 (44,442.33) (8,741.12) (53,183.45) 628.77 (52,554.68) 437.17 (52,117.51) UB UB UB UB UB Penalties Totals: (112,608.00) Budgeted (60,490.49) Remaining 46 % Used Service glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 914 03/10/2020 UB 03/10/2020 Disconnect Fees UB20200310-20200310 User: 953 03/13/2020 UB 03/13/2020 NSF Check UB20200313-20200313 User: 945 03/18/2020 UB 03/18/2020 Penalty removal UB20200318-20200318 User: 964 03/19/2020 UB 03/19/2020 NSF Check UB20200319-20200319 User: (8,800.00) (1,000.00) (9,800.00) UB (25.00) (9,825.00) UB 50.00 (9,775.00) UB (25.00) (9,800.00) UB Account: 135-47030-000-000 Service Charges Totals: (1,000.00) ■ (9,800.00) ** (15,150.00) Budgeted (5,350.00) Remaining 65 % Used Account: 135-47035-000-000 Plumbing Inspections (2,250.00) .00 (2,250.00) Account: 135-47035-000-000 Plumbing Inspections Totals: .00 (2,250.00) ** (750.00) Budgeted 1,500.00 Remaining 300 % Used Account: 135-47045-000-000 Sewer Inspections (1,350.00) .00 (1,350.00) Account: 135-47045-000-000 Sewer Inspections Totals: .00 (1,350.00) ** (2,500.00) Budgeted (1,150.00) Remaining 54 % Used Account: 135-47070-000-000 TCCC Effluent Charges (15,068.00) .00 (15,068.00) Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (15,068.00) ** (50,000.00) Budgeted (34,932.00) Remaining 30 5 Used Account: 135-49011-000-000 Interest Income 1047 03/31/2020 Bank Interest- March 1047 03/31/2020 Bank Interest- March 1047 03/31/2020 Bank Interest- March (51,811.06) (1,155.83) (52,966.89) GL (1,161.71) (54,128.60) GL (4,979.14) (59,107.74) GL Account: 135-49011-000-000 ■ come Totals: (7,296.68) (59,107.74) ** (120,000.00) Budgeted (60,892.26) Remaining 49 5 Used Account: 135-49016-000-000 Cell Tower Revenue (5,894.05) .00 (5,894.05) Account: 135-49016-000-000 Cell Tower Revenue Totals: .00 (5,894.05) ** (14,146.00) Budgeted (8,251.95) Remaining 42 % Used glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 3/2020 JE Detail Description/Comment Account: 135-49018-000-0 Building Rent Incom 1028 03/31/2020 Town Billed Invoices 1730-1733 AR 20200331-20200331 User: Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-49018-00 Building Rent Ince (7,000.00) Budgeted (3,500.02) Remaining (2,916.65) (583.33) (3,499.98) AR 50 Ueed Account: 135-49026-000-000 • Proceeds from Sale of Assets Account: 135-49026-000-000 ■ Proceeds from Sale of Assets (13,000.00) Budgeted (13,000.00) Remaining .00 0 % Ueed .00 Oversize Meter Reimbursement Account: - - - Oversize Meter Reimbursement Totals: (12,691.00) Budgeted (4,960.72) Remaining Account: 135-49900-000-000 Miscellaneous Income 995 03/31/2020 UB 03/31/2020 Billing UB20200331-20200331 User: Account: 135-49900-000-000 (7,730.28) .00 (7,730.28) 61 % Used (8,341.76) (254.44) Miscellaneous In (254.44) (7,000.00) Budgeted 1,596.20 Remaining 123 % Used (8,596.20) UB (8,596.20) ** Department Totals: (3,903,820.82) ** (563,773.73) Monthly Total (10,645,077.00) Budgeted (6,741,256.18) Remaining 37 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2020 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 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Salaries & Wages 132,263.00 933 03/20/2020 MUD Payroll 3/20/2020 Salaries & Wages 14,944.73 147,207.73 PR 15,154.38 162,362.11 PR Account: 135-50005-010-000 Salaries & Wages Totals: 30,099.11 162,362.11 ** 350,267.00 Budgeted 187,904.89 Remaining 46 % Used Account: 135-50010-010-000 Overtime 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Overtime 8,861.76 691.45 9,553.21 PR 933 03/20/2020 MUD Payroll 3/20/2020 Overtime 784.13 10,337.34 PR Account: 135-50010-010-000 Overtime Totals: 1,475.58 10,337.34 ** 17,000.00 Budgeted 6,662.66 Remaining 61 % Used Account: 135-50016-010-000 Longevity 5,082.50 .00 5,082.50 Account: 135-50016-010-000 Longevity Totals: .00 5,082.50 ** 3,920.00 Budgeted (1,162.50) Remaining 130 % Used Account: 135-50017-010-000 Certification 933 03/20/2020 MUD Payroll 3/20/2020 Certification 2,075.00 425.00 2,500.00 PR Account: 135-50017-010-000 Certification Totals: 425.00 2,500.00 ** 5,400.00 Budgeted 2,900.00 Remaining 46 % Used Account: 135-50020-010-000 Retirement 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Retirement 933 03/20/2020 MUD Payroll 3/20/2020 Retirement 14,802.58 1,447.89 16,250.47 PR 1,515.27 17,765.74 PR Account: 135-50020-010-000 Retirement Totals: 2,963.16 17,765.74 ** 34,863.00 Budgeted 17,097.26 Remaining 51 % Used Account: 135-50026-010-000 Medical Insurance 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Medical Insurance 24,378.62 933 03/20/2020 MUD Payroll 3/20/2020 Medical Insurance 2,612.55 26,991.17 PR 2,612.49 29,603.66 PR Account: 135-50026-010-000 Medical Insurance Totals: 5,225.04 29,603.66 ** 84,326.00 Budgeted 54,722.34 Remaining 35 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2020 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- 1 Insul 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Dental Insurance 933 03/20/2020 MUD Payroll 3/20/2020 Dental Insurance 1,481.48 158.32 1,639.80 PR 158.31 1,798.11 PR Account: -1.1 Dental Ineuranc Totals: mEllir 4,725.00 Budgeted 2,926.89 Remaining 38 % Used Account: 135-50028-010-000 ion Insurance 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Vision Insurance 933 03/20/2020 MUD Payroll 3/20/2020 Vision Insurance 236.11 24.10 260.21 24.08 284.29 PR PR Account: Vision Insurance Totals: - 812 03/01/2020 March Payroll Benefits 812 03/01/2020 March Payroll Benefits 966 03/23/2020 March A/P 1063 03/31/2020 March A/P Account: 135-50029-010-00 767.00 Budgeted e Insurance & Other Employee Benefits Employee LTD & STD Caf 125 Caf 125 Life Insuran• 3,132.00 Budgeted 482.71 Remaining 37 % Used 1,226.45 Account: 135-50030-010- ocial Securi 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Social Security Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Social Security Taxes A Remaining 030-037"911111111111111111.Social Security Taxes AL Totals: 23,348.00 Budgeted 12,300.52 Remaining Account: 135-50035-010-000 Medicare Taxes 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Medicare Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Medicare Taxes • 1,552.66 176.88 1,729.54 Humana Inc 6223 AP 132.01 1,861.55 METLIFE GROUP BENEFITS 6231 AP 22.00 1,883.55 BenefitMall 6295 AP 22.00 1,905.55 BenefitMall AP 9,090.21 2,125.91 61 Used 959.58 10,049.79 997.69 11,047.48 47 % Used 224.43 2,350.34 PR PR PR 233.32 2,583.66 PR Account Medicare Taxes Totals: 5,461.00 Budgeted 2,877.34 Remaining 47 % Used Account: 135-5004 Unemployment Taxes glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Unemployment Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Unemployment Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 63.65 5.38 811.65 69.03 880.68 PR PR 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 Carb+Ignit Coil Air Filter kit fluid, flat back, bushing quick connects, hose gauge refund gauge 23,276.50 19.98 48.63 90.88 107.39 (142.12) 209.43 23,296.48 AMZN MKTP US*I82AK8HT3 23,345.11 THE HOME DEPOT 86581 23,435.99 IN *HOSE TECH USA 23,543.38 GALCO INDUSTRIAL ELECT 23,401.26 GALCO INDUSTRIAL ELECT 23,610.69 GALCO INDUSTRIAL ELECT PC PC PC PC PC PC Account: 135-50040-010-000 Unemployment Taxes Totals: 817.03 880.68 ** 1,080.00 Budgeted 199.32 Remaining 82 % Used Account: 135-50045-010-000 Workman's Compensation 71 03/01/2020 Insurance/Wrk 923 03/12/2020 March A/P Comp Expense Mar WC FY 19 Adjustment 3,857.45 771.49 175.50 4,628.94 4,804.44 TML INTERGOVERNMENTAL RISK 6277 GL AP Account: 135-50045-010-000 Workman's Compensation Totals: 946.99 ** 11,850.00 Budgeted 7,045.56 Remaining 41 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations .00 .00 Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance A Repairs 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 Carb+Ignit Coil Air Filter kit fluid, flat back, bushing quick connects, hose gauge refund gauge 23,276.50 19.98 48.63 90.88 107.39 (142.12) 209.43 23,296.48 AMZN MKTP US*I82AK8HT3 23,345.11 THE HOME DEPOT 86581 23,435.99 IN *HOSE TECH USA 23,543.38 GALCO INDUSTRIAL ELECT 23,401.26 GALCO INDUSTRIAL ELECT 23,610.69 GALCO INDUSTRIAL ELECT PC PC PC PC PC PC glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 3/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number I 1001 03/26/2020 PCards 2/27/2020-3/26/2020 gauge check/calibration 23,276.50 105.00 23,715.69 MACARTHUR GAUGE INC PC Account: 135-55080-010-000 Maintenance & Repairs Totals: 439.19 23,715.69 ** Used 100,000.00 Budgeted 76,284.31 Remaining 24 % Used Account: 135-55105-010-000 Account: 135-55085-010-000 Generator Maint. and Repair 111r- 923 03/12/2020 March A/P backhoe windsheild 920.37 .00 .00 1,828.19 HOLT CAT 135-55085-010-000 Generator Maint. and Repair Totals: Account: 135-55105-010-000 —AVAccount: .00 .00 ** 907.82 1,828.19 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance Account: 1001 03/26/2020 PCards 2/27/2020-3/26/2020 vehicle registration 727.67 22.00 749.67 DENTON VEHREG PC 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 veh registration fee back glass install tires oil change, parking brake 2.00 751.67 TX.GOV*SERVICEFEE-DIR 243.56 995.23 ELITE AUTO GLASS 335.50 1,330.73 DISCOUNT TIRE TXD 75 511.83 1,842.56 INLAND TRUCK PARTS # PC PC PC PC Account: 135-55090-010-000 Vehicle Maintenance Totals: 1,114.89 1,842.56 ** - 5,000.00 Budgeted 3,157.44 Remaining 37 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 111r- 923 03/12/2020 March A/P backhoe windsheild 920.37 907.82 1,828.19 HOLT CAT 6264 AP Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 907.82 1,828.19 ** 3,500.00 Budgeted 1,671.81 Remaining 52 % Used Account: 135-55120-010-000 Cleaning Services 966 03/23/2020 March A/P janitorial svc-february 350.00 87.50 437.50 MEMBER'S BUILDING MAINTENANCE 6309 AP Account: 135-55120-010-000 Cleaning Services Totals: 87.50 437.50 ** 1,000.00 Budgeted 562.50 Remaining 44 % Used Account: 135-55135-010-000 Lab Analysis 923 03/12/2020 923 03/12/2020 March A/P March A/P water samples TCEQ samples 1,597.70 220.00 213.94 1,817.70 2,031.64 TARRANT CTY PUBLIC HEALTH LAB LOWER COLORADO RIVER AUTHORITY 6272 6267 AP AP Account: 135-55135-010-000 Lab Analysis Totals: 433.94 2,031.64 ** 7,500.00 Budgeted 5,468.36 Remaining 27 % Used glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 3/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number Account: 135-60010-010-000 7 Communications/Mobiles i_ AM 923 03/12/2020 March A/P Cell phones -March 2,472.95 424.30 2,897.25 VERIZON WIRELESS 6281 AP Account: 135-60010-010-000 Communications/Mobiles Totals: 424.30 2,897.25 ** 5,000.00 Budgeted 2,102.75 Remaining 58 % Used Account: 135-60020-010-000 Electricity 966 03/23/2020 March A/P Electricity 2/10-3/10 966 03/23/2020 March A/P Electricity 2/10-3/10 46,151.60 12,367.52 6,540.65 58,519.12 65,059.77 HUDSON ENERGY SERVICES, HUDSON ENERGY SERVICES, LLC LLC 6303 6303 AP AP Account: 135-60020-010-000 Electricity Totals: 18,908.17 65,059.77 125,677.00 Budgeted 60,617.23 Remaining 52 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 1001 03/26/2020 PCards 2/27/2020-3/26/2020 M. Hubbard Mid Citie Dist Memb 1001 03/26/2020 PCarde 2/27/2020-3/26/2020 C.Howard Mid Cities Dist Memb 1,196.00 120.00 120.00 1,316.00 1,436.00 TRAINING TRAINING PC PC Account: 135-60080-010-000 Schools & Training J Totals: 240.00 1,436.00 ** 7,426.00 Budgeted 5,990.00 Remaining 19 s Used Account: 135-60090-010-000 T Safety Program .00 .00 Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 3/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number Account: 135-60100-010-000"IIIITravel & per diem .00 .00 Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 2,845.00 Budgeted 2,845.00 Remaining 0 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 16,942.84 16,942.84 .00 Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 16,942.84 ** 63,000.00 Budgeted 46,057.16 Remaining 27 % Used Account: 135-60150-010-000 Wholesale Water 966 03/23/2020 March A/P wholesale water 572,020.73 86,448.49 658,469.22 CITY OF FORT WORTH 6296 AP Account: 135-60150-010-000 Wholesale Water Totals: 86,448.49 658,469.22 ** 2,714,710.00 Budgeted 2,056,240.78 Remaining 24 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 756.00 .00 756.00 Account: 135-60280-010-000 Property Maintenance Totals: .00 756.00 ** 3,000.00 Budgeted 2,244.00 Remaining 25 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1058 03/31/2020 March A?P Mowing -March 750.00 750.00 WATTS ELLISON LLC AP Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 750.00 750.00 ** 14,750.00 Budgeted 14,000.00 Remaining 5 % Used Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S 1046 03/30/2020 TexPool Transfers March TexPool O&M to 16Swift Rev I&S 308,406.76 25,047.72 333,454.48 GO. Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 25,047.72 333,454.48 ** 527,381.00 Budgeted 193,926.52 Remaining 63 % Used Account: 135-60333-010-000 Interfund Transfer Out -Reserve 1046 03/30/2020 TexPool Transfers March TexPool O&M to Rev Bond Resevr 23,000.00 4,600.00 27,600.00 GL Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 4,600.00 27,600.00 ** 55,193.00 Budgeted 27,593.00 Remaining 50 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 180,000.00 Budgeted 180,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 561.72 .00 561.72 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 561.72 ** 2,500.00 Budgeted 1,938.28 Remaining 22 % Uaed Account: 135-65005-010-000 Fuel & Lube 979 03/24/2020 Fuel- March 2020 Fuel -Mar 4,514.91 906.24 5,421.15 US Bank Voyager Fleet Systems 6343 AP Account: 135-65005-010-000 Fuel & Lube Totals: 906.24 5,421.15 ** 15,000.00 Budgeted 9,578.65 Remaining 36 5 Used Account: 135-65010-010-000 Uniforms 2,917.33 .00 2,917.33 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 3/2020 JE Detail Description/Comment Uniforms 5,190.00 Budgeted Chemicals 966 03/23/2020 March A/P testing supplies 966 03/23/2020 March A/P testing supplies 1000 03/31/2020 March AP testing supplies 1000 03/31/2020 March AP chlorine 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 Account: 135-65053-010-000 Account: 135-65053-010-000 Account: 135-69005-010-000 Chemical 20,000.00 Budgeted Sural Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,000.00 Budgeted Meter Expense Meter Expense Totals: Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 2,272.67 Remaining 56 % Used 2,917.33 •• 9,016.50 748.77 9,765.27 HACH COMPANY 504.63 10,269.90 HACH COMPANY 475.53 10,745.43 HACH COMPANY 558.41 11,303.84 DPC INDUSTRIES, INC 8,696.16 Remaining 57 % Used Totals: 1,200.00 Remaining 0 % Used .00 .00 .00 .00 Totals: 1,000.00 Remaining 0 % Used 16,869.78 70,000.00 Budgeted 53,130.22 Remaining 24 % Used Meter Change Out Program ge Out Program T•tale: 87,000.00 Budgeted 50,100.00 Remaining 36,900.00 42 Used .00 16,869.78 .00 36,900.00 6301 AP 6301 AP 6339 AP 6338 AP glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 3/2020 JE Detail Description/Comment 986 03/30/2020 March A/P spare parts Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 176,710.03 12,503.46 189,213.49 HACH COMPANY 6339 AP Accoun. 0 Capital approir12,50 684,875.00 Budgeted 495,661.51 Remaining Account: 135-69008-010-000 Account: 135-69008-010-000 Short Term Debt -Principal Short Term Debt -Principal 30,512.00 Budgeted 30,512.00 28 % Used .00 30,512.00 .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt -Interest 1,840.00 .00 1,840.00 Account: 135-69009-010-000 Short Term Debt -Interest 3,231.00 Budgeted 1,391.00 Remaining 57 % 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: 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 102,077.11 .00 102,077.11 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 120,000.00 Budgeted 17,922.89 Remaining 85 % Ueed glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-55135-010-001 4M11- 923 03/12/2020 March A/P 923 03/12/2020 March A/P Account: Department 10 Totals: Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Lab Analysis for PID water samples TCEQ samples Lab Analysis for PID Totals: 2,000.00 Budgeted 1,158.36 Remaining 547.70 80.00 627.70 TARRANT CTY PUBLIC HEALTH LAB 6272 AP 213.94 841.64 LOWER COLORADO RIVER AUTHORITY 6267 AP 42 Used 1,861,634.76 ** 200,477.63 Monthly Total 5,506,929.00 Budgeted 3,645,294.24 Remaining 34 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACOOUnt: 135-5000 020- 8laries & We 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Salaries & Wages 933 03/20/2020 MUD Payroll 3/20/2020 Salaries & Wages Account :-'5nrelSalaries & Wages Totals: 441,799.00 Budgeted Account: 135-50010-020-000 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Overtime 933 03/20/2020 MUD Payroll 3/20/2020 Overtime Account: Account: 135- Account: 135-50016-020-000 150,837.93 15,820.49 166,658.42 PR 16,024.11 182,682.53 PR 259,116.47 Remaining 41 % Used 9,765.30 776.31 10,541.61 PR 800.82 11,342.43 PR 33,000.00 Budgeted 21,657.57 Remaining 34 % Ueed Longevity 6,872.50 .00 6,872.50 Longevity Totals: 8,035.00 Budgeted 1,162.50 Remaining 86 % Used Account: 135-50017-020-000 Certification 933 03/20/2020 MUD Payroll 3/20/2020 Certification 3,200.00 625.00 3,825.00 PR Account: 135-50017-020-000 ertification 625.00 9,000.00 Budgeted Account: 135-50020-020-000 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Retirement 933 03/20/2020 MUD Payroll 3/20/2020 Retirement Account: 135-50020-020-000 Retirement 3 45,531.00 Budgeted 5,175.00 Remaining 43 % Used 17,332.99 1,536.87 18,869.86 PR 1,615.86 20,485.72 PR Totals: 25,045.28 Remaining 45 % Used Account: Medical Insurance 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Medical Insurance 33,790.07 933 03/20/2020 MUD Payroll 3/20/2020 Medical Insurance Accci Medical Insurance 104,858.00 Budgeted Totals: 63,329.69 Remaining 40 % Used 3,869.14 37,659.21 PR 3,869.10 41,528.31 PR glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Accojsuxill 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Dental Insurance 933 03/20/2020 MUD Payroll 3/20/2020 Dental Insurance 1,985.42 223.47 2,208.89 PR 223.43 2,432.32 PR Account: -1.1 Dental Insuranc Totals: mMilly 5,817.00 Budgeted 3,384.68 Remaining 42 % Used Account: 135-50028-020-000 ion Insurance 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Vision Insurance 933 03/20/2020 MUD Payroll 3/20/2020 Vision Insurance Account: 812 03/01/2020 March Payroll Benefits 812 03/01/2020 March Payroll Benefits 966 03/23/2020 March A/P 1063 03/31/2020 March A/P Account: 135-50029-020-000 Vision Insurance Totals: 948.00 Budgeted Life Insurance & Other Employee Benefits Employee LTD & STD Caf 125 Caf 125 Life Insuran• 4,500.00 Budgeted 320.43 34.87 355.30 34.87 390.17 557.83 Remaining 41 % Used 2,285.50 Account: 135-50030-020- ocial Securi 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Social Security Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Social Security Taxes A Remaining 030-0°"91111111111111111Social Security Taxs- Totals: 30,494.00 Budgeted 18,623.61 Remaining Account: 135-50035-020-000 Medicare Taxes 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Medicare Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Medicare Taxes Account Medicare Taxes 7,132.00 Budgeted PR PR - • 1,786.43 198.33 1,984.76 Humana Inc 6223 AP 165.74 2,150.50 METLIFE GROUP BENEFITS 6231 AP 32.00 2,182.50 BenefitMall 6295 AP 32.00 2,214.50 BenefitMall AP 9,915.32 49 Used - 969.45 10,884.77 985.62 11,870.39 39 % Used - 11112,318.90 226.71 2,545.61 230.52 2,776.13 Totals: 4,355.87 Remaining 39 6 Used PR PR PR PR Account: 135-5004 Unemployment Taxes - glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 3/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Unemployment Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Unemployment Taxes 59.12 1.58 934.52 60.70 995.22 PR PR Account: 135-50040-020-000 Unemployment Taxes Totals: IIIIIP 936.10 995.22 ** 1,260.00 Budgeted 264.78 Remaining 79 % Used Account: 135-50045-020-000 Workman's Compensation 71 03/01/2020 Insurance/Wrk Comp 923 03/12/2020 March A/P Expense Mar WC FY 19 Adjustment 5,551.00 1,110.20 175.50 6,661.20 6,836.70 GL TML INTERGOVERNMENTAL RISE 6277 AP Account: 135-50045-020-000 Workman's Compensation Totals: 1,285.70 6,836.70 ** 15,373.00 Budgeted 8,536.30 Remaining 44 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 38.00 .00 38.00 Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 38.00 ** 400.00 Budgeted 362.00 Remaining 10 % Used Account: 135-50070-020-000 Employee Relations .00 .00 Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .00 .00 Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 3,000.00 .00 3,000.00 Account: 135-55070-020-000 Independent Labor Totals: .00 3,000.00 ** 15,000.00 Budgeted 12,000.00 Remaining 20 % Used Account: 135-55080-020-000 Maintenance & Repairs glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 923 03/12/2020 March A/P 966 03/23/2020 March A/P 1001 03/26/2020 PCarde 2/27/2020-3/26/2020 1001 03/26/2020 1001 03/26/2020 1001 03/26/2020 1001 03/26/2020 1001 03/26/2020 1001 03/26/2020 1001 03/26/2020 PCards PCarde PCarde PCards PCards PCards PCarde 2/27/2020-3/26/2020 2/27/2020-3/26/2020 2/27/2020-3/26/2020 2/27/2020-3/26/2020 2/27/2020-3/26/2020 2/27/2020-3/26/2020 2/27/2020-3/26/2020 1058 03/31/2020 March A?P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 3/2020 JE Detail Beginning Balance Description/Comment work/repair on perm pump #5 filter wraps water filters n95 masks, air freshner returned water filters Hose assembly plungers, bleach alcohol, vinyl tube,clamps,etc pump pump MBR 5 float 35,443.88 Program: Transaction Detail 1,400.00 100.80 99.98 144.98 (99.98) 158.79 57.82 82.01 2,143.87 1,357.47 691.00 Transaction Vendor Name Detail (SUBTOTAL) 36,843.88 36,944.68 37,044.66 37,189.64 37,089.66 37,248.45 37,306.27 37,388.28 39,532.15 40,889.62 41,580.62 Environmental Improvements Inc Filter Element Store LOWES #00732* LOWES #00732* LOWES #00732* IN *HOSE TECH USA THE HOME DEPOT #6581 THE HOME DEPOT 6581 MANUFACTURERS EDGE, IN MANUFACTURERS EDGE, IN DHS AUTOMATION, INC Check Source Number 6260 AP 6300 AP PC PC PC PC PC PC PC PC AP Account: 135-55080-020-000 Maintenance & Repairs Totals: 6,136.74 41,580.62 ** ' 88,000.00 Budgeted 46,419.38 Remaining 47 % Used Account: 135-55081-020-000 Mainten & Repairs Collections 1001 03/26/2020 PCards 2/27/2020-3/26/2020 brooms, cleaner, hose 17,677.78 45.88 17,723.66 THE HOME DEPOT #6581 PC Account: 135-55081-020-000 Mainten & Repairs Collections Totals: 45.88 17,723.66 ** 10,000.00 Budgeted (7,723.66) Remaining 177 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 5 Used Account: 135-55090-020-000 Vehicle Maintenance 1001 03/26/2020 1001 03/26/2020 PCarde PCards 2/27/2020-3/26/2020 state inspection 2/27/2020-3/26/2020 state inspection 742.98 25.50 25.50 768.48 793.98 KWIK KAR LUBE KWIK KAR LUBE & TUNE & TUNE 0 0 PC PC Account: 135-55090-020-000 Vehicle Maintenance Totals: 51.00 793.98 ** 4,000.00 Budgeted 3,206.02 Remaining 20 % Used Account: 135-55091-020-000 Veh Maintenance Collections 1001 03/26/2020 PCards 2/27/2020-3/26/2020 blue def peak 1,986.94 24.94 2,011.88 THE HOME DEPOT #6581 PC Account: 135-55091-020-000 Veh Maintenance Collections Totals: 24.94 2,011.88 ** 8,000.00 Budgeted 5,988.12 Remaining 25 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-5510020- aintenance-Backhoe/SkidLoader 1001 03/26/2020 PCards 2/27/2020-3/26/2020 tire repair Ac Maintenance-Backhoe/SkidLoader Total 3,000.00 Budgeted 2,167.78 Remaining Account: 135-55120-020-000 Account: Cleaning Services 966 03/23/2020 March A/P janitorial svc-february Cleaning Services 1,500.00 Budgeted Acc.85-55125-020-000 + Dempster Services 1058 03/31/2020 March A?P Sludge/grit 1058 03/31/2020 March A?P Sludge/grit 1058 03/31/2020 March A?P Sludge/grit Account: 135-55125-020-6111 Account: 135-55135-020-000 923 03/12/2020 March A/P 923 03/12/2020 March A/P 932 03/16/2020 March A/P 932 03/16/2020 March A/P 966 03/23/2020 March A/P 966 03/23/2020 March A/P 986 03/30/2020 March A/P 986 03/30/2020 March A/P 1007 03/31/2020 March A/P 1058 03/31/2020 March A?P 1058 03/31/2020 March A?P ACCOunt: 135 Dumpster Services 100,000.00 Budgeted Lab Analysis lab testing lab trsting lab testing lab trsting lab testing lab trsting lab testing lab trsting Bio -monitoring lab testing lab trsting Lab Analysis 40,000.00 Budgeted 559.67 272.55 28 % Used 832.22 BLAGGS TIRE WHOLESALE PC 350.00 87.50 437.50 MEMBER'S BUILDING MAINTENANCE 6309 AP 1,062.50 Remaining 29 % Used 38,479.62 2,468.22 40,947.84 L.H. CHANEY MATERIALS, INC. AP 1,181.10 42,128.94 L.H. CHANEY MATERIALS, INC. AP 1,154.44 43,283.38 L.H. CHANEY MATERIALS, INC. AP Totals: 56,716.62 Remaining 43 % Used Account: 135-60010-020-000 Communications/Mobiles 923 03/12/2020 March A/P Cell phones -March 15,048.65 341.55 15,390.20 OXIDOR LABORATORIES LLC 6270 AP 241.50 15,631.70 OXIDOR LABORATORIES LLC 6270 AP 341.55 15,973.25 OXIDOR LABORATORIES LLC 6292 AP 241.50 16,214.75 OXIDOR LABORATORIES LLC 6292 AP 341.55 16,556.30 OXIDOR LABORATORIES LLC 6313 AP 241.50 16,797.80 OXIDOR LABORATORIES LLC 6313 AP 341.55 17,139.35 OXIDOR LABORATORIES LLC 6342 AP 241.50 17,380.85 OXIDOR LABORATORIES LLC 6342 AP 1,080.00 18,460.85 HUTHER AND ASSOCIATES,INC 6344 AP 341.55 18,802.40 OXIDOR LABORATORIES LLC AP 241.50 19,043.90 OXIDOR LABORATORIES LLC AP Totals: ' 20,956.10 Remaining 48 % Used 2,679.40 408.87 • 3,088.27 VERIZON WIRELESS 6281 AP glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Communications/Mobiles 5,000.00 Budgeted 1,911.73 Remaining 62 % Ueed 923 03/12/2020 March A/P electricity 2/3-3/3 1028 03/31/2020 Town Billed Invoices 1730-1733 AR 20200331-20200331 User: 1063 03/31/2020 March A/P electricity 3/3-4/1 Account: 135-60066-020-000 Account: 135-60066-020-000 Elate� 160,067.00 Budgeted Total 3,088.27 ** 60,843.27 511.03 61,354.30 TRI COUNTY ELECTRIC 6279 AP (572.62) 60,781.68 AR 508.83 61,290.51 TRI COUNTY ELECTRIC AP 98,776.49 Remaining 38 % Used Publications/Books/Subscripts Publications/Books/Subscripts Totals: 200.00 Budgeted 200.00 Remaining Account: 135-60070-020-000 ftos & Memberships 1001 03/26/2020 PCards 2/27/2020-3/26/2020 WEF Membership Account: 135-60070-020-00 & Memberships 300.00 Budgeted .00 .00 0 % Used 111.00 105.00 84.00 Remaining 72 % Used Account: 135-60080-020-0 r 1001 03/26/2020 PCards 2/27/2020-3/26/2020 O.Valadez license renewal 1001 03/26/2020 PCards 2/27/2020-3/26/2020 F.Isola class Account."1117S687781778chools & Training 4,990.00 Budgeted Safety Program Safety Program Totals: Account: 135-60090-020-000 Account: 135-60090-020-000 216.00 WEF MAIN PC 2,431.85 111.00 2,542.85 TCEQ IND RENEWAL LIC PC 420.00 2,962.85 TEEX ECOMMERCE PC Totals: 2,027.15 Remaining 59 % Ueed 1,000.00 Budgeted 109.14 .00 109.14 890.66 Remaining 11 % Used Account: 135-60100-020-000 .1.11131Fr diem glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Travel & per diem Account: 135-60100-020-8 Travel & per diem 1,545.00 Budgeted Account: 135-60105-020-000 Account: 135-60105-020-000 Rent/Lease Equipment Rent/Lease Equipment 5,000.00 Budgeted Account: 135-60125-020-000 Advertie Account: 135-60125-020-000 Account: 135-60135-020-000 Account: 135-60135-020-000 Account: 135-60245-020-000 Account: 135-60245-020-000 Account: 135-60280-020-000 Account: 135-60280-020-000 2,500.00 Budgeted TCEQ Fees & Permits TCEQ Fees & Permits 15,000.00 Budgeted Miscellaneous Expenses Miscellaneous Expenses 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted Account: 135-60285-020-000 1058 03/31/2020 March An, Mowing -March 360.84 49.88 Totals: 49 1,134.28 Remaining 27 % Used 5,000.00 Remaining 2,500.00 Remaining 10,088.02 Totals: 0 % Used 0 % Used 4,911.98 Remaining 67 % Used 410.72 PR .00 .00 .00 .00 .00 10,088.02 .00 .00 Totals: 450.00 Remaining 0 % Ueed AIL Mir 584.94 .00 584.94 4,415.06 Remaining 12 % Used 590.00 590.00 WATTS ELLISON LLC AP glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Check Source Number Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 590.00 590.00 ** 14,000.00 Budgeted 13,410.00 Remaining 4 5 Used Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 1046 03/30/2020 TexPool Transfers March TexPool O&M to I&S- PID Debt 52,074.05 10,414.81 62,488.86 GL Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 10,414.81 62,488.86 ** 114,563.00 Budgeted 52,074.14 Remaining 55 % Used Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 1046 03/30/2020 TexPool Transfers March TexPool O&M to Rev Bd WWTP I&S 326,820.11 54,421.63 381,241.74 GL Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 54,421.63 381,241.74 ** 673,867.00 Budgeted 292,625.26 Remaining 57 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 1046 03/30/2020 TexPool Transfers March TexPool O&M to Rev Bond Resevr 28,750.00 5,750.00 34,500.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: i 5,750.00 34,500.00 ** 125,187.00 Budgeted 90,687.00 Remaining 28 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 180,000.00 Budgeted 180,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 190.00 .00 190.00 Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 190.00 ** 2,000.00 Budgeted 1,810.00 Remaining 10 % Used Account: 135-65005-020-000 Fuel & Lube 979 03/24/2020 Fuel- March 2020 Fuel -Mar 3,755.00 491.70 4,246.70 US Bank Voyager Fleet Systems 6343 AP glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Check Source Number Account: 135-65005-020-000 Fuel & Lube Totals: 491.70 4,246.70 ** 12,500.00 Budgeted 8,253.30 Remaining 34 5 Used Account: 135-65010-020-000 Uniforms 3,507.93 .00 3,507.93 Account: 135-65010-020-000 Uniforms Totals: .00 3,507.93 ** 5,495.00 Budgeted 1,987.07 Remaining 64 % Used Account: 135-65030-020-000 Chemicals 923 03/12/2020 March A/P Defoamer 1058 03/31/2020 March A?P sodium hypo 12.55 12,724.87 1,624.08 580.00 14,348.95 14,928.95 MARYLAND BIOCHEMICAL CO, Valley Solvent Company, INC INC 6266 AP AP Account: 135-65030-020-000 Chemicals Totals: 2,204.08 14,928.95 ** 20,000.00 Budgeted 5,071.05 Remaining 75 % Used Account: 135-65031-020-000 Chemicals Collections 4,994.00 .00 4,994.00 Account: 135-65031-020-000 Chemicals Collections Totals: .00 4,994.00 ** 17,500.00 Budgeted 12,506.00 Remaining 29 % Used Account: 135-65035-020-000 Small Tools .00 .00 Account: 135-65035-020-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment 1001 03/26/2020 PCards 2/27/2020-3/26/2020 respirator 1,111.63 54.90 1,166.53 THE HOME DEPOT #6581 PC Account: 135-65040-020-000 Safety Equipment Totals: 54.90 1,166.53 ** 1,200.00 Budgeted 33.47 Remaining 97 % Used Account: 135-65045-020-000 Lab Supplies 923 03/12/2020 March A/P lab supplies 10,837.36 342.38 11,179.74 HACH COMPANY 6263 AP glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 932 03/16/2020 March A/P nitrile gloves 932 03/16/2020 March A/P lab supplies 974 03/24/2020 March A/P lab supplies 974 03/24/2020 March A/P Lab supplies 986 03/30/2020 March A/P lab supplies 1005 03/31/2020 March A/P biomonitoring 1006 03/31/2020 March A/P Void to Recode biomonitoring Account: 135-65045-020-00u Lab Supplies 20,000.00 Budgeted Account: 10,837.36 169.20 11,348.94 LOU'S GLOVES INCORPORATED 6288 AP 2,142.46 13,491.40 IDEXX DISTRIBUTION, INC 6286 AP 552.67 14,044.07 HACH COMPANY 6301 AP 1,968.83 16,012.90 IDEXX DISTRIBUTION, INC 6304 AP 257.28 16,270.18 HACH COMPANY 6339 AP 1,080.00 17,350.18 HUTHER AND ASSOCIATES,INC AP (1,080.00) 16,270.18 HUTHER AND ASSOCIATES,INC AP Totals: 1_ 3,729.82 Remaining 81 % Used Capital Outlays 932 03/16/2020 March A/P Inplant water system WWTP 160,027.89 1,389.11 161,417.00 Halff Associates, INC 6285 AP 932 03/16/2020 March A/P Auma Actuator 1,725.00 163,142.00 Municipal Valve & Equipment Co 6290 AP 1058 03/31/2020 March A?P LS upgrades 9,396.00 172,538.00 DHS AUTOMATION, INC AP Account: 135-69005-020-000 Capital Outlays 530,500.00 Budgeted 357,962.00 Remaining 33 % Used Account: 135-69008-020-000 Short Term Debt -Principal 59,604.74 Account: 135-69008-020-000 Short Term Debt -Principal 79,133.00 Budgeted 19,528.26 Remaining 75 % Used .00 59,604.74 Account: 135-69009-020-000 Account: 135-69009-020-000 Short Term Debt -Interest 11,277.00 Budgeted 5,154.97 Remaining 6,122.03 54 % Used 00 6,122.03 Account: 135-69195-020-000 Gasb34/Reserve for Replacement 130,000.00 Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: 1 130,000.00 Budgeted .00 Remaining Department 20 Totals: 100 % Used .00 130,000.00 1,394,137.17 •• 159,346.17 Monthly Total 3,157,421.00 Budgeted 1,763,283.83 Remaining 44 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2020 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-0 Workman's Compensation 71 03/01/2020 lneurance/Wrk Comp Expense Mar 9.95 Ac Workman's Compensation Total 30.00 Budgeted 18.06 Remaining 40 % Used Account: 135-60066-026-000 ■ Publications/Books/Subscripts Account: 135-60066-026-000 . Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 1.99 11.94 GL 1 .00 .00 0 % Ueed Account: 135-60070-026-000 Account: 135-60070-026-000 Dues & Memberships 675.00 Dues & Memberships Total= 750.00 Budgeted 75.00 Remaining .00 90 % Ueed 675.00 Account: 135-60075-026-000 Account: 135-60075-026-000 Meetings Account: 135-60080-026-000 Account: 135-60080-026-000 Account: 135-60100-026-000 Account: 135-60100-026-000 Meeting. 1,300.00 Budgeted 1,123.72 Remaining 176.28 14 Used 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Travel & per diem Travel & per diem Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used .00 .00 176.28 .00 .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** Department 26 Totals: 2,000.00 Budgeted 2,000.00 Remaining 0 % Used 1.99 Monthly Total 13,230.00 Budgeted 863.22 ** 12,366.78 Remaining 7 % Used glpdatb2 skrolczyk 12:48 04/15/20 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: 3/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Account: 135-50005-030-000 Salaries & Wages 843 03/06/2020 933 03/20/2020 MUD MUD Payroll Payroll 2/16/20-2/29/20 Salaries & Wages 3/20/2020 Salaries & Wages 149,265.50 14,122.33 15,101.60 163,387.83 178,489.43 PR PR Account: 135-50005-030-000 Salaries & Wages Totals: 29,223.93 178,489.43 ** 628,298.00 Budgeted 449,808.57 Remaining 28 5 Used Account: 135-50010-030-000 Overtime 933 03/20/2020 MUD Payroll 3/20/2020 Overtime 20.53 11.24 31.77 PR Account: 135-50010-030-000 Overtime Totals: 11.24 31.77 ** 2,000.00 Budgeted 1,968.23 Remaining 2 % Used Account: 135-50016-030-000 Longevity 2,207.50 .00 2,207.50 Account: 135-50016-030-000 Longevity Totals: .00 2,207.50 ** 2,208.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 843 03/06/2020 933 03/20/2020 MUD MUD Payroll Payroll 2/16/20-2/29/20 Retirement 3/20/2020 Retirement 15,524.98 1,307.73 1,399.45 16,832.71 18,232.16 PR PR Account: 135-50020-030-000 Retirement Totals: 2,707.18 18,232.16 ** 58,554.00 Budgeted 40,321.84 Remaining 31 % Used Account: 135-50026-030-000 Medical Insurance 843 03/06/2020 933 03/20/2020 MUD MUD Payroll Payroll 2/16/20-2/29/20 Medical Insurance 3/20/2020 Medical Insurance 29,157.97 3,172.91 3,172.86 32,330.88 35,503.74 PR PR Account: 135-50026-030-000 Medical Insurance Totals: 6,345.77 35,503.74 ** 124,394.00 Budgeted 88,890.26 Remaining 29 % Used Account: 135-50027-030-000 Dental Insurance 843 03/06/2020 933 03/20/2020 MUD MUD Payroll Payroll 2/16/20-2/29/20 Dental Insurance 3/20/2020 Dental Insurance 1,618.70 174.88 174.87 1,793.58 1,968.45 PR PR Account: 135-50027-030-000 Dental Insurance ■ Totals: 349.75 1,968.45 ** 6,464.00 Budgeted 4,495.55 Remaining 30 % Used glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 3/2020 JE Detail Description/Comment Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) ACCO 002: -030 - Inc Account: 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 933 03/20/2020 MUD Payroll 3/20/2020 Vision Insurance Vision Insurance Bion Insuranc> 1,035.00 Budgeted Account: 135-50029-030-000 ffirimTesurance & Other 812 03/01/2020 March Payroll Benefits Employee Benefits 812 03/01/2020 March Payroll Benefits 966 03/23/2020 March A/P 1063 03/31/2020 March A/P Employee LTD & STD Caf 125 Caf 125 249.67 25.85 275.52 PR 25.83 301.35 PR Totals: i 733.65 Remaining 29 % Used 1,635.45 176.22 1,811.67 Humana Inc 6223 AP 151.69 1,963.36 METLIFE GROUP BENEFITS 6231 AP 16.00 1,979.36 BenefitMall 6295 AP 16.00 1,995.36 BenefitMall AP AC Life Insurance & Other 4,500.00 Budgeted 2,504.64 Remaining 44 % Used Social Security Ta� 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Social Security Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Social Security Taxes Account: 135 Social Security Taxes 39,215.00 Budgeted Accoun Medicare Taxes 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 933 03/20/2020 MUD Payroll 3/20/2020 Medicare Taxes Medicare Taxes 8,790.85 805.46 9,596.31 PR 863.71 10,460.02 PR 28,754.98 Remaining 27 % Used 2,055.95 188.39 2,244.34 PR 201.98 2,446.32 PR Acwu,ac: i.ao-3 35-03 - Medicare Taxes Totals: 9,171.00 Budgeted Account: 135-50040-030-000 Unemployment Taxes 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Unemployment Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Unemployment Taxes 6,724.68 Remaining 27 % Used 46.66 3.28 49.94 PR 793.89 843.83 PR Account Unemployment Taxes Totals: 1,440.00 Budgeted 596.17 Remaining 59 % Used Account: 135-50045-030-000 Workman's Compensation glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 71 03/01/2020 Insurance/Wrk Comp Expense Mar Account: 135-50045-030-000 Account: 135-50060-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 3/2020 JE Detail Beginning Balance Description/Comment 111an'e Compensation Wotale: i 1,775.00 Budgeted 1,146.08 Remaining Account: 135-50060-030-000 Account: 135-50070-030-000 Account: 135-50070-030-000 Pre-emp Physicals/Testing Pre-emp Physicals/Testing 500.00 Budgeted 500.00 Remaining Employee Relate= Employee Relations 8,000.00 Budgeted 4,921.90 Remaining 524.10 3,078.10 Program: Transaction Detail 104.82 35 % Used 0 % Used 38 % Used 10 .00 .00 Transaction Vendor Name Detail (SUBTOTAL) 628.92 .00 3,078.10 Check Source Number 30. Account: 135 Software & Support Check scanner maintenance internet-March Microsoft exchange Camera van support plan Internet internet Internet Adobe program Server support Annual license renewal 923 03/12/2020 March A/P 932 03/16/2020 March A/P 934 03/16/2020 March A/P 966 03/23/2020 March A/P 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1058 03/31/2020 March A?P 1058 03/31/2020 March A?P 126,842.65 Account Software & Support Totals: 134,681.00 Budgeted 3,004.42 Remaining Account: 932 03/16/2020 March A/P 932 03/16/2020 March A/P 1058 03/31/2020 March A?P Independent Labor GM contract -February GM contract -February GM -March hours Totals: 135,000.00 Budgeted 77,799.98 Remaining 54,584.49 98 % Ueed 42 % Ueed 425.00 127,267.65 899.00 128,166.65 494.00 128,660.65 1,250.00 129,910.65 42.37 129,953.02 42.37 129,995.39 53.91 130,049.30 36.78 130,086.08 130.50 130,216.58 1,460.00 131,676.58 1,700.00 15.53 900.00 TECHNIQUE DATA SYSTEMS INC Charter Communications M3 Networks Cues Inc ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*SILL PAYMENT ADOBE ACROPRO SUBS SW INC Data Management Inc. 56,284.49 Carman Consulting LLC. 56,300.02 Carman Consulting LLC. 57,200.02 Carman Consulting LLC. 6275 AP 6283 AP 6289 AP 6299 AP PC PC PC PC AP AP 6282 AP 6282 AP AP glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-030-000 Account: 135-55080-030-000 Maintenance & Repairs III Maintenance & Repairs Totals: 15,000.00 Budgeted 1,165.00 13,835.00 Remaining 8 % Used Account: 135-55085-030-00: Generator Maint. and Repair Accoun Generator Maint. and Repair Totals: 10,000.00 Budgeted 9,469.00 Remaining Account: 135-55120-030-000 - Cleaning Service 966 03/23/2020 March A/P janitorial svc-february Account: 135-55120-030-00- Cleaning Services 10,000.00 Budgeted Account: 135-55160-030-000 974 03/24/2020 March A/P Account: 135-55160-030-000 Account: 135-55205-03' 923 03/12/2020 March A/P 1058 03/31/2020 March A?P Account: 135-55205-030-0191 531.00 3,476.24 .00 1,165.00 .00 531.00 4,345.30 5 % Used 869.06 MEMBER'S BUILDING MAINTENANCE 6309 AP 869.06 5,654.70 Remaining 43 % Used Professional Outside Services FY 20 Winter avg rate revision Professional Outside Sery 65,600.00 Budgeted 63,100.00 Remaining 4 % Used ater billings -February 2,500.00 2,500.00 NEW GEN STRATEGIES & SOLUTIONS 6311 AP 2,500.00 2,474.81 588.05 Water billings -March 579.18 Utility Billing Contract ' Totals: 9,000.00 Budgeted 5,357.96 Remaining Account: 135-60005-030-000 966 03/23/2020 March A/P Answering service -March 1001 03/26/2020 PCards 2/27/2020-3/26/2020 phone 1001 03/26/2020 PCards 2/27/2020-3/26/2020 phone 1001 03/26/2020 PCards 2/27/2020-3/26/2020 phone 1001 03/26/2020 PCards 2/27/2020-3/26/2020 Answering service 1028 03/31/2020 Town Billed Invoices 1730-1733 AR 20200331-20200331 User: 40 5 Used 3,062.86 DATAPROSE LLC 6256 AP 3,642.04 DATAPROSE LLC AP 7,399.55 194.75 7,594.30 KEYSTONE PARK SECRETARIAL 6306 AP 805.99 8,400.29 ATT*BUS PHONE PMT PC 468.11 8,868.40 ATT*BUS PHONE PMT PC 176.78 9,045.18 ATT*SILL PAYMENT PC 14.99 9,060.17 RINGCENTRAL, INC PC (180.00) 8,880.17 AR glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund Account JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 3/2020 JE Detail Description/Comment Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Telephone 23,680.00 Budgeted 14,799.83 Remaining Communications/Mobiles 923 03/12/2020 March A/P Cell phones -March 933 03/20/2020 MUD Payroll 3/20/2020 Communications/Mobiles Account: 135-600 Communications/Mobiles 4,000.00 Budgeted ACCou 11 Electricity/ 923 03/12/2020 March A/P Gexa energy 1/10-2/10 2,572.69 Remaining Electricity 6,879.00 Budgeted 4,125.19 Remaining Account: 135-60025-030-00 Wat 1028 03/31/2020 Town Billed Invoices 1730-1733 AR 20200331-20200331 User: Account: 135-60025-030-00 1,500.00 Budgeted 1,242.18 Account: 135-60035-030-000 923 03/12/2020 March A/P water billings -February 1001 03/26/2020 PCarde 2/27/2020-3/26/2020 FedEx 1058 03/31/2020 March A?P Water billings -March Aocoun Account: 1 1045 03/31/2020 Pace Credit Card Fees 1045 03/31/2020 Pace Credit Card Fees 1045 03/31/2020 Pace Credit Card Fees 1045 03/31/2020 Pace Credit Card Fees 1058 03/31/2020 March A?P 1058 03/31/2020 March A?P Postage 30,000.00 Budgeted Service Charges & Fees Remaining 38 % Ueed 1,189.56 87.75 1,277.31 VERIZON WIRELESS 150.00 1,427.31 2,000.54 383.89 6,806.80 36 % Used 753.27 40 % Used 17 % Used Totals: 19,846.43 Remaining 34 % Ueed Dig Tess -march Direct send fees -March (126.07) 1,675.51 10.94 1,660.32 2,753.81 TOWN OF TROPHY CLUB 257.82 8,482.31 DATAPROSE LLC 8,493.25 FEDEX 91716198 10,153.57 DATAPROSE LLC 6281 AP 6278 PR AP 6256 AP PC AP 31,422.04 1,930.13 33,352.17 GL 33.52 33,385.69 GL 2,982.87 36,368.56 GL 65.22 36,433.78 GL 239.40 36,673.18 Texas Excavation Safety System AP 50.00 36,723.18 Fisery Solutions, LLC AP glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACC Account Account Service Charges & Fees Totals: 67,000.00 Budgeted 30,276.82 Remaining 55 5 Used Bad Debt Expense Bad Debt Expense 1,500.00 Budgeted Insurance 71 03/01/2020 Insurance/Wrk Comp Expense Mar Account: 135 - In Account: 135-60066-030-000 Account: 135-60066-030-000 Account: 135-60070-030-000 Account: 135-60070-030-000 84,000.00 Budgeted Totals: J111111- 1,500.00 Remaining 0 % Used 45,571.52 Publications/Books/Subscripts Remaining Publications/Books/Subscripts 1,000.00 Budgeted 875.00 Remaining Dues & Memberships Dues & Memberships 6,000.00 Budgeted Acci075-039 Meetings 1001 03/26/2020 PCards 2/27/2020-3/26/2020 donuts Account: 135 400.00 Budgeted Public Education - 1001 03/26/2020 PCards 2/27/2020-3/26/2020 voting staff lunch 31,430.09 125.00 4,285.55 46 Used 13 % Used 5,301 .00 .00 6,998.39 38,428.48 .00 125.00 .00 4,285.55 115.09 SQ *CK NDD INC PC 1,714.45 Remaining 71 % Used 61.37 53.72 284.91 Remaining 29 % Used GL 3,809.69 161.82 3,971.51 PANERA BREAD #601996 PC glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2020 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-0011111111111 Public Education Tot- 6,000.00 Budgeted 2,028.49 Remaining ACC ools & Training 66 % Ueed 1001 03/26/2020 PCards 2/27/2020-3/26/2020 SHRM membership 1,163.21 219.00 1,382.21 SOCIETYFORHUMANRESOURC Account: 135-60080-030-00 Schools & Training Totals: 6,850.00 Budgeted 5,467.79 Remaining 20 5 Used Account Travel & per diem 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Travel & per diem 695.14 19.02 714.16 Account: 135- - - ravel & per diem Totals: 3,545.00 Budgeted 2,830.84 Remaining 20 % Ueed .00 .00 Account: 135-60110-030-000 INF- A000unt: 135-60110-030-000 Account: 135-60115-030-000 Account: 135-60115-030-000 Account: 135-60125-030-000 1058 03/31/2020 March A?P Account: 135 Physicals/Testing Physicals/Testing 200.00 Budgeted Election .00 Budgeted Advertising RFP Auditor 2,500.00 Budgeted 200.00 Remaining 0 % Used 138.04 .00 138.04 (138.04) Remaining 0 5 Used Account: 135-60235-030-000 932 03/16/2020 March A/P monitoring svc-march 727.80 Remaining 71 138.04 *• PC PR 1,772.20 1,772.20 Star -Telegram Media AP Used 20 120.00 24.00 144.00 Digital Air Control, Inc 6284 AP glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Check Source Number 966 03/23/2020 March A/P office supplies 74.11 2,132.26 OFFICE DEPOT, INC 6312 AP Account: 135-60235-030-000 Security Totals: 24.00 144.00 ** 1,288.00 Budgeted 1,144.00 Remaining 11 5 Used Account: 135-60245-030-000 Miscellaneous Expenses .00 .00 Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 5 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 5 Used Account: 135-65010-030-000 Uniform .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,235.24 .00 3,235.24 Account: 135-65055-030-000 Hardware Totals: .00 3,235.24 ** 26,485.00 Budgeted 23,249.76 Remaining 12 % Used Account: 135-65085-030-000 Office Supplies 932 03/16/2020 March A/P office supplies 2,002.24 55.91 2,058.15 OFFICE DEPOT, INC 6291 AP 966 03/23/2020 March A/P office supplies 74.11 2,132.26 OFFICE DEPOT, INC 6312 AP glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1001 03/26/2020 PCards 2/27/2020-3/26/2020 986 03/30/2020 March A/P 986 03/30/2020 March A/P reciept book 2,002.24 6.66 2,138.92 AMAZON.COM*IF3HB6OC3 PC office supplies 26.34 2,165.26 OFFICE DEPOT, INC 6341 AP office supplies 34.99 2,200.25 OFFICE DEPOT, INC 6341 AP Account: 135-65085-030-000 Office Supplies Totals: 198.01 2,200.25 ** 6,000.00 Budgeted 3,799.75 Remaining 37 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 1001 03/26/2020 PCards 2/27/2020-3/26/2020 trash bags 2,698.80 26.99 2,725.79 AMZN MKTP US*AW2T28EC3 PC 1001 03/26/2020 PCards 2/27/2020-3/26/2020 thermometer 42.95 2,768.74 WM SUPERCENTER #5247 PC 1001 03/26/2020 PCards 2/27/2020-3/26/2020 coffee 28.72 2,797.46 AMAZON.COM*BK3736783 PC 1001 03/26/2020 PCards 2/27/2020-3/26/2020 candy, soap 12.17 2,809.63 WAL-MART #5247 PC Account: 135-65095-030-000 Maintenance Supplies Totals: 110.83 2,809.63 ** 4,000.00 Budgeted 1,190.37 Remaining 70 % 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 932 03/16/2020 March A/P TC MUD Boundary update 47.39 2,867.91 2,915.30 Halff Associates, INC 6285 AP Account: 135-69005-030-000 Capital Outlays Totals: 2,867.91 2,915.30 ** 195,000.00 Budgeted 192,084.70 Remaining 1 % Used Account: 135-69170-030-000 Copier Lease Installments 923 03/12/2020 March A/P copier lease -march 1,271.47 165.00 1,436.47 TIAA COMMERCIAL FINANCE 6276 AP 974 03/24/2020 March A/P copies 109.86 1,546.33 KYOCERA DOCUMENT SOLUTIONS 6307 AP glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Check Source Number Account: 135-69170-030-000 Copier Lease Installments Totals: 274.86 1,546.33 ** 4,000.00 Budgeted 2,453.67 Remaining 39 5 Used Department 30 Totals: 77,689.98 Monthly Total 581,225.74 ** 1,776,712.00 Budgeted 1,195,486.26 Remaining 33 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 923 03/12/2020 March A/P 923 03/12/2020 March A/P 932 03/16/2020 March A/P 1058 03/31/2020 March A?P legal legal travel Westlake easment legal 56,702.39 5,590.00 1,050.00 13,935.00 5,687.50 62,292.39 McLean & Howard, L.L.P. 63,342.39 McLean & Howard, L.L.P. 77,277.39 WHITAKER CHALK SWINDLE 82,964.89 McLean & Howard, L.L.P. 6269 AP 6269 AP 6293 AP AP Account: 135-55045-039-000 Legal Totals: 26,262.50 82,964.89 ** 135,000.00 Budgeted 52,035.11 Remaining 61 % Used Account: 135-55055-039-000 Auditing 27,713.27 .00 27,713.27 Account: 135-55055-039-000 Auditing Totals: .00 27,713.27 ** 33,800.00 Budgeted 6,086.73 Remaining 82 % Used Account: 135-55060-039-000 Appraisal 891 03/05/2020 March A/P 2nd qtr 2020 appraisel/DCAD 5,178.56 2,243.48 7,422.04 DENTON CENTRAL APPRAISAL DISTR 6257 AP Account: 135-55060-039-000 Appraisal Totals: 2,243.48 7,422.04 ** 11,761.00 Budgeted 4,338.96 Remaining 63 % Used Account: 135-55065-039-000 Tax Admin Fees 3,756.00 .00 3,756.00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 3,756.00 ** Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 28,505.98 Monthly Total 244.00 Remaining 94 % Used 121,856.20 ** 184,561.00 Budgeted 62,704.80 Remaining 66 % Used 55,896.27 (97,751.98) Monthly Total (6,224.00) Budgeted (62,120.27) Remaining ########## glpdatb2 skrolczyk 12:48 04/15/20 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: 3/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted (286,420.00) ** 286,420.00 Remaining 0 5 Used (286,420.00) 286,420.00 Remaining 0 % Used Account: 137-49145-000-000"IIII Intergov Transfer -General Fund (205,000.00) .00 (205,000.00) Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: .00 (205,000.00) ** .00 Budgeted 205,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer -Fire Dept (81,420.00) .00 (81,420.00) Account: 137-49146-000-000 Intergov Transfer -Fire Dept Totals: ; .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 5 Used Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted (286,420.00) ** 286,420.00 Remaining 0 5 Used (286,420.00) 286,420.00 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE u TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 524,254 TOTAL ASSETS 524,254 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,477 TOTAL LIABILITIES 685,477 FUND BALANCE ASSIGNED FUND BALANCE (118,410) NET REVENUES / EXPENDITURES (42,813) TOTAL FUND BALANCE (161,223) TOTAL LIABILITIES AND FUND BALANCE 524,254 glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49011-000-000 Interest Income 460.49- 4,498.62- 4,498.62 Subtotal: 460.49- 4,498.62- 4,498.62 Program number: 460.49- 4,498.62- 4,498.62 Department number: Revenues 460.49- 4,498.62- 4,498.62 Revenues Subtotal 460.49- 4,498.62- 4,498.62 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account 1 517-69005-020-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 3/2020 Adopted Amended Total Current Budget Budget Encumb. Month 12,140.00 Program: YTD Total 47,311.41 % of Remaining Budget Budget 47,311.41 - Subtotal: 12,140.00 47,311.41 47,311.41 - Program number: 1.I. 12,140.00 47,311.41 47,311.41 - Department number: Wastewater ` 12,140.00 47,311.41 47,311.41 - Expenditures Subtotal 12,140.00 47,311.41 47,311.41 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 11,679.51 42,812.79 42,812.79- glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49011-000-000 1047 03/31/2020 Bank Interest- March Interest Income (4,038.13) (460.49) (4,498.62) GL Account: 517-49011-000-000 Interest Income Total (460.49) (4,498.62) ** .00 Budgeted 4,498.62 Remaining 0 % Used Department Totals: (4,498.62) ** (460.49) Monthly Total .00 Budgeted 4,498.62 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 3/2020 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 Mr - 923 03/12/2020 March A/P 974 03/24/2020 March A/P Capital Outlays J WWTP legal WWTP legal 35,171.41 1,190.00 10,950.00 Account: - Capital Outlays Totals: .00 Budgeted(47,311.41) Remaining 0 % Used 36,361.41 Dubois Bryant Campbell LLP 6259 AP 47,311.41 CP&Y/WALLACE GROUP, INC. 6298 AP Department 20 Totals: 47,311.41 ** 12,140.00 Monthly Total .00 Budgeted (47,311.41) Remaining 0 % Used Fund 517 Totals: 42,812.79 11,679.51 Monthly Total .00 Budgeted (42,812.79) Remaining 0 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,703 TOTAL ASSETS 784,703 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 81,691 81,691 698,648 4,364 703,012 784,703 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 519 2016 Rev Bond Const -SWIFT Account 1 519-49011-000-000 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 3/2020 Adopted Amended Total Current Budget Budget Encumb. Month 612.47 - Program: YTD Total 4,364.30- % of Remaining Budget Budget 4,364.30 Subtotal: 612.47- 4,364.30- 4,364.30 Program number: 612.47- 4,364.30- 4,364.30 Department number: Revenues 612.47- 4,364.30- 4,364.30 Revenues Subtotal ._ 612.47- 4,364.30- 4,364.30 Fund number: 519 2016 Rev Bond Const -SWIFT 612.47- 4,364.30- 4,364.30 glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-49011-000-000 1047 03/31/2020 Bank Interest- March Interest Income (3,751.83) (612.47) (4,364.30) GL Account: 519-49011-000-000 Interest Income Totals: Department Totals: Fund 519 Totals: .00 Budgeted 4,364.30 Remaining 0 % Used (612.47) Monthly Total .00 Budgeted (612.47) Monthly Total .00 Budgeted (4,364.30) ** 4,364.30 Remaining 0 % Used (4,364.30) 4,364.30 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET MARCH 2020 TROPHY CLUB 1 MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 448,915 INVESTMENTS 3,891,217 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,340,132 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 4,454,290 (114,158) 4,340,132 4,340,132 glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Interest Income 3,504.93- 26,133.94- 26,133.94 Subtotal: 3,504.93- 26,133.94- 26,133.94 Program number: 3,504.93- 26,133.94- 26,133.94 Department number: 3,504.93- 26,133.94- 26,133.94 Revenues Subtotal ` 3,504.93- 26,133.94- 26,133.94 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 520 Revenue Bond 16" Waterline Account 1 520-69005-010-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Period Ending: 3/2020 Adopted Amended Total Current Budget Budget Encumb. Month 14,853.95 Program: YTD Total 140,292.71 % of Remaining Budget Budget 140,292.71 - Subtotal: 14,853.95 140,292.71 140,292.71 - Program number: 1.I. 14,853.95 140,292.71 140,292.71 - Department number: Water Department ` 14,853.95 140,292.71 140,292.71 - Expenditures Subtotal 14,853.95 140,292.71 140,292.71 - Fund number: 520 Revenue Bond 16" Waterline 11,349.02 114,158.77 114,158.77- glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-49011-000-0 1047 03/31/2020 Bank Interest- March 1047 03/31/2020 Bank Interest- March Account: 520-490 Interest Income Interest Income Totals: .00 Budgeted (22,629.01) (467.79) (23,096.80) GL (3,037.14) (26,133.94) GL 26,133.94 Remaining 0 % Used Department Totals: (26,133.94) ** (3,504.93) Monthly Total .00 Budgeted 26,133.94 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 3/2020 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 Mr - 923 03/12/2020 March A/P 932 03/16/2020 March A/P 932 03/16/2020 March A/P Capital Outla Easement fee -title 125,438.76 940.00 16" water line easement 624.09 easement legal 13,289.86 Capital Outla .00 Budgeted (140,292.71) Remaining 126,378.76 Community National Title LLC 127,002.85 Halff Associates, INC 140,292.71 Jackson Walker LLP 6253 AP 6285 AP 6287 AP 0 % Used Department 10 Totals: 140,292.71 •• 14,853.95 Monthly Total .00 Budgeted (140,292.71) Remaining 0 % Used Fund 520 Totals: 114,158.77 11,349.02 Monthly Total .00 Budgeted (114,158.77) Remaining 0 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Rip TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 872,080 TOTAL ASSETS 872,080 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 803,457 68,623 872,080 872,080 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 528 2015 Revenue Bond Reserve Fund Account Description 528-49011-000-000 528-49142-000-000 528-49143-000-000 Interest Income Interfund transfer in -Water Interfund transfer in -WW Program number: Department number: Revenues Trophy Club MUD No.1 Budget Summary with Amendment Department: Program: Period Ending: 3/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund 11,000.00- 307,049.00- 200,417.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 11,000.00- 307,049.00- 200,417.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 734.06- 4,600.00- 5,750.00- 11,084.06- 11,084.06- 11,084.06- 11,084.06- 6,523.06- 27,600.00- 34,500.00- 68,623.06- 68,623.06- 68,623.06- 68,623.06- 59.301 4,476.94- 8.989 279,449.00- 17.214 165,917.00- 449,842.94- 236 449,842.94- 13.236 449,842.94- 13.236 449,842.94- 13.236 449,842.94- glpdatb2 skrolczyk 12:48 04/15/20 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Account: 528-49011-000-000 1047 03/31/2020 Bank Interest- March Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Account: 528-49011-000-000 come 1 i (11,000.00) Budgeted (4,476.94) Remaining Account: 528-49142-000-000 1046 03/30/2020 TexPool Transfers March TexPool O&M to Rev Bond Resevr (5,789.00) (734.06) (6,523.06) 59 % Used (23,000.00) Interfund transfer in -Wats (307,049.00) Budgeted (279,449.00) Remaining Interfund transfer in -WW 1046 03/30/2020 TexPool Transfers March TexPool O&M to Rev Bond Resevr Account: 528-49143-11Interfund transfer i (200,417.00) Budgeted (28,750.00) (165,917.00) Remaining (4,600.00) 9 % Used (5,750.00) 17 % Used (27,600.00) (34,500.00) Department Totals: (68,623.06) ** (11,084.06) Monthly Total (518,466.00) Budgeted (449,842.94) Remaining 13 % Used Fund 528 Totals: (68,623.06) (11,084.06) Monthly Total (518,466.00) Budgeted (449,842.94) Remaining 13 % Used GL GL GL TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER TOTAL ASSETS LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE IPA TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 923,693 24,375 948,068 24,375 24,375 82,954 840,739 923,693 948,068 glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 533-40002-000-000 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 6,491.91- 251.43- 398.76- 679,203.89- 1,831.16- 1,403.58- 99.526 183.116 70.179 3,237.11- 831.16 596.42 - Subtotal: 7,142.10- 99.562 3,002.37- 533-49011-000-000 533-49015-000-000 533-49141-000-000 Interest Income Lease/Rental Income Interfund Trans In -PID Surchg 5,000.00- 218,004.00- 114,563.00- 5,000.00- 218,004.00- 114,563.00- 773.47- 10,414.81- 3,185.87- 218,004.00- 62,488.86- 63.717 100.000 54.545 1,814.13- 52,074.14- 1 Subtotal: 337,567.00- 337,567.00- 11,188.28- 283,678.73- 84.036 53,888.27 - Program number: 1,023,008.00- 1,023,008.00- 18,330.38- 966,117.36- 94.439 56,890.64 - Department number: Revenues 1,023,008.00- 1,023,008.00- 18,330.38- 966,117.36- 94.439 56,890.64 - Revenues Subtotal 1,023,008.00- 1,023,008.00- 18,330.38- 966,117.36- 94.439 56,890.64- glbase_tbam skrolczyk 12:47 04/15/20 Fund: 533 MUD 1 I&S Consolidated Account Description 1 1 533-70005-051-000 1 533-70025-051-000 1 533-70035-051-000 Payin$g Agent Fee Bond 2nterest Expense -Tax Bond Principal Payment -Tax Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Program: Period Ending: 3/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,150.00 247,858.00 765,000.00 2,150.00 247,858.00 765,000.00 1,450.00 123,928.75 67.442 50.000 700.00 123,929.25 765,000.00 Subtotal: 1,015,008.00 1,015,008.00 125,378.75 12.352 889,11r.25 Program number: 1,015,008.00 1,015,008.00 125,378.75 12.352 889,629.25 Department number: Administration 1,015,008.00 1,015,008.00 125,378.75 12.352 889,629.25 Expenditures Subtotal 1,015,008.00 1,015,008.00 125,378.75 12.352 889,629.25 p Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 18,330.38- 840,738.61- 8#88#9#8#89#9#8 832,738.61 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Account: 533-40000-000- 1024 03/02/2020 Property Taxes 1025 03/03/2020 Property Taxes 1026 03/04/2020 Property Taxes 1027 03/05/2020 Property Taxes 1029 03/06/2020 Property Taxes 1031 03/10/2020 Property Taxes 1032 03/11/2020 Property Taxes 1033 03/12/2020 Property Taxes 1034 03/13/2020 Property Taxes 1035 03/16/2020 Property Taxes 1036 03/17/2020 Property Taxes 1037 03/18/2020 Property Taxes 1038 03/19/2020 Property Taxes 1039 03/20/2020 Property Taxes 1040 03/23/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes Account: 533-4000 d=r8,11 Account: 533-40002-000-00 1025 03/03/2020 Property Taxes 1030 03/09/2020 Property Taxes 1033 03/12/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes Account: 533-40002-000-0 Account: 533-40015-000-00' 1024 03/02/2020 Property Taxes 1025 03/03/2020 Property Taxes 1026 03/04/2020 Property Taxes 1027 03/05/2020 Property Taxes 1029 03/06/2020 Property Taxes 1030 03/09/2020 Property Taxes 1032 03/11/2020 Property Taxes 1033 03/12/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 3/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes Property Taxes Totals: (682,441.00) Budgeted Property Taxes/Delinquent (672,711.98) (523.48) (673,235.46) (87.27) (673,322.73) (644.07) (673,966.80) (92.80) (674,059.60) (976.98) (675,036.58) (24.80) (675,061.38) (254.34) (675,315.72) (19.76) (675,335.48) (347.95) (675,683.43) (283.07) (675,966.50) (558.33) (676,524.83) (301.08) (676,825.91) (339.92) (677,165.83) (138.40) (677,304.23) (334.99) (677,639.22) (274.16) (677,913.38) (1,290.51) (679,203.89) (3,237.11) Remaining 100 % Used (1,579.73) (100.25) (1,679.98) (8.84) (1,688.82) (128.43) (1,817.25) (.01) (1,817.26) (13.90) (1,831.16) Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL T GL GL GL GL GL Property Taxes/Delinquent Totals: (1,000.00) Budgeted Property Taxes/P & I 831.16 Remaining 183 % Used (1,004.82) (33.50) (1,038.32) (31.17) (1,069.49) (46.19) (1,115.68) (6.50) (1,122.18) (68.39) (1,190.57) (2.30) (1,192.87) (22.89) (1,215.76) (35.17) (1,250.93) GL GL GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2020 JE JE JB JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1034 03/13/2020 Property Taxes 1035 03/16/2020 Property Taxes 1036 03/17/2020 Property Taxes 1040 03/23/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes (1,004.82) (31.31) (18.04) (28.10) (19.53) (16.51) (39.16) (1,282.24) (1,300.28) (1,328.38) (1,347.91) (1,364.42) (1,403.58) GL GL GL GL GL GL Account: 533-40015-000-000 Property Taxes/P & I ■ Totals: (398.76) (1,403.58) ** (2,000.00) Budgeted (596.42) Remaining 70 % Used Account: 533-49011-000-000 Interest Income 1047 03/31/2020 Bank Interest- March (2,412.40) (773.47) (3,185.87) GL Account: 533-49011-000-000 Interest Income Totals: (773.47) (3,185.87) ** (5,000.00) Budgeted (1,814.13) Remaining 64 % Used Account: 533-49015-000-000 Lease/Rental Income (218,004.00) .00 (218,004.00) Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (218,004.00) ** (218,004.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 1046 03/30/2020 TexPool Transfers March TexPool O&M to I - PID Debt (52,074.05) (10,414.81) (62,488.86) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,414.81) (62,488.86) ** Department Totals: (114,563.00) Budgeted (18,330.38) Monthly Total (52,074.14) Remaining 55 % Used (966,117.36) ** (1,023,008.00) Budgeted (56,890.64) Remaining 94 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2020 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 1,450.00 .00 1,450.00 Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,450.00 ** 2,150.00 Budgeted 700.00 Remaining 67 % Used Account: 533-70025-051-000 Bond Interest Expense -Tax 123,928.75 .00 123,928.75 Account: 533-70025-051-000 Bond Interest Expense -Tax Totals: .00 123,928.75 ** 247,858.00 Budgeted 123,929.25 Remaining 50 % Used .00 .00 Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 .00 ** Department 51 Totals: Fund 533 Totals: 765,000.00 Budgeted 765,000.00 Remaining 0 % Used 125,378.75 ** .00 Monthly Total 1,015,008.00 Budgeted 889,629.25 Remaining 12 5 Used (840,738.61) (18,330.38) Monthly Total (8,000.00) Budgeted 832,738.61 Remaining ########## TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE NAll TROPHY CLUB i MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 247,837 TOTAL ASSETS 247,837 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 24,518 223,320 247,837 247,837 glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49011-000-000 Interest Income 2,500.00- 2,500.00- 534-49143-000-000 Interfund Transfer In -WW Sales 598,638.00- 598,638.00 - Sub totl 60190- 601 438.00 - Program number: 6011111100 - Department number: Revenues 6011'38.00 - Revenues Subtotal 601,138.00- 601,138.00- 601,138.00- 601,138.00- 166.33- 54,421.63- 587.96- 54,587.96- , 54,587.96- 1,109.24- 326,529.18- 327,638.42- 327,638.42- 327,638.42- 44.370 54.545 54.503 54.503 54.503 54.503 1,390.76- 272,108.82- 273,499.58- 273,499.58- 273,499.58- glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 3/2020 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 200.00 50.000 200.00 1 534-70040-051-000 Revenue Bond Interest Expense 208,238.00 208,238.00 104,118.75 50.000 104,119.25 1 534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 390,000.00 1 Subtotal: , 598,638.00 598,638.00 17.426 494,319.25 Program number: III 598,638.00 598,638.00 111111111 17.426 494,319.25 Department number: Administration III 598,638.00 598,638.00 10 17.426 494,31 Expenditures Subtotal ill 598,638.00 598,638.00 1011111:75 17.426 494,319.25 Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 54,587.96- 2200.67- gilip32.787 220,819.67 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 534 2015 Revenue Bond I&S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 3/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department Totals: (54,587.96) Monthly Total (327,638.42) ** (601,138.00) Budgeted (273,499.58) Remaining 55 % Used Account: 534-49011-000-000 Interest Income 1047 03/31/2020 Bank Interest- March (942.91) (166.33) (1,109.24) GL Account: 534-49011-000-000 Interest Income Totals: (166.33) (1,109.24) ** (2,500.00) Budgeted (1,390.76) Remaining 44 4 Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 1046 03/30/2020 TexPool Transfers March TexPool O&M to Rev Bd WWTP I&S (272,107.55) (54,421.63) (326,529.18) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,421.63) (326,529.18) ** (598,638.00) Budgeted (272,108.82) Remaining 55 4 Used Department Totals: (54,587.96) Monthly Total (327,638.42) ** (601,138.00) Budgeted (273,499.58) Remaining 55 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond IES Department: 51 Administration Program: Period Ending: 3/2020 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 11 Rev Bond Paying Agent Fee 400.00 Budgeted 200.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 208,238.00 Budgeted 104,119.25 Remaining 200.00 104,118.75 Account: 534-70045-051-000 Revenue Bond Principal Expense A,t: 534-70045-051-000 Revenue Bond Principal Expense Totals: 390,000.00 Budgeted 390,000.00 Remaining 50 % Used .00 200.00 .00 104,118.75 50 % Used .00 .00 0 % Used Department 51 Totals: 104,318.75 ** .00 Monthly Total 598,638.00 Budgeted 494,319.25 Remaining 17 % Used Fund 534 Totals: (223,319.67) (54,587.96) Monthly Total (2,500.00) Budgeted 220,819.67 Remaining ########## TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 535 NSII FTW SWIFT REVENUE BOND I&S 125,471 TOTAL ASSETS 125,471 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 4,967 120,504 125,471 125,471 glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49011-000-000 535-49142-000-000 Subtot Program number: Department number: Revenues Interest Income 1,000.00- 1,000.00- Interfund Tran In -Water Sales 275,525.00- 275,525.00- Revenues Subtotal 25.00- 0- 276t25.00- 0- 276,525.00- 276,525.00- 276,525.00- 86.27- 25,047.72- 480.54- 150,286.32- 48.054 519.46- I 54.545 125,238.68- I 54.522 54.522 54.522 54.522 12 125 125,75 125,758.14- glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 800.00 800.00 200.00 25.000 600.00 535-70040-051-000 Revenue Bona Interest Expense 386,811.00 386,811.00 30,062.50 7.772 356,748.50 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 Subtotal: ,111111102,611.00 602,611.00 30,262.50 5.022 572,348.50 Program number: _e02,611.00 602,611.00 30,262.50 5.022 572,348.50 Department number: Administration MI 602,611.00 602,611.00 30,262.50 5.022 572,348.50 Expenditures Subtotal 602,611.00 602,611.00 30,262.50 5.022 572,348.50 Fund number: 535 2016 Rev Bond I&S-SWIFT 326,086.00 326,086.00 120,504.36- -36.955 446,590.36 glpdatb2 skrolczyk 12:48 04/15/20 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: 3/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department Totals: (25,133.99) Monthly Total (150,766.86) ** (276,525.00) Budgeted (125,758.14) Remaining 55 % Used Account: 535-49011-000-000 Interest Income 1047 03/31/2020 Bank Interest- March (394.27) (86.27) (480.54) GL Account: 535-49011-000-000 Interest Income Totals: (86.27) (480.54) ** (1,000.00) Budgeted (519.46) Remaining 48 5 Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1046 03/30/2020 TexPool Transfers March TexPool O&M to 16Swift Rev I&S (125,238.60) (25,047.72) (150,286.32) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: W. (25,047.72) (150,286.32) ** (275,525.00) Budgeted (125,238.68) Remaining 55 5 Used Department Totals: (25,133.99) Monthly Total (150,766.86) ** (276,525.00) Budgeted (125,758.14) Remaining 55 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 3/2020 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 Account: 535-70005-051-000 11 Rev Bond Paying Agent Fee Rev Bond Paying Agent Fee 800.00 Budgeted 600.00 Remaining Account: 535-70040-051-000 Revenue Bond Interest Expense Account: 535-70040-051-000 Account: 535-70045-051-000 Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 356,748.50 Remaining Revenue Bond Principal Expense Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining 200.00 30,062.50 25 % Used .00 200.00 .00 30,062.50 8 % Used .00 .00 0 % Used Department 51 Totals: 30,262.50 ** .00 Monthly Total 602,611.00 Budgeted 572,348.50 Remaining 5 % Used Fund 535 Totals: (120,504.36) (25,133.99) Monthly Total 326,086.00 Budgeted 446,590.36 Remaining -37 % Used TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 511 TROPHY CLUB MTJNICIPAL UTILITY IIISTRICT 536 REVENUE BOND SERIES 2019 I&S 23,281 TOTAL ASSETS 23,281 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 23,281 TOTAL FUND BALANCE 23,281 TOTAL LIABILITIES AND FUND BALANCE 23,281 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account Description 536-49011-000-000 536-49142-000-000 536-49143-000-000 Interest Income Interfund Tran In -Water Sales Interfund Transfer In -WW Sales Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 3/2020 Adopted Amended Total Current Budget Budget Encumb. Month 19.84- Program: Program number: 19.84- Department number: Revenues Revenues Subtotal 19.84- 19.84 - YTD % of Remaining Total Budget Budget 434.80- 434.80 183,168.16- 183,168.16 54,712.56- 54,712.56 238,315.! 238,315.52 238,315.52- 238,315.52 238,315.52- 238,315.52 238,315.52- 238,315.52 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account 1 1 536-70005-051-000 1 536-70040-051-000 Description Rev Bond Paying Agent Fee Revenue Bond Interest Expense Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 3/2020 Program: Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 142.08 214,892.43 142.08- 214,892.43 - ******* End of Report ********* Subtotal: 215,034.51 215,034.51 - Program number: 215,034.51 215,034.51 - Department number: Administration 215,034.51 215,034.51 - Expenditures Subtotal 215,034.51 215,034.51 - Fund number: 536 2019 Rev Bond I&S- W&WW System 19.84- 23,281.01- 23,281.01 ******* End of Report ********* glpdatb2 skrolczyk 12:48 04/15/20 Fund: 536 2019 Rev Bond I&S- W&WW System JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 3/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department Totals: (19.84) Monthly Total .00 Budgeted (238,315.52) ** 238,315.52 Remaining 0 % Used Account: 536-49011-000-000 Interest Income 1047 03/31/2020 Bank Interest- March (414.96) (19.84) (434.80) GL Account: 536-49011-000-000 Interest Income Totals: i (19.84) (434.80) ** .00 Budgeted 434.80 Remaining 0 % Used Account: 536-49142-000-000 Interfund Tran In -Water Sales (183,168.16) .00 (183,168.16) Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals: ; .00 (183,168.16) ** .00 Budgeted 183,168.16 Remaining 0 % Used Account: 536-49143-000-000 Interfund Transfer In -WW Sales (54,712.56) (54,712.56) .00 Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals: .00 (54,712.56) ** .00 Budgeted 54,712.56 Remaining 0 % Used Department Totals: (19.84) Monthly Total .00 Budgeted (238,315.52) ** 238,315.52 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 2&S- W&WW System Department: 51 Administration Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-70005-051-000 Account: 536-70005-051-000 11 Rev Bond Paying Agent Fee Rev Bond Paying Agent .00 Budgeted 142.08 (142.08) Remaining 0 % Used Account: 536-70040-051-000 Revenue Bond Interest Expense 214,892.43 Account: 536-70040-051-000 Revenue Bond Interest Expense Totals: .00 Budgeted (214,892.43) Remaining Department 51 Totals: Fund 536 Totals: Grand Totals: 0 % Used .00 Monthly Total .00 Budgeted (19.84) Monthly Total .00 Budgeted .00 142.08 .00 214,892.43 215,034.51 ** (215,034.51) Remaining 0 % Used (23,281.01) 23,281.01 Remaining 0 % Used ******* End of Report ********* (1,770,732.02) **** (135,636.24) Monthly Total (209,104.00) Budgeted 1,561,628.02 Remaining 847 % Used