Loading...
Q4-September 2018CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2017 - 2018 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET General Fund, 101 Total Revenues 31,844,008.43 32,499,112.70 0.00 (655,104.27)102.06% Total General Government 6,469,588.88 6,348,597.59 2,673.92 118,317.37 98.17% Total Public Safety 13,932,707.32 13,304,662.91 66,781.04 561,263.37 95.97% Total Public Environment 1,393,885.95 1,232,137.13 156,823.62 4,925.20 99.65% Total Parks & Recreation 1,910,615.19 1,754,621.38 3,919.96 152,073.85 92.04% Total Cultural 970,451.96 945,611.35 215.99 24,624.62 97.46% Total Health 901,147.00 724,167.61 1,497.48 175,481.91 80.53% Total Internal Services 5,917,756.69 5,300,691.40 26,164.63 590,900.66 90.01% Total Misc & Projects 347,855.00 313,590.53 12,748.94 21,515.53 93.81% Total Expenditures 31,844,007.99 29,924,079.90 270,825.58 1,649,102.51 94.82% Revenue Over(Under) Expenditures 0.44 2,575,032.80 General Fund, 101 Total Cash in Bank & Investments 13,182,933.31 Special Events Fund, 106 Total Revenues 170,200.00 131,963.50 0.00 38,236.50 77.53% Total Expenditures 170,200.00 131,963.50 843.80 37,392.70 78.03% Revenue Over(Under) Expenditures 0.00 0.00 Special Events Fund, 106 Total Cash in Bank & Investments 34,171.23 Peg Fund, 110 Total Revenues 200,000.00 84,846.75 0.00 115,153.25 42.42% Total Expenditures 200,000.00 0.00 0.00 200,000.00 0.00% Revenue Over(Under) Expenditures 0.00 84,846.75 Peg Fund, 110 Total Cash in Bank & Investments 701,921.85 Water & Sewer, 202 Total Revenues 23,091,170.00 24,034,510.71 0.00 (943,340.71)104.09% Total Expenditures 23,577,474.00 21,778,080.80 418,856.40 1,380,536.80 94.14% Revenue Over(Under) Expenditures (486,304.00)2,256,429.91 Water & Sewer, 202 Total Cash in Bank & Investments 9,829,179.82 Quarterly Statement Schertz, Texas AS OF :SEPTEMBER 30, 2018 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ********************************* 2017 - 2018 ******************************** CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET EMS, 203 Total Revenues 9,020,712.72 7,996,309.94 0.00 1,024,402.78 88.64% Total Expenditures 9,007,172.81 8,201,381.89 23,432.43 782,358.49 91.31% Revenue Over(Under) Expenditures 13,539.91 (205,071.95) EMS, 203 Total Cash in Bank & Investments 253,012.41 Drainage, 204 Total Revenues 2,763,927.00 1,357,489.32 0.00 1,406,437.68 49.11% Total Expenditures 2,893,296.00 1,539,784.89 38,548.00 1,314,963.11 54.55% Revenue Over(Under) Expenditures (129,369.00)(182,295.57) Drainage, 204 Total Cash in Bank & Investments 1,537,243.85 Hotel Tax, 314 Total Revenues 563,650.00 549,261.35 0.00 14,388.65 97.45% Total Expenditures 322,836.00 204,988.12 0.00 117,847.88 63.50% Revenue Over(Under) Expenditures 240,814.00 344,273.23 Hotel Tax, 314 Total Cash in Bank & Investments 1,815,638.43 Park, 317 Total Revenues 239,829.69 145,848.42 0.00 93,981.27 60.81% Total Expenditures 239,829.69 139,499.16 61,411.63 38,918.90 83.77% Revenue Over(Under) Expenditures 0.00 6,349.26 Park, 317 Total Cash in Bank & Investments 374,160.45 Tree Mitigation, 319 Total Revenues 157,000.00 107,409.91 0.00 49,590.09 68.41% Total Expenditures 157,000.00 7,518.00 0.00 149,482.00 4.79% Revenue Over(Under) Expenditures 0.00 99,891.91 Tree Mitigation, 319 Total Cash in Bank & Investments 431,804.38 Capital Recovery Water, 411 Total Revenues 1,140,200.00 1,647,711.37 0.00 (507,511.37)144.51% Total Expenditures 256,000.00 1,000.00 0.00 255,000.00 0.39% Revenue Over(Under) Expenditures 884,200.00 1,646,711.37 Capital Recovery Water, 411 Total Cash in Bank & Investments 6,492,073.78 Quarterly Statement Schertz, Texas AS OF :SEPTEMBER 30, 2018 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ********************************* 2017 - 2018 ******************************** CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Capital Recovery Sewer, 421 Total Revenues 949,850.00 907,560.01 0.00 42,289.99 95.55% Total Expenditures 823,348.00 493,208.28 0.00 330,139.72 59.90% Revenue Over(Under) Expenditures 126,502.00 414,351.73 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 6,018,412.27 I&S, 505 Total Revenues 6,994,532.00 6,670,738.89 0.00 323,793.11 95.37% Total Expenditures 6,994,532.00 7,020,962.60 0.00 (26,430.60)100.38% Revenue Over(Under) Expenditures 0.00 (350,223.71) I&S, 505 Total Cash in Bank & Investments 1,099,858.42 SED Corporation, 620 Total Revenues 4,307,873.00 4,487,740.00 0.00 (179,867.00)104.18% Total Expenditures 2,434,865.00 1,745,172.72 0.00 689,692.28 71.67% Revenue Over(Under) Expenditures 1,873,008.00 2,742,567.28 SED Corporation, 620 Total Cash in Bank & Investments 17,062,360.94 Total Cash in Bank & Investments 58,832,771.14 Quarterly Statement Schertz, Texas AS OF :SEPTEMBER 30, 2018 101 GENERAL FUND 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 Taxes 19,581,110.00 2,274,724.06 18,449,209.63 20,497,620.83 - (916,510.83) 104.68% Franchises 2,229,264.43 677,985.40 2,213,196.75 2,365,623.69 - (136,359.26) 106.12% Permits 1,573,356.00 440,895.86 2,304,765.35 2,243,569.49 - (670,213.49) 142.60% Licenses 51,160.00 14,301.00 63,164.00 73,381.00 - (22,221.00) 143.43% Fees 2,126,546.00 665,816.65 2,661,260.51 2,587,846.74 - (461,300.74) 121.69% Fines 20,000.00 4,113.53 23,339.27 20,902.37 - (902.37) 104.51% Inter-Jurisdictional 873,008.00 309,854.64 876,885.08 887,255.98 - (14,247.98) 101.63% Fund Transfers 4,561,214.00 813,826.78 2,484,140.08 2,902,482.76 - 1,658,731.24 63.63% Miscellaneous 828,350.00 197,303.22 513,521.97 920,429.84 - (92,079.84) 111.12% TOTAL REVENUES 31,844,008.43 5,398,821.14 29,589,482.64 32,499,112.70 - (655,104.27) 102.06% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 36,871.00 8,263.86 33,360.97 35,479.29 14.40 1,377.31 96.26% Supplies 1,050.00 - 630.11 142.73 - 907.27 13.59% City Support Services 39,221.00 2,801.36 34,368.74 20,577.67 - 18,643.33 52.47% Utility Services 641.47 148.02 - 613.09 - 28.38 95.58% Operations Support 500.00 - 336.04 29.00 - 471.00 5.80% Staff Support 28,868.53 3,893.03 23,993.44 25,958.76 - 2,909.77 89.92% Operating Equipment - - 723.00 - - - 0.00% TOTAL CITY COUNCIL 107,152.00 15,106.27 93,412.30 82,800.54 14.40 24,337.06 77.29% CITY MANAGER Personnel Services 1,088,445.00 218,602.94 1,047,155.93 1,232,897.14 - (144,452.14) 113.27% Supplies 1,000.00 16.80 2,285.76 457.30 - 542.70 45.73% City Support Services 12,674.32 - 5,093.49 8,154.32 - 4,520.00 64.34% Utility Services - 625.69 232.87 1,634.74 - (1,634.74) 0.00% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2018 101 GENERAL FUND 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, 2018 Operations Support - - 23.98 - - - 0.00% Staff Support 27,060.68 4,959.28 22,977.32 15,252.01 305.66 11,503.01 57.49% Operating Equipment 1,000.00 1,446.99 - 1,446.99 - (446.99) 144.70% TOTAL CITY MANAGER 1,130,180.00 225,651.70 1,077,769.35 1,259,842.50 305.66 (129,968.16) 111.50% MUNICIPAL COURT Personnel Services 305,878.29 67,731.90 274,744.48 297,345.33 - 8,532.96 97.21% Supplies 2,000.00 718.40 1,622.95 1,667.58 - 332.42 83.38% City Support Services 157.86 - 430.76 157.86 - - 100.00% Operations Support 730.37 661.37 869.45 730.37 - - 100.00% Staff Support 6,944.50 2,575.48 4,963.62 5,465.11 - 1,479.39 78.70% Court Support 200.00 - 186.00 96.00 - 104.00 48.00% Professional Services 62,927.12 17,012.56 56,230.00 61,641.83 100.00 1,185.29 98.12% Maintenance Services 3,000.00 450.00 3,142.00 1,950.00 1,000.00 50.00 98.33% Operating Equipment - - 39.02 - - - 0.00% TOTAL MUNICIPAL COURT 381,838.14 89,149.71 342,228.28 369,054.08 1,100.00 11,684.06 96.94% CUSTOMER RELATIONS-311 Personnel Services 128,514.43 27,518.52 117,567.12 120,620.29 - 7,894.14 93.86% Supplies 150.00 16.62 40.30 88.92 - 61.08 59.28% Staff Support 815.00 55.98 170.00 102.96 - 712.04 12.63% Operating Equipment 600.00 - - 554.62 - 45.38 92.44% TOTAL CUSTOMER RELATIONS-311 130,079.43 27,591.12 117,777.42 121,366.79 - 8,712.64 93.30% PLANNING & ZONING Personnel Services 210,590.27 44,110.71 193,914.63 204,480.63 - 6,109.64 97.10% Supplies 1,851.80 834.77 1,450.79 1,273.68 - 578.12 68.78% Operations Support 150.00 155.00 70.29 162.20 - (12.20) 108.13% Staff Support 21,588.20 11,138.77 18,912.92 20,350.99 - 1,237.21 94.27% Professional Services 100.00 10.00 105 10 - 90.00 10.00% 101 GENERAL FUND 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, 2018 Operating Equipment 250.00 154.99 - 154.99 - 95.01 62.00% TOTAL PLANNING & ZONING 234,530.27 56,404.24 214,453.63 226,432.49 - 8,097.78 96.55% LEGAL SERVICES Operations Support 5,000.00 7,420.44 12,036.11 9,057.03 - (4,057.03) 181.14% Professional Services 155,000.00 39,315.72 138,661.71 111,945.18 - 43,054.82 72.22% TOTAL LEGAL SERVICES 181,938.20 46,736.16 150,697.82 121,002.21 - 38,997.79 66.51% CITY SECRETARY Personnel Services 192,704.83 43,064.12 180,387.02 186,900.57 - 5,804.26 96.99% Supplies 1,050.00 212.02 1,318.55 974.47 - 75.53 92.81% City Support Services 8,500.00 2,785.45 4,975.46 9,743.20 - (1,243.20) 114.63% Operations Support 100.00 - - 59.90 - 40.10 59.90% Staff Support 6,650.00 1,330.13 3,890.11 3,523.11 - 3,126.89 52.98% TOTAL CITY SECRETARY 209,004.83 47,391.72 190,571.14 201,201.25 - 7,803.58 96.27% NON-DEPARTMENTAL City Support Services 413,145.64 103,462.85 378,332.59 390,962.75 - 22,182.89 94.63% Operations Support 154,500.00 43,472.25 153,601.16 148,610.56 - 5,889.44 96.19% Staff Support 320.00 80.00 165.50 160.00 - 160.00 50.00% City Assistance 1,741,562.00 139,081.25 1,711,328.61 1,705,943.56 - 35,618.44 97.95% Professional Services 44,635.00 14,749.92 71,974.41 63,169.06 (18,534.06) 141.52% Fund Chrgs/Transfrs-Spec Events Fnd 143,733.00 108,615.51 37,446.70 108,615.51 - 35,117.49 75.57% TOTAL NON-DEPARTMENTAL 2,497,895.64 409,461.78 2,352,848.97 2,417,461.44 - 80,434.20 96.78% PUBLIC AFFAIRS Personnel Services 287,029.12 65,896.99 276,770.59 277,705.36 - 9,323.76 96.75% Supplies 2,770.00 700.94 1,295.51 2,124.89 - 645.11 76.71% Operations Support 21,184.88 3,923.07 15,165.16 16,241.05 - 4,943.83 76.66% Staff Support 4,230.00 1,333.33 2,670.00 3,253.00 108.00 869.00 79.46% Professional Services 3,100.00 - 22,900.00 3,120.00 - (20.00) 100.65% 101 GENERAL FUND 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, 2018 Operating Equipment 30.00 - 229.00 27.97 - 2.03 93.23% TOTAL PUBLIC AFFAIRS 318,344.00 71,854.33 319,030.26 302,472.27 108.00 15,763.73 95.05% RECORDS MANAGEMENT Personnel Services 49,668.83 12,066.17 37,907.53 47,904.87 - 1,763.96 96.45% Supplies 100.00 - 31.22 - - 100.00 0.00% Staff Support 355.00 55.00 - 285.53 - 69.47 80.43% Professional Services 15,985.17 2,817.96 9,740.85 14,526.71 - 1,458.46 90.88% TOTAL RECORDS MANAGEMENT 66,109.00 14,939.13 47,679.60 62,717.11 - 3,391.89 94.87% SCHERTZ MAGAZINE Personnel Services 130,598.67 29,447.48 128,997.01 126,786.53 - 3,812.14 97.08% Supplies 200.00 49.99 180.85 90.57 - 109.43 45.29% Opperations Support 2,600.00 90.00 985.25 1,670.09 - 929.91 64.23% Staff Support 3,330.00 885.46 1,500.72 2,956.65 - 373.35 88.79% Professional Services 248,754.33 49,175.88 218,160.44 238,966.43 - 9,787.90 96.07% Fund Charges/Transfers 10,000.00 - - - - 10,000.00 0.00% Operating Equipment - - 125.98 - - - 0.00% TOTAL SCHERTZ MAGAZINE 395,483.00 79,648.81 349,950.25 370,470.27 - 25,012.73 93.68% ENGINEERING Personnel Services 635,710.08 143,171.05 464,056.07 615,695.37 - 20,014.71 96.85% Supplies 1,572.30 832.48 1,615.50 1,324.25 - 248.05 84.22% City Support Services 650.00 - 295.20 650.00 - - 100.00% Utility Services 3,500.00 1,062.73 1,190.43 2,907.51 - 592.49 83.07% Operations Support 47.70 - 101.94 47.70 - - 100.00% Staff Support 9,670.00 6,097.45 6,431.20 8,885.61 - 784.39 91.89% Professional Services 7,775.92 7,633.21 63,578.90 11,110.71 - (3,334.79) 142.89% Rental/Leasing - - 2,824.47 - - - 0.00% 101 GENERAL FUND 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, 2018 Operating Equipment 400.00 - 358.93 - - 400.00 0.00% TOTAL ENGINEERING 659,326.00 158,796.92 540,452.64 640,621.15 - 18,704.85 97.16% GIS Personnel Services 171,851.57 38,269.57 155,410.11 166,621.93 - 5,229.64 96.96% Supplies 1,740.00 233.08 2,226.05 486.94 1,145.86 107.20 93.84% Staff Support 3,970.00 704.00 4,014.90 3,962.82 - 7.18 99.82% Rental/Leasing 2,085.00 520.95 2,083.80 2,083.80 - 1.20 99.94% TOTAL GIS 179,646.57 39,727.60 163,734.86 173,155.49 1,145.86 5,345.22 97.02% TOTAL GENERAL GOVERNMENT 6,470,832.88 1,282,459.49 5,960,606.52 6,348,597.59 2,673.92 119,561.37 98.15% PUBLIC SAFETY POLICE Personnel Services 6,429,458.00 1,483,226.82 5,921,588.71 6,233,131.56 - 196,326.44 96.95% Supplies 57,291.80 11,420.68 82,014.67 49,090.94 15.39 8,185.47 85.71% City Support Services 21,500.00 - 21,294.42 24,229.52 - (2,729.52) 112.70% Utility Services 90,302.00 34,552.20 78,640.89 89,016.75 - 1,285.25 98.58% Operations Support 3,735.00 1,488.00 2,074.64 2,991.25 - 743.75 80.09% Staff Support 133,724.43 42,195.08 119,986.61 116,334.36 4,039.75 13,350.32 90.02% City Assistance 23,222.00 11,845.10 16,259.49 19,714.79 - 3,507.21 84.90% Professional Services 49,948.00 8,691.17 48,012.49 53,305.47 - (3,357.47) 106.72% Maintenance Services 54,645.00 22,210.74 45,219.68 53,577.95 - 1,067.05 98.05% Rental/Leasing - - 44,158.64 - - - 0.00% Operating Equipment 100,952.80 53,188.84 133,713.79 78,831.29 - 22,121.51 78.09% Capital Outlay 578,932.56 52,947.70 357,603.28 529,427.76 37,052.20 12,452.60 97.85% TOTAL POLICE 7,543,711.59 1,721,766.33 6,870,567.31 7,249,651.64 41,107.34 252,952.61 96.65% FIRE RESCUE Personnel Services 4,338,043.93 1,031,872.52 3,647,597.31 4,198,761.14 - 139,282.79 96.79% 101 GENERAL FUND 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, 2018 Supplies 18,200.00 5,162.58 4,961.48 12,243.84 1,343.82 4,612.34 74.66% Utility Services 53,650.00 20,865.63 49,079.35 48,958.42 - 4,691.58 91.26% Operations Support 550.00 84.00 - 142.00 - 408.00 25.82% Staff Support 163,875.00 42,644.07 136,416.38 157,728.32 1,527.66 4,619.02 97.18% City Assistance 20,000.00 8,351.66 22,489.59 15,182.98 3,977.28 839.74 95.80% Professional Services 27,500.00 2,450.00 32,696.00 25,875.00 - 1,625.00 94.09% Maintenance Services 73,000.00 13,728.18 40,402.71 58,967.71 4,637.55 9,394.74 87.13% Other Costs - 11,738.64 611.01 15,159.58 - (15,159.58) 0.00% Rental/Leasing 23,500.00 3,950.82 15,915.65 15,915.65 - 7,584.35 67.73% Operating Equipment 107,800.00 43,968.48 89,154.10 83,365.77 13,788.60 10,645.63 90.12% Capital Outlay 112,350.00 42,163.98 37,207.23 121,816.53 - (9,466.53) 108.43% TOTAL FIRE RESCUE 4,938,468.93 1,226,980.56 4,076,530.81 4,754,116.94 25,274.91 159,077.08 96.78% INSPECTIONS Personnel Services 651,832.80 150,445.67 578,865.84 630,528.15 - 21,304.65 96.73% Supplies 3,022.00 1,317.03 2,836.28 2,548.66 330.76 142.58 95.28% Utility Services 4,650.00 1,535.12 3,747.36 4,460.92 - 189.08 95.93% Operations Support 2,000.00 870.80 1,845.47 1,780.80 - 219.20 89.04% Staff Support 24,350.00 12,279.01 18,063.38 22,986.33 - 1,363.67 94.40% Professional Services 268,700.00 136,650.00 206,557.50 260,540.00 - 8,160.00 96.96% Operating Equipment 5,500.00 1,017.73 - 5,390.79 - 109.21 98.01% TOTAL INSPECTIONS 960,054.80 304,115.36 811,915.83 928,235.65 330.76 31,488.39 96.72% MARSHAL'S OFFICE Personnel Services 451,997.00 79,190.31 446,313.01 348,908.37 - 103,088.63 77.19% Supplies 3,475.00 67.15 2,312.65 2,844.09 68.03 562.88 83.80% Utility Services 8,500.00 2,055.24 6,173.23 6,241.64 - 2,258.36 73.43% Operations Support 1,000.00 - 274.85 106.00 - 894.00 10.60% Staff Support 11,900.00 1,556.48 5,507.88 5,546.11 - 6,353.89 46.61% City Assistance 2,750.00 - - - - 2,750.00 0.00% Maintenance Services 5,100.00 2,700.00 3,700.00 4,256.00 - 844.00 83.45% 101 GENERAL FUND 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, 2018 Operating Equipment 5,750.00 2,125.00 17,698.62 4,756.47 - 993.53 82.72% TOTAL MARSHAL'S OFFICE 490,472.00 87,694.18 481,980.24 372,658.68 68.03 117,745.29 75.99% TOTAL PUBLIC SAFETY 13,932,707.32 3,340,556.43 12,240,994.19 13,304,662.91 66,781.04 561,263.37 95.97% PUBLIC ENVIRONMENT STREETS Personnel Services 797,135.95 177,543.03 730,407.51 774,776.68 - 22,359.27 97.20% Supplies 81,050.00 25,224.09 92,867.79 80,276.07 221.56 552.37 99.32% Utility Services 149,200.00 58,977.77 167,422.73 172,994.08 - (23,794.08) 115.95% Staff Support 11,600.00 3,423.16 11,586.25 10,495.91 204.32 899.77 92.24% Professional Services 20,790.00 10,256.00 71,704.50 18,193.00 - 2,597.00 87.51% Maintenance Services 71,400.00 2,565.00 40,093.97 71,385.79 - 14.21 99.98% Rental/Lease 3,210.00 - 2,763.23 3,200.57 - 9.43 99.71% Operating Equipment 6,800.00 1,852.17 12,132.62 6,661.87 - 138.13 97.97% Capital Outlay 252,700.00 53,418.00 135,808.04 94,153.16 156,397.74 2,149.10 99.15% TOTAL STREETS 1,393,885.95 333,259.22 1,264,786.64 1,232,137.13 156,823.62 4,925.20 99.65% TOTAL PUBLIC ENVIRONMENT 1,393,885.95 333,259.22 1,264,786.64 1,232,137.13 156,823.62 4,925.20 99.65% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 471,723.97 101,435.26 496,445.54 459,135.58 - 12,588.39 97.33% Supplies 72,980.12 19,524.37 38,934.20 71,157.74 1,832.19 (9.81) 100.01% City Support Services 10,507.81 2,955.97 12,005.27 10,436.54 - 71.27 99.32% Utility Services 243,884.00 81,955.51 247,033.27 248,867.21 - (4,983.21) 102.04% Operations Support 998.97 120.00 1,673.20 998.97 - - 100.00% Staff Support 8,608.78 919.83 10,351.13 8,200.38 135.00 273.40 96.82% 101 GENERAL FUND 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, 2018 Professional Services 115,837.60 72,873.34 90,230.14 115,891.58 1,757.82 (1,811.80) 101.56% Maintenance Services 18,401.52 271.45 17,352.00 13,718.01 - 4,683.51 74.55% Rental/Leasing 29,214.44 963.21 37,299.06 29,493.86 - (279.42) 100.96% Operating Equipment 22,097.76 7,523.18 19,023.71 24,066.67 - (1,968.91) 108.91% Capital Outlay 70,408.22 56,129.68 - 70,408.22 - - 100.00% TOTAL PARKS DEPARTMENT 1,064,663.19 344,671.80 970,347.52 1,052,374.76 3,725.01 8,563.42 99.20% SWIM POOL Personnel Services - - - - - 0.00% Supplies 24,070.05 12,069.75 25,814.10 20,294.84 194.95 3,580.26 85.13% Utility Services 25,500.00 16,737.61 24,900.34 27,454.75 - (1,954.75) 107.67% Professional Services - - 3,632.56 - - - 0.00% Maintenance Services 643,376.13 267,623.98 574,709.38 529,216.51 - 114,159.62 82.26% Operating Equipment 1,031.82 - - 1,031.82 - - 100.00% TOTAL SWIM POOL 693,978.00 296,431.34 629,056.38 577,997.92 194.95 115,785.13 83.32% EVENT FACILITIES Personnel Services 60,584.00 2,379.48 52,855.02 48,446.26 - 12,137.74 79.97% Supplies 5,000.00 723.12 3,351.80 3,766.19 - 1,233.81 75.32% Utility Services 52,600.00 18,996.83 47,116.43 43,784.97 - 8,815.03 83.24% Operations Support 9,600.00 11,694.27 4,949.05 15,537.86 - (5,937.86) 161.85% Staff Support 2,090.00 (110.00) 1,351.35 541.83 - 1,548.17 25.92% Operating Equipment 22,100.00 3,854.16 7,664.98 12,171.59 - 9,928.41 55.08% TOTAL EVENT FACILITIES 151,974.00 37,537.86 117,288.63 124,248.70 - 27,725.30 81.76% TOTAL PARKS & RECREATION 1,910,615.19 678,641.00 1,716,692.53 1,754,621.38 3,919.96 152,073.85 92.04% CULTURAL LIBRARY Personnel Services 771,601.96 166,228.14 728,194.90 749,870.60 - 21,731.36 97.18% 101 GENERAL FUND 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, 2018 Supplies 15,500.00 7,226.50 13,241.43 13,842.15 - 1,657.85 89.30% Utility Services 55,500.00 29,232.60 46,976.90 59,473.22 - (3,973.22) 107.16% Operations Support 4,200.00 697.97 1,499.88 3,845.89 215.99 138.12 96.71% Staff Support 7,375.00 24.00 5,519.67 4,742.01 - 2,632.99 64.30% Professional Services 2,275.00 - 2,252.00 2,318.00 - (43.00) 101.89% Maintenance Services 1,500.00 - - - - 1,500.00 0.00% Operating Equipment 112,500.00 18,778.15 106,800.36 111,519.48 - 980.52 99.13% TOTAL LIBRARY 970,451.96 222,187.36 904,485.14 945,611.35 215.99 24,624.62 97.46% TOTAL CULTURAL 970,451.96 222,187.36 904,485.14 945,611.35 215.99 24,624.62 97.46% HEALTH ANIMAL SERVICES Personnel Services 338,061.00 67,976.02 304,804.24 286,958.35 - 51,102.65 84.88% Supplies 35,380.00 12,413.17 35,015.92 32,625.52 - 2,754.48 92.21% City Support Services 1,500.00 - 2,111.83 791.96 - 708.04 52.80% Utility Services 58,843.00 26,022.90 60,217.39 52,284.70 - 6,558.30 88.85% Operations Support 257.00 186.00 711.98 442.07 - (185.07) 172.01% Staff Support 7,900.00 2,662.58 6,864.12 5,931.92 581.96 1,386.12 82.45% City Assistance 18,500.00 8,042.30 15,637.54 19,117.62 - (617.62) 103.34% Professional Services 24,000.00 9,233.51 21,606.46 20,780.52 300.00 2,919.48 87.84% Maintenance Services 41,080.00 14,600.95 12,163.92 16,695.95 85.27 24,298.78 40.85% Operating Equipment 33,050.00 16,282.36 8,922.13 24,326.76 510.15 8,213.09 75.15% Capital Outlay 62,000.00 64,911.68 87,605.30 64,911.68 - (2,911.68) 104.70% TOTAL ANIMAL SERVICES 620,571.00 222,331.47 555,660.83 524,867.05 1,477.38 94,226.57 84.82% ENVIRONMENTAL HEALTH Personnel Services 201,501.00 18,844.48 185,962.66 134,623.60 - 66,877.40 66.81% Supplies 1,700.00 326.99 695.33 800.44 20.10 879.46 48.27% 101 GENERAL FUND 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, 2018 Operations Support 800.00 31.00 702.61 242.00 - 558.00 30.25% Staff Support 5,750.00 1,190.96 4,240.76 3,929.76 - 1,820.24 68.34% City Assistance 1,000.00 - 900.81 337.98 - 662.02 33.80% Professional Services 20,500.00 6,715.00 481.00 18,770.00 - 1,730.00 91.56% Maintenance Services 12,000.00 1,825.00 8,225.00 7,123.50 - 4,876.50 59.36% Operating Equipment 2,300.00 - 3,670.74 1,666.74 - 633.26 72.47% Capital Outlay 35,025.00 6,201.54 - 31,806.54 - 3,218.46 90.81% TOTAL ANIMAL SERVICES 280,576.00 35,134.97 204,878.91 199,300.56 20.10 81,255.34 71.04% TOTAL HEALTH 901,147.00 257,466.44 760,539.74 724,167.61 1,497.48 175,481.91 80.53% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 572,776.72 132,617.70 483,227.08 554,889.45 - 17,887.27 96.88% Supplies 7,100.00 412.00 6,681.44 7,173.48 - (73.48) 101.03% City Support Services 803,125.68 132,052.91 555,608.79 683,465.38 18,182.50 101,477.80 87.36% Utility Services 210,474.00 51,601.28 199,888.52 197,473.11 - 13,000.89 93.82% Staff Support 40,000.00 6,622.23 29,832.25 32,833.86 - 7,166.14 82.08% Professional Services 249,137.00 1,320.00 - 7,065.10 - 242,071.90 2.84% Maintenance Services 14,692.00 1,928.72 16,313.54 12,027.58 - 2,664.42 81.86% Rental/Leasing - - 33,457.32 - - - Operating Equipment 270,498.68 100,136.30 219,734.41 262,497.21 3,729.47 4,272.00 98.42% Capital Outlay 75,000.00 78,774.47 - 80,384.43 - (5,384.43) 107.18% TOTAL INFORMATION TECHNOLOGY 2,242,804.08 505,465.61 1,544,743.35 1,837,809.60 21,911.97 383,082.51 82.92% HUMAN RESOURCES Personnel Services 409,601.75 97,219.04 332,663.07 404,675.74 - 4,926.01 98.80% Supplies 1,000.00 299.35 925.81 823.37 - 176.63 82.34% Human Services 68,075.00 23,040.36 52,824.51 61,427.27 3,572.16 3,075.57 95.48% 101 GENERAL FUND 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, 2018 City Support Services 204.36 - 311.40 204.36 - - 100.00% Utility Services 455.88 113.97 - 455.88 - - 100.00% Operations Support 8,507.76 2,032.98 6,940.80 8,339.18 - 168.58 98.02% Staff Support 10,932.00 3,558.13 14,672.23 11,072.97 28.00 (168.97) 101.55% City Assistance 12,000.00 2,790.00 9,729.50 10,535.00 560.00 905.00 92.46% Professional Services 9,258.71 2,234.25 9,437.00 9,162.00 - 96.71 98.96% Operating Equipment 580.00 613.47 1,234.92 613.47 - (33.47) 105.77% TOTAL HUMAN RESOURCES 520,615.46 131,901.55 428,739.24 507,309.24 4,160.16 9,146.06 98.24% FINANCE Personnel Services 584,989.00 107,362.23 564,954.66 524,327.50 - 60,661.50 89.63% Supplies 4,160.00 1,209.61 4,893.64 3,621.87 - 538.13 87.06% City Support Services - - - 138.00 - (138.00) 0.00% Operations Support 1,655.00 - 1,916.64 1,200.00 - 455.00 72.51% Staff Support 9,495.00 2,640.08 5,468.50 7,938.56 - 1,556.44 83.61% Professional Sevices 32,470.00 13,250.00 24,255.00 29,255.00 - 3,215.00 90.10% Operating Equipment 3,770.00 - 2,969.52 - - 3,770.00 0.00% TOTAL FINANCE 636,539.00 124,461.92 604,457.96 566,480.93 - 70,058.07 88.99% PURCHASING & ASSET MGT Personnel Services 207,405.00 46,790.24 181,478.80 196,414.32 - 10,990.68 94.70% Supplies 1,050.00 523.17 4,455.35 703.74 - 346.26 67.02% Utility Services 250.00 59.99 222.78 253.34 - (3.34) 101.34% Operations Support 3,150.00 1,048.50 26.35 1,101.65 - 2,048.35 34.97% Staff Support 6,054.00 662.06 3,513.31 3,228.67 - 2,825.33 53.33% City Assistance 3,000.00 291.00 1,711.00 714.00 - 2,286.00 23.80% Operating Equipment 546.00 - 450.76 545.99 - 0.01 100.00% Capital Outlay 29,000.00 28,058.22 - 28,058.22 - 941.78 96.75% TOTAL PURCHASING & ASSET MGT 250,455.00 77,433.18 191,858.35 231,019.93 - 19,435.07 92.24% FLEET SERVICE Personnel Services 317,173.00 66,859.98 340,129.14 300,963.73 - 16,209.27 94.89% 101 GENERAL FUND 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, 2018 Supplies 173,481.34 52,238.64 165,709.30 166,482.20 92.50 6,906.64 96.02% City Support Services 6,500.00 - 3,649.40 13,117.77 - (6,617.77) 201.81% Utility Services 8,500.00 3,619.46 8,392.90 10,578.32 - (2,078.32) 124.45% Operations Support 200.00 - 59.69 - - 200.00 0.00% Staff Support 12,238.31 2,148.82 9,346.66 8,674.15 - 3,564.16 70.88% Maintenance Services 191,250.00 47,356.50 160,906.02 183,375.02 - 7,874.98 95.88% Operating Equipment 8,790.35 7,493.49 7,758.36 8,790.35 - - 100.00% Capital Outlay 74,000.00 150.00 - 26,641.00 - 47,359.00 36.00% TOTAL FLEET SERVICE 792,133.00 179,866.89 695,951.47 718,622.54 92.50 73,417.96 90.73% FACILITY SERVICES Personnel Services 790,334.94 175,199.83 777,294.47 764,415.72 - 25,919.22 96.72% Supplies 110,635.00 26,819.83 103,737.13 109,596.41 - 1,038.59 99.06% City Support Services 10,219.00 - - - - 10,219.00 0.00% Utility Services 159,515.00 81,412.80 149,296.25 182,716.08 - (23,201.08) 114.54% Operation Support 20,633.06 5,936.64 - 30,671.31 - (10,038.25) 148.65% Staff Support 10,100.00 3,515.28 10,380.86 8,747.11 - 1,352.89 86.61% Professional Services 46,333.01 17,968.40 - 46,333.01 - - 100.00% Maintenance Services 232,794.14 56,932.07 333,948.88 211,663.18 - 21,130.96 90.92% Rental/Leasing 5,850.00 1,640.00 2,210.69 4,717.95 - 1,132.05 80.65% Operating Equipment 21,385.00 19,351.93 2,463.34 21,271.95 - 113.05 99.47% Capital Outlay 67,411.00 59,316.44 25,825.70 59,316.44 - 8,094.56 87.99% TOTAL BUILDING MAINTENANCE 1,475,210.15 448,093.22 1,405,157.32 1,439,449.16 - 35,760.99 97.58% TOTAL INTERNAL SERVICE 5,917,756.69 1,467,222.37 4,870,907.69 5,300,691.40 26,164.63 590,900.66 90.01% 101 GENERAL FUND 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, 2018 MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 313,872.00 81,202.71 298,164.28 298,623.06 10,248.94 5,000.00 98.41% Operating Equipment 12,000.00 - - 8,467.47 - 3,532.53 70.56% TOTAL CITY ASSISTANCE 325,872.00 81,202.71 298,164.28 307,090.53 10,248.94 8,532.53 97.38% COURT - RESTRICTED FUNDS Operating Equipment 21,983.00 6,500.00 357.00 6,500.00 2,500.00 12,983.00 40.94% TOTAL CITY ASSISTANCE 21,983.00 6,500.00 357.00 6,500.00 2,500.00 12,983.00 40.94% TOTAL MISC & PROJECTS 347,855.00 87,702.71 298,521.28 313,590.53 12,748.94 21,515.53 93.81% TOTAL EXPENDITURES 31,844,007.99 7,669,495.02 28,017,533.73 29,924,079.90 270,825.58 1,649,102.51 94.82% REVENUE OVER(UNDER) EXPEND.0.44 (2,270,673.88) 1,571,948.91 2,575,032.80 (270,825.58) (2,304,206.78) 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 11,726,025.00 77,853.11 - 11,128,370.29 11,849,651.59 - (123,626.59) 101.05% 000-411200 Advalorem Tax - Delinquent 50,000.00 32,233.58 - (192.28) 73,377.91 - (23,377.91) 146.76% 000-411300 Advalorem Tax - P&I 50,000.00 14,555.26 - 54,758.65 85,694.43 - (35,694.43) 171.39% 000-411500 Sales Tax Revenue-Gen Fund 7,711,085.00 2,139,485.10 - 7,223,573.55 8,445,501.73 - (734,416.73) 109.52% 000-411600 Bingo Tax - - - 31.25 11.25 - (11.25) 0.00% 000-411700 Mixed Beverage Tax 44,000.00 10,597.01 - 42,668.17 43,383.92 - 616.08 98.60% TOTAL Taxes 19,581,110.00 2,274,724.06 - 18,449,209.63 20,497,620.83 - (916,510.83) 104.68% Franchises 000-421200 Center Point/Entex Energy 67,793.07 13,575.04 - 68,524.38 80,098.73 - (12,305.66) 118.15% 000-421220 City Public Service 946,887.77 232,250.39 - 910,770.55 939,032.20 - 7,855.57 99.17% 000-421240 Guadalupe Valley Elec Co-op 416,134.03 126,361.97 - 423,897.53 445,505.21 - (29,371.18) 107.06% 000-421250 New Braunfels Utilities 75,393.90 21,402.43 - 69,790.28 71,993.56 - 3,400.34 95.49% 000-421300 Time Warner-State Franchise 269,019.90 103,489.35 - 273,988.62 334,613.44 - (65,593.54) 124.38% 000-421460 AT&T Franchise Fee 191,123.61 42,419.25 - 200,597.11 143,060.79 - 48,062.82 74.85% 000-421480 Other Telecom Franchise 113,964.44 97,841.19 - 135,723.62 197,094.31 - (83,129.87) 172.94% 000-421500 Solid Waste Franchise Fee 148,947.71 40,645.78 - 129,904.66 154,225.45 - (5,277.74) 103.54% TOTAL Franchises 2,229,264.43 677,985.40 - 2,213,196.75 2,365,623.69 - (136,359.26) 106.12% Permits 000-431100 Home Occupation Permit 500.00 - - 490.00 490.00 - 10.00 98.00% 000-431205 Building Permit - Residential 573,156.00 165,383.00 - 630,838.50 688,248.50 - (115,092.50) 120.08% 000-431210 Building Permit - Commercial 370,400.00 45,593.00 - 630,642.00 687,367.50 - (316,967.50) 185.57% 000-431215 Building Permit - General 150,000.00 108,863.00 - 534,711.00 329,072.00 - (179,072.00) 219.38% 000-431300 Mobile Home Permit 300.00 100.00 - 300.00 350.00 - (50.00) 116.67% 000-431400 Signs Permit 6,000.00 1,797.00 - 5,482.00 5,458.00 - 542.00 90.97% 000-431500 Food Establishmnt Permit 60,000.00 3,060.00 - 62,715.00 60,950.00 - (950.00) 101.58% 000-431600 Garage Sale Permit 10,500.00 - - 9,490.00 2,135.00 - 8,365.00 20.33% 000-431700 Plumbing Permit 121,000.00 35,256.15 - 139,490.30 161,472.10 - (40,472.10) 133.45% 000-431750 Electrical Permit 61,000.00 20,300.00 - 71,500.00 82,140.00 - (21,140.00) 134.66% 000-431800 Mechanical Permit 62,000.00 19,480.00 - 71,800.00 76,940.00 - (14,940.00) 124.10% 000-431900 Solicitor/Peddler Permit 1,500.00 710.00 - 1,484.50 2,620.00 - (1,120.00) 174.67% 000-431950 Animal/Pet Permit 1,000.00 - - 365.00 90.00 - 910.00 9.00% 000-432000 Cert. of Occupancy Prmt 7,000.00 1,900.00 - 5,650.00 6,450.00 - 550.00 92.14% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2018 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, 2018 000-432100 Security Alarm Permit 36,000.00 14,951.00 - 40,355.66 51,114.00 - (15,114.00) 141.98% 000-432300 Grading/Clearing Permit 7,000.00 2,003.95 - 9,046.00 14,645.67 - (7,645.67) 209.22% 000-432400 Development Permit 81,000.00 15,697.60 61,037.39 39,252.08 41,747.92 48.46% 000-435000 Fire Permit 25,000.00 5,801.16 - 29,368.00 33,024.64 - (8,024.64) 132.10% 000-436010 Network Nodes - - - 1,750.00 - (1,750.00) 0.00% TOTAL Permits 1,573,356.00 440,895.86 - 2,304,765.35 2,243,569.49 - (670,213.49) 142.6% Licenses 000-441000 Alcohol Beverage License 8,000.00 1,570.00 - 7,075.00 7,085.00 - 915.00 88.56% 000-441300 Mobile Home License 160.00 - - 160.00 80.00 - 80.00 50.00% 000-442000 Contractors License 40,000.00 12,150.00 - 52,600.00 63,660.00 - (23,660.00) 159.15% 000-444000 Pet License 3,000.00 581.00 - 3,329.00 2,556.00 - 444.00 85.20% TOTAL Licenses 51,160.00 14,301.00 - 63,164.00 73,381.00 - (22,221.00) 143.43% Fees 000-451000 Municipal Court Fines 682,252.00 181,368.00 - 742,592.36 642,040.85 - 40,211.15 94.11% 000-451100 Arrest Fee 21,714.00 8,275.90 - 28,080.08 24,742.97 - (3,028.97) 113.95% 000-451110 Expunction Fee 120.00 - - 90.00 - - 120.00 0.00% 000-451200 Warrant Fees 124,000.00 16,460.50 - 102,156.33 75,203.31 - 48,796.69 60.65% 000-451210 Court - Claims & Judgements - (806.10) - (1,855.50) - - - 0.00% 000-451340 Judicial Fee - City 3,152.00 1,061.91 - 3,853.63 3,314.98 - (162.98) 105.17% 000-451400 Traffic Fine Costs TTL 10,265.00 4,154.35 - 13,403.10 11,711.83 - (1,446.83) 114.09% 000-451510 Juvenile Case Mgmt Fee 26,352.00 8,869.11 - 32,149.30 27,695.63 - (1,343.63) 105.10% 000-451520 Truancy Fee 4,464.00 1,651.38 5,705.64 4,889.34 (425.34) 109.53% 000-451600 Technology Fund Fee 21,983.00 7,029.31 - 24,918.03 22,097.92 - (114.92) 100.52% 000-451700 Security Fee 15,817.00 5,281.69 - 19,355.33 16,678.09 - (861.09) 105.44% 000-451800 Time Payment Fee - City 9,689.00 1,127.51 - 5,936.41 4,986.29 - 4,702.71 51.46% 000-451850 State Fines 10% Service Fee 20,488.00 8,122.22 - 37,999.60 29,597.98 - (9,109.98) 144.46% 000-451900 DPS Payment - Local 8,829.00 1,291.06 - 7,580.78 5,916.27 - 2,912.73 67.01% 000-452000 Child Safety Fee 3,810.00 1,854.28 - 3,210.28 6,798.39 - (2,988.39) 178.44% 000-452100 Platting Fees 62,000.00 11,750.00 - 66,500.00 53,000.00 - 9,000.00 85.48% 000-452200 Site Plan Fee 43,500.00 3,000.00 - 28,000.00 36,000.00 - 7,500.00 82.76% 000-452300 Plan Check Fee 463,261.00 161,976.50 - 894,727.50 817,114.50 - (353,853.50) 176.38% 000-452320 Tree Mitigation Admin Fee 20,000.00 - - 11,799.90 17,368.50 - 2,631.50 86.84% 000-452400 BOA/Zoning Fees 5,000.00 2,500.00 - 3,110.51 5,777.64 - (777.64) 115.55% 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, 2018 000-452600 Specific Use/Zone Chng Fee 14,300.00 2,737.54 - 20,500.00 23,937.54 - (9,637.54) 167.40% 000-452710 Zoning Ltr & Dev Rights 1,200.00 750.00 - 2,400.00 1,950.00 - (750.00) 162.50% 000-453100 Reinspection Fees 90,000.00 53,725.00 - 108,427.00 169,225.00 - (79,225.00) 188.03% 000-453110 Swim Pool Inspection Fee 2,600.00 - - 2,530.00 2,620.00 - (20.00) 100.77% 000-453200 Lot Abatement 5,000.00 - - 2,243.21 1,615.00 - 3,385.00 32.30% 000-453211 Admin Fee-Inspections 10,400.00 3,000.00 - 15,800.00 24,600.00 - (14,200.00) 236.54% 000-453310 Misc Inspection Fee - 400.00 - - 3,613.00 - (3,613.00) 0.00% 000-453710 Foster Care 1,000.00 250.00 - 1,200.00 1,100.00 - (100.00) 110.00% 000-454200 Pool Gate Admission Fee 24,000.00 16,172.09 - 25,464.90 23,053.09 - 946.91 96.05% 000-454300 Seasonal Pool Pass Fee 5,000.00 900.00 - 5,894.00 4,410.00 - 590.00 88.20% 000-456120 Senior Center Meal Fee - - 802.00 802.00 - (802.00) 0.00% 000-456500 Haz Mat Fees 5,000.00 - - 400.00 - - 5,000.00 0.00% 000-456600 Fire Re-inspection Fee 1,000.00 250.00 - 1,200.00 1,145.00 - (145.00) 114.50% 000-456600 Sale of General Fixed Asset - - - - 19,251.61 - (19,251.61) 0.00% 000-458110 Sale of Merchandise-GovDeal 40,000.00 51,423.09 - 52,261.05 86,052.04 - (46,052.04) 215.13% 000-458300 Sale of Property/Auction 3,000.00 - - - - - 3,000.00 0.00% 000-458400 Civic Center Rental Fees 200,000.00 57,348.85 - 194,963.75 210,428.35 - (10,428.35) 105.21% 000-458401 Capital Recovery Fee-Civic Cntr 10,000.00 1,975.00 - 14,660.00 8,220.00 - 1,780.00 82.20% 000-458450 North Center Rental Fees 18,500.00 6,796.75 - 26,396.75 26,581.75 (8,081.75) 143.69% 000-458460 Senior Center Rental 15,000.00 2,100.00 8,100.00 4,600.00 - 10,400.00 30.67% 000-458500 Community Center Rental Fees 25,000.00 8,991.50 - 31,978.00 40,651.00 - (15,651.00) 162.60% 000-458550 Pavilion Rental Fees 20,000.00 4,782.50 - 19,497.50 20,380.00 - (380.00) 101.90% 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 - (3,080.00) 130.80% 000-458650 NonResident User Fee-BVYA 10,000.00 580.00 - 8,451.00 9,670.00 - 330.00 96.70% 000-458660 BVYA Utility Reimbursement 15,000.00 8,622.91 - 26,159.97 21,918.89 - (6,918.89) 146.13% 000-458670 SYSA Utility Reimbursement - - - - 5,464.58 - (5,464.58) 0.00% 000-458675 Lions Futbol Utility Reimbursement 10,000.00 6,516.00 - 9,376.00 8,860.00 - 1,140.00 88.60% 000-458700 Vehicle Impoundment 10,000.00 2,850.00 - 9,860.00 10,920.00 - (920.00) 109.20% 000-459200 NSF Check Fee 250.00 - - 50.00 25.00 - 225.00 10.00% 000-459300 Notary Fee 250.00 6.00 - 126.00 96.00 - 154.00 38.40% 000-459400 Maps, Copies, UDC, & Misc F 250.00 10.00 - 40.00 35.00 - 215.00 14.00% 000-459600 Animal Adoption Fee 12,500.00 5,914.00 - 18,581.00 18,826.90 - (6,326.90) 150.62% 000-459700 Pet Impoundment Fee 7,000.00 1,460.00 - 6,266.50 6,257.20 - 742.80 89.39% 000-459800 Police Reports Fee 5,800.00 1,337.80 - 6,018.60 5,723.30 - 76.70 98.68% 000-45990 Fire - False Alarm Fee - - 4,500.00 - - - 0.00% TOTAL Fees 2,126,546.00 665,816.65 - 2,661,260.51 2,587,846.74 - (461,300.74) 121.69% 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, 2018 Fines 000-463000 Library Fines 20,000.00 4,113.53 - 23,339.27 20,902.37 - (902.37) 104.51% TOTAL Fines 20,000.00 4,113.53 - 23,339.27 20,902.37 - (902.37) 104.51% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,077.00 15,808.32 - 21,077.76 36,886.08 - (15,809.08) 175.01% 000-473200 City of Seguin - Fire Contract 29,231.00 8,184.66 - 29,230.80 30,107.76 - (876.76) 103.00% 000-473300 Guad Co - Library 218,000.00 72,384.00 - 217,152.00 217,152.00 - 848.00 99.61% 000-473400 Randolph AFB-Animal Cntrl 1,200.00 - - 1,200.00 200.00 - 1,000.00 16.67% 000-474200 Library Services - Cibolo 35,000.00 - - 35,000.00 35,001.50 - (1.50) 100.00% 000-474210 Library Services-Selma 20,000.00 - - 31,540.00 21,750.00 - (1,750.00) 108.75% 000-474400 Dispatch Service - Cibolo 166,000.00 40,000.00 - 160,000.00 160,000.00 - 6,000.00 96.39% 000-474600 School Crossing Guard-Bexar 38,000.00 10,703.32 - 37,805.72 43,762.71 - (5,762.71) 115.17% 000-474610 School Cross Guard-Guadalupe 38,000.00 10,274.34 - 38,878.80 43,635.93 - (5,635.93) 114.83% 000-474620 School Crossing Guard-Comal 1,500.00 - - - - 1,500.00 0.00% 000-474700 School Officer Funding 255,000.00 127,500.00 - 255,000.00 255,000.00 - - 100.00% 000-474750 Crime Victim Liaison Agreement 50,000.00 25,000.00 - 50,000.00 43,760.00 - 6,240.00 87.52% TOTAL Inter-Jurisdictional 873,008.00 309,854.64 - 876,885.08 887,255.98 - (14,247.98) 101.63% Fund Transfers 000-480000 Indirect Costs - EMS 170,087.00 42,521.76 - 150,087.00 170,086.92 - 0.08 100.00% 000-480100 Indirect Costs - Hotel/Motel 67,605.00 16,601.25 - 66,405.00 66,405.00 - 1,200.00 98.22% 000-481000 Transfer In Reserves 1,548,564.00 - - - - - 1,548,564.00 0.00% 000-485000 Interfund Charge-Drainage 271,430.00 67,857.51 - 184,425.00 271,429.92 - 0.08 100.00% 000-486000 Interfund Chrges-Admin W&S 1,344,140.00 336,035.01 - 1,186,812.00 1,344,139.92 - 0.08 100.00% 000-487000 Interfund Charges-Fleet 344,026.00 85,811.25 - 397,581.00 344,026.00 - - 100.00% 000-488000 Interfund Charges-4B 441,395.00 - - 430,445.00 441,395.00 - - 100.00% 000-489000 Transfer In 108,967.00 - - 68,385.08 - - 108,967.00 0.00% 000-489620 Contribution - SEDC 265,000.00 265,000.00 - - 265,000.00 - - 100.00% TOTAL Fund Transfers 4,561,214.00 813,826.78 - 2,484,140.08 2,902,482.76 - 1,658,731.24 63.63% 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, 2018 Miscellaneous 000-491000 Interest Earned 1,500.00 5,897.27 - 4,706.59 26,900.56 - (25,400.56) 1793.37% 000-491200 Investment Income 150,000.00 75,242.25 - 136,000.70 240,437.30 - (90,437.30) 160.29% 000-491800 Gain/Loss - (249.94) - (1,420.63) (16,291.80) - 16,291.80 0.00% 000-491900 Unrealized Gain/Loss (30,000.00) (768.47) - (11,305.39) 958.05 - (30,958.05) 0.00% 000-493000 Donations-Others - - - - 20.00 - (20.00) 0.00% 000-493120 Donations-Public Library 7,500.00 1,023.01 - 4,044.35 6,854.17 - 645.83 91.39% 000-493400 Donation - Animal Control 15,000.00 683.69 - 18,190.78 12,979.36 - 2,020.64 86.53% 000-493401 Donations-A/C Microchip 1,000.00 180.00 - 640.00 675.00 - 325.00 67.50% 000-493402 Donations-Spay&Neuter 1,000.00 - - 810.00 87.00 - 913.00 8.70% 000-493403 Donations-Animal Adoption Trailer - - 552.29 - - - 0.00% 000-493404 Donations-TNR Program 500.00 - - - - 500.00 0.00% 000-493460 Donations-Parks 12,000.00 530.80 13,741.09 11,355.80 - 644.20 94.63% 000-493465 Donations-Senior Center 12,000.00 3,239.56 10,571.59 11,472.11 - 527.89 95.60% 000-493502 Donations-PD 28,600.00 (1,599.00) - 4,222.25 27,000.00 - 1,600.00 94.41% 000-493503 Donations-Fire Rescue 15,350.00 - 9,541.00 15,350.00 - - 100.00% 000-494481 LawEnforcemtOfficersStnd&Ed 3,650.00 - - 3,679.47 3,823.43 - (173.43) 104.75% 000-494482 Grants - Police, Fire, Gen Fund 5,000.00 - - 4,892.03 1,473.67 - 3,526.33 29.47% 000-495100 Mobile Stage Rental Fees - 1,550.00 - 1,550.00 3,650.00 - (3,650.00) 0.00% 000-497000 Misc Income-Gen Fund 30,000.00 12,522.82 - (25,322.50) 81,225.70 - (51,225.70) 270.75% 000-497005 Schertz Magazine Advertising 195,000.00 39,700.00 - 186,000.00 147,755.00 - 47,245.00 75.77% 000-497100 Misc Income-Police 18,500.00 2,865.44 - 17,865.86 11,240.46 - 7,259.54 60.76% 000-497150 Misc Income-Fire Department - - - 1,750.00 970.11 - (970.11) 0.00% 000-497200 Misc Income-Library 5,000.00 1,475.50 - 4,965.10 5,330.70 - (330.70) 106.61% 000-497210 Misc Income-Library Copier 18,000.00 5,337.80 18,187.16 19,557.95 - (1,557.95) 108.66% 000-497300 Misc Income-Animal Control - - - 390.00 298.75 - (298.75) 0.00% 000-497400 Misc Income-Streets Dept.60,000.00 5,440.00 - 51,734.50 27,943.97 - 32,056.03 46.57% 000-497500 Misc Income-TML Insurance 10,000.00 3,047.22 - 9,252.06 36,098.05 - (26,098.05) 360.98% 000-497550 Misc Income-TML Reimbursemt 20,000.00 602.39 - 11,956.51 2,073.87 - 17,926.13 10.37% 000-497600 Misc Income-Vending Mach.2,500.00 578.59 - 2,257.04 2,364.92 - 135.08 94.60% 000-497610 Misc Income- Muni Court - - - - 2,036.40 - (2,036.40) 0.00% 000-498000 Reimbursmnt-Gen Fund 35,000.00 - - 20,358.75 8,355.21 - 26,644.79 23.87% 000-498100 Reimbursmnt Fire - Training 500.00 - - 7.00 - - 500.00 0.00% 000-498105 Reimburmnt Police - DEA 5,000.00 6,650.71 - 5,763.94 9,279.32 - (4,279.32) 185.59% 000-498110 Reimbursmnt Fire - Emg. Acti-O 200,000.00 33,353.58 - 3,267.16 212,799.39 - (12,799.39) 106.40% 000-498150 Reimbursemnt - Library 5,750.00 - 4,673.27 6,355.39 - (605.39) 110.53% TOTAL Miscellaneous 828,350.00 197,303.22 - 513,521.97 920,429.84 - (92,079.84) 111.12% TOTAL REVENUES 31,844,008.43 5,398,821.14 - 29,589,482.64 32,499,112.70 - (655,104.27) 102.06% Cash in Bank Claim on Operating Cash Pool-Checking 998,211.19$ Cash in Investments LOGIC Investment-General Fund 9,933,732.61 LOGIC Investment-Equip Replacement 76,194.27 LOGIC Investment-Veh Replacement 513,760.50 LOGIC Investment-Air Condi Replacment 279,592.50 CAPITAL ONE Investment-General Fund 1,381,442.24 Total Cash in Bank & Investments 13,182,933.31$ CASH IN BANK AND INVESTMENTS AS OF: September 30, 2018 GENERAL FUND OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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 2013-14 363,589 538,568 3,641,091 2,726,044 585,058 72,116 16,554 48,791 18,572 20,939 10,460 7,446 ADVALOREM TAX OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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 2013-14 481,247 657,271 554,578 416,261 728,443 487,933 541,476 781,057 692,446 448,577 680,332 547,431 48.3%14.2% 10.6%12.2%-9.6% $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 Sales Tax -General Fund OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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 73,800.00 - 43,058.37 67,615.51 - 6,184.49 91.62% Miscellaneous 96,400.00 3,620.07 104,960.50 64,347.99 - 32,052.01 66.75% TOTAL REVENUES 170,200.00 3,620.07 148,018.87 131,963.50 - 38,236.50 77.53% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental - - 2,909.10 - - - 0.00% TOTAL GENERAL GOVERNMENT - - 2,909.10 - - - 0.00% CULTURAL Festival of Angels 12,924.00 - 10,912.90 10,566.23 - 2,357.77 81.76% Employee Appreciation Event 13,000.00 129.34 11,620.88 12,133.31 - 866.69 93.33% 4th of July Jubilee 26,076.00 25,931.91 23,533.31 26,074.79 142.80 (141.59) 100.54% National Night Out 400.00 - 270.00 - - 400.00 0.00% Wilenchik Walk for Life 20,000.00 7,184.00 12,620.00 10,593.68 - 9,406.32 52.97% Schertz Fest 30,000.00 23,930.41 23,779.28 24,584.39 701.00 4,714.61 84.28% Schertz Sweetheart 31,250.00 5,180.89 23,207.09 17,662.90 - 13,587.10 56.52% Hal Baldwin Scholarship 15,050.00 7.00 14,054.77 13,544.61 - 1,505.39 90.00% Other Events 21,500.00 87.90 10,376.81 16,803.59 - 4,696.41 78.16% TOTAL CULTURAL 170,200.00 62,451.45 130,375.04 131,963.50 843.80 37,392.70 78.03% TOTAL EXPENDITURES 170,200.00 62,451.45 133,284.14 131,963.50 843.80 37,392.70 78.03% REVENUE OVER(UNDER) EXPEND - (58,831.38) 14,734.73 - (843.80) 843.80 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 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-486100 Transfer In 9,000.00 - 5,611.67 9,000.00 - - 100.00% 000-486101 Transfer In - General Fund 64,800.00 - 37,446.70 58,615.51 - 6,184.49 90.46% TOTAL Fund Transfers 73,800.00 - 43,058.37 67,615.51 - 6,184.49 91.62% Miscellaneous 000-491200 Investment Income 150.00 98.07 175.25 312.80 - (162.80) 208.53% 000-492200 Wilenchik Walk for Life 20,000.00 69.00 12,620.00 10,594.00 - 9,406.00 52.97% 000-493000 July 4th Activities 26,000.00 (2,497.00) 27,386.25 19,628.00 - 6,372.00 75.49% 000-493150 SchertzQ 30,000.00 5,950.00 26,994.00 6,150.00 - 23,850.00 20.50% 000-493256 Donations - Police Events 3,000.00 - - - - 3,000.00 0.00% 000-493455 Proceeds-Festival of Angels 700.00 - 5,615.00 1,305.00 - (605.00) 186.43% 000-493460 Schertz Sweetheart 1,500.00 - 1,705.00 (20.81) - 1,520.81 -1.39% 000-493470 Moving on Main - - - 680.00 (680.00) 000-493621 Hal Baldwin Scholarship 15,050.00 - 28,465.00 20,105.00 - (5,055.00) 133.59% 000-497000 Misc Income - - 2,000.00 5,594.00 - (5,594.00) 0.00% TOTAL Miscellaneous 96,400.00 3,620.07 104,960.50 64,347.99 - 32,052.01 66.75% TOTAL REVENUES 170,200.00 3,620.07 148,018.87 131,963.50 - 38,236.50 77.53% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 Cash in Bank Claim on Operating Cash Pool-Checking 16,792.09$ Cash in Investments Texas Class- Special Events 17,379.14 Total Cash in Bank & Investments 34,171.23$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2018 SPECIAL EVENTS FUND 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 93,300.00 63,415.79 88,044.66 84,846.75 - 8,453.25 90.94% Fund Transfers 106,700.00 - - - - 106,700.00 0.00% TOTAL REVENUES 200,000.00 63,415.79 88,044.66 84,846.75 - 115,153.25 42.42% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 200,000.00 - - - - 200,000.00 0.00% TOTAL GENERAL GOVERNMENT 200,000.00 - - - - 200,000.00 0.00% MISC & PROJECTS Projects - - 27,129.00 - - - 0.00% TOTAL MISC & PROJECTS - - 27,129.00 - - - 0.00% TOTAL EXPENDITURES 200,000.00 - 27,129.00 - - 200,000.00 0.00% REVENUE OVER(UNDER) EXPEND - 63,415.79 60,915.66 84,846.75 - (84,846.75) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 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 55,000.00 43,288.61 54,611.80 57,299.25 - (2,299.25) 104.18% 000-421465 AT&T PEG Fee 38,300.00 20,127.18 33,432.86 27,547.50 - 10,752.50 71.93% TOTAL Franchises 93,300.00 63,415.79 88,044.66 84,846.75 - 8,453.25 90.94% Fund Transfers 000-481000 Transfer In - Reserves 106,700.00 - - - - 106,700.00 0.00% TOTAL Fund Transfers 106,700.00 - - - - 106,700.00 0.00% TOTAL REVENUES 200,000.00 63,415.79 88,044.66 84,846.75 - 115,153.25 42.42% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 Cash in Bank Cash Balance 701,921.85$ Total Cash in Bank & Investments 701,921.85$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2018 PEG FUND 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 238,260.00 50,537.46 232,753.70 263,469 - (25,208.61) 110.58% Permits - - 49,563.52 - - - 0.00% Fees 22,013,250.00 6,319,345.61 21,617,932.68 23,280,704 - (1,267,453.91) 105.76% Fund Transfers 583,046.00 35,377.50 136,920.00 141,510 - 441,536.00 24.27% Miscellaneous 256,614.00 125,767.61 6,606,454.56 348,828 - (92,214.19) 135.93% TOTAL REVENUES 23,091,170.00 6,531,028.18 28,643,624.46 24,034,510.71 - (943,340.71) 104.09% EXPENDITURE SUMMARY NON DEPARTMENTAL Other Finance Source - 51,999.83 - 51,999.83 - (51,999.83) 0.00% TOTAL NON DEPARTMENTAL - 51,999.83 - 51,999.83 - (51,999.83) 0.00% BUSINESS OFFICE Personnel Services 480,038.00 91,333.00 415,998.16 437,522.06 - 42,515.94 91.14% Supplies 3,800.00 1,415.07 1,680.14 2,916.30 - 883.70 76.74% Human Services 400.00 - 203.00 - - 400.00 0.00% City Support Services 2,146.00 1.00 27.50 1.00 - 2,145.00 0.05% Utility Services 1,027.00 275.61 752.05 1,026.26 - 0.74 99.93% Operations Support 156,300.00 33,734.90 125,801.72 141,417.02 10,000.00 4,882.98 96.88% Staff Support 6,970.00 1,570.40 3,040.33 3,754.61 - 3,215.39 53.87% Professional Services 170,000.00 58,604.43 137,193.85 210,299.57 - (40,299.57) 123.71% Maintenance Services 8,040.00 1,260.00 6,120.00 6,120.00 420.00 1,500.00 81.34% Operating Equipment 3,607.00 - - 3,656.94 - (49.94) 101.38% TOTAL BUSINESS OFFICE 832,328.00 188,194.41 690,816.75 806,713.76 10,420.00 15,194.24 98.17% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2018 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, 2018 W & S ADMINISTRATION Personnel Services 1,382,056.36 312,258.28 1,107,430.73 1,226,074.86 - 155,981.50 88.71% Supplies 225,500.00 86,455.72 196,682.73 216,143.53 2,159.24 7,197.23 96.81% Human Services 600.00 - 539.00 - - 600.00 0.00% City Support Services 70,500.00 601.69 64,703.96 59,829.47 - 10,670.53 84.86% Utility Services 3,532,329.00 1,157,551.21 3,237,941.89 3,566,645.42 - (34,316.42) 100.97% Operations Support 11,600.00 1,876.90 8,227.86 6,419.10 - 5,180.90 55.34% Staff Support 29,250.00 5,668.20 22,363.85 25,583.02 - 3,666.98 87.46% City Assistance 1,500.00 222.00 1,638.00 333.00 - 1,167.00 22.20% Professional Services 368,000.00 167,758.20 358,882.53 391,047.34 - (23,047.34) 106.26% Fund Charges/Transfers 5,092,110.00 1,063,057.58 6,421,343.68 5,090,748.10 - 1,361.90 99.97% Maintenance Services 8,601,240.00 3,085,313.63 7,922,688.88 8,400,915.53 2,377.47 197,947.00 97.70% Other Costs 37,500.00 - 36,605.45 36,615.45 - 884.55 97.64% Debt Service 1,626,779.00 752,611.20 357,795.24 1,491,245.50 - 135,533.50 91.67% Rental-Leasing 124,500.00 - 23,501.89 2,782.95 - 121,717.05 2.24% Operating Equipment 9,000.00 3,198.39 3,089.93 4,025.18 249.55 4,725.27 47.50% Capital Outlay 397,877.64 - - - 397,477.64 400.00 99.90% TOTAL PUBLIC WORKS 21,510,342.00 6,636,573.00 19,763,435.62 20,518,408.45 402,263.90 589,669.65 97.26% MISC & PROJECTS PROJECTS City Support Services 40,000.00 - - - - 40,000.00 0.00% Operations Support 1,441.50 - - 964.26 - 477.24 66.89% Professional Services 53,325.50 - - 8,457.50 6,172.50 38,695.50 27.44% Maintenance Services 780,037.00 - - 391,537.00 - 388,500.00 50.19% TOTAL PROJECTS 874,804.00 - - 400,958.76 6,172.50 467,672.74 46.54% SEWER PROJECT Professional Services 360,000.00 - - - - 360,000.00 0.00% TOTAL SEWER PROJECTS 360,000.00 - - - - 360,000.00 0.00% TOTAL MISC & PROJECTS 1,234,804.00 - - 400,958.76 6,172.50 827,672.74 32.97% TOTAL EXPENDITURES 23,577,474.00 6,824,767.41 20,454,252.37 21,778,080.80 418,856.40 1,380,536.80 94.14% ** REVENUE OVER(UNDER)EXPENSES **(486,304.00) (293,739.23) 8,189,372.09 2,256,429.91 (418,856.40) (2,323,877.51) 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 238,260.00 50,537.46 232,753.70 263,468.61 - (25,208.61) 110.58% TOTAL Franchises 238,260.00 50,537.46 232,753.70 263,468.61 - (25,208.61) 110.58% Permits 000-432400 Development Permit - - 49,563.52 - - - 0.00% TOTAL Permits - - 49,563.52 - - - 0.00% Fees 000-455200 Garbage Collection Fee 4,850,000.00 1,274,042.53 4,617,935.61 4,957,467.63 - (107,467.63) 102.22% 000-455500 Water & Sewer Transfer Fee - - - (10.00) - 10.00 0.00% 000-455600 Fire Line Fees 31,000.00 - 29,540.00 29,015.00 - 1,985.00 93.60% 000-455700 Recycle Fee Revenue 309,750.00 74,229.53 295,773.10 305,305.47 - 4,444.53 98.57% 000-455800 W&S Line Constructn Reimbursemnt 20,000.00 8,094.84 35,302.04 36,474.41 - (16,474.41) 182.37% 000-457100 Sale of Water 9,825,000.00 3,138,717.79 9,741,286.37 10,661,182.69 - (836,182.69) 108.51% 000-457110 Edwards Water Lease 125,000.00 26,700.00 125,531.25 54,872.25 - 70,127.75 43.90% 000-457120 Water Transfer Charge-Selma 50,000.00 20,187.13 24,641.14 26,419.64 - 23,580.36 52.84% 000-457200 Sale of Meters 80,000.00 28,621.00 111,839.26 143,916.03 - (63,916.03) 179.90% 000-457400 Sewer Charges 6,500,000.00 1,695,326.16 6,385,093.91 6,812,869.46 - (312,869.46) 104.81% 000-457500 Water Penalties 220,000.00 52,751.63 248,540.00 250,316.33 - (30,316.33) 113.78% 000-459200 NSF Check Fee-Water&Sewer 2,500.00 675.00 2,450.00 2,875.00 - (375.00) 115.00% TOTAL Fees 22,013,250.00 6,319,345.61 21,617,932.68 23,280,703.91 - (1,267,453.91) 105.76% Fund Transfers 000-486000 Transfer In- Reserve 441,536.00 - - - - 441,536.00 0.00% 000-486204 Interfnd Chrg-Drainage Bill 141,510.00 35,377.50 136,920.00 141,510.00 - - 100.00% TOTAL Fund Transfers 583,046.00 35,377.50 136,920.00 141,510.00 - 441,536.00 24.27% AS OF: September 30, 2018 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z 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 AS OF: September 30, 2018 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z Miscellaneous 000-490000 Misc Charges 500.00 2,597.00 282,281.71 10,989.00 - (10,489.00) 2197.80% 000-491000 Interest Earned 1,500.00 22,478.26 3,666.23 44,858.94 - (43,358.94) 2990.60% 000-491200 Investment Income 60,000.00 66,507.65 58,375.64 158,053.81 - (98,053.81) 263.42% 000-495013 Capital Contribution - W&S - - 6,111,473.71 - - - 0.00% 000-496000 Water Construction Reserve - - - 1.00 - (1.00) 0.00% 000-497000 Misc Income-W&S 15,000.00 563.45 28,284.12 3,294.44 - 11,705.56 21.96% 000-498110 Reimbursement-SSLGC 129,614.00 33,621.25 122,373.15 131,630.00 - (2,016.00) 101.56% 000-498200 Reimbursement- W&S Project 50,000.00 - - 1.00 - 49,999.00 0.00% TOTAL Miscellaneous 256,614.00 125,767.61 6,606,454.56 348,828.19 - (92,214.19) 135.93% TOTAL REVENUES 23,091,170.00 6,531,028.18 28,643,624.46 24,034,510.71 - (943,340.71) 104.09% Cash in Bank Claim on Operating Cash Pool-Checking -$ Cash in Investments Lone Star Investment-Water&Sewer 7,978,575.20 Lone Star Investment-W&S Customer Deposits 305,487.50 Lone Star Investment-W&S Equip Replacement 183,673.46 Lone Star Investment-W&S Veh Replacement 265,332.92 Schertz Bank & Trust-Certificate of Deposit 1,096,110.74 9,829,179.82$ Total Cash in Bank & Investments 9,829,179.82$ CASH IN BANK AND INVESTMENTS AS OF: September 30, 2018 WATER & SEWER 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,122,000.00 1,443,578.12 5,955,625.72 4,998,716.24 - 1,123,283.76 81.65% Inter-Jurisdictional 2,780,862.72 281,192.64 2,412,953.11 2,861,992.46 - (81,129.74) 102.92% Fund Transfers - - 550,000.00 - - - 0.00% Miscellaneous 117,850.00 15,058.12 223,833.98 135,601.24 - (17,751.24) 115.06% TOTAL REVENUES 9,020,712.72 1,739,828.88 9,142,412.81 7,996,309.94 - 1,024,402.78 88.64% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 4,244,739.00 940,142.90 3,837,205.27 4,000,189.29 - 244,549.71 94.24% Supplies 410,850.00 71,819.04 378,683.81 351,731.54 18,411.38 40,707.08 90.09% Human Services - - 1,299.00 - - - 0.00% City Support Services 103,680.00 1,668.25 57,156.06 49,081.35 - 54,598.65 47.34% Utility Services 118,000.00 40,487.21 114,478.11 120,225.21 - (2,225.21) 101.89% Operations Support 75,040.00 13,543.26 61,530.78 57,172.31 - 17,867.69 76.19% Staff Support 70,750.00 8,290.99 52,858.50 47,266.68 3,509.38 19,973.94 71.77% City Assistance 568,866.81 184,275.59 527,022.47 560,527.14 46.26 8,293.41 98.54% Professional Services 168,200.00 66,728.69 126,267.22 140,167.79 - 28,032.21 83.33% Fund Charges/Transfers 2,656,827.00 77,580.61 2,735,917.79 1,787,252.03 - 869,574.97 67.27% Maintenance Services 12,000.00 5,760.00 20,610.04 12,480.00 299.00 (779.00) 106.49% Other Cost - - 1,130.44 - - - 0.00% Debt Service 288,120.00 170,887.50 10,869.56 286,675.63 - 1,444.37 99.50% Rental-Leasing 141,000.00 17,385.21 70,120.35 136,713.83 - 4,286.17 96.96% Operating Equipment 119,100.00 15,227.11 38,818.79 46,167.33 1,166.41 71,766.26 39.74% Capital Outlay 30,000.00 - 34,510.00 605,731.76 - (575,731.76) 2019.11% TOTAL PUBLIC SAFETY 9,007,172.81 1,613,796.36 8,068,478.19 8,201,381.89 23,432.43 782,358.49 91.31% TOTAL EXPENDITURES 9,007,172.81 1,613,796.36 8,068,478.19 8,201,381.89 23,432.43 782,358.49 91.31% ** REVENUE OVER(UNDER) EXPENSES **13,539.91 126,032.52 1,073,934.62 (205,071.95) (23,432.43) 242,044.29 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2018 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,866,200.00 1,371,031.30 5,666,325.67 4,698,879.43 - 1,167,320.57 80.10% 000-456110 Subscription Program Fees 30,000.00 500.00 25,115.00 25,275.00 - 4,725.00 84.25% 000-456120 EMT Class - Fees 96,000.00 33,305.00 94,873.00 98,770.00 - (2,770.00) 102.89% 000-456122 CE Class - Fees 22,800.00 2,745.90 16,975.00 23,458.42 - (658.42) 102.89% 000-456130 Immunization Fees 7,000.00 - 9,138.00 3,008.17 - 3,991.83 42.97% 000-456140 Billing Fees - External 25,000.00 6,271.92 18,153.05 23,016.37 - 1,983.63 92.07% 000-456150 Standby Fees 25,000.00 10,217.10 24,483.50 38,517.80 - (13,517.80) 154.07% 000-456155 Community Services Support 50,000.00 12,206.90 100,487.50 72,888.09 - (22,888.09) 145.78% 000-456160 MIH Services - 7,300.00 - 13,960.00 - (13,960.00) 0.00% 000-458110 Sales of Merchandise - GovDeal - - - 842.96 - (842.96) 0.00% 000-459200 NSF Check Fee - - 75.00 100.00 - (100.00) 0.00% TOTAL Fees 6,122,000.00 1,443,578.12 5,955,625.72 4,998,716.24 - 1,123,283.76 81.65% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 843,577.17 281,192.64 843,578.00 843,578.00 - (0.83) 100.00% 000-474300 Cibolo Support 346,467.65 - 319,098.32 346,467.64 - 0.01 100.00% 000-475100 Comal Co ESD #6 112,536.60 - 106,011.73 116,812.50 - (4,275.90) 103.80% 000-475200 Live Oak Support 213,151.95 - 206,956.52 213,151.96 - (0.01) 100.00% 000-475300 Universal City Support 281,283.70 - 262,361.00 281,283.72 - (0.02) 100.00% 000-475400 Selma Support 111,886.35 - 106,656.08 111,886.36 - (0.01) 100.00% 000-475500 Schertz Support 556,325.00 - 504,083.88 556,325.00 - - 100.00% 000-475600 Santa Clara Support 10,447.35 - 10,354.16 10,447.36 - (0.01) 100.00% 000-475800 Marion Support 15,186.95 - 14,956.00 15,186.96 - (0.01) 100.00% 000-475910 TASPP Program 290,000.00 - 38,897.42 366,852.96 - (76,852.96) 126.50% TOTAL Inter-Jurisdictional 2,780,862.72 281,192.64 2,412,953.11 2,861,992.46 - (81,129.74) 102.92% Fund Transfers - 000-486100 Transfer In - - 550,000.00 - - - 0.00% TOTAL Fund Transfers - - 550,000.00 - - - 0.00% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2018 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 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2018 Miscellaneous 000-491000 Interest Earned 100.00 1,431.65 898.59 4,402.87 - (4,302.87) 4402.87% 000-491200 Investment Income 750.00 313.45 2,750.18 6,236.78 - (5,486.78) 831.57% 000-493203 Donations-EMS 2,000.00 513.00 351.00 913.00 - 1,087.00 45.65% 000-493205 Donations- Golf Tournament 10,000.00 - 10,060.00 18,595.00 - (8,595.00) 185.95% 000-495100 UH Grant Program 40,000.00 - 99,579.03 - - 40,000.00 0.00% 000-497000 Misc Income 25,000.00 2,151.03 48,902.91 49,965.83 - (24,965.83) 199.86% 000-497100 Recovery of Bad Debt 40,000.00 10,648.99 61,292.27 55,487.76 - (15,487.76) 138.72% TOTAL Miscellaneous 117,850.00 15,058.12 223,833.98 135,601.24 - (17,751.24) 115.06% TOTAL REVENUES 9,020,712.72 1,739,828.88 9,142,412.81 7,996,309.94 - 1,024,402.78 88.64% Cash in Bank Claim on Operating Cash Pool-Checking 195,872.80$ Cash in Investments Texas Class- EMS Notes 2015 Investment 140.10 SR 2017 Ambulance-Logic 56,999.51 Total Cash in Bank & Investments 253,012.41$ CASH IN BANK AND INVESTMENTS AS OF: September 30, 2018 SCHERTZ EMS 204-DRAINAGE CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER EXPENSE Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Permits 3,000.00 1,140.00 - 2,960.00 3,960 - (960.00) 132.00% Fees 1,179,250.00 280,910.46 - 1,146,945.61 1,159,274 - 19,975.86 98.31% Fund Transfers 1,327,327.00 - - - - - 1,327,327.00 0.00% Miscellaneous 254,350.00 7,942.46 - 16,662.78 194,255 - 60,094.82 76.37% TOTAL REVENUES 2,763,927.00 289,992.92 - 1,166,568.39 1,357,489.32 - 1,406,437.68 49.11% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 391,652.00 79,572.77 - 293,187.34 328,956.84 - 62,695.16 83.99% Supplies 5,200.00 1,835.99 - 3,722.56 5,046.38 - 153.62 97.05% City Support Services 8,180.00 365.00 - 4,576.16 6,873.54 - 1,306.46 84.03% Utility Services 13,200.00 5,194.66 - 16,299.29 14,016.79 - (816.79) 106.19% Operations Support 1,000.00 - - - - - 1,000.00 0.00% Staff Support 7,100.00 1,315.85 - 6,004.24 5,757.56 - 1,342.44 81.09% City Assistance 400.00 - - 287.00 98.00 - 302.00 24.50% Professional Services 117,320.00 - - 46,733.00 8,918.00 - 108,402.00 7.60% Fund Charges/Transfers 497,295.00 124,073.76 - 556,071.41 496,294.92 - 1,000.08 99.80% Maintenance Services - - - 13,720.54 1,089.91 - (1,089.91) 0.00% Other costs 200.00 - - 100.00 100.00 - 100.00 50.00% Debt Service 123,225.00 119,112.50 - 119,794.56 123,206.13 - 18.87 99.98% Rental/Leasing 100.00 - - - - - 100.00 0.00% Operating Equipment 7,000.00 6,292.06 - 5,739.17 6,812.05 - 187.95 97.32% TOTAL DRAINAGE 1,171,872.00 337,762.59 - 1,066,235.27 997,170.12 - 174,701.88 85.09% PROJECTS City Support Services 7,354.50 - - - - - 7,354.50 0.00% Operations Support 1,950.00 1,082.02 - - 1,551.02 - 398.98 79.54% Professional Services 180,058.50 88,681.92 - - 157,108.50 21,070.00 1,880.00 98.96% Maintenance Services 1,532,061.00 - - - 383,955.25 17,478.00 1,130,627.75 26.20% TOTAL PROJECTS 1,721,424.00 89,763.94 - - 542,614.77 38,548.00 1,140,261.23 33.76% TOTAL EXPENDITURES 2,893,296.00 427,526.53 - 1,066,235.27 1,539,784.89 38,548.00 1,314,963.11 54.55% ** REVENUE OVER(UNDER) EXPEND (129,369.00) (137,533.61) - 100,333.12 (182,295.57) (38,548.00) 91,474.57 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2018 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,140.00 2,960.00 3,960.00 - (960.00) 132.00% TOTAL Permits 3,000.00 1,140.00 2,960.00 3,960.00 - (960.00) 132.00% Fees 000-457500 Drainage Penalties 10,000.00 1,855.22 10,015.62 10,537.47 - (537.47) 105.37% 000-457600 Drainage Fee 1,169,250.00 279,055.24 1,136,929.99 1,148,736.67 - 20,513.33 98.25% TOTAL Fees 1,179,250.00 280,910.46 1,146,945.61 1,159,274.14 - 19,975.86 98.31% Fund Transfers 000-481000 Transfer In 1,327,327.00 - - - - 1,327,327.00 0.00% TOTAL Funds Transfers 1,327,327.00 - - - - 1,327,327 0.00% Miscellaneous 000-491000 Interest Earned 150.00 2,251.26 295.39 3,481.28 - (3,331.28) 2320.85% 000-491200 Investment Interest 12,000.00 5,677.34 15,500.39 26,508.61 - (14,508.61) 220.91% 000-497000 Misc Income-Drainage 242,200.00 13.86 867.00 164,265.29 - 77,934.71 67.82% TOTAL Miscellaneous 254,350.00 7,942.46 16,662.78 194,255.18 - 60,094.82 76.37% TOTAL REVENUES 2,763,927.00 289,992.92 1,166,568.39 1,357,489.32 - 1,406,437.68 49.11% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2018 Cash in Bank Claim on Operating Cash Pool-Checking 230,281.08$ Cash in Investments Lone Star Investment-Drainage Maint Fund 1,306,962.77 Total Cash in Bank & Investments 1,537,243.85$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: September 30, 2018 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 550,000.00 155,887.19 499,466.20 520,423.78 - 29,576.22 94.62% Miscellaneous 13,650.00 9,660.97 12,294.50 28,837.57 - (15,187.57) 211.26% TOTAL REVENUES 563,650.00 165,548.16 511,760.70 549,261.35 - 14,388.65 97.45% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 110,000.00 18,881.17 84,605.07 85,797.47 - 24,202.53 78.00% Operations Support 68,425.00 3,486.00 36,427.77 32,375.17 - 36,049.83 47.31% Professional Services 3,000.00 1,276.13 3,000.00 4,276.13 - (1,276.13) 142.54% Fund Charges/Transfers 67,605.00 16,601.25 66,405.00 66,405.00 - 1,200.00 98.22% Maintenance Services 10,000.00 7,879.35 3,511.94 7,879.35 - 2,120.65 78.79% Capital Outlay 63,806.00 - - 8,255.00 - 55,551.00 12.94% TOTAL NONDEPARTMENTAL 322,836.00 48,123.90 193,949.78 204,988.12 - 117,847.88 63.50% TOTAL EXPENDITURES 322,836.00 48,123.90 193,949.78 204,988.12 - 117,847.88 63.50% REVENUE OVER(UNDER) EXPENDITURE 240,814.00 117,424.26 317,810.92 344,273.23 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 Cash in Bank Claim on Operating Cash Pool-Checking 144,240.85$ Cash in Investments Texas Class - Hotel Tax 1,671,397.58 Total Cash in Bank & Investments 1,815,638.43$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2018 HOTEL OCCUPANCY TAX FUND OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 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 - 98,000.00 139,000 - (69,000.00) 198.57% Fund Transfers 109,829.69 - - - - 109,829.69 0.00% Miscellaneous 60,000.00 2,118.46 3,715.52 6,848.42 - 53,151.58 11.41% TOTAL REVENUES 239,829.69 2,118.46 101,715.52 145,848.42 - 93,981.27 60.81% EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services 26,900.00 7,889.30 - 16,139.30 10,721.00 39.70 99.85% Operating Equipment 10,000.00 1,425.71 19,486.93 1,425.71 - 8,574.29 14.26% Capital Outlay 202,929.69 34,438.75 59,139.06 121,934.15 50,690.63 30,304.91 85.07% TOTAL PARKLAND DEDICATION 239,829.69 43,753.76 78,625.99 139,499.16 61,411.63 38,918.90 83.77% TOTAL EXPENDITURES 239,829.69 43,753.76 78,625.99 139,499.16 61,411.63 38,918.90 83.77% REVENUE OVER(UNDER) EXPEND - (41,635) 23,090 6,349 (61,412) 55,062 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 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 - 98,000.00 139,000.00 - (69,000.00) 198.57% TOTAL Fees 70,000.00 - 98,000.00 139,000.00 - (69,000.00) 198.57% Fund Transfers 000-48100 Transfer In- Reserves 109,829.69 - - - - 109,829.69 0.00% TOTAL Fund Transfers 109,829.69 - - - - 109,829.69 0.00% Miscellaneous 000-491000 Interest Earned 100.00 219.74 322.57 794.66 - (694.66) 794.66% 000-491200 Investment Interest 3,000.00 1,898.72 3,392.95 6,053.76 - (3,053.76) 201.79% 000-499100 Transfer From Parks Reserve 56,900.00 - - - - 56,900.00 0.00% TOTAL Miscellaneous 60,000.00 2,118.46 3,715.52 6,848.42 - 53,151.58 11.41% TOTAL REVENUES 239,829.69 2,118.46 101,715.52 145,848.42 - 93,981.27 60.81% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 Cash in Bank Current Claim on Operating Cash Pool-Checking 37,742.95 Cash in Investments Texas Class- Park Fund 336,417.50 Total in Investment Pool 336,417.50 Total Cash in Bank & Investments 374,160.45 CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2018 PARK FUND 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER EXPENSE Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 72,500.00 (2,158.50) - 74,116.10 100,522 - (28,021.50) 138.65% Fund Transfers 81,400.00 - - - - - 81,400.00 0.00% Miscellaneous 3,100.00 2,262.17 - 3,310.91 6,888 - (3,788.41) 222.21% TOTAL REVENUES 157,000.00 103.67 - 77,427.01 107,409.91 - 49,590.09 68.41% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services-Trees 157,000.00 4,275.00 - 85,901.00 7,518.00 - 149,482.00 4.79% TOTAL TREE MITIGATION 157,000.00 4,275.00 - 85,901.00 7,518.00 - 149,482.00 4.79% TOTAL EXPENDITURES 157,000.00 4,275.00 - 85,901.00 7,518.00 - 149,482.00 4.79% REVENUE OVER(UNDER) EXPEND - (4,171.33) - (8,473.99) 99,891.91 - (99,891.91) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 319-TREE MITIGATION 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-458900 Tree Mitigation 72,500.00 (2,158.50) 74,116.10 100,521.50 - (28,021.50) 138.65% TOTAL Fees 72,500.00 (2,158.50) 74,116.10 100,521.50 - (28,021.50) 138.65% Fund Transfers 000-481000 Transfer In - Reserves 81,400.00 - - - - 81,400.00 0.00% TOTAL Fund Transfers 81,400.00 - - - - 81,400.00 0.00% Miscellaneous 000-491000 Interest Earned 100.00 455.40 58.02 1,152.65 - (1,052.65) 1152.65% 000-491200 Investment Interest 3,000.00 1,806.77 3,252.89 5,735.76 - (2,735.76) 191.19% TOTAL Miscellaneous 3,100.00 2,262.17 3,310.91 6,888.41 - (3,788.41) 222.21% TOTAL REVENUES 157,000.00 103.67 77,427.01 107,409.91 - 49,590.09 68.41% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 Cash in Bank Claim on Operating Cash Pool-Checking $53,670.81 Cash in Investments MBIA Investment-Tree Mitigation 378,133.57 Total Cash in Bank & Investments $431,804.38 CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2018 TREE MITIGATION FUND 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 312,471.00 1,433,309.40 1,544,962.40 - (444,962.40) 140.45% Miscellaneous 40,200.00 34,678.03 38,537.40 102,748.97 - (62,548.97) 255.59% TOTAL REVENUES 1,140,200.00 347,149.03 1,471,846.80 1,647,711.37 - (507,511.37) 144.51% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 256,000.00 - 1,000.00 1,000.00 - 255,000.00 0.39% TOTAL NON DEPARTMENTAL 256,000.00 - 1,000.00 1,000.00 - 255,000.00 0.39% TOTAL MISC & PROJECTS - - - - - - 0.00% TOTAL EXPENDITURES 256,000.00 - 1,000.00 1,000.00 - 255,000.00 0.39% REVENUE OVER(UNDER) EXPENDITURES 884,200.00 347,149.03 1,470,846.80 1,646,711.37 - (762,511.37) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 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 312,471.00 1,433,309.40 1,544,962.40 - (444,962.40) 140.45% TOTAL Fees 1,100,000.00 312,471.00 1,433,309.40 1,544,962.40 - (444,962.40) 140.45% Miscellaneous 000-491000 Interest Earned 200.00 887.75 862.78 5,527.07 - (5,327.07) 2763.54% 000-491200 Investment Income 40,000.00 33,790.28 37,674.62 97,221.90 - (57,221.90) 243.05% TOTAL Miscellaneous 40,200.00 34,678.03 38,537.40 102,748.97 - (62,548.97) 255.59% TOTAL REVENUES 1,140,200.00 347,149.03 1,471,846.80 1,647,711.37 - (507,511.37) 144.51% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 Cash in Bank Claim on Operating Cash Pool-Checking 183,706.73$ Cash in Investments Lone Star Investment-Capital Recovery Water 6,308,367.05 Total Cash in Bank & Investments 6,492,073.78$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2018 CAPITAL RECOVERY WATER 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER EXPENSES Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 550,000.00 145,776.00 - 744,573.60 821,969 - (271,968.80) 149.45% Fund Transfers 359,700.00 - - - - - 359,700.00 0.00% Miscellaneous 40,150.00 31,076.31 - 36,518.45 85,591 - (45,441.21) 213.18% TOTAL REVENUES 949,850.00 176,852.31 - 781,092.05 907,560.01 - 42,289.99 95.55% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 335,500.00 1,092.26 - 5,355.94 5,360.28 - 330,139.72 1.60% Fund Charges/Transfers 487,848.00 - - - 487,848.00 - - 100.00% TOTAL NON DEPARTMENTAL 823,348.00 1,092.26 - 5,355.94 493,208.28 - 330,139.72 59.90% TOTAL EXPENDITURES 823,348.00 1,092.26 - 5,355.94 493,208.28 - 330,139.72 59.90% REVENUE OVER(UNDER) EXPENDITURES 126,502.00 175,760.05 - 775,736.11 414,351.73 - (287,849.73) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30, 2018 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 550,000.00 136,776.00 717,573.60 794,968.80 - (244,968.80) 144.54% 000-455913 Cap Recovery-North Sewer Tr - 9,000.00 27,000.00 27,000.00 - (27,000.00) 0.00% TOTAL Fees 550,000.00 145,776.00 744,573.60 821,968.80 - (271,968.80) 149.45% Fund Transfers 000-481000 Transfer from Reserves 359,700.00 - - - - 359,700.00 0.00% TOTAL Fund Transfers 359,700.00 - - - - 359,700.00 0.00% Miscellaneous 000-491000 Interest Earned 150.00 263.59 729.64 3,799.09 - (3,649.09) 2532.73% 000-491200 Investment Income 40,000.00 32,592.22 63,424.39 104,839.85 - (64,839.85) 262.10% 000-491800 Gain/Loss - 9.38 (13,176.07) (11,125.56) - 11,125.56 0.00% 000-491900 Unrealized Gain/Loss-Cap One - (1,788.88) (14,459.51) (11,922.17) - 11,922.17 0.00% TOTAL Miscellaneous 40,150.00 31,076.31 36,518.45 85,591.21 - (45,441.21) 213.18% TOTAL REVENUES 949,850.00 176,852.31 781,092.05 907,560.01 - 42,289.99 95.55% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: September 30, 2018 Cash in Bank Claim on Operating Cash Pool-Checking 248,962.40$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 4,010,603.15 Capital One-Investment 1,758,846.72 Total Cash in Bank & Investments 6,018,412.27$ CASH IN BANK AND INVESTMENTS AS OF: September 30, 2018 CAPITAL RECOVERY SEWER 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,030,353.00 65,164.97 6,149,843.74 6,148,041.49 - (117,688.49) 101.95% Fund Transfers 487,110.00 - - - - 487,110.00 0.00% Miscellaneous 477,069.00 104,433.53 508,777.06 522,697.40 - (45,628.40) 109.56% TOTAL REVENUES 6,994,532.00 169,598.50 6,658,620.80 6,670,738.89 - 323,793.11 95.37% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 2,550.00 2,000.00 2,950.00 4,150.00 - (1,600.00) 162.75% Debt Service 6,991,982.00 1,201,169.67 6,517,165.55 7,016,812.60 - (24,830.60) 100.36% TOTAL GENERAL GOVERNMENT 6,994,532.00 1,203,169.67 6,520,115.55 7,020,962.60 - (26,430.60) 100.38% - TOTAL EXPENDITURES 6,994,532.00 1,203,169.67 6,520,115.55 7,020,962.60 - (26,430.60) 100.38% ** REVENUE OVER(UNDER) EXPEND - (350,223.71) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 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,030,353.00 65,164.97 6,149,843.74 6,148,041.49 - (117,688.49) 101.95% TOTAL Taxes 6,030,353.00 65,164.97 6,149,843.74 6,148,041.49 - (117,688.49) 101.95% 000-486000 Transfer From Reserves 487,110.00 - - - - 487,110.00 0.00% TOTAL Fund Transfers 487,110.00 - - - - 487,110.00 0.00% Miscellaneous 000-491000 Interest Earned 300.00 60.72 208.46 4,352.44 - (4,052.44) 1450.81% 000-491200 Investment Earnings 16,000.00 29,372.81 47,549.85 57,575.96 - (41,575.96) 359.85% 000-495015 Contribution from SED 360,769.00 - 361,018.75 360,769.00 - - 100.00% 000-495020 Contribution from YMCA 100,000.00 75,000.00 100,000.00 100,000.00 - - 100.00% TOTAL Miscellaneous 477,069.00 104,433.53 508,777.06 522,697.40 - (45,628.40) 109.56% TOTAL REVENUES 6,994,532.00 169,598.50 6,658,620.80 6,670,738.89 - 323,793.11 95.37% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 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 2,550.00 2,000.00 2,950.00 4,150.00 - (1,600.00) 162.75% TOTAL Professional Services 2,550.00 2,000.00 2,950.00 4,150.00 - (1,600.00) 162.75% Debt Service 101-555612 Bond-GO Refunding 2010-Principal 285,000.00 - 285,000.00 285,000.00 - - 100.00% 101-555612.1 Bond-GO Refunding 2010 Interest 38,475.00 17,100.00 47,025.00 38,475.00 - - 100.00% 101-555629 GO Bond 2007-Principal 290,000.00 - 280,000.00 290,000.00 - - 100.00% 101-555629.1 GO Bond 2007-Interest 136,345.00 65,188.96 147,691.26 136,312.21 - 32.79 99.98% 101-555630 GO Bond SR2008 Principal 475,000.00 - 460,000.00 475,000.00 - - 100.00% 101-555630.1 GO Bond SR2008 Interest 259,055.00 - 278,362.00 210,487.60 - 48,567.40 81.25% 101-555631 GO Bond SR2009 Principal 550,000.00 - 550,000.00 550,000.00 - - 100.00% 101-555631.1 BO Bond SR2009 Interest 249,138.00 120,100.00 266,325.00 249,137.50 - 0.50 100.00% 101-555633 GO SR2011 Principal 240,000.00 - 235,000.00 240,000.00 - - 100.00% 101-555633.1 GO SR2011 Interest 327,038.00 161,418.75 334,762.50 327,037.50 - 0.50 100.00% 101-555634 GO SR2011A Refund Principal 635,000.00 - 620,000.00 635,000.00 - - 100.00% 101-555634.1 GO SR2011A Refund Interest 87,783.00 40,110.31 101,962.09 87,700.56 - 82.44 99.91% 101-555635 GO SR2012 Principal 335,000.00 - 320,000.00 335,000.00 - - 100.00% 101-555635.1 GO SR2012 Interest 168,095.00 80,697.50 181,755.00 168,095.00 - - 100.00% 101-555636 Tax Note - SR2013 - Principal 170,000.00 - 170,000.00 170,000.00 - - 100.00% 101-555636.1 Tax Note - SR2013 - Interest 1,445.00 - 3,995.00 1,445.00 - - 100.00% 101-555637 Tax Note - SR 2013A - Principal 165,000.00 - 160,000.00 165,000.00 - - 100.00% 101-555637.1 Tax Note - SR2013 - Interest 1,073.00 - 3,185.00 1,072.49 - 0.51 99.95% 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 289,775.00 144,137.50 292,275.00 289,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 2,538.00 1,268.75 3,139.26 2,531.77 - 6.23 99.75% 101-555640 Bond-Ref 2015 Bond- Principal 490,000.00 - 450,000.00 490,000.00 - - 100.00% 101-555640.1 Bond-GO Ref 2015- Interest 92,725.00 43,912.50 102,125.00 92,725.00 - - 100.00% 101-555641 Tax Note - SR2015A - Principal 145,000.00 145,000.00 145,000.00 145,000.00 - - 100.00% 101-555641.1 Tax Note - SR2015A - Interest 11,550.00 5,775.00 13,750.92 11,506.58 - 43.42 99.62% 101-555642 GO Bond SR2016 Principal 205,000.00 - 405,000.00 205,000.00 - - 100.00% 101-555642.1 GO Bond SR2016 Interest 167,607.00 81,753.13 175,756.26 167,606.26 - 0.74 100.00% 101-555643 CO Bond Tax SR2016 Principal 55,000.00 - 55,000.00 55,000.00 - - 100.00% 101-555643.1 CO Bond Tax SR2016 Interest 47,238.00 23,206.25 48,887.50 47,237.50 - 0.50 100.00% 101-555644 CO Bond nonTax SR2016 Principal 165,000.00 - 170,000.00 165,000.00 - - 100.00% 101-555644 CO Bond nonTax SR2016 Interest 69,469.00 33,084.38 76,168.76 69,468.76 - 0.24 100.00% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 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, 2018 101-555645 CO Bond SR2017 Principal 245,000.00 - - 245,000.00 - - 100.00% 101-555645.1 CO Bond SR2017 Interest 178,689.00 71,612.50 - 178,688.06 - 0.94 100.00% 101-555646 Bond-GO SR2017 Principal 135,000.00 - - 135,000.00 - - 100.00% 101-55646.1 Bond - GO SR2017 Interest 143,944.00 58,237.50 - 143,944.17 - (0.17) 100.00% 101-555647.1 Bond - GO 2018 Refund Interest - 73,566.64 - 73,566.64 - (73,566.64) 0.00% TOTAL Debt Service 6,991,982.00 1,201,169.67 6,517,165.55 7,016,812.60 - (24,830.60) 100.36% TOTAL EXPENDITURES 6,994,532.00 1,203,169.67 6,520,115.55 7,020,962.60 - (28,030.60) 100.38% Cash in Bank Claim on Operating Cash Pool-Checking 27,896.35$ MBIA Investment- Tax I&S 1,071,962.07 Total Cash in Bank & Investments 1,099,858.42$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2018 TAX I&S 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 3,962,572.00 1,069,742.27 3,620,929.57 4,223,053.39 - (260,481.39) 106.57% Fund Transfers 225,000.00 - - - - 225,000.00 0.00% Miscellaneous 120,301.00 81,746.40 125,682.23 264,686.61 - (144,385.61) 220.02% TOTAL REVENUES 4,307,873.00 1,151,488.67 3,746,611.80 4,487,740.00 - (179,867.00) 104.18% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Supplies 750.00 156.69 415.47 512.83 - 237.17 0.00% Human Services 500.00 - 389.64 - - 500.00 1277.92% City Support Services 37,700.00 1,800.52 5,654.48 6,389.61 - 31,310.39 6.09% Utility Services 3,870.00 568.27 2,386.78 2,295.02 - 1,574.98 2393.28% Operations Support 172,000.00 36,408.50 63,855.37 92,620.12 - 79,379.88 6.69% Staff Support 21,900.00 1,516.13 14,846.49 11,509.88 - 10,390.12 2456.37% City Assistance 1,042,500.00 112,847.65 1,050.52 537,945.97 - 504,554.03 2.36% Professional Services 82,500.00 9,303.52 20,353.85 24,563.65 - 57,936.35 1294.48% Fund Charges/Transfers 1,067,945.00 265,000.00 792,077.75 1,067,945.00 - - 100.00% Maintenance Services 1,000.00 70.00 - 455.00 - 545.00 45.50% Operating Equipment 4,200.00 359.62 3,341.00 935.64 - 3,264.36 22.28% TOTAL ECONO DEVELOPMENT 2,434,865.00 428,030.90 904,371.35 1,745,172.72 - 689,692.28 71.67% TOTAL EXPENDITURES 2,434,865.00 428,030.90 904,371.35 1,745,172.72 - 689,692.28 71.67% ** REVENUE OVER(UNDER) EXPEND 1,873,008.00 723,457.77 2,842,240.45 2,742,567.28 - (869,559.28) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2018 Cash in Bank Claim on Operating Cash Pool-Checking 397,525.61$ Cash in Investments Texas Class Investment-Economic Development Corp 14,578,596.46 Schertz Bank & Trust-Certificate of Deposit 1,018,080.00 Schertz Bank & Trust-Certificate of Deposit 1,068,158.87 Total Cash in Bank & Investments 17,062,360.94$ CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2018 SED CORPORATION OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2017-18 322,292 343,024 307,585 313,990 372,357 291,909 336,784 375,378 320,141 420,127 397,558 317,390 2016-17 287,235 379,299 290,086 280,216 373,641 243,369 216,222 334,771 276,770 283,282 348,268 286,986 2015-16 239,534 372,334 264,843 246,568 391,510 265,249 265,854 307,920 284,254 261,570 2014-15 247,750 319,452 252,513 210,669 397,691 225,482 247,025 361,702 232,983 248,121 379,939 254,153 12.1% -9.6% 48.3%14.2% 10.6% $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 Chart Title