Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Q2-FINAL
CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2020 - 2021 ********************************* CURRENT CURRENT Y-T-D BUDGET 50% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET General Fund, 101 Total Revenues 37,474,811.00 24,316,876.95 0.00 13,157,934.05 64.89% Total General Government 7,037,119.00 3,305,413.60 539,767.96 3,191,937.44 54.64% Total Public Safety 17,430,954.37 8,821,494.47 323,512.51 8,285,947.39 52.46% Total Public Environment 1,649,740.00 666,114.24 56,135.37 927,490.39 43.78% Total Parks & Recreation 2,682,141.00 990,747.19 166,711.46 1,524,682.35 43.15% Total Cultural 1,064,255.00 531,070.35 7,183.47 526,001.18 50.58% Total Internal Services 7,228,255.61 3,076,225.91 610,916.89 3,541,112.81 51.01% Total Misc & Projects 934,292.00 702,698.42 84,669.50 146,924.08 84.27% Total Expenditures 38,026,756.98 18,093,604.18 1,788,897.16 18,144,255.64 52.29% Revenue Over(Under) Expenditures (551,945.98)6,223,272.77 (1,788,897.16)(4,986,321.59) General Fund, 101 Total Cash in Bank & Investments 21,438,832.91 Special Events Fund, 106 Total Revenues 32,100.00 34,684.19 0.00 (2,584.19)108.05% Total Expenditures 32,100.00 12,152.60 0.00 19,947.40 37.86% Revenue Over(Under) Expenditures 0.00 22,531.59 0.00 (22,531.59) Special Events Fund, 106 Total Cash in Bank & Investments 133,972.55 Peg Fund, 110 Total Revenues 185,500.00 43,256.76 0.00 142,243.24 23.32% Total Expenditures 185,500.00 0.00 0.00 185,500.00 0.00% Revenue Over(Under) Expenditures 0.00 43,256.76 0.00 (43,256.76) Peg Fund, 110 Total Cash in Bank & Investments 910,964.79 Water & Sewer, 202 Total Revenues 25,504,368.00 12,509,678.46 0.00 12,994,689.54 49.05% Total Expenditures 24,826,603.00 13,948,965.35 302,517.64 10,575,120.01 57.40% Revenue Over(Under) Expenditures 677,765.00 (1,439,286.89)(302,517.64)2,419,569.53 Water & Sewer, 202 Total Cash in Bank & Investments 6,474,928.58 Quarterly Statement Schertz, Texas AS OF :MARCH 31, 2021 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2020 - 2021 ********************************* CURRENT CURRENT Y-T-D BUDGET 50% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET EMS, 203 Total Revenues 9,785,424.51 5,008,282.59 0.00 4,777,141.92 51.18% Total Expenditures 10,001,991.01 4,935,455.75 476,583.47 4,589,951.79 54.11% Revenue Over(Under) Expenditures (216,566.50)72,826.84 (476,583.47)187,190.13 EMS, 203 Total Cash in Bank & Investments 1,184,983.70 Drainage, 204 Total Revenues 1,462,793.00 580,219.47 0.00 882,573.53 39.67% Total Expenditures 1,497,913.00 908,028.52 135,753.78 454,130.70 69.68% Revenue Over(Under) Expenditures (35,120.00)(327,809.05)(135,753.78)428,442.83 Drainage, 204 Total Cash in Bank & Investments 500,526.49 Hotel Tax, 314 Total Revenues 540,750.00 137,587.58 0.00 403,162.42 25.44% Total Expenditures 253,930.00 197,041.76 30,396.85 26,491.39 89.57% Revenue Over(Under) Expenditures 286,820.00 (59,454.18)(30,396.85)376,671.03 Hotel Tax, 314 Total Cash in Bank & Investments 2,025,484.31 Park, 317 Total Revenues 125,000.00 198.91 0.00 124,801.09 0.16% Total Expenditures 125,000.00 0.00 810.70 124,189.30 0.65% Revenue Over(Under) Expenditures 0.00 198.91 (810.70)611.79 Park, 317 Total Cash in Bank & Investments 292,434.36 Tree Mitigation, 319 Total Revenues 74,500.00 219,393.02 0.00 (144,893.02)294.49% Total Expenditures 70,000.00 5,625.00 0.00 64,375.00 8.04% Revenue Over(Under) Expenditures 4,500.00 213,768.02 0.00 (209,268.02) Tree Mitigation, 319 Total Cash in Bank & Investments 676,995.64 Capital Recovery Water, 411 Total Revenues 1,172,000.00 744,118.17 0.00 427,881.83 63.49% Total Expenditures 206,000.00 35,414.11 92,802.17 77,783.72 62.24% Revenue Over(Under) Expenditures 966,000.00 708,704.06 (92,802.17)350,098.11 Capital Recovery Water, 411 Total Cash in Bank & Investments 8,434,468.92 Quarterly Statement Schertz, Texas AS OF :MARCH 31, 2021 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2020 - 2021 ********************************* CURRENT CURRENT Y-T-D BUDGET 50% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Capital Recovery Sewer, 421 Total Revenues 672,000.00 389,625.91 0.00 282,374.09 57.98% Total Expenditures 208,000.00 41,632.14 118,123.02 48,244.84 76.81% Revenue Over(Under) Expenditures 464,000.00 347,993.77 (118,123.02)234,129.25 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 7,693,827.83 I&S, 505 Total Revenues 7,095,821.00 6,866,724.90 0.00 229,096.10 96.77% Total Expenditures 7,094,861.00 5,824,662.41 0.00 1,270,198.59 82.10% Revenue Over(Under) Expenditures 960.00 1,042,062.49 0.00 (1,041,102.49) I&S, 505 Total Cash in Bank & Investments 1,827,980.88 SED Corporation, 620 Total Revenues 8,144,799.00 2,498,960.70 0.00 5,645,838.30 30.68% Total Expenditures 8,144,799.00 461,917.81 207.12 7,682,674.07 5.67% Revenue Over(Under) Expenditures 0.00 2,037,042.89 (207.12)(2,036,835.77) SED Corporation, 620 Total Cash in Bank & Investments 22,282,779.20 Total Cash in Bank & Investments 73,878,180.16 Quarterly Statement Schertz, Texas AS OF :MARCH 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 25,198,550.00 8,707,351.92 18,579,689.68 19,270,634.45 - 5,927,915.55 76.48 Franchises 2,334,000.00 512,129.97 1,047,795.85 1,060,358.57 - 1,273,641.43 45.43 Permits 1,767,250.00 543,680.17 861,551.27 953,680.59 - 813,569.41 53.96 Licenses 56,860.00 14,105.00 28,787.00 25,375.00 - 31,485.00 44.63 Fees 2,338,234.00 486,264.56 1,147,337.79 938,109.90 - 1,400,124.10 40.12 Fines 11,000.00 1,756.52 5,652.27 2,965.50 - 8,034.50 26.96 Inter-Jurisdictional 1,066,925.00 160,891.15 445,486.89 284,646.63 - 782,278.37 26.68 Fund Transfers 4,069,892.00 633,995.34 1,351,970.52 1,425,390.62 - 2,644,501.38 35.02 Miscellaneous 632,100.00 250,454.91 510,823.62 355,715.69 - 276,384.31 56.28 TOTAL REVENUES 37,474,811.00 11,310,629.54 23,979,094.89 24,316,876.95 - 13,157,934.05 64.89% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 37,633.00 8,598.12 20,082.23 18,795.19 14.40 18,823.41 49.98 Supplies 750.00 - 312.30 139.40 - 610.60 18.59 City Support Services 59,705.00 957.32 36,642.90 37,956.17 313.90 21,434.93 64.10 Operations Support 300.00 62.00 174.12 85.50 - 214.50 28.50 Staff Support 28,600.00 4,120.38 23,709.52 13,383.93 745.00 14,471.07 49.40 Professional Services 6,000.00 - - - - 6,000.00 0.00 Operating Equipment 2,000.00 - - - - 2,000.00 0.00 TOTAL CITY COUNCIL 134,988.00 13,737.82 80,921.07 70,360.19 1,073.30 63,554.51 52.92% CITY MANAGER Personnel Services 1,246,309.00 269,905.19 543,321.56 584,049.78 - 662,259.22 46.86 Supplies 2,000.00 436.01 611.08 551.82 31.00 1,417.18 29.14 City Support Services 4,800.00 - 3,767.25 - - 4,800.00 - Operations Support 50.00 - - - - 50.00 - Staff Support 24,775.00 818.89 7,947.91 2,963.89 354.75 21,456.36 13.40 Operating Equipment 1,200.00 - - 1,200.00 - - 100.00 TOTAL CITY MANAGER 1,279,134.00 271,160.09 555,647.80 588,765.49 385.75 689,982.76 46.06% MUNICIPAL COURT Personnel Services 283,625.00 65,693.01 133,792.24 146,693.15 - 136,931.85 51.72 Supplies 1,500.00 60.00 699.93 484.89 - 1,015.11 32.33 City Support Services 500.00 - 180.40 123.86 - 376.14 24.77 Operations Support 2,000.00 246.00 - 246.00 31.00 1,723.00 13.85 Staff Support 6,910.00 563.44 1,352.51 638.33 300.00 5,971.67 13.58 Court Support 1,080.00 - 186.00 - - 1,080.00 0.00 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 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: March 31, 2021 Professional Services 69,850.00 8,605.00 27,075.00 17,737.50 34,462.50 17,650.00 74.73 Maintenance Services 3,000.00 300.00 900.00 850.00 1,400.00 750.00 75.00 TOTAL MUNICIPAL COURT 368,465.00 75,467.45 164,186.08 166,773.73 36,193.50 165,497.77 55.08% CUSTOMER RELATIONS-311 Personnel Services 113,239.00 26,107.92 53,163.36 56,997.88 - 56,241.12 50.33 Supplies 100.00 20.86 74.72 33.33 - 66.67 33.33 Staff Support 530.00 96.90 717.43 163.84 - 366.16 30.91 TOTAL CUSTOMER RELATIONS-311 113,869.00 26,225.68 53,955.51 57,195.05 - 56,673.95 50.23% PLANNING & ZONING Personnel Services 264,117.00 53,051.67 79,081.49 107,617.50 - 156,499.50 40.75 Supplies 1,873.00 158.46 158.54 296.75 8.00 1,568.25 16.27 Operations Support 186.00 43.00 50.00 50.60 52.00 83.40 55.16 Staff Support 29,548.00 405.00 7,722.70 1,037.00 - 28,511.00 3.51 Professional Services 400,100.00 - 21.00 5.00 - 400,095.00 - Operating Equipment 6,401.00 - 317.95 6,075.83 - 325.17 94.92 TOTAL PLANNING & ZONING 702,225.00 53,658.13 87,351.68 115,082.68 60.00 587,082.32 16.40% LEGAL SERVICES Operations Support 10,000.00 550.75 777.30 2,807.66 379.50 6,812.84 31.87 Professional Services 140,000.00 23,494.26 36,582.41 40,475.31 - 99,524.69 28.91 TOTAL LEGAL SERVICES 150,000.00 24,045.01 37,359.71 43,282.97 379.50 106,337.53 29.11% CITY SECRETARY Personnel Services 192,155.00 39,999.98 93,961.22 92,546.93 - 99,608.07 48.16 Supplies 1,150.00 256.33 468.80 665.98 35.60 448.42 61.01 City Support Services 10,000.00 2,816.06 3,283.95 2,816.06 - 7,183.94 28.16 Operations Support 150.00 43.00 - 43.00 - 107.00 28.67 Staff Support 4,350.00 367.43 3,036.47 1,349.83 448.00 2,552.17 41.33 Operating Equipment 1,035.00 - - - - 1,035.00 - TOTAL CITY SECRETARY 208,840.00 43,482.80 100,750.44 97,421.80 483.60 110,934.60 46.88% NON-DEPARTMENTAL City Support Services 755,684.00 71,119.52 371,067.98 393,735.94 111,509.90 250,438.16 66.86 Operations Support 143,000.00 28,742.80 69,682.89 67,087.42 105.75 75,806.83 46.99 Staff Support 200.00 - - - - 200.00 - City Assistance 1,557,048.00 721,924.33 653,442.40 908,686.50 342,524.34 305,837.16 80.36 Professional Services 53,535.00 28,998.47 27,539.98 54,029.00 - (494.00) 100.92 Fund Chrgs/Transfrs-Spec Events Fnd 27,979.00 (1,516.65) - (1,516.65) - 29,495.65 5.42 Capital Outlay 0.00 7,450.00 - 7,450.00 - (7,450.00) - TOTAL NON-DEPARTMENTAL 2,537,446.00 856,718.47 1,121,733.25 1,429,472.21 454,139.99 653,833.80 74.23% PUBLIC AFFAIRS 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: March 31, 2021 Personnel Services 302,583.00 70,590.07 145,250.82 153,773.67 - 148,809.33 50.82 Supplies 1,700.00 95.00 383.98 515.61 437.63 746.76 56.07 Operations Support 46,603.00 3,514.72 9,069.03 4,263.85 8,019.05 34,320.10 26.36 Staff Support 11,140.00 238.93 2,782.33 274.57 448.49 10,416.94 6.49 Professional Services 267,000.00 98,695.74 122,026.01 143,391.50 916.00 122,692.50 54.05 TOTAL PUBLIC AFFAIRS 629,026.00 173,134.46 280,502.66 302,219.20 9,821.17 316,985.63 49.61% ENGINEERING Personnel Services 808,237.00 198,184.40 300,769.01 404,261.47 - 403,975.53 50.02 Supplies 2,350.00 19.65 515.50 119.95 4.15 2,225.90 5.28 City Support Services 500.00 - - - - 500.00 - Utility Services 4,350.00 1,190.34 2,600.48 2,225.74 - 2,124.26 51.17 Operations Support 100.00 93.00 - 93.00 - 7.00 93.00 Staff Support 18,704.00 1,342.51 1,953.62 1,900.33 - 16,803.67 10.16 Professional Services 75,000.00 - 12,280.00 - 37,227.00 37,773.00 49.64 Operating Equipment 3,885.00 456.18 54.98 26,239.79 - (22,354.79) 675.41 TOTAL ENGINEERING 913,126.00 201,286.08 318,173.59 434,840.28 37,231.15 441,054.57 51.70% TOTAL GENERAL GOVERNMENT 7,037,119.00 1,738,915.99 2,893,890.01 3,305,413.60 539,767.96 3,191,937.44 54.64% PUBLIC SAFETY POLICE Personnel Services 8,612,069.00 2,103,305.17 3,723,682.75 4,503,157.40 - 4,108,911.60 52.29 Supplies 110,876.44 25,436.45 31,483.70 31,147.14 3,428.80 76,300.50 31.18 City Support Services 26,000.00 401.55 25,400.62 32,421.79 - (6,421.79) 124.70 Utility Services 201,800.00 32,820.64 39,660.76 58,871.06 - 142,928.94 29.17 Operations Support 18,685.00 1,571.00 3,493.00 2,309.00 230.00 16,146.00 13.59 Staff Support 202,597.83 35,486.59 51,563.01 57,255.00 11,526.25 133,816.58 33.95 City Assistance 81,100.00 8,828.78 4,043.81 9,507.33 1,474.83 70,117.84 13.54 Professional Services 84,583.00 7,933.97 18,624.06 29,251.27 - 55,331.73 34.58 Maintenance Services 90,705.00 14,573.00 17,350.73 21,161.99 - 69,543.01 23.33 Operating Equipment 224,219.60 32,744.90 154,018.12 84,874.28 59,979.82 79,365.50 64.60 Capital Outlay 546,319.50 263,196.66 221,828.83 295,016.63 5,410.00 245,892.87 54.99 TOTAL POLICE 10,198,955.37 2,526,298.71 4,335,693.39 5,124,972.89 82,049.70 4,991,932.78 51.05% FIRE RESCUE Personnel Services 5,261,519.00 1,299,779.46 2,378,155.32 2,867,625.58 - 2,393,893.42 54.50 Supplies 23,965.00 2,879.88 5,622.79 3,396.07 377.45 20,191.48 15.75 Utility Services 76,600.00 18,911.44 37,724.21 33,017.96 - 43,582.04 43.10 Operations Support 2,150.00 - 334.93 157.73 - 1,992.27 7.34 Staff Support 197,100.00 5,957.67 110,673.87 15,846.09 89,039.96 92,213.95 53.21 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: March 31, 2021 City Assistance 23,000.00 3,725.66 7,926.01 4,603.75 - 18,396.25 20.02 Professional Services 85,502.00 7,251.00 29,511.00 21,353.43 42,743.38 21,405.19 74.97 Maintenance Services 90,562.00 15,976.38 10,194.35 33,283.02 1,704.00 55,574.98 38.63 Rental/Leasing 13,500.00 - 6,742.44 - - 13,500.00 - Operating Equipment 148,955.00 21,519.68 52,373.25 41,686.19 14,582.81 92,686.00 37.78 Capital Outlay 291,000.00 158,691.82 101,548.43 186,265.13 50,073.33 54,661.54 81.22 TOTAL FIRE RESCUE 6,213,853.00 1,534,692.99 2,740,806.60 3,212,313.36 199,531.33 2,802,008.31 54.91% INSPECTIONS Personnel Services 891,759.00 198,049.20 413,567.87 433,880.62 - 457,878.38 48.65 Supplies 5,076.00 444.83 635.03 645.93 - 4,430.07 12.73 Utility Services 8,400.00 1,087.73 2,037.23 2,125.44 - 6,274.56 25.30 Operations Support 1,000.00 62.00 - 62.00 52.00 886.00 11.40 Staff Support 41,261.00 1,600.21 10,153.29 2,075.73 916.98 38,268.29 7.25 Professional Services 70,000.00 2,637.50 7,575.00 18,037.50 40,962.50 11,000.00 84.29 Operating Equipment 650.00 - - - - 650.00 - TOTAL INSPECTIONS 1,018,146.00 203,881.47 433,968.42 484,208.22 41,931.48 492,006.30 51.68% TOTAL PUBLIC SAFETY 17,430,954.37 4,264,873.17 7,510,468.41 8,821,494.47 323,512.51 8,285,947.39 52.46% PUBLIC ENVIRONMENT STREETS Personnel Services 933,855.00 173,773.62 376,901.43 394,817.81 - 539,037.19 42.28 Supplies 117,950.00 19,172.22 63,913.54 47,437.41 22,952.12 47,560.47 59.68 Utility Services 176,000.00 43,953.32 73,093.68 75,673.69 1,351.83 98,974.48 43.76 Staff Support 21,120.00 6,128.15 10,585.02 8,287.34 216.42 12,616.24 40.26 Professional Services 18,000.00 11,540.00 - 12,070.00 - 5,930.00 67.06 Maintenance Services 334,992.00 12,887.50 68,790.50 69,668.00 22,940.00 242,384.00 27.64 Rental/Lease 6,000.00 1,366.79 1,900.00 1,366.79 1,275.00 3,358.21 44.03 Operating Equipment 9,800.00 24,110.56 - 25,170.20 7,400.00 (22,770.20) 332.35 Capital Outlay 32,023.00 31,623.00 - 31,623.00 - 400.00 98.75 TOTAL STREETS 1,649,740.00 324,555.16 596,332.63 666,114.24 56,135.37 927,490.39 43.78% TOTAL PUBLIC ENVIRONMENT 1,649,740.00 324,555.16 596,332.63 666,114.24 56,135.37 927,490.39 43.78% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 714,711.00 147,170.65 283,746.53 301,977.05 - 412,733.95 42.25 Supplies 99,350.00 33,613.65 25,207.11 59,417.99 21,102.98 18,829.03 81.05 City Support Services 111,316.00 22,135.19 38,329.54 72,670.18 10,530.27 28,115.55 74.74 Utility Services 246,000.00 64,646.23 97,239.74 99,972.10 - 146,027.90 40.64 Operations Support 2,000.00 - - 122.92 - 1,877.08 6.15 Staff Support 19,670.00 2,804.99 9,644.09 5,195.34 1,165.02 13,309.64 32.34 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: March 31, 2021 Professional Services 120,271.00 3,060.00 32,461.92 30,274.30 16,832.00 73,164.70 39.17 Maintenance Services 84,000.00 909.19 12,079.97 54,501.80 13,412.09 16,086.11 80.85 Rental/Leasing 10,000.00 830.27 7,202.86 2,879.19 830.00 6,290.81 37.09 Operating Equipment 65,000.00 1,858.74 29,083.50 4,445.00 8,750.00 51,805.00 20.30 Capital Outlay 246,898.00 33,826.00 19,624.13 39,189.82 90,168.13 117,540.05 52.39 TOTAL PARKS DEPARTMENT 1,719,216.00 310,854.91 554,619.39 670,645.69 162,790.49 885,779.82 48.48% SWIM POOL Supplies 25,500.00 5,536.26 4,045.00 5,558.62 - 19,941.38 21.80 Utility Services 16,500.00 5,019.26 7,189.62 7,407.28 - 9,092.72 44.89 Maintenance Services 527,878.00 102,542.32 137,564.54 184,132.30 1,973.08 341,772.62 35.26 TOTAL SWIM POOL 569,878.00 113,097.84 148,799.16 197,098.20 1,973.08 370,806.72 34.93% EVENT FACILITIES Personnel Services 277,964.00 45,162.23 134,590.91 96,311.03 75.20 181,577.77 34.68 Supplies 5,400.00 338.67 2,518.18 1,418.60 383.71 3,597.69 33.38 Utility Services 48,400.00 9,283.97 14,361.12 13,800.83 - 34,599.17 28.51 Operations Support 20,343.00 7,074.66 1,332.36 8,883.30 - 11,459.70 43.67 Staff Support 4,925.00 303.99 2,373.20 495.55 51.98 4,377.47 11.12 Maintenance Services 13,000.00 1,080.00 5,225.00 1,080.00 - 11,920.00 8.31 Operating Equipment 23,015.00 287.99 (4,355.31) 1,013.99 1,437.00 20,564.01 10.65 TOTAL EVENT FACILITIES 393,047.00 63,531.51 156,045.46 123,003.30 1,947.89 268,095.81 31.79% TOTAL PARKS & RECREATION 2,682,141.00 487,484.26 859,464.01 990,747.19 166,711.46 1,524,682.35 43.15% CULTURAL LIBRARY Personnel Services 834,575.00 192,996.92 400,554.21 422,192.83 - 412,382.17 50.59 Supplies 13,855.00 1,085.72 4,812.69 5,912.77 945.26 6,996.97 49.50 Utility Services 65,500.00 10,645.82 26,772.26 15,972.51 - 49,527.49 24.39 Operations Support 3,600.00 371.96 3,342.38 959.94 - 2,640.06 26.67 Staff Support 8,280.00 1,340.30 7,097.80 1,669.48 1,275.00 5,335.52 35.56 Professional Services 2,300.00 - 1,984.10 1,655.96 - 644.04 72.00 Operating Equipment 136,145.00 45,306.03 76,143.03 82,706.86 4,963.21 48,474.93 64.39 TOTAL LIBRARY 1,064,255.00 251,746.75 520,706.47 531,070.35 7,183.47 526,001.18 50.58% TOTAL CULTURAL 1,064,255.00 251,746.75 520,706.47 531,070.35 7,183.47 526,001.18 50.58% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 856,808.00 183,127.24 325,003.42 399,396.12 - 457,411.88 46.61 Supplies 6,800.00 599.97 1,980.73 1,762.83 773.23 4,263.94 37.30 City Support Services 974,666.00 164,883.29 187,551.63 326,740.12 124,621.96 523,303.92 46.31 Utility Services 285,125.00 81,795.30 84,116.79 134,154.92 4,067.07 146,903.01 48.48 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2021 Staff Support 43,628.00 1,498.68 21,760.14 1,615.69 424.00 41,588.31 4.68 Professional Services 102,599.00 43,879.63 62.50 43,879.63 3,875.50 54,843.87 46.55 Maintenance Services 10,000.00 2,185.35 1,388.77 9,367.96 - 632.04 93.68 Rental/Leasing 3,651.00 608.36 - 1,520.90 304.18 1,825.92 49.99 Operating Equipment 320,369.00 130,552.58 79,061.42 176,983.27 48,952.33 94,433.40 70.52 Capital Outlay 35,000.00 26,889.00 - 26,889.00 - 8,111.00 76.83 TOTAL INFORMATION TECHNOLOGY 2,638,646.00 636,019.40 700,925.40 1,122,310.44 183,018.27 1,333,317.29 49.47% HUMAN RESOURCES Personnel Services 456,957.00 102,638.02 203,641.73 217,666.98 - 239,290.02 47.63 Supplies 2,700.00 63.86 1,039.76 245.96 126.25 2,327.79 13.79 Human Services 234,562.00 30,258.33 64,129.30 82,885.76 38,088.15 113,588.09 51.57 Operations Support 5,836.00 - 1,604.84 2,433.84 225.00 3,177.16 45.56 Staff Support 36,150.00 8,784.58 10,866.74 22,087.88 880.28 13,181.84 63.54 City Assistance 10,000.00 3,028.00 4,726.00 5,013.00 - 4,987.00 50.13 Professional Services 15,000.00 - 57,513.50 - 6,980.00 8,020.00 46.53 Operating Equipment 514.00 - 249.99 513.31 - 0.69 99.87 TOTAL HUMAN RESOURCES 761,719.00 144,772.79 343,771.86 330,846.73 46,299.68 384,572.59 49.51% FINANCE Personnel Services 605,758.00 143,347.53 285,957.56 313,818.15 - 291,939.85 51.81 Supplies 3,700.00 917.79 1,587.17 1,718.88 - 1,981.12 46.46 Staff Support 9,422.00 755.00 4,365.58 1,619.00 530.00 7,273.00 22.81 Professional Sevices 34,500.00 13,832.30 22,341.07 14,742.12 610.00 19,147.88 44.50 Operating Equipment 586.61 - 1,610.96 336.08 - 250.53 57.29 TOTAL FINANCE 653,966.61 158,852.62 315,862.34 332,234.23 1,140.00 320,592.38 50.98% PURCHASING & ASSET MGT Personnel Services 225,784.00 53,013.54 109,420.22 116,374.95 - 109,409.05 51.54 Supplies 700.00 65.10 73.50 99.68 - 600.32 14.24 Operations Support 7,650.00 1,825.00 3,190.96 3,124.00 488.75 4,037.25 47.23 Staff Support 6,785.00 775.00 1,322.82 1,150.38 861.49 4,773.13 29.65 City Assistance 2,000.00 244.00 470.00 406.00 190.00 1,404.00 29.80 Operating Equipment 1,600.00 - - - 277.97 1,322.03 17.37 TOTAL PURCHASING & ASSET MGT 244,519.00 55,922.64 114,477.50 121,155.01 1,818.21 121,545.78 50.29% FLEET SERVICE Personnel Services 514,842.00 124,578.34 165,490.77 261,799.90 - 253,042.10 50.85 Supplies 213,766.00 54,641.95 80,800.83 92,479.06 12,189.12 109,097.82 48.96 City Support Services 15,000.00 15.00 2,297.20 2,372.20 124.50 12,503.30 16.64 Utility Services 11,385.00 3,291.65 3,333.50 4,926.49 - 6,458.51 43.27 Staff Support 29,700.00 5,592.87 7,085.40 9,910.83 1,507.60 18,281.57 38.45 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: March 31, 2021 Maintenance Services 218,002.00 48,624.22 83,925.11 111,154.99 24,860.72 81,986.29 62.39 Operating Equipment 13,853.00 3,717.32 2,558.72 8,455.26 - 5,397.74 61.04 Capital Outlay 57,049.00 6,349.99 - 6,349.99 21,303.00 29,396.01 48.47 TOTAL FLEET SERVICE 1,073,597.00 246,811.34 345,491.53 497,448.72 59,984.94 516,163.34 51.92% FACILITY SERVICES Personnel Services 735,826.00 202,111.29 352,889.35 415,586.93 - 320,239.07 56.48 Supplies 145,900.00 9,344.82 28,783.16 19,573.26 5,446.74 120,880.00 17.15 City Support Services 5,000.00 - - - - 5,000.00 - Utility Services 171,000.00 45,489.12 80,316.53 71,893.44 - 99,106.56 42.04 Staff Support 12,800.00 1,459.53 3,091.99 2,165.53 303.78 10,330.69 19.29 Professional Services 85,746.00 27,814.70 38,942.55 43,031.32 48,242.86 (5,528.18) 106.45 Maintenance Services 652,536.00 41,473.14 160,822.32 92,714.30 264,662.41 295,159.29 54.77 Rental/Leasing 500.00 - 80.38 - - 500.00 - Operating Equipment 16,500.00 - 5,907.75 - - 16,500.00 - Capital Outlay 30,000.00 27,266.00 - 27,266.00 - 2,734.00 90.89 TOTAL BUILDING MAINTENANCE 1,855,808.00 354,958.60 670,834.03 672,230.78 318,655.79 864,921.43 53.39% TOTAL INTERNAL SERVICE 7,228,255.61 1,597,337.39 2,491,362.66 3,076,225.91 610,916.89 3,541,112.81 51.01% MISC & PROJECTS Project Fund Charges/Transfers 581,300.00 581,300.00 - 581,300.00 - - 100.00 TOTAL PROJECTS 581,300.00 581,300.00 - 581,300.00 - - 100.00% CITY ASSISTANCE City's Assistance to Agencies 320,000.00 63,277.50 149,199.38 115,698.42 82,169.50 122,132.08 61.83 Operating Equipment 10,000.00 - 4,321.57 - - 10,000.00 - TOTAL CITY ASSISTANCE 330,000.00 63,277.50 153,520.95 115,698.42 82,169.50 132,132.08 59.96% COURT - RESTRICTED FUNDS Operating Equipment 22,992.00 5,700.00 - 5,700.00 2,500.00 14,792.00 35.66 TOTAL COURT-RESTRICTED FUNDS 22,992.00 5,700.00 - 5,700.00 2,500.00 14,792.00 35.66% TOTAL MISC & PROJECTS 934,292.00 650,277.50 153,520.95 702,698.42 84,669.50 146,924.08 84.27% TOTAL EXPENDITURES 38,026,756.98 9,315,190.22 15,089,802.10 18,093,604.18 1,788,897.16 18,144,255.64 52.29% REVENUE OVER(UNDER) EXPEND.(551,945.98) 1,995,439.32 8,889,292.79 6,223,272.77 (1,788,897.16) (4,986,321.59) 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 14,554,500.00 6,326,294.34 13,740,301.99 14,232,880.01 - 321,619.99 97.79 000-411110 Disable Veterans Assist Pymnt 500,000.00 - - - - 500,000.00 - 000-411200 Advalorem Tax-Delinquent 50,000.00 12,341.09 14,682.60 45,282.24 - 4,717.76 90.56 000-411300 Advalorem Tax-P&I 50,000.00 28,416.76 21,909.44 43,430.83 - 6,569.17 86.86 000-411500 Sales Tax Revenue-Gen Fund 9,964,000.00 2,317,109.69 4,760,518.81 4,916,282.98 - 5,047,717.02 49.34 000-411600 Bingo Tax 50.00 - 28.16 - - 50.00 - 000-411700 Mixed Beverage Tax 80,000.00 23,190.04 42,248.68 32,758.39 - 47,241.61 40.95 TOTAL Taxes 25,198,550.00 8,707,351.92 18,579,689.68 19,270,634.45 - 5,927,915.55 76.48% Franchises 000-421200 Center Point/Entex Energy 95,000.00 35,191.06 59,696.98 57,736.14 - 37,263.86 60.77 000-421220 City Public Service 1,020,000.00 231,253.90 420,449.42 464,605.10 - 555,394.90 45.55 000-421240 Guadalupe Valley Elec Co-op 455,000.00 97,638.66 198,556.70 194,390.23 - 260,609.77 42.72 000-421250 New Braunfels Utilities 78,000.00 16,100.61 27,876.95 32,049.50 - 45,950.50 41.09 000-421300 Time Warner-State Franchise 250,000.00 45,682.02 116,128.28 129,381.80 - 120,618.20 51.75 000-421460 AT&T Franchise Fee 150,000.00 40,483.68 80,948.66 52,181.99 - 97,818.01 34.79 000-421480 Other Telecom Franchise - ROW 130,000.00 8,317.48 63,698.57 46,832.79 - 83,167.21 36.03 000-421500 Solid Waste Franchise Fee 156,000.00 37,462.56 80,440.29 83,181.02 - 72,818.98 53.32 TOTAL Franchises 2,334,000.00 512,129.97 1,047,795.85 1,060,358.57 - 1,273,641.43 45.43% Permits 000-431100 Home Occupation Permit 500.00 105.00 385.00 525.00 - (25.00) 105.00 000-431205 Bldg Permit-Residential 550,000.00 175,629.50 270,585.50 305,528.00 - 244,472.00 55.55 000-431210 Bldg Permit-Commercial 350,000.00 75,189.00 143,777.00 125,645.00 - 224,355.00 35.90 000-431215 Bldg Permit-General 350,000.00 148,641.50 178,369.00 227,825.50 - 122,174.50 65.09 000-431300 Mobile Home Permit 400.00 - 275.00 300.00 - 100.00 75.00 000-431400 Signs Permit 5,600.00 823.00 2,755.00 2,309.00 - 3,291.00 41.23 000-431500 Food Establishmnt Permit 63,000.00 3,370.00 62,520.00 59,620.00 - 3,380.00 94.63 000-431700 Plumbing Permit 138,950.00 36,279.50 60,387.00 69,851.50 - 69,098.50 50.27 000-431750 Electrical Permit 70,900.00 21,160.00 28,660.00 42,600.00 - 28,300.00 60.08 000-431800 Mechanical Permit 68,300.00 16,560.00 29,960.00 31,340.00 - 36,960.00 45.89 000-431900 Solicitor/Peddler Permit 2,300.00 490.00 866.00 610.00 - 1,690.00 26.52 000-431950 Animal/Pet Permit 500.00 - 15.00 - - 500.00 0.00 000-432000 Cert of Occupancy Prmt 6,300.00 2,400.00 4,900.00 3,450.00 - 2,850.00 54.76 000-432100 Security Alarm Permit 43,000.00 7,295.00 18,961.00 14,270.00 - 28,730.00 33.19 000-432300 Grading/Clearing Permit 12,500.00 2,450.00 5,464.18 4,900.00 - 7,600.00 39.20 000-432400 Development Permit 75,000.00 46,383.67 31,359.09 53,778.09 - 21,221.91 71.70 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: March 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: March 31, 2021 000-435000 Fire Permit 30,000.00 6,904.00 22,312.50 11,128.50 - 18,871.50 37.10 TOTAL Permits 1,767,250.00 543,680.17 861,551.27 953,680.59 - 813,569.41 53.96% Licenses 000-441000 Alcohol Beverage License 8,100.00 555.00 3,510.00 3,095.00 - 5,005.00 38.21 000-441300 Mobile Home License 160.00 - 120.00 80.00 - 80.00 50.00 000-442000 Contractors License 45,600.00 13,550.00 24,200.00 22,200.00 - 23,400.00 48.68 000-444000 Pet License 3,000.00 - 957.00 - - 3,000.00 0.00 TOTAL Licenses 56,860.00 14,105.00 28,787.00 25,375.00 - 31,485.00 44.63% Fees 000-451000 Municipal Court Fines 664,160.00 113,784.33 332,171.64 213,208.90 - 450,951.10 32.10 000-451100 Arrest Fee 25,680.00 3,463.37 11,757.92 7,545.45 - 18,134.55 29.38 000-451110 Expunction Fee 160.00 - 100.00 - - 160.00 0.00 000-451200 Warrant Fees 73,560.00 11,300.02 36,683.45 19,314.29 - 54,245.71 26.26 000-451220 Officer Jury Fee 400.00 - 91.20 - - 400.00 0.00 000-451310 Restitution Fee-Local 0.00 102.60 126.00 102.60 - (102.60) 0.00 000-451320 Civil Justice Fee-Court 500.00 - - - - 500.00 0.00 000-451340 Judicial Fee-City 3,432.00 128.16 1,201.30 211.27 - 3,220.73 6.16 000-451400 Traffic Fine Costs TTL 12,168.00 1,468.05 5,338.46 3,432.50 - 8,735.50 28.21 000-451510 Juvenile Case Mgmt Fee 28,668.00 1,067.92 10,005.94 1,765.48 - 26,902.52 6.16 000-451520 Truancy Fees 5,352.00 3,005.58 5,137.73 6,766.83 - (1,414.83) 126.44 000-451530 Local Municipal Jury Fund 400.00 57.71 65.95 130.86 - 269.14 32.72 000-451600 Technology Fund Fee 22,992.00 3,172.45 10,728.99 6,692.45 - 16,299.55 29.11 000-451700 Security Fee 17,244.00 3,475.89 9,301.09 7,506.42 - 9,737.58 43.53 000-451800 Time Payment Fee-City 4,968.00 475.84 2,394.07 836.62 - 4,131.38 16.84 000-451850 State Fines 10% Service Fee 38,752.00 6,553.28 16,581.32 15,637.72 - 23,114.28 40.35 000-451900 DPS Payment-Local 5,592.00 936.00 2,721.71 1,540.00 - 4,052.00 27.54 000-452000 Child Safety Fee 10,356.00 1,072.63 4,826.32 2,984.11 - 7,371.89 28.82 000-452100 Platting Fees 59,000.00 11,500.00 6,750.00 17,500.00 - 41,500.00 29.66 000-452200 Site Plan Fee 36,000.00 2,000.00 3,000.00 6,500.00 - 29,500.00 18.06 000-452300 Plan Check Fee 625,000.00 182,521.25 280,480.00 295,634.50 - 329,365.50 47.30 000-452320 Tree Mitigation Admin Fee 15,000.00 - 10,707.30 38,640.00 - (23,640.00) 257.60 000-452400 BOA/Variance Fees 5,000.00 1,000.00 - 1,000.00 - 4,000.00 20.00 000-452600 Specific Use/Zone Chng Fee 18,000.00 15,300.00 14,999.80 21,300.00 - (3,300.00) 118.33 000-452710 Zoning Ltr & Dev Rights 1,950.00 1,050.00 2,250.00 1,650.00 - 300.00 84.62 000-453100 Reinspection Fees 190,000.00 33,425.00 98,875.00 85,300.00 - 104,700.00 44.89 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: March 31, 2021 000-453110 Swim Pool Inspection Fee 2,500.00 - 660.00 - - 2,500.00 0.00 000-453200 Lot Abatement 5,000.00 425.00 6,028.54 1,825.00 - 3,175.00 36.50 000-453211 Admin Fee-Inspections 18,600.00 400.00 6,000.00 1,000.00 - 17,600.00 5.38 000-453710 Foster Care 500.00 200.00 200.00 200.00 - 300.00 40.00 000-454200 Pool Gate Admission Fee 24,000.00 - 30.00 - - 24,000.00 0.00 000-454300 Seasonal Pool Pass Fee 5,000.00 - - - - 5,000.00 0.00 000-456120 Senior Center Meal Fee 20,000.00 9,205.86 6,504.98 16,860.15 - 3,139.85 84.30 000-456500 HAZ MAT Fees 5,000.00 - - - - 5,000.00 0.00 000-456600 Fire Re-inspection Fee 1,000.00 200.00 250.00 200.00 - 800.00 20.00 000-458000 Sale of General Fixed Assets 20,000.00 - - - - 20,000.00 0.00 000-458100 Sale of Merchandise 0.00 60.00 360.00 90.00 - (90.00) 0.00 000-458110 Sale of Mdse - GovDeals 80,000.00 31,672.84 25,232.64 55,957.84 - 24,042.16 69.95 000-458350 Gain on Sale of Fixed Assets 0.00 - - 3,800.00 - (3,800.00) 0.00 000-458400 Civic Center Rental Fees 130,900.00 575.00 5,850.00 2,300.00 - 128,600.00 1.76 000-458401 Capital Recovery Fee-Civic C 0.00 (50.00) 11,400.00 500.00 - (500.00) 0.00 000-458450 North Center Rental Fees 14,000.00 6,037.50 15,725.00 8,537.50 - 5,462.50 60.98 000-458460 Senior Center Rental 7,000.00 - 3,500.00 - - 7,000.00 0.00 000-458500 Community Center Rental Fees 23,800.00 7,687.00 13,269.50 11,322.00 - 12,478.00 47.57 000-458501 Community Center Service Fees 0.00 150.00 350.00 250.00 - (250.00) 0.00 000-458510 Grand Ballroom Rental Fees 0.00 (643.75) 79,223.75 6,968.75 - (6,968.75) 0.00 000-458520 Cut-Off Hall Rental Fees 0.00 (4,327.50) 10,936.25 (1,496.25) - 1,496.25 0.00 000-458530 Conference Hall Rental Fees 0.00 - 1,787.50 506.25 - (506.25) 0.00 000-458540 Bluebonnet Hall Rental Fees 0.00 (1,745.00) 26,776.25 1,948.75 - (1,948.75) 0.00 000-458550 Pavilion Rental Fees 20,000.00 3,807.50 5,605.00 5,732.50 - 14,267.50 28.66 000-458560 Chamber of Comm Rent 7,500.00 1,950.00 3,900.00 3,900.00 - 3,600.00 52.00 000-458570 Non-Resident SYSA League 10,000.00 5,990.00 8,590.00 5,990.00 - 4,010.00 59.90 000-458580 HOA Meeting Rental Fees 0.00 375.00 900.00 600.00 - (600.00) 0.00 000-458581 Funeral Reception Rental Fees 0.00 150.00 450.00 375.00 - (375.00) 0.00 000-458582 Quality of Life Rental Fees 0.00 1,935.00 4,245.00 3,435.00 - (3,435.00) 0.00 000-458590 Cancellation Fees-Event Rental 0.00 300.00 5,095.00 850.00 - (850.00) 0.00 000-458650 NonResident User Fee-BVYA 10,000.00 - - 7,080.00 - 2,920.00 70.80 000-458660 BVYA Utility Reimbursement 15,000.00 3,000.00 - 10,838.38 - 4,161.62 72.26 000-458670 SYSA Utility Reimbursement 7,500.00 - 4,493.68 - - 7,500.00 0.00 000-458675 Lions Futbol Utility Reimbrsmt 10,000.00 12,032.00 12,582.00 15,548.00 - (5,548.00) 155.48 000-458685 Recreation Programs 1,000.00 - - - - 1,000.00 0.00 000-458685.001Rec Prgrm-Kickball Leagues 2,600.00 - - - - 2,600.00 0.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: March 31, 2021 000-458700 Vehicle Impoundment 10,000.00 2,780.00 5,750.00 5,420.00 - 4,580.00 54.20 000-459200 NSF Check Fee 100.00 - 125.00 - - 100.00 0.00 000-459300 Notary Fee 100.00 6.00 24.00 42.00 - 58.00 42.00 000-459400 Maps,Copies,UDC & Misc Fees 0.00 - 5.00 - - - 0.00 000-459600 Animal Adoption Fee 12,000.00 2,195.00 7,690.00 4,135.00 - 7,865.00 34.46 000-459700 Pet Impoundment Fee 5,000.00 2,097.00 4,330.21 4,216.00 - 784.00 84.32 000-459800 Police Reports Fee 5,800.00 2,940.03 2,608.30 3,978.03 - 1,821.97 68.59 TOTAL Fees 2,338,234.00 486,264.56 1,147,337.79 938,109.90 - 1,400,124.10 40.12% Fines 000-463000 Library Fines 11,000.00 1,756.52 5,652.27 2,965.50 - 8,034.50 26.96 TOTAL Fines 11,000.00 1,756.52 5,652.27 2,965.50 - 8,034.50 26.96% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,077.00 5,269.44 - 21,077.76 - (0.76) 100.00 000-473200 City of Seguin-Fire Contract 30,107.00 8,363.28 12,544.90 16,726.56 - 13,380.44 55.56 000-473300 Guadalupe Co-Library 203,191.00 50,797.74 108,576.00 118,528.06 - 84,662.94 58.33 000-473400 Randolph AFB-Animal Control 500.00 - - - - 500.00 0.00 000-474200 Library Services-Cibolo 40,000.00 40,000.00 40,030.00 40,000.00 - - 100.00 000-474210 Library Services-Selma 26,000.00 25,020.00 26,505.00 25,020.00 - 980.00 96.23 000-474400 Dispatch Service-Cibolo 166,000.00 - 80,000.00 - - 166,000.00 0.00 000-474600 School Crossing Guard-Bexar Co 36,000.00 8,667.87 18,902.26 17,666.35 - 18,333.65 49.07 000-474610 School Cross Guard-Guadalupe C 41,000.00 10,272.82 20,528.73 20,627.90 - 20,372.10 50.31 000-474700 School Officer Funding 453,050.00 - 88,400.00 - - 453,050.00 0.00 000-474750 Crime Victim Liaison Agreement 50,000.00 12,500.00 50,000.00 25,000.00 - 25,000.00 50.00 TOTAL Inter-Jurisdictional 1,066,925.00 160,891.15 445,486.89 284,646.63 - 782,278.37 26.68% Fund Transfers 000-480000 Indirect Costs-EMS 182,600.00 46,566.00 89,550.00 91,341.00 - 91,259.00 50.02 000-480100 Indirect Costs-Hotel/Motel 72,464.00 17,625.03 37,214.02 36,232.06 - 36,231.94 50.00 000-481000 Transfer In - Reserves 1,081,160.00 - - - - 1,081,160.00 0.00 000-485000 Interfund Charges-Drainage-5%285,506.00 81,974.52 121,555.00 142,753.02 - 142,752.98 50.00 000-486000 Interfund Chrges-Admin W&S 1,450,827.00 379,163.49 692,499.98 725,413.46 - 725,413.54 50.00 000-486202 Transfer In-Water&Sewer Fund 4,000.00 - - - - 4,000.00 0.00 000-486203 Transfer In-EMS 4,000.00 - - - - 4,000.00 0.00 000-486204 Transfer In-Drainage 1,000.00 - - - - 1,000.00 0.00 000-487000 Interfund Charges-Fleet 398,618.00 108,666.30 180,333.52 198,833.08 - 199,784.92 49.88 000-488000 Interfund Charges-4B 503,717.00 - 230,818.00 230,818.00 - 272,899.00 45.82 000-489000 Transfer In 86,000.00 - - - - 86,000.00 0.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: March 31, 2021 TOTAL Fund Transfers 4,069,892.00 633,995.34 1,351,970.52 1,425,390.62 - 2,644,501.38 35.02% Miscellaneous 000-491000 Interest Earned 15,000.00 1,966.19 23,437.65 3,656.35 - 11,343.65 24.38 000-491200 Investment Income 120,000.00 12,484.63 177,653.65 32,567.97 - 87,432.03 27.14 000-491900 Unrealized Gain/Loss-CapOne 0.00 (8,742.65) 33,581.07 (16,855.56) - 16,855.56 0.00 000-493000 Donations-Others 0.00 500.00 - 500.00 - (500.00) 0.00 000-493120 Donations-Public Library 10,000.00 1,578.10 1,062.75 1,679.75 - 8,320.25 16.80 000-493400 Donations-Animal Control 5,000.00 305.00 2,878.00 2,040.00 - 2,960.00 40.80 000-493401 Donations-A/C Microchip 0.00 300.00 690.00 615.00 - (615.00) 0.00 000-493460 Donations- Parks 10,000.00 - - - - 10,000.00 0.00 000-493465 Donations-Senior Center 10,000.00 265.00 5,376.37 265.00 - 9,735.00 2.65 000-493502 Donations-PD 0.00 50.00 100.00 450.00 - (450.00) 0.00 000-493503 Donation-Fire Rescue 0.00 400.00 2,150.00 800.00 - (800.00) 0.00 000-493618 Donation - Veteran's Memorial 0.00 150.00 150.00 1,050.00 - (1,050.00) 0.00 000-493700 July 4th Activities 26,000.00 - - - - 26,000.00 0.00 000-493701 Proceeds-Holidazzle 12,500.00 - - 3,290.00 - 9,210.00 26.32 000-493704 Moving on Main 4,000.00 9,450.00 100.00 9,450.00 - (5,450.00) 236.25 000-494481 LawEnforcemtOfficersStnd&5,000.00 4,489.49 5,081.86 4,489.49 - 510.51 89.79 000-494482 Grants-Police, Fire, Gen Fund 2,500.00 - - 541.11 - 1,958.89 21.64 000-495100 Mobile Stage Rental Fees 2,100.00 550.00 1,550.00 550.00 - 1,550.00 26.19 000-497000 Misc Income-Gen Fund 40,000.00 113,442.66 34,964.11 126,801.30 - (86,801.30) 317.00 000-497005 Schertz Magazine Advertising 120,000.00 37,050.00 66,550.00 73,511.62 - 46,488.38 61.26 000-497100 Misc Income-Police 9,000.00 2,925.34 6,400.36 6,849.26 - 2,150.74 76.10 000-497200 Misc Income-Library 4,500.00 500.75 2,227.20 970.00 - 3,530.00 21.56 000-497210 Misc Income-Library Copier 18,000.00 1,695.55 9,427.25 2,823.05 - 15,176.95 15.68 000-497300 Misc Income-Animal Control 0.00 250.00 - 400.00 - (400.00) 0.00 000-497400 Misc Income-Streets Dept 30,000.00 3,285.76 7,033.29 6,261.76 - 23,738.24 20.87 000-497460 Misc Income-Parks 0.00 360.00 - 360.00 - (360.00) 0.00 000-497500 Misc Income-TML Ins. Claims 25,000.00 817.22 14,115.81 2,261.67 - 22,738.33 9.05 000-497550 Misc Income-TML WC Reimbursmnt 10,000.00 13,420.41 4,886.86 16,969.89 - (6,969.89) 169.70 000-497600 Misc Income-Vending Mach 2,500.00 100.99 859.38 192.37 - 2,307.63 7.69 000-498000 Reimbursmnt-Gen Fund 20,000.00 - 15,443.00 - - 20,000.00 0.00 000-498105 Reimbursmt Police OT-DEA 18,000.00 12,548.02 9,062.60 24,314.55 - (6,314.55) 135.08 000-498110 Reimburmnt Fire-Emg Acti-OT 100,000.00 40,312.45 72,533.39 40,312.45 - 59,687.55 40.31 000-498150 Reimbursement - Library 13,000.00 - 13,509.00 8,598.66 - 4,401.34 66.14 TOTAL Miscellaneous 632,100.00 250,454.91 510,823.62 355,715.69 - 276,384.31 56.28% 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: March 31, 2021 TOTAL REVENUES 37,474,811.00 11,310,629.54 23,979,094.89 24,316,876.95 - 13,157,934.05 64.89% Cash in Bank Claim on Operating Cash Pool-Checking 1,566,851.71$ Cash in Investments LOGIC Investment-General Fund 16,455,549.02 LOGIC Investment-Equip Replacement 79,084.19 LOGIC Investment-Veh Replacement 533,247.01 LOGIC Investment-Air Condi Replacment 290,197.16 BBVA CD Investment 1,049,696.40 CAPITAL ONE Investment-General Fund 1,464,207.42 Total Cash in Bank & Investments 21,438,832.91$ GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: March 31, 2021 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 2020-21 743,235 894,399 769,523 766,917 1,051,843 776,582 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 2016-17 574,470 758,598 580,171 560,431 747,281 486,739 432,444 669,542 553,540 566,565 696,536 573,973 - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 Sales Tax-General Fund AS OF: March 31, 2020 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2020-21 67,176 970,388 6,869,022 3,995,189 2,086,758 244,347 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 2016-17 419,931 328,521 5,447,189 2,515,077 2,106,927 120,850 42,362 34,666 58,291 24,344 16,511 13,700 - 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 2020-21 233,351 231,254 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 2016-17 252,947 191,140 213,951 259,517 $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 CITY PUBLIC SERVICE 2020-21 2019-20 2018-19 2017-18 2016-17 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 32,100.00 6,152.10 51,444.77 34,684.19 - (2,584.19) 108.05 TOTAL REVENUES 32,100.00 6,152.10 51,444.77 34,684.19 - (2,584.19) 108.05% EXPENDITURE SUMMARY GENERAL GOVERNMENT CULTURAL KICK CANCER 10,000.00 534.25 4,380.81 534.25 - 9,465.75 5.34 HAL BALDWIN SCHOLARSHIP 22,100.00 (1,250.00) 11,845.30 11,618.35 - 10,481.65 52.57 TOTAL CULTURAL 32,100.00 (715.75) 16,236.91 12,152.60 - 19,947.40 37.86% TOTAL EXPENDITURES 32,100.00 (715.75) 16,236.91 12,152.60 - 19,947.40 37.86% REVENUE OVER(UNDER) EXPEND 0.00 6,867.85 35,207.86 22,531.59 - (22,531.59) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2021 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 Fund Transfers Miscellaneous 000-491200 Investment Income 0.00 5.10 164.25 12.19 - (12.19) 0.00 000-492200 Kick Cancer 10,000.00 2,795.00 5,582.52 2,795.00 - 7,205.00 27.95 000-493621 Hal Baldwin Scholarship 22,100.00 455.00 24,350.00 28,980.00 - (6,880.00) 131.13 000-497000 Misc Income - Special Events 0.00 2,897.00 9,028.00 2,897.00 - (2,897.00) 0.00 TOTAL Miscellaneous 32,100.00 6,152.10 51,444.77 34,684.19 - (2,584.19) 108.05% TOTAL REVENUES 32,100.00 6,152.10 51,444.77 34,684.19 - (2,584.19) 108.05% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: March 31, 2021 Cash in Bank Current Claim on Operating Cash Pool-Checking 115,929.91$ Cash in Investments Texas Class- Special Events 18,042.64 Total Cash in Bank & Investments 133,972.55$ SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: March 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 FINANCIAL SUMMARY REVENUE SUMMARY Franchises 90,000.00 22,279.14 44,494.60 43,256.76 - 46,743.24 48.06 Fund Transfers 95,500.00 - - - - 95,500.00 - TOTAL REVENUES 185,500.00 22,279.14 44,494.60 43,256.76 - 142,243.24 23.32% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental MISC & PROJECTS Projects Capital Outlay 185,500.00 - - - - 185,500.00 - TOTAL MISC & PROJECTS 185,500.00 - - - - 185,500.00 0.00% TOTAL EXPENDITURES 185,500.00 - - - - 185,500.00 0.00% REVENUE OVER(UNDER) EXPEND 0.00 22,279.14 44,494.60 43,256.76 - (43,256.76) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 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 - 31,566.84 15,560.70 - 44,439.30 25.93 000-421465 AT&T PEG Fee 30,000.00 22,279.14 12,927.76 27,696.06 - 2,303.94 92.32 TOTAL Franchises 90,000.00 22,279.14 44,494.60 43,256.76 - 46,743.24 48.06% Fund Transfers 000-481000 Transfer In - Reserves 95,500.00 - - - - 95,500.00 0.00 TOTAL Fund Transfers 95,500.00 - - - - 95,500.00 0.00% Miscellaneous TOTAL REVENUES 185,500.00 22,279.14 44,494.60 43,256.76 - 142,243.24 23.32% AS OF: March 31, 2021 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) Cash in Bank Cash Balance 910,964.79$ Total Cash in Bank & Investments 910,964.79$ PEG FUND CASH IN BANK AND INVESTMENTS AS OF: March 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 238,750.00 200,071.10 174,542.71 215,849.19 - 22,900.81 90.41 Fees 24,803,500.00 6,010,251.80 12,196,687.81 12,005,158.01 - 12,798,341.99 48.40 Fund Transfers 146,400.00 61,603.98 73,200.00 98,203.98 - 48,196.02 67.08 Miscellaneous 315,718.00 140,161.33 223,787.82 190,467.28 - 125,250.72 60.33 TOTAL REVENUES 25,504,368.00 6,412,088.21 12,671,218.34 12,509,678.46 - 12,994,689.54 49.05% EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers 0.00 - - 19,745.69 - (19,745.69) - TOTAL NON DEPARTMENTAL 0.00 - - 19,745.69 - (19,745.69) 0.00% BUSINESS OFFICE Personnel Services 500,021.00 111,569.10 236,041.15 245,710.85 - 254,310.15 49.14 Supplies 5,100.00 119,289.57 1,344.98 119,721.22 5,191.84 (119,813.06) 2,449.28 City Support Services 5,000.00 33,151.19 28,640.26 33,151.19 - (28,151.19) 663.02 Utility Services 9,200.00 1,957.51 4,267.46 4,212.80 - 4,987.20 45.79 Operations Support 120,500.00 23,447.74 43,332.40 45,193.98 6,957.78 68,348.24 43.28 Staff Support 6,400.00 1,277.33 2,518.31 1,615.28 120.56 4,664.16 27.12 Professional Services 253,000.00 65,021.02 101,655.85 113,034.58 - 139,965.42 44.68 Maintenance Services 5,040.00 840.00 2,520.00 2,520.00 3,360.00 (840.00) 116.67 Operating Equipment 600.00 - 430.40 - - 600.00 - TOTAL BUSINESS OFFICE 904,861.00 356,553.46 440,555.31 565,159.90 15,630.18 324,070.92 64.19% W & S ADMINISTRATION Personnel Services 1,553,559.00 478,833.88 811,361.32 976,372.35 - 577,186.65 62.85 Supplies 187,500.00 35,032.32 152,483.10 36,707.43 6,457.33 144,335.24 23.02 City Support Services 166,535.00 24.07 62,118.14 66,077.53 - 100,457.47 39.68 Utility Services 3,575,800.00 851,777.87 1,659,677.23 1,700,774.83 1,351.85 1,873,673.32 47.60 Operations Support 11,300.00 2,581.58 7,214.21 3,978.98 - 7,321.02 35.21 Staff Support 39,500.00 9,245.39 27,493.39 16,401.40 30.00 23,068.60 41.60 City Assistance 500.00 - 76.00 - 40.00 460.00 8.00 Professional Services 444,015.00 209,548.37 228,208.31 229,817.16 38,904.99 175,292.85 60.52 Fund Charges/Transfers 6,470,624.00 1,741,867.82 3,609,873.69 3,695,403.01 - 2,775,220.99 57.11 Maintenance Services 9,166,090.00 2,782,029.75 3,612,418.52 4,213,531.56 162,105.74 4,790,452.70 47.74 Other Costs 40,000.00 38,435.72 36,605.45 38,435.72 - 1,564.28 96.09 Debt Service 2,106,932.00 1,575,649.23 1,551,501.10 1,575,649.23 - 531,282.77 74.78 Rental/Leasing 4,500.00 17,027.00 54,952.44 43,087.14 - (38,587.14) 957.49 Operating Equipment 8,000.00 1,174.06 2,511.01 1,174.06 249.55 6,576.39 17.80 Capital Outlay 146,887.00 - 34,513.60 - 48,887.00 98,000.00 33.28 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 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: March 31, 2021 TOTAL PUBLIC WORKS 23,921,742.00 7,743,227.06 11,851,007.51 12,597,410.40 258,026.46 11,066,305.14 53.74% MISC & PROJECTS PROJECTS Professional Services 0.00 1,815.00 15,680.00 3,932.50 8,724.00 (12,656.50) - Maintenance Services 0.00 536,692.00 - 762,716.86 20,137.00 (782,853.86) - SEWER PROJECT TOTAL EXPENDITURES 24,826,603.00 8,638,287.52 12,307,242.82 13,948,965.35 302,517.64 10,575,120.01 57.40% ** REVENUE OVER(UNDER)EXPENSES **677,765.00 (2,226,199.31) 363,975.52 (1,439,286.89) (302,517.64) 2,419,569.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 238,750.00 200,071.10 174,542.71 215,849.19 - 22,900.81 90.41 TOTAL Franchises 238,750.00 200,071.10 174,542.71 215,849.19 - 22,900.81 90.41% Permits TOTAL Permits 0.00 - 3,000.00 - - - 0.00% Fees 000-455200 Garbage Collection Fee 5,280,000.00 1,207,938.58 2,587,218.82 2,407,151.37 - 2,872,848.63 45.59 000-455600 Fire Line Fees 33,000.00 - - - - 33,000.00 - 000-455700 Recycle Fee Revenue 336,000.00 84,900.65 164,353.44 157,023.87 - 178,976.13 46.73 000-455800 W&S Line Constructn Reimbur 20,000.00 10,549.52 12,969.02 17,207.52 - 2,792.48 86.04 000-457100 Sale of Water 11,100,000.00 2,513,921.85 5,318,626.30 5,291,081.43 - 5,808,918.57 47.67 000-457110 Edwards Water Lease 40,000.00 - 48,196.28 - - 40,000.00 - 000-457120 Water Transfer Charge-Selma 30,000.00 - 17,169.24 13,881.72 - 16,118.28 46.27 000-457200 Sale of Meters 120,000.00 33,872.12 51,796.18 63,200.18 - 56,799.82 52.67 000-457400 Sewer Charges 7,592,000.00 2,158,094.08 3,862,085.37 4,054,211.92 - 3,537,788.08 53.40 000-457500 Water Penalties 250,000.00 150.00 132,323.16 250.00 - 249,750.00 0.10 000-459200 NSF Check Fee-Water&Sewer 2,500.00 825.00 1,950.00 1,150.00 - 1,350.00 46.00 TOTAL Fees 24,803,500.00 6,010,251.80 12,196,687.81 12,005,158.01 - 12,798,341.99 48.40% Fund Transfers 000-486204 Interfnd Chrg-Drainage Billing 146,400.00 36,600.00 73,200.00 73,200.00 - 73,200.00 50.00 000-486406 Transfer In - Pblc Imprvmnt 0.00 25,003.98 - 25,003.98 - (25,003.98) - TOTAL Fund Transfers 146,400.00 61,603.98 73,200.00 98,203.98 - 48,196.02 67.08% Miscellaneous 000-490000 Misc Charges 10,500.00 1,644.00 5,787.00 1,694.00 - 8,806.00 16.13 000-491000 Interest Earned 40,000.00 2,169.45 21,198.21 4,346.45 - 35,653.55 10.87 000-491200 Investment Income 120,000.00 25,308.49 113,985.13 28,452.12 - 91,547.88 23.71 000-496000 Water Construction Reserve Acc 0.00 - 1.00 - - - - 000-497000 Misc Income-W&S 20,000.00 51,108.65 12,096.79 61,429.44 - (41,429.44) 307.15 000-498110 Salary Reimb-SSLGC 125,218.00 59,930.74 70,719.69 94,545.27 - 30,672.73 75.50 TOTAL Miscellaneous 315,718.00 140,161.33 223,787.82 190,467.28 - 125,250.72 60.33% TOTAL REVENUES 25,504,368.00 6,412,088.21 12,671,218.34 12,509,678.46 - 12,994,689.54 49.05% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: March 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 195,929.70$ Cash in Investments Lone Star Investment-Water&Sewer 4,331,798.18 Lone Star Investment-W&S Customer Deposits 317,373.34 Lone Star Investment-W&S Equip Replacement 190,819.79 Lone Star Investment-W&S Veh Replacement 275,656.50 Schertz Bank & Trust-Certificate of Deposit 1,163,351.07 6,278,998.88$ Total Cash in Bank & Investments 6,474,928.58$ WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: March 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,621,567.20 1,641,030.83 2,993,220.77 3,227,717.50 - 3,393,849.70 48.75 Inter-Jurisdictional 3,028,357.31 190,608.12 1,541,258.91 1,636,279.66 - 1,392,077.65 54.03 Miscellaneous 135,500.00 117,009.13 81,344.79 144,285.43 - (8,785.43) 106.48 TOTAL REVENUES 9,785,424.51 1,948,648.08 4,615,824.47 5,008,282.59 - 4,777,141.92 51.18% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 4,628,222.00 1,126,324.57 2,269,175.04 2,440,423.27 - 2,187,798.73 52.73 Supplies 359,500.00 111,695.45 181,675.75 167,537.44 32,341.98 159,620.58 55.60 City Support Services 136,000.00 79.00 40,932.45 35,075.05 712.00 100,212.95 26.31 Utility Services 137,000.00 28,787.10 52,377.02 49,768.07 - 87,231.93 36.33 Operations Support 49,500.00 8,044.00 27,512.01 17,957.75 552.00 30,990.25 37.39 Staff Support 69,500.00 6,330.71 36,145.13 12,250.77 12,767.26 44,481.97 36.00 City Assistance 562,366.81 195,637.64 278,179.37 350,863.89 3,863.46 207,639.46 63.08 Professional Services 118,500.00 22,936.89 64,491.62 63,242.43 26,000.02 29,257.55 75.31 Fund Charges/Transfers 2,993,790.20 742,002.27 1,392,003.26 1,364,174.64 - 1,629,615.56 45.57 Maintenance Services 30,000.00 2,880.00 19,080.00 3,840.00 - 26,160.00 12.80 Debt Service 0.00 113,375.00 116,458.55 113,375.00 - (113,375.00) - Rental/Leasing 67,000.00 - 65,118.05 - - 67,000.00 - Operating Equipment 72,000.00 10,610.59 14,056.50 12,834.46 998.75 58,166.79 19.21 Capital Outlay 778,612.00 42,500.98 41,936.16 304,112.98 399,348.00 75,151.02 90.35 TOTAL PUBLIC SAFETY 10,001,991.01 2,411,204.20 4,599,140.91 4,935,455.75 476,583.47 4,589,951.79 54.11% TOTAL EXPENDITURES 10,001,991.01 2,411,204.20 4,599,140.91 4,935,455.75 476,583.47 4,589,951.79 54.11% ** REVENUE OVER(UNDER) EXPENSES **(216,566.50) (462,556.12) 16,683.56 72,826.84 (476,583.47) 187,190.13 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 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,340,467.20 1,572,274.16 2,853,933.60 3,050,860.14 - 3,289,607.06 48.12 000-456110 Passport Membership Fees 28,000.00 5,330.00 23,825.00 24,970.00 - 3,030.00 89.18 000-456120 EMT Class - Fees 99,000.00 42,150.00 51,675.00 72,400.00 - 26,600.00 73.13 000-456122 CE Class - Fees 15,000.00 - - 2,318.77 - 12,681.23 15.46 000-456130 Immunization Fees 3,000.00 - 3,153.92 1,336.40 - 1,663.60 44.55 000-456140 Billing Fees-External 26,000.00 4,012.31 11,910.53 9,563.53 - 16,436.47 36.78 000-456150 Standby Fees 25,000.00 - 14,870.00 29,320.20 - (4,320.20) 117.28 000-456155 Community Services Support 50,000.00 6,905.36 15,961.82 17,249.46 - 32,750.54 34.50 000-456160 MIH Services 35,000.00 10,359.00 17,815.90 19,674.00 - 15,326.00 56.21 000-459200 NSF Check Fee 100.00 - 75.00 25.00 - 75.00 25.00 TOTAL Fees 6,621,567.20 1,641,030.83 2,993,220.77 3,227,717.50 - 3,393,849.70 48.75% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 843,577.17 154,655.82 492,087.15 463,967.46 - 379,609.71 55.00 000-474300 Cibolo Support 473,115.24 - 219,806.24 236,557.62 - 236,557.62 50.00 000-475100 Comal Co ESD #6 141,411.38 35,952.30 65,330.24 69,506.78 - 71,904.60 49.15 000-475200 Live Oak Support 246,255.84 - 118,887.30 123,127.92 - 123,127.92 50.00 000-475300 Universal City Support 321,566.04 - 152,997.88 160,783.02 - 160,783.02 50.00 000-475400 Selma Support 171,441.00 - 80,500.68 85,720.50 - 85,720.50 50.00 000-475500 Schertz Support 667,048.68 - 301,291.38 333,524.34 - 333,524.34 50.00 000-475600 Santa Clara Support 11,455.20 - 5,568.62 5,727.60 - 5,727.60 50.00 000-475800 Marion Support 18,374.76 - 8,424.32 9,187.38 - 9,187.38 50.00 000-475910 TASPP Program 134,112.00 - 96,365.10 148,177.04 - (14,065.04) 110.49 TOTAL Inter-Jurisdictional 3,028,357.31 190,608.12 1,541,258.91 1,636,279.66 - 1,392,077.65 54.03% Fund Transfers - Miscellaneous 000-491000 Interest Earned 2,500.00 105.36 939.69 262.36 - 2,237.64 10.49 000-491200 Investment Income 5,000.00 327.25 6,854.50 716.45 - 4,283.55 14.33 000-493203 Donations-EMS 2,000.00 - 5,695.53 865.00 - 1,135.00 43.25 000-497000 Misc Income 60,000.00 97,106.41 33,159.18 99,354.41 - (39,354.41) 165.59 000-497100 Recovery of Bad Debt 6,000.00 2,164.82 3,204.14 8,374.99 - (2,374.99) 139.58 000-497110 Collection Agency-Bad Debt 60,000.00 17,305.29 31,491.75 34,712.22 - 25,287.78 57.85 TOTAL Miscellaneous 135,500.00 117,009.13 81,344.79 144,285.43 - (8,785.43) 106.48% TOTAL REVENUES 9,785,424.51 1,948,648.08 4,615,824.47 5,008,282.59 - 4,777,141.92 51.18% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: March 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 287,786.26$ Cash in Investments EMS-Logic 897,185.33 SR 2017 Ambulance-Logic 12.11 Total Cash in Bank & Investments 1,184,983.70$ C I T Y O F S C H E R T Z CASH IN BANK AND INVESTMENTS AS OF: March 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 1,570.00 1,780.00 2,370.00 - 1,630.00 59.25 Fees 1,230,000.00 307,375.09 606,226.15 577,263.19 - 652,736.81 46.93 Fund Transfers 195,793.00 - - - - 195,793.00 - Miscellaneous 33,000.00 225.17 10,643.12 586.28 - 32,413.72 1.78 TOTAL REVENUES 1,462,793.00 309,170.26 618,649.27 580,219.47 - 882,573.53 39.67% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 403,147.00 84,825.99 154,392.87 201,016.35 - 202,130.65 49.86 Supplies 6,000.00 1,534.53 3,557.39 2,634.14 - 3,365.86 43.90 City Support Services 35,500.00 905.94 3,803.87 4,023.21 - 31,476.79 11.33 Utility Services 14,700.00 4,411.36 5,045.89 8,489.78 751.83 5,458.39 62.87 Operations Support 1,050.00 - - - - 1,050.00 - Staff Support 13,700.00 2,564.48 3,544.56 3,486.96 140.00 10,073.04 26.47 City Assistance 500.00 40.00 80.00 40.00 50.00 410.00 18.00 Professional Services 58,729.00 2,700.00 1,500.00 2,758.50 600.00 55,370.50 5.72 Fund Charges/Transfers 532,167.00 145,918.77 240,848.58 285,938.53 - 246,228.47 53.73 Maintenance Services 83,000.00 6,225.00 22,180.00 8,061.51 2,105.00 72,833.49 12.25 Other Costs 200.00 - 100.00 - - 200.00 - Debt Service 122,100.00 1,050.00 2,085.17 1,050.00 - 121,050.00 0.86 Rental/Leasing 500.00 - - - - 500.00 - Operating Equipment 2,500.00 - 863.97 - - 2,500.00 - Capital Outlay 224,120.00 213,572.58 - 213,572.58 - 10,547.42 95.29 TOTAL DRAINAGE 1,497,913.00 463,748.65 438,002.30 731,071.56 3,646.83 763,194.61 49.05% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 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 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2021 PROJECTS Maintenance Services 0.00 188,725.21 1,384.10 176,956.96 122,709.65 (299,666.61) - TOTAL PROJECTS 0.00 188,725.21 1,384.10 176,956.96 132,106.95 (309,063.91) 0.00% TOTAL EXPENDITURES 1,497,913.00 652,473.86 439,386.40 908,028.52 135,753.78 454,130.70 69.68% ** REVENUE OVER(UNDER) EXPEND (35,120.00) (343,303.60) 179,262.87 (327,809.05) (135,753.78) 428,442.83 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 1,570.00 1,780.00 2,370.00 - 1,630.00 59.25 TOTAL Permits 4,000.00 1,570.00 1,780.00 2,370.00 - 1,630.00 59.25% Fees 000-457500 Drainage Penalties 10,000.00 - 4,250.09 - - 10,000.00 0.00 000-457600 Drainage Fee 1,220,000.00 307,375.09 601,976.06 577,263.19 - 642,736.81 47.32 TOTAL Fees 1,230,000.00 307,375.09 606,226.15 577,263.19 - 652,736.81 46.93% Fund Transfers 000-481000 Transfer In - Reserves 178,564.00 - - - - 178,564.00 0.00 000-486100 Transfer In 17,229.00 - - - - 17,229.00 0.00 TOTAL Funds Transfers 195,793.00 - - - - 195,793.00 0.00% Miscellaneous 000-491000 Interest Earned 3,000.00 10.96 336.01 30.73 - 2,969.27 1.02 000-491200 Investment Income 30,000.00 214.21 6,805.69 555.55 - 29,444.45 1.85 TOTAL Miscellaneous 33,000.00 225.17 10,643.12 586.28 - 32,413.72 1.78% TOTAL REVENUES 1,462,793.00 309,170.26 618,649.27 580,219.47 - 882,573.53 39.67% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: March 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 114,486.48$ Cash in Investments Lone Star Investment-Drainage Maint Fund 386,040.01 Total Cash in Bank & Investments 500,526.49$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: March 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 70,938.96 208,761.91 136,183.00 - 383,817.00 26.19 Miscellaneous 20,750.00 584.21 20,265.17 1,404.58 - 19,345.42 6.77 TOTAL REVENUES 540,750.00 71,523.17 229,027.08 137,587.58 - 403,162.42 25.44% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 112,466.00 12,094.75 57,300.09 36,677.77 - 75,788.23 32.61 Operations Support 46,000.00 5,038.28 8,553.00 9,224.28 - 36,775.72 20.05 Professional Services 3,000.00 3,000.00 3,499.50 3,000.00 - - 100.00 Fund Charges/Transfers 72,464.00 17,625.03 37,214.02 36,232.06 - 36,231.94 50.00 Maintenance Services 20,000.00 56,284.05 - 111,907.65 30,396.85 (122,304.50) 711.52 TOTAL NONDEPARTMENTAL 253,930.00 94,042.11 106,566.61 197,041.76 30,396.85 26,491.39 89.57% TOTAL EXPENDITURES 253,930.00 94,042.11 106,566.61 197,041.76 30,396.85 26,491.39 89.57% REVENUE OVER(UNDER) EXPENDITURE 286,820.00 (22,518.94) 122,460.47 (59,454.18) (30,396.85) 376,671.03 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 41,155.39$ Cash in Investments Texas Class - Hotel Tax 1,984,328.92 Total Cash in Bank & Investments 2,025,484.31$ HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: March 31, 2021 AS OF: March 31, 2021 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2020-21 22,147 18,567 19,948 23,467 28,556 45,098 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 2016-17 33,917 33,203 30,940 32,131 33,710 51,467 47,698 43,479 55,151 57,536 46,685 33,548 - 10,000 20,000 30,000 40,000 50,000 60,000 70,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 70,000.00 - - - - 70,000.00 - Fund Transfers 51,500.00 - - - - 51,500.00 - Miscellaneous 3,500.00 84.24 2,581.24 198.91 - 3,301.09 5.68 TOTAL REVENUES 125,000.00 84.24 2,581.24 198.91 - 124,801.09 0.16% EXPENDITURE SUMMARY NON DEPARTMENTAL PARKLAND DEDICATION Professional Services 25,000.00 - - - 810.70 24,189.30 3.24 Capital Outlay 100,000.00 - - - - 100,000.00 - TOTAL PARKLAND DEDICATION 125,000.00 - - - 810.70 124,189.30 0.65% TOTAL EXPENDITURES 125,000.00 - - - 810.70 124,189.30 0.65% REVENUE OVER(UNDER) EXPEND 0.00 84.24 2,581.24 198.91 (810.70) 611.79 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 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 70,000.00 - - - - 70,000.00 - TOTAL Fees 70,000.00 - - - - 70,000.00 0.00% Fund Transfers 000-48100 Transfer In- Reserves 51,500.00 - - - - 51,500.00 0.00 TOTAL Fund Transfers 51,500.00 - - - - 51,500.00 0.00% Miscellaneous 000-491000 Interest Earned 500.00 2.92 339.30 6.08 - 493.92 1.22 000-491200 Investment Income 3,000.00 81.32 2,240.94 192.83 - 2,807.17 6.43 000-493700 Donations 0.00 - 1.00 - - - 0 TOTAL Miscellaneous 3,500.00 84.24 2,581.24 198.91 - 3,301.09 5.68% TOTAL REVENUES 125,000.00 84.24 2,581.24 198.91 - 124,801.09 0.16% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: March 31, 2021 Cash in Bank Current Claim on Operating Cash Pool-Checking 6,366.72 Cash in Investments Texas Class- Park Fund 286,067.64 Total in Investment Pool 286,067.64 Total Cash in Bank & Investments 292,434.36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: March 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,264.70 218,960.00 - (148,960.00) 312.80 Miscellaneous 4,500.00 195.48 4,785.33 433.02 - 4,066.98 9.62 TOTAL REVENUES 74,500.00 195.48 61,050.03 219,393.02 - (144,893.02) 294.49% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services 70,000.00 2,700.00 7,900.00 5,625.00 - 64,375.00 8.04 TOTAL TREE MITIGATION 70,000.00 2,700.00 7,900.00 5,625.00 - 64,375.00 8.04% TOTAL EXPENDITURES 70,000.00 2,700.00 7,900.00 5,625.00 - 64,375.00 8.04% REVENUE OVER(UNDER) EXPEND 4,500.00 (2,504.52) 53,150.03 213,768.02 - (209,268.02) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 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,264.70 218,960.00 - (148,960.00) 312.80 TOTAL Fees 70,000.00 - 56,264.70 218,960.00 - (148,960.00) 312.80% Fund Transfers Miscellaneous 000-491000 Interest Earned 500.00 6.73 410.11 13.92 - 486.08 2.78 000-491200 Investment Income 4,000.00 188.75 3,875.22 419.10 - 3,580.90 10.48 TOTAL Miscellaneous 4,500.00 195.48 4,785.33 433.02 - 4,066.98 9.62% TOTAL REVENUES 74,500.00 195.48 61,050.03 219,393.02 - (144,893.02) 294.49% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: March 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking $13,853.49 Cash in Investments MBIA Investment-Tree Mitigation 663,142.15 Total Cash in Bank & Investments $676,995.64 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: March 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 413,694.00 564,707.29 737,901.00 - 362,099.00 67.08 Miscellaneous 72,000.00 2,712.27 60,718.90 6,217.17 - 65,782.83 8.63 TOTAL REVENUES 1,172,000.00 416,406.27 625,426.19 744,118.17 - 427,881.83 63.49% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 206,000.00 35,414.11 1,000.00 35,414.11 92,802.17 77,783.72 62.24 TOTAL NON DEPARTMENTAL 206,000.00 35,414.11 1,000.00 35,414.11 92,802.17 77,783.72 62.24% MISC & PROJECTS PROJECTS TOTAL EXPENDITURES 206,000.00 35,414.11 1,000.00 35,414.11 92,802.17 77,783.72 62.24% REVENUE OVER(UNDER) EXPENDITURES 966,000.00 380,992.16 624,426.19 708,704.06 (92,802.17) 350,098.11 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 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 413,694.00 564,707.29 737,901.00 - 362,099.00 67.08 TOTAL Fees 1,100,000.00 413,694.00 564,707.29 737,901.00 - 362,099.00 67.08% Fund Transfers Miscellaneous - 000-491000 Interest Earned 2,000.00 76.30 2,610.33 140.80 - 1,859.20 7.04 000-491200 Investment Income 70,000.00 2,635.97 58,108.57 6,076.37 - 63,923.63 8.68 TOTAL Miscellaneous 72,000.00 2,712.27 60,718.90 6,217.17 - 65,782.83 8.63% TOTAL REVENUES 1,172,000.00 416,406.27 625,426.19 744,118.17 - 427,881.83 63.49% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: March 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 244,335.81$ Cash in Investments Lone Star Investment-Capital Recovery Water 8,190,133.11 Total Cash in Bank & Investments 8,434,468.92$ CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: March 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 209,787.28 279,760.20 384,009.88 - 215,990.12 64.00 Miscellaneous 72,000.00 2,505.25 72,371.81 5,616.03 - 66,383.97 7.80 TOTAL REVENUES 672,000.00 212,292.53 352,132.01 389,625.91 - 282,374.09 57.98% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 208,000.00 40,493.76 3,257.72 41,632.14 118,123.02 48,244.84 76.81 TOTAL NON DEPARTMENTAL 208,000.00 40,493.76 3,257.72 41,632.14 118,123.02 48,244.84 76.81% MISC & PROJECTS TOTAL EXPENDITURES 208,000.00 40,493.76 3,257.72 41,632.14 118,123.02 48,244.84 76.81% REVENUE OVER(UNDER) EXPENDITURES 464,000.00 171,798.77 348,874.29 347,993.77 (118,123.02) 234,129.25 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 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 209,787.28 279,760.20 384,009.88 - 215,990.12 64.00 TOTAL Fees 600,000.00 209,787.28 279,760.20 384,009.88 - 215,990.12 64.00% Fund Transfers Miscellaneous 000-491000 Interest Earned 2,000.00 53.95 1,536.40 104.03 - 1,895.97 5.20 000-491200 Investment Income 70,000.00 8,842.71 62,526.15 18,272.62 - 51,727.38 26.10 000-491900 Unrealize Gain/Loss-Captl One 0.00 (6,391.41) 8,309.26 (12,760.62) - 12,760.62 - TOTAL Miscellaneous 72,000.00 2,505.25 72,371.81 5,616.03 - 66,383.97 7.80% TOTAL REVENUES 672,000.00 212,292.53 352,132.01 389,625.91 - 282,374.09 57.98% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: March 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 99,190.57$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 5,764,119.97 Capital One-Investment 1,830,517.29 Total Cash in Bank & Investments 7,693,827.83$ CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: March 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 6,980,821.00 3,024,374.77 6,501,078.86 6,807,797.49 - 173,023.51 97.52 Fund Transfers 0.00 7,914.84 - 7,914.84 - (7,914.84) - Miscellaneous 115,000.00 25,618.89 40,567.39 51,012.57 - 63,987.43 44.36 TOTAL REVENUES 7,095,821.00 3,057,908.50 6,541,646.25 6,866,724.90 - 229,096.10 96.77% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 50,000.00 1,600.00 2,000.00 176,599.52 - (126,599.52) 353.20 Debt Service 7,044,861.00 5,648,062.89 5,807,380.75 5,648,062.89 - 1,396,798.11 80.17 TOTAL GENERAL GOVERNMENT 7,094,861.00 5,649,662.89 5,809,380.75 5,824,662.41 - 1,270,198.59 82.10% TOTAL EXPENDITURES 7,094,861.00 5,649,662.89 5,809,380.75 5,824,662.41 - 1,270,198.59 82.10% ** REVENUE OVER(UNDER) EXPEND 960.00 (2,591,754.39) 732,265.50 1,042,062.49 - (1,041,102.49) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 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 6,980,821.00 3,024,374.77 6,501,078.86 6,807,797.49 - 173,023.51 97.52 TOTAL Taxes 6,980,821.00 3,024,374.77 6,501,078.86 6,807,797.49 - 173,023.51 97.52% Fund Transfers Miscellaneous 000-491200 Investment Income 15,000.00 458.89 13,933.31 801.60 - 14,198.40 5.34 000-495020 Contribution From YMCA 100,000.00 25,000.00 25,000.00 50,000.00 - 50,000.00 50.00 TOTAL Miscellaneous 115,000.00 25,458.89 38,933.31 50,801.60 - 64,198.40 44.18% TOTAL REVENUES 7,095,821.00 3,049,833.66 6,540,012.17 6,858,599.09 - 237,221.91 96.66% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: March 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 1,600.00 2,000.00 1,800.00 - 3,200.00 36.00 101-541502 Cost of Bond Issuance 45,000.00 - - 174,799.52 - (129,799.52) 388.44 TOTAL Professional Services 50,000.00 1,600.00 2,000.00 176,599.52 - (126,599.52) 353.20% Debt Service 101-555628 Bond-CO 2007-Principal 325,000.00 - - - - 325,000.00 - 101-555628.1 Bond-CO 2007-Interest 98,800.00 - - - - 98,800.00 - 101-555629 Bond-GO 2007 Principal 0.00 325,000.00 315,000.00 325,000.00 - (325,000.00) - 101-555629.1 Bond-GO 2007 Interest 0.00 52,706.50 59,116.75 52,706.50 - (52,706.50) - 101-555633 Bond-GO SR2011 Principal 270,000.00 270,000.00 260,000.00 270,000.00 - - 100 101-555633.1 Bond-GO SR2011 Interest 296,938.00 6,750.00 157,043.75 6,750.00 - 290,188.00 2.27 101-555634 Bond-GO 2011A Refund-Principal 485,000.00 485,000.00 475,000.00 485,000.00 - - 100 101-555634.1 Bond-GO 2011A Refund-Interest 52,367.00 29,008.50 34,542.25 29,008.50 - 23,358.50 55.39 101-555635 Bond-GO 2012 - Principal 365,000.00 365,000.00 355,000.00 365,000.00 - - 100 101-555635.1 Bond-GO 2012 - Interest 138,370.00 71,922.50 77,247.50 71,922.50 - 66,447.50 51.98 101-555638 Bond-GO 2014 Refund-Principal 100,000.00 100,000.00 100,000.00 100,000.00 - - 100 101-555638.1 Bond-GO 2014 Refund-Interest 280,775.00 141,137.50 142,637.50 141,137.50 - 139,637.50 50.27 101-555639 Tax Note - SR2015 - Principal 40,000.00 - - - - 40,000.00 - 101-555639.1 Tax Note - SR2015 - Interest 700.00 350.00 651.62 350.00 - 350.00 50 101-555640 Bond-Ref 2015 Bond-Principal 690,000.00 690,000.00 675,000.00 690,000.00 - - 100 101-555640.1 Bond-GO Ref 2015-Interest 47,400.00 28,875.00 37,312.50 28,875.00 - 18,525.00 60.92 101-555641 Tax Note - SR2015A-Principal 150,000.00 - - - - 150,000.00 0 101-555641.1 Tax Note - SR2015A - Interest 4,697.00 2,348.50 3,503.50 2,348.50 - 2,348.50 50 101-555642 Bond-GO SR2016-Principal 235,000.00 235,000.00 225,000.00 235,000.00 - - 100 101-555642.1 Bond-GO SR2016-Interest 141,207.00 72,953.13 77,453.13 72,953.13 - 68,253.87 51.66 101-555643 Bond-TaxableB CO SR2016-Princi 60,000.00 60,000.00 60,000.00 60,000.00 - - 100 101-555643.1 Bond-Taxable CO SR2016-Interes 42,063.00 21,481.25 22,381.25 21,481.25 - 20,581.75 51.07 101-555644 Bond-NonTaxA CO SR2016-Princip 190,000.00 190,000.00 180,000.00 190,000.00 - - 100 101-555644.1 Bond-NonTax CO SR2016-Interest 48,169.00 25,984.38 29,584.38 25,984.38 - 22,184.62 53.94 101-555645 Bond-CO SR2017-Principal 405,000.00 295,000.00 290,000.00 295,000.00 - 110,000.00 72.84 101-555645.1 Bond-CO SR2017 - Interest 126,800.00 63,062.50 67,412.50 63,062.50 - 63,737.50 49.73 101-555646 Bond-GO SR2017 - Principal 160,000.00 160,000.00 155,000.00 160,000.00 - - 100 101-555646.1 Bond-GO SR2017 - Interest 104,925.00 53,662.50 55,987.50 53,662.50 - 51,262.50 51.14 101-555647 Bond-GO 2018 Refund- Principal 570,000.00 570,000.00 560,000.00 570,000.00 - - 100 101-555647.1 Bond-GO 2018 Refund - Interest 98,368.00 52,205.00 58,141.00 52,205.00 - 46,163.00 53.07 101-555648 Bond-CO SR2018 - Principal 235,000.00 235,000.00 220,000.00 235,000.00 - - 100 101-555648.1 Bond-CO 2018 - Interest 175,888.00 90,881.25 96,381.25 90,881.25 - 85,006.75 51.67 101-555649 Bond-GO 2018 Ref - Principal 530,000.00 530,000.00 580,000.00 530,000.00 - - 100 101-555649.1 Bond-GO 2018 Ref - Interest 199,694.00 106,471.88 120,971.87 106,471.88 - 93,222.12 53.32 101-555650 Bond-CO 2019-Principal 255,000.00 255,000.00 250,000.00 255,000.00 - - 100 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 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 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2021 101-555650.1 Bond-CO 2019-Interest 122,700.00 63,262.50 67,012.50 63,262.50 - 59,437.50 51.56 TOTAL Debt Service 7,044,861.00 5,648,062.89 5,807,380.75 5,648,062.89 - 1,396,798.11 80.17% Other Financing Sources TOTAL EXPENDITURES 7,094,861.00 5,649,662.89 5,809,380.75 5,824,662.41 - 1,270,198.59 82.10% Cash in Bank Claim on Operating Cash Pool-Checking 59,759.72$ MBIA Investment- Tax I&S 1,768,221.16 Total Cash in Bank & Investments 1,827,980.88$ TAX I&S CASH IN BANK AND INVESTMENTS AS OF: March 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 4,507,371.00 1,158,553.94 2,387,218.57 2,458,140.71 - 2,049,230.29 54.54 Fund Transfers 3,496,428.00 - - - - 3,496,428.00 - Miscellaneous 141,000.00 27,232.39 216,564.24 40,819.99 - 100,180.01 28.95 TOTAL REVENUES 8,144,799.00 1,185,786.33 2,603,782.81 2,498,960.70 - 5,645,838.30 30.68% EXPENDITURE SUMMARY NONDEPARTMENTAL City Assistance 3,119,275.00 - 746,991.90 200,000.00 - 2,919,275.00 6.41 Fund Charges/Transfers 4,050,000.00 - - - - 4,050,000.00 - TOTAL NONDEPARTMENTAL 7,169,275.00 - 746,991.90 200,000.00 - 6,969,275.00 2.79% MISC & PROJECTS PROJECTS ECONOMIC DEVELOPMENT Supplies 500.00 86.25 281.57 183.16 42.23 274.61 45.08 City Support Services 21,150.00 - 4,537.56 1,810.07 - 19,339.93 8.56 Utility Services 3,695.00 346.49 764.49 506.07 - 3,188.93 13.70 Operations Support 148,610.00 10,183.39 18,367.31 17,463.82 40.00 131,106.18 11.78 Staff Support 28,100.00 697.49 2,691.18 1,592.69 124.89 26,382.42 6.11 City Assistance 202,500.00 - 264.33 - - 202,500.00 - Professional Services 61,300.00 1,920.50 6,386.46 7,544.00 - 53,756.00 12.31 Fund Charges/Transfers 504,669.00 - 230,818.00 230,818.00 - 273,851.00 45.74 Operating Equipment 5,000.00 2,000.00 651.90 2,000.00 - 3,000.00 40.00 TOTAL ECONO DEVELOPMENT 975,524.00 15,234.12 264,762.80 261,917.81 207.12 713,399.07 26.87% FM3009 ROAD&BRIDGE EXPANSION TOTAL EXPENDITURES 8,144,799.00 15,234.12 1,011,754.70 461,917.81 207.12 7,682,674.07 5.67% ** REVENUE OVER(UNDER) EXPEND 0.00 1,170,552.21 1,592,028.11 2,037,042.89 (207.12) (2,036,835.77) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2021 Cash in Bank Claim on Operating Cash Pool-Checking 330,875.22$ Cash in Investments Texas Class Investment-Economic Development Corp 19,754,411.91 Schertz Bank & Trust-Certificate of Deposit 1,080,548.16 Schertz Bank & Trust-Certificate of Deposit 1,116,943.91 Total Cash in Bank & Investments 22,282,779.20$ SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: March 31, 2021