Loading...
Q1-2022-23 Financial StatementsCITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2022 - 2023 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET General Fund, 101 Total Revenues 44,982,410.00 15,637,771.81 (2,028.64)29,346,666.83 34.76% Total General Government 7,285,543.48 1,591,063.64 960,741.63 4,733,738.21 35.03% Total Public Safety 21,170,928.05 4,226,710.19 1,155,973.14 15,788,244.72 25.42% Total Public Environment 2,587,507.00 361,971.53 158,280.08 2,067,255.39 20.11% Total Parks & Recreation 3,359,965.78 513,831.08 331,376.89 2,514,757.81 25.16% Total Cultural 1,292,795.30 301,566.23 8,954.65 982,274.42 24.02% Total Internal Services 8,083,124.64 1,500,751.64 840,479.74 5,741,893.26 28.96% Total Misc & Projects 1,202,545.68 39,827.29 28,673.25 1,134,045.14 5.70% Total Expenditures 44,982,409.93 8,535,721.60 3,484,479.38 32,962,208.95 26.72% Revenue Over(Under) Expenditures 0.07 7,102,050.21 (3,486,508.02)(3,615,542.12) General Fund, 101 Total Cash in Bank & Investments 21,224,022.66 Special Events Fund, 106 Total Revenues 24,000.00 38,401.74 0.00 (14,401.74)160.01% Total Expenditures 24,000.00 14,667.58 1,500.00 7,832.42 67.36% Revenue Over(Under) Expenditures 0.00 23,734.16 (1,500.00)(22,234.16) Special Events Fund, 106 Total Cash in Bank & Investments 162,454.61 Peg Fund, 110 Total Revenues 944,770.00 15,162.38 0.00 929,607.62 1.60% Total Expenditures 914,770.00 105,072.95 502,435.63 307,261.42 66.41% Revenue Over(Under) Expenditures 30,000.00 (89,910.57)(502,435.63)622,346.20 Peg Fund, 110 Total Cash in Bank & Investments 776,417.31 Water & Sewer, 202 Total Revenues 28,485,858.00 7,801,663.69 0.00 20,684,194.31 27.39% Total Expenditures 26,826,740.63 4,599,189.91 1,773,576.49 20,453,974.23 23.76% Revenue Over(Under) Expenditures 1,659,117.37 3,202,473.78 (1,773,576.49)230,220.08 Water & Sewer, 202 Total Cash in Bank & Investments 10,696,040.84 EMS, 203 Total Revenues 11,982,981.82 3,076,706.85 (570.00)8,906,844.97 25.67% Total Expenditures 11,981,662.41 3,017,913.94 686,548.51 8,277,199.96 30.92% Revenue Over(Under) Expenditures 1,319.41 58,792.91 (687,118.51)629,645.01 EMS, 203 Total Cash in Bank & Investments 952,379.25 Quarterly Statement Schertz, Texas AS OF :December 31, 2022 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2022 - 2023 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Drainage, 204 Total Revenues 1,450,073.00 326,536.17 0.00 1,123,536.83 22.52% Total Expenditures 1,439,807.00 308,278.35 28,452.67 1,103,075.98 23.39% Revenue Over(Under) Expenditures 10,266.00 18,257.82 (28,452.67)20,460.85 Drainage, 204 Total Cash in Bank & Investments 634,640.54 Hotel Tax, 314 Total Revenues 648,500.00 174,991.45 0.00 473,508.55 26.98% Total Expenditures 272,915.00 89,600.21 1,334.89 181,979.90 33.32% Revenue Over(Under) Expenditures 375,585.00 85,391.24 (1,334.89)291,528.65 Hotel Tax, 314 Total Cash in Bank & Investments 1,695,057.10 Park, 317 Total Revenues 319,025.00 2,472.02 0.00 316,552.98 0.77% Total Expenditures 125,000.00 0.00 0.00 125,000.00 0.00% Revenue Over(Under) Expenditures 194,025.00 2,472.02 0.00 191,552.98 Park, 317 Total Cash in Bank & Investments 263,994.07 Tree Mitigation, 319 Total Revenues 71,400.00 23,085.51 0.00 48,314.49 32.33% Total Expenditures 70,000.00 2,700.00 2,500.00 64,800.00 7.43% Revenue Over(Under) Expenditures 1,400.00 20,385.51 (2,500.00)(16,485.51) Tree Mitigation, 319 Total Cash in Bank & Investments 728,444.76 Capital Recovery Water, 411 Total Revenues 1,151,500.00 223,467.24 0.00 928,032.76 19.41% Total Expenditures 55,748.00 0.00 36,438.81 19,309.19 65.36% Revenue Over(Under) Expenditures 1,095,752.00 223,467.24 (36,438.81)908,723.57 Capital Recovery Water, 411 Total Cash in Bank & Investments 5,110,151.12 Capital Recovery Sewer, 421 Total Revenues 601,500.00 146,869.47 0.00 454,630.53 24.42% Total Expenditures 64,248.00 1,153.28 76,559.25 (13,464.53)120.96% Revenue Over(Under) Expenditures 537,252.00 145,716.19 (76,559.25)468,095.06 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 6,434,659.68 Quarterly Statement Schertz, Texas AS OF :December 31, 2022 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2022 - 2023 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Roadway Impact Fee Area 1, 431 Total Revenues 343,373.00 58,675.35 0.00 284,697.65 17.09% Total Expenditures 93,173.00 52,425.50 52,425.49 (11,677.99)112.53% Revenue Over(Under) Expenditures 250,200.00 6,249.85 (52,425.49)296,375.64 Roadway Impact Fee Area 1, 431 Total Cash in Bank & Investments 812,220.78 Roadway Impact Fee Area 2, 432 Total Revenues 201,600.00 36,290.82 0.00 165,309.18 18.00% Total Expenditures 55,000.00 0.00 0.00 55,000.00 0.00% Revenue Over(Under) Expenditures 146,600.00 36,290.82 0.00 110,309.18 Roadway Impact Fee Area 2, 432 Total Cash in Bank & Investments 600,318.57 Roadway Impact Fee Area 3, 433 Total Revenues 380,050.00 96,251.77 0.00 283,798.23 25.33% Total Expenditures 5,000.00 0.00 0.00 5,000.00 0.00% Revenue Over(Under) Expenditures 375,050.00 96,251.77 0.00 278,798.23 Roadway Impact Fee Area 3, 433 Total Cash in Bank & Investments 1,279,553.01 Roadway Impact Fee Area 4, 434 Total Revenues 3,040.00 95.96 0.00 2,944.04 3.16% Total Expenditures 3,000.00 0.00 0.00 3,000.00 0.00% Revenue Over(Under) Expenditures 40.00 95.96 0.00 (55.96) Roadway Impact Fee Area 4, 434 Total Cash in Bank & Investments 13,142.89 I&S, 505 Total Revenues 8,686,248.00 4,042,358.69 0.00 4,643,889.31 46.54% Total Expenditures 8,686,248.00 800.00 200.00 8,685,248.00 0.01% Revenue Over(Under) Expenditures 0.00 4,041,558.69 (200.00)(4,041,358.69) I&S, 505 Total Cash in Bank & Investments 5,905,967.33 SED Corporation, 620 Total Revenues 10,050,960.00 1,845,507.77 0.00 8,205,452.23 18.36% Total Expenditures 10,050,960.00 371,089.49 17,493.50 9,662,377.01 3.87% Revenue Over(Under) Expenditures 0.00 1,474,418.28 (17,493.50)(1,456,924.78) SED Corporation, 620 Total Cash in Bank & Investments 26,467,812.28 Total Cash in Bank & Investments 83,757,276.80 Quarterly Statement Schertz, Texas AS OF :December 31, 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 32,305,000.00 12,625,561.81 11,359,925.15 12,625,561.81 - 19,679,438.19 39.08 Franchises 2,550,000.00 603,933.57 561,441.05 603,933.57 - 1,946,066.43 23.68 Permits 1,717,800.00 370,354.33 308,416.32 370,354.33 - 1,347,445.67 21.56 Licenses 45,620.00 3,132.50 10,355.00 3,132.50 - 42,487.50 6.87 Fees 2,189,200.00 469,789.84 435,955.63 469,789.84 - 1,719,410.16 21.46 Fines 9,000.00 2,909.02 2,270.68 2,909.02 - 6,090.98 32.32 Inter-Jurisdictional 1,151,352.00 266,342.97 129,221.05 266,342.97 (2,028.64) 887,037.67 22.96 Fund Transfers 4,174,588.00 924,715.06 898,225.09 924,715.06 - 3,249,872.94 22.15 Miscellaneous 839,850.00 371,032.71 506,231.80 371,032.71 - 468,817.29 44.18 TOTAL REVENUES 44,982,410.00 15,637,771.81 14,212,041.77 15,637,771.81 (2,028.64) 29,346,666.83 34.76% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 41,750.00 8,228.64 10,191.30 8,228.64 14.40 33,506.96 19.74 Supplies 1,078.00 25.00 79.95 25.00 75.00 978.00 9.28 City Support Services 54,880.00 9,924.06 20,678.85 9,924.06 18,207.62 26,748.32 51.26 Operations Support 343.00 - - - - 343.00 0.00 Staff Support 31,899.00 5,705.81 10,364.77 5,705.81 200.15 25,993.04 18.51 Professional Services 3,920.00 - - - - 3,920.00 0.00 TOTAL CITY COUNCIL 133,870.00 23,883.51 41,314.87 23,883.51 18,497.17 91,489.32 31.66% CITY MANAGER Personnel Services 1,351,878.00 272,491.69 294,427.80 272,491.69 253.68 1,079,132.63 20.18 Supplies 1,470.00 155.87 320.43 155.87 94.81 1,219.32 17.05 City Support Services 1,960.00 360.00 - 360.00 - 1,600.00 18.37 Staff Support 24,349.08 1,472.99 5,540.17 1,472.99 1,861.76 21,014.33 13.70 Capital Outlay - - - - 44.50 (44.50) - TOTAL CITY MANAGER 1,379,657.08 274,480.55 300,288.40 274,480.55 2,254.75 1,102,921.78 20.06% MUNICIPAL COURT Personnel Services 329,472.00 86,049.44 87,895.72 86,049.44 99.92 243,322.64 26.15 Supplies 1,568.00 80.30 60.00 80.30 194.91 1,292.79 17.55 City Support Services 980.00 159.71 118.68 159.71 76.86 743.43 24.14 Operations Support 1,960.00 - - - - 1,960.00 - Staff Support 7,261.80 744.91 - 744.91 270.00 6,246.89 13.98 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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: December 31, 2022 Court Support 980.00 282.00 132.00 282.00 210.00 488.00 50.20 Professional Services 65,954.00 12,669.50 10,300.00 12,669.50 41,750.00 11,534.50 82.51 Maintenance Services 8,526.00 300.00 450.00 300.00 3,450.00 4,776.00 43.98 Operating Equipment - - - - 179.99 (179.99) - TOTAL MUNICIPAL COURT 416,701.80 100,285.86 98,956.40 100,285.86 46,231.68 270,184.26 35.16% CUSTOMER RELATIONS-311 Personnel Services 120,518.00 30,989.08 31,784.61 30,989.08 39.45 89,489.47 25.75 Supplies 122.50 34.33 17.02 34.33 - 88.17 28.02 Staff Support 421.40 - 32.28 - - 421.40 - TOTAL CUSTOMER RELATIONS-311 121,061.90 31,023.41 31,833.91 31,023.41 39.45 89,999.04 25.66% PLANNING & ZONING Personnel Services 338,774.00 47,247.33 43,452.70 47,247.33 59.55 291,467.12 13.96 Supplies 1,979.60 150.67 240.86 150.67 (8.13) 1,837.06 7.20 City Support Services - - - - 1,166.00 (1,166.00) - Operations Support 243.04 - - - 62.00 181.04 25.51 Staff Support 34,584.20 2,130.12 1,334.70 2,130.12 120.00 32,334.08 6.51 Professional Services 196.00 (10.00) - (10.00) - 206.00 (5.10) Operating Equipment 318.50 - 285.47 - - 318.50 - TOTAL PLANNING & ZONING 376,095.34 49,518.12 45,313.73 49,518.12 1,399.42 325,177.80 13.54% LEGAL SERVICES Operations Support 9,800.00 577.75 - 577.75 - 9,222.25 5.90 Professional Services 127,400.00 8,754.25 4,050.50 8,754.25 2,863.46 115,782.29 9.12 TOTAL LEGAL SERVICES 137,200.00 9,332.00 4,050.50 9,332.00 2,863.46 125,004.54 8.89% CITY SECRETARY Personnel Services 213,949.00 53,084.49 55,155.27 53,084.49 30.01 160,834.50 24.83 Supplies 1,127.00 217.43 235.13 217.43 35.60 873.97 22.45 City Support Services 11,760.00 - 1,920.02 - - 11,760.00 - Operations Support 147.00 100.00 - 100.00 - 47.00 68.03 Staff Support 6,590.50 158.95 1,262.57 158.95 140.95 6,290.60 4.55 TOTAL CITY SECRETARY 233,573.50 53,560.87 58,572.99 53,560.87 206.56 179,806.07 23.02% NON-DEPARTMENTAL City Support Services 925,471.60 422,778.51 370,776.84 422,778.51 214,106.94 288,586.15 68.82 Operations Support 126,420.00 24,715.29 27,293.31 24,715.29 1,519.31 100,185.40 20.75 City Assistance 1,367,603.72 182,250.11 - 182,250.11 544,135.74 641,217.87 53.11 Professional Services 113,802.50 19,537.83 12,978.28 19,537.83 265.00 93,999.67 17.40 Fund Chrgs/Transfrs-Spec Events Fnd 27,756.54 146.72 - 146.72 - 27,609.82 0.53 TOTAL NON-DEPARTMENTAL 2,561,054.36 649,428.46 411,048.43 649,428.46 760,026.99 1,151,598.91 55.03% 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: December 31, 2022 PUBLIC AFFAIRS Personnel Services 348,144.00 82,803.09 89,640.91 82,803.09 95.61 265,245.30 23.81 Supplies 1,078.00 355.98 351.61 355.98 68.93 653.09 39.42 City Support Services 490.00 - - - - 490.00 - Operations Support 47,971.90 2,121.67 6,903.71 2,121.67 - 45,850.23 4.42 Staff Support 7,840.00 147.00 423.32 147.00 2,477.01 5,215.99 33.47 Professional Services 256,760.00 69,389.50 87,408.00 69,389.50 12,482.54 174,887.96 31.89 Operating Equipment 200.00 192.28 - 192.28 - 7.72 96.14 TOTAL PUBLIC AFFAIRS 662,483.90 155,009.52 184,727.55 155,009.52 15,124.09 492,350.29 25.68% ENGINEERING Personnel Services 1,078,273.00 229,479.22 205,032.23 229,479.22 291.46 848,502.32 21.31 Supplies 1,715.00 483.31 163.09 483.31 - 1,231.69 28.18 Utility Services 7,938.00 1,151.30 581.00 1,151.30 - 6,786.70 14.50 Operations Support 147.00 - - - - 147.00 - Staff Support 15,650.60 439.01 75.00 439.01 365.76 14,845.83 5.14 Professional Services 49,000.00 12,988.50 9,293.05 12,988.50 27,962.50 8,049.00 83.57 Operating Equipment 11,122.00 - - - - 11,122.00 - TOTAL ENGINEERING 1,263,845.60 244,541.34 215,144.37 244,541.34 114,098.06 905,206.20 28.38% TOTAL GENERAL GOVERNMENT 7,285,543.48 1,591,063.64 1,391,251.15 1,591,063.64 960,741.63 4,733,738.21 35.03% PUBLIC SAFETY POLICE Personnel Services 9,599,285.00 2,260,339.58 2,391,077.39 2,260,339.58 2,469.80 7,336,475.62 23.57 Supplies 110,150.04 27,452.71 23,578.22 27,452.71 5,434.00 77,263.33 29.86 City Support Services 33,810.00 35,584.78 33,969.74 35,584.78 - (1,774.78) 105.25 Utility Services 302,232.00 31,668.93 27,462.19 31,668.93 732.64 269,830.43 10.72 Operations Support 16,836.40 - 821.80 - 935.00 15,901.40 5.55 Staff Support 267,954.20 20,079.31 26,164.16 20,079.31 27,458.98 220,415.91 17.74 City Assistance 65,170.00 10,014.05 8,952.04 10,014.05 6,686.18 48,469.77 25.63 Professional Services 79,309.44 20,121.59 21,656.91 20,121.59 7,041.66 52,146.19 34.25 Maintenance Services 78,404.90 5,904.30 5,207.50 5,904.30 - 72,500.60 7.53 Operating Equipment 408,115.10 1,211.52 25,351.86 1,211.52 49,641.69 357,261.89 12.46 Capital Outlay 759,439.00 - 5,390.00 - 625,893.41 133,545.59 82.42 TOTAL POLICE 11,720,706.08 2,412,376.77 2,569,631.81 2,412,376.77 726,293.36 8,582,035.95 26.78% 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: December 31, 2022 FIRE RESCUE Personnel Services 6,410,107.00 1,401,153.12 1,527,987.52 1,401,153.12 1,110.15 5,007,843.73 21.88 Supplies 23,083.90 2,725.24 2,488.56 2,725.24 335.71 20,022.95 13.26 Utility Services 145,039.99 17,999.90 14,387.50 17,999.90 115.73 126,924.36 12.49 Operations Support 4,436.46 100.00 1,527.45 100.00 31.00 4,305.46 2.95 Staff Support 222,972.50 30,612.70 22,373.36 30,612.70 18,922.94 173,436.86 22.22 City Assistance 40,227.04 13,071.00 2,483.23 13,071.00 3,761.10 23,394.94 41.84 Professional Services 72,328.00 4,800.00 10,838.86 4,800.00 3,500.00 64,028.00 11.48 Maintenance Services 83,868.40 2,452.58 2,203.18 2,452.58 8,023.66 73,392.16 12.49 Other Costs 9,800.00 11,341.50 - 11,341.50 - (1,541.50) 115.73 Rental/Leasing 26,460.00 - - - - 26,460.00 - Operating Equipment 127,032.00 5,563.76 6,921.69 5,563.76 25,665.53 95,802.71 24.58 Capital Outlay 488,449.00 9,690.00 - 9,690.00 227,760.17 250,998.83 48.61 TOTAL FIRE RESCUE 7,653,804.29 1,499,509.80 1,591,211.35 1,499,509.80 289,225.99 5,865,068.50 23.37% INSPECTIONS Personnel Services 1,091,750.00 230,425.51 254,938.14 230,425.51 314.00 861,010.49 21.13 Supplies 4,998.00 164.48 93.00 164.48 77.72 4,755.80 4.85 Utility Services 8,232.00 1,071.46 1,198.25 1,071.46 - 7,160.54 13.02 Operations Support 833.00 31.00 - 31.00 62.00 740.00 11.16 Staff Support 45,496.50 1,396.80 2,347.44 1,396.80 643.84 43,455.86 4.49 Professional Services 68,600.00 - 600.00 - 61,100.00 7,500.00 89.07 Operating Equipment 7,637.00 - 570.94 - - 7,637.00 - Capital Outlay 43,750.00 - - - 76,121.44 (32,371.44) 173.99 TOTAL INSPECTIONS 1,271,296.50 233,089.25 259,747.77 233,089.25 138,319.00 899,888.25 29.21% NEIGHBORHOOD SERVICES Personnel Services 368,203.00 78,532.42 76,690.18 78,532.42 104.37 289,566.21 21.36 Supplies 8,914.12 149.55 814.51 149.55 286.06 8,478.51 4.89 Utility Services 8,624.00 866.82 480.00 866.82 - 7,757.18 10.05 Operations Support 3,350.62 31.00 - 31.00 - 3,319.62 0.93 Staff Support 29,060.94 1,750.12 891.59 1,750.12 1,744.36 25,566.46 12.02 Professional Services 2,450.00 - - - - 2,450.00 - Maintenance Services 24,700.00 404.46 1,950.00 404.46 - 24,295.54 1.64 Operating Equipment 3,818.50 - 285.47 - - 3,818.50 - TOTAL NEIGHBORHOOD SERVICES 525,121.18 81,734.37 81,111.75 81,734.37 2,134.79 441,252.02 15.97% TOTAL PUBLIC SAFETY 21,170,928.05 4,226,710.19 4,501,702.68 4,226,710.19 1,155,973.14 15,788,244.72 25.42% 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: December 31, 2022 PUBLIC ENVIRONMENT STREETS Personnel Services 1,107,287.00 290,097.51 265,423.63 290,097.51 1,497.11 815,692.38 26.33 Supplies 178,850.00 13,192.18 16,723.52 13,192.18 14,356.90 151,300.92 15.40 City Support Services 5,880.00 564.62 411.45 564.62 901.14 4,414.24 24.93 Utility Services 196,000.00 40,287.78 31,994.77 40,287.78 - 155,712.22 20.55 Staff Support 22,050.00 3,813.81 1,571.78 3,813.81 2,503.78 15,732.41 28.65 Professional Services 30,380.00 - - - - 30,380.00 - Maintenance Services 725,790.00 502.40 2,591.00 502.40 - 725,287.60 0.07 Rental/Lease 4,900.00 848.23 - 848.23 - 4,051.77 17.31 Operating Equipment 6,370.00 12,665.00 2,386.15 12,665.00 - (6,295.00) 198.82 Capital Outlay 310,000.00 - - - 139,021.15 170,978.85 44.85 TOTAL STREETS 2,587,507.00 361,971.53 321,102.30 361,971.53 158,280.08 2,067,255.39 20.11% TOTAL PUBLIC ENVIRONMENT 2,587,507.00 361,971.53 321,102.30 361,971.53 158,280.08 2,067,255.39 20.11% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 975,812.00 210,521.83 191,576.24 210,521.83 262.77 765,027.40 21.60 Supplies 111,443.00 12,709.35 14,100.85 12,709.35 16,619.92 82,113.73 26.32 City Support Services 180,948.40 46,941.33 42,355.74 46,941.33 44,675.84 89,331.23 50.63 Utility Services 250,880.00 16,596.68 32,974.33 16,596.68 30,084.81 204,198.51 18.61 Operations Support 1,960.00 274.25 - 274.25 - 1,685.75 13.99 Staff Support 19,276.60 4,271.09 4,984.33 4,271.09 - 15,005.51 22.16 Professional Services 194,987.08 22,621.60 35,292.90 22,621.60 17,483.75 154,881.73 20.57 Maintenance Services 13,720.00 2,663.50 1,798.72 2,663.50 4,404.05 6,652.45 51.51 Rental/Leasing 9,800.00 1,176.05 1,041.72 1,176.05 1,500.00 7,123.95 27.31 Operating Equipment 72,715.00 2,425.00 8,049.36 2,425.00 12,891.06 57,398.94 21.06 Capital Outlay 480,615.00 15,538.98 - 15,538.98 162,530.19 302,545.83 37.05 TOTAL PARKS DEPARTMENT 2,312,157.08 335,739.66 332,174.19 335,739.66 290,452.39 1,685,965.03 27.08% SWIM POOL Supplies 24,990.00 21.15 - 21.15 1,261.24 23,707.61 5.13 Utility Services 16,170.00 2,573.46 2,571.43 2,573.46 - 13,596.54 15.92 Maintenance Services 539,664.00 72,120.46 97,339.35 72,120.46 36,060.23 431,483.31 20.05 TOTAL SWIM POOL 580,824.00 74,715.07 99,910.78 74,715.07 37,321.47 468,787.46 19.29% 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: December 31, 2022 EVENT FACILITIES Personnel Services 380,583.00 92,150.09 74,759.05 92,150.09 121.03 288,311.88 24.24 Supplies 4,410.00 846.50 469.40 846.50 27.99 3,535.51 19.83 Utility Services 48,588.40 8,528.34 6,029.35 8,528.34 3,394.92 36,665.14 24.54 Operations Support 15,297.80 - 61.72 - - 15,297.80 - Staff Support 4,875.50 576.46 293.44 576.46 - 4,299.04 11.82 Maintenance Services 2,450.00 - 1,633.94 - - 2,450.00 - Operating Equipment 10,780.00 1,274.96 3,491.14 1,274.96 59.09 9,445.95 12.38 TOTAL EVENT FACILITIES 466,984.70 103,376.35 86,738.04 103,376.35 3,603.03 360,005.32 22.91% TOTAL PARKS & RECREATION 3,359,965.78 513,831.08 518,823.01 513,831.08 331,376.89 2,514,757.81 25.16% CULTURAL LIBRARY Personnel Services 993,719.00 238,520.99 251,406.38 238,520.99 219.09 754,978.92 24.02 Supplies 18,130.00 2,621.50 4,024.44 2,621.50 1,316.45 14,192.05 21.72 Utility Services 60,760.00 7,478.54 10,037.46 7,478.54 - 53,281.46 12.31 Operations Support 4,018.00 335.98 253.97 335.98 - 3,682.02 8.36 Staff Support 7,874.30 5,605.51 5,486.35 5,605.51 15.00 2,253.79 71.38 Professional Services 2,254.00 - 2,129.00 - - 2,254.00 - Operating Equipment 176,040.00 47,003.71 47,002.22 47,003.71 7,404.11 121,632.18 30.91 TOTAL LIBRARY 1,292,795.30 301,566.23 320,339.82 301,566.23 8,954.65 982,274.42 24.02% TOTAL CULTURAL 1,292,795.30 301,566.23 320,339.82 301,566.23 8,954.65 982,274.42 24.02% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 1,109,865.00 252,066.77 238,282.56 252,066.77 282.33 857,515.90 22.74 Supplies 8,624.00 457.36 1,328.37 457.36 485.07 7,681.57 10.93 City Support Services 1,128,273.66 113,449.44 171,915.69 113,449.44 94,093.29 920,730.93 18.39 Utility Services 342,896.18 72,202.25 52,288.92 72,202.25 206.95 270,486.98 21.12 Staff Support 87,333.80 4,898.93 1,056.78 4,898.93 11,105.60 71,329.27 18.33 Professional Services 25,970.00 - 1,406.25 - - 25,970.00 - Maintenance Services 14,700.00 546.85 269.90 546.85 - 14,153.15 3.72 Rental/Leasing 3,577.00 1,294.74 1,216.72 1,294.74 - 2,282.26 36.20 Operating Equipment 273,808.00 12,491.64 52,537.65 12,491.64 62,460.73 198,855.63 27.37 TOTAL INFORMATION TECHNOLOGY 3,063,097.64 457,407.98 520,302.84 457,407.98 202,180.47 2,403,509.19 21.53% 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: December 31, 2022 HUMAN RESOURCES Personnel Services 510,089.00 120,584.01 100,281.02 120,584.01 144.03 389,360.96 23.67 Supplies 3,846.00 308.08 134.37 308.08 813.69 2,724.23 29.17 Human Services 173,558.00 34,994.66 38,049.10 34,994.66 59,176.31 79,387.03 54.26 Operations Support 22,390.00 2,023.73 1,949.84 2,023.73 625.11 19,741.16 11.83 Staff Support 38,367.00 13,248.59 13,680.01 13,248.59 8,177.67 16,940.74 55.85 City Assistance 14,700.00 2,049.00 4,855.00 2,049.00 4,920.00 7,731.00 47.41 Professional Services 4,900.00 - - - - 4,900.00 - Operating Equipment 490.00 - - - - 490.00 - TOTAL HUMAN RESOURCES 768,340.00 173,208.07 158,949.34 173,208.07 73,856.81 521,275.12 32.16% FINANCE Personnel Services 699,363.00 175,468.79 183,182.04 175,468.79 210.66 523,683.55 25.12 Supplies 2,646.00 663.83 726.83 663.83 817.71 1,164.46 55.99 Staff Support 4,263.00 486.99 240.00 486.99 39.24 3,736.77 12.34 Professional Sevices 48,216.00 871.01 7,908.09 871.01 - 47,344.99 1.81 Operating Equipment 980.00 - - - - 980.00 - TOTAL FINANCE 755,468.00 177,490.62 192,056.96 177,490.62 1,067.61 576,909.77 23.64% PURCHASING & ASSET MGT Personnel Services 268,812.00 69,139.30 66,560.09 69,139.30 65.89 199,606.81 25.74 Supplies 3,724.00 678.31 390.56 678.31 232.79 2,812.90 24.47 Operations Support 7,497.00 2,424.25 1,299.00 2,424.25 - 5,072.75 32.34 Staff Support 9,947.00 1,697.05 399.00 1,697.05 58.98 8,190.97 17.65 City Assistance 2,940.00 110.00 124.00 110.00 84.00 2,746.00 6.60 Operating Equipment 2,450.00 - - - 1,142.97 1,307.03 46.65 TOTAL PURCHASING & ASSET MGT 295,370.00 74,048.91 68,772.65 74,048.91 1,584.63 219,736.46 25.61% FLEET SERVICE Personnel Services 681,919.00 146,435.08 127,930.41 146,435.08 143.14 535,340.78 21.49 Supplies 211,680.00 33,833.16 29,992.53 33,833.16 34,594.44 143,252.40 32.33 City Support Services 13,720.00 - 2,404.34 - 102.50 13,617.50 0.75 Utility Services 11,760.00 1,561.21 1,109.01 1,561.21 39.00 10,159.79 13.61 Staff Support 37,240.00 4,476.24 512.50 4,476.24 1,854.76 30,909.00 17.00 Maintenance Services 227,360.00 47,268.39 38,782.94 47,268.39 34,732.46 145,359.15 36.07 Operating Equipment 13,720.00 580.22 5,007.38 580.22 1,065.99 12,073.79 12.00 Capital Outlay 46,875.00 - 394.87 - 94,256.40 (47,381.40) 201.08 TOTAL FLEET SERVICE 1,244,274.00 234,154.30 206,133.98 234,154.30 166,788.69 843,331.01 32.22% 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: December 31, 2022 FACILITY SERVICES Personnel Services 879,776.00 222,525.27 206,977.44 222,525.27 257.35 656,993.38 25.32 Supplies 156,785.00 39,145.60 9,833.34 39,145.60 13,691.23 103,948.17 33.70 Utility Services 189,140.00 23,165.78 31,688.37 23,165.78 19,133.74 146,840.48 22.36 Staff Support 20,620.00 3,113.74 1,646.63 3,113.74 2,882.21 14,624.05 29.08 Professional Services 193,904.00 38,184.13 12,416.31 38,184.13 123,951.91 31,767.96 83.62 Maintenance Services 419,440.00 58,307.24 36,814.88 58,307.24 117,928.25 243,204.51 41.42 Rental/Leasing 490.00 - - - - 490.00 - Operating Equipment 3,920.00 - - - 658.00 3,262.00 16.79 Capital Outlay 92,500.00 - - - 116,498.84 (23,998.84) 125.94 TOTAL BUILDING MAINTENANCE 1,956,575.00 384,441.76 299,376.97 384,441.76 395,001.53 1,177,131.71 39.84% TOTAL INTERNAL SERVICE 8,083,124.64 1,500,751.64 1,445,592.74 1,500,751.64 840,479.74 5,741,893.26 28.96% MISC & PROJECTS Project Fund Charges/Transfers 850,000.00 - - - - 850,000.00 - TOTAL PROJECTS 850,000.00 - - - - 850,000.00 0.00% CITY ASSISTANCE City's Assistance to Agencies 326,012.68 37,619.75 49,458.75 37,619.75 23,893.25 264,499.68 18.87 Operating Equipment 13,793.00 2,207.54 - 2,207.54 2,280.00 9,305.46 32.53 TOTAL CITY ASSISTANCE 339,805.68 39,827.29 49,458.75 39,827.29 26,173.25 273,805.14 19.42% SEWER PROJECTS TOTAL SEWER PROJECTS - - - - - - 0.00% COURT - RESTRICTED FUNDS Operating Equipment 12,740.00 - - - 2,500.00 10,240.00 19.62 TOTAL COURT-RESTRICTED FUNDS 12,740.00 - - - 2,500.00 10,240.00 19.62% TOTAL MISC & PROJECTS 1,202,545.68 39,827.29 49,458.75 39,827.29 28,673.25 1,134,045.14 5.70% TOTAL EXPENDITURES 44,982,409.93 8,535,721.60 8,548,270.45 8,535,721.60 3,484,479.38 32,962,208.95 26.72% REVENUE OVER(UNDER) EXPEND.0.07 7,102,050.21 5,663,771.32 7,102,050.21 (3,486,508.02) (3,615,542.12) 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 Taxes 000-411100 Advalorem Tax-Current 17,965,000.00 9,235,312.50 8,443,209.42 9,235,312.50 - 8,729,687.50 51.41 000-411110 Disable Veterans Assist Pymnt 1,100,000.00 - - - - 1,100,000.00 - 000-411200 Advalorem Tax-Delinquent 50,000.00 93,109.16 14,754.88 93,109.16 - (43,109.16) 186.22 000-411300 Advalorem Tax-P&I 80,000.00 30,628.20 12,977.65 30,628.20 - 49,371.80 38.29 000-411500 Sales Tax Revenue-Gen Fund 13,040,000.00 3,243,209.95 2,870,801.58 3,243,209.95 - 9,796,790.05 24.87 000-411700 Mixed Beverage Tax 70,000.00 23,302.00 18,181.62 23,302.00 - 46,698.00 33.29 TOTAL Taxes 32,305,000.00 12,625,561.81 11,359,925.15 12,625,561.81 - 19,679,438.19 39.08% Franchises 000-421200 Center Point/Entex Energy 120,000.00 21,645.08 22,791.99 21,645.08 - 98,354.92 18.04 000-421220 City Public Service 1,200,000.00 291,226.83 243,299.04 291,226.83 - 908,773.17 24.27 000-421240 Guadalupe Valley Elec Co-op 475,000.00 99,059.28 109,454.20 99,059.28 - 375,940.72 20.85 000-421250 New Braunfels Utilities 80,000.00 20,303.18 15,731.04 20,303.18 - 59,696.82 25.38 000-421300 Time Warner-State Franchise 325,000.00 82,008.00 77,552.15 82,008.00 - 242,992.00 25.23 000-421460 AT&T Franchise Fee 75,000.00 8,363.43 21,637.80 8,363.43 - 66,636.57 11.15 000-421480 Other Telecom Franchise - ROW 100,000.00 35,508.55 27,885.25 35,508.55 - 64,491.45 35.51 000-421500 Solid Waste Franchise Fee 175,000.00 45,819.22 43,089.58 45,819.22 - 129,180.78 26.18 TOTAL Franchises 2,550,000.00 603,933.57 561,441.05 603,933.57 - 1,946,066.43 23.68% Permits 000-431100 Home Occupation Permit 550.00 105.00 175.00 105.00 - 445.00 19.09 000-431205 Bldg Permit-Residential 513,000.00 66,584.00 48,716.50 66,584.00 - 446,416.00 12.98 000-431210 Bldg Permit-Commercial 347,000.00 64,935.20 92,967.00 64,935.20 - 282,064.80 18.71 000-431215 Bldg Permit-General 328,000.00 62,990.00 56,896.00 62,990.00 - 265,010.00 19.20 000-431300 Mobile Home Permit - 25.00 25.00 25.00 - (25.00) - 000-431400 Signs Permit 5,500.00 976.00 644.00 976.00 - 4,524.00 17.75 000-431500 Food Establishmnt Permit 71,000.00 46,280.00 44,540.00 46,280.00 - 24,720.00 65.18 000-431700 Plumbing Permit 123,000.00 21,840.00 17,809.00 21,840.00 - 101,160.00 17.76 000-431750 Electrical Permit 70,000.00 17,440.00 10,600.00 17,440.00 - 52,560.00 24.91 000-431800 Mechanical Permit 60,000.00 10,640.00 7,800.00 10,640.00 - 49,360.00 17.73 000-431900 Solicitor/Peddler Permit 2,000.00 130.00 240.00 130.00 - 1,870.00 6.50 000-431950 Animal/Pet Permit 250.00 - - - - 250.00 - 000-432000 Cert of Occupancy Prmt 9,500.00 2,400.00 2,850.00 2,400.00 - 7,100.00 25.26 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 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 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 000-432100 Security Alarm Permit 43,000.00 4,161.00 6,995.00 4,161.00 - 38,839.00 9.68 000-432300 Grading/Clearing Permit 15,000.00 10,215.50 2,055.38 10,215.50 - 4,784.50 68.10 000-432400 Development Permit 100,000.00 54,754.63 12,231.44 54,754.63 - 45,245.37 54.75 000-435000 Fire Permit 30,000.00 6,878.00 3,872.00 6,878.00 - 23,122.00 22.93 TOTAL Permits 1,717,800.00 370,354.33 308,416.32 370,354.33 - 1,347,445.67 21.56% Licenses 000-441000 Alcohol Beverage License 8,500.00 3,052.50 2,585.00 3,052.50 - 5,447.50 35.91 000-441300 Mobile Home License 120.00 80.00 80.00 80.00 - 40.00 66.67 000-442000 Contractors License 37,000.00 - 7,690.00 - - 37,000.00 - TOTAL Licenses 45,620.00 3,132.50 10,355.00 3,132.50 - 42,487.50 6.87% Fees 000-451000 Municipal Court Fines 525,000.00 88,917.25 98,415.38 88,917.25 - 436,082.75 16.94 000-451010 Texas Motor Carrier Fines 30,000.00 - 11,744.00 - - 30,000.00 - 000-451015 CVE Out of Service 3,000.00 - 800.00 - - 3,000.00 000-451100 Arrest Fee 12,000.00 2,789.05 3,040.77 2,789.05 - 9,210.95 23.24 000-451200 Warrant Fees 53,000.00 9,209.34 12,404.37 9,209.34 - 43,790.66 17.38 000-451340 Judicial Fee-City 300.00 44.28 83.57 44.28 - 255.72 14.76 000-451400 Traffic Fine Costs TTL 6,000.00 1,218.05 1,317.04 1,218.05 - 4,781.95 20.30 000-451510 Juvenile Case Mgmt Fee 3,000.00 368.97 696.40 368.97 - 2,631.03 12.30 000-451520 Truancy Fees 14,000.00 2,923.16 2,978.62 2,923.16 - 11,076.84 20.88 000-451530 Local Municipal Jury Fund 150.00 57.34 57.50 57.34 - 92.66 38.23 000-451600 Technology Fund Fee 13,000.00 2,610.51 2,891.43 2,610.51 - 10,389.49 20.08 000-451700 Security Fee 15,000.00 3,045.56 3,261.95 3,045.56 - 11,954.44 20.30 000-451800 Time Payment Fee-City 4,000.00 881.00 1,004.61 881.00 - 3,119.00 22.03 000-451850 State Fines 10% Service Fee 15,000.00 6,466.11 5,436.72 6,466.11 - 8,533.89 43.11 000-451900 DPS Payment-Local 4,000.00 760.00 1,015.76 760.00 - 3,240.00 19.00 000-452000 Child Safety Fee 5,000.00 993.02 478.76 993.02 - 4,006.98 19.86 000-452100 Platting Fees 54,000.00 14,500.00 20,250.00 14,500.00 - 39,500.00 26.85 000-452200 Site Plan Fee 23,000.00 12,000.00 6,000.00 12,000.00 - 11,000.00 52.17 000-452300 Plan Check Fee 570,000.00 79,227.87 85,868.25 79,227.87 - 490,772.13 13.90 000-452320 Tree Mitigation Admin Fee 15,000.00 - 10,057.50 - - 15,000.00 - 000-452400 BOA/Variance Fees 2,500.00 500.00 1,500.00 500.00 - 2,000.00 20.00 000-452600 Specific Use/Zone Chng Fee 26,450.00 3,500.00 (2,500.00) 3,500.00 - 22,950.00 13.23 000-452710 Zoning Ltr & Dev Rights 2,550.00 900.00 1,500.00 900.00 - 1,650.00 35.29 000-453100 Reinspection Fees 190,000.00 53,325.00 49,525.00 53,325.00 - 136,675.00 28.07 000-453110 Swim Pool Inspection Fee 2,900.00 1,540.00 - 1,540.00 - 1,360.00 53.10 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 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 000-453200 Lot Abatement 6,700.00 1,520.00 1,700.00 1,520.00 - 5,180.00 22.69 000-453211 Admin Fee-Inspections 10,000.00 1,100.00 2,000.00 1,100.00 - 8,900.00 11.00 000-453710 Foster Care 500.00 - - - - 500.00 - 000-454200 Pool Gate Admission Fee 22,000.00 - - - - 22,000.00 - 000-454300 Seasonal Pool Pass Fee 4,000.00 - - - - 4,000.00 - 000-456110 Senior Center Memberships 16,000.00 3,178.00 252.00 3,178.00 - 12,822.00 19.86 000-456120 Senior Center Meal Fee 20,000.00 7,627.88 4,823.46 7,627.88 - 12,372.12 38.14 000-456500 HAZ MAT Fees 5,000.00 - - - - 5,000.00 - 000-456600 Fire Re-inspection Fee 700.00 100.00 - 100.00 - 600.00 14.29 000-458000 Sale of General Fixed Assets - - 37,572.00 - - - - 000-458110 Sale of Mdse - GovDeals 100,000.00 30,951.45 1,416.00 30,951.45 - 69,048.55 30.95 000-458400 Civic Center Rental Fees 225,000.00 83,702.50 46,013.25 83,702.50 - 141,297.50 37.20 000-458401 Capital Recovery Fee-Civic C - 1,850.00 (600.00) 1,850.00 - (1,850.00) - 000-458402 Civic Center Ancillary Fees - 910.00 250.00 910.00 - (910.00) - 000-458450 North Center Rental Fees 28,000.00 15,300.00 6,956.25 14,925.00 - 13,075.00 53.30 000-458460 Senior Center Rental 7,000.00 1,400.00 - 1,400.00 - 5,600.00 20.00 000-458500 Community Center Rental Fees 40,000.00 22,189.50 12,119.25 22,189.50 - 17,810.50 55.47 000-458501 Community Center Service Fees - - 200.00 - - - - 000-458510 Grand Ballroom Rental Fees - (1,800.00) (18,250.00) (1,800.00) - 1,800.00 - 000-458520 Cut-Off Hall Rental Fees - - 600.00 - - - - 000-458540 Bluebonnet Hall Rental Fees - (900.00) (1,525.00) (900.00) - 900.00 - 000-458550 Pavilion Rental Fees 25,000.00 3,530.00 3,482.50 3,305.00 - 21,695.00 13.22 000-458560 Chamber of Comm Rent 7,800.00 - 1,950.00 - - 7,800.00 - 000-458570 Non-Resident SYSA League 10,000.00 - - - - 10,000.00 - 000-458590 Cancellation Fees-Event Rental 1,500.00 950.00 350.00 950.00 - 550.00 63.33 000-458650 NonResident User Fee-BVYA - 2,540.00 3,530.00 2,540.00 - (2,540.00) - 000-458660 BVYA Utility Reimbursement 15,000.00 6.00 3,912.00 6.00 - 14,994.00 0.04 000-458670 SYSA Utility Reimbursement 7,500.00 - 2,616.29 - - 7,500.00 - 000-458675 Lions Futbol Utility Reimbrsmt 15,000.00 - - - - 15,000.00 - 000-458685 Recreation Programs 1,000.00 - - - - 1,000.00 - 000-458685.001Rec Prgrm-Kickball Leagues 2,600.00 - - - - 2,600.00 - 000-458700 Vehicle Impoundment - 2,970.00 3,380.00 2,970.00 - (2,970.00) - 000-459300 Notary Fee 50.00 18.00 6.00 18.00 - 32.00 36.00 000-459600 Animal Adoption Fee 12,000.00 4,250.00 2,185.00 4,250.00 - 7,750.00 35.42 000-459700 Pet Impoundment Fee 13,000.00 2,457.00 2,188.00 2,457.00 - 10,543.00 18.90 000-459800 Police Reports Fee 5,000.00 1,288.00 1,001.00 1,288.00 - 3,712.00 25.76 TOTAL Fees 2,189,200.00 470,914.84 435,955.63 470,314.84 - 1,718,885.16 21.48% 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 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Fines 000-463000 Library Fines 9,000.00 2,909.02 2,270.68 2,909.02 - 6,090.98 32.32 TOTAL Fines 9,000.00 2,909.02 2,270.68 2,909.02 - 6,090.98 32.32% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,077.00 - 5,269.44 - - 21,077.00 - 000-473200 City of Seguin-Fire Contract 30,107.00 11,742.18 5,575.52 11,742.18 (2,028.64) 20,393.46 32.26 000-473300 Guadalupe Co-Library 220,000.00 54,288.00 - 54,288.00 - 165,712.00 24.68 000-474200 Library Services-Cibolo 40,000.00 - - - - 40,000.00 - 000-474210 Library Services-Selma 25,000.00 - - - - 25,000.00 - 000-474400 Dispatch Service-Cibolo 160,000.00 - - - - 160,000.00 - 000-474600 School Crossing Guard-Bexar Co 36,000.00 9,841.12 9,284.88 9,841.12 - 26,158.88 27.34 000-474610 School Cross Guard-Guadalupe C 41,000.00 10,732.17 10,963.21 10,732.17 - 30,267.83 26.18 000-474620 School Crossing Guards - Comal 1,900.00 - - - - 1,900.00 - 000-474700 School Officer Funding 551,268.00 179,739.50 91,878.00 179,739.50 - 371,528.50 32.60 000-474750 Crime Victim Liaison Agreement 25,000.00 - 6,250.00 - - 25,000.00 - TOTAL Inter-Jurisdictional 1,151,352.00 266,342.97 129,221.05 266,342.97 (2,028.64) 887,037.67 22.96% Fund Transfers 000-480000 Indirect Costs-EMS 216,994.00 54,248.53 53,185.03 54,248.53 - 162,745.47 25.00 000-480100 Indirect Costs-Hotel/Motel 69,915.00 17,478.75 18,610.78 17,478.75 - 52,436.25 25.00 000-481000 Transfer In - Reserves 1,052,715.00 - - - - 1,052,715.00 - 000-485000 Interfund Charges-Drainage-5%320,073.00 80,018.25 77,002.50 80,018.25 - 240,054.75 25.00 000-486000 Interfund Chrges-Admin W&S 1,493,620.00 373,405.03 369,557.53 373,405.03 - 1,120,214.97 25.00 000-486202 Transfer In-Water&Sewer Fund 4,000.00 - - - - 4,000.00 - 000-486203 Transfer In-EMS 4,000.00 - - - - 4,000.00 - 000-486204 Transfer In-Drainage 1,000.00 - - - - 1,000.00 - 000-487000 Interfund Charges-Fleet 470,050.00 128,454.00 126,377.25 128,454.00 - 341,596.00 27.33 000-488000 Interfund Charges-4B 542,221.00 271,110.50 253,492.00 271,110.50 - 271,110.50 50.00 TOTAL Fund Transfers 4,174,588.00 924,715.06 898,225.09 924,715.06 - 3,249,872.94 22.15% Miscellaneous 000-491000 Interest Earned 25,000.00 32,001.04 1,843.81 32,001.04 - (7,001.04) 128.00 000-491200 Investment Income 150,000.00 108,241.72 9,839.82 117,650.02 - 32,349.98 78.43 000-491900 Unrealized Gain/Loss-CapOne - (3,074.71) (13,105.39) (3,074.71) - 3,074.71 - 000-493120 Donations-Public Library 10,000.00 365.06 536.71 365.06 - 9,634.94 3.65 000-493400 Donations-Animal Control 5,000.00 865.00 1,087.00 865.00 - 4,135.00 17.30 000-493465 Donations-Senior Center 10,000.00 1,562.05 1,497.00 1,562.05 - 8,437.95 15.62 000-493503 Donation-Fire Rescue 1,000.00 150.00 - 150.00 - 850.00 15.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 REVENUES C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 000-493618 Donation - Veteran's Memorial 1,250.00 525.00 1,050.00 525.00 - 725.00 42.00 000-493700 July 4th Activities 26,000.00 - - - - 26,000.00 - 000-493701 Proceeds-Holidazzle 12,500.00 10,120.00 14,500.00 10,070.00 - 2,430.00 80.56 000-493704 Moving on Main 4,000.00 - - - - 4,000.00 - 000-493707 Cornhole League 2,000.00 - - - - 2,000.00 - 000-494481 LawEnforcemtOfficersStnd&5,000.00 - - - - 5,000.00 - 000-495100 Mobile Stage Rental Fees - 1,550.00 - 1,550.00 - (1,550.00) - 000-497000 Misc Income-Gen Fund 60,000.00 8,438.66 7,746.02 8,438.66 - 51,561.34 14.06 000-497005 Schertz Magazine Advertising 145,000.00 32,918.75 34,852.50 32,918.75 - 112,081.25 22.70 000-497100 Misc Income-Police 9,000.00 1,805.00 1,646.11 1,805.00 - 7,195.00 20.06 000-497200 Misc Income-Library 3,000.00 1,352.75 650.00 1,352.75 - 1,647.25 45.09 000-497210 Misc Income-Library Copier 14,000.00 3,793.10 3,271.60 3,793.10 - 10,206.90 27.09 000-497300 Misc Income-Animal Control 500.00 630.00 - 630.00 - (130.00) 126.00 000-497400 Misc Income-Streets Dept 50,000.00 10,975.12 10,355.83 10,975.12 - 39,024.88 21.95 000-497500 Misc Income-TML Ins. Claims 25,000.00 15,068.47 830.26 15,068.47 - 9,931.53 60.27 000-497550 Misc Income-TML WC Reimbursmnt 10,000.00 155.01 22,201.62 155.01 - 9,844.99 1.55 000-497600 Misc Income-Vending Mach 1,600.00 411.60 493.60 411.60 - 1,188.40 25.73 000-497610 Misc Income-Muni Court - - 1.80 - - - - 000-498000 Reimbursmnt-Gen Fund 20,000.00 - - - - 20,000.00 - 000-498105 Reimbursmt Police OT-DEA 35,000.00 3,781.29 7,532.01 3,781.29 - 31,218.71 10.80 000-498110 Reimburmnt Fire-Emg Acti-OT 200,000.00 130,039.50 399,401.39 130,039.50 - 69,960.50 65.02 000-498150 Reimbursement - Library 7,000.00 - - - - 7,000.00 - TOTAL Miscellaneous 839,850.00 361,674.41 506,231.80 371,032.71 - 468,817.29 44.18% TOTAL REVENUES 44,982,410.00 15,629,538.51 14,212,041.77 15,638,296.81 (2,028.64) 29,346,141.83 34.76% Cash in Bank Claim on Operating Cash Pool-Checking 4,796,490.35$ Cash in Investments LOGIC Investment-General Fund 13,089,489.07 LOGIC Investment-Equip Replacement 81,910.95 LOGIC Investment-Veh Replacement 541,291.45 LOGIC Investment-Air Condi Replacment 295,349.34 CAPITAL ONE Investment-General Fund 1,405,625.92 CD - Bank of New York 253,122.82 CD - Capital One MCLEAN 253,580.92 CD - Capital One ALLEN 253,580.92 CD - Goldman Sachs 253,580.92 Total Cash in Bank & Investments 21,224,022.66$ GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 2022-23 1,012,285 1,191,635 1,032,144 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 - 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 2022-23 103,252 1,096,390 8,035,670 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 - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 9,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 2022-23 291,227 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 $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 CITY PUBLIC SERVICE 2022-23 2021-22 2020-21 2019-20 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 38,255.02 35,628.89 38,255.02 - (14,255.02) 159.40 TOTAL REVENUES 24,000.00 38,401.74 35,628.89 38,401.74 - (14,401.74) 160.01% EXPENDITURE SUMMARY GENERAL GOVERNMENT CULTURAL KICK CANCER 10,000.00 - - - - 10,000.00 - HAL BALDWIN SCHOLARSHIP 14,000.00 14,667.58 14,706.88 14,667.58 1,500.00 (2,167.58) 115.48 TOTAL CULTURAL 24,000.00 14,667.58 14,706.88 14,667.58 1,500.00 7,832.42 67.36% TOTAL EXPENDITURES 24,000.00 14,667.58 14,706.88 14,667.58 1,500.00 7,832.42 67.36% REVENUE OVER(UNDER) EXPEND - 23,734.16 20,922.01 23,734.16 (1,500.00) (22,234.16) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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 - 175.02 2.55 175.02 - (175.02) - 000-492200 Kick Cancer 10,000.00 - - - - 10,000.00 - 000-493621 Hal Baldwin Scholarship 14,000.00 38,080.00 35,626.34 38,080.00 - (24,080.00) 272.00 TOTAL Miscellaneous 24,000.00 38,255.02 35,628.89 38,255.02 - (14,255.02) 159.40% TOTAL REVENUES 24,000.00 38,255.02 35,628.89 38,255.02 - (14,255.02) 159.40% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 C I T Y O F S C H E R T Z Cash in Bank Current Claim on Operating Cash Pool-Checking 144,084.05$ Cash in Investments Texas Class- Special Events 18,370.56 Total Cash in Bank & Investments 162,454.61$ SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 90,000.00 15,162.38 20,581.45 15,162.38 - 74,837.62 16.85 Fund Transfers 854,770.00 - - - - 854,770.00 - TOTAL REVENUES 944,770.00 15,162.38 20,581.45 15,162.38 - 929,607.62 1.60% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental MISC & PROJECTS Projects Capital Outlay 854,770.00 105,072.95 - 105,072.95 502,435.63 247,261.42 71.07 TOTAL MISC & PROJECTS 914,770.00 105,072.95 - 105,072.95 502,435.63 307,261.42 66.41% TOTAL EXPENDITURES 914,770.00 105,072.95 - 105,072.95 502,435.63 307,261.42 66.41% REVENUE OVER(UNDER) EXPEND 30,000.00 (89,910.57) 20,581.45 (89,910.57) (502,435.63) 622,346.20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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,162.38 16,022.29 15,162.38 - 44,837.62 25.27 000-421465 AT&T PEG Fee 30,000.00 - 4,559.16 - - 30,000.00 - TOTAL Franchises 90,000.00 15,162.38 20,581.45 15,162.38 - 74,837.62 16.85% Fund Transfers 000-481000 Transfer In - Reserves 854,770.00 - - - - 854,770.00 - TOTAL Fund Transfers 854,770.00 - - - - 854,770.00 0.00% Miscellaneous TOTAL REVENUES 944,770.00 15,162.38 20,581.45 15,162.38 - 929,607.62 1.60% AS OF: December 31, 2022 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) Cash in Bank Cash Balance 776,417.31$ Total Cash in Bank & Investments 776,417.31$ PEG FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 400,000.00 4,521.69 54,278.33 4,521.69 - 395,478.31 1.13 Fees 27,487,000.00 7,583,908.83 6,874,051.64 7,583,908.83 - 19,903,091.17 27.59 Fund Transfers 150,000.00 37,500.00 37,500.00 37,500.00 - 112,500.00 25.00 Miscellaneous 448,858.00 175,733.17 91,132.78 175,733.17 - 273,124.83 39.15 TOTAL REVENUES 28,485,858.00 7,801,663.69 7,056,962.75 7,801,663.69 - 20,684,194.31 27.39% EXPENDITURE SUMMARY NON DEPARTMENTAL TOTAL NON DEPARTMENTAL - - - - - - 0.00% BUSINESS OFFICE Personnel Services 568,896.00 128,924.23 144,719.06 128,924.23 188.12 439,783.65 22.70 Supplies 213,090.63 641.62 4,542.78 641.62 571.30 211,877.71 0.57 City Support Services 67,300.00 41,238.36 36,064.69 41,238.36 9,460.00 16,601.64 75.33 Utility Services 11,500.00 1,128.73 1,769.26 1,128.73 - 10,371.27 9.82 Operations Support 120,000.00 20,404.44 24,183.10 20,404.44 92,645.71 6,949.85 94.21 Staff Support 8,700.00 1,151.68 1,190.61 1,151.68 1,430.09 6,118.23 29.68 Professional Services 273,000.00 41,943.69 55,924.18 41,943.69 - 231,056.31 15.36 Maintenance Services 18,700.00 - 1,260.00 - 420.00 18,280.00 2.25 Operating Equipment 600.00 - - - - 600.00 - TOTAL BUSINESS OFFICE 1,281,786.63 235,432.75 269,653.68 235,432.75 104,759.72 941,594.16 26.54% W & S ADMINISTRATION Personnel Services 2,027,484.00 424,941.79 441,870.42 424,941.79 522.22 1,602,019.99 20.98 Supplies 63,000.00 10,615.16 3,456.85 10,615.16 5,575.76 46,809.08 25.70 City Support Services 190,500.00 86,514.49 71,050.71 86,514.49 1,165.02 102,820.49 46.03 Utility Services 3,585,500.00 827,068.86 761,107.02 827,068.86 139.85 2,758,291.29 23.07 Operations Support 10,050.00 1,152.01 1,509.34 1,152.01 - 8,897.99 11.46 Staff Support 43,000.00 4,427.06 3,290.81 4,427.06 2,096.84 36,476.10 15.17 Professional Services 428,400.00 43,693.90 67,546.77 43,693.90 85,656.30 299,049.80 30.19 Fund Charges/Transfers 6,746,368.00 1,278,999.47 1,997,427.13 1,278,999.47 - 5,467,368.53 18.96 Maintenance Services 9,570,200.00 1,125,597.64 1,896,183.30 1,125,597.64 1,083,007.69 7,361,594.67 23.08 Other Costs 40,000.00 36,605.45 36,605.45 36,605.45 - 3,394.55 91.51 Debt Service 2,499,777.00 - - - - 2,499,777.00 - Rental/Leasing 72,275.00 626.56 26,076.94 626.56 19,775.05 51,873.39 28.23 Operating Equipment 7,000.00 4,327.64 485.54 4,327.64 137.39 2,534.97 63.79 Capital Outlay 261,400.00 193,006.13 32,158.31 193,006.13 462,771.65 (394,377.78) 250.87 TOTAL PUBLIC WORKS 25,544,954.00 4,037,576.16 5,338,808.59 4,037,576.16 1,660,847.77 19,846,530.07 22.31% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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: December 31, 2022 MISC & PROJECTS PROJECTS Professional Services - - - - 3,469.00 (3,469.00) - Fund Charges/Transfers - 326,181.00 - 326,181.00 - (326,181.00) - Maintenance Services - - - - 4,500.00 (4,500.00) - TOTAL PROJECTS - 326,181.00 - 326,181.00 7,969.00 (334,150.00) 0.00% SEWER PROJECT TOTAL SEWER PROJECTS - - - - - - 0.00% TOTAL MISC & PROJECTS - 326,181.00 - 326,181.00 7,969.00 (334,150.00) 0.00% TOTAL EXPENDITURES 26,826,740.63 4,599,189.91 5,608,462.27 4,599,189.91 1,773,576.49 20,453,974.23 23.76% ** REVENUE OVER(UNDER)EXPENSES **1,659,117.37 3,202,473.78 1,448,500.48 3,202,473.78 (1,773,576.49) 230,220.08 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 400,000.00 4,521.69 54,278.33 4,521.69 - 395,478.31 1.13 TOTAL Franchises 400,000.00 4,521.69 54,278.33 4,521.69 - 395,478.31 1.13% Permits TOTAL Permits - - - - - - 0.00% Fees 000-455200 Garbage Collection Fee 5,300,000.00 1,477,217.75 1,368,976.75 1,477,217.75 - 3,822,782.25 27.87 000-455600 Fire Line Fees 22,000.00 - - - - 22,000.00 - 000-455700 Recycle Fee Revenue 340,000.00 87,196.79 86,200.63 87,196.79 - 252,803.21 25.65 000-455800 W&S Line Constructn Reimbur 25,000.00 610.00 2,797.00 610.00 - 24,390.00 2.44 000-457100 Sale of Water 12,600,000.00 3,561,877.37 3,047,494.41 3,561,877.37 - 9,038,122.63 28.27 000-457110 Edwards Water Lease 40,000.00 - - - - 40,000.00 - 000-457120 Water Transfer Charge-Selma 15,000.00 - - - - 15,000.00 - 000-457200 Sale of Meters 100,000.00 19,448.77 12,174.55 19,448.77 - 80,551.23 19.45 000-457400 Sewer Charges 8,800,000.00 2,353,485.34 2,282,719.30 2,353,485.34 - 6,446,514.66 26.74 000-457500 Water Penalties 240,000.00 83,622.81 73,064.00 83,622.81 - 156,377.19 34.84 000-458110 Sale of Merchandise - GovDeals 2500.00 - - - - 2,500.00 - 000-459200 NSF Check Fee-Water&Sewer 2,500.00 450.00 625.00 450.00 - 2,050.00 18.00 TOTAL Fees 27,487,000.00 7,583,908.83 6,874,051.64 7,583,908.83 - 19,903,091.17 27.59% Fund Transfers 000-486204 Interfnd Chrg-Drainage Billing 150,000.00 37,500.00 37,500.00 37,500.00 - 112,500.00 25.00 TOTAL Fund Transfers 150,000.00 37,500.00 37,500.00 37,500.00 - 112,500.00 25.00% Miscellaneous 000-490000 Misc Charges 10,500.00 2,681.00 2,963.00 2,681.00 - 7,819.00 25.53 000-491000 Interest Earned 25,000.00 4,386.38 2,842.49 4,386.38 - 20,613.62 17.55 000-491200 Investment Income 100,000.00 82,998.21 996.71 82,998.21 - 17,001.79 83.00 000-497000 Misc Income-W&S 18,000.00 8,003.82 1,008.30 8,003.82 - 9,996.18 44.47 000-498110 Salary Reimb-SSLGC 295,358.00 77,663.76 83,322.29 77,663.76 - 217,694.24 26.29 000-499100 Distribution-GSE Bond Set - - (0.01) - - - - TOTAL Miscellaneous 448,858.00 175,733.17 91,132.78 175,733.17 - 273,124.83 39.15% TOTAL REVENUES 28,485,858.00 7,801,663.69 7,056,962.75 7,801,663.69 - 20,684,194.31 27.39% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 99,703.21$ Cash in Investments Lone Star Investment-Water&Sewer 8,622,710.93 Lone Star Investment-W&S Customer Deposits 323,362.66 Lone Star Investment-W&S Equip Replacement 194,420.88 Lone Star Investment-W&S Veh Replacement 280,858.58 Schertz Bank & Trust-Certificate of Deposit 1,174,984.58 10,596,337.63$ Total Cash in Bank & Investments 10,696,040.84$ WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 7,605,302.40 2,042,198.63 1,881,021.49 2,042,198.63 (570.00) 5,563,673.77 26.84 Inter-Jurisdictional 3,978,179.42 981,329.00 1,248,298.49 981,329.00 - 2,996,850.42 24.67 Fund Transfers 262,000.00 - - - - 262,000.00 - Miscellaneous 137,500.00 53,179.22 117,834.63 53,179.22 - 84,320.78 38.68 TOTAL REVENUES 11,982,981.82 3,076,706.85 3,247,154.61 3,076,706.85 (570.00) 8,906,844.97 25.67% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 6,238,590.00 1,574,533.63 1,577,796.38 1,574,533.63 1,363.60 4,662,692.77 25.26 Supplies 398,525.00 149,830.41 148,141.02 149,830.41 73,386.39 175,308.20 56.01 City Support Services 160,000.00 47,893.78 44,047.12 47,893.78 - 112,106.22 29.93 Utility Services 176,000.00 32,829.37 24,793.11 32,829.37 192.39 142,978.24 18.76 Operations Support 31,500.00 8,295.16 9,520.21 8,295.16 400.00 22,804.84 27.60 Staff Support 88,000.00 28,174.41 26,936.05 28,174.41 13,685.83 46,139.76 47.57 City Assistance 624,989.01 154,789.25 103,517.48 154,789.25 199.00 470,000.76 24.80 Professional Services 125,500.00 33,521.40 63,487.22 33,521.40 39,000.01 52,978.59 57.79 Fund Charges/Transfers 3,145,058.40 918,226.02 818,182.50 918,226.02 - 2,226,832.38 29.20 Maintenance Services 13,000.00 840.00 960.00 840.00 - 12,160.00 6.46 Rental/Leasing 150,000.00 - - - - 150,000.00 - Operating Equipment 120,500.00 12,078.66 4,909.78 12,078.66 23,177.08 85,244.26 29.26 Capital Outlay 710,000.00 56,901.85 517,571.78 56,901.85 535,144.21 117,953.94 83.39 TOTAL PUBLIC SAFETY 11,981,662.41 3,017,913.94 3,339,862.65 3,017,913.94 686,548.51 8,277,199.96 30.92% TOTAL EXPENDITURES 11,981,662.41 3,017,913.94 3,339,862.65 3,017,913.94 686,548.51 8,277,199.96 30.92% ** REVENUE OVER(UNDER) EXPENSES **1,319.41 58,792.91 (92,708.04) 58,792.91 (687,118.51) 629,645.01 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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 7,248,302.40 1,912,097.34 1,761,969.54 1,912,097.34 - 5,336,205.06 26.38 000-456110 Passport Membership Fees 26,000.00 19,015.00 20,545.00 19,015.00 (20.00) 7,005.00 73.06 000-456120 EMT Class - Fees 140,000.00 48,425.00 44,000.00 48,425.00 (550.00) 92,125.00 34.20 000-456122 CE Class - Fees 20,000.00 - - - - 20,000.00 - 000-456130 Immunization Fees 3,000.00 1,720.00 1,241.50 1,720.00 - 1,280.00 57.33 000-456140 Billing Fees-External 28,000.00 8,222.42 3,936.20 8,222.42 - 19,777.58 29.37 000-456150 Standby Fees 50,000.00 33,772.25 34,679.95 33,772.25 - 16,227.75 67.54 000-456155 Community Services Support 50,000.00 9,290.62 6,157.30 9,290.62 - 40,709.38 18.58 000-456160 MIH Services 40,000.00 9,656.00 8,442.00 9,656.00 - 30,344.00 24.14 000-459200 NSF Check Fee - - 50.00 - - - - TOTAL Fees 7,605,302.40 2,042,198.63 1,881,021.49 2,042,198.63 (570.00) 5,563,673.77 26.84% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 927,934.89 231,983.73 231,983.73 231,983.73 - 695,951.16 25.00 000-474200 JBSA Support 654,777.78 162,705.16 - 162,705.16 - 492,072.62 24.85 000-474300 Cibolo Support 557,333.70 139,333.43 132,260.99 139,333.43 - 418,000.27 25.00 000-475100 Comal Co ESD #6 132,247.05 - 35,952.30 - - 132,247.05 - 000-475200 Live Oak Support 273,764.40 68,441.10 70,060.23 68,441.10 - 205,323.30 25.00 000-475300 Universal City Support 345,554.30 86,388.58 83,971.22 86,388.58 - 259,165.72 25.00 000-475400 Selma Support 186,132.10 46,533.03 45,072.56 46,533.03 - 139,599.07 25.00 000-475500 Schertz Support 725,514.30 181,378.58 173,911.06 181,378.58 - 544,135.72 25.00 000-475600 Santa Clara Support 12,236.00 3,059.00 2,988.26 3,059.00 - 9,177.00 25.00 000-475800 Marion Support 22,684.90 5,671.23 5,340.97 5,671.23 - 17,013.67 25.00 000-475910 TASPP Program 140,000.00 55,835.16 466,757.17 55,835.16 - 84,164.84 39.88 TOTAL Inter-Jurisdictional 3,978,179.42 981,329.00 1,248,298.49 981,329.00 - 2,996,850.42 24.67% Fund Transfers - 000-486000 Transfer In-Reserves 262,000.00 - - - - 262,000.00 - TOTAL Fund Transfers 262,000.00 - - - - 262,000.00 0.00% Miscellaneous 000-491000 Interest Earned 1,500.00 2,244.48 75.03 2,244.48 - (744.48) 149.63 000-491200 Investment Income 4,000.00 6,911.23 111.14 6,911.23 - (2,911.23) 172.78 000-493203 Donations-EMS 2,000.00 455.00 650.00 455.00 - 1,545.00 22.75 000-497000 Misc Income 60,000.00 29,074.38 108,578.96 29,074.38 - 30,925.62 48.46 000-497100 Recovery of Bad Debt 20,000.00 3,834.39 392.58 3,834.39 - 16,165.61 19.17 000-497110 Collection Agency-Bad Debt 50,000.00 10,659.74 8,026.92 10,659.74 - 39,340.26 21.32 TOTAL Miscellaneous 137,500.00 53,179.22 117,834.63 53,179.22 - 84,320.78 38.68% TOTAL REVENUES 11,982,981.82 3,076,706.85 3,247,154.61 3,076,706.85 (570.00) 8,906,844.97 25.67% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 332,146.04$ Cash in Investments EMS-Logic 620,233.21 SR 2017 Ambulance-Logic - Total Cash in Bank & Investments 952,379.25$ C I T Y O F S C H E R T Z CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 7,000.00 5,550.00 2,250.00 5,550.00 - 1,450.00 79.29 Fees 1,258,500.00 315,500.50 312,530.57 315,500.50 - 942,999.50 25.07 Fund Transfers 182,573.00 - - - - 182,573.00 - Miscellaneous 2,000.00 5,485.67 106.17 5,485.67 - (3,485.67) 274.28 TOTAL REVENUES 1,450,073.00 326,536.17 314,886.74 326,536.17 - 1,123,536.83 22.52% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 525,214.00 129,562.56 102,450.28 129,562.56 147.56 395,503.88 24.70 Supplies 6,950.00 259.64 62.25 259.64 115.59 6,574.77 5.40 City Support Services 16,000.00 3,610.49 3,211.39 3,610.49 373.01 12,016.50 24.90 Utility Services 16,900.00 5,630.15 4,668.94 5,630.15 - 11,269.85 33.31 Staff Support 14,000.00 1,594.00 1,727.87 1,594.00 1,429.17 10,976.83 21.59 City Assistance 200.00 - 40.00 - - 200.00 - Professional Services 42,500.00 23,704.04 1,400.00 23,704.04 12,680.00 6,115.96 85.61 Fund Charges/Transfers 575,443.00 143,610.75 143,454.28 143,610.75 - 431,832.25 24.96 Maintenance Services 75,000.00 306.72 - 306.72 5,726.39 68,966.89 8.04 Other Costs 100.00 - - - - 100.00 - Operating Equipment 2,500.00 - - - - 2,500.00 - Capital Outlay 165,000.00 - - - - 165,000.00 - TOTAL DRAINAGE 1,439,807.00 308,278.35 257,015.01 308,278.35 20,471.72 1,111,056.93 22.83% PROJECTS Maintenance Services - - 26,517.40 - 7,980.95 (7,980.95) - TOTAL EXPENDITURES 1,439,807.00 308,278.35 283,532.41 308,278.35 28,452.67 1,103,075.98 23.39% ** REVENUE OVER(UNDER) EXPEND 10,266.00 18,257.82 31,354.33 18,257.82 (28,452.67) 20,460.85 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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 7,000.00 5,550.00 2,250.00 5,550.00 - 1,450.00 79.29 TOTAL Permits 7,000.00 5,550.00 2,250.00 5,550.00 - 1,450.00 79.29% Fees 000-457500 Drainage Penalties 8,500.00 2,713.00 2,206.87 2,713.00 - 5,787.00 31.92 000-457600 Drainage Fee 1,250,000.00 312,787.50 310,323.70 312,787.50 - 937,212.50 25.02 TOTAL Fees 1,258,500.00 315,500.50 312,530.57 315,500.50 - 942,999.50 25.07% Fund Transfers 000-481000 Transfer In - Reserves 165,000.00 - - - - 165,000.00 - 000-486101 Transfer In - General Fund 17,573.00 - - - - 17,573.00 - TOTAL Funds Transfers 182,573.00 - - - - 182,573.00 0.00% Miscellaneous 000-491000 Interest Earned 500.00 1,469.73 28.75 1,469.73 - (969.73) 293.95 000-491200 Investment Income 1,500.00 4,015.94 77.42 4,015.94 - (2,515.94) 267.73 TOTAL Miscellaneous 2,000.00 5,485.67 106.17 5,485.67 - (3,485.67) 274.28% TOTAL REVENUES 1,450,073.00 326,536.17 314,886.74 326,536.17 - 1,123,536.83 22.52% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 146,174.48$ Cash in Investments Lone Star Investment-Drainage Maint Fund 488,466.06 Total Cash in Bank & Investments 634,640.54$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 640,000.00 159,485.52 194,668.13 159,485.52 - 480,514.48 24.92 Miscellaneous 8,500.00 15,505.93 334.94 15,505.93 - (7,005.93) 182.42 TOTAL REVENUES 648,500.00 174,991.45 195,003.07 174,991.45 - 473,508.55 26.98% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 0.00 - - - - - - City Support Services 118,000.00 23,942.29 25,826.44 23,942.29 - 94,057.71 20.29 Operations Support 31,000.00 5,561.95 5,284.50 5,561.95 400.00 25,038.05 19.23 Professional Services 4,000.00 180.00 240.00 180.00 540.00 3,280.00 18.00 Fund Charges/Transfers 69,915.00 17,478.75 18,610.78 17,478.75 - 52,436.25 25.00 Maintenance Services 50,000.00 - 29.82 - - 50,000.00 - Operating Equipment - - 1,072.68 - - - - TOTAL NONDEPARTMENTAL 272,915.00 47,162.99 51,064.22 47,162.99 940.00 224,812.01 17.63% TOTAL GENERAL GOVERNMENT 272,915.00 47,162.99 51,064.22 47,162.99 940.00 224,812.01 17.63% MISC & PROJECTS PROJECTS Professional Services - 1,440.00 7,910.00 1,440.00 394.89 (1,834.89) - Maintenance Services - 40,997.22 - 40,997.22 - (40,997.22) - TOTAL PROJECTS - 42,437.22 7,910.00 42,437.22 394.89 (42,832.11) 0.00% TOTAL MISC & PROJECTS - 42,437.22 7,910.00 42,437.22 394.89 (42,832.11) 0.00% TOTAL EXPENDITURES 272,915.00 89,600.21 58,974.22 89,600.21 1,334.89 181,979.90 33.32% REVENUE OVER(UNDER) EXPENDITURE 375,585.00 85,391.24 136,028.85 85,391.24 (1,334.89) 291,528.65 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 50,459.78$ Cash in Investments Texas Class - Hotel Tax 1,644,597.32 Total Cash in Bank & Investments 1,695,057.10$ HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 AS OF: March 31, 2021 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2022-23 45,268 59,237 54,980 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 - 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 2,472.02 40.35 2,472.02 - (1,447.02) 241.17 TOTAL REVENUES 319,025.00 2,472.02 40.35 2,472.02 - 316,552.98 0.77% EXPENDITURE SUMMARY NON DEPARTMENTAL PARKLAND DEDICATION Professional Services 25,000.00 - - - - 25,000.00 - Capital Outlay 100,000.00 - - - - 100,000.00 - TOTAL PARKLAND DEDICATION 125,000.00 - - - - 125,000.00 0.00% TOTAL EXPENDITURES 125,000.00 - - - - 125,000.00 0.00% REVENUE OVER(UNDER) EXPEND 194,025.00 2,472.02 40.35 2,472.02 - 191,552.98 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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 82.70 0.30 82.70 - (57.70) 330.80 000-491200 Investment Income 1,000.00 2,389.32 40.05 2,389.32 - (1,389.32) 238.93 TOTAL Miscellaneous 1,025.00 2,472.02 40.35 2,472.02 - (1,447.02) 241.17% TOTAL REVENUES 319,025.00 2,472.02 40.35 2,472.02 - 316,552.98 0.77% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Current Claim on Operating Cash Pool-Checking 13,284.08 Cash in Investments Texas Class- Park Fund 250,709.99 Total in Investment Pool 250,709.99 Total Cash in Bank & Investments 263,994.07 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 16,315.00 56,992.50 16,315.00 - 53,685.00 23.31 Miscellaneous 1,400.00 6,770.51 104.95 6,770.51 - (5,370.51) 483.61 TOTAL REVENUES 71,400.00 23,085.51 57,097.45 23,085.51 - 48,314.49 32.33% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services 70,000.00 2,700.00 13,600.00 2,700.00 2,500.00 64,800.00 7.43 TOTAL TREE MITIGATION 70,000.00 2,700.00 13,600.00 2,700.00 2,500.00 64,800.00 7.43% TOTAL EXPENDITURES 70,000.00 2,700.00 13,600.00 2,700.00 2,500.00 64,800.00 7.43% REVENUE OVER(UNDER) EXPEND 1,400.00 20,385.51 43,497.45 20,385.51 (2,500.00) (16,485.51) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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 16,315.00 56,992.50 16,315.00 - 53,685.00 23.31 TOTAL Fees 70,000.00 16,315.00 56,992.50 16,315.00 - 53,685.00 23.31% Fund Transfers Miscellaneous 000-491000 Interest Earned 200.00 291.99 17.59 291.99 - (91.99) 146.00 000-491200 Investment Income 1,200.00 6,478.52 87.36 6,478.52 - (5,278.52) 539.88 TOTAL Miscellaneous 1,400.00 6,770.51 104.95 6,770.51 - (5,370.51) 483.61% TOTAL REVENUES 71,400.00 23,085.51 57,097.45 23,085.51 - 48,314.49 32.33% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking $20,828.45 Cash in Investments MBIA Investment-Tree Mitigation 707,616.31 Total Cash in Bank & Investments $728,444.76 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 175,255.00 151,434.00 175,255.00 - 924,745.00 15.93 Miscellaneous 51,500.00 48,212.24 1,848.88 48,212.24 - 3,287.76 93.62 TOTAL REVENUES 1,151,500.00 223,467.24 153,282.88 223,467.24 - 928,032.76 19.41% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL City Support Services 11,748.00 - - - - 11,748.00 - Professional Services 44,000.00 - 2,877.37 - 36,438.81 7,561.19 82.82 TOTAL NON DEPARTMENTAL 55,748.00 - 2,877.37 - 36,438.81 19,309.19 65.36% MISC & PROJECTS PROJECTS TOTAL MISC & PROJECTS - - - - - - 0.00% TOTAL EXPENDITURES 55,748.00 - 2,877.37 - 36,438.81 19,309.19 65.36% REVENUE OVER(UNDER) EXPENDITURES 1,095,752.00 223,467.24 150,405.51 223,467.24 (36,438.81) 908,723.57 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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 175,255.00 151,434.00 175,255.00 - 924,745.00 15.93 TOTAL Fees 1,100,000.00 175,255.00 151,434.00 175,255.00 - 924,745.00 15.93% Fund Transfers Miscellaneous - 000-491000 Interest Earned 1,500.00 610.17 52.01 610.17 - 889.83 40.68 000-491200 Investment Income 50,000.00 47,602.07 1,796.87 47,602.07 - 2,397.93 95.2 TOTAL Miscellaneous 51,500.00 48,212.24 1,848.88 48,212.24 - 3,287.76 93.62% TOTAL REVENUES 1,151,500.00 223,467.24 153,282.88 223,467.24 - 928,032.76 19.41% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 123,965.88$ Cash in Investments Lone Star Investment-Capital Recovery Water 4,986,185.24 Total Cash in Bank & Investments 5,110,151.12$ CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 550,000.00 81,188.90 68,955.12 81,188.90 - 468,811.10 14.76 Miscellaneous 51,500.00 65,680.57 1,663.55 65,680.57 - (14,180.57) 127.54 TOTAL REVENUES 601,500.00 146,869.47 70,618.67 146,869.47 - 454,630.53 24.42% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services - 1,153.28 - - - - - Fund Charges/Transfers 52,500.00 - 4,018.36 1,153.28 76,559.25 (25,212.53) 148.02 TOTAL NON DEPARTMENTAL 64,248.00 1,153.28 4,018.36 1,153.28 76,559.25 (13,464.53) 120.96% MISC & PROJECTS TOTAL EXPENDITURES 64,248.00 1,153.28 4,018.36 1,153.28 76,559.25 (13,464.53) 120.96% REVENUE OVER(UNDER) EXPENDITURES 537,252.00 145,716.19 66,600.31 145,716.19 (76,559.25) 468,095.06 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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 550,000.00 81,188.90 68,955.12 81,188.90 - 468,811.10 14.76 TOTAL Fees 550,000.00 81,188.90 68,955.12 81,188.90 - 468,811.10 14.76% Fund Transfers Miscellaneous 000-491000 Interest Earned 1,500.00 12,283.15 8.54 12,283.15 - (10,783.15) 818.88 000-491200 Investment Income 50,000.00 53,246.48 3,623.90 53,246.48 - (3,246.48) 106.49 000-491900 Unrealize Gain/Loss-Captl One - 150.94 (1,968.89) 150.94 - (150.94) - TOTAL Miscellaneous 51,500.00 65,680.57 1,663.55 65,680.57 - (14,180.57) 127.54% TOTAL REVENUES 601,500.00 146,869.47 70,618.67 146,869.47 - 454,630.53 24.42% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 1,214,685.69$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 4,577,409.07 Capital One-Investment 642,564.92 Total Cash in Bank & Investments 6,434,659.68$ CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 250,000.00 50,550.00 29,256.50 50,550.00 - 199,450.00 20.22 Fund Transfers 88,173.00 - - - - 88,173.00 - Miscellaneous 5,200.00 8,125.35 127.42 8,125.35 - (2,925.35) 156.26 TOTAL REVENUES 343,373.00 58,675.35 29,383.92 58,675.35 - 284,697.65 17.09% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 - 770.21 - - 5,000.00 - TOTAL NON DEPARTMENTAL 5,000.00 - 770.21 - - 5,000.00 0.00% MISC & PROJECTS City Support Services - 8,339.00 - 8,339.00 8,339.00 (16,678.00) - Maintenance Services 88,173.00 44,086.50 - 44,086.50 44,086.49 0.01 100.00 TOTAL MISC & PROJECTS 88,173.00 52,425.50 - 52,425.50 52,425.49 (16,677.99) 118.92% TOTAL EXPENDITURES 93,173.00 52,425.50 770.21 52,425.50 52,425.49 (11,677.99) 112.53% REVENUE OVER(UNDER) EXPENDITURES 250,200.00 6,249.85 28,613.71 6,249.85 (52,425.49) 296,375.64 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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-455921 CapitalRcvry-RoadwaysSrvAre 250,000.00 50,550.00 29,256.50 50,550.00 - 199,450.00 20.22 TOTAL Fees 250,000.00 50,550.00 29,256.50 50,550.00 - 199,450.00 20.22% Fund Transfers 000-481000 Transfer In - Reserves 88,173.00 - - - - 88,173.00 - TOTAL Fund Transfers 88,173.00 - - - - 88,173.00 0.00% Miscellaneous 000-491000 Interest Earned 200.00 92.59 6.31 92.59 - 107.41 46.30 000-491200 Investment Income 5,000.00 8,032.76 121.11 8,032.76 - (3,032.76) 160.66 TOTAL Miscellaneous 5,200.00 8,125.35 127.42 8,125.35 - (2,925.35) 156.26% TOTAL REVENUES 343,373.00 58,675.35 29,383.92 58,675.35 - 284,697.65 17.09% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 58.36$ Cash in Investments Lone Star Investment-Cap Rec Streets 1 812,162.42 Total Cash in Bank & Investments 812,220.78$ ROADWAY IMPACT FEE AREA 1 CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 200,000.00 30,765.20 27,535.31 30,765.20 - 169,234.80 15.38 Miscellaneous 1,600.00 5,525.62 65.15 5,525.62 - (3,925.62) 345.35 TOTAL REVENUES 201,600.00 36,290.82 27,600.46 36,290.82 - 165,309.18 18.00% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL City Assistance 50,000.00 - - - - 50,000.00 - Professional Services 5,000.00 - 2,749.18 - - 5,000.00 - TOTAL NON DEPARTMENTAL 55,000.00 - 2,749.18 - - 55,000.00 0.00% TOTAL EXPENDITURES 55,000.00 - 2,749.18 - - 55,000.00 0.00% REVENUE OVER(UNDER) EXPENDITURES 146,600.00 36,290.82 24,851.28 36,290.82 - 110,309.18 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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 200,000.00 30,765.20 27,535.31 30,765.20 - 169,234.80 15.38 TOTAL Fees 200,000.00 30,765.20 27,535.31 30,765.20 - 169,234.80 15.38% Fund Transfers Miscellaneous 000-491000 Interest Earned 100.00 32.23 5.26 32.23 - 67.77 32.23 000-491200 Investment Income 1,500.00 5,493.39 59.89 5,493.39 - (3,993.39) 366.23 TOTAL Miscellaneous 1,600.00 5,525.62 65.15 5,525.62 - (3,925.62) 345.35% TOTAL REVENUES 201,600.00 36,290.82 27,600.46 36,290.82 - 165,309.18 18.00% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 28,041.26$ Cash in Investments Lone Star Investment-Cap Rec Streets 2 572,277.31 Total Cash in Bank & Investments 600,318.57$ ROADWAY IMPACT FEE AREA 2 CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 375,000.00 84,250.00 91,201.00 84,250.00 - 290,750.00 22.47 Miscellaneous 5,050.00 12,001.77 225.10 12,001.77 - (6,951.77) 237.66 TOTAL REVENUES 380,050.00 96,251.77 91,426.10 96,251.77 - 283,798.23 25.33% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 - 2,749.18 - - 5,000.00 - TOTAL NON DEPARTMENTAL 5,000.00 - 2,749.18 - - 5,000.00 0.00% TOTAL EXPENDITURES 5,000.00 - 2,749.18 - - 5,000.00 0.00% REVENUE OVER(UNDER) EXPENDITURES 375,050.00 96,251.77 88,676.92 96,251.77 - 278,798.23 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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 375,000.00 84,250.00 91,201.00 84,250.00 - 290,750.00 22.47 TOTAL Fees 375,000.00 84,250.00 91,201.00 84,250.00 - 290,750.00 22.47% Fund Transfers Miscellaneous 000-491000 Interest Earned 50.00 129.84 7.66 129.84 - (79.84) 259.68 000-491200 Investment Income 5,000.00 11,871.93 217.44 11,871.93 - (6,871.93) 237.44 TOTAL Miscellaneous 5,050.00 12,001.77 225.10 12,001.77 - (6,951.77) 237.66% TOTAL REVENUES 380,050.00 96,251.77 91,426.10 96,251.77 - 283,798.23 25.33% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 3,851.50$ Cash in Investments Lone Star Investment-Cap Rec Streets 3 1,275,701.51 Total Cash in Bank & Investments 1,279,553.01$ ROADWAY IMPACT FEE AREA 3 CASH IN BANK AND INVESTMENTS AS OF: December 31, 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 3,000.00 - - - - 3,000.00 - Miscellaneous 40.00 95.96 2.03 95.96 - (55.96) 239.90 TOTAL REVENUES 3,040.00 95.96 2.03 95.96 - 2,944.04 3.16% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 3,000.00 - 2,749.18 - - 3,000.00 - TOTAL NON DEPARTMENTAL 3,000.00 - 2,749.18 - - 3,000.00 0.00% TOTAL EXPENDITURES 3,000.00 - 2,749.18 - - 3,000.00 0.00% REVENUE OVER(UNDER) EXPENDITURES 40.00 95.96 (2,747.15) 95.96 - (55.96) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 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 3,000.00 - - - - 3,000.00 - TOTAL Fees 3,000.00 - - - - 3,000.00 0.00% Fund Transfers Miscellaneous 000-491000 Interest Earned 10.00 2.32 - 2.32 - 7.68 23.20 000-491200 Investment Income 30.00 93.64 2.03 93.64 - (63.64) 312.13 TOTAL Miscellaneous 40.00 95.96 2.03 95.96 - (55.96) 239.90% TOTAL REVENUES 3,040.00 95.96 2.03 95.96 - 2,944.04 3.16% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 3,496.87$ Cash in Investments Lone Star Investment-Cap Rec Streets 4 9,646.02 Total Cash in Bank & Investments 13,142.89$ ROADWAY IMPACT FEE AREA 4 CASH IN BANK AND INVESTMENTS AS OF: December 31, 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,696,355.00 3,995,962.32 3,861,752.02 3,995,962.32 - 3,700,392.68 51.92 Fund Transfers 814,143.00 - - - - 814,143.00 - Miscellaneous 175,750.00 46,396.37 5,809.03 46,396.37 - 129,353.63 26.40 TOTAL REVENUES 8,686,248.00 4,042,358.69 3,867,561.05 4,042,358.69 - 4,643,889.31 46.54% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 84,000.00 800.00 45,293.39 800.00 200.00 83,000.00 1.19 Debt Service 8,602,248.00 - - - - 8,602,248.00 - TOTAL GENERAL GOVERNMENT 8,686,248.00 800.00 45,293.39 800.00 200.00 8,685,248.00 0.01% TOTAL EXPENDITURES 8,686,248.00 800.00 45,293.39 800.00 200.00 8,685,248.00 0.01% ** REVENUE OVER(UNDER) EXPEND - 4,041,558.69 3,822,267.66 4,041,558.69 (200.00) (4,041,358.69) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 , 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,696,355.00 3,995,962.32 3,861,752.02 3,995,962.32 - 3,700,392.68 51.92 TOTAL Taxes 7,696,355.00 3,995,962.32 3,861,752.02 3,995,962.32 - 3,700,392.68 51.92% Fund Transfers 000-481000 Transfer In - Reserves 814,143.00 - - - - 814,143.00 - TOTAL Fund Transfers 814,143.00 - - - - 814,143.00 0.00% Miscellaneous 000-491000 Interest Earned 750.00 1,479.13 21.35 1,479.13 - (729.13) 197.22 000-491200 Investment Income 75,000.00 19,917.24 169.93 19,917.24 - 55,082.76 26.56 000-495020 Contribution From YMCA 100,000.00 25,000.00 - 25,000.00 - 75,000.00 25.00 000-498000 Proceeds From Refunding Debt - - 5,617.75 - - - - TOTAL Miscellaneous 175,750.00 46,396.37 5,809.03 46,396.37 - 129,353.63 26.40% TOTAL REVENUES 8,686,248.00 4,042,358.69 3,867,561.05 4,042,358.69 - 4,643,889.31 46.54% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31 , 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 4,000.00 800.00 600.00 800.00 200.00 3,000.00 25.00 101-541502 Cost of Bond Issuance 80,000.00 - 44,693.39 - - 80,000.00 - TOTAL Professional Services 84,000.00 800.00 45,293.39 800.00 200.00 83,000.00 1.19% Debt Service 101-555629 Bond-GO 2007 Principal 355,000.00 - - - - 355,000.00 - 101-555629.1 Bond-GO 2007 Interest 71,123.00 - - - - 71,123.00 - 101-555638 Bond-GO 2014 Refund-Principal 775,000.00 - - - - 775,000.00 - 101-555638.1 Bond-GO 2014 Refund-Interest 245,150.00 - - - - 245,150.00 - 101-555640.1 Bond-GO Ref 2015-Interest 37,050.00 - - - - 37,050.00 - 101-555642 Bond-GO SR2016-Principal 255,000.00 - - - - 255,000.00 - 101-555642.1 Bond-GO SR2016-Interest 121,606.00 - - - - 121,606.00 - 101-555643 Bond-TaxableB CO SR2016-Princi 65,000.00 - - - - 65,000.00 - 101-555643.1 Bond-Taxable CO SR2016-Interes 38,388.00 - - - - 38,388.00 - 101-555644 Bond-NonTaxA CO SR2016-Princip 205,000.00 - - - - 205,000.00 - 101-555644.1 Bond-NonTax CO SR2016-Interest 32,469.00 - - - - 32,469.00 - 101-555645 Bond-CO SR2017-Principal 315,000.00 - - - - 315,000.00 - 101-555645.1 Bond-CO SR2017 - Interest 103,400.00 - - - - 103,400.00 - 101-555646 Bond-GO SR2017 - Principal 170,000.00 - - - - 170,000.00 - 101-555646.1 Bond-GO SR2017 - Interest 95,025.00 - - - - 95,025.00 - 101-555647 Bond-GO 2018 Refund- Principal 595,000.00 - - - - 595,000.00 - 101-555647.1 Bond-GO 2018 Refund - Interest 73,617.00 - - - - 73,617.00 - 101-555648 Bond-CO SR2018 - Principal 260,000.00 - - - - 260,000.00 - 101-555648.1 Bond-CO 2018 - Interest 151,263.00 - - - - 151,263.00 - 101-555649 Bond-GO 2018 Ref - Principal 205,000.00 - - - - 205,000.00 - 101-555649.1 Bond-GO 2018 Ref - Interest 172,069.00 - - - - 172,069.00 - 101-555650 Bond-CO 2019-Principal 275,000.00 - - - - 275,000.00 - 101-555650.1 Bond-CO 2019-Interest 106,800.00 - - - - 106,800.00 - 101-555651 Bond-GO 2020-Principal 960,000.00 - - - - 960,000.00 - 101-555651.1 Bond-GO 2020-Interest 174,063.00 - - - - 174,063.00 - 101-555652 Bond-GO 2021 Ref - Principal 350,000.00 - - - - 350,000.00 - 101-555652.1 Bond-GO 2021 Ref - Interest 124,800.00 - - - - 124,800.00 - 101-555653 Bond-CO 2022 - Principal 175,000.00 - - - - 175,000.00 - 101-555653.1 Bond-CO 2022 - Interest 166,525.00 - - - - 166,525.00 - 101-555654 Bond-CO 2022A - Principal 595,000.00 - - - - 595,000.00 - 101-555655 Bond-GO 2022 - Principal 1,333,900.00 - - - - 1,333,900.00 - TOTAL Debt Service 8,602,248.00 - - - - 8,602,248.00 0.00% Other Financing Sources TOTAL EXPENDITURES 8,686,248.00 800.00 45,293.39 800.00 200.00 8,685,248.00 0.01% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 , 2022 Cash in Bank Claim on Operating Cash Pool-Checking 204,445.78$ MBIA Investment- Tax I&S 5,701,521.55 Total Cash in Bank & Investments 5,905,967.33$ TAX I&S CASH IN BANK AND INVESTMENTS AS OF: December 31 , 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 6,548,000.00 1,621,603.00 1,435,398.73 1,621,603.00 - 4,926,397.00 24.76 Fund Transfers 3,320,960.00 - - - - 3,320,960.00 - Miscellaneous 182,000.00 223,904.77 5,273.47 223,904.77 - (41,904.77) 123.02 TOTAL REVENUES 10,050,960.00 1,845,507.77 1,440,672.20 1,845,507.77 - 8,205,452.23 18.36% EXPENDITURE SUMMARY NONDEPARTMENTAL City Assistance 3,000,079.00 50,000.00 - 50,000.00 - 2,950,079.00 1.67 Fund Charges/Transfers 5,750,000.00 - - - - 5,750,000.00 - TOTAL NONDEPARTMENTAL 8,750,079.00 50,000.00 - 50,000.00 - 8,700,079.00 0.57% MISC & PROJECTS PROJECTS ECONOMIC DEVELOPMENT Supplies 1,000.00 141.24 512.61 141.24 110.82 747.94 25.21 City Support Services 20,000.00 4,482.67 1,460.68 4,482.67 - 15,517.33 22.41 Utility Services 2,975.00 49.00 127.17 49.00 - 2,926.00 1.65 Operations Support 437,610.00 35,749.55 31,178.91 35,749.55 15,393.57 386,466.88 11.69 Staff Support 25,775.00 4,451.64 (264.40) 4,451.64 1,737.88 19,585.48 24.01 City Assistance 205,000.00 3,050.00 - 3,050.00 - 201,950.00 1.49 Professional Services 61,300.00 2,028.00 1,872.00 2,028.00 - 59,272.00 3.31 Fund Charges/Transfers 542,221.00 271,110.50 253,492.00 271,110.50 - 271,110.50 50.00 Operating Equipment 5,000.00 26.89 2,179.94 26.89 251.23 4,721.88 5.56 TOTAL ECONO DEVELOPMENT 1,300,881.00 321,089.49 290,558.91 321,089.49 17,493.50 962,298.01 26.03% FM3009 ROAD&BRIDGE EXPANSION TOTAL EXPENDITURES 10,050,960.00 371,089.49 290,558.91 371,089.49 17,493.50 9,662,377.01 3.87% ** REVENUE OVER(UNDER) EXPEND - 1,474,418.28 1,150,113.29 1,474,418.28 (17,493.50) (1,456,924.78) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 317,010.10$ Cash in Investments Texas Class Investment-Economic Development Corp 23,921,120.17 Schertz Bank & Trust-Certificate of Deposit 1,091,353.64 Schertz Bank & Trust-Certificate of Deposit 1,138,328.37 Total Cash in Bank & Investments 26,467,812.28$ SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022