Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Q4-2021-22 Financial Statements
CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2021 - 2022 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET General Fund, 101 Total Revenues 42,228,007.00 40,861,214.53 0.00 1,366,792.47 96.76% Total General Government 6,931,608.00 6,573,414.11 143,321.34 214,872.55 96.90% Total Public Safety 19,278,631.54 18,633,807.94 903,086.16 (258,262.56)101.34% Total Public Environment 2,002,970.00 1,926,603.19 14,507.07 61,859.74 96.91% Total Parks & Recreation 2,807,854.00 2,577,795.54 123,338.63 106,719.83 96.20% Total Cultural 1,189,773.00 1,144,683.89 0.00 45,089.11 96.21% Total Internal Services 7,754,941.00 7,169,921.90 268,204.19 316,814.91 95.91% Total Misc & Projects 2,262,230.00 2,218,615.25 13,700.00 29,914.75 98.68% Total Expenditures 42,228,007.54 40,244,841.82 1,466,157.39 517,008.33 98.78% Revenue Over(Under) Expenditures (0.54)616,372.71 (1,466,157.39)849,784.14 General Fund, 101 Total Cash in Bank & Investments 14,889,707.92 Special Events Fund, 106 Total Revenues 24,000.00 47,441.86 0.00 (23,441.86)197.67% Total Expenditures 24,000.00 29,568.22 0.00 (5,568.22)123.20% Revenue Over(Under) Expenditures 0.00 17,873.64 0.00 (17,873.64) Special Events Fund, 106 Total Cash in Bank & Investments 138,720.45 Peg Fund, 110 Total Revenues 867,521.00 79,402.59 0.00 788,118.41 9.15% Total Expenditures 867,521.00 162,751.41 461,590.96 243,178.63 71.97% Revenue Over(Under) Expenditures 0.00 (83,348.82)(461,590.96)544,939.78 Peg Fund, 110 Total Cash in Bank & Investments 869,564.08 Water & Sewer, 202 Total Revenues 28,758,723.00 35,173,014.25 0.00 (6,414,291.25)122.30% Total Expenditures 25,921,362.00 34,134,525.62 767,131.39 (8,980,295.01)134.64% Revenue Over(Under) Expenditures 2,837,361.00 1,038,488.63 (767,131.39)2,566,003.76 Water & Sewer, 202 Total Cash in Bank & Investments 8,819,992.35 EMS, 203 Total Revenues 11,794,594.14 11,995,766.69 0.00 (201,172.55)101.71% Total Expenditures 11,736,093.61 11,658,754.15 364,207.61 (286,868.15)102.44% Revenue Over(Under) Expenditures 58,500.53 337,012.54 (364,207.61)85,695.60 EMS, 203 Total Cash in Bank & Investments 923,822.58 Quarterly Statement Schertz, Texas AS OF :September 30, 2022 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2021 - 2022 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Drainage, 204 Total Revenues 1,284,229.00 1,289,716.19 0.00 (5,487.19)100.43% Total Expenditures 1,272,024.00 1,097,440.86 40,111.10 134,472.04 89.43% Revenue Over(Under) Expenditures 12,205.00 192,275.33 (40,111.10)(139,959.23) Drainage, 204 Total Cash in Bank & Investments 638,872.15 Hotel Tax, 314 Total Revenues 1,675,250.00 818,714.88 0.00 856,535.12 48.87% Total Expenditures 1,579,797.00 1,473,811.94 24,553.40 81,431.66 94.85% Revenue Over(Under) Expenditures 95,453.00 (655,097.06)(24,553.40)775,103.46 Hotel Tax, 314 Total Cash in Bank & Investments 1,631,582.21 Park, 317 Total Revenues 319,025.00 2,194.71 0.00 316,830.29 0.69% Total Expenditures 125,000.00 27,690.02 0.00 97,309.98 22.15% Revenue Over(Under) Expenditures 194,025.00 (25,495.31)0.00 219,520.31 Park, 317 Total Cash in Bank & Investments 264,072.05 Tree Mitigation, 319 Total Revenues 71,400.00 142,274.04 0.00 (70,874.04)199.26% Total Expenditures 70,000.00 82,110.00 0.00 (12,110.00)117.30% Revenue Over(Under) Expenditures 1,400.00 60,164.04 0.00 (58,764.04) Tree Mitigation, 319 Total Cash in Bank & Investments 722,434.25 Capital Recovery Water, 411 Total Revenues 1,116,000.00 897,871.33 0.00 218,128.67 80.45% Total Expenditures 4,281,818.70 4,268,052.25 36,438.81 (22,672.36)100.53% Revenue Over(Under) Expenditures (3,165,818.70)(3,370,180.92)(36,438.81)240,801.03 Capital Recovery Water, 411 Total Cash in Bank & Investments 4,902,060.23 Capital Recovery Sewer, 421 Total Revenues 660,250.00 431,148.02 0.00 229,101.98 65.30% Total Expenditures 55,500.00 21,382.14 76,559.25 (42,441.39)176.47% Revenue Over(Under) Expenditures 604,750.00 409,765.88 (76,559.25)271,543.37 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 8,316,636.10 Quarterly Statement Schertz, Texas AS OF :September 30, 2022 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2021 - 2022 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Roadway Impact Fee Area 1, 431 Total Revenues 200,900.00 258,907.21 0.00 (58,007.21)128.87% Total Expenditures 93,173.00 1,358.50 88,172.99 3,641.51 96.09% Revenue Over(Under) Expenditures 107,727.00 257,548.71 (88,172.99)(61,648.72) Roadway Impact Fee Area 1, 431 Total Cash in Bank & Investments 805,970.93 Roadway Impact Fee Area 2, 432 Total Revenues 120,400.00 345,736.67 0.00 (225,336.67)287.16% Total Expenditures 29,000.00 52,484.37 0.00 (23,484.37)180.98% Revenue Over(Under) Expenditures 91,400.00 293,252.30 0.00 (201,852.30) Roadway Impact Fee Area 2, 432 Total Cash in Bank & Investments 564,027.75 Roadway Impact Fee Area 3, 433 Total Revenues 401,500.00 214,108.43 0.00 187,391.57 53.33% Total Expenditures 5,000.00 3,337.50 0.00 1,662.50 66.75% Revenue Over(Under) Expenditures 396,500.00 210,770.93 0.00 185,729.07 Roadway Impact Fee Area 3, 433 Total Cash in Bank & Investments 1,183,301.24 Roadway Impact Fee Area 4, 434 Total Revenues 5,065.00 79.23 0.00 4,985.77 1.56% Total Expenditures 5,000.00 3,337.50 0.00 1,662.50 66.75% Revenue Over(Under) Expenditures 65.00 (3,258.27)0.00 3,323.27 Roadway Impact Fee Area 4, 434 Total Cash in Bank & Investments 6,053.19 I&S, 505 Total Revenues 7,434,862.00 7,409,680.23 0.00 25,181.77 99.66% Total Expenditures 6,676,915.00 6,632,648.26 0.00 44,266.74 99.34% Revenue Over(Under) Expenditures 757,947.00 777,031.97 0.00 (19,084.97) I&S, 505 Total Cash in Bank & Investments 1,864,408.64 SED Corporation, 620 Total Revenues 6,789,000.00 6,226,982.17 0.00 562,017.83 91.72% Total Expenditures 5,540,707.00 1,990,084.06 2,844.45 3,547,778.49 35.97% Revenue Over(Under) Expenditures 1,248,293.00 4,236,898.11 (2,844.45)(2,985,760.66) SED Corporation, 620 Total Cash in Bank & Investments 24,948,441.39 Total Cash in Bank & Investments 71,489,667.51 Quarterly Statement Schertz, Texas AS OF :September 30, 2022 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES REVENUE SUMMARY Taxes 28,032,800.00 3,436,804.20 27,294,441.33 28,794,951.10 - (762,151.10) 102.72 Franchises 2,327,000.00 689,342.24 2,226,361.24 2,494,637.06 - (167,637.06) 107.20 Permits 1,718,150.00 560,394.85 1,547,780.23 2,167,999.63 - (449,849.63) 126.18 Licenses 49,320.00 2,812.50 45,600.00 36,542.50 - 12,777.50 74.09 Fees 2,232,459.00 597,127.59 1,975,216.45 2,255,861.12 - (23,402.12) 101.05 Fines 9,000.00 2,691.92 8,476.81 10,590.29 - (1,590.29) 117.67 Inter-Jurisdictional 990,598.00 278,216.29 899,348.21 961,603.84 - 28,994.16 97.07 Fund Transfers 5,612,630.00 644,732.97 2,893,814.20 3,085,916.00 - 2,526,714.00 54.98 Miscellaneous 1,256,050.00 234,715.22 719,516.22 1,053,112.99 - 202,937.01 83.84 TOTAL REVENUES 42,228,007.00 6,446,837.78 37,610,554.69 40,861,214.53 - 1,366,792.47 96.76% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 38,102.00 8,398.74 37,822.60 36,444.09 14.40 1,643.51 95.69 Supplies 750.00 29.56 258.95 303.25 75.00 371.75 50.43 City Support Services 57,000.00 2,218.76 45,984.72 39,763.84 1,989.80 15,246.36 73.25 Operations Support 300.00 101.00 85.50 289.22 - 10.78 96.41 Staff Support 27,100.00 3,396.53 19,837.58 21,744.23 185.15 5,170.62 80.92 Professional Services 6,000.00 - 2,000.00 2,150.00 - 3,850.00 35.83 TOTAL CITY COUNCIL 129,252.00 14,144.59 105,989.35 100,694.63 2,264.35 26,293.02 79.66% CITY MANAGER Personnel Services 1,311,263.00 330,087.27 1,232,490.64 1,259,295.25 - 51,967.75 96.04 Supplies 1,606.53 318.53 1,064.17 1,192.17 - 414.36 74.21 City Support Services 2,000.00 417.51 3,697.07 1,332.51 - 667.49 66.63 Operations Support 50.00 - - - - 50.00 - Staff Support 25,168.47 4,403.00 11,501.52 22,558.99 135.00 2,474.48 90.17 Professional Services 13,641.21 - - 13,641.21 - - 100.00 Operating Equipment - - 1,200.00 - - - - Capital Outlay 44,000.00 43,537.28 - 43,537.28 44.50 418.22 99.05 TOTAL CITY MANAGER 1,397,729.21 378,763.59 1,249,953.40 1,341,557.41 179.50 55,992.30 95.99% MUNICIPAL COURT Personnel Services 321,928.00 77,091.01 293,160.96 319,682.81 - 2,245.19 99.30 Supplies 1,500.00 504.90 1,402.54 1,261.32 (71.99) 310.67 79.29 City Support Services 500.00 - 471.66 233.87 - 266.13 46.77 Operations Support 2,000.00 1,565.12 301.50 1,565.12 - 434.88 78.26 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 Staff Support 6,910.00 1,547.28 2,776.65 3,378.42 - 3,531.58 48.89 Court Support 3,000.00 132.00 - 264.00 - 2,736.00 8.80 Professional Services 61,700.00 13,943.87 43,378.70 41,403.87 14,550.00 5,746.13 90.69 Maintenance Services 3,000.00 1,032.00 2,065.00 2,714.00 550.00 (264.00) 108.80 Operating Equipment 4,000.00 1,143.21 - 1,890.91 179.99 1,929.10 0.52 TOTAL MUNICIPAL COURT 404,538.00 96,959.39 343,557.01 372,394.32 15,208.00 16,935.68 95.81% CUSTOMER RELATIONS-311 Personnel Services 123,855.00 28,523.88 114,658.11 118,164.28 - 5,690.72 95.41 Supplies 100.00 19.99 148.70 72.86 - 27.14 72.86 Staff Support 430.00 34.09 341.63 162.25 - 267.75 37.73 TOTAL CUSTOMER RELATIONS-311 124,385.00 28,577.96 115,148.44 118,399.39 - 5,985.61 95.19% PLANNING & ZONING Personnel Services 230,769.00 74,824.11 210,013.08 208,949.05 - 21,819.95 90.54 Supplies 2,020.00 128.00 806.50 1,390.26 (8.13) 637.87 68.42 City Support Services 9,000.00 7,500.00 - 7,500.00 1,166.00 334.00 96.29 Operations Support 248.00 - 128.90 - 31.00 217.00 12.50 Staff Support 33,939.00 9,177.03 3,174.00 11,513.51 - 22,425.49 33.92 Professional Services 400,100.00 30.00 20.00 75.00 - 400,025.00 0.02 Fund Chrgs/Transfrs - 400,000.00 - 400,000.00 - (400,000.00) - Operating Equipment 1,639.00 940.00 6,374.83 1,225.47 - 413.53 74.77 TOTAL PLANNING & ZONING 677,715.00 492,599.14 220,517.31 630,653.29 1,188.87 45,872.84 93.23% LEGAL SERVICES Operations Support 10,000.00 8,847.66 8,119.74 11,341.38 - (1,341.38) 113.41 Professional Services 130,000.00 51,155.40 150,246.22 99,376.09 - 30,623.91 76.44 TOTAL LEGAL SERVICES 140,000.00 60,003.06 158,365.96 110,717.47 - 29,282.53 79.08% CITY SECRETARY Personnel Services 206,009.00 52,376.39 194,552.36 211,495.90 - (5,486.90) 102.66 Supplies 1,600.00 568.88 1,082.15 1,346.74 35.60 217.66 86.40 City Support Services 9,400.00 3,045.14 5,921.09 5,109.11 - 4,290.89 54.35 Operations Support 150.00 - 43.00 138.95 - 11.05 92.63 Staff Support 6,000.00 636.95 3,144.08 3,034.97 - 2,965.03 50.58 Operating Equipment 1,000.00 - 249.99 - - 1,000.00 - TOTAL CITY SECRETARY 224,159.00 56,627.36 204,992.67 221,125.67 35.60 2,997.73 98.66% NON-DEPARTMENTAL City Support Services 588,410.79 67,081.04 779,548.74 576,463.51 16,770.68 (4,823.40) 100.82 Utility Services - 3,065.00 7,123.21 3,065.00 - (3,065.00) - Operations Support 140,000.00 33,018.32 141,918.71 129,079.39 - 10,920.61 92.20 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 City Assistance 1,315,645.00 180,311.06 1,406,900.02 1,317,827.68 - (2,182.68) 100.17 Professional Services 88,775.00 15,430.47 100,287.99 83,401.94 265.00 5,108.06 94.25 Fund Chrgs/Transfrs-Spec Events Fnd 27,979.00 30,945.39 122.21 30,945.39 - (2,966.39) 110.60 Capital Outlay - - 7,450.00 - - - - TOTAL NON-DEPARTMENTAL 2,160,809.79 329,851.28 2,443,350.88 2,140,782.91 17,035.68 2,991.20 99.86% PUBLIC AFFAIRS Personnel Services 348,981.00 76,142.53 313,029.02 329,937.85 - 19,043.15 94.54 Supplies 1,100.00 268.64 1,662.51 1,063.02 - 36.98 96.64 City Support Services 1,000.00 321.38 - 528.38 - 471.62 52.84 Operations Support 49,935.00 11,795.07 39,119.43 37,125.18 - 12,809.82 74.35 Staff Support 8,520.00 1,076.54 3,163.01 3,523.52 - 4,996.48 41.36 Professional Services 271,600.00 58,581.93 246,818.22 259,815.46 - 11,784.54 95.66 Operating Equipment 850.00 799.88 - 799.88 - 50.12 94.10 TOTAL PUBLIC AFFAIRS 681,986.00 148,985.97 603,792.19 632,793.29 - 49,192.71 92.79% ENGINEERING Personnel Services 901,990.00 225,674.10 824,116.94 849,599.28 - 52,390.72 94.19 Supplies 2,750.00 761.23 978.86 1,276.89 - 1,473.11 46.43 City Support Services 1,265.00 - - 1,264.80 - 0.20 99.98 Utility Services 5,500.00 3,141.29 5,211.69 6,285.89 - (785.89) 114.29 Operations Support 150.00 31.00 93.00 61.81 - 88.19 41.21 Staff Support 16,045.00 4,191.89 6,084.08 8,803.56 - 7,241.44 54.87 Professional Services 61,934.00 18,241.50 34,465.00 36,884.55 21,931.00 3,118.45 94.96 Operating Equipment 1,400.00 - (787.75) 118.95 - 1,281.05 8.50 TOTAL ENGINEERING 991,034.00 252,041.01 870,161.82 904,295.73 107,409.34 (20,671.07) 102.09% TOTAL GENERAL GOVERNMENT 6,931,608.00 1,858,553.35 6,315,829.03 6,573,414.11 143,321.34 214,872.55 96.90% PUBLIC SAFETY POLICE Personnel Services 9,155,515.00 2,175,529.85 8,793,001.25 8,980,658.64 - 174,856.36 98.09 Supplies 99,557.91 21,305.70 81,816.74 78,178.16 (9.74) 21,389.49 78.52 City Support Services 26,500.00 - 32,421.79 33,969.74 - (7,469.74) 128.19 Utility Services 201,872.00 80,742.95 142,159.54 210,810.99 - (8,938.99) 104.43 Operations Support 27,316.00 1,475.01 11,714.01 15,905.56 - 11,410.44 58.23 Staff Support 194,569.83 39,359.96 185,169.59 154,914.18 21,173.43 18,482.22 90.50 City Assistance 71,319.00 32,796.53 49,922.65 73,671.19 - (2,352.19) 103.30 Professional Services 79,266.20 4,359.39 58,082.19 58,241.11 - 21,025.09 73.48 Maintenance Services 77,305.00 20,516.30 63,918.06 58,968.23 - 18,336.77 76.28 Operating Equipment 196,688.60 141,429.64 292,745.95 269,074.08 14,845.00 (87,230.48) 144.35 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 Capital Outlay 508,406.00 - 244,450.56 298,642.52 482,551.49 (272,788.01) 153.66 TOTAL POLICE 10,638,315.54 2,517,515.33 9,955,402.33 10,233,034.40 518,560.18 (113,279.04) 101.06% FIRE RESCUE Personnel Services 6,086,677.00 1,475,546.66 5,703,000.52 6,338,803.79 - (252,126.79) 104.14 Supplies 26,930.00 10,152.31 11,646.50 21,949.62 1,710.34 3,270.04 87.86 Utility Services 80,000.00 46,064.61 86,881.23 121,405.00 - (41,405.00) 151.76 Operations Support 4,527.00 62.00 374.73 2,352.26 - 2,174.74 51.96 Staff Support 206,772.00 62,845.23 174,584.75 161,974.65 27,742.46 17,054.89 91.75 City Assistance 25,198.00 3,133.69 21,574.66 9,198.02 15,832.91 167.07 99.34 Professional Services 63,600.00 3,445.00 73,052.43 43,633.82 - 19,966.18 68.61 Maintenance Services 81,500.00 14,337.51 53,860.91 56,862.71 - 24,637.29 69.77 Other Costs 10,000.00 17,912.90 6,895.26 66,977.24 - (56,977.24) 669.77 Rental/Leasing 39,025.00 - - 38,744.86 - 280.14 99.28 Operating Equipment 120,000.00 30,713.19 341,500.42 75,260.51 21,802.16 22,937.33 80.89 Capital Outlay 473,637.00 74,880.12 86,408.81 92,247.12 229,216.67 152,173.21 67.87 TOTAL FIRE RESCUE 7,217,866.00 1,739,093.22 6,559,780.22 7,029,409.60 296,304.54 (107,848.14) 101.49% INSPECTIONS Personnel Services 918,554.00 214,028.06 884,168.51 923,678.74 - (5,124.74) 100.56 Supplies 5,100.00 1,290.57 2,547.88 2,116.05 - 2,983.95 41.49 Utility Services 8,400.00 2,217.43 5,659.27 6,384.92 - 2,015.08 76.01 Operations Support 850.00 - 176.00 31.00 - 819.00 3.65 Staff Support 41,446.00 11,254.61 20,210.26 20,764.28 - 20,681.72 50.10 Professional Services 70,000.00 17,200.00 32,987.50 57,900.00 12,100.00 - 100.00 Operating Equipment 650.00 - 1,201.76 570.94 - 79.06 87.84 Capital Outlay - - 27,381.00 - 76,121.44 (76,121.44) - TOTAL INSPECTIONS 1,045,000.00 245,990.67 974,332.18 1,011,445.93 88,221.44 (54,667.37) 105.23% NEIGHBORHOOD SERVICES Personnel Services 312,294.00 81,001.36 - 326,230.99 - (13,936.99) 104.46 Supplies 5,924.00 2,980.15 - 4,568.33 - 1,355.67 77.12 Utility Services 12,595.00 1,722.52 - 4,852.56 - 7,742.44 38.53 Operations Support 3,419.00 - - 31.00 - 3,388.00 0.91 Staff Support 24,393.00 9,443.53 - 14,050.68 - 10,342.32 57.60 Professional Services 2,500.00 - - - - 2,500.00 - Maintenance Services 15,000.00 2,350.00 - 9,025.00 - 5,975.00 60.17 Operating Equipment 1,325.00 - - 1,159.45 - 165.55 87.51 TOTAL NEIGHBORHOOD SERVICES 377,450.00 97,497.56 - 359,918.01 - 17,531.99 95.36% 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 TOTAL PUBLIC SAFETY 19,278,631.54 4,600,096.78 17,489,514.73 18,633,807.94 903,086.16 (258,262.56) 101.34% PUBLIC ENVIRONMENT STREETS Personnel Services 986,600.00 227,640.77 815,231.91 967,503.14 1,149.57 17,947.29 98.18 Supplies 139,475.00 56,464.21 100,221.91 127,232.89 231.47 12,010.64 91.39 City Support Services 6,000.00 2,236.20 133.25 3,771.53 30.15 2,198.32 63.36 Utility Services 192,600.00 87,464.64 188,188.81 230,811.30 - (38,211.30) 119.84 Staff Support 25,920.00 10,570.86 18,944.40 23,990.61 30.88 1,898.51 92.68 Professional Services 58,600.00 41,695.75 12,495.00 49,231.85 - 9,368.15 84.01 Maintenance Services 383,500.00 79,653.99 213,778.14 324,184.21 650.00 58,665.79 84.70 Rental/Lease 5,000.00 - 2,611.79 4,285.00 - 715.00 85.70 Operating Equipment 45,200.00 30,671.15 30,580.67 35,547.43 12,415.00 (2,762.43) 106.11 Capital Outlay 160,075.00 58,128.61 31,623.00 160,045.23 - 29.77 99.98 TOTAL STREETS 2,002,970.00 594,526.18 1,413,808.88 1,926,603.19 14,507.07 61,859.74 96.91% TOTAL PUBLIC ENVIRONMENT 2,002,970.00 594,526.18 1,413,808.88 1,926,603.19 14,507.07 61,859.74 96.91% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 758,970.00 189,165.05 669,997.35 729,137.70 - 29,832.30 96.07 Supplies 113,148.00 21,428.48 122,154.05 98,309.40 - 14,838.60 86.89 City Support Services 166,000.00 61,742.06 153,878.72 167,763.12 - (1,763.12) 101.06 Utility Services 246,000.00 90,911.95 260,987.79 246,900.43 - (900.43) 100.37 Operations Support 2,000.00 994.40 1,049.42 1,044.40 217.75 737.85 63.11 Staff Support 19,670.00 5,490.87 15,958.04 18,938.24 - 731.76 96.28 Professional Services 183,964.00 52,259.01 146,145.47 149,267.01 31,050.60 3,646.39 98.02 Maintenance Services 14,000.00 628.48 76,649.00 12,985.38 - 1,014.62 92.75 Rental/Leasing 10,000.00 1,738.93 10,037.82 7,006.81 - 2,993.19 70.07 Operating Equipment 65,000.00 7,710.92 52,344.66 33,792.37 9,014.36 22,193.27 65.86 Capital Outlay 244,979.00 69,203.47 152,666.70 128,376.94 83,055.92 33,546.14 86.31 TOTAL PARKS DEPARTMENT 1,823,731.00 501,273.62 1,661,869.02 1,593,521.80 123,338.63 106,870.57 94.14% SWIM POOL Supplies 25,500.00 4,029.16 23,107.26 27,388.69 - (1,888.69) 107.41 Utility Services 16,500.00 8,550.01 22,616.41 24,788.47 - (8,288.47) 150.23 Maintenance Services 527,878.00 169,432.63 490,950.21 537,096.36 - (9,218.36) 101.75 TOTAL SWIM POOL 569,878.00 182,011.80 536,673.88 589,273.52 - (19,395.52) 103.40% EVENT FACILITIES Personnel Services 316,022.00 82,863.48 216,037.24 320,975.26 - (4,953.26) 101.57 Supplies 5,150.00 1,282.54 5,605.72 4,360.89 - 789.11 84.68 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 Utility Services 48,600.00 23,218.86 40,363.06 47,275.79 - 1,324.21 97.28 Operations Support 13,408.00 1,743.89 30,114.22 2,789.48 - 10,618.52 20.80 Staff Support 4,865.00 1,337.97 2,362.26 2,894.44 - 1,970.56 59.50 Maintenance Services 12,700.00 915.00 5,641.00 4,172.77 - 8,527.23 32.86 Operating Equipment 13,500.00 3,148.84 6,745.02 12,531.59 - 968.41 92.83 TOTAL EVENT FACILITIES 414,245.00 114,510.58 307,775.32 395,000.22 - 19,244.78 95.35% TOTAL PARKS & RECREATION 2,807,854.00 797,796.00 2,506,318.22 2,577,795.54 123,338.63 106,719.83 96.20% CULTURAL LIBRARY Personnel Services 930,786.00 222,811.17 847,827.48 911,988.13 - 18,797.87 97.98 Supplies 15,000.00 3,561.92 11,346.56 11,204.67 - 3,795.33 74.70 Utility Services 70,000.00 23,567.04 48,116.88 63,622.35 - 6,377.65 90.89 Operations Support 5,900.00 3,220.55 2,167.88 4,808.24 - 1,091.76 81.50 Staff Support 7,025.00 350.00 3,655.09 6,249.16 - 775.84 88.96 Professional Services 3,300.00 - 1,655.96 2,129.00 - 1,171.00 64.52 Operating Equipment 157,762.00 32,984.12 125,507.79 144,682.34 - 13,079.66 91.71 TOTAL LIBRARY 1,189,773.00 286,494.80 1,040,277.64 1,144,683.89 - 45,089.11 96.21% TOTAL CULTURAL 1,189,773.00 286,494.80 1,040,277.64 1,144,683.89 - 45,089.11 96.21% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 952,258.00 227,329.50 847,553.47 952,714.97 - (456.97) 100.05 Supplies 9,300.00 1,517.50 4,350.85 7,619.81 - 1,680.19 81.93 City Support Services 1,024,097.00 269,655.09 863,873.36 998,887.98 206.50 25,002.52 97.56 Utility Services 367,465.00 118,718.03 318,225.84 367,726.50 206.95 (468.45) 100.13 Staff Support 53,700.00 17,674.69 22,058.94 43,206.91 3,251.50 7,241.59 86.51 Professional Services 38,075.00 - 118,812.81 1,406.25 - 36,668.75 3.69 Maintenance Services 10,000.00 7,862.06 9,948.26 9,639.41 269.90 90.69 99.09 Rental/Leasing 3,650.00 608.36 3,477.27 3,345.98 304.18 (0.16) 100.00 Operating Equipment 284,594.00 75,849.35 302,387.42 268,886.29 5,476.80 10,230.91 96.41 TOTAL INFORMATION TECHNOLOGY 2,743,139.00 719,214.58 2,517,577.22 2,653,434.10 9,715.83 79,989.07 97.08% HUMAN RESOURCES Personnel Services 475,219.00 121,510.77 451,403.18 443,643.56 - 31,575.44 93.36 Supplies 2,700.00 329.57 1,054.59 1,197.18 813.69 689.13 74.48 Human Services 213,645.00 39,905.10 159,426.20 156,973.06 - 56,671.94 73.47 Operations Support 5,500.00 973.00 4,017.90 3,297.84 - 2,202.16 59.96 Staff Support 32,205.00 3,377.83 33,546.85 26,373.66 15.77 5,815.57 81.94 City Assistance 20,700.00 4,995.00 16,430.00 18,958.00 990.00 752.00 96.37 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 Professional Services 5,000.00 4,126.05 - 4,126.05 - 873.95 82.52 Operating Equipment 500.00 - 513.31 - - 500.00 - TOTAL HUMAN RESOURCES 755,469.00 175,217.32 666,392.03 654,569.35 1,819.46 99,080.19 86.88% FINANCE Personnel Services 690,179.00 167,608.71 641,054.36 668,781.56 - 21,397.44 96.90 Supplies 2,700.00 1,047.85 3,125.33 2,620.83 - 79.17 97.07 Staff Support 6,710.00 3,028.24 3,384.00 4,346.76 - 2,363.24 64.78 Professional Sevices 38,700.00 13,766.99 38,883.51 52,312.28 - (13,612.28) 135.17 Operating Equipment 280.00 279.99 586.07 279.99 - 0.01 100.00 TOTAL FINANCE 738,569.00 185,731.78 687,033.27 728,341.42 - 10,227.58 98.62% PURCHASING & ASSET MGT Personnel Services 261,379.00 64,460.57 235,534.73 260,776.15 - 602.85 99.77 Supplies 3,600.00 (193.71) 559.07 1,614.64 - 1,985.36 44.85 Operations Support 6,050.00 2,863.25 3,756.50 5,535.25 216.75 298.00 95.07 Staff Support 7,785.00 3,244.85 4,885.25 6,826.39 - 958.61 87.69 City Assistance 2,000.00 562.00 1,342.00 2,108.00 124.00 (232.00) 111.60 Operating Equipment 600.00 119.99 1,457.25 499.97 - 100.03 83.33 TOTAL PURCHASING & ASSET MGT 281,914.00 71,554.95 247,913.01 277,858.40 340.75 3,714.85 98.68% FLEET SERVICE Personnel Services 560,458.00 126,047.45 532,884.25 512,535.98 - 47,922.02 91.45 Supplies 237,991.00 88,109.16 166,115.89 235,082.50 2,554.20 354.30 99.85 City Support Services 4,700.00 - 2,496.70 4,689.34 - 10.66 99.77 Utility Services 9,800.00 3,849.08 8,517.86 9,420.03 - 379.97 96.12 Staff Support 29,017.00 15,371.47 16,358.15 28,714.22 30.15 272.63 99.06 Maintenance Services 247,577.00 59,415.01 232,178.70 230,123.62 16,602.00 851.38 99.66 Operating Equipment 20,910.00 9,190.00 39,248.65 20,909.15 - 0.85 100.00 Capital Outlay 195,658.00 50,079.89 27,675.31 145,544.93 94,256.40 (44,143.33) 122.56 TOTAL FLEET SERVICE 1,306,111.00 366,732.71 1,025,475.51 1,217,319.64 113,442.75 (24,651.39) 101.89% FACILITY SERVICES Personnel Services 753,072.00 184,288.13 767,106.37 754,037.35 - (965.35) 100.13 Supplies 134,842.00 54,791.80 57,240.42 119,147.87 7,342.99 8,351.14 93.81 City Support Services 5,000.00 - 355.00 - - 5,000.00 - Utility Services 191,000.00 64,030.85 185,011.98 193,500.70 - (2,500.70) 101.31 Staff Support 20,900.00 7,922.38 11,541.80 17,451.20 48.95 3,399.85 83.73 Professional Services 160,000.00 40,190.33 94,953.58 148,080.12 6,758.12 5,161.76 96.77 Maintenance Services 615,800.00 147,302.43 517,295.00 367,920.92 12,236.50 235,642.58 61.73 Rental/Leasing 500.00 - - - - 500.00 - 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 Operating Equipment 6,000.00 1,354.00 2,861.44 1,704.00 - 4,296.00 28.40 Capital Outlay 42,625.00 10,523.83 27,266.00 36,556.83 116,498.84 (110,430.67) 359.07 TOTAL BUILDING MAINTENANCE 1,929,739.00 510,403.75 1,663,631.59 1,638,398.99 142,885.40 148,454.61 92.31% TOTAL INTERNAL SERVICE 7,754,941.00 2,028,855.09 6,808,022.63 7,169,921.90 268,204.19 316,814.91 95.91% MISC & PROJECTS Project Fund Charges/Transfers 1,645,112.00 1,139,701.00 2,314,007.01 1,645,112.00 - - 100.00 TOTAL PROJECTS 1,645,112.00 1,139,701.00 2,314,007.01 1,645,112.00 - - 100.00% CITY ASSISTANCE City's Assistance to Agencies 302,666.00 66,639.75 290,617.17 282,518.25 5,000.00 15,147.75 95.00 Operating Equipment 10,000.00 - - - 6,200.00 3,800.00 62.00 TOTAL CITY ASSISTANCE 312,666.00 66,639.75 290,617.17 282,518.25 11,200.00 18,947.75 93.94% SEWER PROJECTS Fund Charges/Transfers 285,000.00 285,000.00 - 285,000.00 - - 100.00 TOTAL SEWER PROJECTS 285,000.00 285,000.00 - 285,000.00 - - 100.00% COURT - RESTRICTED FUNDS Operating Equipment 19,452.00 - 11,769.99 5,985.00 2,500.00 10,967.00 43.62 TOTAL COURT-RESTRICTED FUNDS 19,452.00 - 11,769.99 5,985.00 2,500.00 10,967.00 43.62% TOTAL MISC & PROJECTS 2,262,230.00 1,491,340.75 2,616,394.17 2,218,615.25 13,700.00 29,914.75 98.68% TOTAL EXPENDITURES 42,228,007.54 11,657,662.95 38,190,165.30 40,244,841.82 1,466,157.39 517,008.33 98.78% REVENUE OVER(UNDER) EXPEND.(0.54) (5,210,825.17) (579,610.61) 616,372.71 (1,466,157.39) 849,784.14 101 GENERAL FUND CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Taxes 000-411100 Advalorem Tax-Current 94,609.38 14,762,219.16 15,626,509.01 - (206,509.01) 101.34 000-411110 Disable Veterans Assist Pymnt - 1,064,592.01 897,968.67 - 202,031.33 81.63 000-411200 Advalorem Tax-Delinquent 12,810.81 68,736.95 22,661.44 - 27,338.56 45.32 000-411300 Advalorem Tax-P&I 24,887.25 107,360.63 114,390.95 - (44,390.95) 163.42 000-411500 Sales Tax Revenue-Gen Fund 3,279,423.62 11,222,802.51 12,050,029.57 - (727,229.57) 106.42 000-411700 Mixed Beverage Tax 25,073.14 68,730.07 83,391.46 - (13,391.46) 119.13 TOTAL Taxes 3,436,804.20 27,294,441.33 28,794,951.10 - (762,151.10) 102.72% Franchises 000-421200 Center Point/Entex Energy 24,481.40 103,057.54 126,358.46 - (32,358.46) 134.42 000-421220 City Public Service 446,598.21 1,039,099.72 1,233,886.26 - (253,886.26) 125.91 000-421240 Guadalupe Valley Elec Co-op 168,794.89 457,842.38 524,778.95 - (64,778.95) 114.08 000-421250 New Braunfels Utilities 22,178.43 71,295.94 77,046.54 - (7,046.54) 110.07 000-421300 Time Warner-State Franchise 75,811.89 317,385.21 307,341.29 - 17,658.71 94.57 000-421460 AT&T Franchise Fee (39,947.60) 27,032.09 22,857.76 - 77,142.24 22.86 000-421480 Other Telecom Franchise - ROW (53,603.10) 44,205.85 26,551.23 - 103,448.77 20.42 000-421500 Solid Waste Franchise Fee 45,028.12 166,442.51 175,816.57 - (7,816.57) 104.65 TOTAL Franchises 689,342.24 2,226,361.24 2,494,637.06 - (167,637.06) 107.20% Permits 000-431100 Home Occupation Permit - 665.00 350.00 - 175.00 66.67 000-431205 Bldg Permit-Residential 107,028.75 475,335.50 337,018.25 - 264,381.75 56.04 000-431210 Bldg Permit-Commercial 256,307.22 210,053.00 890,050.91 - (640,050.91) 356.02 000-431215 Bldg Permit-General 77,527.14 356,640.50 281,149.90 - 68,850.10 80.33 000-431300 Mobile Home Permit 50.00 400.00 100.00 - 275.00 26.67 000-431400 Signs Permit 1,492.00 6,668.00 6,047.00 - (1,047.00) 120.94 000-431500 Food Establishmnt Permit 18,265.00 73,410.00 69,075.00 - 925.00 98.68 000-431700 Plumbing Permit 24,650.00 121,196.00 93,030.00 - 36,970.00 71.56 000-431750 Electrical Permit 18,920.00 75,500.00 62,500.00 - 12,500.00 83.33 000-431800 Mechanical Permit 14,240.00 53,800.00 47,480.00 - 20,520.00 69.82 000-431900 Solicitor/Peddler Permit 1,070.00 2,890.00 2,800.00 - (800.00) 140.00 000-431950 Animal/Pet Permit 200.00 100.00 400.00 - (150.00) 160.00 000-432000 Cert of Occupancy Prmt - 11,350.00 7,550.00 - 50.00 99.34 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 101 GENERAL FUND CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 000-432100 Security Alarm Permit 10,076.77 31,661.67 40,026.77 - 2,973.23 93.09 000-432300 Grading/Clearing Permit 9,109.86 12,942.78 27,790.09 - (17,790.09) 277.90 000-432400 Development Permit 15,176.11 87,450.28 273,965.71 - (198,965.71) 365.29 000-435000 Fire Permit 6,282.00 27,717.50 28,666.00 - 1,334.00 95.55 TOTAL Permits 560,394.85 1,547,780.23 2,167,999.63 - (449,849.63) 126.18% Licenses 000-441000 Alcohol Beverage License 2,812.50 9,620.00 8,242.50 - (42.50) 100.52 000-441300 Mobile Home License - 80.00 120.00 - - 100.00 000-442000 Contractors License - 35,900.00 28,180.00 - 12,820.00 68.73 TOTAL Licenses 2,812.50 45,600.00 36,542.50 - 12,777.50 74.09% Fees 000-451000 Municipal Court Fines 120,735.75 481,066.88 475,978.73 - 149,021.27 76.16 000-451010 Texas Motor Carrier Fines 250.00 - 21,954.00 - (21,954.00) - 000-451015 CVE Out of Service 50.00 250.00 1,950.00 - (1,950.00) 000-451100 Arrest Fee 3,880.03 14,040.19 15,353.56 - 5,946.44 72.08 000-451110 Expunction Fee - - - - 100.00 - 000-451200 Warrant Fees 12,743.94 56,474.29 54,749.47 - 12,650.53 81.23 000-451220 Officer Jury Fee - - - - 200.00 - 000-451310 Restitution Fee-Local - 102.60 - - 100.00 - 000-451340 Judicial Fee-City 68.60 543.99 343.97 - 1,180.03 22.57 000-451400 Traffic Fine Costs TTL 1,671.41 5,839.05 6,587.98 - 3,336.02 66.38 000-451510 Juvenile Case Mgmt Fee 571.64 4,543.28 2,876.55 - 9,891.45 22.53 000-451520 Truancy Fees 3,921.30 12,458.78 15,115.18 - (1,531.18) 111.27 000-451530 Local Municipal Jury Fund 77.04 237.52 294.88 - (69.88) 131.06 000-451600 Technology Fund Fee 3,543.14 13,232.68 14,171.09 - 5,280.91 72.85 000-451700 Security Fee 4,120.75 14,436.99 16,231.74 - 2,668.26 85.88 000-451800 Time Payment Fee-City 1,387.49 2,616.57 4,846.77 - (706.77) 117.07 000-451850 State Fines 10% Service Fee 13,937.01 27,690.93 24,547.98 - 8,064.02 75.27 000-451900 DPS Payment-Local 985.21 4,353.21 4,426.96 - 625.04 87.63 000-452000 Child Safety Fee 1,070.19 4,800.49 4,841.96 - 1,038.04 82.35 000-452100 Platting Fees 14,000.00 44,500.00 55,250.00 - (1,250.00) 102.31 000-452200 Site Plan Fee 4,500.00 19,000.00 23,000.00 - - 100.00 101 GENERAL FUND CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 000-452300 Plan Check Fee 138,353.18 462,927.75 592,968.92 - 7,031.08 98.83 000-452320 Tree Mitigation Admin Fee - 38,737.50 11,550.00 - 3,450.00 77.00 000-452400 BOA/Variance Fees 1,000.00 1,500.00 3,500.00 - (1,000.00) 140.00 000-452600 Specific Use/Zone Chng Fee 6,250.00 34,300.00 37,250.00 - (10,800.00) 140.83 000-452710 Zoning Ltr & Dev Rights 450.00 2,700.00 4,800.00 - (2,250.00) 188.24 000-453100 Reinspection Fees 41,625.00 179,625.00 185,725.00 - 4,275.00 97.75 000-453110 Swim Pool Inspection Fee 330.00 3,410.00 990.00 - 1,510.00 39.60 000-453200 Lot Abatement 2,539.58 6,525.00 7,264.58 - (2,264.58) 145.29 000-453211 Admin Fee-Inspections 500.00 3,000.00 10,400.00 - (400.00) 104.00 000-453710 Foster Care - 300.00 50.00 - 450.00 10.00 000-454200 Pool Gate Admission Fee 13,144.00 21,545.48 25,595.00 - (3,595.00) 116.34 000-454300 Seasonal Pool Pass Fee 190.00 6,730.00 6,885.00 - (2,885.00) 172.13 000-456110 Senior Center Memberships 5,058.00 - 23,718.00 - (23,718.00) - 000-456120 Senior Center Meal Fee 5,311.14 28,205.41 23,797.26 - (3,797.26) 118.99 000-456500 HAZ MAT Fees - - - - 5,000.00 - 000-456600 Fire Re-inspection Fee 50.00 300.00 100.00 - 650.00 13.33 000-458000 Sale of General Fixed Assets - - 37,572.00 - (37,572.00) - 000-458100 Sale of Merchandise - 90.00 - - - - 000-458110 Sale of Mdse - GovDeals 15,536.00 126,932.59 19,910.27 - 80,089.73 19.91 000-458400 Civic Center Rental Fees 107,129.99 42,904.48 315,026.49 - (175,026.49) 225.02 000-458401 Capital Recovery Fee-Civic C 2,925.00 7,775.00 4,375.00 - (4,375.00) - 000-458402 Civic Center Ancillary Fees 1,100.00 210.00 2,115.00 - (2,115.00) - 000-458450 North Center Rental Fees 11,837.50 26,093.75 40,587.50 - (22,587.50) 225.49 000-458460 Senior Center Rental 2,800.00 - 4,200.00 - 2,800.00 60.00 000-458500 Community Center Rental Fees 12,810.75 32,505.25 53,370.00 - (28,370.00) 213.48 000-458501 Community Center Service Fees 250.00 500.00 900.00 - (900.00) - 000-458510 Grand Ballroom Rental Fees - 51,501.25 (30,693.75) - 30,693.75 - 000-458520 Cut-Off Hall Rental Fees - 8,016.25 600.00 - (600.00) - 000-458530 Conference Hall Rental Fees - 506.25 - - - - 000-458540 Bluebonnet Hall Rental Fees (400.00) 19,973.75 (3,137.50) - 3,137.50 - 000-458550 Pavilion Rental Fees 7,910.00 24,307.50 26,775.00 - (6,775.00) 133.88 000-458551 Equipment Rentals-Parks - - 40.00 - (40.00) - 000-458560 Chamber of Comm Rent - 7,800.00 5,850.00 - 1,950.00 75.00 101 GENERAL FUND CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 000-458570 Non-Resident SYSA League - 9,160.00 7,500.00 - 2,500.00 75.00 000-458580 HOA Meeting Rental Fees - 825.00 - - - - 000-458581 Funeral Reception Rental Fees - 675.00 - - - - 000-458582 Quality of Life Rental Fees - 6,150.00 - - - - 000-458590 Cancellation Fees-Event Rental 650.00 1,600.00 2,150.00 - (2,150.00) - 000-458650 NonResident User Fee-BVYA 1,000.00 12,600.00 8,240.00 - 1,760.00 82.40 000-458660 BVYA Utility Reimbursement 3,648.31 18,338.38 10,134.02 - 4,865.98 67.56 000-458670 SYSA Utility Reimbursement 1,834.64 5,863.38 8,486.12 - (986.12) 113.15 000-458675 Lions Futbol Utility Reimbrsmt 12,032.00 22,580.00 15,548.00 - (548.00) 103.65 000-458685 Recreation Programs - 2,431.00 (25.00) - 1,025.00 (2.50) 000-458685.001Rec Prgrm-Kickball Leagues 2,900.00 7,105.00 7,305.00 - (4,705.00) 280.96 000-458700 Vehicle Impoundment 3,140.00 11,580.00 13,070.00 - (2,070.00) 118.82 000-459200 NSF Check Fee - - - - 100.00 - 000-459300 Notary Fee 18.00 84.00 60.00 - (12.00) 125.00 000-459600 Animal Adoption Fee 3,420.00 10,955.00 11,305.00 - (2,305.00) 125.61 000-459700 Pet Impoundment Fee 2,969.00 9,436.00 11,870.00 - (4,870.00) 169.57 000-459800 Police Reports Fee 1,302.00 6,924.03 5,613.39 - (613.39) 112.27 TOTAL Fees 597,127.59 1,975,216.45 2,255,861.12 - (23,402.12) 101.05% Fines 000-463000 Library Fines 2,691.92 8,476.81 10,590.29 - (1,590.29) 117.67 TOTAL Fines 2,691.92 8,476.81 10,590.29 - (1,590.29) 117.67% Inter-Jurisdictional 000-473100 Bexar Co - Fire - 35,129.60 7,025.92 - 14,051.08 33.33 000-473200 City of Seguin-Fire Contract 11,151.04 33,453.12 30,665.36 - (558.36) 101.85 000-473300 Guadalupe Co-Library 54,288.00 203,191.00 217,152.00 - (152.00) 100.07 000-474200 Library Services-Cibolo - 40,000.00 40,000.00 - - 100.00 000-474210 Library Services-Selma - 25,020.00 24,825.00 - 1,175.00 95.48 000-474400 Dispatch Service-Cibolo 80,000.00 83,000.00 243,000.00 - (83,000.00) 151.88 000-474600 School Crossing Guard-Bexar Co 15,418.43 41,211.79 41,882.08 - (5,882.08) 116.34 000-474610 School Cross Guard-Guadalupe C 12,980.82 47,822.13 48,098.23 - (7,098.23) 117.31 000-474620 School Crossing Guards - Comal - 1,812.57 14,571.25 - (12,671.25) 766.91 000-474700 School Officer Funding 91,878.00 363,708.00 275,634.00 - 91,880.00 75.00 101 GENERAL FUND CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 000-474750 Crime Victim Liaison Agreement 12,500.00 25,000.00 18,750.00 - 31,250.00 37.50 TOTAL Inter-Jurisdictional 278,216.29 899,348.21 961,603.84 - 28,994.16 97.07% Fund Transfers 000-480000 Indirect Costs-EMS 53,184.99 182,682.00 212,740.00 - - 100.00 000-480100 Indirect Costs-Hotel/Motel 18,610.74 72,464.08 74,443.00 - - 100.00 000-481000 Transfer In - Reserves - - - - 2,289,008.00 - 000-485000 Interfund Charges-Drainage-5%77,002.50 285,506.04 308,010.00 - - 100.00 000-486000 Interfund Chrges-Admin W&S 369,557.49 1,450,826.96 1,478,230.00 - - 100.00 000-486202 Transfer In-Water&Sewer Fund - - - - 4,000.00 - 000-486203 Transfer In-EMS - - - - 4,000.00 - 000-486204 Transfer In-Drainage - - - - 1,000.00 - 000-487000 Interfund Charges-Fleet 126,377.25 397,666.12 505,509.00 - - 100.00 000-488000 Interfund Charges-4B - 504,669.00 506,984.00 - - 100.00 000-489000 Transfer In - - - - 203,706.00 - TOTAL Fund Transfers 644,732.97 2,893,814.20 3,085,916.00 - 2,526,714.00 54.98% Miscellaneous 000-491000 Interest Earned 10,818.81 7,535.51 16,673.60 - (1,673.60) 111.16 000-491200 Investment Income 92,361.17 52,592.22 157,925.98 - (37,925.98) 131.60 000-491900 Unrealized Gain/Loss-CapOne (26,748.90) (30,999.21) (83,863.57) - 83,863.57 - 000-493000 Donations-Others - 500.00 - - - - 000-493120 Donations-Public Library 525.03 1,797.75 1,563.30 - 8,436.70 15.63 000-493400 Donations-Animal Control 1,643.90 2,905.00 4,786.90 - 213.10 95.74 000-493460 Donations- Parks - - - - 10,000.00 - 000-493465 Donations-Senior Center 1,104.00 1,710.50 4,874.33 - 5,125.67 48.74 000-493503 Donation-Fire Rescue 625.00 800.00 625.00 - 375.00 62.50 000-493618 Donation - Veteran's Memorial 300.00 2,100.00 2,930.00 - (1,680.00) 234.40 000-493700 July 4th Activities 567.00 27,721.00 28,417.00 - (2,417.00) 109.30 000-493701 Proceeds-Holidazzle 40.00 3,290.00 21,640.00 - (9,140.00) 173.12 000-493704 Moving on Main - 9,950.00 8,700.00 - (4,700.00) 217.50 000-493707 Cornhole League 1,230.00 2,260.00 1,230.00 - (1,230.00) - 000-494481 LawEnforcemtOfficersStnd&- 4,489.49 4,151.77 - 848.23 83.04 000-494482 Grants-Police, Fire, Gen Fund - 541.11 - - 12,500.00 - 101 GENERAL FUND CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 000-495100 Mobile Stage Rental Fees - - 3,600.00 - (3,600.00) - 000-497000 Misc Income-Gen Fund 33,752.90 176,673.95 74,077.98 - (24,077.98) 148.16 000-497005 Schertz Magazine Advertising 36,500.00 155,536.62 142,893.12 - (2,893.12) 102.07 000-497100 Misc Income-Police 3,139.25 15,738.14 9,553.30 - (553.30) 106.15 000-497200 Misc Income-Library 1,281.50 4,784.65 4,060.45 - (1,060.45) 135.35 000-497210 Misc Income-Library Copier 3,824.50 9,021.45 14,309.67 - 690.33 95.40 000-497300 Misc Income-Animal Control 90.00 720.50 420.00 - 380.00 52.50 000-497400 Misc Income-Streets Dept 7,533.64 13,206.86 33,953.91 - 16,046.09 67.91 000-497460 Misc Income-Parks - 288.00 74.60 - (74.60) - 000-497500 Misc Income-TML Ins. Claims 15,573.12 62,833.69 23,065.18 - 1,934.82 92.26 000-497550 Misc Income-TML WC Reimbursmnt 8,961.96 45,649.00 58,164.18 - (48,164.18) 581.64 000-497600 Misc Income-Vending Mach 1,441.57 800.48 2,406.85 - 93.15 96.27 000-497610 Misc Income-Muni Court 2.40 0.01 4.20 - (4.20) - 000-498000 Reimbursmnt-Gen Fund - - - - 20,000.00 - 000-498105 Reimbursmt Police OT-DEA 5,021.23 38,500.77 27,538.71 - 7,461.29 78.68 000-498110 Reimburmnt Fire-Emg Acti-OT 27,032.90 88,294.49 473,242.18 - 176,757.82 72.81 000-498150 Reimbursement - Library 8,094.24 19,824.24 8,094.24 - 4,905.76 62.26 TOTAL Miscellaneous 234,715.22 719,516.22 1,053,112.99 - 202,937.01 83.84% TOTAL REVENUES 6,446,837.78 37,610,554.69 40,861,214.53 - 1,366,792.47 96.76% Cash in Bank Claim on Operating Cash Pool-Checking 575,879.91$ Cash in Investments LOGIC Investment-General Fund 10,999,445.07 LOGIC Investment-Equip Replacement 79,723.87 LOGIC Investment-Veh Replacement 537,560.69 LOGIC Investment-Air Condi Replacment 292,544.71 CAPITAL ONE Investment-General Fund 1,395,756.44 CD - Bank of New York 251,953.21 CD - Capital One MCLEAN 252,281.34 CD - Capital One ALLEN 252,281.34 CD - Goldman Sachs 252,281.34 Total Cash in Bank & Investments 14,889,707.92$ GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 Updated report at 5/12/2020 by Maya AS OF: March 31, 2020 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2021-22 1,004,614 1,103,814 826,933 926,859 1,104,306 840,622 803,436 1,090,848 969,440 953,702 1,215,909 1,063,576 2020-21 743,235 894,399 769,523 766,917 1,051,843 776,582 652,217 1,039,235 878,852 881,389 1,342,856 917,603 2019-20 669,061 809,661 729,135 656,810 908,377 953,913 662,240 840,330 708,822 765,963 880,492 847,850 2018-19 766,254 736,285 627,360 571,251 769,881 603,905 647,650 699,759 950,507 681,755 769,754 487,275 2017-18 644,584 686,048 615,170 627,981 744,714 583,818 673,567 750,755 640,283 840,254 795,116 634,780 1,004,614 1,103,814 826,933 926,859 1,104,306 840,622 803,436 1,090,848 969,440 953,702 1,215,909 1,063,576 - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 Sales Tax-General Fund AS OF: March 31, 2020 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2021-22 64,306 790,610 7,588,294 4,069,380 2,505,204 168,170 49,143 82,010 177,339 32,660 40,812 21,138 2020-21 67,176 970,388 6,869,022 3,995,189 2,086,758 244,347 76,381 71,700 174,542 42,752 33,745 130,219 2019-20 181,122 806,033 6,755,473 4,432,940 1,463,522 101,212 72,046 56,463 88,055 48,550 20,479 76,361 2018-19 255,207 587,379 5,347,223 5,289,147 160,362 85,307 60,277 71,690 56,808 39,643 25,332 23,338 2017-18 100,310 505,909 5,577,660 3,375,990 1,936,953 117,684 82,856 52,620 21,817 16,745 47,029 14,080 - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 ADVALOREM TAX Updated report at 5/12/2020 by Maya AS OF: March 31, 2020 NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2021-22 304,524 241,989 261,111 258,456 2020-21 233,351 231,254 273,749 297,978 2019-20 240,156 192,246 261,394 286,756 2018-19 270,225 203,885 199,326 263,032 2017-18 271,335 208,803 213,511 283,058 $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 CITY PUBLIC SERVICE 2021-22 2020-21 2019-20 2018-19 2017-18 C I T Y O F S C H E R T Z 106-SPECIAL EVENTS FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Miscellaneous 24,000.00 (2,451.50) 31,792.85 47,588.58 - (23,588.58) 198.29 TOTAL REVENUES 24,000.00 (2,598.22) 30,321.34 47,441.86 - (23,441.86) 197.67% EXPENDITURE SUMMARY GENERAL GOVERNMENT CULTURAL KICK CANCER 10,000.00 - 4,283.74 9,848.94 - 151.06 98.49 HAL BALDWIN SCHOLARSHIP 14,000.00 12.40 16,631.75 19,719.28 - (5,719.28) 140.85 TOTAL CULTURAL 24,000.00 12.40 20,915.49 29,568.22 - (5,568.22) 123.20% TOTAL EXPENDITURES 24,000.00 12.40 20,915.49 29,568.22 - (5,568.22) 123.20% REVENUE OVER(UNDER) EXPEND 0.00 (2,610.62) 9,405.85 17,873.64 - (17,873.64) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 C I T Y O F S C H E R T Z 106-SPECIAL EVENTS FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Miscellaneous 000-491200 Investment Income - 100.50 17.85 147.24 - (147.24) - 000-492200 Kick Cancer 10,000.00 - 2,795.00 9,595.00 - 405.00 95.95 000-493621 Hal Baldwin Scholarship 14,000.00 2,220.00 28,980.00 37,846.34 - (23,846.34) 270.33 000-497000 Misc Income - Special Events - (4,772.00) - - - - - TOTAL Miscellaneous 24,000.00 (2,451.50) 31,792.85 47,588.58 - (23,588.58) 198.29% TOTAL REVENUES 24,000.00 (2,451.50) 31,792.85 47,588.58 - (23,588.58) 198.29% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 C I T Y O F S C H E R T Z Cash in Bank Current Claim on Operating Cash Pool-Checking 120,524.91$ Cash in Investments Texas Class- Special Events 18,195.54 Total Cash in Bank & Investments 138,720.45$ SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 110-PEG FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Franchises 110,000.00 19,589.91 78,746.02 79,402.59 - 30,597.41 72.18 Fund Transfers 757,521.00 - - - - 757,521.00 - TOTAL REVENUES 867,521.00 19,589.91 78,746.02 79,402.59 - 788,118.41 9.15% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental MISC & PROJECTS Projects Capital Outlay 517,521.00 162,751.41 - 162,751.41 461,590.96 (106,821.37) 120.64 TOTAL MISC & PROJECTS 867,521.00 162,751.41 - 162,751.41 461,590.96 243,178.63 71.97% TOTAL EXPENDITURES 867,521.00 162,751.41 - 162,751.41 461,590.96 243,178.63 71.97% REVENUE OVER(UNDER) EXPEND - (143,161.50) 78,746.02 (83,348.82) (461,590.96) 544,939.78 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 110-PEG FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Franchises 000-421350 Time Warner - PEG Fee 60,000.00 15,700.04 46,223.62 62,326.97 - (2,326.97) 103.88 000-421465 AT&T PEG Fee 50,000.00 3,889.87 32,522.40 17,075.62 - 32,924.38 34.15 TOTAL Franchises 110,000.00 19,589.91 78,746.02 79,402.59 - 30,597.41 72.18% Fund Transfers 000-481000 Transfer In - Reserves 757,521.00 - - - - 757,521.00 - TOTAL Fund Transfers 757,521.00 - - - - 757,521.00 0.00% Miscellaneous TOTAL REVENUES 867,521.00 19,589.91 78,746.02 79,402.59 - 788,118.41 9.15% AS OF: September 30, 2022 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) Cash in Bank Cash Balance 869,564.08$ Total Cash in Bank & Investments 869,564.08$ PEG FUND CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 202-WATER & SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Franchises 304,487.00 - 296,913.42 360,419.37 - (55,932.37) 118.37 Fees 27,485,000.00 8,343,105.45 25,922,940.14 28,981,667.20 - (1,496,667.20) 105.45 Fund Transfers 526,000.00 322,500.00 171,403.98 435,000.36 - 90,999.64 82.70 Miscellaneous 443,236.00 5,078,197.32 5,616,905.65 5,395,927.32 - (4,952,691.32) 1,217.39 TOTAL REVENUES 28,758,723.00 13,743,802.77 32,008,163.19 35,173,014.25 - (6,414,291.25) 122.30% EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers - - 2,405,229.94 - - - - TOTAL NON DEPARTMENTAL - - 2,405,229.94 - - - 0.00% BUSINESS OFFICE Personnel Services 547,378.00 119,822.42 504,675.10 507,906.41 - 39,471.59 92.79 Supplies 185,100.00 21,037.04 146,983.89 149,748.25 239.60 35,112.15 81.03 City Support Services 68,500.00 - 33,151.19 37,261.69 - 31,238.31 54.40 Utility Services 9,400.00 3,969.43 10,787.23 11,332.76 - (1,932.76) 120.56 Operations Support 102,500.00 39,131.70 112,211.87 120,360.03 - (17,860.03) 117.42 Staff Support 6,400.00 2,216.33 3,229.71 5,322.96 - 1,077.04 83.17 Professional Services 259,000.00 115,046.41 272,853.06 311,462.09 - (52,462.09) 120.26 Maintenance Services 5,040.00 840.00 5,040.00 4,620.00 420.00 - 100.00 TOTAL BUSINESS OFFICE 1,247,318.00 302,063.33 1,088,932.05 1,148,014.19 704.10 98,599.71 92.10% W & S ADMINISTRATION Personnel Services 1,951,955.00 458,721.28 1,801,985.65 1,821,806.99 - 130,148.01 93.33 Supplies 65,000.00 31,516.28 78,926.18 44,285.45 7,242.22 13,472.33 79.27 City Support Services 170,500.00 619.18 68,257.70 72,617.33 30.17 97,852.50 42.61 Utility Services 3,583,200.00 1,238,390.56 3,773,667.22 3,890,451.71 - (307,251.71) 108.57 Operations Support 12,050.00 1,788.02 9,449.56 7,390.09 - 4,659.91 61.33 Staff Support 43,000.00 17,592.66 37,795.06 35,788.12 18.78 7,193.10 83.27 City Assistance 250.00 - 200.00 40.00 - 210.00 16.00 Professional Services 476,970.00 97,380.43 465,998.69 312,925.71 18,835.00 145,209.29 69.56 Fund Charges/Transfers 6,825,826.00 3,719,339.55 8,615,455.27 8,930,072.35 - (2,104,246.35) 130.83 Maintenance Services 9,216,040.00 3,624,794.43 10,195,252.74 10,994,259.83 77,204.34 (1,855,424.17) 120.13 Other Costs 38,500.00 10.48 39,999.99 36,615.93 - 1,884.07 95.11 Debt Service 1,518,553.00 379,598.44 2,072,272.75 1,661,696.94 - (143,143.94) 109.43 Other Financing Sources - - - 57,094.83 - (57,094.83) - Rental/Leasing 12,200.00 34,000.00 96,568.01 113,265.24 - (101,065.24) 928.40 Operating Equipment 9,000.00 4,917.13 6,949.79 8,200.91 - 799.09 91.12 Capital Outlay 181,000.00 (46,061.35) - - 655,127.78 (474,127.78) 361.95 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 202-WATER & SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 TOTAL PUBLIC WORKS 24,104,044.00 9,562,607.09 27,262,778.61 27,986,511.43 758,458.29 (4,640,925.72) 119.25% MISC & PROJECTS PROJECTS Professional Services - - - - 3,469.00 (3,469.00) - Fund Charges/Transfers - - - 5,000,000.00 - (5,000,000.00) - Maintenance Services - - - - 4,500.00 (4,500.00) - Rental/Leasing 570,000.00 (570,529.00) - - - 570,000.00 - TOTAL PROJECTS 570,000.00 (570,529.00) - 5,000,000.00 7,969.00 (4,437,969.00) 878.59% SEWER PROJECT TOTAL SEWER PROJECTS - - - - - - 0.00% TOTAL MISC & PROJECTS 570,000.00 (570,529.00) - 5,000,000.00 7,969.00 (4,437,969.00) 878.59% TOTAL EXPENDITURES 25,921,362.00 9,294,141.42 30,756,940.60 34,134,525.62 767,131.39 (8,980,295.01) 134.64% ** REVENUE OVER(UNDER)EXPENSES **2,837,361.00 4,449,661.35 1,251,222.59 1,038,488.63 (767,131.39) 2,566,003.76 202-WATER & SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Franchises 000-421490 Cell Tower Leasing 304,487.00 - 296,913.42 360,419.37 - (55,932.37) 118.37 TOTAL Franchises 304,487.00 - 296,913.42 360,419.37 - (55,932.37) 118.37% Permits TOTAL Permits - - - - - - 0.00% Fees 000-455200 Garbage Collection Fee 5,300,000.00 1,479,578.95 5,157,312.38 5,673,337.05 - (373,337.05) 107.04 000-455700 Recycle Fee Revenue 345,000.00 88,839.59 333,131.42 348,489.59 - (3,489.59) 101.01 000-455800 W&S Line Constructn Reimbur 25,000.00 500.00 26,565.35 11,541.00 - 13,459.00 46.16 000-457100 Sale of Water 12,600,000.00 4,272,878.48 11,566,510.25 13,249,624.06 - (649,624.06) 105.16 000-457110 Edwards Water Lease 40,000.00 - 26,700.00 - - 40,000.00 - 000-457120 Water Transfer Charge-Selma 30,000.00 - 13,881.72 - - 30,000.00 - 000-457200 Sale of Meters 120,000.00 61,759.35 95,185.18 116,855.13 - 3,144.87 97.38 000-457400 Sewer Charges 8,770,000.00 2,346,127.50 8,608,374.53 9,256,697.32 - (486,697.32) 105.55 000-457500 Water Penalties 250,000.00 92,696.58 52,254.31 322,373.05 - (72,373.05) 128.95 000-458110 Sale of Merchandise - GovDeals 2500.00 - 41,000.00 - - 2,500.00 - 000-459200 NSF Check Fee-Water&Sewer 2,500.00 725.00 2,025.00 2,750.00 - (250.00) 110.00 TOTAL Fees 27,485,000.00 8,343,105.45 25,922,940.14 28,981,667.20 - (1,496,667.20) 105.45% Fund Transfers 000-486000 Transfer In - Reserves 91,000.00 - - - - 91,000.00 - 000-486204 Interfnd Chrg-Drainage Billing 150,000.00 37,500.00 146,400.00 150,000.00 - - 100.00 000-486406 Transfer In - Pblc Imprvmnt - - 25,003.98 0.36 - (0.36) - TOTAL Fund Transfers 526,000.00 322,500.00 171,403.98 435,000.36 - 90,999.64 82.70% Miscellaneous 000-490000 Misc Charges 10,500.00 5,723.51 15,964.08 14,729.51 - (4,229.51) 140.28 000-491000 Interest Earned 20,000.00 8,761.27 8,478.81 20,570.55 - (570.55) 102.85 000-491200 Investment Income 90,000.00 34,795.04 30,912.25 75,302.89 - 14,697.11 83.67 000-495013 Capital Contribution-W&S - 4,940,032.20 5,243,819.50 4,940,032.20 - (4,940,032.20) - 000-497000 Misc Income-W&S 25,000.00 1,814.57 66,294.51 4,379.46 - 20,620.54 17.52 000-498110 Salary Reimb-SSLGC 297,736.00 87,070.73 251,436.50 340,912.86 - (43,176.86) 114.50 000-499100 Distribution-GSE Bond Set - - - (0.15) - 0.15 - TOTAL Miscellaneous 443,236.00 5,078,197.32 5,616,905.65 5,395,927.32 - (4,952,691.32) 1217.39% TOTAL REVENUES 28,758,723.00 13,743,802.77 32,008,163.19 35,173,014.25 - (6,414,291.25) 122.30% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 106,652.93$ Cash in Investments Lone Star Investment-Water&Sewer 6,747,465.13 Lone Star Investment-W&S Customer Deposits 320,223.79 Lone Star Investment-W&S Equip Replacement 192,533.63 Lone Star Investment-W&S Veh Replacement 278,132.29 Schertz Bank & Trust-Certificate of Deposit 1,174,984.58 8,713,339.42 Total Cash in Bank & Investments 8,819,992.35$ WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 203-EMS CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 6,545,489.60 2,066,097.78 7,164,149.68 7,780,594.93 - (1,235,105.33) 118.87 Inter-Jurisdictional 3,985,932.54 431,548.57 3,204,108.09 4,133,931.29 - (147,998.75) 103.71 Fund Transfers 1,088,672.00 - 409,605.84 - - 1,088,672.00 - Miscellaneous 174,500.00 19,952.89 115,705.02 81,240.47 - 93,259.53 46.56 TOTAL REVENUES 11,794,594.14 2,517,599.24 10,893,568.63 11,995,766.69 - (201,172.55) 101.71% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 5,576,958.00 1,506,095.94 5,087,531.17 6,037,318.66 - (460,360.66) 108.25 Supplies 410,550.00 147,819.81 356,297.09 459,668.93 35,403.34 (84,522.27) 120.59 City Support Services 138,000.00 5,904.00 71,113.29 81,609.59 - 56,390.41 59.14 Utility Services 106,000.00 70,733.47 130,472.90 186,756.59 - (80,756.59) 176.19 Operations Support 45,000.00 9,230.34 152,743.91 34,261.24 - 10,738.76 76.14 Staff Support 73,265.00 6,923.44 55,328.70 68,776.21 2,866.63 1,622.16 97.79 City Assistance 626,989.01 206,330.00 616,861.85 623,522.15 32.00 3,434.86 99.45 Professional Services 123,500.00 26,336.79 113,798.24 149,673.61 - (26,173.61) 121.19 Fund Charges/Transfers 2,663,735.60 768,387.61 3,272,624.93 2,890,318.17 - (226,582.57) 108.51 Maintenance Services 13,000.00 3,720.00 10,560.00 10,440.00 - 2,560.00 80.31 Debt Service 118,120.00 - 115,100.00 116,725.00 - 1,395.00 98.82 Rental/Leasing 150,000.00 - 65,118.05 145,102.65 - 4,897.35 96.74 Operating Equipment 115,298.00 10,332.81 74,513.10 34,473.69 8,612.37 72,211.94 37.37 Capital Outlay 1,575,678.00 10,451.00 - 820,107.66 317,293.27 438,277.07 72.18 TOTAL PUBLIC SAFETY 11,736,093.61 2,772,265.21 10,122,063.23 11,658,754.15 364,207.61 (286,868.15) 102.44% TOTAL EXPENDITURES 11,736,093.61 2,772,265.21 10,122,063.23 11,658,754.15 364,207.61 (286,868.15) 102.44% ** REVENUE OVER(UNDER) EXPENSES **58,500.53 (254,665.97) 771,505.40 337,012.54 (364,207.61) 85,695.60 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 203-EMS CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-456100 Ambulance/Mileage Transprt Fee 6,206,889.60 1,970,636.62 6,844,294.24 7,400,892.24 - (1,194,002.64) 119.24 000-456110 Passport Membership Fees 28,000.00 820.00 25,765.00 26,660.00 - 1,340.00 95.21 000-456120 EMT Class - Fees 137,500.00 53,200.00 134,600.00 170,975.00 - (33,475.00) 124.35 000-456122 CE Class - Fees 24,000.00 - 19,744.77 18,523.20 - 5,476.80 77.18 000-456130 Immunization Fees 3,000.00 38.71 2,148.89 2,266.16 - 733.84 75.54 000-456140 Billing Fees-External 26,000.00 6,710.57 20,156.54 23,383.14 - 2,616.86 89.94 000-456150 Standby Fees 30,000.00 11,649.90 39,825.85 53,638.60 - (23,638.60) 178.80 000-456155 Community Services Support 50,000.00 10,778.98 40,176.39 42,061.59 - 7,938.41 84.12 000-456160 MIH Services 40,000.00 12,263.00 37,413.00 42,145.00 - (2,145.00) 105.36 000-459200 NSF Check Fee 100.00 - 25.00 50.00 - 50.00 50.00 TOTAL Fees 6,545,489.60 2,066,097.78 7,164,149.68 7,780,594.93 - (1,235,105.33) 118.87% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 927,934.89 231,983.73 1,005,262.91 850,607.01 - 77,327.88 91.67 000-474200 JBSA Support 635,706.00 158,326.62 - 582,130.94 - 53,575.06 91.57 000-474300 Cibolo Support 529,043.95 - 473,115.24 529,043.96 - (0.01) 100.00 000-475100 Comal Co ESD #6 148,870.54 41,238.22 141,411.38 200,905.18 - (52,034.64) 134.95 000-475200 Live Oak Support 280,240.92 - 246,255.84 259,350.75 - 20,890.17 92.55 000-475300 Universal City Support 335,884.88 - 321,566.04 335,884.88 - - 100.00 000-475400 Selma Support 180,290.22 - 171,441.00 180,290.24 - (0.02) 100.00 000-475500 Schertz Support 695,644.24 - 667,048.68 695,644.24 - - 100.00 000-475600 Santa Clara Support 11,953.03 - 11,455.20 11,953.04 - (0.01) 100.00 000-475800 Marion Support 21,363.87 - 18,374.76 21,363.88 - (0.01) 100.00 000-475910 TASPP Program 219,000.00 - 148,177.04 466,757.17 - (247,757.17) 213.13 TOTAL Inter-Jurisdictional 3,985,932.54 431,548.57 3,204,108.09 4,133,931.29 - (147,998.75) 103.71% Fund Transfers - 000-486000 Transfer In-Reserves 755,172.00 - - - - 755,172.00 - TOTAL Fund Transfers 1,088,672.00 - - - - 1,088,672.00 0.00% Miscellaneous 000-491000 Interest Earned 2,500.00 796.78 489.15 1,163.96 - 1,336.04 46.56 000-491200 Investment Income 5,000.00 4,093.88 958.58 5,894.52 - (894.52) 117.89 000-493203 Donations-EMS 2,000.00 850.00 925.00 1,500.00 - 500.00 75.00 000-497000 Misc Income 75,000.00 1,604.00 48,218.15 28,161.99 - 46,838.01 37.55 000-497100 Recovery of Bad Debt 20,000.00 6,533.50 11,222.68 12,902.88 - 7,097.12 64.51 000-497110 Collection Agency-Bad Debt 70,000.00 6,074.73 53,891.46 31,617.12 - 38,382.88 45.17 TOTAL Miscellaneous 174,500.00 19,952.89 115,705.02 81,240.47 - 93,259.53 46.56% TOTAL REVENUES 11,794,594.14 2,517,599.24 10,483,962.79 11,995,766.69 - (201,172.55) 101.71% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 270,500.60$ Cash in Investments EMS-Logic 653,321.98 SR 2017 Ambulance-Logic - Total Cash in Bank & Investments 923,822.58$ C I T Y O F S C H E R T Z CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 204-DRAINAGE CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Permits 4,000.00 2,800.00 6,670.00 9,650.00 - (5,650.00) 241.25 Fees 1,260,000.00 317,463.57 1,211,192.42 1,258,898.99 - 1,101.01 99.91 Fund Transfers 17,229.00 17,229.00 - 17,229.00 - - 100.00 Miscellaneous 3,000.00 2,738.58 59,975.17 3,938.20 - (938.20) 131.27 TOTAL REVENUES 1,284,229.00 340,231.15 1,277,837.59 1,289,716.19 - (5,487.19) 100.43% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 456,920.00 81,564.01 379,236.66 338,693.94 - 118,226.06 74.13 Supplies 8,500.00 4,441.53 3,716.98 5,863.65 - 2,636.35 68.98 City Support Services 20,500.00 66.00 4,474.27 4,490.30 30.15 15,979.55 22.05 Utility Services 26,700.00 11,301.21 20,287.65 26,435.76 - 264.24 99.01 Operations Support 1,050.00 - 31.00 - - 1,050.00 - Staff Support 13,700.00 1,727.64 13,041.97 11,171.34 - 2,528.66 81.54 City Assistance 500.00 - 120.00 40.00 - 460.00 8.00 Professional Services 69,237.00 6,784.04 2,719.50 16,224.68 32,100.00 20,912.32 69.80 Fund Charges/Transfers 574,817.00 251,836.26 647,133.35 682,199.02 - (107,382.02) 118.68 Maintenance Services 83,000.00 2,654.58 10,727.83 9,763.59 - 73,236.41 11.76 Other Costs 100.00 - - 100.00 - - 100.00 Debt Service - - 121,740.46 - - - - Rental/Leasing 500.00 - - - - 500.00 - Operating Equipment 2,500.00 1,759.96 6,867.31 2,458.58 - 41.42 98.34 Capital Outlay 14,000.00 (13,903.04) - - - 14,000.00 - TOTAL DRAINAGE 1,272,024.00 348,232.19 1,210,096.98 1,097,440.86 32,130.15 142,452.99 88.80% PROJECTS Maintenance Services - (26,517.40) - - 7,980.95 (7,980.95) - TOTAL EXPENDITURES 1,272,024.00 321,714.79 1,210,096.98 1,097,440.86 40,111.10 134,472.04 89.43% ** REVENUE OVER(UNDER) EXPEND 12,205.00 18,516.36 67,740.61 192,275.33 (40,111.10) (139,959.23) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 204-DRAINAGE CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Permits 000-432400 Floodplain Permit 4,000.00 2,800.00 6,670.00 9,650.00 - (5,650.00) 241.25 TOTAL Permits 4,000.00 2,800.00 6,670.00 9,650.00 - (5,650.00) 241.25% Fees 000-457500 Drainage Penalties 10,000.00 2,612.11 1,539.52 9,880.78 - 119.22 98.81 000-457600 Drainage Fee 1,250,000.00 314,851.46 1,209,652.90 1,249,018.21 - 981.79 99.92 TOTAL Fees 1,260,000.00 317,463.57 1,211,192.42 1,258,898.99 - 1,101.01 99.91% Fund Transfers 000-486100 Transfer In 17,229.00 17,229.00 - 17,229.00 - - 100.00 TOTAL Funds Transfers 17,229.00 17,229.00 - 17,229.00 - - 100.00% Miscellaneous 000-491000 Interest Earned 1,000.00 541.37 82.25 710.43 - 289.57 71.04 000-491200 Investment Income 2,000.00 2,197.21 737.89 3,227.77 - (1,227.77) 161.39 000-497000 Misc Income-Drainage - - 59,155.03 - - - - TOTAL Miscellaneous 3,000.00 2,738.58 59,975.17 3,938.20 - (938.20) 131.27% TOTAL REVENUES 1,284,229.00 340,231.15 1,277,837.59 1,289,716.19 - (5,487.19) 100.43% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 254,422.03$ Cash in Investments Lone Star Investment-Drainage Maint Fund 384,450.12 Total Cash in Bank & Investments 638,872.15$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 314-HOTEL TAX CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Taxes 520,000.00 218,097.90 518,921.00 804,132.41 - (284,132.41) 154.64 Fund Transfers 1,150,000.00 - - - - 1,150,000.00 - Miscellaneous 5,250.00 8,798.98 2,094.91 14,582.47 - (9,332.47) 277.76 TOTAL REVENUES 1,675,250.00 226,896.88 521,015.91 818,714.88 - 856,535.12 48.87% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies - - 6,995.41 - - - - City Support Services 112,466.00 6,726.17 67,976.74 65,701.90 - 46,764.10 58.42 Operations Support 31,000.00 1,386.00 17,458.78 19,061.10 1,700.00 10,238.90 66.97 Professional Services 3,500.00 120.00 6,565.05 3,831.79 - (331.79) 109.48 Fund Charges/Transfers 74,443.00 18,610.74 72,464.08 74,443.00 - - 100.00 Maintenance Services 50,000.00 - 164,304.36 54,676.81 - (4,676.81) 109.35 Operating Equipment 44,888.00 - - 42,387.50 - 2,500.50 94.43 Capital Outlay 20,000.00 - - 28,200.00 - (8,200.00) 141.00 TOTAL NONDEPARTMENTAL 336,297.00 26,842.91 335,764.42 288,302.10 1,700.00 46,294.90 86.23% TOTAL GENERAL GOVERNMENT 336,297.00 26,842.91 335,764.42 288,302.10 1,700.00 46,294.90 86.23% MISC & PROJECTS PROJECTS Professional Services 93,500.00 5,031.54 - 57,214.83 394.89 35,890.28 61.61 Maintenance Services 1,150,000.00 170,814.20 - 1,128,295.01 22,458.51 (753.52) 100.07 TOTAL PROJECTS 1,243,500.00 175,845.74 - 1,185,509.84 22,853.40 35,136.76 97.17% TOTAL MISC & PROJECTS 1,243,500.00 175,845.74 - 1,185,509.84 22,853.40 35,136.76 97.17% TOTAL EXPENDITURES 1,579,797.00 202,688.65 335,764.42 1,473,811.94 24,553.40 81,431.66 94.85% REVENUE OVER(UNDER) EXPENDITURE 95,453.00 24,208.23 185,251.49 (655,097.06) (24,553.40) 775,103.46 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 52,193.86$ Cash in Investments Texas Class - Hotel Tax 1,579,388.35 Total Cash in Bank & Investments 1,631,582.21$ HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 AS OF: March 31, 2021 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2021-22 65,789 63,938 62,952 58,027 54,614 74,755 70,056 70,014 75,996 75,155 53,940 51,934 2020-21 22,147 18,567 19,948 23,467 28,556 45,098 48,675 51,329 39,397 70,910 62,432 24,529 2019-20 33,124 31,590 29,661 23,382 33,841 20,209 8,643 8,934 13,859 15,559 25,115 29,624 2018-19 44,431 43,858 40,307 38,034 41,886 55,316 44,285 43,642 36,501 44,160 34,532 36,619 2017-18 37,415 38,911 30,706 31,786 48,161 52,784 52,258 53,747 50,639 58,448 46,800 36,619 - 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 HOTEL OCCUPANCY TAX 317-PARK CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 318,000.00 - - - - 318,000.00 - Miscellaneous 1,025.00 1,451.69 293.52 2,194.71 - (1,169.71) 214.12 TOTAL REVENUES 319,025.00 1,451.69 293.52 2,194.71 - 316,830.29 0.69% EXPENDITURE SUMMARY NON DEPARTMENTAL PARKLAND DEDICATION Professional Services 25,000.00 10,040.00 4,500.00 10,040.00 - 14,960.00 40.16 Capital Outlay 100,000.00 - 1,011.61 17,650.02 - 82,349.98 17.65 TOTAL PARKLAND DEDICATION 125,000.00 10,040.00 5,511.61 27,690.02 - 97,309.98 22.15% TOTAL EXPENDITURES 125,000.00 10,040.00 5,511.61 27,690.02 - 97,309.98 22.15% REVENUE OVER(UNDER) EXPEND 194,025.00 (8,588.31) (5,218.09) (25,495.31) - 219,520.31 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 317-PARK CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-458800 Parkland Dedication 318,000.00 - - - - 318,000.00 - TOTAL Fees 318,000.00 - - - - 318,000.00 0.00% Fund Transfers TOTAL Fund Transfers - - - - - - 0.00% Miscellaneous 000-491000 Interest Earned 25.00 31.28 9.88 32.49 - (7.49) 129.96 000-491200 Investment Income 1,000.00 1,420.41 283.64 2,162.22 - (1,162.22) 216.22 TOTAL Miscellaneous 1,025.00 1,451.69 293.52 2,194.71 - (1,169.71) 214.12% TOTAL REVENUES 319,025.00 1,451.69 293.52 2,194.71 - 316,830.29 0.69% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Current Claim on Operating Cash Pool-Checking 15,751.38$ Cash in Investments Texas Class- Park Fund 248,320.67 Total Cash in Bank & Investments 264,072.05$ PARK FUND CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 319-TREE MITIGATION CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 70,000.00 73,000.00 219,512.50 136,950.00 - (66,950.00) 195.64 Miscellaneous 1,400.00 3,600.25 650.09 5,324.04 - (3,924.04) 380.29 TOTAL REVENUES 71,400.00 76,600.25 220,162.59 142,274.04 - (70,874.04) 199.26% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services 70,000.00 20,650.00 35,495.00 82,110.00 - (12,110.00) 117.30 TOTAL TREE MITIGATION 70,000.00 20,650.00 35,495.00 82,110.00 - (12,110.00) 117.30% TOTAL EXPENDITURES 70,000.00 20,650.00 35,495.00 82,110.00 - (12,110.00) 117.30% REVENUE OVER(UNDER) EXPEND 1,400.00 55,950.25 184,667.59 60,164.04 - (58,764.04) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 319-TREE MITIGATION CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-458900 Tree Mitigation 70,000.00 73,000.00 219,512.50 136,950.00 - (66,950.00) 195.64 TOTAL Fees 70,000.00 73,000.00 219,512.50 136,950.00 - (66,950.00) 195.64% Fund Transfers Miscellaneous 000-491000 Interest Earned 200.00 4.25 20.51 38.88 - 161.12 19.44 000-491200 Investment Income 1,200.00 3,596.00 629.58 5,285.16 - (4,085.16) 440.43 TOTAL Miscellaneous 1,400.00 3,600.25 650.09 5,324.04 - (3,924.04) 380.29% TOTAL REVENUES 71,400.00 76,600.25 220,162.59 142,274.04 - (70,874.04) 199.26% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking $71,296.46 Cash in Investments MBIA Investment-Tree Mitigation 651,137.79 Total Cash in Bank & Investments $722,434.25 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 411-CAPITAL RECOVERY WATER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 1,100,000.00 145,915.00 1,079,712.00 832,663.76 - 267,336.24 75.70 Miscellaneous 16,000.00 41,547.64 10,309.73 65,207.57 - (49,207.57) 407.55 TOTAL REVENUES 1,116,000.00 187,462.64 1,090,021.73 897,871.33 - 218,128.67 80.45% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 51,000.00 20,200.55 46,921.79 37,233.55 36,438.81 (22,672.36) 144.46 TOTAL NON DEPARTMENTAL 51,000.00 20,200.55 46,921.79 37,233.55 36,438.81 (22,672.36) 144.46% MISC & PROJECTS PROJECTS Fund Charges/Transfers 4,230,818.70 4,230,818.70 512,000.00 4,230,818.70 - - 100.00 TOTAL MISC & PROJECTS 4,230,818.70 4,230,818.70 512,000.00 4,230,818.70 - - 100.00% TOTAL EXPENDITURES 4,281,818.70 4,251,019.25 558,921.79 4,268,052.25 36,438.81 (22,672.36) 100.53% REVENUE OVER(UNDER) EXPENDITURES (3,165,818.70) (4,063,556.61) 531,099.94 (3,370,180.92) (36,438.81) 240,801.03 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 411-CAPITAL RECOVERY WATER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455900 Cap Rcvry-Water 1,100,000.00 145,915.00 1,079,712.00 832,663.76 - 267,336.24 75.70 TOTAL Fees 1,100,000.00 145,915.00 1,079,712.00 832,663.76 - 267,336.24 75.70% Fund Transfers Miscellaneous - 000-491000 Interest Earned 1,000.00 506.59 236.67 754.20 - 245.80 75.42 000-491200 Investment Income 15,000.00 41,041.05 10,073.06 64,453.37 - (49,453.37) 429.69 TOTAL Miscellaneous 16,000.00 41,547.64 10,309.73 65,207.57 - (49,207.57) 407.55% TOTAL REVENUES 1,116,000.00 187,462.64 1,090,021.73 897,871.33 - 218,128.67 80.45% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 263,477.06$ Cash in Investments Lone Star Investment-Capital Recovery Water 4,638,583.17 Total Cash in Bank & Investments 4,902,060.23$ CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 421-CAPITAL RECOVERY SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 600,000.00 81,662.72 611,658.56 371,261.32 - 228,738.68 61.88 Miscellaneous 60,250.00 37,260.61 9,864.81 59,886.70 - 363.30 99.40 TOTAL REVENUES 660,250.00 118,923.33 621,523.37 431,148.02 - 229,101.98 65.30% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 55,500.00 1,140.07 60,487.21 21,382.14 76,559.25 (42,441.39) 176.47 Fund Charges/Transfers - - 7,795,000.00 - - - - TOTAL NON DEPARTMENTAL 55,500.00 1,140.07 7,855,487.21 21,382.14 76,559.25 (42,441.39) 176.47% MISC & PROJECTS TOTAL EXPENDITURES 55,500.00 1,140.07 7,855,487.21 21,382.14 76,559.25 (42,441.39) 176.47% REVENUE OVER(UNDER) EXPENDITURES 604,750.00 117,783.26 (7,233,963.84) 409,765.88 (76,559.25) 271,543.37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 421-CAPITAL RECOVERY SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 Cap Rcvry-Waste Water 600,000.00 81,662.72 611,658.56 371,261.32 - 228,738.68 61.88 TOTAL Fees 600,000.00 81,662.72 611,658.56 371,261.32 - 228,738.68 61.88% Fund Transfers Miscellaneous 000-491000 Interest Earned 250.00 6,159.58 194.63 6,414.51 - (6,164.51) 2,565.80 000-491200 Investment Income 60,000.00 30,735.23 39,749.84 63,417.67 - (3,417.67) 105.70 000-491900 Unrealize Gain/Loss-Captl One - 365.80 (30,079.66) (9,945.48) - 9,945.48 - TOTAL Miscellaneous 60,250.00 37,260.61 9,864.81 59,886.70 - 363.30 99.40% TOTAL REVENUES 660,250.00 118,923.33 621,523.37 431,148.02 - 229,101.98 65.30% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 1,841,201.43$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 4,635,827.87 Capital One-Investment 1,839,606.80 Total Cash in Bank & Investments 8,316,636.10$ CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 431-ROADWAY IMPACT FEE AREA 1 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 200,000.00 80,822.35 211,937.24 252,871.82 - (52,871.82) 126.44 Miscellaneous 900.00 4,297.39 592.06 6,035.39 - (5,135.39) 670.60 TOTAL REVENUES 200,900.00 85,119.74 212,529.30 258,907.21 - (58,007.21) 128.87% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 - 1,979.00 1,358.50 - 3,641.50 27.17 TOTAL NON DEPARTMENTAL 5,000.00 - 1,979.00 1,358.50 - 3,641.50 27.17% TOTAL EXPENDITURES 93,173.00 - 1,979.00 1,358.50 88,172.99 3,641.51 96.09% REVENUE OVER(UNDER) EXPENDITURES 107,727.00 85,119.74 210,550.30 257,548.71 (88,172.99) (61,648.72) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 431-ROADWAY IMPACT FEE AREA 1 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 CapitalRcvry-RoadwaysSrvAre 200,000.00 80,822.35 211,937.24 252,871.82 - (52,871.82) 126.44 TOTAL Fees 200,000.00 80,822.35 211,937.24 252,871.82 - (52,871.82) 126.44% Fund Transfers Miscellaneous 000-491000 Interest Earned 300.00 6.75 195.26 32.80 - 267.20 10.93 000-491200 Investment Income 600.00 4,290.64 396.80 6,002.59 - (5,402.59) 1,000.43 TOTAL Miscellaneous 900.00 4,297.39 592.06 6,035.39 - (5,135.39) 670.60% TOTAL REVENUES 200,900.00 85,119.74 212,529.30 258,907.21 - (58,007.21) 128.87% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 971.54$ Cash in Investments Lone Star Investment-Cap Rec Streets 1 804,999.39 Total Cash in Bank & Investments 805,970.93$ ROADWAY IMPACT FEE AREA 1 CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 432-ROADWAY IMPACT FEE AREA 2 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 120,000.00 53,381.58 163,822.90 341,649.60 - (221,649.60) 284.71 Miscellaneous 400.00 2,991.09 248.54 4,087.07 - (3,687.07) 1,021.77 TOTAL REVENUES 120,400.00 56,372.67 164,071.44 345,736.67 - (225,336.67) 287.16% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL City Assistance 24,000.00 - 39,148.36 49,146.87 - (25,146.87) 204.78 Professional Services 5,000.00 - - 3,337.50 - 1,662.50 66.75 TOTAL NON DEPARTMENTAL 29,000.00 - 39,148.36 52,484.37 - (23,484.37) 180.98% TOTAL EXPENDITURES 29,000.00 - 39,148.36 52,484.37 - (23,484.37) 180.98% REVENUE OVER(UNDER) EXPENDITURES 91,400.00 56,372.67 124,923.08 293,252.30 - (201,852.30) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 432-ROADWAY IMPACT FEE AREA 2 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 CapitalRcvry-RoadwaysSrvAre 120,000.00 53,381.58 163,822.90 341,649.60 - (221,649.60) 284.71 TOTAL Fees 120,000.00 53,381.58 163,822.90 341,649.60 - (221,649.60) 284.71% Fund Transfers Miscellaneous 000-491000 Interest Earned 200.00 22.16 89.44 52.25 - 147.75 26.13 000-491200 Investment Income 200.00 2,968.93 159.10 4,034.82 - (3,834.82) 2,017.41 TOTAL Miscellaneous 400.00 2,991.09 248.54 4,087.07 - (3,687.07) 1021.77% TOTAL REVENUES 120,400.00 56,372.67 164,071.44 345,736.67 - (225,336.67) 287.16% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 15,243.83$ Cash in Investments Lone Star Investment-Cap Rec Streets 2 548,783.92 Total Cash in Bank & Investments 564,027.75$ ROADWAY IMPACT FEE AREA 2 CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 433-ROADWAY IMPACT FEE AREA 3 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 400,000.00 30,330.00 523,919.20 204,433.00 - 195,567.00 51.11 Miscellaneous 1,500.00 6,643.71 976.68 9,675.43 - (8,175.43) 645.03 TOTAL REVENUES 401,500.00 36,973.71 524,895.88 214,108.43 - 187,391.57 53.33% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 - - 3,337.50 - 1,662.50 66.75 TOTAL NON DEPARTMENTAL 5,000.00 - - 3,337.50 - 1,662.50 66.75% TOTAL EXPENDITURES 5,000.00 - - 3,337.50 - 1,662.50 66.75% REVENUE OVER(UNDER) EXPENDITURES 396,500.00 36,973.71 524,895.88 210,770.93 - 185,729.07 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 433-ROADWAY IMPACT FEE AREA 3 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 CapitalRcvry-RoadwaysSrvAre 400,000.00 30,330.00 523,919.20 204,433.00 - 195,567.00 51.11 TOTAL Fees 400,000.00 30,330.00 523,919.20 204,433.00 - 195,567.00 51.11% Fund Transfers Miscellaneous 000-491000 Interest Earned 900.00 16.38 441.94 30.59 - 869.41 3.40 000-491200 Investment Income 600.00 6,627.33 534.74 9,644.84 - (9,044.84) 1,607.47 TOTAL Miscellaneous 1,500.00 6,643.71 976.68 9,675.43 - (8,175.43) 645.03% TOTAL REVENUES 401,500.00 36,973.71 524,895.88 214,108.43 - 187,391.57 53.33% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 471.66$ Cash in Investments Lone Star Investment-Cap Rec Streets 3 1,182,829.58 Total Cash in Bank & Investments 1,183,301.24$ ROADWAY IMPACT FEE AREA 3 CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 434-ROADWAY IMPACT FEE AREA 4 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 5,000.00 - 3,033.00 - - 5,000.00 - Miscellaneous 65.00 56.05 9.01 79.23 - (14.23) 121.89 TOTAL REVENUES 5,065.00 56.05 3,042.01 79.23 - 4,985.77 1.56% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 - - 3,337.50 - 1,662.50 66.75 TOTAL NON DEPARTMENTAL 5,000.00 - - 3,337.50 - 1,662.50 66.75% TOTAL EXPENDITURES 5,000.00 - - 3,337.50 - 1,662.50 66.75% REVENUE OVER(UNDER) EXPENDITURES 65.00 56.05 3,042.01 (3,258.27) - 3,323.27 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 434-ROADWAY IMPACT FEE AREA 4 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 CapitalRcvry-RoadwaysSrvAre 5,000.00 - 3,033.00 - - 5,000.00 - TOTAL Fees 5,000.00 - 3,033.00 - - 5,000.00 0.00% Fund Transfers Miscellaneous 000-491000 Interest Earned 15.00 1.46 3.10 2.76 - 12.24 18.40 000-491200 Investment Income 50.00 54.59 5.91 76.47 - (26.47) 152.94 TOTAL Miscellaneous 65.00 56.05 9.01 79.23 - (14.23) 121.89% TOTAL REVENUES 5,065.00 56.05 3,042.01 79.23 - 4,985.77 1.56% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking (3,499.19)$ Cash in Investments Lone Star Investment-Cap Rec Streets 4 9,552.38 Total Cash in Bank & Investments 6,053.19$ ROADWAY IMPACT FEE AREA 4 CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022 505-TAX I&S CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Taxes 7,329,862.00 60,024.96 7,102,016.32 7,182,899.57 - 146,962.43 98.00 Fund Transfers - - 7,914.84 2,737.08 - (2,737.08) - Miscellaneous 105,000.00 35,705.16 126,591.97 224,043.58 - (119,043.58) 213.37 TOTAL REVENUES 7,434,862.00 95,730.12 7,236,523.13 7,409,680.23 - 25,181.77 99.66% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 50,000.00 1,800.00 178,599.52 48,493.39 - 1,506.61 96.99 Debt Service 6,626,915.00 1,104,408.73 6,756,465.33 6,584,154.87 - 42,760.13 99.35 TOTAL GENERAL GOVERNMENT 6,676,915.00 1,106,208.73 6,935,064.85 6,632,648.26 - 44,266.74 99.34% TOTAL EXPENDITURES 6,676,915.00 1,106,208.73 6,935,064.85 6,632,648.26 - 44,266.74 99.34% ** REVENUE OVER(UNDER) EXPEND 757,947.00 (1,010,478.61) 301,458.28 777,031.97 - (19,084.97) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30 , 2022 505-TAX I & S CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Taxes 000-411900 Property Tax Revenue 7,329,862.00 60,024.96 7,102,016.32 7,182,899.57 - 146,962.43 98.00 TOTAL Taxes 7,329,862.00 60,024.96 7,102,016.32 7,182,899.57 - 146,962.43 98.00% Fund Transfers 000-486100 Transfer In - - 6,584.65 - - - - 000-486401 Transfer In -Bond Project Fund - - 1,330.19 2,737.08 - (2,737.08) - TOTAL Fund Transfers - - 7,914.84 2,737.08 - (2,737.08) 0.00% Miscellaneous 000-491000 Interest Earned 1,000.00 72.81 277.20 363.39 - 636.61 36.34 000-491200 Investment Income 4,000.00 10,632.35 1,314.77 143,062.44 - (139,062.44) 3,576.56 000-495020 Contribution From YMCA 100,000.00 25,000.00 125,000.00 75,000.00 - 25,000.00 75.00 000-498000 Proceeds From Refunding Debt - - - 5,617.75 - (5,617.75) - TOTAL Miscellaneous 105,000.00 35,705.16 126,591.97 224,043.58 - (119,043.58) 213.37% TOTAL REVENUES 7,434,862.00 95,730.12 7,236,523.13 7,409,680.23 - 25,181.77 99.66% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30 , 2022 505-TAX I & S GENERAL GOVERNMENT CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET NON DEPARTMENTAL Professional Services 101-541500 Paying Agent 5,000.00 1,800.00 3,800.00 3,800.00 - 1,200.00 76.00 101-541502 Cost of Bond Issuance 45,000.00 - 174,799.52 44,693.39 - 306.61 99.32 TOTAL Professional Services 50,000.00 1,800.00 178,599.52 48,493.39 - 1,506.61 96.99% Debt Service 101-555629 Bond-GO 2007 Principal 340000.00 - 325,000.00 340,000.00 - - 100.00 101-555629.1 Bond-GO 2007 Interest 85267.00 39,058.43 98,578.79 85,151.18 - 115.82 99.86 101-555635 Bond-GO 2012 - Principal 375,000.00 - 365,000.00 375,000.00 - - 100.00 101-555635.1 Bond-GO 2012 - Interest 128,677.00 - 138,370.00 4,218.75 - 124,458.25 3.28 101-555638 Bond-GO 2014 Refund-Principal 750,000.00 - 100,000.00 750,000.00 - - 100.00 101-555638.1 Bond-GO 2014 Refund-Interest 268,025.00 128,387.50 280,775.00 268,025.00 - - 100.00 101-555640.1 Bond-GO Ref 2015-Interest 37,050.00 18,525.00 47,400.00 37,050.00 - - 100.00 101-555641 Tax Note - SR2015A-Principal 155,000.00 154,999.99 150,000.00 154,999.99 - 0.01 100.00 101-555641.1 Tax Note - SR2015A - Interest 2,387.00 1,193.50 4,697.00 2,387.00 - - 100.00 101-555642 Bond-GO SR2016-Principal 245,000.00 - 235,000.00 245,000.00 - - 100.00 101-555642.1 Bond-GO SR2016-Interest 131,607.00 63,353.13 141,206.26 131,606.26 - 0.74 100.00 101-555643 Bond-TaxableB CO SR2016-Princi 60,000.00 - 60,000.00 60,000.00 - - 100.00 101-555643.1 Bond-Taxable CO SR2016-Interes 40,263.00 19,681.25 42,062.50 40,262.50 - 0.50 100.00 101-555644 Bond-NonTaxA CO SR2016-Princip 195,000.00 - 190,000.00 195,000.00 - - 100.00 101-555644.1 Bond-NonTax CO SR2016-Interest 40,469.00 18,284.38 48,168.76 40,468.76 - 0.24 100.00 101-555645 Bond-CO SR2017-Principal 420,000.00 - 295,000.00 305,000.00 - 115,000.00 72.62 101-555645.1 Bond-CO SR2017 - Interest 114,425.00 54,062.50 121,700.00 112,700.00 - 1,725.00 98.49 101-555646 Bond-GO SR2017 - Principal 165,000.00 - 160,000.00 165,000.00 - - 100.00 101-555646.1 Bond-GO SR2017 - Interest 100,050.00 48,787.50 104,925.00 100,050.00 - - 100.00 101-555647 Bond-GO 2018 Refund- Principal 585,000.00 - 570,000.00 585,000.00 - - 100.00 101-555647.1 Bond-GO 2018 Refund - Interest 86,125.00 39,962.00 98,368.00 86,125.00 - - 100.00 101-555648 Bond-CO SR2018 - Principal 245,000.00 - 235,000.00 245,000.00 - - 100.00 101-555648.1 Bond-CO 2018 - Interest 163,888.00 78,881.25 175,887.50 163,887.50 - 0.50 100.00 101-555649 Bond-GO 2018 Ref - Principal 185,000.00 - 530,000.00 185,000.00 - - 100.00 101-555649.1 Bond-GO 2018 Ref - Interest 181,819.00 88,596.88 199,693.76 181,818.76 - 0.24 100.00 101-555650 Bond-CO 2019-Principal 265,000.00 - 255,000.00 265,000.00 - - 100.00 101-555650.1 Bond-CO 2019-Interest 114,900.00 55,462.50 122,700.00 114,900.00 - - 100.00 101-555651 Bond-GO 2020-Principal 935,000.00 - - 935,000.00 - - 100.00 101-555651.1 Bond-GO 2020-Interest 211,963.00 96,631.25 164,026.67 211,962.50 - 0.50 100.00 101-555652.1 Bond-GO 2021 Ref - Interest - 98,850.00 - 98,850.00 - (98,850.00) - 101-555653.1 Bond-CO 2022 - Interest - 99,691.67 - 99,691.67 - (99,691.67) - TOTAL Debt Service 6,626,915.00 1,104,408.73 6,756,465.33 6,584,154.87 - 42,760.13 99.35% Other Financing Sources TOTAL EXPENDITURES 6,676,915.00 1,106,208.73 6,935,064.85 6,632,648.26 - 44,266.74 99.34% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30 , 2022 Cash in Bank Claim on Operating Cash Pool-Checking 125,804.33$ MBIA Investment- Tax I&S 1,738,604.31 Total Cash in Bank & Investments 1,864,408.64$ TAX I&S CASH IN BANK AND INVESTMENTS AS OF: September 30 , 2022 620-SED CORPORATION CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Taxes 5,408,000.00 1,640,405.68 5,615,928.48 6,025,703.00 - (617,703.00) 111.42 Fund Transfers 1,240,000.00 - - - - 1,240,000.00 - Miscellaneous 141,000.00 128,470.28 56,144.20 201,279.17 - (60,279.17) 142.75 TOTAL REVENUES 6,789,000.00 1,768,875.96 5,672,072.68 6,226,982.17 - 562,017.83 91.72% EXPENDITURE SUMMARY NONDEPARTMENTAL City Assistance 3,139,038.00 - 224,384.89 - - 3,139,038.00 - Fund Charges/Transfers 1,240,000.00 1,240,000.00 4,050,000.00 1,240,000.00 - - 100.00 TOTAL NONDEPARTMENTAL 4,379,038.00 1,240,000.00 4,274,384.89 1,240,000.00 - 3,139,038.00 28.32% MISC & PROJECTS PROJECTS ECONOMIC DEVELOPMENT Supplies 1,000.00 80.14 576.76 1,011.27 - (11.27) 101.13 City Support Services 11,200.00 3,341.26 3,322.17 7,311.03 1,666.46 2,222.51 80.16 Utility Services 2,975.00 247.10 1,836.38 2,211.58 - 763.42 74.34 Operations Support 346,985.00 48,040.55 68,826.37 186,417.42 908.91 159,658.67 53.99 Staff Support 24,225.00 9,675.84 7,076.61 21,350.37 269.08 2,605.55 89.24 City Assistance 202,500.00 - - - - 202,500.00 - Professional Services 61,300.00 4,917.75 21,267.25 20,751.72 - 40,548.28 33.85 Fund Charges/Transfers 506,984.00 - 504,669.00 506,984.00 - - 100.00 Operating Equipment 4,500.00 86.91 2,507.71 4,046.67 - 453.33 89.93 TOTAL ECONO DEVELOPMENT 1,161,669.00 66,389.55 610,082.25 750,084.06 2,844.45 408,740.49 64.81% FM3009 ROAD&BRIDGE EXPANSION TOTAL EXPENDITURES 5,540,707.00 1,306,389.55 4,884,467.14 1,990,084.06 2,844.45 3,547,778.49 35.97% ** REVENUE OVER(UNDER) EXPEND 1,248,293.00 462,486.41 787,605.54 4,236,898.11 (2,844.45) (2,985,760.66) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 317,631.22$ Cash in Investments Texas Class Investment-Economic Development Corp 22,403,704.61 Schertz Bank & Trust-Certificate of Deposit 1,091,353.64 Schertz Bank & Trust-Certificate of Deposit 1,135,751.92 Total Cash in Bank & Investments 24,948,441.39$ SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: September 30, 2022