Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04-Fourth Quarter Financial Report
CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2018 - 2019 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET General Fund, 101 Total Revenues 34,156,549 33,355,638.88 (600.00)801,509.69 97.66% Total General Government 6,584,482 5,897,009.59 7,877.38 679,594.68 89.68% Total Public Safety 14,576,571 14,355,397.36 42,004.42 179,169.52 98.77% Total Public Environment 1,641,982 1,308,962.31 35,020.37 297,999.32 81.85% Total Parks & Recreation 2,671,790 2,381,288.50 24,466.38 266,035.12 90.04% Total Cultural 1,017,904 1,003,912.77 0.00 13,991.23 98.63% Total Health 500,269 503,217.75 26,458.44 (29,407.19)105.88% Total Internal Services 6,760,987 6,017,676.95 101,359.72 641,950.33 90.51% Total Misc & Projects 377,666 305,733.20 37,839.34 34,093.46 90.97% Total Expenditures 34,131,651 31,773,198.43 275,026.05 2,083,426.47 93.90% Revenue Over(Under) Expenditures 24,897.62 1,582,440.45 General Fund, 101 Total Cash in Bank & Investments 16,111,809.19 Special Events Fund, 106 Total Revenues 156,760 150,862.96 0.00 5,897.04 96.24% Total Expenditures 177,708 134,596.62 862.01 42,249.37 76.23% Revenue Over(Under) Expenditures (20,948)16,266.34 Special Events Fund, 106 Total Cash in Bank & Investments 113,815.30 Peg Fund, 110 Total Revenues 195,000 87,045.14 0.00 107,954.86 44.64% Total Expenditures 195,000 3,258.50 0.00 191,741.50 1.67% Revenue Over(Under) Expenditures 0 83,786.64 Peg Fund, 110 Total Cash in Bank & Investments 785,708.49 Water & Sewer, 202 Total Revenues 25,735,522 27,124,462.51 0.00 (1,388,941.01)105.40% Total Expenditures 24,980,024 28,249,125.74 99,729.14 (3,368,831.13)113.49% Revenue Over(Under) Expenditures 755,498 (1,124,663.23) Water & Sewer, 202 Total Cash in Bank & Investments 10,391,833.03 Quarterly Statement Schertz, Texas AS OF :SEPTEMBER 30, 2019 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ********************************* 2018 - 2019 ******************************** CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET EMS, 203 Total Revenues 9,345,315 9,205,814.21 0.00 139,500.98 98.51% Total Expenditures 9,235,636 8,998,736.23 9,630.57 227,269.43 97.54% Revenue Over(Under) Expenditures 109,679 207,077.98 EMS, 203 Total Cash in Bank & Investments 584,695.16 Drainage, 204 Total Revenues 2,265,362 1,288,191.52 0.00 977,170.48 56.86% Total Expenditures 2,250,571 1,171,623.27 13,188.52 1,065,758.71 52.64% Revenue Over(Under) Expenditures 14,792 116,568.25 Drainage, 204 Total Cash in Bank & Investments 875,675.11 Hotel Tax, 314 Total Revenues 528,000 535,523.54 0.00 (7,523.54)101.42% Total Expenditures 256,732 197,845.63 0.00 58,886.37 77.06% Revenue Over(Under) Expenditures 271,268 337,677.91 Hotel Tax, 314 Total Cash in Bank & Investments 2,154,355.54 Park, 317 Total Revenues 176,512 18,600.74 0.00 157,911.26 10.54% Total Expenditures 176,512 102,091.53 5,881.49 68,538.98 61.17% Revenue Over(Under) Expenditures 0 (83,490.79) Park, 317 Total Cash in Bank & Investments 290,669.66 Tree Mitigation, 319 Total Revenues 80,250 29,469.35 0.00 50,780.65 36.72% Total Expenditures 75,000 27,867.22 0.00 47,132.78 37.16% Revenue Over(Under) Expenditures 5,250 1,602.13 Tree Mitigation, 319 Total Cash in Bank & Investments 447,526.48 Capital Recovery Water, 411 Total Revenues 2,557,000 1,223,671.79 0.00 1,333,328.21 47.86% Total Expenditures 1,631,000 1,375,984.00 0.00 255,016.00 84.36% Revenue Over(Under) Expenditures 926,000 (152,312.21) Capital Recovery Water, 411 Total Cash in Bank & Investments 6,455,801.57 Quarterly Statement Schertz, Texas AS OF :SEPTEMBER 30, 2019 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ********************************* 2018 - 2019 ******************************** CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Capital Recovery Sewer, 421 Total Revenues 644,000 763,846.85 0.00 (119,846.85)118.61% Total Expenditures 260,500 5,420.60 0.00 255,079.40 2.08% Revenue Over(Under) Expenditures 383,500 758,426.25 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 6,776,838.52 I&S, 505 Total Revenues 6,653,723 6,585,461.85 0.00 68,261.15 98.97% Total Expenditures 6,653,723 6,727,857.75 0.00 (74,134.48)101.11% Revenue Over(Under) Expenditures 0 (142,395.90) I&S, 505 Total Cash in Bank & Investments 957,462.52 SED Corporation, 620 Total Revenues 5,749,744 4,815,534.48 0.00 934,209.52 83.75% Total Expenditures 5,749,744 855,165.98 1,582.93 4,892,995.09 14.90% Revenue Over(Under) Expenditures 0 3,960,368.50 SED Corporation, 620 Total Cash in Bank & Investments 20,252,547.19 Total Cash in Bank & Investments 66,198,737.76 Quarterly Statement Schertz, Texas AS OF :SEPTEMBER 30, 2019 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 21,519,002.00 2,111,583.34 - 20,507,459.61 22,193,926.28 - (674,924.28) 103.14% Franchises 2,373,686.57 617,483.38 - 2,308,335.17 2,270,106.53 - 103,580.04 95.64% Permits 1,604,320.00 537,070.47 - 2,240,267.83 1,539,510.94 - 64,809.06 95.96% Licenses 56,760.00 14,814.50 - 73,381.00 65,786.55 - (9,026.55) 115.90% Fees 1,843,973.00 685,144.76 - 2,587,846.74 2,459,972.24 (600.00) (615,399.24) 133.37% Fines 22,000.00 3,737.57 - 20,902.37 14,582.69 - 7,417.31 66.28% Inter-Jurisdictional 967,008.00 287,984.32 - 887,255.98 926,569.88 - 40,438.12 95.82% Fund Transfers 5,063,249.00 534,527.18 - 2,989,901.29 2,697,682.62 - 2,365,566.38 53.28% Miscellaneous 706,550.00 402,693.33 - 918,107.62 1,202,471.17 - (495,921.17) 170.19% TOTAL REVENUES 34,156,548.57 5,195,038.85 - 32,533,457.61 33,370,608.90 (600.00) 786,539.67 97.70% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 35,009.00 9,528.46 - 35,409.70 36,445.44 14.40 (1,450.84) 104.14% Supplies 1,000.00 26.10 - 142.73 644.55 - 355.45 64.46% City Support Services 27,500.00 189.18 - 20,577.67 24,677.25 35.00 2,787.75 89.86% Utility Services - - - 624.64 - - - 0.00% Operations Support 300.00 - - 29.00 178.40 116.00 5.60 98.13% Staff Support 32,150.00 4,915.73 - 22,979.06 22,614.84 5.00 9,530.16 70.36% Professional Services 8,000.00 1,950.00 - 7,800.00 - 200.00 97.50% TOTAL CITY COUNCIL 103,959.00 16,609.47 - 79,762.80 92,360.48 170.40 11,428.12 89.01% CITY MANAGER Personnel Services 1,106,847.00 308,094.64 - 1,231,128.54 1,067,342.97 39.47 39,464.56 96.43% Supplies 1,920.00 480.94 - 457.30 1,892.23 24.20 3.57 99.81% City Support Services 6,000.00 4,338.25 - 8,154.32 4,338.25 - 1,661.75 72.30% Utility Services 2,000.00 - 1,634.74 414.39 - 1,585.61 20.72% Operations Support 50.00 - - - - 50.00 0.00% Staff Support 26,605.00 9,098.05 - 13,429.01 17,511.81 510.91 8,582.28 67.74% Operating Equipment 1,100.00 - - 1,446.99 1,370.45 - (270.45) 124.59% TOTAL CITY MANAGER 1,144,522.00 322,011.88 - 1,256,250.90 1,092,870.10 574.58 51,077.32 95.54% MUNICIPAL COURT Personnel Services 266,795.00 66,181.90 - 296,830.95 284,317.60 - (17,522.60) 106.57% Supplies 2,000.00 977.20 - 1,667.58 1,986.60 - 13.40 99.33% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 City Support Services 975.00 - - 157.86 326.17 - 648.83 33.45% Operations Support 3,000.00 1,843.00 - 730.37 1,967.00 - 1,033.00 65.57% Staff Support 8,510.00 2,562.23 - 5,465.11 6,988.33 74.36 1,447.31 82.99% Court Support 700.00 132.00 - 96.00 450.00 - 250.00 64.29% Professional Services 73,960.00 14,950.00 - 61,641.83 52,772.56 1,800.00 19,387.44 73.79% Maintenance Services 3,000.00 450.00 - 1,950.00 1,800.00 1,000.00 200.00 93.33% TOTAL MUNICIPAL COURT 358,940.00 87,096.33 - 368,539.70 350,608.26 2,874.36 5,457.38 98.48% CUSTOMER RELATIONS-311 Personnel Services 120,977.00 27,879.30 - 120,394.14 117,209.97 - 3,767.03 96.89% Supplies 150.00 27.58 - 88.92 96.99 - 53.01 64.66% Staff Support 530.00 71.08 - 102.96 195.02 (12.78) 347.76 34.38% Operating Equipment 300.00 269.78 - 554.62 269.78 - 30.22 89.93% TOTAL CUSTOMER RELATIONS-311 121,957.00 28,247.74 - 121,140.64 117,771.76 (12.78) 4,198.02 96.56% PLANNING & ZONING Personnel Services 210,124.00 54,961.07 - 204,100.39 203,165.60 - 6,958.40 96.69% Supplies 2,862.65 205.11 - 1,273.68 694.26 - 2,168.39 24.25% Operations Support 174.00 - - 162.20 7.00 43.00 124.00 28.74% Staff Support 26,755.00 14,097.66 - 15,060.11 23,537.48 - 3,217.52 87.97% Professional Services 100.00 13.00 - 10.00 27.00 - 73.00 27.00% Operating Equipment 250.00 373.00 - 154.99 1,225.38 - (975.38) 490.15% TOTAL PLANNING & ZONING 240,265.65 69,649.84 - 220,761.37 228,656.72 43.00 11,565.93 95.19% LEGAL SERVICES Operations Support 10,000.00 7,453.93 - 9,057.03 9,071.23 - 928.77 90.71% Professional Services 150,000.00 50,925.92 - 120,900.63 126,526.42 - 23,473.58 84.35% TOTAL LEGAL SERVICES 160,000.00 58,379.85 - 129,957.66 135,597.65 - 24,402.35 84.75% CITY SECRETARY Personnel Services 191,399.00 48,993.59 - 186,550.43 200,213.84 - (8,814.84) 104.61% Supplies 1,150.00 97.76 - 974.47 1,153.95 14.40 (18.35) 101.60% City Support Services 15,000.00 873.44 - 9,743.20 3,846.47 - 11,153.53 25.64% Operations Support 100.00 - - 59.90 27.95 - 72.05 27.95% Staff Support 4,400.00 108.00 - 3,523.11 4,137.32 - 262.68 94.03% TOTAL CITY SECRETARY 212,049.00 50,072.79 - 200,851.11 209,379.53 14.40 2,655.07 98.75% NON-DEPARTMENTAL City Support Services 507,202.00 60,120.27 - 390,962.75 438,071.77 - 69,130.23 86.37% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Operations Support 163,500.00 60,281.96 - 148,764.42 157,973.85 - 5,526.15 96.62% Staff Support 250.00 - - 160.00 73.20 - 176.80 29.28% City Assistance 1,879,730.00 165,384.29 - 1,705,943.56 1,463,271.90 - 416,458.10 77.84% Professional Services 51,235.00 12,346.68 - 60,993.86 47,922.39 - 3,312.61 93.53% Fund Chrgs/Transfrs-Spec Events Fnd 67,250.00 62,764.78 - 115,682.58 62,764.78 - 4,485.22 93.33% TOTAL NON-DEPARTMENTAL 2,669,167.00 360,897.98 - 2,422,507.17 2,170,077.89 - 499,089.11 81.30% PUBLIC AFFAIRS Personnel Services 288,461.00 63,723.80 - 277,168.01 289,214.00 - (753.00) 100.26% Supplies 1,050.00 261.04 - 2,124.89 733.49 - 316.51 69.86% City Support Services 4,000.00 1,365.00 - 1,975.14 - 2,024.86 Operations Support 43,500.00 9,593.95 - 16,241.05 21,894.62 2.91 21,602.47 50.34% Staff Support 10,100.00 1,424.72 - 3,253.20 7,817.76 14.00 2,268.24 77.54% Professional Services 304,980.00 48,423.82 - 3,120.00 286,850.24 - 18,129.76 94.06% Operating Equipment - 3,080.40 - 27.97 3,080.40 - (3,080.40) 0.00% TOTAL PUBLIC AFFAIRS 652,091.00 127,872.73 - 301,935.12 611,565.65 16.91 40,508.44 93.79% ENGINEERING Personnel Services 614,373.00 169,641.82 - 614,555.13 638,906.91 - (24,533.91) 103.99% Supplies 2,720.00 534.54 - 1,324.25 1,166.64 276.59 1,276.77 53.06% City Support Services 900.00 - - 650.00 - - 900.00 0.00% Utility Services 4,118.00 3,540.12 - 2,907.51 7,060.71 - (2,942.71) 171.46% Operations Support 100.00 - 47.70 - - 100.00 0.00% Staff Support 12,658.00 9,587.88 - 8,885.61 12,761.59 - (103.59) 100.82% Professional Services 71,000.00 18,565.09 - 11,110.71 19,831.11 1,160.00 50,008.89 29.56% Operating Equipment 3,351.00 428.38 - - 538.37 1,614.06 1,198.57 64.23% Capital Outlay 30,000.00 - - - 28,607.15 - 1,392.85 95.36% TOTAL ENGINEERING 739,220.00 202,297.83 - 639,480.91 708,872.48 3,050.65 27,296.87 96.31% GIS Personnel Services 173,886.00 44,120.64 - 166,317.73 173,207.79 - 678.21 99.61% Supplies 1,740.00 - - 486.94 - 1,145.86 594.14 65.85% Staff Support 4,600.00 - - 3,962.82 3,957.48 - 642.52 86.03% Rental/Leasing 2,085.00 520.95 - 2,083.80 2,083.80 - 1.20 99.94% TOTAL GIS 182,311.00 44,641.59 - 172,851.29 179,249.07 1,145.86 1,916.07 98.95% TOTAL GENERAL GOVERNMENT 6,584,481.65 1,367,778.03 - 5,914,038.67 5,897,009.59 7,877.38 679,594.68 89.68% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 PUBLIC SAFETY POLICE Personnel Services 7,168,007.00 1,861,048.57 - 6,221,395.14 7,022,239.83 - 145,767.17 97.97% Supplies 58,626.32 10,468.18 - 49,103.93 56,586.09 - 2,040.23 96.52% City Support Services 26,000.00 1,035.00 - 24,229.52 26,264.31 - (264.31) 101.02% Utility Services 99,344.50 37,328.75 - 89,016.75 97,914.26 - 1,430.24 98.56% Operations Support 10,621.00 3,515.05 - 2,991.25 7,836.05 36.79 2,748.16 74.13% Staff Support 151,161.53 40,633.35 - 116,509.36 135,559.21 38.32 15,564.00 89.70% City Assistance 18,200.00 9,377.87 - 19,714.79 16,742.20 - 1,457.80 91.99% Professional Services 78,123.00 25,801.17 - 53,395.79 80,628.97 - (2,505.97) 103.21% Maintenance Services 80,696.00 31,645.00 - 53,577.95 62,030.00 149.75 18,516.25 77.05% Operating Equipment 213,037.65 25,415.76 - 78,831.29 395,550.73 - (182,513.08) 185.67% Capital Outlay 373,991.30 - - 529,427.76 199,596.75 - 174,394.55 53.37% TOTAL POLICE 8,277,808.30 2,046,268.70 - 7,238,193.53 8,100,948.40 224.86 176,635.04 97.87% FIRE RESCUE Personnel Services 4,552,388.00 1,206,477.28 - 4,191,702.73 4,628,094.77 - (75,706.77) 101.66% Supplies 23,554.00 6,551.53 - 12,243.84 18,529.45 176.71 4,847.84 79.42% Utility Services 61,078.00 20,249.80 - 49,029.73 55,221.04 638.69 5,218.27 91.46% Operations Support 550.00 155.52 - 142.00 391.61 - 158.39 71.20% Staff Support 185,052.00 57,686.97 - 156,957.90 172,038.22 9,910.19 3,103.59 98.32% City Assistance 23,000.00 14,150.85 - 15,182.98 20,867.53 970.00 1,162.47 94.95% Professional Services 33,500.00 - - 25,875.00 33,465.00 - 35.00 99.90% Maintenance Services 83,818.00 37,819.94 - 58,967.71 70,560.44 104.00 13,153.56 84.31% Other Costs - - 15,159.58 1,594.08 - (1,594.08) 0.00% Rental/Leasing 29,100.00 3,371.22 - 15,915.85 25,580.85 - 3,519.15 87.91% Operating Equipment 112,144.00 36,097.33 - 143,198.68 100,193.32 8,913.92 3,036.76 97.29% Capital Outlay 179,000.00 157,910.84 - 121,816.53 157,910.84 21,066.05 23.11 99.99% TOTAL FIRE RESCUE 5,283,184.00 1,540,471.28 - 4,806,192.53 5,284,447.15 41,779.56 (43,042.71) 100.81% INSPECTIONS Personnel Services 849,754.00 222,953.75 - 629,217.79 809,228.83 - 40,525.17 95.23% Supplies 3,742.00 841.31 - 2,548.66 2,897.27 - 844.73 77.43% Utility Services 5,000.00 1,972.21 - 4,460.92 6,046.53 - (1,046.53) 120.93% Operations Support 2,219.00 259.50 - 1,780.80 1,206.10 - 1,012.90 54.35% Staff Support 29,961.00 11,175.83 - 19,253.85 25,974.71 - 3,986.29 86.70% Professional Services 70,000.00 14,075.00 - 260,540.00 69,720.00 - 280.00 99.60% Operating Equipment 903.00 961.53 - 5,390.79 2,841.07 - (1,938.07) 314.63% Capital Outlay 54,000.00 - - - 52,087.30 - 1,912.70 96.46% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 TOTAL INSPECTIONS 1,015,579.00 252,239.13 - 923,192.81 970,001.81 - 45,577.19 95.51% TOTAL PUBLIC SAFETY 14,576,571.30 3,838,979.11 - 12,967,578.87 14,355,397.36 42,004.42 179,169.52 98.77% PUBLIC ENVIRONMENT STREETS Personnel Services 800,297.00 178,884.44 773,404.43 732,429.04 67,867.96 91.52% Supplies 100,150.00 33,278.49 - 80,858.17 92,909.98 872.16 6,367.86 93.64% Utility Services 181,700.00 60,294.19 - 173,057.48 184,413.64 30.39 (2,744.03) 101.51% Staff Support 18,650.00 3,925.69 - 10,495.91 17,397.38 604.32 648.30 96.52% Professional Services 15,000.00 - 18,193.00 6,345.00 - 8,655.00 42.30% Maintenance Services 287,200.00 39,914.73 - 70,180.95 40,561.09 33,513.50 213,125.41 25.79% Rental/Lease 4,850.00 2,392.60 - 3,200.57 5,042.60 - (192.60) 103.97% Operating Equipment 4,850.00 1,531.91 - 6,661.87 41,318.45 - (36,468.45) 851.93% Capital Outlay 229,285.00 32,147.39 - 94,153.16 188,545.13 - 40,739.87 82.23% TOTAL STREETS 1,641,982.00 173,485.00 - 1,230,205.54 1,308,962.31 35,020.37 297,999.32 14.89 TOTAL PUBLIC ENVIRONMENT 841,685.00 173,485.00 - 1,230,205.54 1,308,962.31 35,020.37 297,999.32 159.68% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 673,965.00 155,104.01 - 458,475.39 573,534.00 - 100,431.00 85.10% Supplies 71,896.83 18,289.47 - 71,787.74 68,853.35 2,134.87 908.61 98.74% City Support Services 10,000.00 9,235.47 - 10,436.54 20,807.53 - (10,807.53) 208.08% Utility Services 220,500.00 66,430.23 - 256,028.02 225,783.03 - (5,283.03) 102.40% Operations Support 1,847.39 333.00 - 998.97 1,847.39 - - 100.00% Staff Support 14,895.30 3,537.02 - 8,200.38 17,338.49 115.67 (2,558.86) 117.18% Professional Services 137,500.00 71,221.48 - 115,891.58 151,897.02 - (14,397.02) 110.47% Maintenance Services 77,478.75 4,812.70 - 13,718.01 11,687.93 16,089.00 49,701.82 35.85% Rental/Leasing 5,946.73 8,230.95 - 29,493.86 13,629.57 - (7,682.84) 229.19% Operating Equipment 72,350.00 36,582.33 - 24,066.67 93,040.27 3,632.75 (24,323.02) 133.62% Capital Outlay 323,927.00 75,887.16 - 70,408.22 310,418.50 - 13,508.50 95.83% TOTAL PARKS DEPARTMENT 1,610,307.00 449,663.82 - 1,059,505.38 1,488,837.08 21,972.29 99,497.63 93.82% SWIM POOL Supplies 25,500.00 8,562.57 - 20,489.79 15,343.85 - 10,156.15 60.17% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Utility Services 16,500.00 6,971.13 - 27,834.67 27,255.74 - (10,755.74) 165.19% Professional Services - 2,992.50 - - 2,992.50 - (2,992.50) 0.00% Maintenance Services 597,878.00 209,758.75 - 529,216.51 519,888.57 1,974.00 76,015.43 87.29% Operating Equipment - 2,125.29 - 1,031.82 2,125.29 - (2,125.29) 0.00% TOTAL SWIM POOL 639,878.00 230,410.24 - 578,572.79 567,605.95 1,974.00 70,298.05 89.01% EVENT FACILITIES Personnel Services 295,770.00 65,165.61 - 48,371.35 241,044.79 - 54,725.21 81.50% Supplies 5,850.00 1,282.40 - 3,766.19 3,245.91 - 2,604.09 55.49% Utility Services 51,350.00 16,780.48 - 44,852.42 40,823.20 520.09 10,006.71 80.51% Operations Support 15,580.00 1,189.47 - 15,735.07 10,367.89 - 5,212.11 66.55% Staff Support 5,135.00 883.31 - 541.83 3,056.68 - 2,078.32 59.53% Maintenance Services 10,000.00 - - - 10,000.00 0.00% Operating Equipment 37,920.00 12,890.28 - 12,171.59 26,307.00 - 11,613.00 69.38% TOTAL EVENT FACILITIES 421,605.00 98,191.55 - 125,438.45 324,845.47 520.09 96,239.44 77.17% TOTAL PARKS & RECREATION 2,671,790.00 778,265.61 - 1,763,516.62 2,381,288.50 24,466.38 266,035.12 90.04% CULTURAL LIBRARY Personnel Services 800,254.00 211,559.75 - 748,526.96 790,290.09 - 9,963.91 98.75% Supplies 15,500.00 5,035.26 - 13,842.15 12,466.27 - 3,033.73 80.43% Utility Services 55,500.00 25,975.11 - 60,937.96 57,546.65 - (2,046.65) 103.69% Operations Support 3,650.00 1,321.96 - 4,061.88 2,851.88 - 798.12 78.13% Staff Support 5,700.00 411.80 - 4,742.01 4,512.15 - 1,187.85 79.16% Professional Services 2,300.00 - - 2,318.00 2,364.00 - (64.00) 102.78% Operating Equipment 135,000.00 40,084.48 - 111,519.48 133,881.73 - 1,118.27 99.17% TOTAL LIBRARY 1,017,904.00 284,388.36 - 945,948.44 1,003,912.77 - 13,991.23 98.63% TOTAL CULTURAL 1,017,904.00 284,388.36 - 945,948.44 1,003,912.77 - 13,991.23 98.63% HEALTH ANIMAL SERVICES Personnel Services 327,839.00 88,215.18 - 284,727.53 324,894.92 - 2,944.08 99.10% Supplies 36,380.00 14,225.56 - 36,941.28 41,960.75 - (5,580.75) 115.34% City Support Services 3,500.00 928.35 791.96 928.35 - 2,571.65 26.52% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Utility Services 44,000.00 15,544.14 - 53,198.14 57,629.68 3,827.95 (17,457.63) 139.68% Operations Support 1,000.00 - - 442.07 229.67 - 770.33 22.97% Staff Support 13,750.00 3,578.94 - 6,343.92 9,572.91 730.20 3,446.89 74.93% City Assistance 15,000.00 20,956.49 - 19,117.62 33,813.25 - (18,813.25) 225.42% Professional Services 28,117.00 14,987.00 - 20,780.52 28,068.45 - 48.55 99.83% Maintenance Services 5,069.00 1,274.85 - 16,695.95 2,160.12 - 2,908.88 42.61% Operating Equipment 5,511.00 2,146.62 - 24,326.76 3,959.65 1,797.50 (246.15) 104.47% Capital Outlay 20,103.00 - - 64,911.68 - 20,102.79 0.21 100.00% TOTAL ANIMAL SERVICES 500,269.00 161,857.13 - 528,277.43 503,217.75 26,458.44 (29,407.19) 105.88% TOTAL HEALTH 500,269.00 161,857.13 - 528,277.43 503,217.75 26,458.44 (29,407.19) 105.88% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 626,643.00 176,244.14 - 553,839.55 669,941.22 33.00 (43,331.22) 106.91% Supplies 9,140.00 1,138.51 - 7,173.48 5,340.03 123.28 3,676.69 59.77% City Support Services 920,029.00 238,746.21 - 683,465.38 709,038.97 1.04 210,988.99 77.07% Utility Services 235,768.00 92,896.97 - 199,530.43 232,361.90 4,245.50 (839.40) 100.36% Staff Support 43,600.00 3,946.20 - 32,833.86 39,076.23 - 4,523.77 89.62% Professional Services 477,919.00 170,443.62 - 7,065.10 216,398.62 3,938.00 257,582.38 46.10% Maintenance Services 14,500.00 5,601.82 - 12,027.58 13,945.61 456.00 98.39 99.32% Operating Equipment 429,660.00 37,339.94 - 262,589.01 300,645.20 2,633.29 126,381.51 70.59% Capital Outlay 33,500.00 31,736.19 - 80,384.43 37,103.19 51.96 (3,655.15) 110.91% TOTAL INFORMATION TECHNOLOGY 2,790,759.00 758,093.60 - 1,838,908.82 2,223,850.97 11,482.07 555,425.96 80.10% HUMAN RESOURCES Personnel Services 422,135.00 117,223.21 - 403,948.50 414,741.28 - 7,393.72 98.25% Supplies 700.00 54.75 - 823.37 606.32 6.06 87.62 87.48% Human Services 72,500.00 97,885.52 - 61,427.27 141,714.00 1,369.43 (70,583.43) 197.36% City Support Services - - 204.36 - - - 0.00% Utility Services - - 493.87 - - - 0.00% Operations Support 6,700.00 1,071.00 - 8,339.18 4,027.16 670.50 2,002.34 70.11% Staff Support 36,500.00 8,671.77 - 11,072.97 28,562.47 507.97 7,429.56 79.65% City Assistance 14,500.00 4,765.00 - 10,775.00 13,860.00 - 640.00 95.59% Professional Services 132,350.00 51,950.74 - 9,162.00 56,432.74 27,920.00 47,997.26 63.73% Operating Equipment 2,000.00 1,071.44 - 613.47 1,071.44 73.01 855.55 57.22% TOTAL HUMAN RESOURCES 687,385.00 282,693.43 - 506,859.99 661,015.41 30,546.97 (4,177.38) 100.61% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 FINANCE Personnel Services 573,362.00 147,381.81 - 523,522.33 558,785.93 - 14,576.07 97.46% Supplies 4,575.00 936.39 - 3,621.87 4,064.94 - 510.06 88.85% City Support Services - 138.00 - - - 0.00% Operations Support 2,155.00 - - 1,200.00 - - 2,155.00 0.00% Staff Support 9,495.00 200.00 - 7,938.56 3,676.40 - 5,818.60 38.72% Professional Sevices 34,500.00 8,967.00 29,255.00 31,498.75 - 3,001.25 91.30% Operating Equipment 1,395.00 1,797.97 - - 2,357.63 - (962.63) 169.01% TOTAL FINANCE 625,482.00 159,283.17 - 565,675.76 600,383.65 - 25,098.35 95.99% PURCHASING & ASSET MGT Personnel Services 210,449.00 56,587.57 - 196,031.53 214,878.73 - (4,429.73) 102.10% Supplies 1,450.00 382.05 - 570.99 1,660.75 - (210.75) 114.53% Utility Services - - - 253.34 - - - 0.00% Operations Support 7,450.00 753.25 - 1,101.65 5,818.75 - 1,631.25 78.10% Staff Support 6,700.00 1,590.36 - 3,228.67 4,609.19 446.85 1,643.96 75.46% City Assistance 3,000.00 416.00 749.00 1,994.00 - 1,006.00 66.47% Operating Equipment 350.00 169.98 - 545.99 169.98 - 180.02 48.57% Capital Outlay - - - 28,058.22 - - - 0.00% TOTAL PURCHASING & ASSET MGT 229,399.00 59,899.21 - 230,539.39 229,131.40 446.85 (179.25) 100.08% FLEET SERVICE Personnel Services 354,881.00 75,333.07 - 300,519.18 274,262.85 - 80,618.15 77.28% Supplies 167,530.00 2,587.56 - 198,319.23 137,605.58 724.74 29,199.68 82.57% City Support Services 16,500.00 40.50 - 13,117.77 15,887.30 - 612.70 96.29% Utility Services 8,000.00 2,666.73 - 10,578.32 8,743.67 - (743.67) 109.30% Staff Support 20,682.00 2,159.87 - 8,674.15 16,752.33 - 3,929.67 81.00% Maintenance Services 199,750.00 120,699.44 - 183,375.02 241,290.53 - (41,540.53) 120.80% Operating Equipment 8,200.00 4,396.97 - 8,790.35 14,811.56 - (6,611.56) 180.63% Capital Outlay 105,000.00 61,966.50 - 26,641.00 94,939.50 - 10,060.50 90.42% TOTAL FLEET SERVICE 880,543.00 269,850.64 - 750,015.02 804,293.32 724.74 75,524.94 91.42% FACILITY SERVICES Personnel Services 696,769.00 169,019.19 - 763,095.73 661,221.71 - 35,547.29 94.90% Supplies 100,613.08 31,727.54 - 106,145.42 102,431.79 119.00 (1,937.71) 101.93% Utility Services 169,600.00 72,027.50 - 187,315.74 176,961.97 4,644.09 (12,006.06) 107.08% Operation Support - - 30,671.31 - - - 0.00% Staff Support 6,183.00 1,069.31 - 8,747.11 5,604.55 - 578.45 90.64% Professional Services 78,550.00 32,284.54 46,333.01 82,988.29 - (4,438.29) 105.65% Maintenance Services 452,499.91 168,747.17 - 214,636.18 427,285.38 53,396.00 (28,181.47) 106.23% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Rental/Leasing 1,000.00 - - 4,717.95 400.00 - 600.00 40.00% Operating Equipment 5,739.92 1,682.06 21,271.95 5,670.06 - 69.86 98.78% Capital Outlay 36,464.09 26,012.40 - 59,316.44 36,438.45 - 25.64 99.93% TOTAL BUILDING MAINTENANCE 1,547,419.00 502,569.71 - 1,442,250.84 1,499,002.20 58,159.09 (9,742.29) 100.63% TOTAL INTERNAL SERVICE 6,760,987.00 2,032,389.76 - 5,334,249.82 6,017,676.95 101,359.72 641,950.33 90.51% MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 317,666.00 72,454.51 - 303,623.06 291,810.64 35,339.34 (9,483.98) 102.99% Operating Equipment 15,000.00 - - 8,467.47 11,315.88 - 3,684.12 75.44% TOTAL CITY ASSISTANCE 332,666.00 72,454.51 - 312,090.53 303,126.52 35,339.34 (5,799.86) 101.74% COURT - RESTRICTED FUNDS Operating Equipment 45,000.00 2,606.68 - 6,500.00 2,606.68 2,500.00 39,893.32 11.35% TOTAL CITY ASSISTANCE 45,000.00 2,606.68 - 6,500.00 2,606.68 2,500.00 39,893.32 11.35% TOTAL MISC & PROJECTS 377,666.00 75,061.19 - 318,590.53 305,733.20 37,839.34 34,093.46 90.97% TOTAL EXPENDITURES 34,131,650.95 8,891,088.63 - 29,002,405.92 31,773,198.43 275,026.05 2,083,426.47 93.90% REVENUE OVER(UNDER) EXPEND.24,897.62 (3,696,049.78) - 3,531,051.69 1,597,410.47 (275,626.05) (1,296,886.80) 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 13,122,952.00 88,312.64 - 11,849,651.59 13,471,713.69 - (348,761.69) 102.66% 000-411110 Disabled Veterans Assistance - - - 201,117.19 - (201,117.19) 0.00% 000-411200 Advalorem Tax - Delinquent 50,000.00 7,778.05 - 73,377.91 55,578.66 - (5,578.66) 111.16% 000-411300 Advalorem Tax - P&I 50,000.00 16,768.90 - 85,694.43 70,356.07 - (20,356.07) 140.71% 000-411500 Sales Tax Revenue-Gen Fund 8,252,000.00 1,978,086.55 - 8,455,340.51 8,334,641.95 - (82,641.95) 101.00% 000-411600 Bingo Tax 50.00 - - 11.25 24.30 - 25.70 48.60% 000-411700 Mixed Beverage Tax 44,000.00 20,637.20 - 43,383.92 60,494.42 - (16,494.42) 137.49% TOTAL Taxes 21,519,002.00 2,111,583.34 - 20,507,459.61 22,193,926.28 - (674,924.28) 103.14% Franchises 000-421200 Center Point/Entex Energy 82,988.93 14,581.98 - 80,245.25 92,447.59 - (9,458.66) 111.40% 000-421220 City Public Service 1,022,833.82 252,475.07 - 975,966.93 943,528.57 - 79,305.25 92.25% 000-421240 Guadalupe Valley Elec Co-op 423,553.61 146,876.68 - 454,085.05 445,505.43 - (21,951.82) 105.18% 000-421250 New Braunfels Utilities 74,472.96 20,977.84 - 71,118.70 66,590.59 - 7,882.37 89.42% 000-421300 Time Warner-State Franchise 298,637.68 77,325.15 - 305,571.04 310,383.88 - (11,746.20) 103.93% 000-421460 AT&T Franchise Fee 152,418.58 32,364.21 - 137,205.76 129,614.05 - 22,804.53 85.04% 000-421480 Other Telecom Franchise 162,780.99 32,716.35 - 129,916.99 125,415.10 - 37,365.89 77.05% 000-421500 Solid Waste Franchise Fee 156,000.00 40,166.10 - 154,225.45 156,621.32 - (621.32) 100.40% TOTAL Franchises 2,373,686.57 617,483.38 - 2,308,335.17 2,270,106.53 - 103,580.04 95.64% Permits 000-431100 Home Occupation Permit 500.00 35.00 - 490.00 525.00 - (25.00) 105.00% 000-431205 Building Permit - Residential 618,520.00 189,180.50 - 688,248.50 528,024.50 - 90,495.50 85.37% 000-431210 Building Permit - Commercial 270,000.00 89,869.00 - 687,367.50 154,369.00 - 115,631.00 57.17% 000-431215 Building Permit - General 220,000.00 111,100.50 - 329,072.00 362,897.50 - (142,897.50) 164.95% 000-431300 Mobile Home Permit 300.00 125.00 - 350.00 750.00 - (450.00) 250.00% 000-431400 Signs Permit 5,800.00 2,912.00 - 5,458.00 9,231.00 - (3,431.00) 159.16% 000-431500 Food Establishmnt Permit 63,000.00 2,725.00 - 60,950.00 62,460.00 - 540.00 99.14% 000-431700 Plumbing Permit 128,800.00 35,546.00 - 161,472.10 125,205.00 - 3,595.00 97.21% 000-431750 Electrical Permit 65,500.00 20,580.00 - 82,140.00 70,860.00 - (5,360.00) 108.18% 000-431800 Mechanical Permit 65,900.00 20,860.00 - 76,940.00 65,740.00 - 160.00 99.76% 000-431900 Solicitor/Peddler Permit 1,500.00 470.00 - 2,620.00 6,500.00 - (5,000.00) 433.33% 000-431950 Animal/Pet Permit 1,000.00 15.00 - 90.00 15.00 - 985.00 1.50% 000-432000 Cert. of Occupancy Prmt 6,500.00 3,200.00 - 6,450.00 9,250.00 - (2,750.00) 142.31% 000-432100 Security Alarm Permit 36,000.00 14,610.03 - 51,697.34 48,506.03 - (12,506.03) 134.74% 000-432300 Grading/Clearing Permit 15,000.00 3,979.79 - 14,645.67 15,117.92 - (117.92) 100.79% 000-432400 Development Permit 81,000.00 35,802.15 39,252.08 52,296.99 28,703.01 64.56% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 000-435000 Fire Permit 25,000.00 6,060.50 - 33,024.64 27,763.00 - (2,763.00) 111.05% 000-436010 Network Nodes - - - - - - - 0.00% TOTAL Permits 1,604,320.00 537,070.47 - 2,240,267.83 1,539,510.94 - 64,809.06 95.96% Licenses 000-441000 Alcohol Beverage License 8,000.00 1,952.50 - 7,085.00 7,542.50 - 457.50 94.28% 000-441300 Mobile Home License 160.00 - - 80.00 80.00 - 80.00 50.00% 000-442000 Contractors License 45,600.00 12,350.00 - 63,660.00 55,600.00 - (10,000.00) 121.93% 000-444000 Pet License 3,000.00 512.00 - 2,556.00 2,564.05 - 435.95 85.47% TOTAL Licenses 56,760.00 14,814.50 - 73,381.00 65,786.55 - (9,026.55) 115.90% Fees 000-451000 Municipal Court Fines 382,303.00 167,681.77 - 642,040.85 689,543.30 - (307,240.30) 180.37% 000-451100 Arrest Fee 21,012.00 6,941.13 - 24,742.97 26,447.55 - (5,435.55) 125.87% 000-451110 Expunction Fee 120.00 30.00 - - 30.00 - 90.00 25.00% 000-451200 Warrant Fees 98,000.00 16,274.10 - 75,203.31 72,813.48 - 25,186.52 74.30% 000-451210 Court - Claims & Judgements - - - - (214.89) - 214.89 0.00% 000-451320 Civil Justice Fee-Court 29.00 - - - - 29.00 0.00% 000-451321 Civil Justice Fee-State 262.00 - - - - - 262.00 0.00% 000-451340 Judicial Fee - City 2,776.00 912.65 - 3,314.98 3,516.35 - (740.35) 126.67% 000-451400 Traffic Fine Costs TTL 6,000.00 3,332.86 - 11,711.83 12,521.47 - (6,521.47) 208.69% 000-451510 Juvenile Case Mgmt Fee 23,236.00 7,610.30 - 27,695.63 29,337.96 - (6,101.96) 126.26% 000-451520 Truancy Fee 3,934.00 1,409.34 4,889.34 5,447.91 (1,513.91) 138.48% 000-451600 Technology Fund Fee 18,793.00 6,061.21 - 22,097.92 23,423.03 - (4,630.03) 124.64% 000-451700 Security Fee 7,475.00 4,545.89 - 16,678.09 17,567.27 - (10,092.27) 235.01% 000-451800 Time Payment Fee - City 4,119.00 1,075.18 - 4,986.29 4,967.73 - (848.73) 120.61% 000-451850 State Fines 10% Service Fee 20,000.00 8,362.12 - 29,597.98 35,756.42 - (15,756.42) 178.78% 000-451900 DPS Payment - Local 6,210.00 1,162.17 - 5,916.27 5,501.12 - 708.88 88.58% 000-452000 Child Safety Fee 4,874.00 2,251.14 - 6,798.39 9,742.52 - (4,868.52) 199.89% 000-452100 Platting Fees 57,000.00 15,000.00 - 53,000.00 52,500.00 - 4,500.00 92.11% 000-452200 Site Plan Fee 38,000.00 6,000.00 - 36,000.00 31,500.00 - 6,500.00 82.89% 000-452300 Plan Check Fee 514,260.00 182,545.88 - 817,114.50 527,530.81 - (13,270.81) 102.58% 000-452320 Tree Mitigation Admin Fee 12,000.00 4,342.50 - 17,368.50 5,280.00 - 6,720.00 44.00% 000-452400 BOA/Zoning Fees 6,500.00 500.00 - 5,777.64 3,250.00 - 3,250.00 50.00% 000-452600 Specific Use/Zone Chng Fee 18,000.00 - - 23,937.54 18,800.00 - (800.00) 104.44% 000-452710 Zoning Ltr & Dev Rights 1,950.00 1,500.00 - 1,950.00 4,500.00 - (2,550.00) 230.77% 000-453100 Reinspection Fees 100,100.00 56,577.00 - 169,225.00 226,667.00 - (126,567.00) 226.44% 000-453110 Swim Pool Inspection Fee 2,920.00 110.00 - 2,620.00 1,430.00 - 1,490.00 48.97% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 000-453200 Lot Abatement 5,000.00 1,757.50 - 1,615.00 2,507.50 - 2,492.50 50.15% 000-453211 Admin Fee-Inspections 15,500.00 1,800.00 - 24,600.00 11,100.00 - 4,400.00 71.61% 000-453310 Misc Inspection Fee - - - 3,613.00 400.00 - (400.00) 0.00% 000-453710 Foster Care 1,200.00 52.87 - 1,100.00 402.87 - 797.13 33.57% 000-454200 Pool Gate Admission Fee 24,000.00 16,182.10 - 23,053.09 24,312.35 - (312.35) 101.30% 000-454300 Seasonal Pool Pass Fee 5,000.00 484.00 - 4,410.00 4,234.00 - 766.00 84.68% 000-456120 Senior Center Meal Fee - - 802.00 401.00 - (401.00) 0.00% 000-456500 Haz Mat Fees 5,000.00 - - - 1,041.25 - 3,958.75 20.83% 000-456600 Fire Re-inspection Fee 1,000.00 143.17 - 1,145.00 493.17 - 506.83 49.32% 000-456600 Sale of General Fixed Asset 20,000.00 - - 19,251.61 - - 20,000.00 0.00% 000-458100 Sale of Merchandise - 1,475.00 - 2,111.39 (2,111.39) 0.00% 000-458110 Sale of Merchandise-GovDeal 25,000.00 12,917.98 - 86,052.04 113,073.22 - (88,073.22) 452.29% 000-458400 Civic Center Rental Fees 197,000.00 32,929.75 - 210,428.35 211,567.62 (600.00) (13,967.62) 107.09% 000-458401 Capital Recovery Fee-Civic Cntr 7,500.00 5,425.00 - 8,220.00 17,940.00 - (10,440.00) 239.20% 000-458450 North Center Rental Fees 23,000.00 7,932.50 - 26,581.75 27,797.00 (4,797.00) 120.86% 000-458460 Senior Center Rental 7,200.00 2,501.00 4,600.00 8,101.00 - (901.00) 112.51% 000-458500 Community Center Rental Fees 35,000.00 12,919.50 - 40,651.00 45,210.50 - (10,210.50) 129.17% 000-458501 Community Center Service Fees - 250.00 - 250.00 (250.00) 000-458510 Grand Ballroom Rental Fees - 24,718.75 - 27,218.75 (27,218.75) 0.00% 000-458520 Cut-Off Hall Rental Fees - 5,643.75 - 5,643.75 (5,643.75) 0.00% 000-458530 Conference Hall Rental Fees - 268.75 - 268.75 (268.75) 0.00% 000-458540 Bluebonnet Hall Rental Fees - 20,175.00 - 20,250.00 (20,250.00) 0.00% 000-458550 Pavilion Rental Fees 20,000.00 5,595.00 - 20,380.00 20,671.50 - (671.50) 103.36% 000-458560 Chamber of Comm rent 7,800.00 1,950.00 - 7,800.00 7,800.00 - - 100.00% 000-458570 Non-Resident SYSA League 10,000.00 - - 13,080.00 19,170.00 - (9,170.00) 191.70% 000-458580 HOA Meeting Rental Fees - - 450.00 (450.00) 000-458581 Funeral Reception Rental Fees - - 225.00 (225.00) 000-458582 Quality of Life Rental Fees - - 1,860.00 (1,860.00) 000-458590 Cancellation Fees-Event Rental - - 250.00 (250.00) 000-458650 NonResident User Fee-BVYA 10,000.00 7,470.00 - 9,670.00 10,710.00 - (710.00) 107.10% 000-458660 BVYA Utility Reimbursement 15,000.00 6,323.94 - 21,918.89 13,489.78 - 1,510.22 89.93% 000-458670 SYSA Utility Reimbursement 15,000.00 2,958.96 - 5,464.58 4,882.85 - 10,117.15 32.55% 000-458675 Lions Futbol Utility Reimbursement 10,000.00 10,032.00 - 8,860.00 17,064.00 - (7,064.00) 170.64% 000-458700 Vehicle Impoundment 10,000.00 3,100.00 - 10,920.00 7,820.00 - 2,180.00 78.20% 000-459200 NSF Check Fee 100.00 - - 25.00 100.00 - - 100.00% 000-459300 Notary Fee 200.00 - - 96.00 42.00 - 158.00 21.00% 000-459400 Maps, Copies, UDC, & Misc F - - - 35.00 30.00 - (30.00) 0.00% 000-459600 Animal Adoption Fee 12,500.00 3,283.00 - 18,826.90 12,423.12 - 76.88 99.38% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 000-459700 Pet Impoundment Fee 6,300.00 2,166.00 - 6,257.20 6,099.34 - 200.66 96.81% 000-459800 Police Reports Fee 5,800.00 464.00 - 5,723.30 4,701.50 - 1,098.50 81.06% 000-45990 Fire - False Alarm Fee - - - - - - - 0.00% TOTAL Fees 1,843,973.00 685,144.76 - 2,587,846.74 2,459,972.24 (600.00) (615,399.24) 133.37% Fines 000-463000 Library Fines 22,000.00 3,737.57 - 20,902.37 14,582.69 - 7,417.31 66.28% TOTAL Fines 22,000.00 3,737.57 - 20,902.37 14,582.69 - 7,417.31 66.28% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,077.00 - - 36,886.08 5,269.44 - 15,807.56 25.00% 000-473200 City of Seguin - Fire Contract 29,231.00 7,526.94 - 30,107.76 30,107.76 - (876.76) 103.00% 000-473300 Guad Co - Library 218,000.00 54,288.00 - 217,152.00 217,152.00 - 848.00 99.61% 000-473400 Randolph AFB-Animal Cntrl 1,200.00 - - 200.00 - - 1,200.00 0.00% 000-474200 Library Services - Cibolo 35,000.00 35,000.00 - 35,001.50 35,000.00 - - 100.00% 000-474210 Library Services-Selma 22,000.00 - - 21,750.00 23,475.00 - (1,475.00) 106.70% 000-474400 Dispatch Service - Cibolo 166,000.00 80,000.00 - 160,000.00 160,000.00 - 6,000.00 96.39% 000-474600 School Crossing Guard-Bexar 38,000.00 10,939.79 - 43,762.71 41,417.61 - (3,417.61) 108.99% 000-474610 School Cross Guard-Guadalupe 38,500.00 11,829.59 - 43,635.93 39,748.07 - (1,248.07) 103.24% 000-474700 School Officer Funding 348,000.00 88,400.00 - 255,000.00 349,400.00 - (1,400.00) 100.40% 000-474750 Crime Victim Liaison Agreement 50,000.00 - - 43,760.00 25,000.00 - 25,000.00 50.00% TOTAL Inter-Jurisdictional 967,008.00 287,984.32 - 887,255.98 926,569.88 - 40,438.12 95.82% Fund Transfers 000-480000 Indirect Costs - EMS 175,587.00 9,896.75 - 170,086.92 141,587.00 - 34,000.00 80.64% 000-480100 Indirect Costs - Hotel/Motel 67,582.00 16,895.49 - 67,605.00 67,582.00 - - 100.00% 000-481000 Transfer In Reserves 2,226,359.00 - - - - - 2,226,359.00 0.00% 000-482100 Transfer From Reserves-Ct Tech 26,207.00 - - - - 26,207.00 0.00% 000-485000 Interfund Charge-Drainage 295,157.00 73,789.26 - 271,429.92 295,157.00 - - 100.00% 000-486000 Interfund Chrges-Admin W&S 1,365,998.00 341,499.51 - 1,344,139.92 1,365,998.00 - - 100.00% 000-486202 Transfer In-W&S 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 370,729.00 92,446.17 - 344,026.00 370,728.62 - 0.38 100.00% 000-488000 Interfund Charges-4B 456,630.00 - - 441,395.00 456,630.00 - - 100.00% 000-489000 Transfer In 70,000.00 - - 86,218.53 - - 70,000.00 0.00% 000-489620 Contribution - SEDC - - - 265,000.00 - - - 0.00% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 TOTAL Fund Transfers 5,063,249.00 534,527.18 - 2,989,901.29 2,697,682.62 - 2,365,566.38 53.28% Miscellaneous 000-491000 Interest Earned 35,000.00 11,788.11 - 26,900.56 68,504.02 - (33,504.02) 195.73% 000-491200 Investment Income 235,000.00 95,696.80 - 242,255.25 407,592.77 - (172,592.77) 173.44% 000-491800 Gain/Loss - - - (16,291.80) (9,867.17) - 9,867.17 0.00% 000-491900 Unrealized Gain/Loss - 2,401.61 - (777.20) 22,386.31 - (22,386.31) 0.00% 000-492500 Proceeds from Capital Lease - - - 42,829.00 - 000-493000 Donations-Others - - - 20.00 50.00 - (50.00) 0.00% 000-493120 Donations-Public Library 10,000.00 2,034.00 - 6,854.17 9,692.32 - 307.68 96.92% 000-493130 Donations-Writing the Next Chap.- - - - - - - 0.00% 000-493400 Donation - Animal Control 15,000.00 2,058.75 - 12,979.36 4,768.50 - 10,231.50 31.79% 000-493401 Donations-A/C Microchip 1,000.00 292.00 - 675.00 382.00 - 618.00 38.20% 000-493402 Donations-Spay&Neuter 1,000.00 - - 87.00 - - 1,000.00 0.00% 000-493404 Donations-TNR Program 500.00 - - - - 500.00 0.00% 000-493460 Donations-Parks 10,000.00 8,557.00 11,355.80 11,717.51 - (1,717.51) 117.18% 000-493465 Donations-Senior Center 10,000.00 2,607.28 11,472.11 11,493.98 - (1,493.98) 114.94% 000-493502 Donations-PD - - - 27,000.00 930.00 - (930.00) 0.00% 000-493503 Donations-Fire Rescue - 140.00 15,350.00 1,740.00 - (1,740.00) 0.00% 000-493618 Donations-Veteran's Memorial - 390.00 - - 390.00 - (390.00) 0.00% 000-493503 Donations - Fire Rescue - - - - - - - 0.00% 000-494481 LawEnforcemtOfficersStnd&Ed 3,650.00 - - 3,823.43 4,341.18 - (691.18) 118.94% 000-494482 Grants - Police, Fire, Gen Fund 3,000.00 8,000.00 - 1,473.67 8,000.00 - (5,000.00) 266.67% 000-495100 Mobile Stage Rental Fees 2,100.00 - - 3,650.00 2,050.00 - 50.00 97.62% 000-497000 Misc Income-Gen Fund 60,000.00 9,004.26 - 27,727.14 43,408.62 - 16,591.38 72.35% 000-497005 Schertz Magazine Advertising 140,000.00 33,095.00 - 147,755.00 143,420.00 - (3,420.00) 102.44% 000-497100 Misc Income-Police 3,800.00 7,299.64 - 11,240.46 14,742.54 - (10,942.54) 387.96% 000-497150 Misc Income-Fire Department - - - 970.11 - - - 0.00% 000-497200 Misc Income-Library 4,500.00 1,312.75 - 5,330.70 4,929.85 - (429.85) 109.55% 000-497210 Misc Income-Library Copier 18,000.00 6,172.36 19,557.95 21,843.21 - (3,843.21) 121.35% 000-497300 Misc Income-Animal Control - - - 298.75 325.00 - (325.00) 0.00% 000-497400 Misc Income-Streets Dept.60,000.00 17,335.50 - 28,275.27 35,979.75 - 24,020.25 59.97% 000-497460 Misc Income-Parks - - - 139.80 (139.80) 0.00% 000-497500 Misc Income-TML Insurance 20,000.00 4,281.35 - 36,098.05 19,623.09 - 376.91 98.12% 000-497550 Misc Income-TML Reimbursemt 15,000.00 - - 2,073.87 3,406.65 - 11,593.35 22.71% 000-497600 Misc Income-Vending Mach.2,500.00 693.25 - 2,364.92 2,824.07 - (324.07) 112.96% 000-497610 Misc Income- Muni Court - - - 2,036.40 154.20 - (154.20) 0.00% 000-498000 Reimbursmnt-Gen Fund 20,000.00 - - 8,355.21 - - 20,000.00 0.00% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER EXPENSE Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 000-498100 Reimbursmnt Fire - Training 500.00 - - - - - 500.00 0.00% 000-498105 Reimburmnt Police - DEA - 5,035.54 - 17,212.66 17,830.24 - (17,830.24) 0.00% 000-498107 Reimburmnt Police - Event - - - - - - 0.00% 000-498110 Reimbursmnt Fire - Emg. Acti-O 30,000.00 184,498.13 - 212,799.39 336,654.54 - (306,654.54) 1122.18% 000-498150 Reimbursemnt - Library 6,000.00 - 6,355.39 13,018.19 - (7,018.19) 216.97% TOTAL Miscellaneous 706,550.00 402,693.33 - 918,107.62 1,202,471.17 - (495,921.17) 170.19% TOTAL REVENUES 34,156,548.57 5,195,038.85 - 32,533,457.61 33,370,608.90 (600.00) 786,539.67 97.70% Cash in Bank Claim on Operating Cash Pool-Checking 1,024,226.21$ Cash in Investments LOGIC Investment-General Fund 11,765,613.78 LOGIC Investment-Equip Replacement 78,099.46 LOGIC Investment-Veh Replacement 526,606.62 LOGIC Investment-Air Condi Replacment 286,583.49 BBVA CD Investment 1,015,620.41 CAPITAL ONE Investment-General Fund 1,415,059.22 Total Cash in Bank & Investments 16,111,809.19$ GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2019 100% OF OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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 2014-15 357,436 356,940 4,463,962 2,741,991 1,198,153 85,775 44,720 25,398 30,488 49,777 14,839 3,787 ADVALOREM TAX 100% OF OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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 2014-15 495,499 638,904 505,026 421,339 795,382 450,965 494,050 723,404 465,966 496,241 759,879 508,305 18.9%7.3% 2.0%-9.0% 3.4% 3.4% -3.8% -6.8% 48.5% 48.3% 14.2% 10.6% $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 $1,000,000 Sales Tax -General Fund 100% OF OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2018-19 270,225 203,885 199,326 263,032.10 2017-18 271,335 208,803 213,511 283,058 2016-17 252,947 191,140 213,951 259,517 2015-16 237,314 183,530 173,336 178,081 2014-15 215,257 172,814 172,628 227,438 $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 CITY PUBLIC SERVICE 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 56,500.00 59,893.42 74,175.90 59,893.42 - (3,393.42) 0.00% Miscellaneous 100,260.00 9,359.99 110,496.99 90,969.54 - 9,290.46 90.73% TOTAL REVENUES 156,760.00 69,253.41 184,672.89 150,862.96 - 5,897.04 96.24% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental - - 4,806.32 - - - 0.00% TOTAL GENERAL GOVERNMENT - - 4,806.32 - - - 0.00% CULTURAL Festival of Angels 16,255.00 196.00 10,566.23 17,557.29 - (1,302.29) 108.01% Employee Appreciation Event - - 12,133.31 - - - 0.00% 4th of July Jubilee 26,000.00 33,243.15 26,074.79 36,870.05 142.80 (11,012.85) 142.36% National Night Out 500.00 - - - - 500.00 0.00% Wilenchik Walk for Life 15,000.00 - 10,593.68 9,365.50 - 5,634.50 62.44% Schertz Fest 42,943.00 - 24,584.39 636.00 700.00 41,607.00 3.11% Schertz Sweetheart 24,000.00 12,841.57 17,662.90 23,851.16 19.21 129.63 99.46% Hal Baldwin Scholarship 15,510.00 679.98 13,544.61 12,135.91 - 3,374.09 78.25% Other Events 37,500.00 2,654.89 16,803.59 34,180.71 - 3,319.29 91.15% TOTAL CULTURAL 177,708.00 49,615.59 131,963.50 134,596.62 862.01 42,249.37 76.23% TOTAL EXPENDITURES 177,708.00 49,615.59 136,769.82 134,596.62 862.01 42,249.37 76.23% REVENUE OVER(UNDER) EXPEND (20,948.00) 19,637.82 47,903.07 16,266.34 (862.01) (36,352.33) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fund Transfers 000-486101 Transfer In - General Fund 56,500.00 59,893.42 74,175.90 59,893.42 - (3,393.42) 106.01% TOTAL Fund Transfers 56,500.00 59,893.42 74,175.90 59,893.42 - (3,393.42) 106.01% Miscellaneous 000-491200 Investment Income 250.00 102.99 312.80 435.04 - (185.04) 174.02% 000-492200 Wilenchik Walk for Life 15,000.00 - 10,594.00 9,305.50 - 5,694.50 62.04% 000-493000 July 4th Activities 26,000.00 7,447.50 25,628.00 34,288.50 - (8,288.50) 131.88% 000-493150 SchertzQ 30,000.00 - 6,150.00 (1,250.00) - 31,250.00 -4.17% 000-493256 Donations - Police Events 3,000.00 - - - - 3,000.00 0.00% 000-493455 Proceeds-Festival of Angels 1,500.00 - 1,305.00 4,170.00 - (2,670.00) 278.00% 000-493460 Schertz Sweetheart - (20.81) 488.00 - (488.00) 0.00% 000-493470 Moving on Main 3,000.00 - 680.00 4,560.00 (1,560.00) 152.00% 000-493621 Hal Baldwin Scholarship 15,510.00 - 20,105.00 28,820.00 - (13,310.00) 185.82% 000-497000 Misc Income 6,000.00 1,809.50 45,743.00 10,152.50 - (4,152.50) 169.21% TOTAL Miscellaneous 100,260.00 9,359.99 110,496.99 90,969.54 - 9,290.46 90.73% TOTAL REVENUES 156,760.00 69,253.41 184,672.89 150,862.96 - 5,897.04 96.24% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 96,001.12$ Cash in Investments Texas Class- Special Events 17,814.18 Total Cash in Bank & Investments 113,815.30$ SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2019 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 78,990.77 21,977.16 84,846.75 87,045.14 - (8,054.37) 110.20% Fund Transfers 116,009.23 - - - - 116,009.23 0.00% TOTAL REVENUES 195,000.00 21,977.16 84,846.75 87,045.14 - 107,954.86 44.64% EXPENDITURE SUMMARY MISC & PROJECTS Projects 195,000.00 - - 3,258.50 - 191,741.50 1.67% TOTAL MISC & PROJECTS 195,000.00 - - 3,258.50 - 191,741.50 1.67% TOTAL EXPENDITURES 195,000.00 - - 3,258.50 - 191,741.50 1.67% REVENUE OVER(UNDER) EXPEND - 21,977.16 84,846.75 83,786.64 - (83,786.64) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 110-PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421350 Time Warner - PEG Fee 60,168.03 15,548.28 57,299.25 61,501.13 - (1,333.10) 102.22% 000-421465 AT&T PEG Fee 18,822.74 6,428.88 27,547.50 25,544.01 - (6,721.27) 135.71% TOTAL Franchises 78,990.77 21,977.16 84,846.75 87,045.14 - (8,054.37) 110.20% Fund Transfers 000-489000 Transfer In 116,009.23 - - - - 116,009.23 0.00% TOTAL REVENUES 195,000.00 21,977.16 84,846.75 87,045.14 - 107,954.86 44.64% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Cash in Bank Cash Balance 785,708.49$ Total Cash in Bank & Investments 785,708.49$ PEG FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2019 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 263,517.05 3,375.34 263,468.61 224,928 - 38,589.13 85.36% Fees 24,439,057.45 7,177,414.06 23,293,063.84 24,074,907 - 364,150.94 98.51% Fund Transfers 685,836.00 35,250.00 141,510.00 348,302 - 337,533.73 50.79% Miscellaneous 347,111.00 2,089,711.39 3,495,149.24 2,476,326 - (2,129,214.81) 713.41% TOTAL REVENUES 25,735,521.50 9,305,750.79 27,193,191.69 27,124,462.51 - (1,388,941.01) 105.40% EXPENDITURE SUMMARY NON DEPARTMENTAL Transfer to Public Improvements 125,000.00 - 5,825,000.00 3,800,000.00 - (3,675,000.00) 3040.00% Other Finance Source - 62,790.17 51,999.83 62,790.17 - (62,790.17) 0.00% TOTAL NON DEPARTMENTAL 125,000.00 62,790.17 5,876,999.83 3,862,790.17 - (3,737,790.17) 3090.23% BUSINESS OFFICE Personnel Services 499,900.00 110,034.33 453,201.38 438,540.68 - 61,359.32 87.73% Supplies 3,800.00 837.41 2,916.30 2,308.36 - 1,491.64 60.75% City Support Services 5,655.00 - 1.00 250.00 - 5,405.00 4.42% Utility Services 10,365.00 4,013.08 1,026.26 6,763.25 - 3,601.75 65.25% Operations Support 158,500.00 31,472.18 141,417.02 126,534.83 6,572.90 25,392.27 83.98% Staff Support 6,250.00 1,442.88 3,754.61 4,821.52 - 1,428.48 77.14% Professional Services 243,000.00 90,082.83 210,299.57 246,531.98 - (3,531.98) 101.45% Maintenance Services 8,040.00 1,260.00 6,120.00 6,540.00 26,826.00 (25,326.00) 415.00% Operating Equipment 600.00 - 3,656.94 359.97 - 240.03 60.00% TOTAL BUSINESS OFFICE 936,110.00 239,142.71 822,393.08 832,650.59 33,398.90 70,060.51 92.52% W & S ADMINISTRATION Personnel Services 1,432,723.00 371,187.42 1,259,855.56 1,362,027.20 - 70,695.80 95.07% Supplies 187,500.00 182,383.89 178,336.42 313,561.55 4,257.15 (130,318.70) 169.50% Human Services 700.00 - - - - 700.00 0.00% City Support Services 157,535.00 1,248.76 59,829.47 52,962.33 - 104,572.67 33.62% Utility Services 3,526,800.00 1,234,998.43 3,528,080.66 3,480,075.21 119.78 46,605.01 98.68% Operations Support 11,300.00 2,403.90 6,419.10 9,193.15 - 2,106.85 81.36% Staff Support 35,000.00 13,291.44 25,583.02 35,762.27 2,416.82 (3,179.09) 109.08% City Assistance 1,500.00 170.00 333.00 205.00 - 1,295.00 13.67% Professional Services 416,465.00 87,298.07 403,180.89 373,083.84 - 43,381.16 89.58% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Fund Charges/Transfers 6,208,960.00 3,614,148.01 7,315,927.45 8,545,539.07 - (2,336,579.07) 137.63% Maintenance Services 9,149,707.50 3,376,236.48 8,519,547.48 8,857,026.15 3,355.09 289,326.26 96.84% Other Costs 40,000.00 - 36,615.45 38,435.72 - 1,564.28 96.09% Debt Service 1,904,245.25 213,436.65 382,602.62 480,953.55 - 1,423,291.70 25.26% Rental-Leasing 124,500.00 20,800.00 56,782.95 (30,306.56) - 154,806.56 -24.34% Operating Equipment 9,000.00 33,569.09 4,025.18 35,166.50 249.55 (26,416.05) 393.51% Capital Outlay 712,978.00 (688,421.03) - - 32,862.85 680,115.15 4.61% TOTAL PUBLIC WORKS 23,918,913.75 8,462,751.11 21,777,119.25 23,553,684.98 43,261.24 321,967.53 98.65% MISC & PROJECTS PROJECTS Operations Support - - - - - - 0.00% Professional Services - (14,336.25) - - 18,569.00 (18,569.00) 0.00% Maintenance Services - (164,131.18) - - 4,500.00 (4,500.00) 0.00% TOTAL PROJECTS - (178,467.43) - - 23,069.00 (23,069.00) 0.00% TOTAL MISC & PROJECTS - (178,467.43) - - 23,069.00 (23,069.00) 0.00% TOTAL EXPENDITURES 24,980,023.75 8,523,426.39 28,476,512.16 28,249,125.74 99,729.14 (3,368,831.13) 113.49% ** REVENUE OVER(UNDER)EXPENSES **755,497.75 782,324.40 (1,283,320.47) (1,124,663.23) (99,729.14) 1,979,890.12 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421490 Tower Leasing 263,517.05 3,375.34 263,468.61 224,927.92 - 38,589.13 85.36% TOTAL Franchises 263,517.05 3,375.34 263,468.61 224,927.92 - 38,589.13 85.36% Permits 000-432400 Development Permit - - - - - - 0.00% TOTAL Permits - - - - - - 0.00% Fees 000-455200 Garbage Collection Fee 5,217,962.06 1,358,838.92 4,960,183.19 5,130,049.00 - 87,913.06 98.32% 000-455600 Fire Line Fees 31,000.00 - 29,015.00 33,160.00 - (2,160.00) 106.97% 000-455700 Recycle Fee Revenue 315,500.00 83,099.38 305,469.41 328,531.43 - (13,031.43) 104.13% 000-455800 W&S Line Constructn Reimbursemnt 20,000.00 8,183.00 36,474.41 23,182.00 - (3,182.00) 115.91% 000-457100 Sale of Water 10,790,831.42 3,781,769.14 10,666,526.61 11,089,576.14 - (298,744.72) 102.77% 000-457110 Edwards Water Lease 40,000.00 - 54,872.25 34,243.78 - 5,756.22 85.61% 000-457120 Water Transfer Charge-Selma 6,233.00 21,762.54 26,419.64 50,571.37 - (44,338.37) 811.35% 000-457200 Sale of Meters 160,000.00 32,317.06 143,916.03 95,390.12 - 64,609.88 59.62% 000-457400 Sewer Charges 7,578,030.97 1,890,344.02 6,816,995.97 7,281,618.45 - 296,412.52 96.09% 000-457500 Water Penalties 277,000.00 150.00 250,316.33 5,659.22 - 271,340.78 2.04% 000-459200 NSF Check Fee-Water&Sewer 2,500.00 950.00 2,875.00 2,925.00 - (425.00) 117.00% TOTAL Fees 24,439,057.45 7,177,414.06 23,293,063.84 24,074,906.51 - 364,150.94 98.51% Fund Transfers 000-486000 Transfer In- Reserve 544,836.00 - - 207,302.27 - 337,533.73 38.05% 000-486204 Interfnd Chrg-Drainage Bill 141,000.00 35,250.00 141,510.00 141,000.00 - - 100.00% TOTAL Fund Transfers 685,836.00 35,250.00 141,510.00 348,302.27 - 337,533.73 50.79% Miscellaneous 000-490000 Misc Charges 1,000.00 2,812.00 10,989.00 10,434.00 - (9,434.00) 1043.40% 000-491000 Interest Earned 25,000.00 18,334.31 44,858.94 69,495.56 - (44,495.56) 277.98% 000-491200 Investment Income 180,000.00 48,597.90 158,053.81 227,580.26 - (47,580.26) 126.43% 000-495013 Capital Contribution - W&S - 1,975,523.56 3,132,348.49 1,975,523.56 - (1,975,523.56) 0.00% 000-496000 Water Construction Reserve - - 1.00 - - - 0.00% 000-497000 Misc Income-W&S 15,000.00 9,319.65 17,267.00 55,589.57 - (40,589.57) 370.60% 000-497550 TML Reimbursements - - - - - - 0.00% 000-498100 Reimbursement-EMS Loan - - - - - - 0.00% 000-498110 Reimbursement-SSLGC 126,111.00 35,123.97 131,630.00 137,702.86 - (11,591.86) 109.19% 000-498200 Reimbursement- W&S Project - - 1.00 - - - 0.00% TOTAL Miscellaneous 347,111.00 2,089,711.39 3,495,149.24 2,476,325.81 - (2,129,214.81) 713.41% TOTAL REVENUES 25,735,521.50 9,305,750.79 27,193,191.69 27,124,462.51 - (1,388,941.01) 105.40% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 985,072.95$ Cash in Investments Lone Star Investment-Water&Sewer 7,521,104.16 Lone Star Investment-W&S Customer Deposits 313,174.34 Lone Star Investment-W&S Equip Replacement 188,295.14 Lone Star Investment-W&S Veh Replacement 272,009.42 Schertz Bank & Trust-Certificate of Deposit 1,112,177.02 9,406,760.08$ Total Cash in Bank & Investments 10,391,833.03$ WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2019 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 6,194,079.80 1,416,695.00 4,754,620.33 5,941,235.08 - 252,844.72 95.92% Inter-Jurisdictional 3,025,485.39 456,822.11 2,861,992.46 3,161,147.07 - (135,661.68) 104.48% Fund Transfers - - - - - - 0.00% Miscellaneous 125,750.00 398,141.66 135,601.24 103,432.06 - 22,317.94 82.25% TOTAL REVENUES 9,345,315.19 2,271,658.77 7,752,214.03 9,205,814.21 - 139,500.98 98.51% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 4,446,474.29 1,153,982.48 4,043,031.81 4,255,155.15 82.85 191,236.29 95.70% Supplies 431,050.00 105,951.15 346,143.82 393,101.83 2,227.22 35,720.95 91.71% City Support Services 98,000.00 658.35 49,081.35 64,105.08 - 33,894.92 65.41% Utility Services 128,500.00 45,366.97 120,332.89 133,236.26 1,340.23 (6,076.49) 104.73% Operations Support 88,781.71 11,138.94 57,172.31 63,623.71 - 25,158.00 71.66% Staff Support 79,250.00 16,308.45 44,955.48 56,092.06 3,959.64 19,198.30 75.78% City Assistance 568,866.81 139,141.14 561,123.14 556,463.20 377.75 12,025.86 97.89% Professional Services 162,140.00 24,887.96 141,903.29 97,491.72 - 64,648.28 60.13% Fund Charges/Transfers 2,694,628.42 1,531,042.23 2,250,108.44 3,076,255.87 - (381,627.45) 114.16% Maintenance Services 12,000.00 6,720.00 12,480.00 11,819.00 - 181.00 98.49% Debt Service 288,895.00 (932.58) 28,408.96 113,548.78 - 175,346.22 39.30% Rental-Leasing 141,000.00 - 1,567.27 100,780.31 - 40,219.69 71.48% Operating Equipment 89,550.00 36,342.03 46,167.33 77,063.26 1,642.88 10,843.86 87.89% Capital Outlay 6,500.00 (6,500.00) - - - 6,500.00 0.00% TOTAL PUBLIC SAFETY 9,235,636.23 3,064,107.12 7,702,476.09 8,998,736.23 9,630.57 227,269.43 97.54% TOTAL EXPENDITURES 9,235,636.23 3,064,107.12 7,702,476.09 8,998,736.23 9,630.57 227,269.43 97.54% ** REVENUE OVER(UNDER) EXPENSES **109,678.96 (792,448.35) 49,737.94 207,077.98 (9,630.57) (87,768.45) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-456100 Ambulance/Mileage Transport 5,894,479.80 1,331,835.83 4,517,953.92 5,652,205.34 - 242,274.46 95.89% 000-456110 Passport Membership Fees 28,000.00 430.00 25,275.00 23,860.00 - 4,140.00 85.21% 000-456120 EMT Class - Fees 96,000.00 33,200.00 98,770.00 97,379.06 - (1,379.06) 101.44% 000-456122 CE Class - Fees 21,500.00 5,290.00 23,458.42 22,312.00 - (812.00) 103.78% 000-456130 Immunization Fees 7,000.00 480.00 3,008.17 2,763.74 - 4,236.26 39.48% 000-456140 Billing Fees - External 25,000.00 6,282.33 23,016.37 23,568.87 - 1,431.13 94.28% 000-456150 Standby Fees 27,000.00 3,675.05 38,517.80 25,184.55 - 1,815.45 93.28% 000-456155 Community Services Support 75,000.00 21,176.79 72,888.09 52,320.49 - 22,679.51 69.76% 000-456160 MIH Services 20,000.00 6,500.00 13,960.00 29,192.00 - (9,192.00) 145.96% 000-458110 Sales of Merchandise - GovDeal - 7,825.00 (62,327.44) 12,399.03 - (12,399.03) 0.00% 000-459200 NSF Check Fee 100.00 - 100.00 50.00 - 50.00 50.00% TOTAL Fees 6,194,079.80 1,416,695.00 4,754,620.33 5,941,235.08 - 252,844.72 95.92% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 843,577.17 - 843,578.00 843,578.04 - (0.87) 100.00% 000-474300 Cibolo Support 410,582.70 102,645.68 346,467.64 410,582.72 - (0.02) 100.00% 000-475100 Comal Co ESD #6 121,722.92 31,775.76 116,812.50 125,159.31 - (3,436.39) 102.82% 000-475200 Live Oak Support 232,140.26 58,035.07 213,151.96 232,140.28 - (0.02) 100.00% 000-475300 Universal City Support 300,091.66 75,022.92 281,283.72 300,091.68 - (0.02) 100.00% 000-475400 Selma Support 148,697.12 37,174.28 111,886.36 148,697.12 - - 100.00% 000-475500 Schertz Support 581,537.22 145,384.31 556,325.00 581,537.24 - (0.02) 100.00% 000-475600 Santa Clara Support 10,789.68 2,697.42 10,447.36 10,789.68 - - 100.00% 000-475800 Marion Support 16,346.66 4,086.67 15,186.96 16,346.68 - (0.02) 100.00% 000-475910 TASPP Program 360,000.00 - 366,852.96 492,224.32 - (132,224.32) 136.73% TOTAL Inter-Jurisdictional 3,025,485.39 456,822.11 2,861,992.46 3,161,147.07 - (135,661.68) 104.48% Miscellaneous 000-491000 Interest Earned 3,000.00 548.63 4,402.87 5,017.50 - (2,017.50) 167.25% 000-491200 Investment Income 750.00 3,238.28 6,236.78 9,919.24 - (9,169.24) 1322.57% 000-493203 Donations-EMS 2,000.00 - 913.00 625.44 - 1,374.56 31.27% 000-493205 Donations- Golf Tournament 10,000.00 - 18,595.00 (2,160.00) - 12,160.00 -21.60% 000-497000 Misc Income 50,000.00 381,849.77 49,965.83 48,056.37 - 1,943.63 96.11% 000-497100 Recovery of Bad Debt 60,000.00 525.40 55,487.76 2,977.40 - 57,022.60 4.96% 000-497110 Collection Agency-Bad Debt - 11,979.58 - 38,996.11 - (38,996.11) 0.00% TOTAL Miscellaneous 125,750.00 398,141.66 135,601.24 103,432.06 - 22,317.94 82.25% TOTAL REVENUES 9,345,315.19 2,271,658.77 7,752,214.03 9,205,814.21 - 139,500.98 98.51% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 95,206.89$ Cash in Investments EMS-Logic 558,493.95 SR 2017 Ambulance-Logic 58,424.80 Total Cash in Bank & Investments 712,125.64$ SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2019 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Permits 3,000.00 1,100.00 3,960.00 3,860 - (860.00) 128.67% Fees 1,208,500.00 298,360.83 1,159,910.28 1,200,722 - 7,778.29 99.36% Fund Transfers 1,027,062.00 - - 27,000 - 1,000,062.00 2.63% Miscellaneous 26,800.00 5,604.11 194,255.18 56,610 - (29,809.81) 211.23% TOTAL REVENUES 2,265,362.00 305,064.94 1,358,125.46 1,288,191.52 - 977,170.48 56.86% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 400,584.00 69,713.22 339,602.56 303,249.11 - 97,334.89 75.70% Supplies 5,700.00 1,517.58 4,772.81 4,516.54 - 1,183.46 79.24% City Support Services 1,000.00 - 6,873.54 3,266.01 - (2,266.01) 326.60% Utility Services 13,200.00 4,959.54 14,016.79 15,022.29 - (1,822.29) 113.81% Operations Support 1,000.00 - - - - 1,000.00 0.00% Staff Support 10,000.00 3,663.11 5,757.56 9,597.23 140.00 262.77 97.37% City Assistance 500.00 - 98.00 63.00 - 437.00 12.60% Professional Services 41,500.00 - 8,918.00 1,475.00 - 40,025.00 3.55% Fund Charges/Transfers 532,162.00 240,354.26 617,182.26 791,502.87 - (259,340.87) 148.73% Maintenance Services 30,000.00 28,433.00 1,089.91 32,767.04 - (2,767.04) 109.22% Other costs 200.00 3,106.25 100.00 100.00 - 100.00 50.00% Debt Service 121,212.50 (670.83) 8,206.13 5,535.06 - 115,677.44 4.57% Rental/Leasing 5,500.00 - - 55.00 - 5,445.00 1.00% Operating Equipment - - 6,812.05 4,474.12 - (4,474.12) 0.00% Capital Outlay 74,348.00 - - - - 74,348.00 0.00% TOTAL DRAINAGE 1,236,906.50 351,076.13 1,013,429.61 1,171,623.27 140.00 65,143.23 94.73% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 PROJECTS City Support Services 8,839.48 - - - - 8,839.48 0.00% Operations Support 1,228.52 (566.50) - - - 1,228.52 0.00% Professional Services 53,789.00 (9,451.50) - - - 53,789.00 0.00% Maintenance Services 949,807.00 (623,685.79) - - 13,048.52 936,758.48 1.37% TOTAL PROJECTS 1,013,664.00 (633,703.79) - - 13,048.52 1,000,615.48 1.29% TOTAL EXPENDITURES 2,250,570.50 (282,627.66) 1,013,429.61 1,171,623.27 13,188.52 1,065,758.71 52.64% ** REVENUE OVER(UNDER) EXPEND 14,791.50 587,692.60 344,695.85 116,568.25 (13,188.52) (88,588.23) 204-DRAINAGE CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000-432400 Floodplain Permit 3,000.00 1,100.00 3,960.00 3,860.00 - (860.00) 128.67% TOTAL Permits 3,000.00 1,100.00 3,960.00 3,860.00 - (860.00) 128.67% Fees 000-457500 Drainage Penalties 10,000.00 - 10,537.47 32.02 - 9,967.98 0.32% 000-457600 Drainage Fee 1,198,500.00 298,360.83 1,149,372.81 1,200,689.69 - (2,189.69) 100.18% TOTAL Fees 1,208,500.00 298,360.83 1,159,910.28 1,200,721.71 - 7,778.29 99.36% Fund Transfers 000-481000 Transfer In 1,027,062.00 - - 27,000.00 - 1,000,062.00 2.63% TOTAL Funds Transfers 1,027,062.00 - - 27,000 - 1,000,062.00 2.63% Miscellaneous 000-491000 Interest Earned 1,800.00 489.95 3,481.28 3,365.96 - (1,565.96) 187.00% 000-491200 Investment Interest 25,000.00 5,114.16 26,508.61 29,227.28 - (4,227.28) 116.91% 000-497000 Misc Income-Drainage - - 164,265.29 24,016.57 - (24,016.57) 0.00% TOTAL Miscellaneous 26,800.00 5,604.11 194,255.18 56,609.81 - (29,809.81) 211.23% TOTAL REVENUES 2,265,362.00 305,064.94 1,358,125.46 1,288,191.52 - 977,170.48 56.86% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 89,485.06$ Cash in Investments Lone Star Investment-Drainage Maint Fund 786,190.05 Total Cash in Bank & Investments 875,675.11$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2019 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 500,000.00 125,286.55 520,423.78 487,508.83 - 12,491.17 97.50% Miscellaneous 28,000.00 12,190.14 28,837.57 48,014.71 - (20,014.71) 171.48% TOTAL REVENUES 528,000.00 137,476.69 549,261.35 535,523.54 - (7,523.54) 101.42% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 110,650.00 21,004.83 85,797.47 87,133.37 - 23,516.63 78.75% Operations Support 65,500.00 4,511.00 32,375.17 14,941.00 - 50,559.00 22.81% Professional Services 3,000.00 1,705.43 4,276.13 28,189.26 - (25,189.26) 939.64% Fund Charges/Transfers 67,582.00 16,895.49 67,605.00 67,582.00 - - 100.00% Maintenance Services 10,000.00 - 7,879.35 - - 10,000.00 0.00% Capital Outlay - - 8,255.00 - - - 0.00% TOTAL NONDEPARTMENTAL 256,732.00 44,116.75 206,188.12 197,845.63 - 58,886.37 77.06% TOTAL EXPENDITURES 256,732.00 44,116.75 206,188.12 197,845.63 - 58,886.37 77.06% REVENUE OVER(UNDER) EXPENDITURE 271,268.00 93,359.94 343,073.23 337,677.91 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 37,118.24$ Cash in Investments Texas Class - Hotel Tax 2,117,237.30 Total Cash in Bank & Investments 2,154,355.54$ HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2019 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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 2014-15 44,724 42,229 35,309 33,055 46,037 58,530 43,715 43,525 53,346 72,297 51,772 39,195 $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 HOTEL OCCUPANCY TAX 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 70,000.00 - 139,000.00 11,000 - 59,000.00 15.71% Fund Transfers 76,512.00 - - - - 76,512.00 0.00% Miscellaneous 30,000.00 1,726.48 6,194.27 16,056.99 - 13,943.01 53.52% TOTAL REVENUES 176,512.00 1,726.48 145,194.27 27,056.99 - 149,455.01 15.33% EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services 10,000.00 - 16,139.30 4,839.51 5,881.49 (721.00) 107.21% Operating Equipment 5,000.00 - 1,352.96 9,510.60 - (4,510.60) 190.21% Capital Outlay 161,512.00 - 121,934.15 86,841.42 - 74,670.58 53.77% TOTAL PARKLAND DEDICATION 176,512.00 - 139,426.41 101,191.53 5,881.49 69,438.98 60.66% TOTAL EXPENDITURES 176,512.00 - 139,426.41 101,191.53 5,881.49 69,438.98 60.66% REVENUE OVER(UNDER) EXPEND - 1,726.48 5,767.86 (74,134.54) (5,881.49) 80,016.03 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458800 Parkland Dedication 70,000.00 - 139,000.00 11,000.00 - 59,000.00 15.71% TOTAL Fees 70,000.00 - 139,000.00 11,000.00 - 59,000.00 15.71% Fund Transfers 000-48100 Transfer In- Reserves 76,512.00 - - - - 76,512.00 0.00% TOTAL Fund Transfers 76,512.00 - - - - 76,512.00 0.00% Miscellaneous 000-491000 Interest Earned 750.00 292.26 766.06 1,018.86 - (268.86) 135.85% 000-491200 Investment Interest 7,000.00 1,434.22 5,428.21 6,067.63 - 932.37 86.68% 000-493700 Donations - 8,557.00 (8,557.00) 0.00% 000-497000 Misc Income - - - 413.50 - (413.50) 0.00% 000-499100 Transfer From Parks Reserve 22,250.00 - - - - 22,250.00 0.00% TOTAL Miscellaneous 30,000.00 1,726.48 6,194.27 16,056.99 - 13,943.01 53.52% TOTAL REVENUES 176,512.00 1,726.48 145,194.27 27,056.99 - 149,455.01 15.33% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Cash in Bank Current Claim on Operating Cash Pool-Checking 47,744.74 Cash in Investments Texas Class- Park Fund 242,924.92 Total in Investment Pool 242,924.92 Total Cash in Bank & Investments 290,669.66 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2019 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 1,100,000.00 378,486.00 1,544,962.40 1,061,672.40 - 38,327.60 96.52% Fund Transfers 1,375,000.00 - - - - 1,375,000.00 0.00% Miscellaneous 82,000.00 35,712.97 102,748.97 161,999.39 - (79,999.39) 197.56% TOTAL REVENUES 2,557,000.00 414,198.97 1,647,711.37 1,223,671.79 - 1,333,328.21 47.86% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 256,000.00 - 1,000.00 984.00 - 255,016.00 0.38% Fund Charges/Transfers 1,375,000.00 - - 1,375,000.00 - - 100.00% TOTAL NON DEPARTMENTAL 1,631,000.00 - 1,000.00 1,375,984.00 - 255,016.00 84.36% TOTAL MISC & PROJECTS - - - - - - 0.00% TOTAL EXPENDITURES 1,631,000.00 - 1,000.00 1,375,984.00 - 255,016.00 84.36% REVENUE OVER(UNDER) EXPENDITURES 926,000.00 414,198.97 1,646,711.37 (152,312.21) - 1,078,312.21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455900 Capital Recovery - Water 1,100,000.00 378,486.00 1,544,962.40 1,061,672.40 - 38,327.60 96.52% TOTAL Fees 1,100,000.00 378,486.00 1,544,962.40 1,061,672.40 - 38,327.60 96.52% Fund Transfers 000-481000 Transfer from Reserves 1,375,000.00 - - - - 1,375,000.00 0.00% TOTAL Fund Transfers 1,375,000.00 - - - - 1,375,000.00 - Miscellaneous - 000-491000 Interest Earned 7,000.00 499.30 5,527.07 3,382.96 - 3,617.04 48.33% 000-491200 Investment Income 75,000.00 35,213.67 97,221.90 158,616.43 - (83,616.43) 211.49% TOTAL Miscellaneous 82,000.00 35,712.97 102,748.97 161,999.39 - (79,999.39) 197.56% TOTAL REVENUES 2,557,000.00 414,198.97 1,647,711.37 1,223,671.79 - 1,333,328.21 47.86% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 272,353.09$ Cash in Investments Lone Star Investment-Capital Recovery Water 6,183,448.48 Total Cash in Bank & Investments 6,455,801.57$ CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2019 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 600,000.00 221,643.84 821,968.80 598,137 - 1,863.24 99.69% Fund Transfers - - - - - - 0.00% Miscellaneous 44,000.00 41,903.92 85,591.21 165,710 - (121,710.09) 376.61% TOTAL REVENUES 644,000.00 263,547.76 907,560.01 763,846.85 - (119,846.85) 118.61% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 260,500.00 1,121.53 5,360.28 5,420.60 - 255,079.40 2.08% Fund Charges/Transfers - - 487,848.00 - - - 0.00% TOTAL NON DEPARTMENTAL 260,500.00 1,121.53 493,208.28 5,420.60 - 255,079.40 2.08% TOTAL EXPENDITURES 260,500.00 1,121.53 493,208.28 5,420.60 - 255,079.40 2.08% REVENUE OVER(UNDER) EXPENDITURES 383,500.00 262,426.23 414,351.73 758,426.25 - (374,926.25) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455910 Capital Recovery - Waste Wtr 600,000.00 221,643.84 794,968.80 608,936.76 - (8,936.76) 101.49% 000-455913 Cap Recovery-North Sewer Tr - - 27,000.00 (10,800.00) - 10,800.00 0.00% TOTAL Fees 600,000.00 221,643.84 821,968.80 598,136.76 - 1,863.24 99.69% Fund Transfers 000-481000 Transfer from Reserves - - - - - - 0.00% TOTAL Fund Transfers - - - - - - 0.00% Miscellaneous 000-491000 Interest Earned 4,000.00 336.56 3,799.09 3,141.27 - 858.73 78.53% 000-491200 Investment Income 40,000.00 39,049.11 104,839.85 139,329.29 - (99,329.29) 348.32% 000-491800 Gain/Loss - (817.00) (11,125.56) (8,566.94) - 8,566.94 0.00% 000-491900 Unrealized Gain/Loss-Cap One - 3,335.25 (11,922.17) 31,806.47 - (31,806.47) 0.00% TOTAL Miscellaneous 44,000.00 41,903.92 85,591.21 165,710.09 - (121,710.09) 376.61% TOTAL REVENUES 644,000.00 263,547.76 907,560.01 763,846.85 - (119,846.85) 118.61% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 126,035.43$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 4,842,846.30 Capital One-Investment 1,807,956.79 Total Cash in Bank & Investments 6,776,838.52$ CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2019 505-TAX I&S CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 6,384,000.00 54,283.26 6,148,041.49 6,414,867.75 - (30,867.75) 100.48% Fund Transfers 113,723.00 - - - - 113,723.00 0.00% Miscellaneous 156,000.00 14,900.08 6,557,697.40 170,594.10 - (14,594.10) 109.36% TOTAL REVENUES 6,653,723.00 69,183.34 12,705,738.89 6,585,461.85 - 68,261.15 98.97% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 - 80,206.10 48,880.27 - (43,880.27) 977.61% Debt Service 6,648,723.27 1,009,227.36 6,816,133.75 6,678,977.48 - (30,254.21) 100.46% Other Financing Sources - - 6,159,622.75 - - - 0.00% TOTAL GENERAL GOVERNMENT 6,653,723.27 1,009,227.36 13,055,962.60 6,727,857.75 - (74,134.48) 101.11% - TOTAL EXPENDITURES 6,653,723.27 1,009,227.36 13,055,962.60 6,727,857.75 - (74,134.48) 101.11% ** REVENUE OVER(UNDER) EXPEND (0.27) (940,044.02) (350,223.71) (142,395.90) - 142,395.63 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 505-TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y-T-D BUDGET 100% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411900 Property Tax Revenue 6,384,000.00 54,283.26 6,148,041.49 6,414,867.75 - (30,867.75) 100.48% TOTAL Taxes 6,384,000.00 54,283.26 6,148,041.49 6,414,867.75 - (30,867.75) 100.48% 000-486000 Transfer From Reserves 113,723.00 - - - - 113,723.00 0.00% TOTAL Fund Transfers 113,723.00 - - - - 113,723.00 0.00% Miscellaneous 000-491000 Interest Earned 6,000.00 101.03 4,352.44 6,773.64 - (773.64) 112.89% 000-491200 Investment Earnings 50,000.00 14,799.05 57,575.96 44,102.08 - 5,897.92 88.20% 000-495015 Contribution from SED - - 360,769.00 - - - 0.00% 000-495020 Contribution from YMCA 100,000.00 - 100,000.00 100,000.00 - - 100.00% 000-497000 Misc Income - 276.80 - 276.81 - (276.81) 0.00% 000-498000 Proceeds From Refunding Debt - - 6,035,000.00 19,441.57 - (19,441.57) 0.00% TOTAL Miscellaneous 156,000.00 14,900.08 6,557,697.40 170,594.10 - (14,594.10) 109.36% TOTAL REVENUES 6,653,723.00 69,183.34 12,705,738.89 6,585,461.85 - 68,261.15 98.97% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF NON DEPARTMENTAL BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101-541500 Paying Agent 5,000.00 2,000.00 4,150.00 4,350.00 - 650.00 87.00% 101-541502 Cost of Bond Issuance - - 76,056.10 44,530.27 - (44,530.27) 0.00% TOTAL Professional Services 5,000.00 - 80,206.10 48,880.27 - (43,880.27) 0.87 Debt Service 101-555612 Bond-GO Refunding 2010-Principal 300,000.00 - 285,000.00 300,000.00 - - 100.00% 101-555612.1 Bond-GO Refunding 2010 Interest 29,700.00 - 38,475.00 4,500.00 - 25,200.00 15.15% 101-555629 GO Bond 2007-Principal 300,000.00 - 290,000.00 300,000.00 - - 100.00% 101-555629.1 GO Bond 2007-Interest 124,338.50 59,082.83 136,312.21 124,304.58 - 33.92 99.97% 101-555630 GO Bond SR2008 Principal - - 475,000.00 - - - 0.00% 101-555630.1 GO Bond SR2008 Interest - - 9,808.75 - - - 0.00% 101-555631 GO Bond SR2009 Principal 210,000.00 - 550,000.00 93,575.00 - 116,425.00 44.56% 101-555631.1 BO Bond SR2009 Interest 236,525.00 - 249,137.50 120,100.00 - 116,425.00 50.78% 101-555633 GO SR2011 Principal 250,000.00 - 240,000.00 250,000.00 - - 100.00% 101-555633.1 GO SR2011 Interest 318,462.50 157,043.75 327,037.50 318,462.50 - - 100.00% 101-555634 GO SR2011A Refund Principal 485,000.00 - 635,000.00 485,000.00 - - 100.00% 101-555634.1 GO SR2011A Refund Interest 74,734.75 34,322.51 87,700.56 74,515.01 - 219.74 99.71% 101-555635 GO SR2012 Principal 345,000.00 - 335,000.00 345,000.00 - - 100.00% 101-555635.1 GO SR2012 Interest 157,945.00 77,247.50 168,095.00 157,945.00 - - 100.00% 101-555636 Tax Note - SR2013 - Principal - - 170,000.00 - - - 0.00% 101-555636.1 Tax Note - SR2013 - Interest - - 1,445.00 - - - 0.00% 101-555637 Tax Note - SR 2013A - Principal - - 165,000.00 - - - 0.00% 101-555637.1 Tax Note - SR2013 - Interest - - 1,072.49 - - - 0.00% 101-555638 Bond-GO 2014 Refund-Principal 100,000.00 - 100,000.00 100,000.00 - - 100.00% 101-555638.1 Bond-GO 2014 Refund-Interest 286,775.00 142,637.50 289,775.00 286,775.00 - - 100.00% 101-555639 Tax Note - SR2015 - Principal 35,000.00 35,000.00 35,000.00 35,000.00 - - 100.00% 101-555639.1 Tax Note - SR2015 - Interest 1,925.00 962.50 2,531.77 1,922.95 - 2.05 99.89% 101-555640 Bond-Ref 2015 Bond- Principal 150,000.00 - 490,000.00 660,000.00 - (510,000.00) 440.00% 101-555640.1 Bond-GO Ref 2015- Interest 9,317.00 37,312.50 92,725.00 81,225.00 - (71,908.00) 871.79% 101-555641 Tax Note - SR2015A - Principal 660,000.00 150,000.00 145,000.00 150,000.00 - 510,000.00 22.73% 101-555641.1 Tax Note - SR2015A - Interest 81,225.00 4,658.51 11,506.58 9,267.39 - 71,957.61 11.41% 101-555642 GO Bond SR2016 Principal 215,000.00 - 205,000.00 215,000.00 - - 100.00% 101-555642.1 GO Bond SR2016 Interest 159,206.26 77,453.13 167,606.26 159,206.26 - - 100.00% 101-555643 CO Bond Tax SR2016 Principal 175,000.00 - 55,000.00 55,000.00 - 120,000.00 31.43% 101-555643.1 CO Bond Tax SR2016 Interest 62,668.76 22,381.25 47,237.50 45,587.50 - 17,081.26 72.74% 101-555644 CO Bond nonTax SR2016 Principal 55,000.00 - 165,000.00 175,000.00 - (120,000.00) 318.18% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF NON DEPARTMENTAL BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 101-555644 CO Bond nonTax SR2016 Interest 45,587.50 29,584.38 69,468.76 62,668.76 - (17,081.26) 137.47% 101-555645 CO Bond SR2017 Principal 280,000.00 - 245,000.00 280,000.00 - - 100.00% 101-555645.1 CO Bond SR2017 Interest 139,025.00 67,412.50 178,688.06 139,025.00 - - 100.00% 101-555646 Bond-GO SR2017 Principal 150,000.00 - 135,000.00 150,000.00 - - 100.00% 101-55646.1 Bond - GO SR2017 Interest 114,225.00 55,987.50 143,944.17 114,225.00 - - 100.00% 101-555647 Bond-GO 2018 Refund Principal 550,000.00 - 550,000.00 - 100.00% 101-555647.1 Bond - GO 2018 Refund Interest 122,112.00 58,141.00 73,566.64 122,112.00 - - 100.00% 101-555648 Bond-CO SR2018 - Principal - - 210,000.00 (210,000.00) 0.00% 101-555648.1 Bond-CO 2018 - Interest - - 214,951.05 - (214,951.05) 0.00% 101-555649 Bond-GO 2018 Ref - Principal - - 95,000.00 (95,000.00) 0.00% 101-555649.1 Bond-GO 2018 Ref - Interest - - 193,609.48 - (193,609.48) 0.00% 101-555900 Debt Service 424,951.00 - - - - 424,951.00 0.00% TOTAL Debt Service 6,648,723.27 1,009,227.36 6,816,133.75 6,678,977.48 - (30,254.21) 100.46% Other Financing Sources - - - - - 0.00% 101-556300 Payment to Refund Debt - - 6,159,622.75 - - - 0.00% TOTAL Other Financing Sources - - 6,159,622.75 - - - 0.00% TOTAL EXPENDITURES 6,653,723.27 1,009,227.36 13,055,962.60 6,727,857.75 - (74,134.48) 101.11% Cash in Bank Claim on Operating Cash Pool-Checking 46,746.12$ MBIA Investment- Tax I&S 910,716.40 Total Cash in Bank & Investments 957,462.52$ TAX I&S CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2019 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 4,242,580.00 985,186.70 3,153,311.12 3,277,614.12 - 964,965.88 77.26% Fund Transfers 1,249,164.00 - - - - 1,249,164.00 0.00% Miscellaneous 258,000.00 122,887.14 182,940.21 541,392.08 - (283,392.08) 209.84% TOTAL REVENUES 5,749,744.00 1,108,073.84 3,336,251.33 3,819,006.20 - 1,930,737.80 66.42% EXPENDITURE SUMMARY NONDEPARTMENTAL City Assistance 4,800,000.00 - - - - 4,800,000.00 0.00% TOTAL NONDEPARTMENTAL 4,800,000.00 - - - - 4,800,000.00 0.00% ECONOMIC DEVELOPMENT Personnel Services - - - - - - 0.00% Supplies 750.00 87.87 356.14 251.76 77.87 420.37 10.38% City Support Services 21,300.00 646.54 4,589.09 5,057.25 431.25 15,811.50 8.10% Utility Services 3,720.00 394.97 1,726.75 1,293.25 - 2,426.75 1571.57% Operations Support 122,500.00 22,415.31 56,211.62 58,462.53 2,421.91 61,615.56 10.87% Staff Support 21,400.00 2,569.75 9,993.75 10,890.98 39.00 10,470.02 0.95% City Assistance 252,500.00 87.65 425,098.32 164.88 - 252,335.12 6.11% Professional Services 66,300.00 12,803.50 15,260.13 15,415.67 - 50,884.33 690.16% Fund Charges/Transfers 457,574.00 - 802,945.00 457,574.00 - - 233.39% Maintenance Services 1,000.00 - 385.00 80.00 - 920.00 8.00% Operating Equipment 2,700.00 - 576.02 375.77 - 2,324.23 13.92% TOTAL ECONO DEVELOPMENT 949,744.00 39,005.59 1,317,141.82 549,566.09 2,970.03 397,207.88 58.18% TOTAL EXPENDITURES 5,749,744.00 39,005.59 1,317,141.82 549,566.09 2,970.03 5,197,207.88 9.61% ** REVENUE OVER(UNDER) EXPEND - 1,069,068.25 2,019,109.51 3,269,440.11 (2,970.03) (3,266,470.08) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 173,959.81$ Cash in Investments Texas Class Investment-Economic Development Corp 17,958,902.24 Schertz Bank & Trust-Certificate of Deposit 1,033,016.49 Schertz Bank & Trust-Certificate of Deposit 1,086,668.65 Total Cash in Bank & Investments 20,252,547.19$ SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2019