Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Q1 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 41,490,207.00 14,215,180.99 0.00 27,275,026.01 34.26% Total General Government 7,113,358.00 1,423,086.93 301,004.80 5,389,266.27 24.24% Total Public Safety 18,411,831.54 4,694,040.28 2,125,982.91 11,591,808.35 37.04% Total Public Environment 2,037,970.00 335,729.56 191,127.41 1,511,113.03 25.85% Total Parks & Recreation 2,748,554.00 534,461.27 76,226.71 2,137,866.02 22.22% Total Cultural 1,163,373.00 334,629.02 6,029.40 822,714.58 29.28% Total Internal Services 7,722,891.00 1,493,334.92 715,579.93 5,513,976.15 28.60% Total Misc & Projects 2,292,230.00 49,458.75 2,500.00 2,240,271.25 2.27% Total Expenditures 41,490,207.54 8,864,740.73 3,418,451.16 29,207,015.65 29.61% Revenue Over(Under) Expenditures 0.54 5,350,440.26 (3,418,451.16)(1,931,989.64) General Fund, 101 Total Cash in Bank & Investments 20,425,081.02 Special Events Fund, 106 Total Revenues 24,000.00 35,628.89 0.00 (11,628.89)148.45% Total Expenditures 24,000.00 14,706.88 0.00 9,293.12 61.28% Revenue Over(Under) Expenditures 0.00 20,922.01 0.00 (20,922.01) Special Events Fund, 106 Total Cash in Bank & Investments 141,768.82 Peg Fund, 110 Total Revenues 350,000.00 20,581.45 0.00 329,418.55 5.88% Total Expenditures 350,000.00 0.00 0.00 350,000.00 0.00% Revenue Over(Under) Expenditures 0.00 20,581.45 0.00 (20,581.45) Peg Fund, 110 Total Cash in Bank & Investments 967,035.50 Water & Sewer, 202 Total Revenues 28,758,723.00 7,056,962.75 0.00 21,701,760.25 24.54% Total Expenditures 25,921,362.00 5,635,350.61 1,336,527.56 18,949,483.83 26.90% Revenue Over(Under) Expenditures 2,837,361.00 1,421,612.14 (1,336,527.56)2,752,276.42 Water & Sewer, 202 Total Cash in Bank & Investments 6,991,637.34 Quarterly Statement Schertz, Texas AS OF :December 31, 2021 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 EMS, 203 Total Revenues 11,794,594.14 3,247,154.61 0.00 8,547,439.53 27.53% Total Expenditures 11,736,093.61 3,396,790.65 456,642.16 7,882,660.80 32.83% Revenue Over(Under) Expenditures 58,500.53 (149,636.04)(456,642.16)664,778.73 EMS, 203 Total Cash in Bank & Investments 970,564.99 Drainage, 204 Total Revenues 1,284,229.00 314,886.74 0.00 969,342.26 24.52% Total Expenditures 1,272,024.00 289,985.61 26,685.11 955,353.28 24.90% Revenue Over(Under) Expenditures 12,205.00 24,901.13 (26,685.11)13,988.98 Drainage, 204 Total Cash in Bank & Investments 418,882.34 Hotel Tax, 314 Total Revenues 1,675,250.00 195,003.07 0.00 1,480,246.93 11.64% Total Expenditures 1,579,797.00 58,974.22 133,847.56 1,386,975.22 12.21% Revenue Over(Under) Expenditures 95,453.00 136,028.85 (133,847.56)93,271.71 Hotel Tax, 314 Total Cash in Bank & Investments 2,372,801.86 Park, 317 Total Revenues 319,025.00 40.35 0.00 318,984.65 0.01% Total Expenditures 125,000.00 0.00 0.00 125,000.00 0.00% Revenue Over(Under) Expenditures 194,025.00 40.35 0.00 193,984.65 Park, 317 Total Cash in Bank & Investments 287,057.71 Tree Mitigation, 319 Total Revenues 71,400.00 57,097.45 0.00 14,302.55 79.97% Total Expenditures 70,000.00 13,600.00 2,700.00 53,700.00 23.29% Revenue Over(Under) Expenditures 1,400.00 43,497.45 (2,700.00)(39,397.45) Tree Mitigation, 319 Total Cash in Bank & Investments 691,392.66 Capital Recovery Water, 411 Total Revenues 1,116,000.00 153,282.88 0.00 962,717.12 13.74% Total Expenditures 51,000.00 2,877.37 78,417.12 (30,294.49)159.40% Revenue Over(Under) Expenditures 1,065,000.00 150,405.51 (78,417.12)993,011.61 Capital Recovery Water, 411 Total Cash in Bank & Investments 8,407,270.31 Quarterly Statement Schertz, Texas AS OF :December 31, 2021 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 Capital Recovery Sewer, 421 Total Revenues 660,250.00 70,583.52 0.00 589,666.48 10.69% Total Expenditures 55,500.00 4,018.36 97,902.49 (46,420.85)183.64% Revenue Over(Under) Expenditures 604,750.00 66,565.16 (97,902.49)636,087.33 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 178,435.38 I&S, 505 Total Revenues 7,434,862.00 3,867,561.05 0.00 3,567,300.95 52.02% Total Expenditures 6,676,915.00 45,293.39 1,982,996.88 4,648,624.73 30.38% Revenue Over(Under) Expenditures 757,947.00 3,822,267.66 (1,982,996.88)(1,081,323.78) I&S, 505 Total Cash in Bank & Investments 4,909,644.33 SED Corporation, 620 Total Revenues 6,789,000.00 1,440,672.20 0.00 5,348,327.80 21.22% Total Expenditures 5,540,707.00 290,558.91 22,441.66 5,227,706.43 5.65% Revenue Over(Under) Expenditures 1,248,293.00 1,150,113.29 (22,441.66)120,621.37 SED Corporation, 620 Total Cash in Bank & Investments 21,931,784.88 Total Cash in Bank & Investments 68,693,357.14 Quarterly Statement Schertz, Texas AS OF :December 31, 2021 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 27,845,000.00 11,359,925.15 10,563,282.53 11,359,925.15 - 16,485,074.85 40.80 Franchises 2,327,000.00 561,441.05 548,228.60 561,441.05 - 1,765,558.95 24.13 Permits 1,718,150.00 308,416.32 410,000.42 308,416.32 - 1,409,733.68 17.95 Licenses 49,320.00 10,355.00 11,270.00 10,355.00 - 38,965.00 21.00 Fees 2,232,459.00 435,955.63 451,845.34 435,955.63 - 1,796,503.37 19.53 Fines 9,000.00 2,270.68 1,208.98 2,270.68 - 6,729.32 25.23 Inter-Jurisdictional 990,598.00 129,221.05 123,755.48 129,221.05 - 861,376.95 13.04 Fund Transfers 5,612,630.00 898,225.09 812,911.78 898,225.09 - 4,714,404.91 16.00 Miscellaneous 706,050.00 509,371.02 105,260.78 509,371.02 - 196,678.98 72.14 TOTAL REVENUES 41,490,207.00 14,215,180.99 13,027,763.91 14,215,180.99 - 27,275,026.01 34.26% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 38,102.00 10,191.30 10,197.07 10,191.30 14.40 27,896.30 26.79 Supplies 750.00 79.95 139.40 79.95 200.00 470.05 37.33 City Support Services 55,500.00 20,678.85 36,998.85 20,678.85 2,188.90 32,632.25 41.20 Operations Support 300.00 - 23.50 - - 300.00 0.00 Staff Support 28,600.00 10,364.77 9,263.55 10,364.77 320.15 17,915.08 37.36 Professional Services 6,000.00 - - - - 6,000.00 0.00 TOTAL CITY COUNCIL 129,252.00 41,314.87 56,622.37 41,314.87 2,723.45 85,213.68 34.07% CITY MANAGER Personnel Services 1,260,763.00 301,848.98 314,144.59 301,848.98 - 958,914.02 23.94 Supplies 2,000.00 320.43 115.81 320.43 - 1,679.57 16.02 City Support Services 2,000.00 - - - - 2,000.00 - Operations Support 50.00 - - - - 50.00 - Staff Support 24,775.00 5,540.17 2,145.00 5,540.17 740.60 18,494.23 25.35 Professional Services 13,641.21 - - - - 13,641.21 - Operating Equipment - - 1,200.00 - - - - Capital Outlay 44,000.00 - - - 43,581.78 418.22 99.05 TOTAL CITY MANAGER 1,347,229.21 307,709.58 317,605.40 307,709.58 44,322.38 995,197.25 26.13% MUNICIPAL COURT Personnel Services 306,228.00 93,058.28 81,000.14 93,058.28 - 213,169.72 30.39 Supplies 1,500.00 60.00 424.89 60.00 104.97 1,335.03 11.00 City Support Services 500.00 118.68 123.86 118.68 - 381.32 23.74 Operations Support 2,000.00 - - - - 2,000.00 - C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 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, 2021 Staff Support 6,910.00 - 74.89 - 354.63 6,555.37 5.13 Court Support 3,000.00 132.00 - 132.00 - 2,868.00 4.40 Professional Services 61,700.00 10,300.00 9,132.50 10,300.00 53,900.00 (2,500.00) 104.05 Maintenance Services 3,000.00 450.00 550.00 450.00 1,800.00 750.00 75.00 Operating Equipment 4,000.00 - - - - 4,000.00 - TOTAL MUNICIPAL COURT 388,838.00 104,118.96 91,306.28 104,118.96 56,159.60 228,559.44 41.22% CUSTOMER RELATIONS-311 Personnel Services 116,705.00 35,011.21 30,889.96 35,011.21 - 81,693.79 30.00 Supplies 100.00 17.02 12.47 17.02 - 82.98 17.02 Staff Support 430.00 32.28 66.94 32.28 - 397.72 7.51 TOTAL CUSTOMER RELATIONS-311 117,235.00 35,060.51 30,969.37 35,060.51 - 82,174.49 29.91% PLANNING & ZONING Personnel Services 289,769.00 46,033.98 54,565.83 46,033.98 - 243,735.02 15.89 Supplies 2,020.00 240.86 138.29 240.86 (47.18) 1,826.32 9.59 Operations Support 248.00 - 7.60 - - 248.00 - Staff Support 33,939.00 1,334.70 632.00 1,334.70 100.00 32,504.30 4.23 Professional Services 400,100.00 - 5.00 - - 400,100.00 - Operating Equipment 1,639.00 285.47 6,075.83 285.47 - 1,353.53 17.42 TOTAL PLANNING & ZONING 727,715.00 47,895.01 61,424.55 47,895.01 52.82 679,767.17 6.59% LEGAL SERVICES Operations Support 10,000.00 - 2,256.91 - 295.00 9,705.00 2.95 Professional Services 130,000.00 4,050.50 16,981.05 4,050.50 - 125,949.50 3.12 TOTAL LEGAL SERVICES 140,000.00 4,050.50 19,237.96 4,050.50 295.00 135,654.50 3.10% CITY SECRETARY Personnel Services 197,509.00 56,768.57 52,546.95 56,768.57 - 140,740.43 28.74 Supplies 1,150.00 235.13 409.65 235.13 35.60 879.27 23.54 City Support Services 10,000.00 1,920.02 - 1,920.02 - 8,079.98 19.20 Operations Support 150.00 - - - - 150.00 - Staff Support 6,450.00 1,262.57 982.40 1,262.57 - 5,187.43 19.57 Operating Equipment 1,000.00 - - - - 1,000.00 - TOTAL CITY SECRETARY 216,259.00 60,186.29 53,939.00 60,186.29 35.60 156,037.11 27.85% NON-DEPARTMENTAL City Support Services 856,310.79 370,776.84 322,616.42 370,776.84 176,010.54 309,523.41 63.85 Operations Support 140,000.00 27,293.31 38,344.62 27,293.31 1,408.82 111,297.87 20.50 City Assistance 1,315,645.00 - 186,762.17 - - 1,315,645.00 - Professional Services 88,775.00 12,978.28 25,030.53 12,978.28 300.00 75,496.72 14.96 Fund Chrgs/Transfrs-Spec Events Fnd 27,979.00 - - - - 27,979.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: December 31, 2021 Capital Outlay 0.00 - - - - - - TOTAL NON-DEPARTMENTAL 2,428,709.79 411,048.43 572,753.74 411,048.43 177,719.36 1,839,942.00 24.24% PUBLIC AFFAIRS Personnel Services 325,481.00 94,803.47 83,183.60 94,803.47 - 230,677.53 29.13 Supplies 1,100.00 351.61 420.61 351.61 28.68 719.71 34.57 City Support Services 1,000.00 - - - - 1,000.00 - Operations Support 48,235.00 6,903.71 749.13 6,903.71 - 41,331.29 14.31 Staff Support 11,170.00 423.32 35.64 423.32 125.91 10,620.77 4.92 Professional Services 271,500.00 87,408.00 44,695.76 87,408.00 4,000.00 180,092.00 33.67 TOTAL PUBLIC AFFAIRS 658,486.00 189,890.11 129,084.74 189,890.11 4,154.59 464,441.30 29.47% ENGINEERING Personnel Services 879,409.00 211,700.53 206,077.07 211,700.53 - 667,708.47 24.07 Supplies 2,750.00 163.09 100.30 163.09 - 2,586.91 5.93 City Support Services 1,265.00 - - - - 1,265.00 - Utility Services 5,500.00 581.00 1,035.40 581.00 - 4,919.00 10.56 Operations Support 150.00 - - - - 150.00 - Staff Support 16,045.00 75.00 557.82 75.00 200.00 15,770.00 1.71 Professional Services 53,115.00 9,293.05 - 9,293.05 15,342.00 28,479.95 46.38 Operating Equipment 1,400.00 - 25,783.61 - - 1,400.00 - TOTAL ENGINEERING 959,634.00 221,812.67 233,554.20 221,812.67 15,542.00 722,279.33 24.73% TOTAL GENERAL GOVERNMENT 7,113,358.00 1,423,086.93 1,566,497.61 1,423,086.93 301,004.80 5,389,266.27 24.24% PUBLIC SAFETY POLICE Personnel Services 8,812,715.00 2,495,619.21 2,399,852.23 2,495,619.21 - 6,317,095.79 28.32 Supplies 110,557.91 23,578.22 5,710.69 23,578.22 2,399.74 84,579.95 23.50 City Support Services 26,500.00 33,969.74 32,020.24 33,969.74 - (7,469.74) 128.19 Utility Services 193,200.00 27,462.19 26,050.42 27,462.19 - 165,737.81 14.21 Operations Support 30,316.00 821.80 738.00 821.80 411.84 29,082.36 4.07 Staff Support 164,030.83 26,164.16 21,768.41 26,164.16 20,639.70 117,226.97 28.53 City Assistance 60,300.00 8,952.04 678.55 8,952.04 - 51,347.96 14.85 Professional Services 85,266.20 21,656.91 21,317.30 21,656.91 9,313.88 54,295.41 36.32 Maintenance Services 77,305.00 5,207.50 6,588.99 5,207.50 775.00 71,322.50 7.74 Operating Equipment 192,687.60 25,351.86 78,348.79 25,351.86 28,959.47 138,376.27 28.19 Capital Outlay 542,637.00 5,390.00 5,600.56 5,390.00 390,312.97 146,934.03 72.92 TOTAL POLICE 10,295,515.54 2,674,173.63 2,598,674.18 2,674,173.63 452,812.60 7,168,529.31 30.37% FIRE RESCUE 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, 2021 Personnel Services 5,536,677.00 1,597,284.13 1,567,846.12 1,597,284.13 - 3,939,392.87 28.85 Supplies 22,555.00 2,488.56 516.19 2,488.56 633.22 19,433.22 13.84 Utility Services 80,000.00 14,387.50 14,106.52 14,387.50 - 65,612.50 17.98 Operations Support 4,527.00 1,527.45 157.73 1,527.45 - 2,999.55 33.74 Staff Support 205,772.00 22,373.36 9,888.42 22,373.36 38,305.94 145,092.70 29.49 City Assistance 25,198.00 2,483.23 878.09 2,483.23 3,761.10 18,953.67 24.78 Professional Services 63,600.00 10,838.86 14,102.43 10,838.86 - 52,761.14 17.04 Maintenance Services 81,500.00 2,203.18 17,306.64 2,203.18 3,375.68 75,921.14 6.85 Other Costs 10,000.00 - 5,078.41 - - 10,000.00 - Rental/Leasing 27,000.00 - - - - 27,000.00 - Operating Equipment 120,000.00 6,921.69 47,354.82 6,921.69 2,999.99 110,078.32 8.27 Capital Outlay 473,637.00 - 385.00 - 1,572,950.81 (1,099,313.81) 332.10 TOTAL FIRE RESCUE 6,650,466.00 1,660,507.96 1,677,620.37 1,660,507.96 1,622,026.74 3,367,931.30 49.36% INSPECTIONS Personnel Services 961,954.00 268,274.75 235,831.42 268,274.75 - 693,679.25 27.89 Supplies 5,100.00 93.00 201.10 93.00 - 5,007.00 1.82 Utility Services 8,400.00 1,198.25 1,037.71 1,198.25 - 7,201.75 14.26 Operations Support 850.00 - - - - 850.00 - Staff Support 41,446.00 2,347.44 475.52 2,347.44 627.57 38,470.99 7.18 Professional Services 70,000.00 600.00 15,400.00 600.00 48,400.00 21,000.00 70.00 Operating Equipment 650.00 570.94 - 570.94 - 79.06 87.84 Capital Outlay - - 27,381.00 - - - - TOTAL INSPECTIONS 1,088,400.00 273,084.38 280,326.75 273,084.38 49,027.57 766,288.05 29.59% NEIGHBORHOOD SERVICES Personnel Services 312,294.00 81,852.74 - 81,852.74 - 230,441.26 26.21 Supplies 4,519.00 814.51 - 814.51 - 3,704.49 18.02 Utility Services 15,000.00 480.00 - 480.00 - 14,520.00 3.20 Operations Support 3,419.00 - - - - 3,419.00 - Staff Support 23,393.00 891.59 - 891.59 516.00 21,985.41 6.02 Professional Services 2,500.00 - - - - 2,500.00 - Maintenance Services 16,000.00 1,950.00 - 1,950.00 1,600.00 12,450.00 22.19 Operating Equipment 325.00 285.47 - 285.47 - 39.53 87.84 TOTAL NEIGHBORHOOD SERVICES 377,450.00 86,274.31 - 86,274.31 2,116.00 289,059.69 23.42% TOTAL PUBLIC SAFETY 18,411,831.54 4,694,040.28 4,556,621.30 4,694,040.28 2,125,982.91 11,591,808.35 37.04% PUBLIC ENVIRONMENT STREETS Personnel Services 1,009,600.00 280,050.89 221,044.19 280,050.89 1,149.57 728,399.54 27.85 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, 2021 Supplies 167,950.00 16,723.52 28,265.19 16,723.52 11,064.78 140,161.70 16.55 City Support Services 6,000.00 411.45 - 411.45 453.10 5,135.45 14.41 Utility Services 180,600.00 31,994.77 31,720.37 31,994.77 - 148,605.23 17.72 Staff Support 22,120.00 1,571.78 2,159.19 1,571.78 389.20 20,159.02 8.87 Professional Services 20,000.00 - 530.00 - 7,536.10 12,463.90 37.68 Maintenance Services 396,500.00 2,591.00 56,780.50 2,591.00 12,294.40 381,614.60 3.75 Rental/Lease 5,000.00 - - - - 5,000.00 - Operating Equipment 71,000.00 2,386.15 1,059.64 2,386.15 (1,804.97) 70,418.82 0.82 Capital Outlay 159,200.00 - - - 160,045.23 (845.23) 100.53 TOTAL STREETS 2,037,970.00 335,729.56 341,559.08 335,729.56 191,127.41 1,511,113.03 25.85% TOTAL PUBLIC ENVIRONMENT 2,037,970.00 335,729.56 341,559.08 335,729.56 191,127.41 1,511,113.03 25.85% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 758,970.00 202,008.92 154,806.40 202,008.92 - 556,961.08 26.62 Supplies 113,148.00 14,100.85 25,804.34 14,100.85 5,457.58 93,589.57 17.29 City Support Services 136,000.00 42,355.74 50,534.99 42,355.74 5,256.74 88,387.52 35.01 Utility Services 246,000.00 32,974.33 35,325.87 32,974.33 12,281.01 200,744.66 18.40 Operations Support 2,000.00 - 122.92 - - 2,000.00 - Staff Support 19,670.00 4,984.33 2,390.35 4,984.33 - 14,685.67 25.34 Professional Services 147,946.00 35,292.90 27,214.30 35,292.90 - 112,653.10 23.86 Maintenance Services 14,000.00 1,798.72 53,592.61 1,798.72 2,945.15 9,256.13 33.88 Rental/Leasing 10,000.00 1,041.72 2,048.92 1,041.72 862.94 8,095.34 19.05 Operating Equipment 65,000.00 8,049.36 7,950.08 8,049.36 3,986.39 52,964.25 18.52 Capital Outlay 280,997.00 - - - 40,587.00 240,410.00 14.44 TOTAL PARKS DEPARTMENT 1,793,731.00 342,606.87 359,790.78 342,606.87 71,376.81 1,379,747.32 23.08% SWIM POOL Supplies 25,500.00 - 22.36 - 2,880.00 22,620.00 11.29 Utility Services 16,500.00 2,571.43 2,388.02 2,571.43 543.70 13,384.87 18.88 Maintenance Services 527,878.00 97,339.35 81,589.98 97,339.35 - 430,538.65 18.44 TOTAL SWIM POOL 569,878.00 99,910.78 84,000.36 99,910.78 3,423.70 466,543.52 18.13% EVENT FACILITIES Personnel Services 284,722.00 79,964.63 51,148.80 79,964.63 - 204,757.37 28.09 Supplies 6,150.00 469.40 1,079.93 469.40 298.23 5,382.37 12.48 Utility Services 48,600.00 6,029.35 4,516.86 6,029.35 - 42,570.65 12.41 Operations Support 15,908.00 61.72 1,808.64 61.72 - 15,846.28 0.39 Staff Support 4,865.00 293.44 191.56 293.44 152.88 4,418.68 9.17 Maintenance Services 12,700.00 1,633.94 - 1,633.94 - 11,066.06 12.87 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, 2021 Operating Equipment 12,000.00 3,491.14 726.00 3,491.14 975.09 7,533.77 37.22 TOTAL EVENT FACILITIES 384,945.00 91,943.62 59,471.79 91,943.62 1,426.20 291,575.18 24.26% TOTAL PARKS & RECREATION 2,748,554.00 534,461.27 503,262.93 534,461.27 76,226.71 2,137,866.02 22.22% CULTURAL LIBRARY Personnel Services 904,386.00 268,695.58 229,195.91 268,695.58 - 635,690.42 29.71 Supplies 15,000.00 4,024.44 4,827.05 4,024.44 194.25 10,781.31 28.12 Utility Services 70,000.00 10,037.46 5,326.69 10,037.46 - 59,962.54 14.34 Operations Support 5,900.00 253.97 587.98 253.97 - 5,646.03 4.30 Staff Support 7,025.00 5,486.35 329.18 5,486.35 - 1,538.65 78.10 Professional Services 3,300.00 2,129.00 1,655.96 2,129.00 - 1,171.00 64.52 Operating Equipment 157,762.00 44,002.22 37,400.83 44,002.22 5,835.15 107,924.63 31.59 TOTAL LIBRARY 1,163,373.00 334,629.02 279,323.60 334,629.02 6,029.40 822,714.58 29.28% TOTAL CULTURAL 1,163,373.00 334,629.02 279,323.60 334,629.02 6,029.40 822,714.58 29.28% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 916,558.00 247,854.80 216,268.88 247,854.80 - 668,703.20 27.04 Supplies 8,300.00 1,328.37 1,162.86 1,328.37 941.25 6,030.38 27.34 City Support Services 1,024,097.00 174,915.69 161,856.83 174,915.69 90,008.96 759,172.35 25.87 Utility Services 367,465.00 52,288.92 52,359.62 52,288.92 33,376.00 281,800.08 23.31 Staff Support 69,700.00 1,056.78 117.01 1,056.78 1,158.81 67,484.41 3.18 Professional Services 38,075.00 1,406.25 - 1,406.25 - 36,668.75 3.69 Maintenance Services 10,000.00 269.90 7,182.61 269.90 - 9,730.10 2.70 Rental/Leasing 3,650.00 1,216.72 912.54 1,216.72 - 2,433.28 33.33 Operating Equipment 269,594.00 52,537.65 46,430.69 52,537.65 55,758.89 161,297.46 40.17 TOTAL INFORMATION TECHNOLOGY 2,707,439.00 532,875.08 486,291.04 532,875.08 181,243.91 1,993,320.01 26.38% HUMAN RESOURCES Personnel Services 468,069.00 105,443.58 115,028.96 105,443.58 11,292.62 351,332.80 24.94 Supplies 2,700.00 134.37 182.10 134.37 - 2,565.63 4.98 Human Services 215,400.00 38,049.10 52,627.43 38,049.10 57,105.23 120,245.67 44.18 Operations Support 5,500.00 1,949.84 2,433.84 1,949.84 - 3,550.16 35.45 Staff Support 41,150.00 13,680.01 13,303.30 13,680.01 2,104.22 25,365.77 38.36 City Assistance 10,000.00 4,855.00 1,985.00 4,855.00 990.00 4,155.00 58.45 Professional Services 5,000.00 - - - - 5,000.00 - Operating Equipment 500.00 - 513.31 - - 500.00 - TOTAL HUMAN RESOURCES 748,319.00 164,111.90 186,073.94 164,111.90 71,492.07 512,715.03 31.48% FINANCE 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, 2021 Personnel Services 656,579.00 192,216.52 170,470.62 192,216.52 - 464,362.48 29.28 Supplies 2,700.00 726.83 801.09 726.83 - 1,973.17 26.92 Staff Support 6,740.00 240.00 864.00 240.00 - 6,500.00 3.56 Professional Sevices 38,700.00 7,908.09 909.82 7,908.09 - 30,791.91 20.43 Operating Equipment 250.00 - 336.08 - - 250.00 - TOTAL FINANCE 704,969.00 201,091.44 173,381.61 201,091.44 - 503,877.56 28.52% PURCHASING & ASSET MGT Personnel Services 237,179.00 70,432.01 63,361.41 70,432.01 - 166,746.99 29.70 Supplies 3,600.00 390.56 34.58 390.56 231.19 2,978.25 17.27 Operations Support 7,550.00 1,299.00 1,299.00 1,299.00 517.00 5,734.00 24.05 Staff Support 6,785.00 399.00 375.38 399.00 825.95 5,560.05 18.05 City Assistance 2,000.00 124.00 162.00 124.00 445.00 1,431.00 28.45 Operating Equipment 600.00 - - - - 600.00 - TOTAL PURCHASING & ASSET MGT 257,714.00 72,644.57 65,232.37 72,644.57 2,019.14 183,050.29 28.97% FLEET SERVICE Personnel Services 560,458.00 135,028.93 137,221.56 135,028.93 - 425,429.07 24.09 Supplies 216,700.00 29,992.53 37,837.11 29,992.53 11,839.53 174,867.94 19.30 City Support Services 15,000.00 2,404.34 2,357.20 2,404.34 - 12,595.66 16.03 Utility Services 11,500.00 1,109.01 1,634.84 1,109.01 - 10,390.99 9.64 Staff Support 32,500.00 512.50 4,317.96 512.50 649.31 31,338.19 3.57 Maintenance Services 234,953.00 38,782.94 62,404.77 38,782.94 16,394.38 179,775.68 23.48 Operating Equipment 14,000.00 5,007.38 4,737.94 5,007.38 2,756.18 6,236.44 55.45 Capital Outlay 221,000.00 394.87 - 394.87 183,327.79 37,277.34 83.13 TOTAL FLEET SERVICE 1,306,111.00 213,232.50 250,511.38 213,232.50 214,967.19 877,911.31 32.78% FACILITY SERVICES Personnel Services 820,939.00 216,979.90 213,475.64 216,979.90 - 603,959.10 26.43 Supplies 159,500.00 9,833.34 10,228.44 9,833.34 4,439.13 145,227.53 8.95 City Support Services 5,000.00 - - - - 5,000.00 - Utility Services 186,000.00 31,688.37 26,404.32 31,688.37 - 154,311.63 17.04 Staff Support 18,400.00 1,646.63 706.00 1,646.63 634.25 16,119.12 12.40 Professional Services 160,000.00 12,416.31 15,216.62 12,416.31 136,579.41 11,004.28 93.12 Maintenance Services 610,000.00 36,814.88 51,367.16 36,814.88 78,083.33 495,101.79 18.84 Rental/Leasing 500.00 - - - - 500.00 - Operating Equipment 6,000.00 - - - - 6,000.00 - Capital Outlay 32,000.00 - - - 26,121.50 5,878.50 81.63 TOTAL BUILDING MAINTENANCE 1,998,339.00 309,379.43 317,398.18 309,379.43 245,857.62 1,443,101.95 27.78% TOTAL INTERNAL SERVICE 7,722,891.00 1,493,334.92 1,478,888.52 1,493,334.92 715,579.93 5,513,976.15 28.60% 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, 2021 MISC & PROJECTS Project Fund Charges/Transfers 1,645,112.00 - - - - 1,645,112.00 - TOTAL PROJECTS 1,645,112.00 - - - - 1,645,112.00 0.00% CITY ASSISTANCE City's Assistance to Agencies 332,666.00 49,458.75 52,420.92 49,458.75 - 283,207.25 14.87 Operating Equipment 10,000.00 - - - - 10,000.00 - TOTAL CITY ASSISTANCE 342,666.00 49,458.75 52,420.92 49,458.75 - 293,207.25 14.43% SEWER PROJECTS Fund Charges/Transfers 285,000.00 - - - - 285,000.00 - TOTAL SEWER PROJECTS 285,000.00 - - - - 285,000.00 0.00% COURT - RESTRICTED FUNDS Operating Equipment 19,452.00 - - - 2,500.00 16,952.00 12.85 TOTAL COURT-RESTRICTED FUNDS 19,452.00 - - - 2,500.00 16,952.00 12.85% TOTAL MISC & PROJECTS 2,292,230.00 49,458.75 52,420.92 49,458.75 2,500.00 2,240,271.25 2.27% TOTAL EXPENDITURES 41,490,207.54 8,864,740.73 8,778,573.96 8,864,740.73 3,418,451.16 29,207,015.65 29.61% REVENUE OVER(UNDER) EXPEND.(0.54) 5,350,440.26 4,249,189.95 5,350,440.26 (3,418,451.16) (1,931,989.64) 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 15,420,000.00 8,443,209.42 7,906,585.67 8,443,209.42 - 6,976,790.58 54.75 000-411110 Disable Veterans Assist Pymnt 1,100,000.00 - - - - 1,100,000.00 - 000-411200 Advalorem Tax-Delinquent 50,000.00 14,754.88 32,941.15 14,754.88 - 35,245.12 29.51 000-411300 Advalorem Tax-P&I 70,000.00 12,977.65 15,014.07 12,977.65 - 57,022.35 18.54 000-411500 Sales Tax Revenue-Gen Fund 11,135,000.00 2,870,801.58 2,599,173.29 2,870,801.58 - 8,264,198.42 25.78 000-411600 Bingo Tax - - - - - - - 000-411700 Mixed Beverage Tax 70,000.00 18,181.62 9,568.35 18,181.62 - 51,818.38 25.97 TOTAL Taxes 27,845,000.00 11,359,925.15 10,563,282.53 11,359,925.15 - 16,485,074.85 40.80% Franchises 000-421200 Center Point/Entex Energy 94,000.00 22,791.99 22,545.08 22,791.99 - 71,208.01 24.25 000-421220 City Public Service 980,000.00 243,299.04 233,351.20 243,299.04 - 736,700.96 24.83 000-421240 Guadalupe Valley Elec Co-op 460,000.00 109,454.20 96,751.57 109,454.20 - 350,545.80 23.79 000-421250 New Braunfels Utilities 70,000.00 15,731.04 15,948.89 15,731.04 - 54,268.96 22.47 000-421300 Time Warner-State Franchise 325,000.00 77,552.15 83,699.78 77,552.15 - 247,447.85 23.86 000-421460 AT&T Franchise Fee 100,000.00 21,637.80 11,698.31 21,637.80 - 78,362.20 21.64 000-421480 Other Telecom Franchise - ROW 130,000.00 27,885.25 38,515.31 27,885.25 - 102,114.75 21.45 000-421500 Solid Waste Franchise Fee 168,000.00 43,089.58 45,718.46 43,089.58 - 124,910.42 25.65 TOTAL Franchises 2,327,000.00 561,441.05 548,228.60 561,441.05 - 1,765,558.95 24.13% Permits 000-431100 Home Occupation Permit 525.00 175.00 420.00 175.00 - 350.00 33.33 000-431205 Bldg Permit-Residential 601,400.00 48,716.50 129,898.50 48,716.50 - 552,683.50 8.10 000-431210 Bldg Permit-Commercial 250,000.00 92,967.00 50,456.00 92,967.00 - 157,033.00 37.19 000-431215 Bldg Permit-General 350,000.00 56,896.00 79,184.00 56,896.00 - 293,104.00 16.26 000-431300 Mobile Home Permit 375.00 25.00 300.00 25.00 - 350.00 6.67 000-431400 Signs Permit 5,000.00 644.00 1,486.00 644.00 - 4,356.00 12.88 000-431500 Food Establishmnt Permit 70,000.00 44,540.00 56,250.00 44,540.00 - 25,460.00 63.63 000-431700 Plumbing Permit 130,000.00 17,809.00 33,572.00 17,809.00 - 112,191.00 13.70 000-431750 Electrical Permit 75,000.00 10,600.00 21,440.00 10,600.00 - 64,400.00 14.13 000-431800 Mechanical Permit 68,000.00 7,800.00 14,780.00 7,800.00 - 60,200.00 11.47 000-431900 Solicitor/Peddler Permit 2,000.00 240.00 120.00 240.00 - 1,760.00 12.00 000-431950 Animal/Pet Permit 250.00 - - - - 250.00 - 000-432000 Cert of Occupancy Prmt 7,600.00 2,850.00 1,050.00 2,850.00 - 4,750.00 37.50 000-432100 Security Alarm Permit 43,000.00 6,995.00 6,975.00 6,995.00 - 36,005.00 16.27 000-432300 Grading/Clearing Permit 10,000.00 2,055.38 2,450.00 2,055.38 - 7,944.62 20.55 000-432400 Development Permit 75,000.00 12,231.44 7,394.42 12,231.44 - 62,768.56 16.31 000-435000 Fire Permit 30,000.00 3,872.00 4,224.50 3,872.00 - 26,128.00 12.91 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 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, 2021 TOTAL Permits 1,718,150.00 308,416.32 410,000.42 308,416.32 - 1,409,733.68 17.95% Licenses 000-441000 Alcohol Beverage License 8,200.00 2,585.00 2,540.00 2,585.00 - 5,615.00 31.52 000-441300 Mobile Home License 120.00 80.00 80.00 80.00 - 40.00 66.67 000-442000 Contractors License 41,000.00 7,690.00 8,650.00 7,690.00 - 33,310.00 18.76 000-444000 Pet License - - - - - - - TOTAL Licenses 49,320.00 10,355.00 11,270.00 10,355.00 - 38,965.00 21.00% Fees 000-451000 Municipal Court Fines 625,000.00 98,415.38 99,424.57 98,415.38 - 526,584.62 15.75 000-451010 Texas Motor Carrier Fines - 11,744.00 - 11,744.00 - (11,744.00) - 000-451015 CVE Out of Service - 800.00 - 800.00 - (800.00) 000-451100 Arrest Fee 21,300.00 3,040.77 4,082.08 3,040.77 - 18,259.23 14.28 000-451110 Expunction Fee 100.00 - - - - 100.00 - 000-451200 Warrant Fees 67,400.00 12,404.37 8,014.27 12,404.37 - 54,995.63 18.40 000-451220 Officer Jury Fee 200.00 - - - - 200.00 - 000-451310 Restitution Fee-Local 100.00 - - - - 100.00 - 000-451320 Civil Justice Fee-Court - - - - - - - 000-451340 Judicial Fee-City 1,524.00 83.57 83.11 83.57 - 1,440.43 5.48 000-451400 Traffic Fine Costs TTL 9,924.00 1,317.04 1,964.45 1,317.04 - 8,606.96 13.27 000-451510 Juvenile Case Mgmt Fee 12,768.00 696.40 697.56 696.40 - 12,071.60 5.45 000-451520 Truancy Fees 13,584.00 2,978.62 3,761.25 2,978.62 - 10,605.38 21.93 000-451530 Local Municipal Jury Fund 225.00 57.50 73.15 57.50 - 167.50 25.56 000-451600 Technology Fund Fee 19,452.00 2,891.43 3,520.00 2,891.43 - 16,560.57 14.86 000-451700 Security Fee 18,900.00 3,261.95 4,030.53 3,261.95 - 15,638.05 17.26 000-451800 Time Payment Fee-City 4,140.00 1,004.61 360.78 1,004.61 - 3,135.39 24.27 000-451850 State Fines 10% Service Fee 32,612.00 5,436.72 9,084.44 5,436.72 - 27,175.28 16.67 000-451900 DPS Payment-Local 5,052.00 1,015.76 604.00 1,015.76 - 4,036.24 20.11 000-452000 Child Safety Fee 5,880.00 478.76 1,911.48 478.76 - 5,401.24 8.14 000-452100 Platting Fees 54,000.00 20,250.00 6,000.00 20,250.00 - 33,750.00 37.50 000-452200 Site Plan Fee 23,000.00 6,000.00 4,500.00 6,000.00 - 17,000.00 26.09 000-452300 Plan Check Fee 600,000.00 85,868.25 113,113.25 85,868.25 - 514,131.75 14.31 000-452320 Tree Mitigation Admin Fee 15,000.00 10,057.50 38,640.00 10,057.50 - 4,942.50 67.05 000-452400 BOA/Variance Fees 2,500.00 1,500.00 - 1,500.00 - 1,000.00 60.00 000-452600 Specific Use/Zone Chng Fee 26,450.00 (2,500.00) 6,000.00 (2,500.00) - 28,950.00 (9.45) 000-452710 Zoning Ltr & Dev Rights 2,550.00 1,500.00 600.00 1,500.00 - 1,050.00 58.82 000-453100 Reinspection Fees 190,000.00 49,525.00 51,875.00 49,525.00 - 140,475.00 26.07 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, 2021 000-453110 Swim Pool Inspection Fee 2,500.00 - - - - 2,500.00 - 000-453200 Lot Abatement 5,000.00 1,700.00 1,400.00 1,700.00 - 3,300.00 34.00 000-453211 Admin Fee-Inspections 10,000.00 2,000.00 600.00 2,000.00 - 8,000.00 20.00 000-453310 Misc Inspection Fees - - - - - - - 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 - 252.00 - 252.00 - (252.00) - 000-456120 Senior Center Meal Fee 20,000.00 4,823.46 7,654.29 4,823.46 - 15,176.54 24.12 000-456500 HAZ MAT Fees 5,000.00 - - - - 5,000.00 - 000-456600 Fire Re-inspection Fee 750.00 - - - - 750.00 - 000-458000 Sale of General Fixed Assets - 37,572.00 - 37,572.00 - (37,572.00) - 000-458100 Sale of Merchandise - - 30.00 - - - - 000-458110 Sale of Mdse - GovDeals 100,000.00 1,416.00 24,285.00 1,416.00 - 98,584.00 1.42 000-458400 Civic Center Rental Fees 140,000.00 46,013.25 1,725.00 46,013.25 - 93,986.75 32.87 000-458401 Capital Recovery Fee-Civic C - (600.00) 550.00 (600.00) - 600.00 - 000-458402 Civic Center Ancillary Fees - 250.00 - 250.00 - (250.00) - 000-458450 North Center Rental Fees 18,000.00 6,956.25 2,500.00 6,956.25 - 11,043.75 38.65 000-458460 Senior Center Rental 7,000.00 - - - - 7,000.00 - 000-458500 Community Center Rental Fees 25,000.00 12,119.25 3,635.00 12,119.25 - 12,880.75 48.48 000-458501 Community Center Service Fees - 200.00 100.00 200.00 - (200.00) - 000-458510 Grand Ballroom Rental Fees - (18,250.00) 7,612.50 (18,250.00) - 18,250.00 - 000-458520 Cut-Off Hall Rental Fees - 600.00 2,831.25 600.00 - (600.00) - 000-458530 Conference Hall Rental Fees - - 506.25 - - - - 000-458540 Bluebonnet Hall Rental Fees - (1,525.00) 3,693.75 (1,525.00) - 1,525.00 - 000-458550 Pavilion Rental Fees 20,000.00 3,482.50 1,925.00 3,482.50 - 16,517.50 17.41 000-458551 Equipment Rentals-Parks - - - - - - - 000-458560 Chamber of Comm Rent 7,800.00 1,950.00 1,950.00 1,950.00 - 5,850.00 25.00 000-458570 Non-Resident SYSA League 10,000.00 - - - - 10,000.00 - 000-458580 HOA Meeting Rental Fees - - 225.00 - - - - 000-458581 Funeral Reception Rental Fees - - 225.00 - - - - 000-458582 Quality of Life Rental Fees - - 1,500.00 - - - - 000-458590 Cancellation Fees-Event Rental - 350.00 550.00 350.00 - (350.00) - 000-458650 NonResident User Fee-BVYA 10,000.00 3,530.00 7,080.00 3,530.00 - 6,470.00 35.30 000-458660 BVYA Utility Reimbursement 15,000.00 3,912.00 7,838.38 3,912.00 - 11,088.00 26.08 000-458670 SYSA Utility Reimbursement 7,500.00 2,616.29 - 2,616.29 - 4,883.71 34.88 000-458675 Lions Futbol Utility Reimbrsmt 15,000.00 - 3,516.00 - - 15,000.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, 2021 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 11,000.00 3,380.00 2,640.00 3,380.00 - 7,620.00 30.73 000-459200 NSF Check Fee 100.00 - - - - 100.00 - 000-459300 Notary Fee 48.00 6.00 36.00 6.00 - 42.00 12.50 000-459400 Maps,Copies,UDC & Misc Fees - - - - - - - 000-459600 Animal Adoption Fee 9,000.00 2,185.00 1,940.00 2,185.00 - 6,815.00 24.28 000-459700 Pet Impoundment Fee 7,000.00 2,188.00 2,119.00 2,188.00 - 4,812.00 31.26 000-459800 Police Reports Fee 5,000.00 1,001.00 1,038.00 1,001.00 - 3,999.00 20.02 TOTAL Fees 2,232,459.00 435,955.63 451,845.34 435,955.63 - 1,796,503.37 19.53% Fines 000-463000 Library Fines 9,000.00 2,270.68 1,208.98 2,270.68 - 6,729.32 25.23 TOTAL Fines 9,000.00 2,270.68 1,208.98 2,270.68 - 6,729.32 25.23% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,077.00 5,269.44 15,808.32 5,269.44 - 15,807.56 25.00 000-473200 City of Seguin-Fire Contract 30,107.00 5,575.52 8,363.28 5,575.52 - 24,531.48 18.52 000-473300 Guadalupe Co-Library 217,000.00 - 67,730.32 - - 217,000.00 - 000-473400 Randolph AFB-Animal Control - - - - - - - 000-474200 Library Services-Cibolo 40,000.00 - - - - 40,000.00 - 000-474210 Library Services-Selma 26,000.00 - - - - 26,000.00 - 000-474400 Dispatch Service-Cibolo 160,000.00 - - - - 160,000.00 - 000-474600 School Crossing Guard-Bexar Co 36,000.00 9,284.88 8,998.48 9,284.88 - 26,715.12 25.79 000-474610 School Cross Guard-Guadalupe C 41,000.00 10,963.21 10,355.08 10,963.21 - 30,036.79 26.74 000-474620 School Crossing Guards - Comal 1,900.00 - - - - 1,900.00 - 000-474700 School Officer Funding 367,514.00 91,878.00 - 91,878.00 - 275,636.00 25.00 000-474750 Crime Victim Liaison Agreement 50,000.00 6,250.00 12,500.00 6,250.00 - 43,750.00 12.50 TOTAL Inter-Jurisdictional 990,598.00 129,221.05 123,755.48 129,221.05 - 861,376.95 13.04% Fund Transfers 000-480000 Indirect Costs-EMS 212,740.00 53,185.03 44,775.00 53,185.03 - 159,554.97 25.00 000-480100 Indirect Costs-Hotel/Motel 74,443.00 18,610.78 18,607.03 18,610.78 - 55,832.22 25.00 000-481000 Transfer In - Reserves 2,289,008.00 - - - - 2,289,008.00 - 000-485000 Interfund Charges-Drainage-5%308,010.00 77,002.50 60,778.50 77,002.50 - 231,007.50 25.00 000-486000 Interfund Chrges-Admin W&S 1,478,230.00 369,557.53 346,249.97 369,557.53 - 1,108,672.47 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 - 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, 2021 000-487000 Interfund Charges-Fleet 505,509.00 126,377.25 90,166.78 126,377.25 - 379,131.75 25.00 000-488000 Interfund Charges-4B 506,984.00 253,492.00 252,334.50 253,492.00 - 253,492.00 50.00 000-489000 Transfer In 203,706.00 - - - - 203,706.00 - TOTAL Fund Transfers 5,612,630.00 898,225.09 812,911.78 898,225.09 - 4,714,404.91 16.00% Miscellaneous 000-491000 Interest Earned 15,000.00 1,843.81 1,690.16 1,843.81 - 13,156.19 12.29 000-491200 Investment Income 120,000.00 7,538.39 20,083.34 7,538.39 - 112,461.61 6.28 000-491900 Unrealized Gain/Loss-CapOne - (7,719.74) (8,112.91) (7,719.74) - 7,719.74 - 000-493000 Donations-Others - - - - - - - 000-493120 Donations-Public Library 10,000.00 536.71 101.65 536.71 - 9,463.29 5.37 000-493400 Donations-Animal Control 5,000.00 1,087.00 1,735.00 1,087.00 - 3,913.00 21.74 000-493401 Donations-A/C Microchip - 55.00 315.00 55.00 - (55.00) - 000-493460 Donations- Parks 10,000.00 - - - - 10,000.00 - 000-493465 Donations-Senior Center 10,000.00 1,497.00 - 1,497.00 - 8,503.00 14.97 000-493503 Donation-Fire Rescue 1,000.00 - 400.00 - - 1,000.00 - 000-493618 Donation - Veteran's Memorial 1,250.00 1,050.00 900.00 1,050.00 - 200.00 84.00 000-493700 July 4th Activities 26,000.00 - - - - 26,000.00 - 000-493701 Proceeds-Holidazzle 12,500.00 14,500.00 3,290.00 14,500.00 - (2,000.00) 116.00 000-493704 Moving on Main 4,000.00 - - - - 4,000.00 - 000-493707 Cornhole League - - - - - - - 000-494481 LawEnforcemtOfficersStnd&5,000.00 - - - - 5,000.00 - 000-494482 Grants-Police, Fire, Gen Fund 12,500.00 - 541.11 - - 12,500.00 - 000-495100 Mobile Stage Rental Fees - - - - - - - 000-497000 Misc Income-Gen Fund 50,000.00 7,746.02 13,358.64 7,746.02 - 42,253.98 15.49 000-497005 Schertz Magazine Advertising 140,000.00 34,852.50 36,461.62 34,852.50 - 105,147.50 24.89 000-497100 Misc Income-Police 9,000.00 1,646.11 3,923.92 1,646.11 - 7,353.89 18.29 000-497200 Misc Income-Library 3,000.00 650.00 469.25 650.00 - 2,350.00 21.67 000-497210 Misc Income-Library Copier 15,000.00 3,271.60 1,127.50 3,271.60 - 11,728.40 21.81 000-497300 Misc Income-Animal Control 800.00 - 150.00 - - 800.00 - 000-497400 Misc Income-Streets Dept 50,000.00 10,355.83 2,976.00 10,355.83 - 39,644.17 20.71 000-497460 Misc Income-Parks - - - - - - - 000-497500 Misc Income-TML Ins. Claims 25,000.00 830.26 1,444.45 830.26 - 24,169.74 3.32 000-497550 Misc Income-TML WC Reimbursmnt 10,000.00 22,201.62 3,549.48 22,201.62 - (12,201.62) 222.02 000-497600 Misc Income-Vending Mach 2,500.00 493.60 91.38 493.60 - 2,006.40 19.74 000-497610 Misc Income-Muni Court - 1.80 - 1.80 - (1.80) - 000-498000 Reimbursmnt-Gen Fund 20,000.00 - - - - 20,000.00 - 000-498100 Reimburmnt Fire-Training - - - - - - - 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, 2021 000-498105 Reimbursmt Police OT-DEA 35,000.00 7,532.01 11,766.53 7,532.01 - 27,467.99 21.52 000-498107 Reimbrsmnt-Police OT-Events - - - - - - - 000-498110 Reimburmnt Fire-Emg Acti-OT 100,000.00 399,401.39 - 399,401.39 - (299,401.39) 399.40 000-498150 Reimbursement - Library 13,000.00 - 8,598.66 - - 13,000.00 - TOTAL Miscellaneous 706,050.00 509,371.02 105,260.78 509,371.02 - 196,678.98 72.14% TOTAL REVENUES 41,490,207.00 14,215,180.99 13,027,763.91 14,215,180.99 - 27,275,026.01 34.26% Cash in Bank Claim on Operating Cash Pool-Checking 2,933,122.68$ Cash in Investments LOGIC Investment-General Fund 13,082,872.99 LOGIC Investment-Equip Replacement 79,116.91 LOGIC Investment-Veh Replacement 533,468.20 LOGIC Investment-Air Condi Replacment 290,317.50 CAPITAL ONE Investment-General Fund 1,460,486.34 CD - Bank of New York 249,000.00 CD - Capital One MCLEAN 249,000.00 CD - Capital One ALLEN 249,000.00 CD - Goldman Sachs 249,000.00 Total Cash in Bank & Investments 20,425,081.02$ GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2021-22 1,004,614 1,103,814 826,933 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 - 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 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 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 35,628.89 28,532.09 35,628.89 - (11,628.89) 148.45 TOTAL REVENUES 24,000.00 35,628.89 28,532.09 35,628.89 - (11,628.89) 148.45% EXPENDITURE SUMMARY GENERAL GOVERNMENT CULTURAL KICK CANCER 10,000.00 - - - - 10,000.00 - HAL BALDWIN SCHOLARSHIP 14,000.00 14,706.88 12,868.35 14,706.88 - (706.88) 105.05 TOTAL CULTURAL 24,000.00 14,706.88 12,868.35 14,706.88 - 9,293.12 61.28% TOTAL EXPENDITURES 24,000.00 14,706.88 12,868.35 14,706.88 - 9,293.12 61.28% REVENUE OVER(UNDER) EXPEND 0.00 20,922.01 15,663.74 20,922.01 - (20,922.01) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 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 - 2.55 7.09 2.55 - (2.55) - 000-492200 Kick Cancer 10,000.00 - - - - 10,000.00 - 000-493621 Hal Baldwin Scholarship 14,000.00 35,626.34 28,525.00 35,626.34 - (21,626.34) 254.47 000-497000 Misc Income - Special Events - - - - - - - TOTAL Miscellaneous 24,000.00 35,628.89 28,532.09 35,628.89 - (11,628.89) 148.45% TOTAL REVENUES 24,000.00 35,628.89 28,532.09 35,628.89 - (11,628.89) 148.45% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: Decmber 31, 2021 C I T Y O F S C H E R T Z Cash in Bank Current Claim on Operating Cash Pool-Checking 123,717.97$ Cash in Investments Texas Class- Special Events 18,050.85 Total Cash in Bank & Investments 141,768.82$ SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: September 30, 2021 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 243,299 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 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 20,581.45 20,977.62 20,581.45 - 89,418.55 18.71 Fund Transfers 240,000.00 - - - - 240,000.00 - TOTAL REVENUES 350,000.00 20,581.45 20,977.62 20,581.45 - 329,418.55 5.88% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental MISC & PROJECTS Projects Capital Outlay - - - - - - - TOTAL MISC & PROJECTS 350,000.00 - - - - 350,000.00 0.00% TOTAL EXPENDITURES 350,000.00 - - - - 350,000.00 0.00% REVENUE OVER(UNDER) EXPEND - 20,581.45 20,977.62 20,581.45 - (20,581.45) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 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 16,022.29 15,560.70 16,022.29 - 43,977.71 26.70 000-421465 AT&T PEG Fee 50,000.00 4,559.16 5,416.92 4,559.16 - 45,440.84 9.12 TOTAL Franchises 110,000.00 20,581.45 20,977.62 20,581.45 - 89,418.55 18.71% Fund Transfers 000-481000 Transfer In - Reserves 240,000.00 - - - - 240,000.00 - TOTAL Fund Transfers 240,000.00 - - - - 240,000.00 0.00% Miscellaneous TOTAL REVENUES 350,000.00 20,581.45 20,977.62 20,581.45 - 329,418.55 5.88% AS OF: December 31, 2021 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) Cash in Bank Cash Balance 967,035.50$ Total Cash in Bank & Investments 967,035.50$ PEG FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 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 54,278.33 15,778.09 54,278.33 - 250,208.67 17.83 Permits - - - - - - - Fees 27,485,000.00 6,874,051.64 5,994,906.21 6,874,051.64 - 20,610,948.36 25.01 Fund Transfers 526,000.00 37,500.00 36,600.00 37,500.00 - 488,500.00 7.13 Miscellaneous 443,236.00 91,132.78 50,305.95 91,132.78 - 352,103.22 20.56 TOTAL REVENUES 28,758,723.00 7,056,962.75 6,097,590.25 7,056,962.75 - 21,701,760.25 24.54% EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers - - 19,745.69 - - - - TOTAL NON DEPARTMENTAL - - 19,745.69 - - - 0.00% BUSINESS OFFICE Personnel Services 547,378.00 156,334.82 134,141.75 156,334.82 - 391,043.18 28.56 Supplies 185,100.00 4,542.78 431.65 4,542.78 240.90 180,316.32 2.58 City Support Services 68,500.00 36,064.69 - 36,064.69 - 32,435.31 52.65 Utility Services 9,400.00 1,769.26 2,255.29 1,769.26 - 7,630.74 18.82 Operations Support 102,500.00 24,183.10 21,746.24 24,183.10 - 78,316.90 23.59 Staff Support 6,400.00 1,190.61 337.95 1,190.61 58.94 5,150.45 19.52 Professional Services 259,000.00 55,924.18 48,013.56 55,924.18 - 203,075.82 21.59 Maintenance Services 5,040.00 1,260.00 1,680.00 1,260.00 3,780.00 - 100.00 Operating Equipment - - - - - - - TOTAL BUSINESS OFFICE 1,247,318.00 281,269.44 208,606.44 281,269.44 62,404.34 903,644.22 27.55% W & S ADMINISTRATION Personnel Services 1,951,955.00 457,143.00 497,538.47 457,143.00 - 1,494,812.00 23.42 Supplies 62,000.00 3,456.85 1,675.11 3,456.85 1,944.43 56,598.72 8.71 City Support Services 178,500.00 71,050.71 66,053.46 71,050.71 500.00 106,949.29 40.08 Utility Services 3,573,200.00 761,107.02 848,996.96 761,107.02 81.18 2,812,011.80 21.30 Operations Support 12,050.00 1,509.34 1,397.40 1,509.34 31.00 10,509.66 12.78 Staff Support 43,000.00 3,290.81 7,156.01 3,290.81 162.38 39,546.81 8.03 City Assistance 250.00 40.00 - 40.00 - 210.00 16.00 Professional Services 476,970.00 67,546.77 20,268.79 67,546.77 6,235.00 403,188.23 15.47 Fund Charges/Transfers 6,825,826.00 1,997,427.13 1,953,535.19 1,997,427.13 - 4,828,398.87 29.26 Maintenance Services 9,247,240.00 1,896,183.30 1,431,501.81 1,896,183.30 189,002.19 7,162,054.51 22.55 Other Costs 38,500.00 36,605.45 - 36,605.45 - 1,894.55 95.08 Debt Service 1,518,553.00 - - - 908,937.50 609,615.50 59.86 Rental/Leasing 4,000.00 26,076.94 26,060.14 26,076.94 17,000.00 (39,076.94) 1,076.92 Operating Equipment 9,000.00 485.54 - 485.54 - 8,514.46 5.39 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 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, 2021 Capital Outlay 163,000.00 32,158.31 - 32,158.31 142,260.54 (11,418.85) 107.01 TOTAL PUBLIC WORKS 24,104,044.00 5,354,081.17 4,854,183.34 5,354,081.17 1,266,154.22 17,483,808.61 27.47% MISC & PROJECTS PROJECTS Professional Services 0.00 - 2,117.50 - 3,469.00 (3,469.00) - Maintenance Services 0.00 - 226,024.86 - 4,500.00 (4,500.00) - Rental/Leasing 570,000.00 - - - - 570,000.00 - TOTAL PROJECTS 570,000.00 - 228,142.36 - 7,969.00 562,031.00 1.40% SEWER PROJECT Professional Services - - - - - - - Fund Charges/Transfers - - - - - - - TOTAL SEWER PROJECTS - - - - - - 0.00% TOTAL MISC & PROJECTS 570,000.00 - 228,142.36 - 7,969.00 562,031.00 1.40% TOTAL EXPENDITURES 25,921,362.00 5,635,350.61 5,310,677.83 5,635,350.61 1,336,527.56 18,949,483.83 26.90% ** REVENUE OVER(UNDER)EXPENSES **2,837,361.00 1,421,612.14 786,912.42 1,421,612.14 (1,336,527.56) 2,752,276.42 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 54,278.33 15,778.09 54,278.33 - 250,208.67 17.83 TOTAL Franchises 304,487.00 54,278.33 15,778.09 54,278.33 - 250,208.67 17.83% Permits 000-436010 Network Nodes 0.00 - - - - - TOTAL Permits 0.00 - - - - - 0.00% Fees 000-455200 Garbage Collection Fee 5,300,000.00 1,368,976.75 1,199,212.79 1,368,976.75 - 3,931,023.25 25.83 000-455600 Fire Line Fees - - - - - - - 000-455700 Recycle Fee Revenue 345,000.00 86,200.63 72,123.22 86,200.63 - 258,799.37 24.99 000-455800 W&S Line Constructn Reimbur 25,000.00 2,797.00 6,658.00 2,797.00 - 22,203.00 11.19 000-457100 Sale of Water 12,600,000.00 3,047,494.41 2,777,159.58 3,047,494.41 - 9,552,505.59 24.19 000-457110 Edwards Water Lease 40,000.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 12,174.55 29,328.06 12,174.55 - 107,825.45 10.15 000-457400 Sewer Charges 8,770,000.00 2,282,719.30 1,896,117.84 2,282,719.30 - 6,487,280.70 26.03 000-457500 Water Penalties 250,000.00 73,064.00 100.00 73,064.00 - 176,936.00 29.23 000-458110 Sale of Merchandise - GovDeals 2500.00 - - - - 2,500.00 - 000-459200 NSF Check Fee-Water&Sewer 2,500.00 625.00 325.00 625.00 - 1,875.00 25.00 TOTAL Fees 27,485,000.00 6,874,051.64 5,994,906.21 6,874,051.64 - 20,610,948.36 25.01% 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 36,600.00 37,500.00 - 112,500.00 25.00 000-486406 Transfer In - Pblc Imprvmnt 0.00 - - - - - - TOTAL Fund Transfers 526,000.00 37,500.00 36,600.00 37,500.00 - 488,500.00 7.13% Miscellaneous 000-490000 Misc Charges 10,500.00 2,963.00 50.00 2,963.00 - 7,537.00 28.22 000-491000 Interest Earned 20,000.00 2,842.49 2,177.00 2,842.49 - 17,157.51 14.21 000-491200 Investment Income 90,000.00 996.71 3,143.63 996.71 - 89,003.29 1.11 000-495013 Capital Contribution-W&S 0.00 - - - - - - 000-496000 Water Construction Reserve Acc 0.00 - - - - - - 000-497000 Misc Income-W&S 25,000.00 1,008.30 10,320.79 1,008.30 - 23,991.70 4.03 000-498110 Salary Reimb-SSLGC 297,736.00 83,322.29 34,614.53 83,322.29 - 214,413.71 27.99 000-499100 Distribution-GSE Bond Set - (0.01) - (0.01) - 0.01 - TOTAL Miscellaneous 443,236.00 91,132.78 50,305.95 91,132.78 - 352,103.22 20.56% TOTAL REVENUES 28,758,723.00 7,056,962.75 6,097,590.25 7,056,962.75 - 21,701,760.25 24.54% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 309,181.63$ Cash in Investments Lone Star Investment-Water&Sewer 4,734,695.84 Lone Star Investment-W&S Customer Deposits 317,599.74 Lone Star Investment-W&S Equip Replacement 190,955.92 Lone Star Investment-W&S Veh Replacement 275,853.14 Schertz Bank & Trust-Certificate of Deposit 1,163,351.07 6,682,455.71$ Total Cash in Bank & Investments 6,991,637.34$ WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 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 1,881,021.49 1,586,686.67 1,881,021.49 - 4,664,468.11 28.74 Inter-Jurisdictional 3,985,932.54 1,248,298.49 1,445,671.54 1,248,298.49 - 2,737,634.05 31.32 Fund Transfers 1,088,672.00 - - - - 1,088,672.00 - Miscellaneous 174,500.00 117,834.63 27,276.30 117,834.63 - 56,665.37 67.53 TOTAL REVENUES 11,794,594.14 3,247,154.61 3,059,634.51 3,247,154.61 - 8,547,439.53 27.53% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 5,576,958.00 1,634,724.38 1,314,098.70 1,634,724.38 - 3,942,233.62 29.31 Supplies 387,250.00 148,141.02 55,841.99 148,141.02 10,455.78 228,653.20 40.95 City Support Services 138,000.00 44,047.12 39,073.05 44,047.12 - 93,952.88 31.92 Utility Services 106,000.00 24,793.11 20,980.97 24,793.11 1,255.97 79,950.92 24.57 Operations Support 40,000.00 9,520.21 9,913.75 9,520.21 593.70 29,886.09 25.28 Staff Support 73,265.00 26,936.05 5,920.06 26,936.05 4,085.66 42,243.29 42.34 City Assistance 626,989.01 103,517.48 155,226.25 103,517.48 51,886.75 471,584.78 24.79 Professional Services 123,500.00 63,487.22 36,228.54 63,487.22 39,000.01 21,012.77 82.99 Fund Charges/Transfers 2,663,735.60 818,182.50 622,172.37 818,182.50 - 1,845,553.10 30.72 Maintenance Services 13,000.00 960.00 960.00 960.00 - 12,040.00 7.38 Other Costs 0.00 - - - - - - Debt Service 118120.00 - - - - 118,120.00 - Rental/Leasing 150,000.00 - - - - 150,000.00 - Operating Equipment 115,298.00 4,909.78 9,090.87 4,909.78 2,174.74 108,213.48 6.14 Capital Outlay 1,603,978.00 517,571.78 254,745.00 517,571.78 347,189.55 739,216.67 53.91 TOTAL PUBLIC SAFETY 11,736,093.61 3,396,790.65 2,524,251.55 3,396,790.65 456,642.16 7,882,660.80 32.83% TOTAL EXPENDITURES 11,736,093.61 3,396,790.65 2,524,251.55 3,396,790.65 456,642.16 7,882,660.80 32.83% ** REVENUE OVER(UNDER) EXPENSES **58,500.53 (149,636.04) 535,382.96 (149,636.04) (456,642.16) 664,778.73 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 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,761,969.54 1,478,585.98 1,761,969.54 - 4,444,920.06 28.39 000-456110 Passport Membership Fees 28,000.00 20,545.00 19,640.00 20,545.00 - 7,455.00 73.38 000-456120 EMT Class - Fees 137,500.00 44,000.00 30,250.00 44,000.00 - 93,500.00 32.00 000-456122 CE Class - Fees 24,000.00 - 2,318.77 - - 24,000.00 - 000-456130 Immunization Fees 3,000.00 1,241.50 1,336.40 1,241.50 - 1,758.50 41.38 000-456140 Billing Fees-External 26,000.00 3,936.20 5,551.22 3,936.20 - 22,063.80 15.14 000-456150 Standby Fees 30,000.00 34,679.95 29,320.20 34,679.95 - (4,679.95) 115.60 000-456155 Community Services Support 50,000.00 6,157.30 10,344.10 6,157.30 - 43,842.70 12.31 000-456160 MIH Services 40,000.00 8,442.00 9,315.00 8,442.00 - 31,558.00 21.11 000-459200 NSF Check Fee 100.00 50.00 25.00 50.00 - 50.00 50.00 TOTAL Fees 6,545,489.60 1,881,021.49 1,586,686.67 1,881,021.49 - 4,664,468.11 28.74% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 927,934.89 231,983.73 309,311.64 231,983.73 - 695,951.16 25.00 000-474200 JBSA Support 635,706.00 - - - - 635,706.00 - 000-474300 Cibolo Support 529,043.95 132,260.99 236,557.62 132,260.99 - 396,782.96 25.00 000-475100 Comal Co ESD #6 148,870.54 35,952.30 33,554.48 35,952.30 - 112,918.24 24.15 000-475200 Live Oak Support 280,240.92 70,060.23 123,127.92 70,060.23 - 210,180.69 25.00 000-475300 Universal City Support 335,884.88 83,971.22 160,783.02 83,971.22 - 251,913.66 25.00 000-475400 Selma Support 180,290.22 45,072.56 85,720.50 45,072.56 - 135,217.66 25.00 000-475500 Schertz Support 695,644.24 173,911.06 333,524.34 173,911.06 - 521,733.18 25.00 000-475600 Santa Clara Support 11,953.03 2,988.26 5,727.60 2,988.26 - 8,964.77 25.00 000-475800 Marion Support 21,363.87 5,340.97 9,187.38 5,340.97 - 16,022.90 25.00 000-475910 TASPP Program 219,000.00 466,757.17 148,177.04 466,757.17 - (247,757.17) 213.13 TOTAL Inter-Jurisdictional 3,985,932.54 1,248,298.49 1,445,671.54 1,248,298.49 - 2,737,634.05 31.32% 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 75.03 157.00 75.03 - 2,424.97 3.00 000-491200 Investment Income 5,000.00 111.14 389.20 111.14 - 4,888.86 2.22 000-493203 Donations-EMS 2,000.00 650.00 865.00 650.00 - 1,350.00 32.50 000-497000 Misc Income 75,000.00 108,578.96 2,248.00 108,578.96 - (33,578.96) 144.77 000-497100 Recovery of Bad Debt 20,000.00 392.58 6,210.17 392.58 - 19,607.42 1.96 000-497110 Collection Agency-Bad Debt 70,000.00 8,026.92 17,406.93 8,026.92 - 61,973.08 11.47 TOTAL Miscellaneous 174,500.00 117,834.63 27,276.30 117,834.63 - 56,665.37 67.53% TOTAL REVENUES 11,794,594.14 3,247,154.61 3,059,634.51 3,247,154.61 - 8,547,439.53 27.53% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 323,014.28$ Cash in Investments EMS-Logic 647,538.60 SR 2017 Ambulance-Logic 12.11 Total Cash in Bank & Investments 970,564.99$ C I T Y O F S C H E R T Z CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 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,250.00 800.00 2,250.00 - 1,750.00 56.25 Fees 1,260,000.00 312,530.57 269,888.10 312,530.57 - 947,469.43 24.80 Fund Transfers 17,229.00 - - - - 17,229.00 - Miscellaneous 3,000.00 106.17 361.11 106.17 - 2,893.83 3.54 TOTAL REVENUES 1,284,229.00 314,886.74 271,049.21 314,886.74 - 969,342.26 24.52% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 467,657.00 108,903.48 116,190.36 108,903.48 - 358,753.52 23.29 Supplies 6,000.00 62.25 1,099.61 62.25 - 5,937.75 1.04 City Support Services 35,000.00 3,211.39 3,117.27 3,211.39 380.71 31,407.90 10.26 Utility Services 14,700.00 4,668.94 4,078.42 4,668.94 - 10,031.06 31.76 Operations Support 1,050.00 - - - - 1,050.00 - Staff Support 13,700.00 1,727.87 922.48 1,727.87 260.41 11,711.72 14.51 City Assistance 500.00 40.00 - 40.00 - 460.00 8.00 Professional Services 58,500.00 1,400.00 58.50 1,400.00 - 57,100.00 2.39 Fund Charges/Transfers 574,817.00 143,454.28 140,019.76 143,454.28 - 431,362.72 24.96 Maintenance Services 83,000.00 - 1,836.51 - 4,160.00 78,840.00 5.01 Other Costs 100.00 - - - - 100.00 - Debt Service - - - - - - - Rental/Leasing 500.00 - - - - 500.00 - Operating Equipment 2,500.00 - - - - 2,500.00 - Capital Outlay 14,000.00 - - - 13,903.04 96.96 99.31 TOTAL DRAINAGE 1,272,024.00 263,468.21 267,322.91 263,468.21 18,704.16 989,851.63 22.18% PROJECTS Professional Services - - - - - - - Maintenance Services - 26,517.40 (8,000.00) 26,517.40 7,980.95 (34,498.35) - TOTAL EXPENDITURES 1,272,024.00 289,985.61 259,322.91 289,985.61 26,685.11 955,353.28 24.90% ** REVENUE OVER(UNDER) EXPEND 12,205.00 24,901.13 11,726.30 24,901.13 (26,685.11) 13,988.98 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 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,250.00 800.00 2,250.00 - 1,750.00 56.25 TOTAL Permits 4,000.00 2,250.00 800.00 2,250.00 - 1,750.00 56.25% Fees 000-457500 Drainage Penalties 10,000.00 2,206.87 - 2,206.87 - 7,793.13 22.07 000-457600 Drainage Fee 1,250,000.00 310,323.70 269,888.10 310,323.70 - 939,676.30 24.83 000-458110 Sale of Merchandise - GovDeals - - - - - - - TOTAL Fees 1,260,000.00 312,530.57 269,888.10 312,530.57 - 947,469.43 24.80% Fund Transfers 000-481000 Transfer In - Reserves - - - - - - - 000-486100 Transfer In 17,229.00 - - - - 17,229.00 - 000-486202 Transfer In-Water&Sewer Fund - - - - - - - 000-486405 Transfer-In Grant Fund - - - - - - - TOTAL Funds Transfers 17,229.00 - - - - 17,229.00 0.00% Miscellaneous 000-491000 Interest Earned 1,000.00 28.75 19.77 28.75 - 971.25 2.88 000-491200 Investment Income 2,000.00 77.42 341.34 77.42 - 1,922.58 3.87 000-493204 Donations- Drainage Projects - - - - - - - 000-494495 Other Financing-Capital Lease - - - - - - - 000-495000 Grant Reimbursement - - - - - - - 000-495013 Capital Contributions-Drainage - - - - - - - 000-497000 Misc Income-Drainage 0.00 - - - - - - 000-497100 MISC INCOME-SCRAP METAL SALES 0.00 - - - - - - 000-498300 Reimburmnt-City Property - - - - - - - TOTAL Miscellaneous 3,000.00 106.17 361.11 106.17 - 2,893.83 3.54% TOTAL REVENUES 1,284,229.00 314,886.74 271,049.21 314,886.74 - 969,342.26 24.52% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 37,582.57$ Cash in Investments Lone Star Investment-Drainage Maint Fund 381,299.77 Total Cash in Bank & Investments 418,882.34$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 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 194,668.13 65,244.04 194,668.13 - 325,331.87 37.44 Fund Transfers 1,150,000.00 - - - - 1,150,000.00 - Miscellaneous 5,250.00 334.94 820.37 334.94 - 4,915.06 6.38 TOTAL REVENUES 1,675,250.00 195,003.07 66,064.41 195,003.07 - 1,480,246.93 11.64% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 0.00 - - - - - - City Support Services 112,466.00 25,826.44 24,583.02 25,826.44 - 86,639.56 22.96 Operations Support 31,000.00 5,284.50 4,186.00 5,284.50 4,200.00 21,515.50 30.60 Professional Services 3,500.00 240.00 - 240.00 480.00 2,780.00 20.57 Fund Charges/Transfers 74,443.00 18,610.78 18,607.03 18,610.78 - 55,832.22 25.00 Maintenance Services 50,000.00 29.82 55,623.60 29.82 45,348.81 4,621.37 90.76 Operating Equipment 44,888.00 1,072.68 - 1,072.68 44,787.75 (972.43) 102.17 Capital Outlay 20000.00 - - - - 20,000.00 - TOTAL NONDEPARTMENTAL 336,297.00 51,064.22 102,999.65 51,064.22 94,816.56 190,416.22 43.38% TOTAL GENERAL GOVERNMENT 336,297.00 51,064.22 102,999.65 51,064.22 94,816.56 190,416.22 43.38% MISC & PROJECTS PROJECTS Professional Services 93,500.00 7,910.00 - 7,910.00 39,031.00 46,559.00 50.20 Maintenance Services 1,150,000.00 - - - - 1,150,000.00 - TOTAL PROJECTS 1,243,500.00 7,910.00 - 7,910.00 39,031.00 1,196,559.00 3.77% TOTAL MISC & PROJECTS 1,243,500.00 7,910.00 - 7,910.00 39,031.00 1,196,559.00 3.77% TOTAL EXPENDITURES 1,579,797.00 58,974.22 102,999.65 58,974.22 133,847.56 1,386,975.22 12.21% REVENUE OVER(UNDER) EXPENDITURE 95,453.00 136,028.85 (36,935.24) 136,028.85 (133,847.56) 93,271.71 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 107,527.06$ Cash in Investments Texas Class - Hotel Tax 2,265,274.80 Total Cash in Bank & Investments 2,372,801.86$ HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 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 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 - Fund Transfers - - - - - - - Miscellaneous 1,025.00 40.35 114.67 40.35 - 984.65 3.94 TOTAL REVENUES 319,025.00 40.35 114.67 40.35 - 318,984.65 0.01% 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 40.35 114.67 40.35 - 193,984.65 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 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 000-48100 Transfer In- Reserves - - - - - - - TOTAL Fund Transfers - - - - - - 0.00% Miscellaneous 000-491000 Interest Earned 25.00 0.30 3.16 0.30 - 24.70 1.20 000-491200 Investment Income 1,000.00 40.05 111.51 40.05 - 959.95 4.01 000-493700 Donations 0.00 - - - - - - TOTAL Miscellaneous 1,025.00 40.35 114.67 40.35 - 984.65 3.94% TOTAL REVENUES 319,025.00 40.35 114.67 40.35 - 318,984.65 0.01% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 Cash in Bank Current Claim on Operating Cash Pool-Checking 859.21 Cash in Investments Texas Class- Park Fund 286,198.50 Total in Investment Pool 286,198.50 Total Cash in Bank & Investments 287,057.71 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 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 56,992.50 218,960.00 56,992.50 - 13,007.50 81.42 Miscellaneous 1,400.00 104.95 237.54 104.95 - 1,295.05 7.50 TOTAL REVENUES 71,400.00 57,097.45 219,197.54 57,097.45 - 14,302.55 79.97% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services 70,000.00 13,600.00 2,925.00 13,600.00 2,700.00 53,700.00 23.29 TOTAL TREE MITIGATION 70,000.00 13,600.00 2,925.00 13,600.00 2,700.00 53,700.00 23.29% TOTAL EXPENDITURES 70,000.00 13,600.00 2,925.00 13,600.00 2,700.00 53,700.00 23.29% REVENUE OVER(UNDER) EXPEND 1,400.00 43,497.45 216,272.54 43,497.45 (2,700.00) (39,397.45) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 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 56,992.50 218,960.00 56,992.50 - 13,007.50 81.42 TOTAL Fees 70,000.00 56,992.50 218,960.00 56,992.50 - 13,007.50 81.42% Fund Transfers Miscellaneous 000-491000 Interest Earned 200.00 17.59 7.19 17.59 - 182.41 8.80 000-491200 Investment Income 1,200.00 87.36 230.35 87.36 - 1,112.64 7.28 000-497000 Misc Income - - - - - - TOTAL Miscellaneous 1,400.00 104.95 237.54 104.95 - 1,295.05 7.50% TOTAL REVENUES 71,400.00 57,097.45 219,197.54 57,097.45 - 14,302.55 79.97% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking $37,952.67 Cash in Investments MBIA Investment-Tree Mitigation 653,439.99 Total Cash in Bank & Investments $691,392.66 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 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 151,434.00 324,207.00 151,434.00 - 948,566.00 13.77 Miscellaneous 16,000.00 1,848.88 3,504.90 1,848.88 - 14,151.12 11.56 TOTAL REVENUES 1,116,000.00 153,282.88 327,711.90 153,282.88 - 962,717.12 13.74% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 51,000.00 2,877.37 - 2,877.37 78,417.12 (30,294.49) 159.40 TOTAL NON DEPARTMENTAL 51,000.00 2,877.37 - 2,877.37 78,417.12 (30,294.49) 159.40% MISC & PROJECTS PROJECTS Fund Charges/Transfers - - - - - - - TOTAL MISC & PROJECTS - - - - - - 0.00% TOTAL EXPENDITURES 51,000.00 2,877.37 - 2,877.37 78,417.12 (30,294.49) 159.40% REVENUE OVER(UNDER) EXPENDITURES 1,065,000.00 150,405.51 327,711.90 150,405.51 (78,417.12) 993,011.61 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 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 151,434.00 324,207.00 151,434.00 - 948,566.00 13.77 TOTAL Fees 1,100,000.00 151,434.00 324,207.00 151,434.00 - 948,566.00 13.77% Fund Transfers Miscellaneous - 000-491000 Interest Earned 1,000.00 52.01 64.50 52.01 - 947.99 5.2 000-491200 Investment Income 15,000.00 1,796.87 3,440.40 1,796.87 - 13,203.13 11.98 TOTAL Miscellaneous 16,000.00 1,848.88 3,504.90 1,848.88 - 14,151.12 11.56% TOTAL REVENUES 1,116,000.00 153,282.88 327,711.90 153,282.88 - 962,717.12 13.74% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 21,343.64$ Cash in Investments Lone Star Investment-Capital Recovery Water 8,385,926.67 Total Cash in Bank & Investments 8,407,270.31$ CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 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 68,955.12 174,222.60 68,955.12 - 531,044.88 11.49 Miscellaneous 60,250.00 1,628.40 3,110.78 1,628.40 - 58,621.60 2.70 TOTAL REVENUES 660,250.00 70,583.52 177,333.38 70,583.52 - 589,666.48 10.69% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 55,500.00 4,018.36 1,138.38 4,018.36 97,902.49 (46,420.85) 183.64 Fund Charges/Transfers - - - - - - - TOTAL NON DEPARTMENTAL 55,500.00 4,018.36 1,138.38 4,018.36 97,902.49 (46,420.85) 183.64% MISC & PROJECTS TOTAL EXPENDITURES 55,500.00 4,018.36 1,138.38 4,018.36 97,902.49 (46,420.85) 183.64% REVENUE OVER(UNDER) EXPENDITURES 604,750.00 66,565.16 176,195.00 66,565.16 (97,902.49) 636,087.33 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 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 68,955.12 174,222.60 68,955.12 - 531,044.88 11.49 TOTAL Fees 600,000.00 68,955.12 174,222.60 68,955.12 - 531,044.88 11.49% Fund Transfers Miscellaneous 000-491000 Interest Earned 250.00 8.54 50.08 8.54 - 241.46 3.42 000-491200 Investment Income 60,000.00 2,958.00 9,429.91 2,958.00 - 57,042.00 4.93 000-491900 Unrealize Gain/Loss-Captl One 0.00 (1,338.14) (6,369.21) (1,338.14) - 1,338.14 - TOTAL Miscellaneous 60,250.00 1,628.40 3,110.78 1,628.40 - 58,621.60 2.70% TOTAL REVENUES 660,250.00 70,583.52 177,333.38 70,583.52 - 589,666.48 10.69% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking (7,649,327.02)$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 5,998,320.70 Capital One-Investment 1,829,441.70 Total Cash in Bank & Investments 178,435.38$ CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 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 3,861,752.02 3,783,422.72 3,861,752.02 - 3,468,109.98 52.69 Fund Transfers - - - - - - - Miscellaneous 105,000.00 5,809.03 25,393.68 5,809.03 - 99,190.97 5.53 TOTAL REVENUES 7,434,862.00 3,867,561.05 3,808,816.40 3,867,561.05 - 3,567,300.95 52.02% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 50,000.00 45,293.39 174,999.52 45,293.39 - 4,706.61 90.59 Debt Service 6,626,915.00 - - - 1,982,996.88 4,643,918.12 29.92 TOTAL GENERAL GOVERNMENT 6,676,915.00 45,293.39 174,999.52 45,293.39 1,982,996.88 4,648,624.73 30.38% TOTAL EXPENDITURES 6,676,915.00 45,293.39 174,999.52 45,293.39 1,982,996.88 4,648,624.73 30.38% ** REVENUE OVER(UNDER) EXPEND 757,947.00 3,822,267.66 3,633,816.88 3,822,267.66 (1,982,996.88) (1,081,323.78) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 , 2021 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 3,861,752.02 3,783,422.72 3,861,752.02 - 3,468,109.98 52.69 TOTAL Taxes 7,329,862.00 3,861,752.02 3,783,422.72 3,861,752.02 - 3,468,109.98 52.69% Fund Transfers 000-486100 Transfer In - - - - - - - 000-486401 Transfer In -Bond Project Fund - - - - - - - TOTAL Fund Transfers 0.00 - - - - - 0.00% Miscellaneous 000-491000 Interest Earned 1,000.00 21.35 50.97 21.35 - 978.65 2.14 000-491200 Investment Income 4,000.00 169.93 342.71 169.93 - 3,830.07 4.25 000-495020 Contribution From YMCA 100,000.00 - 25,000.00 - - 100,000.00 - 000-498000 Proceeds From Refunding Debt - 5,617.75 - 5,617.75 - (5,617.75) - TOTAL Miscellaneous 105,000.00 5,809.03 25,393.68 5,809.03 - 99,190.97 5.53% TOTAL REVENUES 7,434,862.00 3,867,561.05 3,808,816.40 3,867,561.05 - 3,567,300.95 52.02% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31 , 2021 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 600.00 200.00 600.00 - 4,400.00 12.00 101-541502 Cost of Bond Issuance 45,000.00 44,693.39 174,799.52 44,693.39 - 306.61 99.32 TOTAL Professional Services 50,000.00 45,293.39 174,999.52 45,293.39 - 4,706.61 90.59% Debt Service 101-555629 Bond-GO 2007 Principal 340000.00 - - - - 340,000.00 - 101-555629.1 Bond-GO 2007 Interest 85267.00 - - - - 85,267.00 - 101-555635 Bond-GO 2012 - Principal 375,000.00 - - - - 375,000.00 - 101-555635.1 Bond-GO 2012 - Interest 128,677.00 - - - - 128,677.00 - 101-555638 Bond-GO 2014 Refund-Principal 750,000.00 - - - - 750,000.00 - 101-555638.1 Bond-GO 2014 Refund-Interest 268,025.00 - - - - 268,025.00 - 101-555640.1 Bond-GO Ref 2015-Interest 37,050.00 - - - - 37,050.00 - 101-555641 Tax Note - SR2015A-Principal 155,000.00 - - - - 155,000.00 - 101-555641.1 Tax Note - SR2015A - Interest 2,387.00 - - - - 2,387.00 - 101-555642 Bond-GO SR2016-Principal 245,000.00 - - - - 245,000.00 - 101-555642.1 Bond-GO SR2016-Interest 131,607.00 - - - - 131,607.00 - 101-555643 Bond-TaxableB CO SR2016-Princi 60,000.00 - - - - 60,000.00 - 101-555643.1 Bond-Taxable CO SR2016-Interes 40,263.00 - - - - 40,263.00 - 101-555644 Bond-NonTaxA CO SR2016-Princip 195,000.00 - - - - 195,000.00 - 101-555644.1 Bond-NonTax CO SR2016-Interest 40,469.00 - - - - 40,469.00 - 101-555645 Bond-CO SR2017-Principal 420,000.00 - - - - 420,000.00 - 101-555645.1 Bond-CO SR2017 - Interest 114,425.00 - - - - 114,425.00 - 101-555646 Bond-GO SR2017 - Principal 165,000.00 - - - - 165,000.00 - 101-555646.1 Bond-GO SR2017 - Interest 100,050.00 - - - - 100,050.00 - 101-555647 Bond-GO 2018 Refund- Principal 585,000.00 - - - - 585,000.00 - 101-555647.1 Bond-GO 2018 Refund - Interest 86,125.00 - - - - 86,125.00 - 101-555648 Bond-CO SR2018 - Principal 245,000.00 - - - 245,000.00 - 100.00 101-555648.1 Bond-CO 2018 - Interest 163,888.00 - - - 85,006.25 78,881.75 51.87 101-555649 Bond-GO 2018 Ref - Principal 185,000.00 - - - 185,000.00 - 100.00 101-555649.1 Bond-GO 2018 Ref - Interest 181,819.00 - - - 93,221.88 88,597.12 51.27 101-555650 Bond-CO 2019-Principal 265,000.00 - - - 265,000.00 - 100.00 101-555650.1 Bond-CO 2019-Interest 114,900.00 - - - 59,437.50 55,462.50 51.73 101-555651.1 Bond-GO 2020-Interest 211963.00 - - - 115,331.25 96,631.75 54.41 TOTAL Debt Service 6,626,915.00 - - - 1,982,996.88 4,643,918.12 29.92% Other Financing Sources TOTAL EXPENDITURES 6,676,915.00 45,293.39 174,999.52 45,293.39 1,982,996.88 4,648,624.73 30.38% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 , 2021 Cash in Bank Claim on Operating Cash Pool-Checking 1,215,873.62$ MBIA Investment- Tax I&S 3,693,770.71 Total Cash in Bank & Investments 4,909,644.33$ TAX I&S CASH IN BANK AND INVESTMENTS AS OF: December 31 , 2021 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,435,398.73 1,299,586.77 1,435,398.73 - 3,972,601.27 26.54 Fund Transfers 1,240,000.00 - - - - 1,240,000.00 - Miscellaneous 141,000.00 5,273.47 13,587.60 5,273.47 - 135,726.53 3.74 TOTAL REVENUES 6,789,000.00 1,440,672.20 1,313,174.37 1,440,672.20 - 5,348,327.80 21.22% EXPENDITURE SUMMARY NONDEPARTMENTAL City Assistance 3,139,038.00 - 200,000.00 - - 3,139,038.00 - Fund Charges/Transfers 1,240,000.00 - - - - 1,240,000.00 - TOTAL NONDEPARTMENTAL 4,379,038.00 - 200,000.00 - - 4,379,038.00 0.00% MISC & PROJECTS PROJECTS ECONOMIC DEVELOPMENT Supplies 1,000.00 512.61 96.91 512.61 67.96 419.43 58.06 City Support Services 19,200.00 1,460.68 1,810.07 1,460.68 - 17,739.32 7.61 Utility Services 2,975.00 127.17 159.58 127.17 - 2,847.83 4.27 Operations Support 343,110.00 31,178.91 7,280.43 31,178.91 18,660.91 293,270.18 14.53 Staff Support 20,100.00 (264.40) 895.20 (264.40) 2,211.91 18,152.49 9.69 City Assistance 202,500.00 - - - - 202,500.00 - Professional Services 61,300.00 1,872.00 5,623.50 1,872.00 - 59,428.00 3.05 Fund Charges/Transfers 506,984.00 253,492.00 252,334.50 253,492.00 - 253,492.00 50.00 Operating Equipment 4,500.00 2,179.94 - 2,179.94 1,500.88 819.18 81.80 TOTAL ECONO DEVELOPMENT 1,161,669.00 290,558.91 268,200.19 290,558.91 22,441.66 848,668.43 26.94% FM3009 ROAD&BRIDGE EXPANSION TOTAL EXPENDITURES 5,540,707.00 290,558.91 468,200.19 290,558.91 22,441.66 5,227,706.43 5.65% ** REVENUE OVER(UNDER) EXPEND 1,248,293.00 1,150,113.29 844,974.18 1,150,113.29 (22,441.66) 120,621.37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 296,647.26$ Cash in Investments Texas Class Investment-Economic Development Corp 19,426,448.67 Schertz Bank & Trust-Certificate of Deposit 1,080,548.16 Schertz Bank & Trust-Certificate of Deposit 1,128,140.79 Total Cash in Bank & Investments 21,931,784.88$ SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021