Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Q3-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 32,702,634.66 0.00 8,787,572.34 78.82% Total General Government 7,095,958.00 4,697,684.33 371,762.45 2,026,511.22 71.44% Total Public Safety 18,429,231.54 14,030,602.21 630,849.07 3,767,780.26 79.56% Total Public Environment 2,037,970.00 1,332,077.01 257,505.03 448,387.96 78.00% Total Parks & Recreation 2,748,554.00 1,779,824.59 144,658.60 824,070.81 70.02% Total Cultural 1,163,373.00 855,041.14 5,454.85 302,877.01 73.97% Total Internal Services 7,722,891.00 5,144,300.02 538,589.08 2,040,001.90 73.58% Total Misc & Projects 2,292,230.00 727,274.50 2,500.00 1,562,455.50 31.84% Total Expenditures 41,490,207.54 28,566,803.80 1,951,319.08 10,972,084.66 73.56% Revenue Over(Under) Expenditures 0.54 4,135,830.86 (1,951,319.08)(2,184,512.32) General Fund, 101 Total Cash in Bank & Investments 19,938,650.45 Special Events Fund, 106 Total Revenues 24,000.00 50,040.08 0.00 (26,040.08)208.50% Total Expenditures 24,000.00 29,555.82 12.40 (5,568.22)123.20% Revenue Over(Under) Expenditures 0.00 20,484.26 12.40 (20,471.86) Special Events Fund, 106 Total Cash in Bank & Investments 141,331.07 Peg Fund, 110 Total Revenues 867,521.00 59,812.68 0.00 807,708.32 6.89% Total Expenditures 867,521.00 0.00 460,977.82 406,543.18 53.14% Revenue Over(Under) Expenditures 0.00 59,812.68 (460,977.82)401,165.14 Peg Fund, 110 Total Cash in Bank & Investments 1,006,266.73 Water & Sewer, 202 Total Revenues 28,758,723.00 21,432,810.71 0.00 7,325,912.29 74.53% Total Expenditures 25,921,362.00 24,392,412.43 507,015.81 1,021,933.76 96.06% Revenue Over(Under) Expenditures 2,837,361.00 (2,959,601.72)(507,015.81)6,303,978.53 Water & Sewer, 202 Total Cash in Bank & Investments 7,026,005.31 EMS, 203 Total Revenues 11,794,594.14 9,478,142.45 0.00 2,316,451.69 80.36% Total Expenditures 11,736,093.61 8,884,078.24 476,317.70 2,375,697.67 79.76% Revenue Over(Under) Expenditures 58,500.53 594,064.21 (476,317.70)(59,245.98) EMS, 203 Total Cash in Bank & Investments 745,623.70 Quarterly Statement Schertz, Texas AS OF :June 30, 2022 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2021 - 2022 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Drainage, 204 Total Revenues 1,284,229.00 949,485.04 0.00 334,743.96 73.93% Total Expenditures 1,272,024.00 775,726.07 13,741.07 482,556.86 62.06% Revenue Over(Under) Expenditures 12,205.00 173,758.97 (13,741.07)(147,812.90) Drainage, 204 Total Cash in Bank & Investments 570,866.67 Hotel Tax, 314 Total Revenues 1,675,250.00 591,818.00 0.00 1,083,432.00 35.33% Total Expenditures 1,579,797.00 1,251,331.41 75,820.97 252,644.62 84.01% Revenue Over(Under) Expenditures 95,453.00 (659,513.41)(75,820.97)830,787.38 Hotel Tax, 314 Total Cash in Bank & Investments 1,623,916.69 Park, 317 Total Revenues 319,025.00 743.02 0.00 318,281.98 0.23% Total Expenditures 125,000.00 17,650.02 10,040.00 97,309.98 22.15% Revenue Over(Under) Expenditures 194,025.00 (16,907.00)(10,040.00)220,972.00 Park, 317 Total Cash in Bank & Investments 270,110.36 Tree Mitigation, 319 Total Revenues 71,400.00 65,673.79 0.00 5,726.21 91.98% Total Expenditures 70,000.00 61,460.00 6,378.00 2,162.00 96.91% Revenue Over(Under) Expenditures 1,400.00 4,213.79 (6,378.00)3,564.21 Tree Mitigation, 319 Total Cash in Bank & Investments 652,109.00 Capital Recovery Water, 411 Total Revenues 1,116,000.00 710,408.69 0.00 405,591.31 63.66% Total Expenditures 51,000.00 17,033.00 56,639.36 (22,672.36)144.46% Revenue Over(Under) Expenditures 1,065,000.00 693,375.69 (56,639.36)428,263.67 Capital Recovery Water, 411 Total Cash in Bank & Investments 8,950,240.49 Capital Recovery Sewer, 421 Total Revenues 660,250.00 312,224.69 0.00 348,025.31 47.29% Total Expenditures 55,500.00 20,242.07 76,559.25 (41,301.32)174.42% Revenue Over(Under) Expenditures 604,750.00 291,982.62 (76,559.25)389,326.63 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 8,198,852.84 Quarterly Statement Schertz, Texas AS OF :June 30, 2022 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2021 - 2022 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Roadway Impact Fee Area 1, 431 Total Revenues 200,900.00 173,787.47 0.00 27,112.53 86.50% Total Expenditures 93,173.00 1,358.50 0.00 91,814.50 1.46% Revenue Over(Under) Expenditures 107,727.00 172,428.97 0.00 (64,701.97) Roadway Impact Fee Area 1, 431 Total Cash in Bank & Investments 720,851.19 Roadway Impact Fee Area 2, 432 Total Revenues 120,400.00 289,364.00 0.00 (168,964.00)240.34% Total Expenditures 29,000.00 52,484.37 0.00 (23,484.37)180.98% Revenue Over(Under) Expenditures 91,400.00 236,879.63 0.00 (145,479.63) Roadway Impact Fee Area 2, 432 Total Cash in Bank & Investments 507,655.08 Roadway Impact Fee Area 3, 433 Total Revenues 401,500.00 177,134.72 0.00 224,365.28 44.12% Total Expenditures 5,000.00 3,337.50 0.00 1,662.50 66.75% Revenue Over(Under) Expenditures 396,500.00 173,797.22 0.00 222,702.78 Roadway Impact Fee Area 3, 433 Total Cash in Bank & Investments 1,146,327.53 Roadway Impact Fee Area 4, 434 Total Revenues 5,065.00 23.18 0.00 5,041.82 0.46% Total Expenditures 5,000.00 3,337.50 0.00 1,662.50 66.75% Revenue Over(Under) Expenditures 65.00 (3,314.32)0.00 3,379.32 Roadway Impact Fee Area 4, 434 Total Cash in Bank & Investments 5,997.14 I&S, 505 Total Revenues 7,434,862.00 7,204,861.53 0.00 230,000.47 96.91% Total Expenditures 6,676,915.00 5,526,439.53 0.00 1,150,475.47 82.77% Revenue Over(Under) Expenditures 757,947.00 1,678,422.00 0.00 (920,475.00) I&S, 505 Total Cash in Bank & Investments 2,765,798.67 SED Corporation, 620 Total Revenues 6,789,000.00 4,334,822.78 0.00 2,454,177.22 63.85% Total Expenditures 5,540,707.00 683,694.51 7,936.12 4,849,076.37 12.48% Revenue Over(Under) Expenditures 1,248,293.00 3,651,128.27 (7,936.12)(2,394,899.15) SED Corporation, 620 Total Cash in Bank & Investments 24,471,014.09 Total Cash in Bank & Investments 78,741,617.01 Quarterly Statement Schertz, Texas AS OF :June 30, 2022 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES REVENUE SUMMARY Taxes 27,845,000.00 4,035,687.56 19,432,509.15 20,927,333.97 - 6,917,666.03 75.16 Franchises 2,327,000.00 597,080.64 1,065,352.18 1,130,786.19 - 1,196,213.81 48.59 Permits 1,718,150.00 801,048.40 953,680.59 832,620.26 - 885,529.74 48.46 Licenses 49,320.00 11,307.50 25,375.00 24,967.50 - 24,352.50 50.62 Fees 2,232,459.00 722,553.38 935,134.90 968,471.18 - 1,263,987.82 43.38 Fines 9,000.00 2,657.33 2,965.50 5,037.38 - 3,962.62 55.97 Inter-Jurisdictional 990,598.00 228,636.38 284,646.63 565,317.46 - 425,280.54 57.07 Fund Transfers 5,612,630.00 898,224.97 1,446,907.12 1,542,958.06 - 4,069,671.94 27.49 Miscellaneous 706,050.00 174,625.28 355,739.48 599,056.77 - 106,993.23 84.85 TOTAL REVENUES 41,490,207.00 7,471,821.44 24,502,310.55 26,596,548.77 - 14,893,658.23 64.10% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 38,102.00 9,432.19 18,795.19 18,468.87 14.40 19,618.73 48.51 Supplies 750.00 56.34 139.40 261.29 75.00 413.71 44.84 City Support Services 57,000.00 4,205.27 37,956.17 33,012.40 2,296.74 21,690.86 61.95 Operations Support 300.00 188.22 85.50 - - 300.00 0.00 Staff Support 27,100.00 2,909.95 13,383.93 15,515.15 320.15 11,264.70 58.43 Professional Services 6,000.00 2,150.00 - 2,000.00 - 4,000.00 33.33 TOTAL CITY COUNCIL 129,252.00 18,941.97 70,360.19 69,257.71 2,706.29 57,288.00 55.68% CITY MANAGER Personnel Services 1,260,763.00 355,961.27 584,049.78 589,628.66 - 671,134.34 46.77 Supplies 1,929.00 456.67 551.82 601.67 92.55 1,234.78 35.99 City Support Services 2,000.00 - - 590.00 - 1,410.00 29.50 Operations Support 50.00 - - - - 50.00 - Staff Support 24,846.00 8,345.48 2,963.89 9,744.37 735.11 14,366.52 42.18 Professional Services 13,641.21 - - 13,641.21 - - 100.00 Operating Equipment - - 1,200.00 - - - - Capital Outlay 44,000.00 - - - 43,581.78 418.22 99.05 TOTAL CITY MANAGER 1,347,229.21 364,763.42 588,765.49 614,205.91 44,409.44 688,613.86 48.89% MUNICIPAL COURT Personnel Services 306,228.00 87,593.44 146,693.15 162,344.96 - 143,883.04 53.01 Supplies 1,500.00 288.79 484.89 396.79 - 1,103.21 26.45 City Support Services 500.00 - 123.86 118.68 - 381.32 23.74 Operations Support 2,000.00 - 246.00 - - 2,000.00 - C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 Staff Support 6,910.00 636.83 638.33 1,432.70 - 5,477.30 20.73 Court Support 3,000.00 - - 132.00 - 2,868.00 4.40 Professional Services 61,700.00 10,705.00 17,737.50 18,095.00 41,425.00 2,180.00 96.47 Maintenance Services 3,000.00 300.00 850.00 1,132.00 1,400.00 468.00 84.40 Operating Equipment 4,000.00 - - 473.22 - 3,526.78 0.12 TOTAL MUNICIPAL COURT 388,838.00 99,524.06 166,773.73 184,125.35 42,825.00 161,887.65 58.37% CUSTOMER RELATIONS-311 Personnel Services 116,705.00 33,615.63 56,997.88 59,542.40 - 57,162.60 51.02 Supplies 100.00 35.85 33.33 52.87 - 47.13 52.87 Staff Support 430.00 75.88 163.84 52.28 38.99 338.73 21.23 TOTAL CUSTOMER RELATIONS-311 117,235.00 33,727.36 57,195.05 59,647.55 38.99 57,548.46 50.91% PLANNING & ZONING Personnel Services 289,769.00 50,582.66 107,617.50 84,289.94 - 205,479.06 29.09 Supplies 2,020.00 999.00 296.75 263.26 (57.58) 1,814.32 10.18 Operations Support 248.00 - 50.60 - - 248.00 - Staff Support 33,939.00 568.18 1,037.00 1,989.20 - 31,949.80 5.86 Professional Services 400,100.00 - 5.00 40.00 - 400,060.00 0.01 Operating Equipment 1,639.00 - 6,075.83 285.47 - 1,353.53 17.42 TOTAL PLANNING & ZONING 727,715.00 52,149.84 115,082.68 86,867.87 (57.58) 640,904.71 11.93% LEGAL SERVICES Operations Support 10,000.00 1,485.72 2,807.66 1,823.72 528.00 7,648.28 23.52 Professional Services 130,000.00 25,933.56 40,475.31 22,137.69 - 107,862.31 17.03 TOTAL LEGAL SERVICES 140,000.00 27,419.28 43,282.97 23,961.41 528.00 115,510.59 17.49% CITY SECRETARY Personnel Services 197,509.00 57,610.19 92,546.93 105,069.66 - 92,439.34 53.20 Supplies 1,150.00 16.10 665.98 328.22 35.60 786.18 31.64 City Support Services 10,000.00 143.95 2,816.06 2,063.97 - 7,936.03 20.64 Operations Support 150.00 138.95 43.00 - - 150.00 - Staff Support 6,450.00 442.45 1,349.83 1,969.07 - 4,480.93 30.53 Operating Equipment 1,000.00 - - - - 1,000.00 - TOTAL CITY SECRETARY 216,259.00 58,351.64 97,421.80 109,430.92 35.60 106,792.48 50.62% NON-DEPARTMENTAL City Support Services 851,935.79 21,114.48 393,735.94 442,049.03 122,704.36 287,182.40 66.29 Operations Support 140,000.00 31,940.33 67,087.42 61,435.92 55.00 78,509.08 43.92 City Assistance 1,315,645.00 789,694.50 908,686.50 943,605.56 347,822.12 24,217.32 98.16 Professional Services 88,775.00 20,198.41 62,904.32 30,924.96 265.00 57,585.04 35.13 Fund Chrgs/Transfrs-Spec Events Fnd 27,979.00 - (1,516.65) - - 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: June 30, 2022 Capital Outlay 0.00 - 7,450.00 - - - - TOTAL NON-DEPARTMENTAL 2,424,334.79 862,947.72 1,438,347.53 1,478,015.47 470,846.48 475,472.84 80.39% PUBLIC AFFAIRS Personnel Services 325,481.00 93,531.92 153,773.67 167,418.47 - 158,062.53 51.44 Supplies 1,100.00 217.91 515.61 567.98 67.80 464.22 57.80 City Support Services 1,000.00 - - - - 1,000.00 - Operations Support 47,635.00 7,010.77 4,263.85 8,336.18 1,027.34 38,271.48 19.66 Staff Support 11,170.00 767.50 274.57 615.18 - 10,554.82 5.51 Professional Services 271,500.00 55,013.85 143,391.50 140,843.88 7,064.50 123,591.62 54.48 TOTAL PUBLIC AFFAIRS 658,486.00 156,541.95 302,219.20 317,781.69 8,159.64 332,544.67 49.50% ENGINEERING Personnel Services 879,409.00 229,304.58 404,261.47 402,420.50 - 476,988.50 45.76 Supplies 2,750.00 236.17 119.95 335.24 - 2,414.76 12.19 City Support Services 1,265.00 1,264.80 - 1,264.80 - 0.20 99.98 Utility Services 5,500.00 1,254.63 2,225.74 1,527.85 - 3,972.15 27.78 Operations Support 150.00 8.16 93.00 - - 150.00 - Staff Support 16,045.00 2,374.71 1,900.33 1,438.99 470.71 14,135.30 11.90 Professional Services 53,115.00 9,350.00 - 9,293.05 26,367.50 17,454.45 67.14 Operating Equipment 1,400.00 - (1,228.01) 118.95 - 1,281.05 8.50 TOTAL ENGINEERING 959,634.00 243,793.05 407,372.48 416,399.38 26,838.21 516,396.41 46.19% TOTAL GENERAL GOVERNMENT 7,108,983.00 1,918,160.29 3,286,821.12 3,359,693.26 596,330.07 3,152,959.67 55.65% PUBLIC SAFETY POLICE Personnel Services 8,812,715.00 2,474,157.67 4,503,157.40 4,501,186.53 - 4,311,528.47 51.08 Supplies 110,557.91 19,664.49 31,147.14 36,592.11 8,249.91 65,715.89 40.56 City Support Services 26,500.00 - 32,421.79 33,969.74 - (7,469.74) 128.19 Utility Services 193,200.00 53,292.60 58,871.06 70,064.57 - 123,135.43 36.27 Operations Support 30,316.00 9,384.50 2,309.00 12,041.05 1,097.34 17,177.61 43.34 Staff Support 164,030.83 45,814.68 57,255.00 77,101.99 17,123.21 69,805.63 57.44 City Assistance 60,300.00 20,432.32 9,507.33 25,641.98 2,611.54 32,046.48 46.85 Professional Services 85,266.20 18,153.63 29,251.27 42,466.18 8,627.48 34,172.54 59.92 Maintenance Services 77,305.00 1,492.93 21,161.99 6,854.33 621.10 69,829.57 9.67 Operating Equipment 192,687.60 19,136.20 135,440.35 54,361.82 83,655.22 54,670.56 71.63 Capital Outlay 542,637.00 149,705.24 244,450.56 202,325.45 264,811.54 75,500.01 86.09 TOTAL POLICE 10,295,515.54 2,811,234.26 5,124,972.89 5,062,605.75 386,797.34 4,846,112.45 52.93% 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: June 30, 2022 Personnel Services 5,536,677.00 1,818,070.19 2,867,625.58 3,218,818.64 - 2,317,858.36 58.14 Supplies 26,930.00 5,668.31 3,396.07 8,897.55 3,836.22 14,196.23 47.28 Utility Services 80,000.00 31,212.12 33,017.96 41,481.79 - 38,518.21 51.85 Operations Support 4,527.00 733.75 157.73 1,534.53 - 2,992.47 33.90 Staff Support 205,772.00 42,625.79 15,846.09 59,405.61 35,209.10 111,157.29 45.98 City Assistance 25,198.00 531.06 4,603.75 3,741.08 4,061.10 17,395.82 30.96 Professional Services 63,600.00 1,133.96 21,353.43 16,838.82 20,900.00 25,861.18 59.34 Maintenance Services 81,500.00 23,434.88 33,283.02 27,263.83 1,600.00 52,636.17 35.42 Other Costs 10,000.00 27,728.01 5,078.41 23,028.58 - (13,028.58) 230.29 Rental/Leasing 27,000.00 38,744.86 - - - 27,000.00 - Operating Equipment 120,000.00 17,090.41 205,246.32 20,570.77 16,576.02 82,853.21 30.96 Capital Outlay 473,637.00 1,613.30 22,705.00 27,393.03 263,285.90 182,958.07 61.37 TOTAL FIRE RESCUE 6,654,841.00 2,008,586.64 3,212,313.36 3,448,974.23 345,468.34 2,860,398.43 57.02% INSPECTIONS Personnel Services 961,954.00 250,703.92 433,880.62 483,080.98 - 478,873.02 50.22 Supplies 5,100.00 293.81 645.93 529.05 160.74 4,410.21 13.53 Utility Services 8,400.00 1,595.03 2,125.44 2,439.72 - 5,960.28 29.04 Operations Support 850.00 31.00 62.00 - - 850.00 - Staff Support 41,446.00 3,226.78 2,075.73 4,800.85 - 36,645.15 11.58 Professional Services 70,000.00 22,900.00 18,037.50 5,400.00 43,600.00 21,000.00 70.00 Operating Equipment 650.00 - - 570.94 - 79.06 87.84 Capital Outlay - - 27,381.00 - - - - TOTAL INSPECTIONS 1,088,400.00 278,750.54 484,208.22 496,821.54 43,760.74 547,817.72 49.67% NEIGHBORHOOD SERVICES Personnel Services 312,294.00 94,195.39 - 159,532.04 - 152,761.96 51.08 Supplies 4,519.00 479.84 - 1,165.82 308.27 3,044.91 32.62 Utility Services 14,000.00 1,438.95 - 1,466.61 - 12,533.39 10.48 Operations Support 3,419.00 31.00 - - 31.00 3,388.00 0.91 Staff Support 24,393.00 1,118.60 - 2,479.80 177.00 21,736.20 10.89 Professional Services 2,500.00 - - - - 2,500.00 - Maintenance Services 15,000.00 850.00 - 3,550.00 - 11,450.00 23.67 Operating Equipment 1,325.00 210.92 - 285.47 - 1,039.53 21.54 TOTAL NEIGHBORHOOD SERVICES 377,450.00 98,324.70 - 168,479.74 516.27 208,453.99 44.77% TOTAL PUBLIC SAFETY 18,416,206.54 5,196,896.14 8,821,494.47 9,176,881.26 776,542.69 8,462,782.59 54.05% PUBLIC ENVIRONMENT STREETS Personnel Services 1,009,600.00 266,034.64 394,817.82 499,588.87 1,149.57 508,861.56 49.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: June 30, 2022 Supplies 167,050.00 29,816.99 47,437.41 40,982.25 18,939.61 107,128.14 35.87 City Support Services 6,000.00 229.31 - 1,066.14 30.15 4,903.71 18.27 Utility Services 180,600.00 58,890.19 75,673.69 83,610.71 - 96,989.29 46.30 Staff Support 22,120.00 10,732.33 8,287.34 3,502.36 1,279.82 17,337.82 21.62 Professional Services 20,000.00 7,536.10 12,070.00 7,536.10 - 12,463.90 37.68 Maintenance Services 396,500.00 173,103.93 69,668.00 158,062.48 28,721.36 209,716.16 47.11 Rental/Lease 5,000.00 4,285.00 1,366.79 3,915.00 - 1,085.00 78.30 Operating Equipment 71,000.00 - 25,170.20 4,876.28 (1,939.99) 68,063.71 4.14 Capital Outlay 160,100.00 101,916.62 31,623.00 85,429.62 74,615.61 54.77 99.97 TOTAL STREETS 2,037,970.00 652,545.11 666,114.25 888,569.81 122,796.13 1,026,604.06 49.63% TOTAL PUBLIC ENVIRONMENT 2,037,970.00 652,545.11 666,114.25 888,569.81 122,796.13 1,026,604.06 49.63% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 758,970.00 187,770.12 302,061.46 370,445.21 - 388,524.79 48.81 Supplies 113,148.00 35,778.81 59,417.99 33,465.29 17,532.54 62,150.17 45.07 City Support Services 136,000.00 21,768.56 71,194.43 62,982.83 10,464.06 62,553.11 54.01 Utility Services 246,000.00 48,220.25 99,972.10 87,978.32 - 158,021.68 35.76 Operations Support 2,000.00 50.00 122.92 - - 2,000.00 - Staff Support 19,670.00 3,013.74 5,195.34 10,494.30 - 9,175.70 53.35 Professional Services 147,946.00 32,187.00 30,274.30 48,133.35 - 99,812.65 32.53 Maintenance Services 14,000.00 7,315.57 54,501.80 3,677.54 7,212.42 3,110.04 77.79 Rental/Leasing 10,000.00 691.29 2,879.19 3,336.43 650.76 6,012.81 39.87 Operating Equipment 65,000.00 11,937.20 14,995.82 20,386.56 2,200.00 42,413.44 34.75 Capital Outlay 280,997.00 59,173.47 28,639.00 - 147,851.69 133,145.31 52.62 TOTAL PARKS DEPARTMENT 1,793,731.00 407,906.01 669,254.35 640,899.83 185,911.47 966,919.70 46.09% SWIM POOL Supplies 25,500.00 4,543.25 5,558.62 2,929.83 5.86 22,564.31 11.51 Utility Services 16,500.00 7,965.97 7,407.28 8,749.53 - 7,750.47 53.03 Maintenance Services 527,878.00 72,120.46 184,132.30 205,520.04 - 322,357.96 38.93 TOTAL SWIM POOL 569,878.00 84,629.68 197,098.20 217,199.40 5.86 352,672.74 38.11% EVENT FACILITIES Personnel Services 284,722.00 93,193.92 96,311.03 153,125.41 - 131,596.59 53.78 Supplies 3,650.00 1,006.65 1,418.60 1,352.11 220.44 2,077.45 43.08 Utility Services 48,600.00 9,099.66 13,800.83 15,473.61 - 33,126.39 31.84 Operations Support 15,908.00 31.00 8,883.30 123.72 - 15,784.28 0.78 Staff Support 4,865.00 318.99 495.55 1,317.48 99.00 3,448.52 29.12 Maintenance Services 12,700.00 955.70 1,080.00 2,302.07 415.70 9,982.23 21.40 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: June 30, 2022 Operating Equipment 14,500.00 368.97 1,013.99 8,333.83 308.99 5,857.18 59.61 TOTAL EVENT FACILITIES 384,945.00 104,974.89 123,003.30 182,028.23 1,044.13 201,872.64 47.56% TOTAL PARKS & RECREATION 2,748,554.00 597,510.58 989,355.85 1,040,127.46 186,961.46 1,521,465.08 44.64% CULTURAL LIBRARY Personnel Services 904,386.00 247,824.30 422,192.83 464,919.45 - 439,466.55 51.41 Supplies 15,000.00 1,459.49 5,912.77 5,404.10 - 9,595.90 36.03 Utility Services 70,000.00 11,650.25 15,972.51 22,272.57 - 47,727.43 31.82 Operations Support 5,900.00 679.75 959.94 907.94 - 4,992.06 15.39 Staff Support 7,025.00 343.00 1,669.48 5,706.16 - 1,318.84 81.23 Professional Services 3,300.00 - 1,655.96 2,129.00 - 1,171.00 64.52 Operating Equipment 157,762.00 35,610.61 82,706.86 60,442.26 23,744.93 73,574.81 53.36 TOTAL LIBRARY 1,163,373.00 297,567.40 531,070.35 561,781.48 23,744.93 577,846.59 50.33% TOTAL CULTURAL 1,163,373.00 297,567.40 531,070.35 561,781.48 23,744.93 577,846.59 50.33% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 916,558.00 282,067.59 399,396.12 474,127.68 - 442,430.32 51.73 Supplies 8,300.00 3,338.66 1,762.83 4,496.24 926.54 2,877.22 65.33 City Support Services 1,024,097.00 281,818.56 326,740.12 426,237.53 40,680.52 557,178.95 45.59 Utility Services 367,465.00 103,564.09 134,154.92 163,575.25 33,407.68 170,482.07 53.61 Staff Support 69,700.00 17,747.96 1,615.69 12,727.50 83.22 56,889.28 18.38 Professional Services 38,075.00 - 43,879.63 1,406.25 - 36,668.75 3.69 Maintenance Services 10,000.00 - 9,367.96 1,777.35 269.90 7,952.75 20.47 Rental/Leasing 3,650.00 912.54 1,520.90 1,825.08 608.36 1,216.56 66.67 Operating Equipment 269,594.00 93,501.50 176,983.27 107,004.84 79,665.87 82,923.29 69.24 TOTAL INFORMATION TECHNOLOGY 2,707,439.00 782,950.90 1,122,310.44 1,193,177.72 155,642.09 1,358,619.19 49.82% HUMAN RESOURCES Personnel Services 468,069.00 120,661.05 217,666.98 201,626.18 - 266,442.82 43.08 Supplies 2,700.00 283.13 245.96 491.51 837.80 1,370.69 49.23 Human Services 213,400.00 48,126.00 82,885.76 74,046.89 41,217.81 98,135.30 54.01 Operations Support 5,500.00 - 2,433.84 2,324.84 - 3,175.16 42.27 Staff Support 38,150.00 4,836.32 22,087.88 18,073.43 611.46 19,465.11 48.98 City Assistance 15,000.00 6,485.00 5,013.00 8,008.00 990.00 6,002.00 59.99 Professional Services 5,000.00 - - - - 5,000.00 - Operating Equipment 500.00 - 513.31 - - 500.00 - TOTAL HUMAN RESOURCES 748,319.00 180,391.50 330,846.73 304,570.85 43,657.07 400,091.08 46.53% 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: June 30, 2022 Personnel Services 656,579.00 171,363.44 313,818.15 340,748.24 - 315,830.76 51.90 Supplies 2,700.00 182.59 1,718.88 1,430.64 - 1,269.36 52.99 Staff Support 6,740.00 828.52 1,619.00 490.00 - 6,250.00 7.27 Professional Sevices 38,700.00 29,229.47 14,742.12 12,154.32 - 26,545.68 31.41 Operating Equipment 250.00 - 336.08 - - 250.00 - TOTAL FINANCE 704,969.00 201,604.02 332,234.23 354,823.20 - 350,145.80 50.33% PURCHASING & ASSET MGT Personnel Services 237,179.00 75,525.04 116,374.95 126,702.79 - 110,476.21 53.42 Supplies 3,600.00 480.37 99.68 400.69 199.36 2,999.95 16.67 Operations Support 7,550.00 856.00 3,124.00 1,816.00 856.00 4,878.00 35.39 Staff Support 6,785.00 2,466.46 1,150.38 2,866.00 708.96 3,210.04 52.69 City Assistance 2,000.00 905.00 406.00 442.00 629.00 929.00 53.55 Operating Equipment 600.00 379.98 - - - 600.00 - TOTAL PURCHASING & ASSET MGT 257,714.00 80,612.85 121,155.01 132,227.48 2,393.32 123,093.20 52.24% FLEET SERVICE Personnel Services 560,458.00 145,668.91 261,925.77 254,157.87 - 306,300.13 45.35 Supplies 216,700.00 66,960.66 92,479.06 83,819.45 16,535.55 116,345.00 46.31 City Support Services 15,000.00 - 2,372.20 4,689.34 - 10,310.66 31.26 Utility Services 11,500.00 2,705.43 4,926.49 2,307.47 355.44 8,837.09 23.16 Staff Support 32,500.00 4,851.85 9,910.83 3,365.13 676.28 28,458.59 12.44 Maintenance Services 234,953.00 90,908.32 110,934.49 90,915.33 45,348.33 98,689.34 58.00 Operating Equipment 14,000.00 4,595.59 8,455.26 7,973.56 - 6,026.44 56.95 Capital Outlay 221,000.00 61,597.18 6,349.99 64,722.86 124,299.80 31,977.34 85.53 TOTAL FLEET SERVICE 1,306,111.00 383,553.86 497,354.09 511,951.01 187,215.40 606,944.59 53.53% FACILITY SERVICES Personnel Services 820,939.00 212,427.85 415,586.93 377,747.61 - 443,191.39 46.01 Supplies 159,500.00 36,478.17 19,573.26 30,071.54 10,489.76 118,938.70 25.43 City Support Services 5,000.00 - - - - 5,000.00 - Utility Services 186,000.00 47,194.27 71,893.44 78,522.92 - 107,477.08 42.22 Staff Support 18,400.00 5,830.83 2,165.53 2,645.26 746.53 15,008.21 18.43 Professional Services 160,000.00 35,595.93 43,031.32 69,072.06 79,923.66 11,004.28 93.12 Maintenance Services 610,000.00 133,755.35 92,934.80 82,967.62 90,948.92 436,083.46 28.51 Rental/Leasing 500.00 - - - - 500.00 - Operating Equipment 6,000.00 350.00 - - - 6,000.00 - Capital Outlay 32,000.00 - 27,266.00 - 26,121.50 5,878.50 81.63 TOTAL BUILDING MAINTENANCE 1,998,339.00 471,632.40 672,451.28 641,027.01 208,230.37 1,149,081.62 42.50% TOTAL INTERNAL SERVICE 7,722,891.00 2,100,745.53 3,076,351.78 3,137,777.27 597,138.25 3,987,975.48 48.36% 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 MISC & PROJECTS Project Fund Charges/Transfers 1,645,112.00 - 581,300.00 505,411.00 - 1,139,701.00 30.72 TOTAL PROJECTS 1,645,112.00 - 581,300.00 505,411.00 - 1,139,701.00 30.72% CITY ASSISTANCE City's Assistance to Agencies 332,666.00 49,219.00 115,698.42 151,439.00 - 181,227.00 45.52 Operating Equipment 10,000.00 - - - - 10,000.00 - TOTAL CITY ASSISTANCE 342,666.00 49,219.00 115,698.42 151,439.00 - 191,227.00 44.19% 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 5,985.00 5,700.00 5,895.00 2,500.00 11,057.00 43.16 TOTAL COURT-RESTRICTED FUNDS 19,452.00 5,985.00 5,700.00 5,895.00 2,500.00 11,057.00 43.16% TOTAL MISC & PROJECTS 2,292,230.00 55,204.00 702,698.42 662,745.00 2,500.00 1,626,985.00 29.02% TOTAL EXPENDITURES 41,490,207.54 10,819,102.27 18,073,906.24 18,827,575.54 2,306,013.53 20,356,618.47 50.94% REVENUE OVER(UNDER) EXPEND.(0.54) (3,347,280.83) 6,428,404.31 7,768,973.23 (2,306,013.53) (5,462,960.24) 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 308,491.50 14,555,503.24 15,494,454.83 - (74,454.83) 100.48 000-411110 Disable Veterans Assist Pymnt 1,100,000.00 897,968.67 1,064,592.01 897,968.67 - 202,031.33 81.63 000-411200 Advalorem Tax-Delinquent 50,000.00 12,944.10 51,435.29 47,721.33 - 2,278.67 95.44 000-411300 Advalorem Tax-P&I 70,000.00 37,655.43 67,389.44 89,077.80 - (19,077.80) 127.25 000-411500 Sales Tax Revenue-Gen Fund 11,135,000.00 1,689,964.59 8,193,480.97 7,308,242.74 - 3,826,757.26 65.63 000-411600 Bingo Tax - - - - - - - 000-411700 Mixed Beverage Tax 70,000.00 21,425.43 48,151.64 58,318.32 - 11,681.68 83.31 TOTAL Taxes 27,845,000.00 2,968,449.72 23,980,552.59 23,895,783.69 - 3,949,216.31 85.82% Franchises 000-421200 Center Point/Entex Energy 94,000.00 11,957.64 84,279.28 90,505.86 - 3,494.14 96.28 000-421220 City Public Service 980,000.00 209,694.99 738,354.09 695,948.03 - 284,051.97 71.02 000-421240 Guadalupe Valley Elec Co-op 460,000.00 67,718.38 308,310.57 300,880.30 - 159,119.70 65.41 000-421250 New Braunfels Utilities 70,000.00 12,135.24 50,016.88 44,601.33 - 25,398.67 63.72 000-421300 Time Warner-State Franchise 325,000.00 53,449.20 236,851.72 206,478.37 - 118,521.63 63.53 000-421460 AT&T Franchise Fee 100,000.00 13,019.84 21,971.22 56,295.44 - 43,704.56 56.30 000-421480 Other Telecom Franchise - ROW 130,000.00 11,358.90 45,157.64 47,465.95 - 82,534.05 36.51 000-421500 Solid Waste Franchise Fee 168,000.00 29,912.80 124,480.05 115,555.71 - 52,444.29 68.78 TOTAL Franchises 2,327,000.00 409,246.99 1,609,421.45 1,557,730.99 - 769,269.01 66.94% Permits 000-431100 Home Occupation Permit 525.00 70.00 595.00 350.00 - 175.00 66.67 000-431205 Bldg Permit-Residential 601,400.00 74,744.00 403,979.50 229,989.50 - 371,410.50 38.24 000-431210 Bldg Permit-Commercial 250,000.00 501,123.69 138,009.00 633,743.69 - (383,743.69) 253.50 000-431215 Bldg Permit-General 350,000.00 97,697.26 284,541.00 203,622.76 - 146,377.24 58.18 000-431300 Mobile Home Permit 375.00 - 400.00 50.00 - 325.00 13.33 000-431400 Signs Permit 5,000.00 1,965.00 4,610.00 4,555.00 - 445.00 91.10 000-431500 Food Establishmnt Permit 70,000.00 2,700.00 61,180.00 50,525.00 - 19,475.00 72.18 000-431700 Plumbing Permit 130,000.00 21,500.00 97,372.00 68,380.00 - 61,620.00 52.60 000-431750 Electrical Permit 75,000.00 15,900.00 60,220.00 43,580.00 - 31,420.00 58.11 000-431800 Mechanical Permit 68,000.00 13,440.00 42,740.00 33,240.00 - 34,760.00 48.88 000-431900 Solicitor/Peddler Permit 2,000.00 690.00 1,970.00 1,730.00 - 270.00 86.50 000-431950 Animal/Pet Permit 250.00 - - 200.00 - 50.00 80.00 000-432000 Cert of Occupancy Prmt 7,600.00 1,300.00 7,900.00 7,550.00 - 50.00 99.34 000-432100 Security Alarm Permit 43,000.00 12,815.00 27,586.00 29,950.00 - 13,050.00 69.65 000-432300 Grading/Clearing Permit 10,000.00 7,161.06 9,407.00 18,680.23 - (8,680.23) 186.80 000-432400 Development Permit 75,000.00 13,675.51 74,315.60 258,789.60 - (183,789.60) 345.05 000-435000 Fire Permit 30,000.00 9,918.00 21,140.50 22,384.00 - 7,616.00 74.61 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 TOTAL Permits 1,718,150.00 774,699.52 1,235,965.60 1,607,319.78 - 110,830.22 93.55% Licenses 000-441000 Alcohol Beverage License 8,200.00 2,262.50 5,697.50 5,430.00 - 2,770.00 66.22 000-441300 Mobile Home License 120.00 - 80.00 120.00 - - 100.00 000-442000 Contractors License 41,000.00 6,500.00 29,500.00 28,180.00 - 12,820.00 68.73 000-444000 Pet License - - - - - - - TOTAL Licenses 49,320.00 8,762.50 35,277.50 33,730.00 - 15,590.00 68.39% Fees 000-451000 Municipal Court Fines 625,000.00 129,199.66 366,745.08 355,242.98 - 269,757.02 56.84 000-451010 Texas Motor Carrier Fines - 2,117.50 - 21,704.00 - (21,704.00) - 000-451015 CVE Out of Service - 263.50 - 1,900.00 - (1,900.00) 000-451100 Arrest Fee 21,300.00 4,195.94 11,382.75 11,473.53 - 9,826.47 53.87 000-451110 Expunction Fee 100.00 - - - - 100.00 - 000-451200 Warrant Fees 67,400.00 14,527.52 39,595.55 42,005.53 - 25,394.47 62.32 000-451220 Officer Jury Fee 200.00 - - - - 200.00 - 000-451310 Restitution Fee-Local 100.00 - 102.60 - - 100.00 - 000-451320 Civil Justice Fee-Court - - - - - - - 000-451340 Judicial Fee-City 1,524.00 83.11 416.30 275.37 - 1,248.63 18.07 000-451400 Traffic Fine Costs TTL 9,924.00 1,806.91 4,891.62 4,916.57 - 5,007.43 49.54 000-451510 Juvenile Case Mgmt Fee 12,768.00 697.77 3,479.09 2,304.91 - 10,463.09 18.05 000-451520 Truancy Fees 13,584.00 4,178.67 9,995.31 11,193.88 - 2,390.12 82.40 000-451530 Local Municipal Jury Fund 225.00 81.79 191.09 217.84 - 7.16 96.82 000-451600 Technology Fund Fee 19,452.00 3,838.47 10,518.22 10,627.95 - 8,824.05 54.64 000-451700 Security Fee 18,900.00 4,432.28 11,519.53 12,110.99 - 6,789.01 64.08 000-451800 Time Payment Fee-City 4,140.00 1,146.29 1,707.00 3,459.28 - 680.72 83.56 000-451850 State Fines 10% Service Fee 32,612.00 - 21,271.98 10,610.97 - 22,001.03 32.54 000-451900 DPS Payment-Local 5,052.00 1,284.66 3,037.21 3,441.75 - 1,610.25 68.13 000-452000 Child Safety Fee 5,880.00 1,479.26 4,217.63 3,771.77 - 2,108.23 64.15 000-452100 Platting Fees 54,000.00 5,500.00 33,500.00 41,250.00 - 12,750.00 76.39 000-452200 Site Plan Fee 23,000.00 5,000.00 14,000.00 18,500.00 - 4,500.00 80.43 000-452300 Plan Check Fee 600,000.00 284,024.49 366,836.00 454,615.74 - 145,384.26 75.77 000-452320 Tree Mitigation Admin Fee 15,000.00 - 38,737.50 11,550.00 - 3,450.00 77.00 000-452400 BOA/Variance Fees 2,500.00 500.00 1,500.00 2,500.00 - - 100.00 000-452600 Specific Use/Zone Chng Fee 26,450.00 18,250.00 26,300.00 31,000.00 - (4,550.00) 117.20 000-452710 Zoning Ltr & Dev Rights 2,550.00 2,550.00 2,100.00 4,350.00 - (1,800.00) 170.59 000-453100 Reinspection Fees 190,000.00 43,050.00 130,050.00 144,100.00 - 45,900.00 75.84 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: June 30, 2022 000-453110 Swim Pool Inspection Fee 2,500.00 330.00 2,860.00 660.00 - 1,840.00 26.40 000-453200 Lot Abatement 5,000.00 875.00 1,825.00 4,725.00 - 275.00 94.50 000-453211 Admin Fee-Inspections 10,000.00 2,700.00 2,600.00 9,900.00 - 100.00 99.00 000-453310 Misc Inspection Fees - - - - - - - 000-453710 Foster Care 500.00 - 300.00 50.00 - 450.00 10.00 000-454200 Pool Gate Admission Fee 22,000.00 12,380.00 9,712.48 12,380.00 - 9,620.00 56.27 000-454300 Seasonal Pool Pass Fee 4,000.00 6,305.00 6,480.00 6,305.00 - (2,305.00) 157.63 000-456110 Senior Center Memberships - 5,426.00 - 18,451.00 - (18,451.00) - 000-456120 Senior Center Meal Fee 20,000.00 1,642.11 20,875.89 12,180.57 - 7,819.43 60.90 000-456500 HAZ MAT Fees 5,000.00 - - - - 5,000.00 - 000-456600 Fire Re-inspection Fee 750.00 - 300.00 50.00 - 700.00 6.67 000-458000 Sale of General Fixed Assets - - - 37,572.00 - (37,572.00) - 000-458100 Sale of Merchandise - - 90.00 - - - - 000-458110 Sale of Mdse - GovDeals 100,000.00 1,121.38 111,698.84 4,374.27 - 95,625.73 4.37 000-458400 Civic Center Rental Fees 140,000.00 76,676.25 9,130.00 210,009.00 - (70,009.00) 150.01 000-458401 Capital Recovery Fee-Civic C - 925.00 6,575.00 1,600.00 - (1,600.00) - 000-458402 Civic Center Ancillary Fees - 750.00 10.00 1,015.00 - (1,015.00) - 000-458450 North Center Rental Fees 18,000.00 9,218.75 19,812.50 28,750.00 - (10,750.00) 159.72 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 25,000.00 17,989.00 21,624.00 44,009.25 - (19,009.25) 176.04 000-458501 Community Center Service Fees - 250.00 350.00 650.00 - (650.00) - 000-458510 Grand Ballroom Rental Fees - (5,100.00) 44,270.00 (30,693.75) - 30,693.75 - 000-458520 Cut-Off Hall Rental Fees - - 4,566.25 600.00 - (600.00) - 000-458530 Conference Hall Rental Fees - - 506.25 - - - - 000-458540 Bluebonnet Hall Rental Fees - (900.00) 17,355.00 (2,737.50) - 2,737.50 - 000-458550 Pavilion Rental Fees 20,000.00 7,575.00 15,837.50 18,865.00 - 1,135.00 94.33 000-458551 Equipment Rentals-Parks - 40.00 - 40.00 - (40.00) - 000-458560 Chamber of Comm Rent 7,800.00 1,950.00 5,850.00 5,850.00 - 1,950.00 75.00 000-458570 Non-Resident SYSA League 10,000.00 - 5,990.00 7,500.00 - 2,500.00 75.00 000-458580 HOA Meeting Rental Fees - - 750.00 - - - - 000-458581 Funeral Reception Rental Fees - - 675.00 - - - - 000-458582 Quality of Life Rental Fees - - 5,775.00 - - - - 000-458590 Cancellation Fees-Event Rental - 850.00 1,250.00 1,500.00 - (1,500.00) - 000-458650 NonResident User Fee-BVYA 10,000.00 3,710.00 12,600.00 7,240.00 - 2,760.00 72.40 000-458660 BVYA Utility Reimbursement 15,000.00 2,573.71 14,738.38 6,485.71 - 8,514.29 43.24 000-458670 SYSA Utility Reimbursement 7,500.00 1,669.28 - 6,651.48 - 848.52 88.69 000-458675 Lions Futbol Utility Reimbrsmt 15,000.00 - 15,548.00 3,516.00 - 11,484.00 23.44 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: June 30, 2022 000-458685 Recreation Programs 1,000.00 (25.00) - (25.00) - 1,025.00 (2.50) 000-458685.001Rec Prgrm-Kickball Leagues 2,600.00 805.00 3,650.00 4,405.00 - (1,805.00) 169.42 000-458700 Vehicle Impoundment 11,000.00 3,270.00 8,220.00 9,930.00 - 1,070.00 90.27 000-459200 NSF Check Fee 100.00 - - - - 100.00 - 000-459300 Notary Fee 48.00 12.00 54.00 42.00 - 6.00 87.50 000-459400 Maps,Copies,UDC & Misc Fees - - - - - - - 000-459600 Animal Adoption Fee 9,000.00 2,605.00 7,425.00 7,835.00 - 1,165.00 87.06 000-459700 Pet Impoundment Fee 7,000.00 3,913.00 6,436.00 8,629.00 - (1,629.00) 123.27 000-459800 Police Reports Fee 5,000.00 1,758.00 4,986.03 4,311.39 - 688.61 86.23 TOTAL Fees 2,232,459.00 690,902.30 1,496,620.58 1,657,148.48 - 575,310.52 74.23% Fines 000-463000 Library Fines 9,000.00 2,860.99 5,754.04 7,898.37 - 1,101.63 87.76 TOTAL Fines 9,000.00 2,860.99 5,754.04 7,898.37 - 1,101.63 87.76% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,077.00 - 21,077.76 7,025.92 - 14,051.08 33.33 000-473200 City of Seguin-Fire Contract 30,107.00 5,575.52 25,089.84 19,514.32 - 10,592.68 64.82 000-473300 Guadalupe Co-Library 217,000.00 36,192.00 152,393.22 162,864.00 - 54,136.00 75.05 000-473400 Randolph AFB-Animal Control - - - - - - - 000-474200 Library Services-Cibolo 40,000.00 - 40,000.00 40,000.00 - - 100.00 000-474210 Library Services-Selma 26,000.00 - 25,020.00 24,825.00 - 1,175.00 95.48 000-474400 Dispatch Service-Cibolo 160,000.00 40,000.00 83,000.00 163,000.00 - (3,000.00) 101.88 000-474600 School Crossing Guard-Bexar Co 36,000.00 8,051.65 29,895.97 26,463.65 - 9,536.35 73.51 000-474610 School Cross Guard-Guadalupe C 41,000.00 13,679.67 34,290.03 35,117.41 - 5,882.59 85.65 000-474620 School Crossing Guards - Comal 1,900.00 14,571.25 1,812.57 14,571.25 - (12,671.25) 766.91 000-474700 School Officer Funding 367,514.00 - 271,830.00 183,756.00 - 183,758.00 50.00 000-474750 Crime Victim Liaison Agreement 50,000.00 - 25,000.00 6,250.00 - 43,750.00 12.50 TOTAL Inter-Jurisdictional 990,598.00 118,070.09 709,409.39 683,387.55 - 307,210.45 68.99% Fund Transfers 000-480000 Indirect Costs-EMS 212,740.00 53,184.99 137,011.50 159,555.01 - 53,184.99 75.00 000-480100 Indirect Costs-Hotel/Motel 74,443.00 18,610.74 54,348.07 55,832.26 - 18,610.74 75.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 214,129.53 231,007.50 - 77,002.50 75.00 000-486000 Interfund Chrges-Admin W&S 1,478,230.00 369,557.49 1,088,120.21 1,108,672.51 - 369,557.49 75.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: June 30, 2022 000-487000 Interfund Charges-Fleet 505,509.00 126,377.25 298,249.60 379,131.75 - 126,377.25 75.00 000-488000 Interfund Charges-4B 506,984.00 253,492.00 504,669.00 506,984.00 - - 100.00 000-489000 Transfer In 203,706.00 - - - - 203,706.00 - TOTAL Fund Transfers 5,612,630.00 898,224.97 2,296,527.91 2,441,183.03 - 3,171,446.97 43.49% Miscellaneous 000-491000 Interest Earned 15,000.00 2,306.23 5,361.73 5,854.79 - 9,145.21 39.03 000-491200 Investment Income 120,000.00 43,276.18 43,994.74 65,564.81 - 54,435.19 54.64 000-491900 Unrealized Gain/Loss-CapOne - (16,288.35) (24,950.85) (57,114.67) - 57,114.67 - 000-493000 Donations-Others - - 500.00 - - - - 000-493120 Donations-Public Library 10,000.00 169.58 1,690.50 1,038.27 - 8,961.73 10.38 000-493400 Donations-Animal Control 5,000.00 1,951.00 2,335.00 3,143.00 - 1,857.00 62.86 000-493401 Donations-A/C Microchip - 15.00 940.00 85.00 - (85.00) - 000-493460 Donations- Parks 10,000.00 - - - - 10,000.00 - 000-493465 Donations-Senior Center 10,000.00 1,429.33 465.00 3,770.33 - 6,229.67 37.70 000-493503 Donation-Fire Rescue 1,000.00 - 800.00 - - 1,000.00 - 000-493618 Donation - Veteran's Memorial 1,250.00 150.00 1,425.00 2,630.00 - (1,380.00) 210.40 000-493700 July 4th Activities 26,000.00 27,750.00 14,876.00 27,750.00 - (1,750.00) 106.73 000-493701 Proceeds-Holidazzle 12,500.00 - 3,290.00 21,600.00 - (9,100.00) 172.80 000-493704 Moving on Main 4,000.00 3,400.00 9,950.00 8,700.00 - (4,700.00) 217.50 000-493707 Cornhole League - - - - - - - 000-494481 LawEnforcemtOfficersStnd&5,000.00 - 4,489.49 4,151.77 - 848.23 83.04 000-494482 Grants-Police, Fire, Gen Fund 12,500.00 - 541.11 - - 12,500.00 - 000-495100 Mobile Stage Rental Fees - 2,550.00 - 3,600.00 - (3,600.00) - 000-497000 Misc Income-Gen Fund 50,000.00 17,578.66 167,197.99 40,325.08 - 9,674.92 80.65 000-497005 Schertz Magazine Advertising 140,000.00 34,115.62 117,961.62 106,393.12 - 33,606.88 76.00 000-497100 Misc Income-Police 9,000.00 2,568.25 8,581.52 6,414.05 - 2,585.95 71.27 000-497200 Misc Income-Library 3,000.00 1,067.80 1,661.40 2,778.95 - 221.05 92.63 000-497210 Misc Income-Library Copier 15,000.00 3,627.67 5,191.30 10,485.17 - 4,514.83 69.90 000-497300 Misc Income-Animal Control 800.00 330.00 683.50 330.00 - 470.00 41.25 000-497400 Misc Income-Streets Dept 50,000.00 11,584.76 13,626.67 26,420.27 - 23,579.73 52.84 000-497460 Misc Income-Parks - (10.00) 360.00 74.60 - (74.60) - 000-497500 Misc Income-TML Ins. Claims 25,000.00 6,661.80 6,946.19 7,492.06 - 17,507.94 29.97 000-497550 Misc Income-TML WC Reimbursmnt 10,000.00 3,171.95 25,795.60 49,202.22 - (39,202.22) 492.02 000-497600 Misc Income-Vending Mach 2,500.00 274.01 290.57 965.28 - 1,534.72 38.61 000-497610 Misc Income-Muni Court - - 0.01 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: June 30, 2022 000-498105 Reimbursmt Police OT-DEA 35,000.00 8,902.41 36,074.58 22,517.48 - 12,482.52 64.34 000-498107 Reimbrsmnt-Police OT-Events - - - - - - - 000-498110 Reimburmnt Fire-Emg Acti-OT 100,000.00 46,807.89 40,312.45 446,209.28 - (346,209.28) 446.21 000-498150 Reimbursement - Library 13,000.00 - 8,598.66 - - 13,000.00 - TOTAL Miscellaneous 706,050.00 211,389.79 499,439.78 818,452.77 - (112,402.77) 115.92% TOTAL REVENUES 41,490,207.00 6,082,606.87 31,868,968.84 32,702,634.66 - 8,787,572.34 78.82% Cash in Bank Claim on Operating Cash Pool-Checking 589,555.72$ Cash in Investments LOGIC Investment-General Fund 16,022,342.01 LOGIC Investment-Equip Replacement 79,304.79 LOGIC Investment-Veh Replacement 534,734.82 LOGIC Investment-Air Condi Replacment 291,006.82 CAPITAL ONE Investment-General Fund 1,416,846.66 CD - Bank of New York 251,044.53 CD - Capital One MCLEAN 251,271.70 CD - Capital One ALLEN 251,271.70 CD - Goldman Sachs 251,271.70 Total Cash in Bank & Investments 19,938,650.45$ GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 Updated report at 5/12/2020 by Maya AS OF: March 31, 2020 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2021-22 1,004,614 1,103,814 826,933 926,859 1,104,306 840,622 803,436 1,090,848 969,440 2020-21 743,235 894,399 769,523 766,917 1,051,843 776,582 652,217 1,039,235 878,852 881,389 1,342,856 917,603 2019-20 669,061 809,661 729,135 656,810 908,377 953,913 662,240 840,330 708,822 765,963 880,492 847,850 2018-19 766,254 736,285 627,360 571,251 769,881 603,905 647,650 699,759 950,507 681,755 769,754 487,275 2017-18 644,584 686,048 615,170 627,981 744,714 583,818 673,567 750,755 640,283 840,254 795,116 634,780 1,004,614 1,103,814 826,933 926,859 1,104,306 840,622 803,436 1,090,848 969,440 - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 Sales Tax-General Fund AS OF: March 31, 2020 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2021-22 64,306 790,610 7,588,294 4,069,380 2,505,204 168,170 49,143 82,010 177,339 2020-21 67,176 970,388 6,869,022 3,995,189 2,086,758 244,347 76,381 71,700 174,542 42,752 33,745 130,219 2019-20 181,122 806,033 6,755,473 4,432,940 1,463,522 101,212 72,046 56,463 88,055 48,550 20,479 76,361 2018-19 255,207 587,379 5,347,223 5,289,147 160,362 85,307 60,277 71,690 56,808 39,643 25,332 23,338 2017-18 100,310 505,909 5,577,660 3,375,990 1,936,953 117,684 82,856 52,620 21,817 16,745 47,029 14,080 - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 ADVALOREM TAX Updated report at 5/12/2020 by Maya AS OF: March 31, 2020 NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2021-22 304,524 241,989 261,111 2020-21 233,351 231,254 273,749 297,978 2019-20 240,156 192,246 261,394 286,756 2018-19 270,225 203,885 199,326 263,032 2017-18 271,335 208,803 213,511 283,058 $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 CITY PUBLIC SERVICE 2021-22 2020-21 2019-20 2018-19 2017-18 C I T Y O F S C H E R T Z 106-SPECIAL EVENTS FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Miscellaneous 24,000.00 96.67 43,671.54 50,040.08 - (26,040.08) 208.50 TOTAL REVENUES 24,000.00 96.67 43,671.54 50,040.08 - (26,040.08) 208.50% EXPENDITURE SUMMARY GENERAL GOVERNMENT CULTURAL KICK CANCER 10,000.00 6,687.07 4,283.74 9,848.94 - 151.06 98.49 HAL BALDWIN SCHOLARSHIP 14,000.00 5,000.00 16,631.75 19,706.88 12.40 (5,719.28) 140.85 TOTAL CULTURAL 24,000.00 11,687.07 20,915.49 29,555.82 12.40 (5,568.22) 123.20% TOTAL EXPENDITURES 24,000.00 11,687.07 20,915.49 29,555.82 12.40 (5,568.22) 123.20% REVENUE OVER(UNDER) EXPEND 0.00 (11,590.40) 22,756.05 20,484.26 (12.40) (20,471.86) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 C I T Y O F S C H E R T Z 106-SPECIAL EVENTS FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Miscellaneous 000-491200 Investment Income - 36.67 15.54 46.74 - (46.74) - 000-492200 Kick Cancer 10,000.00 - 2,795.00 9,595.00 - 405.00 95.95 000-493621 Hal Baldwin Scholarship 14,000.00 - 28,980.00 35,626.34 - (21,626.34) 254.47 000-497000 Misc Income - Special Events - 60.00 456.00 4,772.00 - (4,772.00) - TOTAL Miscellaneous 24,000.00 96.67 43,671.54 50,040.08 - (26,040.08) 208.50% TOTAL REVENUES 24,000.00 96.67 43,671.54 50,040.08 - (26,040.08) 208.50% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 C I T Y O F S C H E R T Z Cash in Bank Current Claim on Operating Cash Pool-Checking 123,236.03$ Cash in Investments Texas Class- Special Events 18,095.04 Total Cash in Bank & Investments 141,331.07$ SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 110-PEG FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Franchises 110,000.00 19,253.22 58,260.65 59,812.68 - 50,187.32 54.38 Fund Transfers 757,521.00 - - - - 757,521.00 - TOTAL REVENUES 867,521.00 19,253.22 58,260.65 59,812.68 - 807,708.32 6.89% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental MISC & PROJECTS Projects Capital Outlay 517,521.00 - - - 460,977.82 56,543.18 89.07 TOTAL MISC & PROJECTS 867,521.00 - - - 460,977.82 406,543.18 53.14% TOTAL EXPENDITURES 867,521.00 - - - 460,977.82 406,543.18 53.14% REVENUE OVER(UNDER) EXPEND - 19,253.22 58,260.65 59,812.68 (460,977.82) 401,165.14 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 110-PEG FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Franchises 000-421350 Time Warner - PEG Fee 60,000.00 15,094.87 30,564.59 46,626.93 - 13,373.07 77.71 000-421465 AT&T PEG Fee 50,000.00 4,158.35 27,696.06 13,185.75 - 36,814.25 26.37 TOTAL Franchises 110,000.00 19,253.22 58,260.65 59,812.68 - 50,187.32 54.38% Fund Transfers 000-481000 Transfer In - Reserves 757,521.00 - - - - 757,521.00 - TOTAL Fund Transfers 757,521.00 - - - - 757,521.00 0.00% Miscellaneous TOTAL REVENUES 867,521.00 19,253.22 58,260.65 59,812.68 - 807,708.32 6.89% AS OF: June 30, 2022 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) Cash in Bank Cash Balance 1,006,266.73$ Total Cash in Bank & Investments 1,006,266.73$ PEG FUND CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 202-WATER & SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Franchises 304,487.00 91,992.45 294,413.42 360,419.37 - (55,932.37) 118.37 Permits - - - - - - - Fees 27,485,000.00 7,226,033.36 18,580,200.59 20,653,794.49 - 6,831,205.51 75.15 Fund Transfers 526,000.00 37,500.00 134,803.98 112,500.36 - 413,499.64 21.39 Miscellaneous 443,236.00 96,165.71 268,674.67 306,096.49 - 137,139.51 69.06 TOTAL REVENUES 28,758,723.00 7,451,691.52 19,278,092.66 21,432,810.71 - 7,325,912.29 74.53% EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers - - 619,745.69 - - - - TOTAL NON DEPARTMENTAL - - 619,745.69 - - - 0.00% BUSINESS OFFICE Personnel Services 547,378.00 124,888.52 382,962.05 388,083.99 - 159,294.01 70.90 Supplies 185,100.00 17,465.65 134,110.80 128,711.21 20,295.04 36,093.75 80.50 City Support Services 68,500.00 - 33,151.19 37,261.69 - 31,238.31 54.40 Utility Services 9,400.00 2,870.03 6,795.75 7,363.33 - 2,036.67 78.33 Operations Support 102,500.00 28,854.09 69,787.18 81,228.33 10,737.78 10,533.89 89.72 Staff Support 6,400.00 810.75 1,985.82 3,106.63 20.86 3,272.51 48.87 Professional Services 259,000.00 61,939.57 181,877.18 195,904.06 - 63,095.94 75.64 Maintenance Services 5,040.00 1,680.00 3,780.00 3,780.00 1,260.00 - 100.00 Operating Equipment - - - - - - - TOTAL BUSINESS OFFICE 1,247,318.00 238,508.61 814,449.97 845,439.24 90,638.18 311,240.58 75.05% W & S ADMINISTRATION Personnel Services 1,951,955.00 488,901.99 1,460,443.78 1,363,085.71 - 588,869.29 69.83 Supplies 65,000.00 1,453.21 43,202.23 12,769.17 28,328.73 23,902.10 63.23 City Support Services 170,500.00 177.76 67,234.24 71,998.15 30.17 98,471.68 42.25 Utility Services 3,583,200.00 920,647.83 2,665,273.65 2,568,321.95 - 1,014,878.05 71.68 Operations Support 12,050.00 2,377.23 6,685.39 5,602.07 62.00 6,385.93 47.00 Staff Support 43,000.00 10,788.12 22,452.91 18,195.46 43.55 24,760.99 42.42 City Assistance 250.00 - 80.00 40.00 - 210.00 16.00 Professional Services 476,970.00 72,328.23 351,900.57 221,245.28 20,235.00 235,489.72 50.63 Fund Charges/Transfers 6,825,826.00 1,595,646.86 4,965,077.64 5,411,840.85 - 1,413,985.15 79.28 Maintenance Services 9,234,040.00 2,670,644.15 6,875,925.33 7,369,465.40 231,341.68 1,633,232.92 82.31 Other Costs 38,500.00 - 39,999.99 36,605.45 10.00 1,884.55 95.11 Debt Service 1,518,553.00 - 1,575,649.23 1,282,098.50 - 236,454.50 84.43 Other Financing Sources - - - 57,094.83 - (57,094.83) - Rental/Leasing 12,200.00 17,000.00 79,568.01 79,265.24 - (67,065.24) 649.72 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 202-WATER & SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 Operating Equipment 9,000.00 2,519.03 3,858.84 3,283.78 - 5,716.22 36.49 Capital Outlay 163,000.00 13,903.04 48,627.00 46,061.35 128,357.50 (11,418.85) 107.01 TOTAL PUBLIC WORKS 24,104,044.00 5,796,387.45 18,205,978.81 18,546,973.19 408,408.63 5,148,662.18 78.64% MISC & PROJECTS PROJECTS Professional Services 0.00 - 7,882.50 - 3,469.00 (3,469.00) - Fund Charges/Transfers - - - 5,000,000.00 - (5,000,000.00) - Maintenance Services 0.00 - 762,716.86 - 4,500.00 (4,500.00) - Rental/Leasing 570,000.00 - - - - 570,000.00 - TOTAL PROJECTS 570,000.00 - 770,599.36 5,000,000.00 7,969.00 (4,437,969.00) 878.59% SEWER PROJECT Professional Services - - - - - - - Fund Charges/Transfers - - - - - - - TOTAL SEWER PROJECTS - - - - - - 0.00% TOTAL MISC & PROJECTS 570,000.00 - 770,599.36 5,000,000.00 7,969.00 (4,437,969.00) 878.59% TOTAL EXPENDITURES 25,921,362.00 6,034,896.06 20,410,773.83 24,392,412.43 507,015.81 1,021,933.76 96.06% ** REVENUE OVER(UNDER)EXPENSES **2,837,361.00 1,416,795.46 (1,132,681.17) (2,959,601.72) (507,015.81) 6,303,978.53 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 91,992.45 294,413.42 360,419.37 - (55,932.37) 118.37 TOTAL Franchises 304,487.00 91,992.45 294,413.42 360,419.37 - (55,932.37) 118.37% Permits 000-436010 Network Nodes - - - - - - TOTAL Permits - - - - - - 0.00% Fees 000-455200 Garbage Collection Fee 5,300,000.00 1,470,868.92 3,740,934.88 4,208,990.84 - 1,091,009.16 79.41 000-455600 Fire Line Fees - - - - - - - 000-455700 Recycle Fee Revenue 345,000.00 86,853.96 242,362.19 259,650.00 - 85,350.00 75.26 000-455800 W&S Line Constructn Reimbur 25,000.00 2,838.00 21,457.52 11,041.00 - 13,959.00 44.16 000-457100 Sale of Water 12,600,000.00 3,258,222.07 8,193,962.55 8,976,745.58 - 3,623,254.42 71.24 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 17,552.23 79,365.18 55,095.78 - 64,904.22 45.91 000-457400 Sewer Charges 8,770,000.00 2,311,386.14 6,245,236.55 6,910,569.82 - 1,859,430.18 78.80 000-457500 Water Penalties 250,000.00 77,687.04 400.00 229,676.47 - 20,323.53 91.87 000-458110 Sale of Merchandise - GovDeals 2500.00 - 41,000.00 - - 2,500.00 - 000-459200 NSF Check Fee-Water&Sewer 2,500.00 625.00 1,600.00 2,025.00 - 475.00 81.00 TOTAL Fees 27,485,000.00 7,226,033.36 18,580,200.59 20,653,794.49 - 6,831,205.51 75.15% 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 109,800.00 112,500.00 - 37,500.00 75.00 000-486406 Transfer In - Pblc Imprvmnt 0.00 - 25,003.98 0.36 - (0.36) - TOTAL Fund Transfers 526,000.00 37,500.00 134,803.98 112,500.36 - 413,499.64 21.39% Miscellaneous 000-490000 Misc Charges 10,500.00 3,106.00 4,725.00 9,006.00 - 1,494.00 85.77 000-491000 Interest Earned 20,000.00 5,815.10 6,322.32 11,809.28 - 8,190.72 59.05 000-491200 Investment Income 90,000.00 9,596.62 29,893.72 28,874.34 - 61,125.66 32.08 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 982.97 61,922.90 2,564.89 - 22,435.11 10.26 000-498110 Salary Reimb-SSLGC 297,736.00 76,665.02 165,810.73 253,842.13 - 43,893.87 85.26 000-499100 Distribution-GSE Bond Set - - - (0.15) - 0.15 - TOTAL Miscellaneous 443,236.00 96,165.71 268,674.67 306,096.49 - 137,139.51 69.06% TOTAL REVENUES 28,758,723.00 7,451,691.52 19,278,092.66 21,432,810.71 - 7,325,912.29 74.53% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 382,094.44$ Cash in Investments Lone Star Investment-Water&Sewer 4,694,190.19 Lone Star Investment-W&S Customer Deposits 318,393.65 Lone Star Investment-W&S Equip Replacement 191,433.26 Lone Star Investment-W&S Veh Replacement 276,542.70 Schertz Bank & Trust-Certificate of Deposit 1,163,351.07 6,643,910.87$ Total Cash in Bank & Investments 7,026,005.31$ WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 203-EMS CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 6,545,489.60 1,238,376.38 5,064,094.52 5,714,472.15 - 831,017.45 87.30 Inter-Jurisdictional 3,985,932.54 1,409,342.68 2,972,124.28 3,702,382.72 - 283,549.82 92.89 Fund Transfers 1,088,672.00 - - - - 1,088,672.00 - Miscellaneous 174,500.00 33,169.29 97,109.84 61,287.58 - 113,212.42 35.12 TOTAL REVENUES 11,794,594.14 2,680,888.35 8,133,328.64 9,478,142.45 - 2,316,451.69 80.36% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 5,576,958.00 1,568,891.95 3,853,186.79 4,530,430.88 - 1,046,527.12 81.23 Supplies 387,250.00 102,019.95 236,342.63 311,881.12 116,762.15 (41,393.27) 110.69 City Support Services 138,000.00 26,783.47 69,754.29 75,705.59 - 62,294.41 54.86 Utility Services 106,000.00 54,332.22 80,615.23 116,023.12 1,255.97 (11,279.09) 110.64 Operations Support 40,000.00 7,761.68 24,509.59 25,030.90 139.40 14,829.70 62.93 Staff Support 73,265.00 21,558.63 32,261.55 61,852.77 7,168.66 4,243.57 94.21 City Assistance 626,989.01 158,778.42 459,725.36 417,192.15 51,572.75 158,224.11 74.76 Professional Services 123,500.00 27,584.35 86,542.67 121,685.96 13,858.12 (12,044.08) 109.75 Fund Charges/Transfers 2,663,735.60 371,611.19 2,218,768.96 2,121,930.56 - 541,805.04 79.66 Maintenance Services 13,000.00 5,760.00 5,760.00 6,720.00 - 6,280.00 51.69 Other Costs 0.00 - - - - - - Debt Service 118120.00 - 113,375.00 116,725.00 - 1,395.00 98.82 Rental/Leasing 150,000.00 78,509.17 65,118.05 145,102.65 - 4,897.35 96.74 Operating Equipment 115,298.00 14,019.23 30,970.32 24,140.88 10,013.23 81,143.89 29.62 Capital Outlay 1,603,978.00 152,435.00 432,395.16 809,656.66 275,547.42 518,773.92 67.66 TOTAL PUBLIC SAFETY 11,736,093.61 2,590,045.26 7,709,325.60 8,884,078.24 476,317.70 2,375,697.67 79.76% TOTAL EXPENDITURES 11,736,093.61 2,590,045.26 7,709,325.60 8,884,078.24 476,317.70 2,375,697.67 79.76% ** REVENUE OVER(UNDER) EXPENSES **58,500.53 90,843.09 424,003.04 594,064.21 (476,317.70) (59,245.98) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 203-EMS CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-456100 Ambulance/Mileage Transprt Fee 6,206,889.60 1,142,574.99 4,817,905.30 5,430,230.62 - 776,658.98 87.49 000-456110 Passport Membership Fees 28,000.00 975.00 25,645.00 25,840.00 - 2,160.00 92.29 000-456120 EMT Class - Fees 137,500.00 31,950.00 102,150.00 117,775.00 - 19,725.00 85.65 000-456122 CE Class - Fees 24,000.00 18,523.20 19,694.77 18,523.20 - 5,476.80 77.18 000-456130 Immunization Fees 3,000.00 - 1,723.30 2,227.45 - 772.55 74.25 000-456140 Billing Fees-External 26,000.00 6,479.59 14,909.74 16,672.57 - 9,327.43 64.13 000-456150 Standby Fees 30,000.00 7,308.75 30,004.95 41,988.70 - (11,988.70) 139.96 000-456155 Community Services Support 50,000.00 19,863.85 21,976.46 31,282.61 - 18,717.39 62.57 000-456160 MIH Services 40,000.00 10,701.00 30,060.00 29,882.00 - 10,118.00 74.71 000-459200 NSF Check Fee 100.00 - 25.00 50.00 - 50.00 50.00 TOTAL Fees 6,545,489.60 1,238,376.38 5,064,094.52 5,714,472.15 - 831,017.45 87.30% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 927,934.89 154,655.82 773,279.10 618,623.28 - 309,311.61 66.67 000-474200 JBSA Support 635,706.00 158,926.62 - 423,804.32 - 211,901.68 66.67 000-474300 Cibolo Support 529,043.95 264,521.98 473,115.24 529,043.96 - (0.01) 100.00 000-475100 Comal Co ESD #6 148,870.54 82,476.44 141,411.38 159,666.96 - (10,796.42) 107.25 000-475200 Live Oak Support 280,240.92 126,193.68 246,255.84 259,350.75 - 20,890.17 92.55 000-475300 Universal City Support 335,884.88 167,942.44 321,566.04 335,884.88 - - 100.00 000-475400 Selma Support 180,290.22 90,145.12 171,441.00 180,290.24 - (0.02) 100.00 000-475500 Schertz Support 695,644.24 347,822.12 667,048.68 695,644.24 - - 100.00 000-475600 Santa Clara Support 11,953.03 5,976.52 11,455.20 11,953.04 - (0.01) 100.00 000-475800 Marion Support 21,363.87 10,681.94 18,374.76 21,363.88 - (0.01) 100.00 000-475910 TASPP Program 219,000.00 - 148,177.04 466,757.17 - (247,757.17) 213.13 TOTAL Inter-Jurisdictional 3,985,932.54 1,409,342.68 2,972,124.28 3,702,382.72 - 283,549.82 92.89% 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 203.48 341.72 367.18 - 2,132.82 14.69 000-491200 Investment Income 5,000.00 1,398.97 865.67 1,800.64 - 3,199.36 36.01 000-493203 Donations-EMS 2,000.00 - 925.00 650.00 - 1,350.00 32.50 000-497000 Misc Income 75,000.00 18,990.00 39,831.33 26,557.99 - 48,442.01 35.41 000-497100 Recovery of Bad Debt 20,000.00 2,706.75 9,201.82 6,369.38 - 13,630.62 31.85 000-497110 Collection Agency-Bad Debt 70,000.00 9,870.09 45,944.30 25,542.39 - 44,457.61 36.49 TOTAL Miscellaneous 174,500.00 33,169.29 97,109.84 61,287.58 - 113,212.42 35.12% TOTAL REVENUES 11,794,594.14 2,680,888.35 8,133,328.64 9,478,142.45 - 2,316,451.69 80.36% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 46,395.60$ Cash in Investments EMS-Logic 699,228.10 Total Cash in Bank & Investments 745,623.70$ C I T Y O F S C H E R T Z CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 204-DRAINAGE CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Permits 4,000.00 2,600.00 4,320.00 6,850.00 - (2,850.00) 171.25 Fees 1,260,000.00 314,906.49 885,610.99 941,435.42 - 318,564.58 74.72 Fund Transfers 17,229.00 - - - - 17,229.00 - Miscellaneous 3,000.00 905.09 722.55 1,199.62 - 1,800.38 39.99 TOTAL REVENUES 1,284,229.00 318,411.58 890,653.54 949,485.04 - 334,743.96 73.93% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 456,920.00 101,260.21 298,806.61 257,129.93 - 199,790.07 56.27 Supplies 8,500.00 1,296.15 2,785.61 1,422.12 1,909.25 5,168.63 39.19 City Support Services 20,500.00 237.66 4,023.21 4,424.30 30.15 16,045.55 21.73 Utility Services 26,700.00 6,568.21 13,683.82 15,134.55 - 11,565.45 56.68 Operations Support 1,050.00 - - - - 1,050.00 - Staff Support 13,700.00 6,529.66 5,288.69 9,443.70 - 4,256.30 68.93 City Assistance 500.00 - 80.00 40.00 - 460.00 8.00 Professional Services 69,237.00 4,080.71 2,758.50 9,440.64 - 59,796.36 13.64 Fund Charges/Transfers 574,817.00 143,454.24 418,730.29 430,362.76 - 144,454.24 74.87 Maintenance Services 83,000.00 800.00 10,127.83 7,109.01 2,060.76 73,830.23 11.05 Other Costs 100.00 - - 100.00 - - 100.00 Debt Service - - 1,050.00 - - - - Rental/Leasing 500.00 - - - - 500.00 - Operating Equipment 2,500.00 698.62 5,127.30 698.62 1,759.96 41.42 98.34 Capital Outlay 14,000.00 13,903.04 208,575.28 13,903.04 - 96.96 99.31 TOTAL DRAINAGE 1,272,024.00 278,828.50 971,037.14 749,208.67 5,760.12 517,055.21 59.35% PROJECTS Professional Services - - 9,226.29 - - - - Maintenance Services - - 268,936.51 26,517.40 7,980.95 (34,498.35) - TOTAL EXPENDITURES 1,272,024.00 278,828.50 1,249,199.94 775,726.07 13,741.07 482,556.86 62.06% ** REVENUE OVER(UNDER) EXPEND 12,205.00 39,583.08 (358,546.40) 173,758.97 (13,741.07) (147,812.90) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 204-DRAINAGE CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Permits 000-432400 Floodplain Permit 4,000.00 2,600.00 4,320.00 6,850.00 - (2,850.00) 171.25 TOTAL Permits 4,000.00 2,600.00 4,320.00 6,850.00 - (2,850.00) 171.25% Fees 000-457500 Drainage Penalties 10,000.00 2,564.01 - 7,268.67 - 2,731.33 72.69 000-457600 Drainage Fee 1,250,000.00 312,342.48 885,610.99 934,166.75 - 315,833.25 74.73 000-458110 Sale of Merchandise - GovDeals - - - - - - - TOTAL Fees 1,260,000.00 314,906.49 885,610.99 941,435.42 - 318,564.58 74.72% 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 121.61 59.97 169.06 - 830.94 16.91 000-491200 Investment Income 2,000.00 783.48 662.58 1,030.56 - 969.44 51.53 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 - - - - - - - 000-497100 MISC INCOME-SCRAP METAL SALES - - - - - - - 000-498300 Reimburmnt-City Property - - - - - - - TOTAL Miscellaneous 3,000.00 905.09 722.55 1,199.62 - 1,800.38 39.99% TOTAL REVENUES 1,284,229.00 318,411.58 890,653.54 949,485.04 - 334,743.96 73.93% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 188,613.76$ Cash in Investments Lone Star Investment-Drainage Maint Fund 382,252.91 Total Cash in Bank & Investments 570,866.67$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 314-HOTEL TAX CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Taxes 520,000.00 215,313.60 253,641.67 586,034.51 - (66,034.51) 112.70 Fund Transfers 1,150,000.00 - - - - 1,150,000.00 - Miscellaneous 5,250.00 4,452.17 1,800.18 5,783.49 - (533.49) 110.16 TOTAL REVENUES 1,675,250.00 219,765.77 255,441.85 591,818.00 - 1,083,432.00 35.33% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 0.00 - - - - - - City Support Services 112,466.00 22,566.92 49,037.77 58,975.73 - 53,490.27 52.44 Operations Support 31,000.00 7,817.00 14,096.28 17,675.10 1,700.00 11,624.90 62.50 Professional Services 3,500.00 3,291.79 3,570.00 3,711.79 120.00 (331.79) 109.48 Fund Charges/Transfers 74,443.00 18,610.74 54,348.07 55,832.26 - 18,610.74 75.00 Maintenance Services 50,000.00 8,967.50 144,213.25 54,676.81 - (4,676.81) 109.35 Operating Equipment 44,888.00 41,314.82 - 42,387.50 - 2,500.50 94.43 Capital Outlay 20000.00 28,200.00 - 28,200.00 - (8,200.00) 141.00 TOTAL NONDEPARTMENTAL 336,297.00 130,768.77 265,265.37 261,459.19 1,820.00 73,017.81 78.29% TOTAL GENERAL GOVERNMENT 336,297.00 130,768.77 265,265.37 261,459.19 1,820.00 73,017.81 78.29% MISC & PROJECTS PROJECTS Professional Services 93,500.00 7,612.18 - 52,183.29 394.89 40,921.82 56.23 Maintenance Services 1,150,000.00 937,688.93 - 937,688.93 73,606.08 138,704.99 87.94 TOTAL PROJECTS 1,243,500.00 945,301.11 - 989,872.22 74,000.97 179,626.81 85.55% TOTAL MISC & PROJECTS 1,243,500.00 945,301.11 - 989,872.22 74,000.97 179,626.81 85.55% TOTAL EXPENDITURES 1,579,797.00 1,076,069.88 265,265.37 1,251,331.41 75,820.97 252,644.62 84.01% REVENUE OVER(UNDER) EXPENDITURE 95,453.00 (856,304.11) (9,823.52) (659,513.41) (75,820.97) 830,787.38 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 3,312.02$ Cash in Investments Texas Class - Hotel Tax 1,620,604.67 Total Cash in Bank & Investments 1,623,916.69$ HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 AS OF: March 31, 2021 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2021-22 65,789 63,938 62,952 58,027 54,614 74,755 70,056 70,014 75,996 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 582.49 254.75 743.02 - 281.98 72.49 TOTAL REVENUES 319,025.00 582.49 254.75 743.02 - 318,281.98 0.23% EXPENDITURE SUMMARY NON DEPARTMENTAL PARKLAND DEDICATION Professional Services 25,000.00 - - - 10,040.00 14,960.00 40.16 Capital Outlay 100,000.00 - - 17,650.02 - 82,349.98 17.65 TOTAL PARKLAND DEDICATION 125,000.00 - - 17,650.02 10,040.00 97,309.98 22.15% TOTAL EXPENDITURES 125,000.00 - - 17,650.02 10,040.00 97,309.98 22.15% REVENUE OVER(UNDER) EXPEND 194,025.00 582.49 254.75 (16,907.00) (10,040.00) 220,972.00 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 317-PARK CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-458800 Parkland Dedication 318,000.00 - - - - 318,000.00 - TOTAL Fees 318,000.00 - - - - 318,000.00 0.00% Fund Transfers 000-48100 Transfer In- Reserves - - - - - - - TOTAL Fund Transfers - - - - - - 0.00% Miscellaneous 000-491000 Interest Earned 25.00 0.68 8.75 1.21 - 23.79 4.84 000-491200 Investment Income 1,000.00 581.81 246.00 741.81 - 258.19 74.18 000-493700 Donations - - - - - - - TOTAL Miscellaneous 1,025.00 582.49 254.75 743.02 - 281.98 72.49% TOTAL REVENUES 319,025.00 582.49 254.75 743.02 - 318,281.98 0.23% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 Cash in Bank Current Claim on Operating Cash Pool-Checking (16,789.90) Cash in Investments Texas Class- Park Fund 286,900.26 Total in Investment Pool 286,900.26 Total Cash in Bank & Investments 270,110.36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 319-TREE MITIGATION CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 70,000.00 (1,500.00) 219,512.50 63,950.00 - 6,050.00 91.36 Miscellaneous 1,400.00 1,336.90 561.23 1,723.79 - (323.79) 123.13 TOTAL REVENUES 71,400.00 (163.10) 220,073.73 65,673.79 - 5,726.21 91.98% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services 70,000.00 22,680.00 16,695.00 61,460.00 6,378.00 2,162.00 96.91 TOTAL TREE MITIGATION 70,000.00 22,680.00 16,695.00 61,460.00 6,378.00 2,162.00 96.91% TOTAL EXPENDITURES 70,000.00 22,680.00 16,695.00 61,460.00 6,378.00 2,162.00 96.91% REVENUE OVER(UNDER) EXPEND 1,400.00 (22,843.10) 203,378.73 4,213.79 (6,378.00) 3,564.21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 319-TREE MITIGATION CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-458900 Tree Mitigation 70,000.00 (1,500.00) 219,512.50 63,950.00 - 6,050.00 91.36 TOTAL Fees 70,000.00 (1,500.00) 219,512.50 63,950.00 - 6,050.00 91.36% Fund Transfers Miscellaneous 000-491000 Interest Earned 200.00 8.88 18.92 34.63 - 165.37 17.32 000-491200 Investment Income 1,200.00 1,328.02 542.31 1,689.16 - (489.16) 140.76 000-497000 Misc Income - - - - - - TOTAL Miscellaneous 1,400.00 1,336.90 561.23 1,723.79 - (323.79) 123.13% TOTAL REVENUES 71,400.00 (163.10) 220,073.73 65,673.79 - 5,726.21 91.98% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking $4,567.21 Cash in Investments MBIA Investment-Tree Mitigation 647,541.79 Total Cash in Bank & Investments $652,109.00 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 411-CAPITAL RECOVERY WATER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 1,100,000.00 238,980.76 915,408.00 686,748.76 - 413,251.24 62.43 Miscellaneous 16,000.00 18,030.85 8,547.82 23,659.93 - (7,659.93) 147.87 TOTAL REVENUES 1,116,000.00 257,011.61 923,955.82 710,408.69 - 405,591.31 63.66% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 51,000.00 14,155.63 46,921.79 17,033.00 56,639.36 (22,672.36) 144.46 TOTAL NON DEPARTMENTAL 51,000.00 14,155.63 46,921.79 17,033.00 56,639.36 (22,672.36) 144.46% MISC & PROJECTS PROJECTS Fund Charges/Transfers - - 512,000.00 - - - - TOTAL MISC & PROJECTS - - 512,000.00 - - - 0.00% TOTAL EXPENDITURES 51,000.00 14,155.63 558,921.79 17,033.00 56,639.36 (22,672.36) 144.46% REVENUE OVER(UNDER) EXPENDITURES 1,065,000.00 242,855.98 365,034.03 693,375.69 (56,639.36) 428,263.67 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 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 238,980.76 915,408.00 686,748.76 - 413,251.24 62.43 TOTAL Fees 1,100,000.00 238,980.76 915,408.00 686,748.76 - 413,251.24 62.43% Fund Transfers Miscellaneous - 000-491000 Interest Earned 1,000.00 180.40 213.77 247.61 - 752.39 24.76 000-491200 Investment Income 15,000.00 17,850.45 8,334.05 23,412.32 - (8,412.32) 156.08 TOTAL Miscellaneous 16,000.00 18,030.85 8,547.82 23,659.93 - (7,659.93) 147.87% TOTAL REVENUES 1,116,000.00 257,011.61 923,955.82 710,408.69 - 405,591.31 63.66% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 152,698.37$ Cash in Investments Lone Star Investment-Capital Recovery Water 8,797,542.12 Total Cash in Bank & Investments 8,950,240.49$ CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: June 30, 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 95,476.76 505,106.72 289,598.60 - 310,401.40 48.27 Miscellaneous 60,250.00 17,639.56 7,577.98 22,626.09 - 37,623.91 37.55 TOTAL REVENUES 660,250.00 113,116.32 512,684.70 312,224.69 - 348,025.31 47.29% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 55,500.00 15,082.32 59,355.03 20,242.07 76,559.25 (41,301.32) 174.42 Fund Charges/Transfers - - - - - - - TOTAL NON DEPARTMENTAL 55,500.00 15,082.32 59,355.03 20,242.07 76,559.25 (41,301.32) 174.42% MISC & PROJECTS TOTAL EXPENDITURES 55,500.00 15,082.32 59,355.03 20,242.07 76,559.25 (41,301.32) 174.42% REVENUE OVER(UNDER) EXPENDITURES 604,750.00 98,034.00 453,329.67 291,982.62 (76,559.25) 389,326.63 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 421-CAPITAL RECOVERY SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 Cap Rcvry-Waste Water 600,000.00 95,476.76 505,106.72 289,598.60 - 310,401.40 48.27 TOTAL Fees 600,000.00 95,476.76 505,106.72 289,598.60 - 310,401.40 48.27% Fund Transfers Miscellaneous 000-491000 Interest Earned 250.00 246.39 156.46 254.93 - (4.93) 101.97 000-491200 Investment Income 60,000.00 20,694.51 32,356.31 32,682.44 - 27,317.56 54.47 000-491900 Unrealize Gain/Loss-Captl One 0.00 (3,301.34) (24,934.79) (10,311.28) - 10,311.28 - TOTAL Miscellaneous 60,250.00 17,639.56 7,577.98 22,626.09 - 37,623.91 37.55% TOTAL REVENUES 660,250.00 113,116.32 512,684.70 312,224.69 - 348,025.31 47.29% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 1,852,624.48$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 4,513,251.95 Capital One-Investment 1,832,976.41 Total Cash in Bank & Investments 8,198,852.84$ CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 431-ROADWAY IMPACT FEE AREA 1 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 200,000.00 98,121.25 165,123.08 172,049.47 - 27,950.53 86.02 Miscellaneous 900.00 1,344.80 478.10 1,738.00 - (838.00) 193.11 TOTAL REVENUES 200,900.00 99,466.05 165,601.18 173,787.47 - 27,112.53 86.50% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 588.29 - 1,358.50 - 3,641.50 27.17 Fund Charges/Transfers - - - - - - - TOTAL NON DEPARTMENTAL 5,000.00 588.29 - 1,358.50 - 3,641.50 27.17% TOTAL EXPENDITURES 93,173.00 588.29 - 1,358.50 - 91,814.50 1.46% REVENUE OVER(UNDER) EXPENDITURES 107,727.00 98,877.76 165,601.18 172,428.97 - (64,701.97) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 431-ROADWAY IMPACT FEE AREA 1 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 CapitalRcvry-RoadwaysSrvAre 200,000.00 98,121.25 165,123.08 172,049.47 - 27,950.53 86.02 TOTAL Fees 200,000.00 98,121.25 165,123.08 172,049.47 - 27,950.53 86.02% Fund Transfers Miscellaneous 000-491000 Interest Earned 300.00 19.65 194.33 26.05 - 273.95 8.68 000-491200 Investment Income 600.00 1,325.15 283.77 1,711.95 - (1,111.95) 285.33 TOTAL Miscellaneous 900.00 1,344.80 478.10 1,738.00 - (838.00) 193.11% TOTAL REVENUES 200,900.00 99,466.05 165,601.18 173,787.47 - 27,112.53 86.50% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 4,142.44$ Cash in Investments Lone Star Investment-Cap Rec Streets 1 716,708.75 Total Cash in Bank & Investments 720,851.19$ CAPITAL RECOVERY ROADWAY AREA 1 CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 432-ROADWAY IMPACT FEE AREA 2 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 120,000.00 189,555.17 99,806.55 288,268.02 - (168,268.02) 240.22 Miscellaneous 400.00 898.65 202.68 1,095.98 - (695.98) 274.00 TOTAL REVENUES 120,400.00 190,453.82 100,009.23 289,364.00 - (168,964.00) 240.34% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL City Assistance 24,000.00 - 39,148.36 49,146.87 - (25,146.87) 204.78 Professional Services 5,000.00 588.32 - 3,337.50 - 1,662.50 66.75 Fund Charges/Transfers - - - - - - - TOTAL NON DEPARTMENTAL 29,000.00 588.32 39,148.36 52,484.37 - (23,484.37) 180.98% TOTAL EXPENDITURES 29,000.00 588.32 39,148.36 52,484.37 - (23,484.37) 180.98% REVENUE OVER(UNDER) EXPENDITURES 91,400.00 189,865.50 60,860.87 236,879.63 - (145,479.63) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 432-ROADWAY IMPACT FEE AREA 2 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 CapitalRcvry-RoadwaysSrvAre 120,000.00 189,555.17 99,806.55 288,268.02 - (168,268.02) 240.22 TOTAL Fees 120,000.00 189,555.17 99,806.55 288,268.02 - (168,268.02) 240.22% Fund Transfers Miscellaneous 000-491000 Interest Earned 200.00 24.75 88.63 30.09 - 169.91 15.05 000-491200 Investment Income 200.00 873.90 114.05 1,065.89 - (865.89) 532.95 TOTAL Miscellaneous 400.00 898.65 202.68 1,095.98 - (695.98) 274.00% TOTAL REVENUES 120,400.00 190,453.82 100,009.23 289,364.00 - (168,964.00) 240.34% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 840.09$ Cash in Investments Lone Star Investment-Cap Rec Streets 2 506,814.99 Total Cash in Bank & Investments 507,655.08$ 432 ROADWAY INPACT FEE AREA 2 CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 433-ROADWAY IMPACT FEE AREA 3 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 400,000.00 22,242.00 468,314.20 174,103.00 - 225,897.00 43.53 Miscellaneous 1,500.00 2,329.89 775.35 3,031.72 - (1,531.72) 202.11 TOTAL REVENUES 401,500.00 24,571.89 469,089.55 177,134.72 - 224,365.28 44.12% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 588.32 - 3,337.50 - 1,662.50 66.75 Fund Charges/Transfers - - - - - - - TOTAL NON DEPARTMENTAL 5,000.00 588.32 - 3,337.50 - 1,662.50 66.75% TOTAL EXPENDITURES 5,000.00 588.32 - 3,337.50 - 1,662.50 66.75% REVENUE OVER(UNDER) EXPENDITURES 396,500.00 23,983.57 469,089.55 173,797.22 - 222,702.78 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 433-ROADWAY IMPACT FEE AREA 3 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 CapitalRcvry-RoadwaysSrvAre 400,000.00 22,242.00 468,314.20 174,103.00 - 225,897.00 43.53 TOTAL Fees 400,000.00 22,242.00 468,314.20 174,103.00 - 225,897.00 43.53% Fund Transfers Miscellaneous 000-491000 Interest Earned 900.00 6.08 440.96 14.21 - 885.79 1.58 000-491200 Investment Income 600.00 2,323.81 334.39 3,017.51 - (2,417.51) 502.92 TOTAL Miscellaneous 1,500.00 2,329.89 775.35 3,031.72 - (1,531.72) 202.11% TOTAL REVENUES 401,500.00 24,571.89 469,089.55 177,134.72 - 224,365.28 44.12% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 4,125.28$ Cash in Investments Lone Star Investment-Cap Rec Streets 3 1,142,202.25 Total Cash in Bank & Investments 1,146,327.53$ 433 ROADWAY IMPACT FEE AREA 3 CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 434-ROADWAY IMPACT FEE AREA 4 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 5,000.00 - 3,033.00 - - 5,000.00 - Miscellaneous 65.00 18.11 7.01 23.18 - 41.82 35.66 TOTAL REVENUES 5,065.00 18.11 3,040.01 23.18 - 5,041.82 0.46% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 588.32 - 3,337.50 - 1,662.50 66.75 Fund Charges/Transfers - - - - - - - TOTAL NON DEPARTMENTAL 5,000.00 588.32 - 3,337.50 - 1,662.50 66.75% TOTAL EXPENDITURES 5,000.00 588.32 - 3,337.50 - 1,662.50 66.75% REVENUE OVER(UNDER) EXPENDITURES 65.00 (570.21) 3,040.01 (3,314.32) - 3,379.32 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 434-ROADWAY IMPACT FEE AREA 4 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 CapitalRcvry-RoadwaysSrvAre 5,000.00 - 3,033.00 - - 5,000.00 - TOTAL Fees 5,000.00 - 3,033.00 - - 5,000.00 0.00% Fund Transfers Miscellaneous 000-491000 Interest Earned 15.00 1.14 3.10 1.30 - 13.70 8.67 000-491200 Investment Income 50.00 16.97 3.91 21.88 - 28.12 43.76 TOTAL Miscellaneous 65.00 18.11 7.01 23.18 - 41.82 35.66% TOTAL REVENUES 5,065.00 18.11 3,040.01 23.18 - 5,041.82 0.46% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 575.59$ Cash in Investments Lone Star Investment-Cap Rec Streets 4 5,421.55 Total Cash in Bank & Investments 5,997.14$ 434 ROADWAY IMPACT FEE AREA 4 CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022 505-TAX I&S CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Taxes 7,329,862.00 164,258.65 6,975,406.91 7,122,874.61 - 206,987.39 97.18 Fund Transfers - - 7,914.84 2,737.08 - (2,737.08) - Miscellaneous 105,000.00 30,336.38 76,405.33 79,249.84 - 25,750.16 75.48 TOTAL REVENUES 7,434,862.00 194,595.03 7,059,727.08 7,204,861.53 - 230,000.47 96.91% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 50,000.00 - 176,599.52 46,693.39 - 3,306.61 93.39 Debt Service 6,626,915.00 - 5,624,516.30 5,479,746.14 - 1,147,168.86 82.69 TOTAL GENERAL GOVERNMENT 6,676,915.00 - 5,801,115.82 5,526,439.53 - 1,150,475.47 82.77% TOTAL EXPENDITURES 6,676,915.00 - 5,801,115.82 5,526,439.53 - 1,150,475.47 82.77% ** REVENUE OVER(UNDER) EXPEND 757,947.00 194,595.03 1,258,611.26 1,678,422.00 - (920,475.00) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30 , 2022 505-TAX I & S CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Taxes 000-411900 Property Tax Revenue 7,329,862.00 164,258.65 6,975,406.91 7,122,874.61 - 206,987.39 97.18 TOTAL Taxes 7,329,862.00 164,258.65 6,975,406.91 7,122,874.61 - 206,987.39 97.18% Fund Transfers 000-486100 Transfer In - - 6,584.65 - - - - 000-486401 Transfer In -Bond Project Fund - - 1,330.19 2,737.08 - (2,737.08) - TOTAL Fund Transfers 0.00 - 7,914.84 2,737.08 - (2,737.08) 0.00% Miscellaneous 000-491000 Interest Earned 1,000.00 88.89 266.43 290.58 - 709.42 29.06 000-491200 Investment Income 4,000.00 5,247.49 1,138.90 23,341.51 - (19,341.51) 583.54 000-495020 Contribution From YMCA 100,000.00 25,000.00 75,000.00 50,000.00 - 50,000.00 50.00 000-498000 Proceeds From Refunding Debt - - - 5,617.75 - (5,617.75) - TOTAL Miscellaneous 105,000.00 30,336.38 76,405.33 79,249.84 - 25,750.16 75.48% TOTAL REVENUES 7,434,862.00 194,595.03 7,059,727.08 7,204,861.53 - 230,000.47 96.91% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30 , 2022 505-TAX I & S GENERAL GOVERNMENT CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET NON DEPARTMENTAL Professional Services 101-541500 Paying Agent 5,000.00 - 1,800.00 2,000.00 - 3,000.00 40.00 101-541502 Cost of Bond Issuance 45,000.00 - 174,799.52 44,693.39 - 306.61 99.32 TOTAL Professional Services 50,000.00 - 176,599.52 46,693.39 - 3,306.61 93.39% Debt Service 101-555629 Bond-GO 2007 Principal 340000.00 - 325,000.00 340,000.00 - - 100.00 101-555629.1 Bond-GO 2007 Interest 85267.00 - 52,706.50 46,092.75 - 39,174.25 54.06 101-555635 Bond-GO 2012 - Principal 375,000.00 - 365,000.00 375,000.00 - - 100.00 101-555635.1 Bond-GO 2012 - Interest 128,677.00 - 71,922.50 4,218.75 - 124,458.25 3.28 101-555638 Bond-GO 2014 Refund-Principal 750,000.00 - 100,000.00 750,000.00 - - 100.00 101-555638.1 Bond-GO 2014 Refund-Interest 268,025.00 - 141,137.50 139,637.50 - 128,387.50 52.10 101-555640.1 Bond-GO Ref 2015-Interest 37,050.00 - 28,875.00 18,525.00 - 18,525.00 50.00 101-555641 Tax Note - SR2015A-Principal 155,000.00 - - - - 155,000.00 - 101-555641.1 Tax Note - SR2015A - Interest 2,387.00 - 2,348.50 1,193.50 - 1,193.50 50.00 101-555642 Bond-GO SR2016-Principal 245,000.00 - 235,000.00 245,000.00 - - 100.00 101-555642.1 Bond-GO SR2016-Interest 131,607.00 - 72,953.13 68,253.13 - 63,353.87 51.86 101-555643 Bond-TaxableB CO SR2016-Princi 60,000.00 - 60,000.00 60,000.00 - - 100.00 101-555643.1 Bond-Taxable CO SR2016-Interes 40,263.00 - 21,481.25 20,581.25 - 19,681.75 51.12 101-555644 Bond-NonTaxA CO SR2016-Princip 195,000.00 - 190,000.00 195,000.00 - - 100.00 101-555644.1 Bond-NonTax CO SR2016-Interest 40,469.00 - 25,984.38 22,184.38 - 18,284.62 54.82 101-555645 Bond-CO SR2017-Principal 420,000.00 - 295,000.00 305,000.00 - 115,000.00 72.62 101-555645.1 Bond-CO SR2017 - Interest 114,425.00 - 63,062.50 58,637.50 - 55,787.50 51.25 101-555646 Bond-GO SR2017 - Principal 165,000.00 - 160,000.00 165,000.00 - - 100.00 101-555646.1 Bond-GO SR2017 - Interest 100,050.00 - 53,662.50 51,262.50 - 48,787.50 51.24 101-555647 Bond-GO 2018 Refund- Principal 585,000.00 - 570,000.00 585,000.00 - - 100.00 101-555647.1 Bond-GO 2018 Refund - Interest 86,125.00 - 52,205.00 46,163.00 - 39,962.00 53.60 101-555648 Bond-CO SR2018 - Principal 245,000.00 - 235,000.00 245,000.00 - - 100.00 101-555648.1 Bond-CO 2018 - Interest 163,888.00 - 90,881.25 85,006.25 - 78,881.75 51.87 101-555649 Bond-GO 2018 Ref - Principal 185,000.00 - 530,000.00 185,000.00 - - 100.00 101-555649.1 Bond-GO 2018 Ref - Interest 181,819.00 - 106,471.88 93,221.88 - 88,597.12 51.27 101-555650 Bond-CO 2019-Principal 265,000.00 - 255,000.00 265,000.00 - - 100.00 101-555650.1 Bond-CO 2019-Interest 114,900.00 - 63,262.50 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 - 5,624,516.30 5,479,746.14 - 1,147,168.86 82.69% Other Financing Sources TOTAL EXPENDITURES 6,676,915.00 - 5,801,115.82 5,526,439.53 - 1,150,475.47 82.77% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30 , 2022 Cash in Bank Claim on Operating Cash Pool-Checking 68,771.38$ MBIA Investment- Tax I&S 2,697,027.29 Total Cash in Bank & Investments 2,765,798.67$ TAX I&S CASH IN BANK AND INVESTMENTS AS OF: June 30 , 2022 620-SED CORPORATION CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Taxes 5,408,000.00 1,345,497.70 4,096,738.01 4,277,859.89 - 1,130,140.11 79.10 Fund Transfers 1,240,000.00 - - - - 1,240,000.00 - Miscellaneous 141,000.00 43,193.84 50,681.91 56,962.89 - 84,037.11 40.40 TOTAL REVENUES 6,789,000.00 1,388,691.54 4,147,419.92 4,334,822.78 - 2,454,177.22 63.85% EXPENDITURE SUMMARY NONDEPARTMENTAL City Assistance 3,139,038.00 - 224,384.89 - - 3,139,038.00 - Fund Charges/Transfers 1,240,000.00 - 390,000.00 - - 1,240,000.00 - TOTAL NONDEPARTMENTAL 4,379,038.00 - 614,384.89 - - 4,379,038.00 0.00% MISC & PROJECTS PROJECTS ECONOMIC DEVELOPMENT Supplies 1,000.00 136.96 299.25 931.13 50.46 18.41 98.16 City Support Services 11,200.00 2,425.57 2,305.07 3,969.77 20.66 7,209.57 35.63 Utility Services 2,975.00 208.54 878.68 1,964.48 19.93 990.59 66.70 Operations Support 346,985.00 34,114.54 37,557.88 138,376.87 5,271.10 203,337.03 41.40 Staff Support 24,225.00 4,754.72 3,023.51 11,674.53 2,573.97 9,976.50 58.82 City Assistance 202,500.00 - - - - 202,500.00 - Professional Services 61,300.00 2,404.00 18,568.50 15,833.97 - 45,466.03 25.83 Fund Charges/Transfers 506,984.00 253,492.00 504,669.00 506,984.00 - - 100.00 Operating Equipment 4,500.00 278.94 2,175.25 3,959.76 - 540.24 87.99 TOTAL ECONO DEVELOPMENT 1,161,669.00 297,815.27 569,477.14 683,694.51 7,936.12 470,038.37 59.54% FM3009 ROAD&BRIDGE EXPANSION TOTAL EXPENDITURES 5,540,707.00 297,815.27 1,183,862.03 683,694.51 7,936.12 4,849,076.37 12.48% ** REVENUE OVER(UNDER) EXPEND 1,248,293.00 1,090,876.27 2,963,557.89 3,651,128.27 (7,936.12) (2,394,899.15) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 354,617.61$ Cash in Investments Texas Class Investment-Economic Development Corp 21,907,707.53 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 24,471,014.09$ SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: June 30, 2022