Loading...
2020-PDF-Q3_Final.pdf-1CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2019 - 2020 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET General Fund, 101 Total Revenues 39,842,237.00 29,372,809.65 (30.98)10,469,458.33 73.72% Total General Government 7,016,113.79 4,549,193.60 668,904.85 1,798,015.34 74.37% Total Public Safety 15,607,921.28 11,095,066.11 555,562.41 3,957,292.76 74.65% Total Public Environment 1,883,260.00 868,685.69 410,333.22 604,241.09 67.92% Total Parks & Recreation 2,584,923.00 1,344,786.42 194,621.31 1,045,515.27 59.55% Total Cultural 1,025,736.00 753,788.50 17,317.49 254,630.01 75.18% Total Health 699,825.40 509,852.92 4,309.37 185,663.11 73.47% Total Internal Services 6,671,465.11 4,147,625.45 272,073.82 2,251,765.84 66.25% Total Misc & Projects 4,352,992.00 226,089.03 37,839.34 4,089,063.63 6.06% Total Expenditures 39,842,236.58 23,495,087.72 2,160,961.81 14,186,187.05 64.39% Revenue Over(Under) Expenditures 0.42 5,877,721.93 (2,160,992.79)(3,716,728.72) General Fund, 101 Total Cash in Bank & Investments 21,460,019.78 Special Events Fund, 106 Total Revenues 29,510.00 45,116.53 0.00 (15,606.53)152.89% Total Expenditures 29,510.00 16,998.68 5,553.48 6,957.84 76.42% Revenue Over(Under) Expenditures 0.00 28,117.85 (5,553.48)(22,564.37) Special Events Fund, 106 Total Cash in Bank & Investments 136,664.37 Peg Fund, 110 Total Revenues 118,000.00 60,605.89 0.00 57,394.11 51.36% Total Expenditures 118,000.00 0.00 0.00 118,000.00 0.00% Revenue Over(Under) Expenditures 0.00 60,605.89 0.00 (60,605.89) Peg Fund, 110 Total Cash in Bank & Investments 846,314.38 Water & Sewer, 202 Total Revenues 29,539,353.00 19,342,046.93 0.00 10,197,306.07 65.48% Total Expenditures 29,539,353.00 17,164,522.19 2,612,687.51 9,762,143.30 66.95% Revenue Over(Under) Expenditures 0.00 2,177,524.74 (2,612,687.51)435,162.77 Water & Sewer, 202 Total Cash in Bank & Investments 11,213,266.02 Quarterly Statement Schertz, Texas AS OF :JUNE 30, 2020 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2019 - 2020 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET EMS, 203 Total Revenues 9,599,144.15 6,583,641.79 0.00 3,015,502.36 68.59% Total Expenditures 9,598,811.11 6,629,223.49 368,172.99 2,601,414.63 72.90% Revenue Over(Under) Expenditures 333.04 (45,581.70)(368,172.99)414,087.73 EMS, 203 Total Cash in Bank & Investments 961,667.87 Drainage, 204 Total Revenues 1,267,000.00 924,160.13 0.00 342,839.87 72.94% Total Expenditures 1,265,709.00 698,550.53 63,992.69 503,165.78 60.25% Revenue Over(Under) Expenditures 1,291.00 225,609.60 (63,992.69)(160,325.91) Drainage, 204 Total Cash in Bank & Investments 894,891.50 Hotel Tax, 314 Total Revenues 553,000.00 271,030.16 0.00 281,969.84 49.01% Total Expenditures 505,894.00 363,075.50 1,703.70 141,114.80 72.11% Revenue Over(Under) Expenditures 47,106.00 (92,045.34)(1,703.70)140,855.04 Hotel Tax, 314 Total Cash in Bank & Investments 2,059,031.00 Park, 317 Total Revenues 177,000.00 3,096.97 0.00 173,903.03 1.75% Total Expenditures 177,000.00 5,760.00 5,881.49 165,358.51 6.58% Revenue Over(Under) Expenditures 0.00 (2,663.03)(5,881.49)8,544.52 Park, 317 Total Cash in Bank & Investments 288,006.63 Tree Mitigation, 319 Total Revenues 78,750.00 58,297.14 0.00 20,452.86 74.03% Total Expenditures 75,000.00 14,800.00 8,400.00 51,800.00 30.93% Revenue Over(Under) Expenditures 3,750.00 43,497.14 (8,400.00)(31,347.14) Tree Mitigation, 319 Total Cash in Bank & Investments 476,903.65 Capital Recovery Water, 411 Total Revenues 1,280,000.00 1,017,451.02 0.00 262,548.98 79.49% Total Expenditures 256,000.00 52,014.71 133,502.60 70,482.69 72.47% Revenue Over(Under) Expenditures 1,024,000.00 965,436.31 (133,502.60)192,066.29 Capital Recovery Water, 411 Total Cash in Bank & Investments 7,421,237.88 Quarterly Statement Schertz, Texas AS OF :JUNE 30, 2020 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2019 - 2020 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Capital Recovery Sewer, 421 Total Revenues 703,000.00 572,684.80 0.00 130,315.20 81.46% Total Expenditures 260,500.00 141,611.82 178,265.93 (59,377.75)122.79% Revenue Over(Under) Expenditures 442,500.00 431,072.98 (178,265.93)189,692.95 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 7,207,911.50 I&S, 505 Total Revenues 7,027,003.00 6,695,422.13 0.00 331,580.87 95.28% Total Expenditures 7,027,003.28 5,809,380.75 893,338.14 324,284.39 95.39% Revenue Over(Under) Expenditures (0.28)886,041.38 (893,338.14)7,296.48 I&S, 505 Total Cash in Bank & Investments 1,843,503.90 SED Corporation, 620 Total Revenues 7,952,931.00 3,823,434.95 0.00 4,129,496.05 48.08% Total Expenditures 7,952,931.00 1,254,443.35 4,294.69 6,694,192.96 15.83% Revenue Over(Under) Expenditures 0.00 2,568,991.60 (4,294.69)(2,564,696.91) SED Corporation, 620 Total Cash in Bank & Investments 23,531,729.74 Total Cash in Bank & Investments 78,341,148.22 Quarterly Statement Schertz, Texas AS OF :JUNE 30, 2020 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES REVENUE SUMMARY Taxes 23,448,050.00 2,624,452.05 20,082,342.94 21,204,141.73 - 2,243,908.27 90.43 Franchises 2,184,000.00 607,769.02 1,652,623.15 1,655,564.87 - 528,435.13 75.80 Permits 1,742,250.00 464,694.20 1,002,440.47 1,326,245.47 - 416,004.53 76.12 Licenses 56,860.00 10,700.00 50,972.05 39,487.00 - 17,373.00 69.45 Fees 2,390,134.00 431,138.36 1,773,477.48 1,579,558.15 - 810,575.85 66.09 Fines 12,000.00 310.33 10,845.12 5,963.60 (30.98) 6,067.38 49.44 Inter-Jurisdictional 977,436.00 163,628.98 638,585.56 609,115.87 - 368,320.13 62.32 Fund Transfers 8,124,257.00 791,395.24 2,163,155.44 2,143,365.76 - 5,980,891.24 26.38 Miscellaneous 907,250.00 300,436.37 799,777.84 809,367.20 - 97,882.80 89.21 TOTAL REVENUES 39,842,237.00 5,394,524.55 28,174,220.05 29,372,809.65 (30.98) 10,469,458.33 73.72% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 36,787.00 10,063.37 26,916.98 30,145.59 14.40 6,627.01 81.99 Supplies 650.00 60.35 618.45 372.65 19.95 257.40 60.40 City Support Services 53,204.96 619.21 24,488.07 37,262.11 392.16 15,550.69 70.77 Operations Support 300.00 - 178.40 174.12 38.15 87.73 70.76 Staff Support 28,600.00 (299.81) 17,699.11 23,409.71 5.00 5,185.29 81.87 Professional Services 8,000.00 1,975.00 5,850.00 1,975.00 - 6,025.00 24.69 Operating Equipment 2,000.00 - - - - 2,000.00 0.00 TOTAL CITY COUNCIL 129,541.96 12,418.12 75,751.01 93,339.18 469.66 35,733.12 72.42% CITY MANAGER Personnel Services 1,162,045.00 317,202.11 759,248.33 860,523.67 30.38 301,490.95 74.06 Supplies 2,000.00 759.00 1,411.29 1,370.08 24.20 605.72 69.71 City Support Services 6,000.00 41.91 - 3,809.16 - 2,190.84 63.49 Operations Support 50.00 - - - - 50.00 - Staff Support 24,775.00 (1,852.22) 8,413.76 6,095.69 498.79 18,180.52 26.62 TOTAL CITY MANAGER 1,194,870.00 316,150.80 770,858.22 871,798.60 553.37 322,518.03 73.01% MUNICIPAL COURT Personnel Services 260,823.00 69,294.86 218,135.70 203,087.09 13.50 57,722.41 77.87 Supplies 1,500.00 230.07 1,009.40 930.00 587.03 (17.03) 101.14 City Support Services 750.00 560.24 326.17 740.64 - 9.36 98.75 Operations Support 2,500.00 - 124.00 - - 2,500.00 0.00 Staff Support 7,110.00 549.00 4,426.10 1,901.51 525.23 4,683.26 34.13 Court Support 700.00 186.00 318.00 372.00 - 328.00 53.14 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2020 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 Professional Services 64,000.00 9,556.00 37,822.56 36,631.00 24,369.00 3,000.00 95.31 Maintenance Services 3,000.00 300.00 1,350.00 1,200.00 780.00 1,020.00 66.00 TOTAL MUNICIPAL COURT 340,383.00 80,676.17 263,511.93 244,862.24 26,274.76 69,246.00 79.66% CUSTOMER RELATIONS-311 Personnel Services 106,817.00 28,609.65 89,330.67 81,773.02 6.75 25,037.23 76.56 Supplies 100.00 - 69.41 74.72 - 25.28 74.72 Staff Support 830.00 82.78 123.94 800.21 (61.22) 91.01 89.03 TOTAL CUSTOMER RELATIONS-311 107,747.00 28,692.43 89,524.02 82,647.95 (54.47) 25,153.52 76.66% PLANNING & ZONING Personnel Services 210,713.00 50,192.76 148,204.53 129,274.25 10.13 81,428.62 61.36 Supplies 1,969.70 114.22 489.15 272.76 41.00 1,655.94 15.93 Utility Services 186.00 31.00 7.00 81.00 - 105.00 43.55 Operations Support 39,953.00 (5,959.00) 9,439.82 1,763.70 - 38,189.30 4.41 Staff Support 100.00 5.00 14.00 26.00 - 74.00 26.00 Professional Services 400.00 - 852.38 317.95 - 82.05 79.49 TOTAL PLANNING & ZONING 253,321.70 44,383.98 159,006.88 131,735.66 51.13 121,534.91 52.02% LEGAL SERVICES Operations Support 10,000.00 199.50 1,617.30 976.80 225.50 8,797.70 12.02 Professional Services 140,000.00 13,205.39 75,600.50 49,787.80 3,353.00 86,859.20 37.96 TOTAL LEGAL SERVICES 150,000.00 13,404.89 77,217.80 50,764.60 3,578.50 95,656.90 36.23% CITY SECRETARY Personnel Services 185,261.00 51,296.36 151,220.25 145,257.58 6.75 39,996.67 78.41 Supplies 1,150.00 119.97 1,056.19 588.77 - 561.23 51.20 City Support Services 9,500.00 2,118.04 2,973.03 5,401.99 - 4,098.01 56.86 Operations Support 150.00 - 27.95 - - 150.00 - Staff Support 5,000.00 851.90 4,029.32 3,888.37 - 1,111.63 77.77 Operating Equipment 400.00 - - - - 400.00 - TOTAL CITY SECRETARY 201,461.00 54,386.27 159,306.74 155,136.71 6.75 46,317.54 77.01% NON-DEPARTMENTAL City Support Services 903,712.13 60,314.03 377,951.50 428,493.67 57,681.13 417,537.33 53.80 Operations Support 156,000.00 22,879.67 97,691.89 92,562.56 - 63,437.44 59.33 Staff Support 200.00 - 73.20 - - 200.00 - City Assistance 1,974,583.00 655,784.86 1,297,887.61 1,309,227.26 569,424.80 95,930.94 95.14 Professional Services 47,235.00 11,521.74 35,575.71 38,803.46 276.00 8,155.54 82.73 Fund Chrgs/Transfrs-Spec Events Fnd 10,750.00 - - - - 10,750.00 - TOTAL NON-DEPARTMENTAL 3,092,480.13 750,500.30 1,809,179.91 1,869,086.95 627,381.93 596,011.25 80.73% PUBLIC AFFAIRS 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 Personnel Services 286,181.00 77,595.04 225,490.20 222,845.86 13.50 63,321.64 77.87 Supplies 700.00 16.96 472.45 400.94 36.79 262.27 62.53 City Support Services 1,000.00 - 610.14 990.49 - 9.51 99.05 Operations Support 46,974.50 10,848.47 12,300.67 19,917.50 300.81 26,756.19 43.04 Staff Support 11,268.50 (498.88) 6,393.04 2,283.45 1,030.92 7,954.13 29.41 Professional Services 250,500.00 50,213.20 238,426.42 172,239.21 6,870.84 71,389.95 71.50 TOTAL PUBLIC AFFAIRS 596,624.00 138,174.79 483,692.92 418,677.45 8,252.86 169,693.69 71.56% ENGINEERING Personnel Services 675,951.00 166,420.62 469,265.09 467,189.63 20.25 208,741.12 69.12 Supplies 2,650.00 36.00 632.10 551.50 - 2,098.50 20.81 Utility Services 3,839.00 2,090.94 3,520.59 4,691.42 - (852.42) 122.20 Operations Support 100.00 31.00 - 31.00 - 69.00 31.00 Staff Support 19,464.00 1,148.64 3,173.71 3,102.26 80.00 16,281.74 16.35 Professional Services 60,000.00 510.50 1,266.02 12,790.50 1,227.00 45,982.50 23.36 Operating Equipment 4,559.00 123.67 109.99 178.65 - 4,380.35 3.92 TOTAL ENGINEERING 767,011.00 170,361.37 477,967.50 488,534.96 1,775.25 276,700.79 63.92% GIS Personnel Services 168,874.00 45,703.56 129,087.15 132,348.21 6.75 36,519.04 78.37 Supplies 1,200.00 59.98 - 534.28 - 665.72 44.52 Professional Services 6,975.00 - 3,957.48 4,763.93 - 2,211.07 68.30 Rental/Leasing 3,000.00 912.54 1,562.85 2,337.88 608.36 53.76 98.21 TOTAL GIS 182,674.00 49,301.08 134,607.48 142,609.30 615.11 39,449.59 78.40% TOTAL GENERAL GOVERNMENT 7,016,113.79 1,658,450.20 4,500,624.41 4,549,193.60 668,904.85 1,798,015.34 7.62 PUBLIC SAFETY POLICE Personnel Services 7,604,381.00 1,850,151.37 5,161,191.26 5,573,834.12 263.25 2,030,283.63 73.30 Supplies 66,685.34 12,671.05 46,117.91 44,154.75 11,998.55 10,532.04 84.21 City Support Services 26,000.00 1,000.00 25,229.31 26,400.62 - (400.62) 101.54 Utility Services 171,728.75 22,984.77 60,585.51 62,645.53 - 109,083.22 36.48 Operations Support 18,086.00 1,093.00 4,321.00 4,586.00 215.00 13,285.00 26.55 Staff Support 121,636.73 6,239.56 94,925.86 56,410.57 11,583.26 53,642.90 55.90 City Assistance 21,100.00 2,150.82 7,364.33 6,194.63 32.84 14,872.53 29.51 Professional Services 73,993.00 20,504.43 54,827.80 39,128.49 2,775.00 32,089.51 56.63 Maintenance Services 72,403.00 23,122.00 30,385.00 40,472.73 - 31,930.27 55.90 Operating Equipment 311,427.55 14,601.34 370,134.97 168,619.46 15,638.41 127,169.68 59.17 Capital Outlay 547,015.00 - 199,596.75 221,828.83 297,927.75 27,258.42 95.02 TOTAL POLICE 9,079,000.37 1,954,518.34 6,054,679.70 6,288,819.73 340,434.06 2,449,746.58 73.02% 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 FIRE RESCUE Personnel Services 4,708,388.00 1,239,899.69 3,421,617.49 3,618,055.00 151.88 1,090,181.12 76.85 Supplies 23,992.22 5,211.28 11,977.92 10,834.07 417.97 12,740.18 46.90 Utility Services 76,600.00 16,142.98 34,971.24 53,867.19 1,535.41 21,197.40 72.33 Operations Support 1,150.00 - 236.09 334.93 - 815.07 29.12 Staff Support 195,887.10 31,841.68 114,351.25 142,515.55 13,538.98 39,832.57 79.67 City Assistance 24,000.00 6,281.55 6,716.68 14,207.56 3,993.00 5,799.44 75.84 Professional Services 68,000.00 8,500.00 33,465.00 38,011.00 22,275.00 7,714.00 88.66 Maintenance Services 63,900.00 15,219.53 32,740.50 25,413.88 10,274.88 28,211.24 55.85 Other Costs - 2,061.25 1,594.08 2,061.25 - (2,061.25) - Rental/Leasing 10,600.00 2,247.48 22,209.63 8,989.92 - 1,610.08 84.81 Operating Equipment 184,001.59 55,211.00 64,095.99 103,191.30 41,118.81 39,691.48 78.43 Capital Outlay 173,000.00 33,171.46 - 139,112.84 44,151.85 (10,264.69) 105.93 TOTAL FIRE RESCUE 5,529,518.91 1,415,787.90 3,743,975.87 4,156,594.49 137,457.78 1,235,466.64 77.66% INSPECTIONS Personnel Services 841,043.00 211,929.57 586,275.08 625,497.45 37.13 215,508.42 74.38 Supplies 5,378.00 514.14 2,055.96 1,149.17 99.16 4,129.67 23.21 Utility Services 9,720.00 1,113.54 4,074.32 3,150.77 - 6,569.23 32.42 Operations Support 2,400.00 - 946.60 - - 2,400.00 - Staff Support 41,261.00 76.21 14,798.88 10,229.50 225.00 30,806.50 25.34 Professional Services 70,000.00 2,050.00 55,645.00 9,625.00 49,375.00 11,000.00 84.29 Operating Equipment 600.00 - 1,879.54 - 553.28 46.72 92.21 Capital Outlay 29,000.00 - 52,087.30 - 27,381.00 1,619.00 94.42 TOTAL INSPECTIONS 999,402.00 215,683.46 717,762.68 649,651.89 77,670.57 272,079.54 72.78% TOTAL PUBLIC SAFETY 15,607,921.28 3,585,989.70 10,516,418.25 11,095,066.11 555,562.41 3,957,292.76 2.23 PUBLIC ENVIRONMENT STREETS Personnel Services 877,796.00 181,124.81 553,544.60 558,026.24 40.50 319,729.26 63.58 Supplies 116,650.00 17,221.94 59,631.49 81,135.48 11,359.96 24,154.56 79.29 City Support Services 2,500.00 80.07 - 1,228.53 - 1,271.47 49.14 Utility Services 175,000.00 48,356.69 124,119.45 121,450.37 - 53,549.63 69.40 Staff Support 18,620.00 1,588.20 13,471.69 12,173.22 738.12 5,708.66 69.34 Professional Services 11,000.00 9,765.30 6,345.00 9,765.30 - 1,234.70 88.78 Maintenance Services 331,869.00 13,700.00 646.36 82,490.50 59,761.46 189,617.04 42.86 Rental/Lease 6,000.00 - 2,650.00 1,900.00 - 4,100.00 31.67 Operating Equipment 1,700.00 516.05 39,786.54 516.05 684.98 498.97 70.65 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 Capital Outlay 342,125.00 - 156,397.74 - 337,748.20 4,376.80 98.72 TOTAL STREETS 1,883,260.00 272,353.06 956,592.87 868,685.69 410,333.22 604,241.09 67.92% TOTAL PUBLIC ENVIRONMENT 1,883,260.00 272,353.06 956,592.87 868,685.69 410,333.22 604,241.09 67.92% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 656,064.00 151,485.19 418,429.99 435,231.71 30.38 220,801.91 66.34 Supplies 96,271.00 23,813.37 50,563.88 49,020.48 14,413.27 32,837.25 65.89 City Support Services 114,500.00 3,311.30 11,572.06 41,640.84 11,098.66 61,760.50 46.06 Utility Services 244,500.00 46,581.86 159,352.80 143,821.60 - 100,678.40 58.82 Operations Support 1,105.00 105.68 1,514.39 105.68 - 999.32 9.56 Staff Support 19,670.00 2,111.09 13,801.47 11,755.18 162.57 7,752.25 60.59 Professional Services 137,500.00 44,304.46 80,675.54 76,766.38 - 60,733.62 55.83 Maintenance Services 102,378.00 3,102.11 6,875.23 15,182.08 23,891.75 63,304.17 38.17 Rental/Leasing 8,015.00 418.40 5,398.62 7,621.26 220.70 173.04 97.84 Operating Equipment 66,829.00 7,226.27 56,457.94 36,309.77 11,934.86 18,584.37 72.19 Capital Outlay 173,196.00 6,789.50 234,531.34 26,413.63 54,443.93 92,338.44 46.69 TOTAL PARKS DEPARTMENT 1,620,028.00 289,249.23 1,039,173.26 843,868.61 116,196.12 659,963.27 59.26% SWIM POOL Supplies 22,500.00 2,903.66 6,781.28 6,948.66 5,225.53 10,325.81 54.11 Utility Services 16,500.00 4,940.87 20,284.61 12,130.49 - 4,369.51 73.52 Maintenance Services 530,878.00 111,186.64 310,129.82 248,751.18 72,740.07 209,386.75 60.56 TOTAL SWIM POOL 569,878.00 119,031.17 337,195.71 267,830.33 77,965.60 224,082.07 60.68% EVENT FACILITIES Personnel Services 279,034.00 69,497.59 175,879.18 204,088.50 13.50 74,932.00 73.15 Supplies 5,981.50 445.20 1,963.51 2,963.38 57.10 2,961.02 50.50 Utility Services 46,650.00 6,647.32 24,042.72 21,008.44 - 25,641.56 45.03 Operations Support 12,358.00 - 9,178.42 1,332.36 - 11,025.64 10.78 Staff Support 5,493.50 318.00 2,173.37 2,691.20 40.00 2,762.30 49.72 Maintenance Services 13,000.00 - - 5,225.00 - 7,775.00 40.19 Operating Equipment 25,500.00 133.91 13,416.72 (4,221.40) 348.99 29,372.41 15.19 Capital Outlay 7,000.00 - - - - 7,000.00 - TOTAL EVENT FACILITIES 395,017.00 77,042.02 226,653.92 233,087.48 459.59 161,469.93 59.12% TOTAL PARKS & RECREATION 2,584,923.00 485,322.42 1,603,022.89 1,344,786.42 194,621.31 1,045,515.27 59.55% CULTURAL LIBRARY Personnel Services 782,955.00 210,092.69 578,730.34 610,646.90 30.38 172,277.72 78.00 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 Supplies 15,000.00 987.90 7,431.01 5,800.59 1,878.84 7,320.57 51.20 Utility Services 57,500.00 8,065.96 31,571.54 34,838.22 4,583.04 18,078.74 68.56 Operations Support 5,350.00 35.98 1,529.92 3,378.36 - 1,971.64 63.15 Staff Support 12,520.00 (957.98) 4,100.35 6,139.82 - 6,380.18 49.04 Professional Services 2,411.00 - 2,364.00 1,984.10 - 426.90 82.29 Operating Equipment 150,000.00 14,857.48 93,797.25 91,000.51 10,825.23 48,174.26 67.88 TOTAL LIBRARY 1,025,736.00 233,082.03 719,524.41 753,788.50 17,317.49 254,630.01 75.18% TOTAL CULTURAL 1,025,736.00 233,082.03 719,524.41 753,788.50 17,317.49 254,630.01 75.18% HEALTH ANIMAL SERVICES Personnel Services 407,558.00 92,390.20 236,679.74 264,514.77 20.25 143,022.98 64.91 Supplies 46,681.00 12,082.98 27,735.19 33,308.00 3,321.12 10,051.88 78.47 Utility Services 52,216.50 7,850.59 42,085.54 30,478.11 - 21,738.39 58.37 Operations Support 1,000.00 - 229.67 93.00 - 907.00 9.30 Staff Support 12,560.90 381.96 5,993.97 2,174.58 968.00 9,418.32 25.02 City Assistance 53,713.00 11,361.25 12,856.76 36,155.11 - 17,557.89 67.31 Professional Services 5,090.00 180.00 13,081.45 3,640.00 - 1,450.00 71.51 Maintenance Services 2,900.00 800.00 885.27 1,280.00 - 1,620.00 44.14 Operating Equipment 3,178.00 2,444.16 1,813.03 5,045.63 - (1,867.63) 158.77 Capital Outlay 114,928.00 24,330.00 - 133,163.72 - (18,235.72) 115.87 TOTAL ANIMAL SERVICES 699,825.40 151,821.14 341,360.62 509,852.92 4,309.37 185,663.11 73.47% TOTAL HEALTH 699,825.40 151,821.14 341,360.62 509,852.92 4,309.37 185,663.11 73.47% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 646,859.00 168,403.53 493,697.08 493,406.95 23.63 153,428.42 76.28 Supplies 6,300.00 306.90 4,201.52 2,287.63 638.97 3,373.40 46.45 City Support Services 936,861.00 281,012.40 470,292.76 468,564.03 57,176.48 411,120.49 56.12 Utility Services 283,246.00 74,707.16 139,464.93 158,053.07 18,688.42 106,504.51 62.40 Staff Support 52,520.00 187.28 35,130.03 21,947.42 2,311.38 28,261.20 46.19 Professional Services 190,424.00 41,448.28 45,955.00 41,510.78 3,875.50 145,037.72 23.83 Maintenance Services 15,500.00 1,279.35 8,343.79 2,668.12 456.00 12,375.88 20.16 Operating Equipment 283,257.11 16,173.20 263,305.26 95,234.62 32,108.70 155,913.79 44.96 Capital Outlay 55,570.00 - 5,367.00 - 27,162.33 28,407.67 48.88 TOTAL INFORMATION TECHNOLOGY 2,470,537.11 583,518.10 1,465,757.37 1,283,672.62 142,441.41 1,044,423.08 57.72% HUMAN RESOURCES Personnel Services 421,928.00 110,620.53 297,518.07 314,262.25 16.88 107,648.87 74.49 Supplies 4,146.00 51.73 551.57 1,091.49 - 3,054.51 26.33 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 Human Services 193,000.00 23,976.26 43,828.48 88,105.56 - 104,894.44 45.65 Operations Support 9,000.00 - 2,956.16 1,604.84 287.00 7,108.16 21.02 Staff Support 38,150.00 105.00 19,890.70 10,971.74 2,995.07 24,183.19 36.61 City Assistance 10,000.00 2,265.00 9,095.00 6,991.00 - 3,009.00 69.91 Professional Services 27,600.00 2,234.25 4,482.00 59,747.75 6,980.00 (39,127.75) 241.77 Operating Equipment 350.00 99.30 - 349.29 - 0.71 99.80 TOTAL HUMAN RESOURCES 704,174.00 139,352.07 378,321.98 483,123.92 10,278.95 210,771.13 70.07% FINANCE Personnel Services 559,958.00 153,809.46 411,404.12 439,767.02 27.00 120,163.98 78.54 Supplies 3,700.00 677.89 3,128.55 2,265.06 43.72 1,391.22 62.40 Staff Support 9,455.00 (724.50) 3,476.40 3,641.08 - 5,813.92 38.51 Professional Sevices 34,169.00 5,724.68 22,531.75 28,065.75 - 6,103.25 82.14 Operating Equipment 1,611.00 - 559.66 1,610.96 - 0.04 100.00 TOTAL FINANCE 608,893.00 159,487.53 441,100.48 475,349.87 70.72 133,472.41 78.08% PURCHASING & ASSET MGT Personnel Services 214,433.00 58,605.87 158,291.16 168,026.09 13.50 46,393.41 78.36 Supplies 700.00 86.92 1,278.70 160.42 48.97 490.61 29.91 Utility Services 280.00 - - - - 280.00 - Operations Support 7,615.00 480.00 5,065.50 3,670.96 - 3,944.04 48.21 Staff Support 5,585.00 - 3,018.83 1,322.82 241.32 4,020.86 28.01 City Assistance 3,000.00 181.00 1,578.00 651.00 160.00 2,189.00 27.03 Operating Equipment 1,570.00 - - - 1,431.37 138.63 91.17 TOTAL PURCHASING & ASSET MGT 233,183.00 59,353.79 169,232.19 173,831.29 1,895.16 57,456.55 75.36% FLEET SERVICE Personnel Services 461,299.00 93,453.05 198,929.78 258,943.83 20.25 202,334.92 56.14 Supplies 201,500.00 58,723.03 135,018.02 139,523.86 10,036.94 51,939.20 74.22 City Support Services 11,500.00 3,219.48 15,846.80 5,516.68 - 5,983.32 47.97 Utility Services 11,500.00 1,248.55 6,076.94 4,582.05 - 6,917.95 39.84 Staff Support 13,932.00 1,665.28 14,592.46 8,750.68 1,620.91 3,560.41 74.44 Maintenance Services 190,000.00 31,207.54 120,591.09 115,132.65 19,328.01 55,539.34 70.77 Operating Equipment 4,800.00 196.56 10,414.59 2,755.28 31.81 2,012.91 58.06 Capital Outlay 151,950.00 151,643.00 32,973.00 151,643.00 - 307.00 99.80 TOTAL FLEET SERVICE 1,046,481.00 341,356.49 534,442.68 686,848.03 31,037.92 328,595.05 68.60% FACILITY SERVICES Personnel Services 654,146.00 194,471.23 492,202.52 547,360.58 33.75 106,751.67 83.68 Supplies 70,054.00 14,494.92 70,704.25 43,278.08 4,501.54 22,274.38 68.20 City Support Services 200.00 99.99 - 99.99 - 100.01 50.00 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 Utility Services 171,000.00 37,060.65 104,934.47 117,377.18 727.18 52,895.64 69.07 Staff Support 9,500.00 2,486.14 4,535.24 5,578.13 331.50 3,590.37 62.21 Professional Services 92,000.00 21,620.43 50,703.75 60,562.98 27,792.44 3,644.58 96.04 Maintenance Services 584,297.00 103,732.33 258,538.21 264,554.65 25,519.75 294,222.60 49.65 Rental/Leasing 500.00 - 400.00 80.38 - 419.62 16.08 Operating Equipment 1,500.00 - 3,988.00 149.75 750.00 600.25 59.98 Capital Outlay 25,000.00 - 10,426.05 5,758.00 26,693.50 (7,451.50) 129.81 TOTAL BUILDING MAINTENANCE 1,608,197.00 373,965.69 996,432.49 1,044,799.72 86,349.66 477,047.62 70.34% TOTAL INTERNAL SERVICE 6,671,465.11 1,657,033.67 3,985,287.19 4,147,625.45 272,073.82 2,251,765.84 66.25% MISC & PROJECTS Project Fund Charges/Transfers 4,000,000.00 - - - - 4,000,000.00 - TOTAL PROJECTS 4,000,000.00 - - - - 4,000,000.00 - CITY ASSISTANCE City's Assistance to Agencies 320,000.00 72,568.08 219,356.13 221,767.46 35,339.34 62,893.20 80.35 Operating Equipment 10,000.00 - 11,315.88 4,321.57 - 5,678.43 43.22 TOTAL CITY ASSISTANCE 330,000.00 72,568.08 230,672.01 226,089.03 35,339.34 68,571.63 79.22% COURT - RESTRICTED FUNDS Operating Equipment 22,992.00 - - - 2,500.00 20,492.00 10.87 TOTAL COURT-RESTRICTED FUNDS 22,992.00 - - - 2,500.00 20,492.00 10.87% TOTAL MISC & PROJECTS 4,352,992.00 72,568.08 230,672.01 226,089.03 37,839.34 4,089,063.63 6.06% TOTAL EXPENDITURES 39,842,236.58 8,116,620.30 22,853,502.65 23,495,087.72 2,160,961.81 14,186,187.05 64.39% REVENUE OVER(UNDER) EXPEND.0.42 (2,722,095.75) 5,320,717.40 5,877,721.93 (2,160,992.79) (3,716,728.72) 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Taxes 000-411100 Advalorem Tax-Current 14,060,000.00 216,563.65 13,383,401.05 13,956,865.64 - 103,134.36 99.27 000-411110 Disable Veterans Assist Pymnt 300,000.00 - 201,117.19 - - 300,000.00 - 000-411200 Advalorem Tax-Delinquent 50,000.00 19,680.79 47,800.61 34,363.39 - 15,636.61 68.73 000-411300 Advalorem Tax-P&I 50,000.00 34,929.40 53,587.17 56,838.84 - (6,838.84) 113.68 000-411500 Sales Tax Revenue-Gen Fund 8,944,000.00 2,333,107.56 6,356,555.40 7,093,626.37 - 1,850,373.63 79.31 000-411600 Bingo Tax 50.00 - 24.30 28.16 - 21.84 56.32 000-411700 Mixed Beverage Tax 44,000.00 20,170.65 39,857.22 62,419.33 - (18,419.33) 141.86 TOTAL Taxes 23,448,050.00 2,624,452.05 20,082,342.94 21,204,141.73 - 2,243,908.27 90.43% Franchises 000-421200 Center Point/Entex Energy 90,000.00 17,766.09 77,865.61 77,463.07 - 12,536.93 86.07 000-421220 City Public Service 1,020,000.00 261,393.98 691,053.50 681,843.40 - 338,156.60 66.85 000-421240 Guadalupe Valley Elec Co-op 455,000.00 99,743.10 298,628.75 298,299.80 - 156,700.20 65.56 000-421250 New Braunfels Utilities 78,000.00 20,035.00 45,612.75 47,911.95 - 30,088.05 61.43 000-421300 Time Warner-State Franchise 180,000.00 90,023.37 233,058.73 206,151.65 - (26,151.65) 114.53 000-421460 AT&T Franchise Fee 75,000.00 47,398.83 97,249.84 128,347.49 - (53,347.49) 171.13 000-421480 Other Telecom Franchise - ROW 130,000.00 31,640.87 92,698.75 95,339.44 - 34,660.56 73.34 000-421500 Solid Waste Franchise Fee 156,000.00 39,767.78 116,455.22 120,208.07 - 35,791.93 77.06 TOTAL Franchises 2,184,000.00 607,769.02 1,652,623.15 1,655,564.87 - 528,435.13 75.80% Permits 000-431100 Home Occupation Permit 500.00 140.00 490.00 525.00 - (25.00) 105.00 000-431205 Bldg Permit-Residential 550,000.00 191,957.00 338,844.00 462,542.50 - 87,457.50 84.10 000-431210 Bldg Permit-Commercial 350,000.00 20,541.00 64,500.00 164,318.00 - 185,682.00 46.95 000-431215 Bldg Permit-General 350,000.00 77,455.50 251,797.00 255,824.50 - 94,175.50 73.09 000-431300 Mobile Home Permit 400.00 25.00 625.00 300.00 - 100.00 75.00 000-431400 Signs Permit 5,600.00 892.00 6,319.00 3,647.00 - 1,953.00 65.13 000-431500 Food Establishmnt Permit 63,000.00 750.00 59,735.00 63,270.00 - (270.00) 100.43 000-431700 Plumbing Permit 138,950.00 37,532.00 89,659.00 97,919.00 - 41,031.00 70.47 000-431750 Electrical Permit 70,900.00 19,440.00 50,280.00 48,100.00 - 22,800.00 67.84 000-431800 Mechanical Permit 68,300.00 21,680.00 44,880.00 51,640.00 - 16,660.00 75.61 000-431900 Solicitor/Peddler Permit 2,300.00 - 6,030.00 866.00 - 1,434.00 37.65 000-431950 Animal/Pet Permit 500.00 - - 15.00 - 485.00 3.00 000-432000 Cert of Occupancy Prmt 6,300.00 1,200.00 6,050.00 6,100.00 - 200.00 96.83 000-432100 Security Alarm Permit 43,000.00 10,945.00 33,896.00 29,906.00 - 13,094.00 69.55 000-432300 Grading/Clearing Permit 12,500.00 1,450.00 11,138.13 6,914.18 - 5,585.82 55.31 000-432400 Development Permit 50,000.00 74,109.70 16,494.84 105,468.79 - (55,468.79) 210.94 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2020 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 000-435000 Fire Permit 30,000.00 6,577.00 21,702.50 28,889.50 - 1,110.50 96.30 TOTAL Permits 1,742,250.00 464,694.20 1,002,440.47 1,326,245.47 - 416,004.53 76.12% Licenses 000-441000 Alcohol Beverage License 8,100.00 1,960.00 5,590.00 5,470.00 - 2,630.00 67.53 000-441300 Mobile Home License 160.00 - 80.00 120.00 - 40.00 75.00 000-442000 Contractors License 45,600.00 8,740.00 43,250.00 32,940.00 - 12,660.00 72.24 000-444000 Pet License 3,000.00 - 2,052.05 957.00 - 2,043.00 31.90 TOTAL Licenses 56,860.00 10,700.00 50,972.05 39,487.00 - 17,373.00 69.45% Fees 000-451000 Municipal Court Fines 664,160.00 134,867.37 521,861.53 467,039.01 - 197,120.99 70.32 000-451100 Arrest Fee 25,680.00 4,089.92 19,506.42 15,847.84 - 9,832.16 61.71 000-451110 Expunction Fee 160.00 - - 100.00 - 60.00 62.50 000-451200 Warrant Fees 73,560.00 15,634.45 56,539.38 52,317.90 - 21,242.10 71.12 000-451220 Officer Jury Fee - - - 91.20 - (91.20) 0.00 000-451340 Judicial Fee-City 3,432.00 177.41 2,603.70 1,378.71 - 2,053.29 40.17 000-451400 Traffic Fine Costs TTL 12,168.00 1,903.47 9,188.61 7,241.93 - 4,926.07 59.52 000-451510 Juvenile Case Mgmt Fee 28,668.00 1,488.55 21,727.66 11,494.49 - 17,173.51 40.10 000-451520 Truancy Fees 5,352.00 3,433.59 4,038.57 8,571.32 - (3,219.32) 160.15 000-451530 Local Municipal Jury Fund - 63.96 - 129.91 - (129.91) 0.00 000-451600 Technology Fund Fee 22,992.00 3,796.72 17,361.82 14,525.71 - 8,466.29 63.18 000-451700 Security Fee 17,244.00 4,063.57 13,021.38 13,364.66 - 3,879.34 77.50 000-451800 Time Payment Fee-City 4,968.00 800.68 3,892.55 3,194.75 - 1,773.25 64.31 000-451850 State Fines 10% Service Fee 38,752.00 9,285.12 27,394.30 25,866.44 - 12,885.56 66.75 000-451900 DPS Payment-Local 5,592.00 1,141.69 4,338.95 3,863.40 - 1,728.60 69.09 000-452000 Child Safety Fee 10,356.00 409.10 7,491.38 5,235.42 - 5,120.58 50.55 000-452100 Platting Fees 59,000.00 15,500.00 37,500.00 22,250.00 - 36,750.00 37.71 000-452200 Site Plan Fee 36,000.00 3,000.00 25,500.00 6,000.00 - 30,000.00 16.67 000-452300 Plan Check Fee 625,000.00 138,261.75 344,984.93 418,741.75 - 206,258.25 67.00 000-452320 Tree Mitigation Admin Fee 15,000.00 - 937.50 10,707.30 - 4,292.70 71.38 000-452400 BOA/Variance Fees 5,000.00 1,000.00 2,750.00 1,000.00 - 4,000.00 20.00 000-452600 Specific Use/Zone Chng Fee 18,000.00 6,090.00 18,800.00 21,089.80 - (3,089.80) 117.17 000-452710 Zoning Ltr & Dev Rights 1,950.00 150.00 3,000.00 2,400.00 - (450.00) 123.08 000-453100 Reinspection Fees 170,000.00 50,400.50 170,090.00 149,275.50 - 20,724.50 87.81 000-453110 Swim Pool Inspection Fee 2,500.00 1,430.00 1,320.00 2,090.00 - 410.00 83.60 000-453200 Lot Abatement 5,000.00 - 750.00 6,028.54 - (1,028.54) 120.57 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 000-453211 Admin Fee-Inspections 18,600.00 3,200.00 9,300.00 9,200.00 - 9,400.00 49.46 000-453310 Misc Inspection Fees - 200.00 400.00 300.00 - (300.00) 0.00 000-453710 Foster Care 500.00 150.00 350.00 350.00 - 150.00 70.00 000-454200 Pool Gate Admission Fee 24,000.00 4,705.00 8,130.25 4,735.00 - 19,265.00 19.73 000-454300 Seasonal Pool Pass Fee 5,000.00 1,290.00 3,750.00 1,290.00 - 3,710.00 25.80 000-456120 Senior Center Meal Fee - 4,621.53 401.00 11,126.51 - (11,126.51) 0.00 000-456500 HAZ MAT Fees 5,000.00 - 1,041.25 - - 5,000.00 0.00 000-456600 Fire Re-inspection Fee 1,000.00 150.00 350.00 400.00 - 600.00 40.00 000-458000 Sale of General Fixed Assets 20,000.00 - - - - 20,000.00 0.00 000-458100 Sale of Merchandise - - 2,071.39 360.00 - (360.00) 0.00 000-458110 Sale of Mdse - GovDeals 80,000.00 1,133.56 100,155.24 26,366.20 - 53,633.80 32.96 000-458400 Civic Center Rental Fees 200,000.00 275.00 178,637.87 6,125.00 - 193,875.00 3.06 000-458401 Capital Recovery Fee-Civic C 7,500.00 100.00 12,515.00 11,700.00 - (4,200.00) 156.00 000-458402 Civic Center Ancillary Fees - (265.00) - 200.00 - (200.00) 0.00 000-458450 North Center Rental Fees 23,000.00 (4,100.00) 19,864.50 11,625.00 - 11,375.00 50.54 000-458460 Senior Center Rental 7,000.00 - 5,600.00 3,500.00 - 3,500.00 50.00 000-458500 Community Center Rental Fees 35,000.00 1,818.75 32,291.00 15,088.25 - 19,911.75 43.11 000-458501 Community Center Service Fees - 150.00 - 500.00 - (500.00) 0.00 000-458510 Grand Ballroom Rental Fees - 9,287.50 2,500.00 90,911.25 - (90,911.25) 0.00 000-458520 Cut-Off Hall Rental Fees - 1,225.00 - 12,161.25 - (12,161.25) 0.00 000-458530 Conference Hall Rental Fees - - - 1,787.50 - (1,787.50) 0.00 000-458540 Bluebonnet Hall Rental Fees - (3,165.00) 75.00 23,611.25 - (23,611.25) 0.00 000-458550 Pavilion Rental Fees 20,000.00 (1,305.00) 15,076.50 4,300.00 - 15,700.00 21.50 000-458560 Chamber of Comm Rent 7,500.00 1,950.00 5,850.00 5,850.00 - 1,650.00 78.00 000-458570 Non-Resident SYSA League 10,000.00 - 19,170.00 8,590.00 - 1,410.00 85.90 000-458580 HOA Meeting Rental Fees - 150.00 - 1,050.00 - (1,050.00) 0.00 000-458581 Funeral Reception Rental Fees - 150.00 - 600.00 - (600.00) 0.00 000-458582 Quality of Life Rental Fees - 135.00 - 4,380.00 - (4,380.00) 0.00 000-458590 Cancellation Fees-Event Rental - 700.00 - 5,795.00 - (5,795.00) 0.00 000-458650 NonResident User Fee-BVYA 10,000.00 6.00 3,240.00 6.00 - 9,994.00 0.06 000-458660 BVYA Utility Reimbursement 15,000.00 - 7,165.84 - - 15,000.00 0.00 000-458670 SYSA Utility Reimbursement 7,500.00 - 1,923.89 4,493.68 - 3,006.32 59.92 000-458675 Lions Futbol Utility Reimbrsmt 10,000.00 - 7,032.00 12,582.00 - (2,582.00) 125.82 000-458685.001Rec Prgrm-Kickball Leagues - 744.00 - 744.00 - (744.00) 0.00 000-458700 Vehicle Impoundment 10,000.00 2,770.00 4,720.00 8,520.00 - 1,480.00 85.20 000-459200 NSF Check Fee 100.00 - 100.00 125.00 - (25.00) 125.00 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 000-459300 Notary Fee 100.00 6.00 42.00 30.00 - 70.00 30.00 000-459400 Maps,Copies,UDC & Misc Fees - - 30.00 5.00 - (5.00) 0.00 000-459600 Animal Adoption Fee 12,000.00 2,880.00 9,140.12 10,570.00 - 1,430.00 88.08 000-459700 Pet Impoundment Fee 5,000.00 3,946.17 3,933.34 8,276.38 - (3,276.38) 165.53 000-459800 Police Reports Fee 5,800.00 1,242.00 4,237.50 2,458.30 - 3,341.70 42.38 TOTAL Fees 2,390,134.00 431,138.36 1,773,477.48 1,579,558.15 - 810,575.85 66.09% Fines 000-463000 Library Fines 12,000.00 310.33 10,845.12 5,963.60 (30.98) 6,067.38 49.44 TOTAL Fines 12,000.00 310.33 10,845.12 5,963.60 (30.98) 6,067.38 49.44% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,077.00 21,077.76 5,269.44 21,077.76 - (0.76) 100.00 000-473200 City of Seguin-Fire Contract 30,107.00 10,035.92 22,580.82 22,580.82 - 7,526.18 75.00 000-473300 Guadalupe Co-Library 217,152.00 72,384.00 162,864.00 180,960.00 - 36,192.00 83.33 000-473400 Randolph AFB-Animal Control 500.00 - - - - 500.00 0.00 000-474200 Library Services-Cibolo 40,000.00 - - 40,030.00 - (30.00) 100.08 000-474210 Library Services-Selma 24,000.00 - 23,475.00 26,505.00 - (2,505.00) 110.44 000-474400 Dispatch Service-Cibolo 166,000.00 40,000.00 80,000.00 120,000.00 - 46,000.00 72.29 000-474600 School Crossing Guard-Bexar Co 36,000.00 9,647.50 30,477.82 28,549.76 - 7,450.24 79.30 000-474610 School Cross Guard-Guadalupe C 39,000.00 10,483.80 27,918.48 31,012.53 - 7,987.47 79.52 000-474700 School Officer Funding 353,600.00 - 261,000.00 88,400.00 - 265,200.00 25.00 TOTAL Inter-Jurisdictional 977,436.00 163,628.98 638,585.56 609,115.87 - 368,320.13 62.32% Fund Transfers 000-480000 Indirect Costs-EMS 179,100.00 44,775.00 131,690.25 134,325.00 - 44,775.00 75.00 000-480100 Indirect Costs-Hotel/Motel 74,428.00 18,606.99 50,686.51 55,821.01 - 18,606.99 75.00 000-481000 Transfer In - Reserves 4,995,915.00 - - - - 4,995,915.00 0.00 000-482200 Transfer In-Vehicle Replace 250,025.00 - - - - 250,025.00 0.00 000-482300 Transfer In-Resrv Child Safety 60,000.00 - - - - 60,000.00 0.00 000-485000 Interfund Charges-Drainage-5%243,114.00 60,778.50 221,367.74 182,333.50 - 60,780.50 75.00 000-486000 Interfund Chrges-Admin W&S 1,404,372.00 346,250.01 1,024,498.49 1,038,749.99 - 365,622.01 73.97 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 361,258.00 90,166.74 278,282.45 270,500.26 - 90,757.74 74.88 000-488000 Interfund Charges-4B 461,045.00 230,818.00 456,630.00 461,636.00 - (591.00) 100.13 000-489000 Transfer In 86,000.00 - - - - 86,000.00 0.00 TOTAL Fund Transfers 8,124,257.00 791,395.24 2,163,155.44 2,143,365.76 - 5,980,891.24 26.38% 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 Miscellaneous 000-491000 Interest Earned 80,000.00 1,142.66 56,715.91 24,580.31 - 55,419.69 30.73 000-491200 Investment Income 400,000.00 51,055.39 311,895.97 228,709.04 - 171,290.96 57.18 000-491900 Unrealized Gain/Loss-CapOne - (4,010.71) 19,984.70 29,570.36 - (29,570.36) 0.00 000-493000 Donations-Others - 100.00 50.00 100.00 - (100.00) 0.00 000-493120 Donations-Public Library 10,000.00 1,100.00 7,658.32 2,162.75 - 7,837.25 21.63 000-493400 Donations-Animal Control 5,000.00 900.00 2,709.75 3,778.00 - 1,222.00 75.56 000-493401 Donations-A/C Microchip - 225.00 90.00 915.00 - (915.00) 0.00 000-493460 Donations- Parks 10,000.00 500.00 3,160.51 500.00 - 9,500.00 5.00 000-493465 Donations-Senior Center 10,000.00 532.00 8,886.70 5,908.37 - 4,091.63 59.08 000-493502 Donations-PD - 100.00 930.00 200.00 - (200.00) 0.00 000-493503 Donation-Fire Rescue - - 1,600.00 2,150.00 - (2,150.00) 0.00 000-493505 Donations-Police Events 3,000.00 - - - - 3,000.00 0.00 000-493618 Donation - Veteran's Memorial - 225.00 - 375.00 - (375.00) 0.00 000-493700 July 4th Activities 26,000.00 235.00 - 235.00 - 25,765.00 0.90 000-493701 Proceeds-Holidazzle 1,500.00 12,320.00 - 12,320.00 - (10,820.00) 821.33 000-493704 Moving on Main 3,000.00 - - 100.00 - 2,900.00 3.33 000-494481 LawEnforcemtOfficersStnd&- - 4,341.18 5,081.86 - (5,081.86) 0.00 000-494482 Grants-Police, Fire, Gen Fund 2,500.00 - - - - 2,500.00 0.00 000-495100 Mobile Stage Rental Fees 2,100.00 - 2,050.00 1,550.00 - 550.00 73.81 000-497000 Misc Income-Gen Fund 25,000.00 175,778.82 34,404.36 210,742.93 - (185,742.93) 842.97 000-497005 Schertz Magazine Advertising 140,000.00 32,375.00 110,325.00 98,925.00 - 41,075.00 70.66 000-497100 Misc Income-Police 9,000.00 787.37 7,442.90 7,187.73 - 1,812.27 79.86 000-497106 Misc Income-Special Events 14,150.00 - - - - 14,150.00 0.00 000-497200 Misc Income-Library 4,500.00 6.00 3,617.10 2,233.20 - 2,266.80 49.63 000-497210 Misc Income-Library Copier 18,000.00 50.10 15,670.85 9,473.90 - 8,526.10 52.63 000-497400 Misc Income-Streets Dept 30,000.00 6,734.51 18,644.25 13,767.80 - 16,232.20 45.89 000-497460 Misc Income-Parks - 84.00 139.80 84.00 - (84.00) 0.00 000-497500 Misc Income-TML Ins. Claims 20,000.00 7,891.70 17,217.74 22,007.51 - (2,007.51) 110.04 000-497550 Misc Income-TML WC Reimbursmnt 10,000.00 - 1,530.65 4,886.86 - 5,113.14 48.87 000-497600 Misc Income-Vending Mach 2,500.00 144.06 2,130.82 1,003.44 - 1,496.56 40.14 000-497610 Misc Income-Muni Court - - 154.20 0.02 - (0.02) 0.00 000-498000 Reimbursmnt-Gen Fund 20,000.00 - - 15,443.00 - 4,557.00 77.22 000-498105 Reimbursmt Police OT-DEA 18,000.00 12,160.47 12,794.70 19,333.73 - (1,333.73) 107.41 000-498110 Reimburmnt Fire-Emg Acti-OT 30,000.00 - 152,156.41 72,533.39 - (42,533.39) 241.78 000-498150 Reimbursement - Library 13,000.00 - 13,018.19 13,509.00 - (509.00) 103.92 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 TOTAL Miscellaneous 907,250.00 300,436.37 799,777.84 809,367.20 - 97,882.80 89.21% TOTAL REVENUES 39,842,237.00 5,394,524.55 28,174,220.05 29,372,809.65 (30.98) 10,469,458.33 73.72% Cash in Bank Claim on Operating Cash Pool-Checking 916,836.65$ Cash in Investments LOGIC Investment-General Fund 17,134,964.29 LOGIC Investment-Equip Replacement 78,963.90 LOGIC Investment-Veh Replacement 532,435.46 LOGIC Investment-Air Condi Replacment 289,755.56 LOGIC Investment-Public Library Bldg Donation - BBVA CD Investment 1,042,371.85 SB&T 12 Month Certificate of Deposit Investment Account - CHASE CAPITAL ONE Investment-General Fund 1,464,692.07 Total Cash in Bank & Investments 21,460,019.78$ GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: June 30, 2020 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 2019-20 669,061 809,661 729,135 656,810 908,377 953,913 662,240 840,330 708,822 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 2015-16 479,069 744,668 529,686 493,136 783,019 530,498 531,707 615,841 568,508 523,141 691,061 678,167 - 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 2019-20 181,122 806,033 6,755,473 72,046 56,463 88,055 72,046.00 56,462.50 88,055.15 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 2015-16 360,300 303,202 4,754,503 3,709,486 888,174 211,253 50,559 54,867 27,116 21,347 10,866 8,696 - 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 2019-20 OCT 240,156 192,246 261,394 2018-19 OCT 270,225 203,885 199,326 263,032.10 2017-18 OCT 271,335 208,803 213,511 283,058 2016-17 OCT 252,947 191,140 213,951 259,517 2015-16 OCT 237,314 183,530 173,336 178,081 - 50,000 100,000 150,000 200,000 250,000 300,000 CITY PUBLIC SERVICE 2019-20 OCT 2018-19 OCT 2017-18 OCT 2016-17 OCT 2015-16 OCT 106-SPECIAL EVENTS FUND CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fund Transfers 5,000.00 - - - - 5,000.00 - Miscellaneous 24,510.00 (6,328.24) 81,609.55 45,116.53 - (20,606.53) 184.07 TOTAL REVENUES 29,510.00 (6,328.24) 81,609.55 45,116.53 - (15,606.53) 152.89% EXPENDITURE SUMMARY GENERAL GOVERNMENT CULTURAL WALK FOR LIFE 9,000.00 740.57 9,365.50 5,121.38 4,691.47 (812.85) 109.03 HAL BALDWIN SCHOLARSHIP 20,510.00 21.20 11,455.93 11,866.50 - 8,643.50 57.86 TOTAL CULTURAL 29,510.00 761.77 84,981.03 16,998.68 5,553.48 6,957.84 76.42% TOTAL EXPENDITURES 29,510.00 761.77 84,981.03 16,998.68 5,553.48 6,957.84 76.42% REVENUE OVER(UNDER) EXPEND 0.00 (7,090.01) (3,371.48) 28,117.85 (5,553.48) (22,564.37) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2020 106-SPECIAL EVENTS FUND CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fund Transfers 000-481000 Transfer In - Reserves 5,000.00 - - - - 5,000.00 0.00 TOTAL Fund Transfers 5,000.00 - - - - 5,000.00 0.00% Miscellaneous 000-492200 Kick Cancer 9,000.00 3,955.27 9,305.50 9,537.79 - (537.79) 105.98 000-493621 Hal Baldwin Scholarship 15,510.00 - 28,820.00 24,350.00 - (8,840.00) 157.00 TOTAL Miscellaneous 24,510.00 (6,328.24) 81,609.55 45,116.53 - (20,606.53) 184.07% TOTAL REVENUES 29,510.00 (6,328.24) 81,609.55 45,116.53 - (15,606.53) 152.89% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2020 Cash in Bank Current Claim on Operating Cash Pool-Checking 118,649.45$ Cash in Investments Texas Class- Special Events 18,014.92 Total Cash in Bank & Investments 136,664.37$ SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2020 110-PEG FUND CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Franchises 90,000.00 16,111.29 65,067.98 60,605.89 - 29,394.11 67.34 Fund Transfers 28,000.00 - - - - 28,000.00 - TOTAL REVENUES 118,000.00 16,111.29 65,067.98 60,605.89 - 57,394.11 51.36% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental MISC & PROJECTS Projects Professional Services 75,000.00 - - - - 75,000.00 - Capital Outlay 43,000.00 - 3,258.50 - - 43,000.00 - TOTAL MISC & PROJECTS 118,000.00 - 3,258.50 - - 118,000.00 0.00% TOTAL EXPENDITURES 118,000.00 - 3,258.50 - - 118,000.00 0.00% REVENUE OVER(UNDER) EXPEND 0.00 16,111.29 61,809.48 60,605.89 - (60,605.89) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30rd, 2020 110-PEG FUND CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Franchises 000-421350 Time Warner - PEG Fee 60,000.00 16,111.29 45,952.85 47,678.13 - 12,321.87 79.46 000-421465 AT&T PEG Fee 30,000.00 - 19,115.13 12,927.76 - 17,072.24 43.09 TOTAL Franchises 90,000.00 16,111.29 65,067.98 60,605.89 - 29,394.11 67.34% Fund Transfers 000-481000 Transfer In - Reserves 28,000.00 - - - - 28,000.00 0.00 TOTAL Fund Transfers 28,000.00 - - - - 28,000.00 0.00% Miscellaneous TOTAL REVENUES 118,000.00 16,111.29 65,067.98 60,605.89 - 57,394.11 51.36% AS OF: JUNE 30rd, 2020 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) Cash in Bank Cash Balance 846,314.38$ Cash in Investment Pools MBIA Special Events - Total Cash in Bank & Investments 846,314.38$ PEG FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30rd, 2020 202-WATER & SEWER CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Franchises 227,380.00 87,449.10 221,552.58 261,991.81 - (34,611.81) 115.22 Fees 24,575,500.00 6,460,125.14 16,897,492.45 18,656,812.95 - 5,918,687.05 75.92 Fund Transfers 4,271,255.00 36,600.00 313,052.27 109,800.00 - 4,161,455.00 2.57 Miscellaneous 465,218.00 86,654.35 386,614.42 310,442.17 - 154,775.83 66.73 TOTAL REVENUES 29,539,353.00 6,670,828.59 17,818,711.72 19,342,046.93 - 10,197,306.07 65.48% EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers 3,250,000.00 - 125,000.00 - - 3,250,000.00 - TOTAL NON DEPARTMENTAL 3,250,000.00 - 125,000.00 - - 3,250,000.00 0.00% BUSINESS OFFICE Personnel Services 479,478.00 128,979.70 328,506.35 365,020.85 30.38 114,426.77 76.14 Supplies 3,800.00 1,005.71 1,470.95 2,350.69 - 1,449.31 61.86 City Support Services 4,501.00 14,260.00 250.00 42,900.26 - (38,399.26) 953.13 Utility Services 11,345.00 2,453.48 2,750.17 6,720.94 148.02 4,476.04 60.55 Operations Support 158,500.00 23,915.73 95,062.65 67,248.13 6,541.90 84,709.97 46.56 Staff Support 6,759.00 717.52 3,378.64 3,235.83 791.06 2,732.11 59.58 Professional Services 243,000.00 68,538.34 156,449.15 169,982.34 - 73,017.66 69.95 Maintenance Services 8,040.00 840.00 5,280.00 3,360.00 2,100.00 2,580.00 67.91 Operating Equipment 600.00 - 359.97 430.40 - 169.60 71.73 Capital Outlay 30,000.00 - - 19,804.50 27,381.00 (17,185.50) 157.29 TOTAL BUSINESS OFFICE 946,023.00 240,710.48 593,507.88 681,053.94 36,992.36 227,976.70 75.90% W & S ADMINISTRATION Personnel Services 1,467,365.00 438,976.98 990,839.78 1,250,338.30 77.63 216,949.07 85.22 Supplies 187,500.00 4,244.15 131,177.66 156,727.25 7,061.73 23,711.02 87.35 City Support Services 159,603.00 238.12 51,713.57 62,356.26 - 97,246.74 39.07 Utility Services 3,575,800.00 875,078.82 2,245,076.78 2,534,756.05 113.58 1,040,930.37 70.89 Operations Support 11,300.00 1,163.06 6,789.25 8,377.27 - 2,922.73 74.14 Staff Support 38,000.00 4,287.44 22,470.83 31,780.83 817.52 5,401.65 85.79 City Assistance 1,500.00 - 35.00 76.00 81.00 1,343.00 10.47 Professional Services 406,179.00 96,179.53 285,785.77 324,387.84 17,053.15 64,738.01 84.06 Fund Charges/Transfers 6,355,471.00 1,466,379.36 4,931,391.06 4,989,256.72 - 1,366,214.28 78.50 Maintenance Services 9,200,490.00 1,635,303.25 5,480,789.67 5,247,721.77 764,828.25 3,187,939.98 65.35 Other Costs 40,000.00 - 38,435.72 36,605.45 - 3,394.55 91.51 Debt Service 2,100,622.00 - 267,516.90 1,551,501.10 268,387.50 280,733.40 86.64 Rental/Leasing 4,500.00 52,000.00 (51,106.56) 106,952.44 10,400.00 (112,852.44) 2,607.83 Operating Equipment 8,000.00 6,099.72 1,597.41 8,610.73 249.55 (860.28) 110.75 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2020 202-WATER & SEWER CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 Capital Outlay 149,000.00 - 688,421.03 34,513.60 48,887.00 65,599.40 55.97 TOTAL PUBLIC WORKS 23,705,330.00 4,579,950.43 15,090,933.87 16,343,961.61 1,117,956.91 6,243,411.48 73.66% MISC & PROJECTS PROJECTS Maintenance Services 1,638,000.00 122,784.14 164,131.18 122,784.14 1,441,811.74 73,404.12 95.52 TOTAL PROJECTS 1,638,000.00 123,826.64 178,467.43 139,506.64 1,457,738.24 40,755.12 97.51% SEWER PROJECT TOTAL MISC & PROJECTS 1,638,000.00 123,826.64 178,467.43 139,506.64 1,457,738.24 40,755.12 97.51% TOTAL EXPENDITURES 29,539,353.00 4,944,487.55 15,987,909.18 17,164,522.19 2,612,687.51 9,762,143.30 66.95% ** REVENUE OVER(UNDER)EXPENSES **0.00 1,726,341.04 1,830,802.54 2,177,524.74 (2,612,687.51) 435,162.77 202-WATER & SEWER CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Franchises 000-421490 Cell Tower Leasing 227,380.00 87,449.10 221,552.58 261,991.81 - (34,611.81) 115.22 TOTAL Franchises 227,380.00 87,449.10 221,552.58 261,991.81 - (34,611.81) 115.22% Permits 000-432400 Development Permit - - - - - 0.00% Fees 000-455200 Garbage Collection Fee 5,280,000.00 1,282,259.84 3,771,210.08 3,869,478.66 - 1,410,521.34 73.29 000-455600 Fire Line Fees 33,000.00 - 33,160.00 - - 33,000.00 - 000-455700 Recycle Fee Revenue 336,000.00 82,991.71 245,432.05 247,345.15 - 88,654.85 73.61 000-455800 W&S Line Constructn Reimbur 20,000.00 8,458.00 14,999.00 21,427.02 - (1,427.02) 107.14 000-457100 Sale of Water 10,914,000.00 2,991,730.57 7,307,807.00 8,310,356.87 - 2,603,643.13 76.14 000-457110 Edwards Water Lease 40,000.00 7,419.63 34,243.78 55,615.91 - (15,615.91) 139.04 000-457120 Water Transfer Charge-Selma 30,000.00 - 28,808.83 17,169.24 - 12,830.76 57.23 000-457200 Sale of Meters 120,000.00 31,564.24 63,073.06 83,360.42 - 36,639.58 69.47 000-457400 Sewer Charges 7,550,000.00 2,055,294.02 5,391,274.43 5,917,379.39 - 1,632,620.61 78.38 000-457500 Water Penalties 250,000.00 (117.87) 5,509.22 132,205.29 - 117,794.71 52.88 000-459200 NSF Check Fee-Water&Sewer 2,500.00 525.00 1,975.00 2,475.00 - 25.00 99.00 TOTAL Fees 24,575,500.00 6,460,125.14 16,897,492.45 18,656,812.95 - 5,918,687.05 75.92% Fund Transfers 000-486000 Transfer In - Reserves 4,124,855.00 - - - - 4,124,855.00 - 000-486204 Interfnd Chrg-Drainage Billing 146,400.00 105,750.00 109,800.00 - 36,600.00 75.00 TOTAL Fund Transfers 4,271,255.00 - 313,052.27 109,800.00 - 4,161,455.00 2.57% Miscellaneous 000-490000 Misc Charges 5,000.00 - 7,622.00 5,787.00 - (787.00) 115.74 000-491000 Interest Earned 75,000.00 837.76 51,161.25 22,035.97 - 52,964.03 29.38 000-491200 Investment Income 240,000.00 22,375.89 178,982.36 136,361.02 - 103,638.98 56.82 000-497000 Misc Income-W&S 20,000.00 63,440.70 46,269.92 75,537.49 - (55,537.49) 377.69 000-498110 Salary Reimb-SSLGC 125,218.00 102,578.89 70,719.69 - 54,498.31 56.48 TOTAL Miscellaneous 465,218.00 86,654.35 386,614.42 310,442.17 - 154,775.83 66.73% TOTAL REVENUES 29,539,353.00 6,634,228.59 17,818,711.72 19,342,046.93 - 10,197,306.07 65.48% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2020 Cash in Bank Claim on Operating Cash Pool-Checking (129,855.08)$ Cash in Investments Lone Star Investment-Water&Sewer 9,420,501.66 Lone Star Investment-W&S Reserve Lone Star Investment-W&S Customer Deposits 316,882.76 Lone Star Investment-W&S Equip Replacement 190,524.82 Lone Star Investment-W&S Veh Replacement 275,230.41 Lone Star Investment-Water/SSLGC SAWS Schertz Bank & Trust-Certificate of Deposit 1,139,981.45 11,343,121.10$ Total Cash in Bank & Investments 11,213,266.02$ WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2020 203-EMS CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 6,492,049.80 1,254,191.36 4,524,540.08 4,247,157.13 - 2,244,892.67 65.42% Inter-Jurisdictional 2,991,594.35 688,187.20 2,704,324.96 2,229,446.11 - 762,148.24 74.52% Miscellaneous 115,500.00 25,693.76 76,465.63 107,038.55 - 8,461.45 92.67% TOTAL REVENUES 9,599,144.15 1,968,072.32 7,305,330.67 6,583,641.79 - 3,015,502.36 68.59% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 4,404,732.00 1,114,549.93 3,101,172.67 3,383,724.97 148.50 1,020,858.53 76.82 Supplies 376,100.00 85,264.74 287,150.68 266,940.49 48,871.27 60,288.24 83.97 City Support Services 137,900.00 18,781.40 63,446.73 59,713.85 - 78,186.15 43.30 Utility Services 136,000.00 30,051.79 87,869.29 83,199.69 456.34 52,343.97 61.51 Operations Support 63,550.00 3,328.69 52,484.77 30,840.70 87.75 32,621.55 48.67 Staff Support 83,650.00 3,702.76 39,783.61 39,847.89 12,012.21 31,789.90 62.00 City Assistance 562,366.81 137,969.70 417,322.06 416,149.07 301.00 145,916.74 74.05 Professional Services 158,000.00 29,046.69 72,603.76 92,915.47 13,000.03 52,084.50 67.04 Fund Charges/Transfers 2,854,204.80 589,490.33 1,916,388.87 1,981,493.59 - 872,711.21 69.42 Maintenance Services 30,000.00 4,800.00 5,099.00 23,880.00 - 6,120.00 79.60 Debt Service 281,007.50 - 114,481.36 116,458.55 3,375.00 161,173.95 42.64 Rental/Leasing 67,000.00 - 100,780.31 65,118.05 - 1,881.95 97.19 Operating Equipment 73,300.00 10,453.51 40,721.23 24,510.01 1,211.64 47,578.35 35.09 Capital Outlay 371,000.00 2,495.00 6,500.00 44,431.16 288,709.25 37,859.59 89.80 TOTAL PUBLIC SAFETY 9,598,811.11 2,029,934.54 6,305,804.34 6,629,223.49 368,172.99 2,601,414.63 72.90% TOTAL EXPENDITURES 9,598,811.11 2,029,934.54 6,305,804.34 6,629,223.49 368,172.99 2,601,414.63 72.90% ** REVENUE OVER(UNDER) EXPENSES **333.04 (61,862.22) 999,526.33 (45,581.70) (368,172.99) 414,087.73 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2020 203-EMS CURRENT BUDGET CURRENT QUARTER PEIOR 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,210,949.80 1,203,946.36 4,320,369.51 4,057,624.96 - 2,153,324.84 65.33 000-456110 Passport Membership Fees 28,000.00 820.00 23,430.00 24,645.00 - 3,355.00 88.02 000-456120 EMT Class - Fees 99,000.00 13,705.00 64,179.06 65,380.00 - 33,620.00 66.04 000-456122 CE Class - Fees 27,000.00 17,692.77 17,022.00 17,692.77 - 9,307.23 65.53 000-456130 Immunization Fees 2,000.00 3,123.99 2,283.74 6,277.91 - (4,277.91) 313.90 000-456140 Billing Fees-External 25,000.00 5,649.30 17,286.54 17,559.83 - 7,440.17 70.24 000-456150 Standby Fees 30,000.00 315.00 21,509.50 15,185.00 - 14,815.00 50.62 000-456155 Community Services Support 50,000.00 1,840.84 31,143.70 17,802.66 - 32,197.34 35.61 000-456160 MIH Services 20,000.00 7,073.10 22,692.00 24,889.00 - (4,889.00) 124.45 000-459200 NSF Check Fee 100.00 25.00 50.00 100.00 - - 100.00 TOTAL Fees 6,492,049.80 1,254,191.36 4,524,540.08 4,247,157.13 - 2,244,892.67 65.42% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 843,577.17 210,894.51 843,578.04 702,981.66 - 140,595.51 83.33 000-474300 Cibolo Support 439,612.47 109,903.12 307,937.04 329,709.36 - 109,903.11 75.00 000-475100 Comal Co ESD #6 133,064.36 33,554.48 93,383.55 98,884.72 - 34,179.64 74.31 000-475200 Live Oak Support 237,774.60 59,443.65 174,105.21 178,330.95 - 59,443.65 75.00 000-475300 Universal City Support 305,995.77 76,498.94 225,068.76 229,496.82 - 76,498.95 75.00 000-475400 Selma Support 161,001.36 40,250.34 111,522.84 120,751.02 - 40,250.34 75.00 000-475500 Schertz Support 602,582.76 150,645.69 436,152.93 451,937.07 - 150,645.69 75.00 000-475600 Santa Clara Support 11,137.23 2,784.31 8,092.26 8,352.93 - 2,784.30 75.00 000-475800 Marion Support 16,848.63 4,212.16 12,260.01 12,636.48 - 4,212.15 75.00 000-475910 TASPP Program 240,000.00 - 492,224.32 96,365.10 - 143,634.90 40.15 TOTAL Inter-Jurisdictional 2,991,594.35 688,187.20 2,704,324.96 2,229,446.11 - 762,148.24 74.52% Fund Transfers - Miscellaneous 000-491000 Interest Earned 4,000.00 41.03 4,468.87 980.72 - 3,019.28 24.52 000-491200 Investment Income 9,500.00 1,996.64 6,680.96 8,851.14 - 648.86 93.17 000-493203 Donations-EMS 2,000.00 30.00 625.44 5,725.53 - (3,725.53) 286.28 000-497000 Misc Income 50,000.00 373,112.23 37,381.83 35,096.18 - 14,903.82 70.19 000-497100 Recovery of Bad Debt 50,000.00 2,919.72 2,452.00 6,123.86 - 43,876.14 12.25 TOTAL Miscellaneous 115,500.00 396,868.99 76,465.63 107,038.55 - 8,461.45 92.67% TOTAL REVENUES 9,599,144.15 2,339,247.55 7,305,330.67 6,583,641.79 - 3,015,502.36 68.59% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: March 31, 2020 Cash in Bank Claim on Operating Cash Pool-Checking 135,897.98$ Cash in Investments EMS-Logic 766,698.47 SR 2017 Ambulance-Logic 59,071.42 Total Cash in Bank & Investments 961,667.87$ C I T Y O F S C H E R T Z CASH IN BANK AND INVESTMENTS AS OF: March 31, 2020 204-DRAINAGE CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Permits 4,000.00 660.00 2,760.00 2,440.00 - 1,560.00 61.00 Fees 1,230,000.00 302,915.59 902,360.88 909,141.74 - 320,858.26 73.91 Miscellaneous 33,000.00 1,935.27 51,005.70 12,578.39 - 20,421.61 38.12 TOTAL REVENUES 1,267,000.00 305,510.86 983,126.58 924,160.13 - 342,839.87 72.94% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 400,200.00 83,220.97 233,535.89 237,613.85 20.25 162,565.90 59.38 Supplies 6,000.00 1,275.91 2,998.96 4,833.30 19.75 1,146.95 80.88 City Support Services 10,500.00 234.61 3,266.01 4,038.48 - 6,461.52 38.46 Utility Services 13,200.00 3,148.48 10,062.75 8,194.37 1,981.99 3,023.64 77.09 Operations Support 1,050.00 - - - - 1,050.00 - Staff Support 13,700.00 1,511.82 5,934.12 5,056.38 359.12 8,284.50 39.53 City Assistance 500.00 - 63.00 80.00 40.00 380.00 24.00 Professional Services 11,500.00 2,106.65 1,475.00 3,606.65 - 7,893.35 31.36 Fund Charges/Transfers 479,659.00 119,664.75 551,148.81 358,992.25 - 120,666.75 74.84 Maintenance Services 92,000.00 49,522.01 4,334.04 71,702.01 14,715.00 5,582.99 93.93 Other Costs 200.00 - 100.00 100.00 - 100.00 50.00 Debt Service 124,200.00 - 3,099.64 2,085.17 - 122,114.83 1.68 Rental/Leasing 500.00 - 55.00 - - 500.00 - Operating Equipment 2,000.00 - 4,474.12 863.97 - 1,136.03 43.20 Capital Outlay 110,500.00 - 69,575.66 - 35,120.00 75,380.00 31.78 TOTAL DRAINAGE 1,265,709.00 260,685.20 890,123.00 697,166.43 52,256.11 516,286.46 59.21% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2020 204-DRAINAGE CURRENT BUDGET CURRENT QUARTER PEIOR 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, 2020 PROJECTS Maintenance Services - - 623,685.79 1,384.10 11,736.58 (13,120.68) - TOTAL PROJECTS - - 633,703.79 1,384.10 11,736.58 (13,120.68) 0.00% TOTAL EXPENDITURES 1,265,709.00 260,685.20 1,523,826.79 698,550.53 63,992.69 503,165.78 60.25% ** REVENUE OVER(UNDER) EXPEND 1,291.00 44,825.66 (540,700.21) 225,609.60 (63,992.69) (160,325.91) 204-DRAINAGE CURRENT BUDGET CURRENT QUARTER PEIOR 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 660.00 2,760.00 2,440.00 - 1,560.00 61.00 TOTAL Permits 4,000.00 660.00 2,760.00 2,440.00 - 1,560.00 61.00% Fees 000-457500 Drainage Penalties 10,000.00 - 32.02 4,250.09 - 5,749.91 42.50 000-457600 Drainage Fee 1,220,000.00 302,915.59 902,328.86 904,891.65 - 315,108.35 74.17 TOTAL Fees 1,230,000.00 302,915.59 902,360.88 909,141.74 - 320,858.26 73.91% Fund Transfers Miscellaneous 000-491000 Interest Earned 3,000.00 54.84 2,876.01 390.85 - 2,609.15 13.03 000-491200 Investment Income 30,000.00 1,880.43 24,113.12 8,686.12 - 21,313.88 28.95 TOTAL Miscellaneous 33,000.00 1,935.27 51,005.70 12,578.39 - 20,421.61 38.12% TOTAL REVENUES 1,267,000.00 305,510.86 983,126.58 924,160.13 - 342,839.87 72.94% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2020 Cash in Bank Claim on Operating Cash Pool-Checking 90,015.33$ Cash in Investments Lone Star Investment-Drainage Maint Fund 804,876.17 Total Cash in Bank & Investments 894,891.50$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: June 30, 2020 314-HOTEL TAX CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Taxes 500,000.00 37,786.15 362,222.28 246,548.06 - 253,451.94 49.31 Miscellaneous 53,000.00 4,216.93 35,824.57 24,482.10 - 28,517.90 46.19 TOTAL REVENUES 553,000.00 42,003.08 398,046.85 271,030.16 - 281,969.84 49.01% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 112,466.00 14,712.55 66,128.54 72,012.64 - 40,453.36 64.03 Operations Support 46,000.00 - 10,430.00 8,553.00 1,703.70 35,743.30 22.30 Professional Services 3,000.00 - 26,483.83 3,499.50 - (499.50) 116.65 Fund Charges/Transfers 74,428.00 18,606.99 50,686.51 55,821.01 - 18,606.99 75.00 Maintenance Services 20,000.00 - - - - 20,000.00 - Capital Outlay 250,000.00 223,189.35 - 223,189.35 - 26,810.65 89.28 TOTAL NONDEPARTMENTAL 505,894.00 256,508.89 153,728.88 363,075.50 1,703.70 141,114.80 72.11% TOTAL EXPENDITURES 505,894.00 256,508.89 153,728.88 363,075.50 1,703.70 141,114.80 72.11% REVENUE OVER(UNDER) EXPENDITURE 47,106.00 (214,505.81) 244,317.97 (92,045.34) (1,703.70) 140,855.04 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2020 Cash in Bank Claim on Operating Cash Pool-Checking 77,788.88$ Cash in Investments Texas Class - Hotel Tax 1,981,242.12 Total Cash in Bank & Investments 2,059,031.00$ HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: March 31, 2020 AS OF: March 31, 2020 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2019-20 33,124 31,590 29,661 23,382 33,841 20,209 8,643 8,934 13,859 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 2015-16 40,800 40,351 38,394 34,516 39,732 54,142 49,741 45,524 51,636 68,491 48,302 33,241 - 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 PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 70,000.00 - 11,000.00 - - 70,000.00 - Fund Transfers 99,000.00 - - - - 99,000.00 - Miscellaneous 8,000.00 - 14,898.91 3,096.97 - 4,903.03 38.71 TOTAL REVENUES 177,000.00 - 25,898.91 3,096.97 - 173,903.03 1.75% EXPENDITURE SUMMARY NON DEPARTMENTAL PARKLAND DEDICATION Capital Outlay 177,000.00 - 86,841.42 - - 177,000.00 - TOTAL PARKLAND DEDICATION 177,000.00 - 101,191.53 5,760.00 5,881.49 165,358.51 6.58% TOTAL EXPENDITURES 177,000.00 - 101,191.53 5,760.00 5,881.49 165,358.51 6.58% REVENUE OVER(UNDER) EXPEND 0.00 - (75,292.62) (2,663.03) (5,881.49) 8,544.52 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2020 317-PARK CURRENT BUDGET CURRENT QUARTER PEIOR 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 - 11,000.00 - - 70,000.00 - TOTAL Fees 70,000.00 - 11,000.00 - - 70,000.00 0.00% Fund Transfers 000-48100 Transfer In- Reserves 99,000.00 - - - - 99,000.00 0.00 TOTAL Fund Transfers 99,000.00 - - - - 99,000.00 0.00% Miscellaneous 000-491000 Interest Earned 1,000.00 18.52 825.65 357.82 - 642.18 35.78 000-491200 Investment Income 7,000.00 497.21 5,102.76 2,738.15 - 4,261.85 39.12 TOTAL Miscellaneous 8,000.00 515.73 5,928.41 3,095.97 - 4,904.03 38.70% TOTAL REVENUES 177,000.00 515.73 16,928.41 3,095.97 - 173,904.03 1.75% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2020 Cash in Bank Current Claim on Operating Cash Pool-Checking 42,343.56 Cash in Investments Texas Class- Park Fund 245,663.07 Total in Investment Pool 245,663.07 Total Cash in Bank & Investments 288,006.63 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: June 30, 2020 319-TREE MITIGATION CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 70,000.00 (3,650.00) 2,182.50 52,614.70 - 17,385.30 75.16 Miscellaneous 8,750.00 897.11 7,865.35 5,682.44 - 3,067.56 64.94 TOTAL REVENUES 78,750.00 (2,752.89) 10,047.85 58,297.14 - 20,452.86 74.03% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services 75,000.00 6,900.00 11,500.00 14,800.00 8,400.00 51,800.00 30.93 TOTAL TREE MITIGATION 75,000.00 6,900.00 11,500.00 14,800.00 8,400.00 51,800.00 30.93% TOTAL EXPENDITURES 75,000.00 6,900.00 11,500.00 14,800.00 8,400.00 51,800.00 30.93% REVENUE OVER(UNDER) EXPEND 3,750.00 (9,652.89) (1,452.15) 43,497.14 (8,400.00) (31,347.14) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2020 319-TREE MITIGATION CURRENT BUDGET CURRENT QUARTER PEIOR 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 (3,650.00) 2,182.50 52,614.70 - 17,385.30 75.16 TOTAL Fees 70,000.00 (3,650.00) 2,182.50 52,614.70 - 17,385.30 75.16% Fund Transfers Miscellaneous 000-491000 Interest Earned 750.00 22.03 639.80 432.14 - 317.86 57.62 000-491200 Investment Income 8,000.00 875.08 7,225.55 4,750.30 - 3,249.70 59.38 TOTAL Miscellaneous 8,750.00 897.11 7,865.35 5,682.44 - 3,067.56 64.94% TOTAL REVENUES 78,750.00 (2,752.89) 10,047.85 58,297.14 - 20,452.86 74.03% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2020 Cash in Bank Claim on Operating Cash Pool-Checking $44,553.04 Cash in Investments MBIA Investment-Tree Mitigation 432,350.61 Total Cash in Bank & Investments $476,903.65 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: June 30, 2020 411-CAPITAL RECOVERY WATER CURRENT BUDGET CURRENT QUARTER PEIOR 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 374,970.00 683,186.40 939,677.29 - 160,322.71 85.43 Miscellaneous 180,000.00 17,054.83 126,286.42 77,773.73 - 102,226.27 43.21 TOTAL REVENUES 1,280,000.00 392,024.83 809,472.82 1,017,451.02 - 262,548.98 79.49% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 256,000.00 51,014.71 984.00 52,014.71 133,502.60 70,482.69 72.47 TOTAL NON DEPARTMENTAL 256,000.00 51,014.71 1,375,984.00 52,014.71 133,502.60 70,482.69 72.47% MISC & PROJECTS PROJECTS TOTAL EXPENDITURES 256,000.00 51,014.71 1,375,984.00 52,014.71 133,502.60 70,482.69 72.47% REVENUE OVER(UNDER) EXPENDITURES 1,024,000.00 341,010.12 (566,511.18) 965,436.31 (133,502.60) 192,066.29 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2020 411-CAPITAL RECOVERY WATER CURRENT BUDGET CURRENT QUARTER PEIOR 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 374,970.00 683,186.40 939,677.29 - 160,322.71 85.43 TOTAL Fees 1,100,000.00 374,970.00 683,186.40 939,677.29 - 160,322.71 85.43% Fund Transfers Miscellaneous - 000-491000 Interest Earned 5,000.00 155.84 2,883.66 2,766.17 - 2,233.83 55.32 000-491200 Investment Income 175,000.00 16,898.99 123,402.76 75,007.56 - 99,992.44 42.86 TOTAL Miscellaneous 180,000.00 17,054.83 126,286.42 77,773.73 - 102,226.27 43.21% TOTAL REVENUES 1,280,000.00 392,024.83 809,472.82 1,017,451.02 - 262,548.98 79.49% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2020 Cash in Bank Claim on Operating Cash Pool-Checking 212,781.84$ Cash in Investments Lone Star Investment-Capital Recovery Water 7,208,456.04 Total Cash in Bank & Investments 7,421,237.88$ CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: June 30, 2020 421-CAPITAL RECOVERY SEWER CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 600,000.00 206,561.20 376,492.92 486,321.40 - 113,678.60 81.05 Miscellaneous 103,000.00 13,991.59 123,806.17 86,363.40 - 16,636.60 83.85 TOTAL REVENUES 703,000.00 220,552.79 500,299.09 572,684.80 - 130,315.20 81.46% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 260,500.00 138,354.10 4,299.07 141,611.82 178,265.93 (59,377.75) 122.79 TOTAL NON DEPARTMENTAL 260,500.00 138,354.10 4,299.07 141,611.82 178,265.93 (59,377.75) 122.79% MISC & PROJECTS TOTAL EXPENDITURES 260,500.00 138,354.10 4,299.07 141,611.82 178,265.93 (59,377.75) 122.79% REVENUE OVER(UNDER) EXPENDITURES 442,500.00 82,198.69 496,000.02 431,072.98 (178,265.93) 189,692.95 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2020 421-CAPITAL RECOVERY SEWER CURRENT BUDGET CURRENT QUARTER PEIOR 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 806,561.20 387,292.92 486,321.40 - 113,678.60 81.05 TOTAL Fees 600,000.00 806,561.20 387,292.92 486,321.40 - 113,678.60 81.05% Fund Transfers Miscellaneous 000-491000 Interest Earned 3,000.00 3,098.82 2,804.71 1,635.22 - 1,364.78 54.51 000-491200 Investment Income 100,000.00 120,709.37 100,280.18 83,235.52 - 16,764.48 83.24 000-491900 Unrealize Gain/Loss-Captl One - (6,816.60) 29,288.22 1,492.66 - (1,492.66) 0.00% TOTAL Miscellaneous 103,000.00 116,991.59 132,373.11 86,363.40 - 16,636.60 83.85% TOTAL REVENUES 703,000.00 923,552.79 519,666.03 572,684.80 - 130,315.20 81.46% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2020 Cash in Bank Claim on Operating Cash Pool-Checking 25,775.29$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 5,350,686.84 Capital One-Investment 1,831,449.37 Total Cash in Bank & Investments 7,207,911.50$ CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: June 30, 2020 505-TAX I&S CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Taxes 6,733,000.00 125,423.32 6,360,584.49 6,626,502.18 - 106,497.82 98.42 Fund Transfers 144,003.00 - - - - 144,003.00 - Miscellaneous 150,000.00 28,352.56 155,417.22 68,919.95 - 81,080.05 45.95 TOTAL REVENUES 7,027,003.00 153,775.88 6,516,001.71 6,695,422.13 - 331,580.87 95.28% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 - 46,880.27 2,000.00 1,800.00 1,200.00 76.00 Debt Service 7,022,003.28 - 5,452,396.99 5,807,380.75 891,538.14 323,084.39 95.40 TOTAL GENERAL GOVERNMENT 7,027,003.28 - 5,499,277.26 5,809,380.75 893,338.14 324,284.39 95.39% TOTAL EXPENDITURES 7,027,003.28 - 5,499,277.26 5,809,380.75 893,338.14 324,284.39 95.39% ** REVENUE OVER(UNDER) EXPEND (0.28)153,775.88 1,016,724.45 886,041.38 (893,338.14) 7,296.48 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2020 505-TAX I & S CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Taxes 000-411900 Property Tax Revenue 6,733,000.00 125,423.32 6,360,584.49 6,626,502.18 - 106,497.82 98.42 TOTAL Taxes 6,733,000.00 125,423.32 6,360,584.49 6,626,502.18 - 106,497.82 98.42% Fund Transfers 000-481000 Transfer In - Reserves 144,003.00 - - - - 144,003.00 0.00% TOTAL Fund Transfers 144,003.00 - - - - 144,003.00 0.00% Miscellaneous 000-491000 Interest Earned 6,000.00 37.11 6,672.61 1,671.19 - 4,328.81 27.85 000-491200 Investment Income 44,000.00 3,315.45 29,303.03 17,248.76 - 26,751.24 39.20 000-495020 Contribution From YMCA 100,000.00 25,000.00 100,000.00 50,000.00 - 50,000.00 50.00 TOTAL Miscellaneous 150,000.00 28,352.56 135,975.64 68,919.95 - 81,080.05 45.95% TOTAL REVENUES 7,027,003.00 153,775.88 6,496,560.13 6,695,422.13 - 331,580.87 95.28% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: June 30, 2020 505-TAX I & S GENERAL GOVERNMENT CURRENT BUDGET CURRENT QUARTER PEIOR 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 - 2,350.00 2,000.00 1,800.00 1,200.00 76.00 TOTAL Professional Services 5,000.00 - 2,350.00 2,000.00 1,800.00 1,200.00 76.00% Debt Service 101-555629 Bond-GO 2007 Principal 315,000.00 - 300,000.00 315,000.00 - - 100 101-555629.1 Bond-GO 2007 Interest 111,823.25 - 65,221.75 59,116.75 - 52,706.50 52.87 101-555633 Bond-GO SR2011 Principal 260,000.00 - 250,000.00 260,000.00 - - 100 101-555633.1 Bond-GO SR2011 Interest 308,887.50 - 161,418.75 157,043.75 151,843.75 - 100 101-555634 Bond-GO 2011A Refund-Principal 475,000.00 - 485,000.00 475,000.00 - - 100 101-555634.1 Bond-GO 2011A Refund-Interest 63,550.75 - 40,192.50 34,542.25 - 29,008.50 54.35 101-555635 Bond-GO 2012 - Principal 355,000.00 - 345,000.00 355,000.00 - - 100 101-555635.1 Bond-GO 2012 - Interest 149,170.00 - 80,697.50 77,247.50 71,922.50 - 100 101-555638 Bond-GO 2014 Refund-Principal 100,000.00 - 100,000.00 100,000.00 - - 100 101-555638.1 Bond-GO 2014 Refund-Interest 283,775.00 - 144,137.50 142,637.50 141,137.50 - 100 101-555639 Tax Note - SR2015 - Principal 35,000.00 - - - - 35,000.00 0 101-555639.1 Tax Note - SR2015 - Interest 1,312.50 - 960.45 651.62 - 660.88 49.65 101-555640 Bond-Ref 2015 Bond-Principal 675,000.00 - 660,000.00 675,000.00 - - 100 101-555640.1 Bond-GO Ref 2015-Interest 66,187.50 - 43,912.50 37,312.50 28,875.00 - 100 101-555641 Tax Note - SR2015A-Principal 150,000.00 - - - - 150,000.00 0 101-555641.1 Tax Note - SR2015A - Interest 7,007.00 - 4,608.88 3,503.50 - 3,503.50 50 101-555642 Bond-GO SR2016-Principal 225,000.00 - 215,000.00 225,000.00 - - 100 101-555642.1 Bond-GO SR2016-Interest 150,406.26 - 81,753.13 77,453.13 72,953.13 - 100 101-555643 Bond-TaxableB CO SR2016-Princi 60,000.00 - 55,000.00 60,000.00 - - 100 101-555643.1 Bond-Taxable CO SR2016-Interes 43,862.50 - 23,206.25 22,381.25 21,481.25 - 100 101-555644 Bond-NonTaxA CO SR2016-Princip 180,000.00 - 175,000.00 180,000.00 - - 100 101-555644.1 Bond-NonTax CO SR2016-Interest 55,568.76 - 33,084.38 29,584.38 25,984.38 - 100 101-555645 Bond-CO SR2017-Principal 357,412.50 - 280,000.00 290,000.00 - 67,412.50 81.14 101-555645.1 Bond-CO SR2017 - Interest 63,062.50 - 71,612.50 67,412.50 63,062.50 (67,412.50) 206.9 101-555646 Bond-GO SR2017 - Principal 155,000.00 - 150,000.00 155,000.00 - - 100 101-555646.1 Bond-GO SR2017 - Interest 109,650.00 - 58,237.50 55,987.50 53,662.50 - 100 101-555647 Bond-GO 2018 Refund- Principal 560,000.00 - 550,000.00 560,000.00 - - 100 101-555647.1 Bond-GO 2018 Refund - Interest 110,346.00 - 63,971.00 58,141.00 - 52,205.00 52.69 101-555648 Bond-CO SR2018 - Principal 220,000.00 - 210,000.00 220,000.00 - - 100 101-555648.1 Bond-CO 2018 - Interest 187,262.50 - 118,569.80 96,381.25 90,881.25 - 100 101-555649 Bond-GO 2018 Ref - Principal 580,000.00 - 95,000.00 580,000.00 - - 100 101-555649.1 Bond-GO 2018 Ref - Interest 227,443.76 - 72,637.60 120,971.87 106,471.88 0.01 100 101-555650 Bond-CO 2019-Principal 250,000.00 - - 250,000.00 - - 100 101-555650.1 Bond-CO 2019-Interest 130,275.00 - - 67,012.50 63,262.50 - 100 TOTAL Debt Service 7,022,003.28 - 4,934,221.99 5,807,380.75 891,538.14 323,084.39 95.40% Other Financing Sources C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2020 505-TAX I & S GENERAL GOVERNMENT CURRENT BUDGET CURRENT QUARTER PEIOR 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: June 30, 2020 TOTAL EXPENDITURES 7,027,003.28 - 4,936,571.99 5,809,380.75 893,338.14 324,284.39 95.39% Cash in Bank Claim on Operating Cash Pool-Checking 18,037.33$ MBIA Investment- Tax I&S 1,825,466.57 Total Cash in Bank & Investments 1,843,503.90$ TAX I&S CASH IN BANK AND INVESTMENTS AS OF: June 30, 2020 620-SED CORPORATION CURRENT BUDGET CURRENT QUARTER PEIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Taxes 4,412,283.00 1,166,553.10 3,178,275.76 3,553,771.67 - 858,511.33 80.54 Fund Transfers 3,110,648.00 - - - - 3,110,648.00 - Miscellaneous 430,000.00 53,099.04 541,392.08 269,663.28 - 160,336.72 62.71 TOTAL REVENUES 7,952,931.00 1,219,652.14 3,719,667.84 3,823,434.95 - 4,129,496.05 48.08% EXPENDITURE SUMMARY NONDEPARTMENTAL City Assistance 6,664,200.00 - - 746,991.90 - 5,917,208.10 11.21 Fund Charges/Transfers 500,000.00 - - - - 500,000.00 - TOTAL NONDEPARTMENTAL 7,164,200.00 - - 746,991.90 - 6,417,208.10 10.43% MISC & PROJECTS PROJECTS ECONOMIC DEVELOPMENT Supplies 500.00 11.94 251.76 293.51 137.73 68.76 86.25 City Support Services 21,650.00 (481.25) 5,057.25 4,056.31 - 17,593.69 18.74 Utility Services 3,445.00 731.89 1,293.25 1,496.38 213.04 1,735.58 49.62 Operations Support 110,750.00 7,241.06 58,462.53 25,608.37 336.00 84,805.63 23.43 Staff Support 22,450.00 866.73 10,890.98 3,557.91 194.74 18,697.35 16.72 City Assistance 102,500.00 - 164.88 264.33 - 102,235.67 0.26 Professional Services 61,300.00 3,500.28 15,415.67 9,886.74 - 51,413.26 16.13 Fund Charges/Transfers 461,636.00 230,818.00 457,574.00 461,636.00 - - 100.00 Maintenance Services 500.00 - 80.00 - - 500.00 - Operating Equipment 4,000.00 - 375.77 651.90 3,413.18 (65.08) 101.63 TOTAL ECONO DEVELOPMENT 788,731.00 242,688.65 549,566.09 507,451.45 4,294.69 276,984.86 64.88% FM3009 ROAD&BRIDGE EXPANSION TOTAL EXPENDITURES 7,952,931.00 242,688.65 549,566.09 1,254,443.35 4,294.69 6,694,192.96 15.83% ** REVENUE OVER(UNDER) EXPEND 0.00 976,963.49 3,170,101.75 2,568,991.60 (4,294.69) (2,564,696.91) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2020 Cash in Bank Claim on Operating Cash Pool-Checking 138,981.33$ Cash in Investments Texas Class Investment-Economic Development Corp 21,222,988.95 Schertz Bank & Trust-Certificate of Deposit 1,058,841.90 Schertz Bank & Trust-Certificate of Deposit 1,110,917.56 Total Cash in Bank & Investments 23,531,729.74$ SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: June 30, 2019