Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
01-First 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 33,489,265 10,771,934.15 0.00 22,717,330.42 32.17% Total General Government 6,751,996 1,349,502.39 665,593.76 4,736,899.50 29.84% Total Public Safety 14,513,000 3,657,142.18 606,177.32 10,249,680.80 29.38% Total Public Environment 1,474,297 441,864.43 43,235.64 989,196.93 32.90% Total Parks & Recreation 2,668,513 411,623.91 81,558.53 2,175,330.56 18.48% Total Cultural 967,904 253,976.53 24,630.49 689,296.98 28.78% Total Health 500,269 116,168.85 3,963.60 380,136.55 24.01% Total Internal Services 6,240,620 1,379,627.87 155,755.75 4,705,236.38 24.60% Total Misc & Projects 372,666 54,033.53 114,442.63 204,189.84 45.21% Total Expenditures 33,489,265 7,663,939.69 1,695,357.72 24,129,967.54 27.95% Revenue Over(Under) Expenditures 0 3,107,994.46 General Fund, 101 Total Cash in Bank & Investments 16,512,629.01 Special Events Fund, 106 Total Revenues 156,760 33,119.33 0.00 123,640.67 21.13% Total Expenditures 156,510 31,463.68 9,369.09 115,677.23 26.09% Revenue Over(Under) Expenditures 250 1,655.65 Special Events Fund, 106 Total Cash in Bank & Investments 87,972.96 Peg Fund, 110 Total Revenues 195,000 20,983.42 0.00 174,016.58 10.76% Total Expenditures 195,000 0.00 0.00 195,000.00 0.00% Revenue Over(Under) Expenditures 0 20,983.42 Peg Fund, 110 Total Cash in Bank & Investments 722,905.27 Water & Sewer, 202 Total Revenues 25,212,544 5,827,060.24 0.00 19,385,483.26 23.11% Total Expenditures 24,457,046 4,743,686.42 295,744.48 19,417,614.85 20.61% Revenue Over(Under) Expenditures 755,498 1,083,373.82 Water & Sewer, 202 Total Cash in Bank & Investments 10,381,703.40 Quarterly Statement Schertz, Texas AS OF :DECEMBER 31, 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,345,315 2,565,466.39 0.00 6,779,848.80 27.45% Total Expenditures 9,235,636 2,117,390.15 155,150.90 6,963,095.18 24.61% Revenue Over(Under) Expenditures 109,679 448,076.24 EMS, 203 Total Cash in Bank & Investments 170,001.99 Drainage, 204 Total Revenues 1,732,083 340,948.25 0.00 1,391,134.75 19.68% Total Expenditures 1,717,292 302,912.64 441,250.95 973,127.91 43.33% Revenue Over(Under) Expenditures 14,792 38,035.61 Drainage, 204 Total Cash in Bank & Investments 1,561,802.00 Hotel Tax, 314 Total Revenues 528,000 119,061.02 0.00 408,938.98 22.55% Total Expenditures 256,732 80,809.19 0.00 175,922.81 31.48% Revenue Over(Under) Expenditures 271,268 38,251.83 Hotel Tax, 314 Total Cash in Bank & Investments 1,855,436.15 Park, 317 Total Revenues 100,000 7,492.93 0.00 92,507.07 7.49% Total Expenditures 100,000 61,806.70 14,704.93 23,488.37 76.51% Revenue Over(Under) Expenditures 0 (54,313.77) Park, 317 Total Cash in Bank & Investments 320,530.83 Tree Mitigation, 319 Total Revenues 80,250 467.08 0.00 79,782.92 0.58% Total Expenditures 75,000 6,900.00 0.00 68,100.00 9.20% Revenue Over(Under) Expenditures 5,250 (6,432.92) Tree Mitigation, 319 Total Cash in Bank & Investments 426,179.78 Capital Recovery Water, 411 Total Revenues 1,182,000 280,027.67 0.00 901,972.33 23.69% Total Expenditures 256,000 0.00 0.00 256,000.00 0.00% Revenue Over(Under) Expenditures 926,000 280,027.67 Capital Recovery Water, 411 Total Cash in Bank & Investments 6,785,857.53 Quarterly Statement Schertz, Texas AS OF :DECEMBER 31, 2018 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 151,283.06 0.00 492,716.94 23.49% Total Expenditures 260,500 730.46 0.00 259,769.54 0.28% Revenue Over(Under) Expenditures 383,500 150,552.60 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 6,184,162.39 I&S, 505 Total Revenues 6,653,723 2,938,745.69 0.00 3,714,977.31 44.17% Total Expenditures 6,653,723 1,550.00 0.00 6,652,173.27 0.02% Revenue Over(Under) Expenditures 0 2,937,195.69 I&S, 505 Total Cash in Bank & Investments 4,040,253.37 SED Corporation, 620 Total Revenues 5,749,744 1,246,100.37 0.00 4,503,643.63 21.67% Total Expenditures 5,749,744 251,632.93 1,062.46 5,497,048.61 4.39% Revenue Over(Under) Expenditures 0 994,467.44 SED Corporation, 620 Total Cash in Bank & Investments 17,062,360.94 Total Cash in Bank & Investments 66,111,795.62 66,111,795.62 Quarterly Statement Schertz, Texas AS OF :DECEMBER 31, 2018 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 21,519,002.00 8,192,817.15 8,203,584.82 8,192,817.15 - 13,326,184.85 38.07% Franchises 2,373,686.57 572,373.79 537,907.88 572,373.79 - 1,801,312.78 24.11% Permits 1,604,320.00 407,808.54 524,646.04 407,808.54 - 1,196,511.46 25.42% Licenses 56,760.00 11,950.00 13,802.50 11,950.00 - 44,810.00 21.05% Fees 1,843,973.00 577,575.39 526,357.66 577,575.39 - 1,266,397.61 31.32% Fines 22,000.00 2,694.21 5,180.44 2,694.21 - 19,305.79 12.25% Inter-Jurisdictional 967,008.00 65,946.97 135,921.98 65,946.97 - 901,061.03 6.82% Fund Transfers 4,445,965.00 797,314.08 769,914.54 797,314.08 - 3,648,650.92 17.93% Miscellaneous 656,550.00 143,454.02 191,584.02 143,454.02 - 513,095.98 21.85% TOTAL REVENUES 33,489,264.57 10,771,934.15 10,908,899.88 10,771,934.15 - 22,717,330.42 32.17% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 35,009.00 9,633.38 9,370.87 9,633.38 14.40 25,361.22 27.56% Supplies 1,000.00 98.92 - 98.92 - 901.08 9.89% City Support Services 27,500.00 6,085.93 11,189.37 6,085.93 12,696.52 8,717.55 68.30% Utility Services - - 119.20 - - - 0.00% Operations Support 300.00 178.40 29.00 178.40 116.00 5.60 98.13% Staff Support 32,150.00 11,865.57 12,281.34 11,865.57 241.90 20,042.53 37.66% Professional Services 8,000.00 - - - - 8,000.00 0.00% TOTAL CITY COUNCIL 103,959.00 27,862.20 32,989.78 27,862.20 13,068.82 63,027.98 39.37% CITY MANAGER Personnel Services 1,123,847.00 259,226.06 313,078.81 259,226.06 - 864,620.94 23.07% Supplies 2,000.00 219.72 251.79 219.72 43.00 1,737.28 13.14% City Support Services 6,000.00 - - - - 6,000.00 0.00% Utility Services 2,000.00 310.37 269.77 310.37 - 1,689.63 15.52% Operations Support 50.00 - - - - 50.00 0.00% Staff Support 26,625.00 2,433.64 3,691.03 2,433.64 812.26 23,379.10 12.19% Operating Equipment 1,000.00 314.39 - 314.39 - 685.61 31.44% TOTAL CITY MANAGER 1,161,522.00 262,504.18 317,291.40 262,504.18 855.26 898,162.56 22.67% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2018 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: December 31, 2018 MUNICIPAL COURT Personnel Services 254,795.00 83,640.69 83,741.39 83,640.69 - 171,154.31 32.83% Supplies 2,000.00 351.75 357.77 351.75 - 1,648.25 17.59% City Support Services 975.00 326.17 157.86 326.17 - 648.83 33.45% Operations Support 3,000.00 31.00 - 31.00 - 2,969.00 1.03% Staff Support 8,510.00 911.90 1,492.64 911.90 370.35 7,227.75 15.07% Court Support 700.00 168.00 - 168.00 - 532.00 24.00% Professional Services 73,960.00 11,972.56 15,000.00 11,972.56 28,150.00 33,837.44 54.25% Maintenance Services 3,000.00 450.00 500.00 450.00 2,350.00 200.00 93.33% TOTAL MUNICIPAL COURT 346,940.00 97,852.07 101,249.66 97,852.07 30,870.35 218,217.58 37.10% CUSTOMER RELATIONS-311 Personnel Services 120,977.00 36,283.50 34,168.21 36,283.50 - 84,693.50 29.99% Supplies 150.00 2.84 56.40 2.84 10.49 136.67 8.89% Staff Support 830.00 - - - - 830.00 0.00% TOTAL CUSTOMER RELATIONS-311 121,957.00 36,286.34 34,224.61 36,286.34 10.49 85,660.17 29.76% PLANNING & ZONING Personnel Services 210,124.00 53,424.80 55,018.80 53,424.80 - 156,699.20 25.43% Supplies 2,862.65 108.35 134.18 108.35 - 2,754.30 3.78% Operations Support 174.00 - - - 7.00 167.00 4.02% Staff Support 26,755.00 1,267.82 1,010.00 1,267.82 200.00 25,287.18 5.49% Professional Services 100.00 5.00 - 5.00 - 95.00 5.00% Operating Equipment 250.00 - - - - 250.00 0.00% TOTAL PLANNING & ZONING 240,265.65 54,805.97 56,162.98 54,805.97 207.00 185,252.68 22.90% LEGAL SERVICES Operations Support 10,000.00 341.75 331.84 341.75 766.55 8,891.70 11.08% Professional Services 150,000.00 21,913.83 11,639.48 21,913.83 11,776.44 116,309.73 22.46% TOTAL LEGAL SERVICES 160,000.00 22,255.58 11,971.32 22,255.58 12,542.99 125,201.43 21.75% CITY SECRETARY Personnel Services 186,399.00 53,888.94 50,872.83 53,888.94 - 132,510.06 28.91% Supplies 1,150.00 251.47 332.19 251.47 409.37 489.16 57.46% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: December 31, 2018 City Support Services 15,000.00 694.64 2,059.17 694.64 - 14,305.36 4.63% Operations Support 100.00 27.95 - 27.95 - 72.05 27.95% Staff Support 4,400.00 1,337.45 964.63 1,337.45 100.00 2,962.55 32.67% TOTAL CITY SECRETARY 207,049.00 56,200.45 54,228.82 56,200.45 509.37 150,339.18 27.39% NON-DEPARTMENTAL City Support Services 723,966.00 230,747.93 227,045.96 230,747.93 164,757.81 328,460.26 54.63% Operations Support 163,500.00 23,336.24 36,824.82 23,336.24 - 140,163.76 14.27% Staff Support 250.00 - 80.00 - - 250.00 0.00% City Assistance 1,844,730.00 145,384.31 139,081.25 145,384.31 436,152.91 1,263,192.78 31.52% Professional Services 51,235.00 11,437.19 17,242.26 11,437.19 - 39,797.81 22.32% Fund Chrgs/Transfrs-Spec Events Fnd 67,250.00 - - - - 67,250.00 0.00% TOTAL NON-DEPARTMENTAL 2,850,931.00 410,905.67 420,274.29 410,905.67 600,910.72 1,839,114.61 35.49% PUBLIC AFFAIRS Personnel Services 288,461.00 86,918.48 125,523.62 86,918.48 - 201,542.52 30.13% Supplies 1,050.00 81.14 448.80 81.14 31.99 936.87 10.77% Operations Support 43,500.00 1,346.84 1,495.30 1,346.84 - 42,153.16 3.10% Staff Support 6,850.00 333.00 149.00 333.00 108.00 6,409.00 6.44% Professional Services 304,980.00 73,063.48 74,704.43 73,063.48 220.00 231,696.52 24.03% TOTAL PUBLIC AFFAIRS 644,841.00 161,742.94 202,321.15 161,742.94 359.99 482,738.07 25.14% ENGINEERING Personnel Services 614,373.00 169,974.22 166,408.34 169,974.22 - 444,398.78 27.67% Supplies 2,720.00 81.31 64.52 81.31 - 2,638.69 2.99% City Support Services 900.00 - - - - 900.00 0.00% Utility Services 4,118.00 799.97 408.74 799.97 206.29 3,111.74 24.44% Operations Support 100.00 - - - - 100.00 0.00% Staff Support 12,658.00 292.94 235.21 292.94 340.94 12,024.12 5.01% Professional Services 71,000.00 195.42 - 195.42 - 70,804.58 0.28% Operating Equipment 3,351.00 - - - - 3,351.00 0.00% Capital Outlay 30,000.00 - - - - 30,000.00 0.00% TOTAL ENGINEERING 739,220.00 171,343.86 167,116.81 171,343.86 547.23 567,328.91 23.25% GIS Personnel Services 166,886.00 47,048.53 46,089.37 47,048.53 - 119,837.47 28.19% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: December 31, 2018 Supplies 1,740.00 - - - 1,145.86 594.14 65.85% Staff Support 4,600.00 - - - 3,176.48 1,423.52 69.05% Rental/Leasing 2,085.00 694.60 520.95 694.60 1,389.20 1.20 99.94% TOTAL GIS 175,311.00 47,743.13 46,610.32 47,743.13 5,711.54 121,856.33 30.49% TOTAL GENERAL GOVERNMENT 6,751,995.65 1,349,502.39 1,444,441.14 1,349,502.39 665,593.76 4,736,899.50 29.84% PUBLIC SAFETY POLICE Personnel Services 7,246,007.00 1,901,014.07 1,884,399.66 1,901,014.07 - 5,344,992.93 26.24% Supplies 59,348.32 28,214.97 2,962.67 28,214.97 2,017.70 29,115.65 50.94% City Support Services 26,000.00 24,229.31 24,229.52 24,229.31 - 1,770.69 93.19% Utility Services 127,278.50 15,853.68 14,255.39 15,853.68 - 111,424.82 12.46% Operations Support 12,121.00 689.00 340.25 689.00 - 11,432.00 5.68% Staff Support 148,368.53 24,626.28 24,100.45 24,626.28 21,199.45 102,542.80 30.89% City Assistance 18,200.00 519.15 1,267.22 519.15 - 17,680.85 2.85% Professional Services 70,443.00 24,564.36 12,105.11 24,564.36 4,950.00 40,928.64 41.90% Maintenance Services 62,645.00 12,745.00 8,770.00 12,745.00 - 49,900.00 20.34% Operating Equipment 86,074.65 37,755.46 - 37,755.46 13,332.36 34,986.83 59.35% Capital Outlay 499,322.30 - 252,324.39 - 241,778.95 257,543.35 48.42% TOTAL POLICE 8,355,808.30 2,070,211.28 2,224,754.66 2,070,211.28 283,278.46 6,002,318.56 28.17% FIRE RESCUE Personnel Services 4,552,388.00 1,299,550.16 1,114,451.35 1,299,550.16 - 3,252,837.84 28.55% Supplies 19,600.00 2,805.73 684.10 2,805.73 402.08 16,392.19 16.37% Utility Services 64,600.00 9,201.01 6,633.92 9,201.01 - 55,398.99 14.24% Operations Support 550.00 98.09 - 98.09 - 451.91 17.83% Staff Support 180,075.00 18,607.62 23,751.42 18,607.62 56,577.36 104,890.02 41.75% City Assistance 23,000.00 4,938.94 1,082.19 4,938.94 - 18,061.06 21.47% Professional Services 33,500.00 5,660.00 4,900.00 5,660.00 21,620.00 6,220.00 81.43% Maintenance Services 62,500.00 7,668.90 469.89 7,668.90 104.00 54,727.10 12.44% Other Costs - 1,594.08 102.05 1,594.08 - (1,594.08) 0.00% Rental/Leasing 33,900.00 3,950.82 20,202.39 3,950.82 11,852.46 18,096.72 46.62% Operating Equipment 105,000.00 13,449.83 12,810.91 13,449.83 28,102.36 63,447.81 39.57% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: December 31, 2018 Capital Outlay 186,500.00 - - - 170,568.57 15,931.43 91.46% TOTAL FIRE RESCUE 5,261,613.00 1,367,525.18 1,185,088.22 1,367,525.18 289,226.83 3,604,860.99 31.49% INSPECTIONS Personnel Services 729,754.00 194,850.49 169,710.40 194,850.49 - 534,903.51 26.70% Supplies 4,115.00 1,171.00 502.98 1,171.00 20.41 2,923.59 28.95% Utility Services 5,000.00 1,016.76 858.73 1,016.76 - 3,983.24 20.34% Operations Support 2,219.00 194.60 213.00 194.60 465.00 1,559.40 29.73% Staff Support 29,961.00 2,723.73 1,942.08 2,723.73 606.72 26,630.55 11.12% Professional Services 70,000.00 22,400.00 20,600.00 22,400.00 32,600.00 15,000.00 78.57% Operating Equipment 530.00 529.98 - 529.98 - 0.02 100.00% Capital Outlay 54,000.00 - - - - 54,000.00 0.00% TOTAL INSPECTIONS 895,579.00 222,886.56 193,827.19 222,886.56 33,692.13 639,000.31 28.65% TOTAL PUBLIC SAFETY 14,513,000.30 3,660,623.02 3,603,670.07 3,660,623.02 606,197.42 10,246,179.86 29.40% PUBLIC ENVIRONMENT STREETS Personnel Services 800,297.00 231,329.04 222,550.42 231,329.04 - 568,967.96 28.91% Supplies 102,450.00 14,610.40 14,622.55 14,610.40 3,530.90 84,308.70 17.71% Utility Services 177,200.00 30,856.05 27,335.75 30,856.05 500.00 145,843.95 17.70% Staff Support 14,550.00 3,641.20 1,331.04 3,641.20 1,732.81 9,175.99 36.93% Professional Services 15,000.00 5,030.00 - 5,030.00 - 9,970.00 33.53% Maintenance Services 285,500.00 - - - - 285,500.00 0.00% Rental/Lease 4,000.00 - 280.00 - - 4,000.00 0.00% Operating Equipment 10,300.00 - - - 1,471.93 8,828.07 14.29% Capital Outlay 65,000.00 156,397.74 4,761.88 156,397.74 36,000.00 (127,397.74) 296.00% TOTAL STREETS 1,474,297.00 441,864.43 270,881.64 441,864.43 43,235.64 989,196.93 32.90% TOTAL PUBLIC ENVIRONMENT 1,474,297.00 441,864.43 270,881.64 441,864.43 43,235.64 989,196.93 32.90% PARKS & RECREATION 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: December 31, 2018 PARKS DEPARTMENT Personnel Services 673,965.00 153,799.18 130,980.24 153,799.18 - 520,165.82 22.82% Supplies 99,900.00 14,317.91 13,735.97 14,317.91 3,838.23 81,743.86 18.17% City Support Services 10,000.00 4,463.46 578.00 4,463.46 313.94 5,222.60 47.77% Utility Services 220,500.00 42,164.54 25,083.03 42,164.54 14,026.47 164,308.99 25.48% Operations Support 1,000.00 - - - - 1,000.00 0.00% Staff Support 12,665.00 4,725.68 1,102.81 4,725.68 409.50 7,529.82 40.55% Professional Services 137,500.00 14,910.64 19,490.00 14,910.64 - 122,589.36 10.84% Maintenance Services 67,500.00 990.40 5,305.01 990.40 750.00 65,759.60 2.58% Rental/Leasing 2,000.00 770.00 9,057.48 770.00 807.72 422.28 78.89% Operating Equipment 12,500.00 4,094.92 188.68 4,094.92 8,497.06 (91.98) 100.74% Capital Outlay 365,500.00 1,801.98 6,178.54 1,801.98 49,650.00 314,048.02 14.08% TOTAL PARKS DEPARTMENT 1,603,030.00 242,038.71 211,699.76 242,038.71 78,292.92 1,282,698.37 19.98% SWIM POOL Supplies 25,500.00 - 1,820.79 - - 25,500.00 0.00% Utility Services 16,500.00 4,640.42 1,123.77 4,640.42 2,576.22 9,283.36 43.74% Maintenance Services 597,878.00 81,906.75 84,869.12 81,906.75 - 515,971.25 13.70% TOTAL SWIM POOL 639,878.00 86,547.17 87,813.68 86,547.17 2,576.22 550,754.61 13.93% EVENT FACILITIES Personnel Services 299,770.00 60,269.50 15,935.32 60,269.50 - 239,500.50 20.11% Supplies 6,150.00 841.06 1,338.58 841.06 169.55 5,139.39 16.43% Utility Services 51,350.00 5,479.54 6,424.97 5,479.54 - 45,870.46 10.67% Operations Support 11,200.00 2,469.84 14.59 2,469.84 305.09 8,425.07 24.78% Staff Support 5,135.00 1,629.96 30.00 1,629.96 214.75 3,290.29 35.92% Maintenance Services 20,000.00 - - - 20,000.00 Operating Equipment 32,000.00 12,348.13 684.97 12,348.13 - 19,651.87 38.59% TOTAL EVENT FACILITIES 425,605.00 83,038.03 24,428.43 83,038.03 689.39 341,877.58 19.67% TOTAL PARKS & RECREATION 2,668,513.00 411,623.91 323,941.87 411,623.91 81,558.53 2,175,330.56 18.48% CULTURAL LIBRARY 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: December 31, 2018 Personnel Services 750,254.00 209,686.36 209,193.69 209,686.36 - 540,567.64 27.95% Supplies 15,500.00 2,273.17 2,391.07 2,273.17 808.74 12,418.09 19.88% Utility Services 55,500.00 7,134.20 6,611.87 7,134.20 - 48,365.80 12.85% Operations Support 3,650.00 247.97 481.98 247.97 - 3,402.03 6.79% Staff Support 5,700.00 1,437.46 1,127.61 1,437.46 310.72 3,951.82 30.67% Professional Services 2,300.00 2,364.00 2,318.00 2,364.00 - (64.00) 102.78% Operating Equipment 135,000.00 30,833.37 34,183.56 30,833.37 23,511.03 80,655.60 40.26% TOTAL LIBRARY 967,904.00 253,976.53 256,307.78 253,976.53 24,630.49 689,296.98 28.78% TOTAL CULTURAL 967,904.00 253,976.53 256,307.78 253,976.53 24,630.49 689,296.98 28.78% HEALTH ANIMAL SERVICES Personnel Services 327,839.00 82,613.60 76,730.45 82,613.60 - 245,225.40 25.20% Supplies 37,380.00 10,927.03 8,080.56 10,927.03 1,597.80 24,855.17 33.51% City Support Services 3,500.00 - - - - 3,500.00 0.00% Utility Services 44,000.00 6,973.63 5,472.26 6,973.63 - 37,026.37 15.85% Operations Support 1,000.00 - 256.07 - - 1,000.00 0.00% Staff Support 13,750.00 1,550.55 1,152.60 1,550.55 - 12,199.45 11.28% City Assistance 17,000.00 5,639.90 2,626.09 5,639.90 - 11,360.10 33.18% Professional Services 25,800.00 3,905.00 4,616.10 3,905.00 2,345.70 19,549.30 24.23% Maintenance Services 7,500.00 245.27 975.00 245.27 - 7,254.73 3.27% Operating Equipment 22,500.00 833.03 250.00 833.03 - 21,666.97 3.70% TOTAL ANIMAL SERVICES 500,269.00 112,688.01 100,159.13 112,688.01 3,943.50 383,637.49 23.31% TOTAL HEALTH 500,269.00 112,688.01 100,159.13 112,688.01 3,943.50 383,637.49 23.31% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 626,643.00 174,899.75 139,064.92 174,899.75 - 451,743.25 27.91% Supplies 9,140.00 759.91 4,099.05 759.91 422.44 7,957.65 12.94% City Support Services 858,029.00 179,012.16 105,030.70 179,012.16 9,250.13 669,766.71 21.94% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: December 31, 2018 Utility Services 235,768.00 42,285.51 39,541.48 42,285.51 7,257.60 186,224.89 21.01% Staff Support 43,600.00 10,664.38 14,167.72 10,664.38 7,357.49 25,578.13 41.33% Professional Services 246,102.00 7,460.00 - 7,460.00 3,938.00 234,704.00 4.63% Maintenance Services 14,500.00 2,340.07 949.45 2,340.07 2,434.05 9,725.88 32.92% Operating Equipment 245,160.00 123,769.91 32,284.19 123,769.91 13,948.70 107,441.39 56.17% Capital Outlay 33,500.00 5,367.00 - 5,367.00 - 28,133.00 16.02% TOTAL INFORMATION TECHNOLOGY 2,312,442.00 546,558.69 335,137.51 546,558.69 44,608.41 1,721,274.90 25.56% HUMAN RESOURCES Personnel Services 424,635.00 105,773.26 109,970.06 105,773.26 - 318,861.74 24.91% Supplies 700.00 16.99 78.99 16.99 296.69 386.32 44.81% Human Services 74,500.00 8,873.47 8,402.75 8,873.47 25,245.15 40,381.38 45.80% City Support Services - - 204.36 - - - 0.00% Utility Services - - 75.98 - - - 0.00% Operations Support 9,000.00 1,327.05 5,855.83 902.00 25.82 8,072.18 10.31% Staff Support 36,500.00 6,280.16 398.66 6,705.21 2,844.28 26,950.51 26.16% City Assistance 10,000.00 770.00 975.00 770.00 - 9,230.00 7.70% Professional Services 54,600.00 - 2,234.25 - 8,937.00 45,663.00 16.37% Operating Equipment 2,000.00 - - - - 2,000.00 0.00% TOTAL HUMAN RESOURCES 611,935.00 123,040.93 128,195.88 123,040.93 37,348.94 451,545.13 26.21% FINANCE Personnel Services 620,362.00 142,545.39 169,450.26 142,545.39 - 477,816.61 22.98% Supplies 4,700.00 856.25 973.88 856.25 1,119.46 2,724.29 42.04% Operations Support 2,155.00 - - - - 2,155.00 0.00% Staff Support 9,495.00 400.00 2,269.26 400.00 370.00 8,725.00 8.11% Professional Sevices 34,500.00 - 7,252.00 - - 34,500.00 0.00% Operating Equipment 1,270.00 - - - - 1,270.00 0.00% TOTAL FINANCE 672,482.00 143,801.64 179,945.40 143,801.64 1,489.46 527,190.90 21.61% PURCHASING & ASSET MGT Personnel Services 210,449.00 58,659.44 59,037.13 58,659.44 - 151,789.56 27.87% Supplies 650.00 21.92 85.87 21.92 194.50 433.58 33.30% Utility Services - - 46.62 - - - 0.00% Operations Support 5,150.00 - - - 980.50 4,169.50 19.04% Staff Support 6,700.00 612.20 660.00 612.20 225.00 5,862.80 12.50% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: December 31, 2018 City Assistance 3,000.00 292.00 67.00 292.00 - 2,708.00 9.73% Operating Equipment 350.00 - - - - 350.00 0.00% TOTAL PURCHASING & ASSET MGT 226,299.00 59,585.56 59,896.62 59,585.56 1,400.00 165,313.44 26.95% FLEET SERVICE Personnel Services 354,881.00 70,440.94 87,162.84 70,440.94 - 284,440.06 19.85% Supplies 167,230.00 33,578.25 34,251.35 33,578.25 18,667.99 114,983.76 31.24% City Support Services 11,000.00 2,283.69 2,826.44 2,283.69 - 8,716.31 20.76% Utility Services 8,000.00 1,165.74 1,419.05 1,165.74 327.50 6,506.76 18.67% Staff Support 20,982.00 1,299.26 3,779.01 1,299.26 141.95 19,540.79 6.87% Maintenance Services 149,750.00 39,377.17 61,507.26 39,377.17 16,772.06 93,600.77 37.50% Operating Equipment 8,200.00 1,782.13 1,296.86 1,782.13 308.04 6,109.83 25.49% Capital Outlay 155,000.00 36,943.00 - 36,943.00 (150.00) 118,207.00 23.74% TOTAL FLEET SERVICE 875,043.00 186,870.18 192,242.81 186,870.18 36,067.54 652,105.28 25.48% FACILITY SERVICES Personnel Services 691,769.00 183,211.56 203,501.17 183,211.56 - 508,557.44 26.48% Supplies 146,800.00 21,611.13 25,133.07 21,611.13 6,823.34 118,365.53 19.37% Utility Services 170,500.00 24,553.02 24,870.36 24,553.02 - 145,946.98 14.40% Operation Support - - 6,086.14 - - - 0.00% Staff Support 15,800.00 1,393.74 1,617.86 1,393.74 451.05 13,955.21 11.68% Professional Services 85,550.00 18,749.84 5,986.81 18,749.84 - 66,800.16 21.92% Maintenance Services 373,535.91 69,851.58 39,133.01 69,851.58 17,102.92 286,581.41 23.28% Rental/Leasing 1,000.00 400.00 - 400.00 - 600.00 40.00% Operating Equipment 21,000.00 - - - - 21,000.00 0.00% Capital Outlay 36,464.09 - - - 10,464.09 26,000.00 28.70% TOTAL BUILDING MAINTENANCE 1,542,419.00 319,770.87 306,328.42 319,770.87 34,841.40 1,187,806.73 22.99% TOTAL INTERNAL SERVICE 6,240,620.00 1,379,627.87 1,201,746.64 1,379,627.87 155,755.75 4,705,236.38 24.60% MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 317,666.00 53,638.41 70,689.94 53,638.41 111,919.29 152,108.30 52.12% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: December 31, 2018 Operating Equipment 10,000.00 395.12 - 395.12 23.34 9,581.54 4.18% TOTAL CITY ASSISTANCE 327,666.00 54,033.53 70,689.94 54,033.53 111,942.63 161,689.84 50.65% COURT - RESTRICTED FUNDS Operating Equipment 45,000.00 - - - 2,500.00 42,500.00 5.56% TOTAL CITY ASSISTANCE 45,000.00 - - - 2,500.00 42,500.00 5.56% TOTAL MISC & PROJECTS 372,666.00 54,033.53 70,689.94 54,033.53 114,442.63 204,189.84 45.21% TOTAL EXPENDITURES 33,489,264.95 7,663,939.69 7,271,838.21 7,663,939.69 1,695,357.72 24,129,967.54 27.95% REVENUE OVER(UNDER) EXPEND.(0.38) 3,107,994.46 3,637,061.67 3,107,994.46 (1,695,357.72) (1,412,637.12) 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 13,122,952.00 6,189,809.76 6,183,879.02 6,189,809.76 - 6,933,142.24 47.17% 000-411200 Advalorem Tax - Delinquent 50,000.00 19,351.92 5,090.94 19,351.92 - 30,648.08 38.70% 000-411300 Advalorem Tax - P&I 50,000.00 9,589.58 4,750.49 9,589.58 - 40,410.42 19.18% 000-411500 Sales Tax Revenue-Gen Fund 8,252,000.00 1,962,321.86 1,998,920.78 1,962,321.86 - 6,289,678.14 23.78% 000-411600 Bingo Tax 50.00 24.30 11.25 24.30 - 25.70 48.60% 000-411700 Mixed Beverage Tax 44,000.00 11,719.73 10,932.34 11,719.73 - 32,280.27 26.64% TOTAL Taxes 21,519,002.00 8,192,817.15 8,203,584.82 8,192,817.15 - 13,326,184.85 38.07% Franchises 000-421200 Center Point/Entex Energy 82,988.93 14,860.02 16,207.59 14,860.02 - 68,128.91 17.91% 000-421220 City Public Service 1,022,833.82 235,961.23 231,582.11 235,961.23 - 786,872.59 23.07% 000-421240 Guadalupe Valley Elec Co-op 423,553.61 112,461.63 103,315.57 112,461.63 - 311,091.98 26.55% 000-421250 New Braunfels Utilities 74,472.96 16,697.29 15,945.24 16,697.29 - 57,775.67 22.42% 000-421300 Time Warner-State Franchise 298,637.68 69,224.85 70,832.02 69,224.85 - 229,412.83 23.18% 000-421460 AT&T Franchise Fee 152,418.58 47,493.48 34,095.09 47,493.48 - 104,925.10 31.16% 000-421480 Other Telecom Franchise 162,780.99 36,745.84 29,327.28 36,745.84 - 126,035.15 22.57% 000-421500 Solid Waste Franchise Fee 156,000.00 38,929.45 36,602.98 38,929.45 - 117,070.55 24.95% TOTAL Franchises 2,373,686.57 572,373.79 537,907.88 572,373.79 - 1,801,312.78 24.11% Permits 000-431100 Home Occupation Permit 500.00 245.00 210.00 245.00 - 255.00 49.00% 000-431205 Building Permit - Residential 618,520.00 129,601.00 189,909.00 129,601.00 - 488,919.00 20.95% 000-431210 Building Permit - Commercial 270,000.00 12,909.00 114,324.00 12,909.00 - 257,091.00 4.78% 000-431215 Building Permit - General 220,000.00 109,709.00 44,042.00 109,709.00 - 110,291.00 49.87% 000-431300 Mobile Home Permit 300.00 125.00 25.00 125.00 - 175.00 41.67% 000-431400 Signs Permit 5,800.00 1,880.00 943.00 1,880.00 - 3,920.00 32.41% 000-431500 Food Establishmnt Permit 63,000.00 51,020.00 55,540.00 51,020.00 - 11,980.00 80.98% 000-431600 Garage Sale Permit - - 2,135.00 - - - 0.00% 000-431700 Plumbing Permit 128,800.00 29,908.00 42,561.70 29,908.00 - 98,892.00 23.22% 000-431750 Electrical Permit 65,500.00 17,520.00 18,900.00 17,520.00 - 47,980.00 26.75% 000-431800 Mechanical Permit 65,900.00 14,940.00 16,960.00 14,940.00 - 50,960.00 22.67% 000-431900 Solicitor/Peddler Permit 1,500.00 330.00 20.00 330.00 - 1,170.00 22.00% 000-431950 Animal/Pet Permit 1,000.00 - 90.00 - - 1,000.00 0.00% 000-432000 Cert. of Occupancy Prmt 6,500.00 2,200.00 1,450.00 2,200.00 - 4,300.00 33.85% 000-432100 Security Alarm Permit 36,000.00 12,566.00 9,423.00 12,566.00 - 23,434.00 34.91% 000-432300 Grading/Clearing Permit 15,000.00 4,151.00 3,474.36 4,151.00 - 10,849.00 27.67% 000-432400 Development Permit 81,000.00 10,584.04 16,303.98 10,584.04 70,415.96 13.07% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31,2018 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31,2018 000-435000 Fire Permit 25,000.00 10,120.50 8,335.00 10,120.50 - 14,879.50 40.48% 000-436010 Network Nodes - - - - - - 0.00% TOTAL Permits 1,604,320.00 407,808.54 524,646.04 407,808.54 - 1,196,511.46 25.42% Licenses 000-441000 Alcohol Beverage License 8,000.00 2,310.00 2,937.50 2,310.00 - 5,690.00 28.88% 000-441300 Mobile Home License 160.00 40.00 40.00 40.00 - 120.00 25.00% 000-442000 Contractors License 45,600.00 8,750.00 10,150.00 8,750.00 - 36,850.00 19.19% 000-444000 Pet License 3,000.00 850.00 675.00 850.00 - 2,150.00 28.33% TOTAL Licenses 56,760.00 11,950.00 13,802.50 11,950.00 - 44,810.00 21.05% Fees 000-451000 Municipal Court Fines 382,303.00 163,810.65 132,591.10 163,810.65 - 218,492.35 42.85% 000-451100 Arrest Fee 21,012.00 6,585.28 4,479.11 6,585.28 - 14,426.72 31.34% 000-451110 Expunction Fee 120.00 - - - - 120.00 0.00% 000-451200 Warrant Fees 98,000.00 14,977.10 19,332.21 14,977.10 - 83,022.90 15.28% 000-451210 Court - Claims & Judgements - (214.89) - (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 860.22 628.58 860.22 - 1,915.78 30.99% 000-451400 Traffic Fine Costs TTL 6,000.00 3,210.43 2,117.35 3,210.43 - 2,789.57 53.51% 000-451510 Juvenile Case Mgmt Fee 23,236.00 7,198.59 5,257.90 7,198.59 - 16,037.41 30.98% 000-451520 Truancy Fee 3,934.00 1,370.82 936.81 1,370.82 2,563.18 34.85% 000-451600 Technology Fund Fee 18,793.00 5,767.53 4,147.23 5,767.53 - 13,025.47 30.69% 000-451700 Security Fee 7,475.00 4,325.67 3,205.38 4,325.67 - 3,149.33 57.87% 000-451800 Time Payment Fee - City 4,119.00 1,212.00 1,406.94 1,212.00 - 2,907.00 29.42% 000-451850 State Fines 10% Service Fee 20,000.00 11,167.35 8,502.14 11,167.35 - 8,832.65 55.84% 000-451900 DPS Payment - Local 6,210.00 1,200.01 1,517.34 1,200.01 - 5,009.99 19.32% 000-452000 Child Safety Fee 4,874.00 3,319.49 1,269.33 3,319.49 - 1,554.51 68.11% 000-452100 Platting Fees 57,000.00 21,500.00 7,750.00 21,500.00 - 35,500.00 37.72% 000-452200 Site Plan Fee 38,000.00 7,000.00 14,500.00 7,000.00 - 31,000.00 18.42% 000-452300 Plan Check Fee 514,260.00 131,060.93 175,383.00 131,060.93 - 383,199.07 25.49% 000-452320 Tree Mitigation Admin Fee 12,000.00 (225.00) 2,319.60 (225.00) - 12,225.00 -1.88% 000-452400 BOA/Zoning Fees 6,500.00 1,000.00 500.00 1,000.00 - 5,500.00 15.38% 000-452600 Specific Use/Zone Chng Fee 18,000.00 8,000.00 12,800.00 8,000.00 - 10,000.00 44.44% 000-452710 Zoning Ltr & Dev Rights 1,950.00 1,050.00 450.00 1,050.00 - 900.00 53.85% 000-453100 Reinspection Fees 100,100.00 48,050.00 33,500.00 48,050.00 - 52,050.00 48.00% 000-453110 Swim Pool Inspection Fee 2,920.00 - - - - 2,920.00 0.00% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31,2018 000-453120 Inspections Plan Review - - - - - - 0.00% 000-453211 Admin Fee-Inspections 15,500.00 4,300.00 6,400.00 4,300.00 - 11,200.00 27.74% 000-453310 Misc Inspection Fee - 300.00 1,700.00 300.00 - (300.00) 0.00% 000-453710 Foster Care 1,200.00 100.00 350.00 100.00 - 1,100.00 8.33% 000-454200 Pool Gate Admission Fee 24,000.00 (54.00) - (54.00) - 24,054.00 -0.23% 000-454300 Seasonal Pool Pass Fee 5,000.00 - - - - 5,000.00 0.00% 000-456120 Senior Center Meal Fee - 401.00 401.00 401.00 - (401.00) 0.00% 000-456500 Haz Mat Fees 5,000.00 1,041.25 - 1,041.25 - 3,958.75 20.83% 000-456600 Fire Re-inspection Fee 1,000.00 100.00 350.00 100.00 - 900.00 10.00% 000-456600 Sale of General Fixed Asset 20,000.00 - - - - 20,000.00 0.00% 000-458100 Sale of Merchandise-GovDeal - 1,475.00 - 1,475.00 (1,475.00) 000-458110 Sale of Merchandise-GovDeal 25,000.00 36,116.69 2,526.09 36,116.69 - (11,116.69) 144.47% 000-458400 Civic Center Rental Fees 197,000.00 49,038.37 40,959.75 49,038.37 - 147,961.63 24.89% 000-458401 Capital Recovery Fee-Civic Cntr 7,500.00 2,990.00 300.00 2,990.00 - 4,510.00 39.87% 000-458450 North Center Rental Fees 23,000.00 6,227.50 5,755.00 6,227.50 16,772.50 27.08% 000-458460 Senior Center Rental 7,200.00 2,100.00 - 2,100.00 - 5,100.00 29.17% 000-458500 Community Center Rental Fees 35,000.00 10,616.00 8,404.50 10,616.00 - 24,384.00 30.33% 000-458550 Pavilion Rental Fees 20,000.00 2,881.00 3,000.00 2,881.00 - 17,119.00 14.41% 000-458560 Chamber of Comm rent 7,800.00 1,950.00 1,950.00 1,950.00 - 5,850.00 25.00% 000-458570 Non-Resident SYSA League 10,000.00 - 9,280.00 - - 10,000.00 0.00% 000-458650 NonResident User Fee-BVYA 10,000.00 3,240.00 - 3,240.00 - 6,760.00 32.40% 000-458660 BVYA Utility Reimbursement 15,000.00 - - - - 15,000.00 0.00% 000-458670 SYSA Utility Reimbursement 15,000.00 - - - - 15,000.00 0.00% 000-458675 Lions Futbol Utility Reimbursement 10,000.00 3,516.00 2,344.00 3,516.00 - 6,484.00 35.16% 000-458700 Vehicle Impoundment 10,000.00 1,910.00 2,860.00 1,910.00 - 8,090.00 19.10% 000-459200 NSF Check Fee 100.00 - - - - 100.00 0.00% 000-459300 Notary Fee 200.00 - 24.00 - - 200.00 0.00% 000-459400 Maps, Copies, UDC, & Misc F - 10.00 5.00 10.00 - (10.00) 0.00% 000-459600 Animal Adoption Fee 12,500.00 4,171.00 3,891.00 4,171.00 - 8,329.00 33.37% 000-459700 Pet Impoundment Fee 6,300.00 1,365.00 1,882.00 1,365.00 - 4,935.00 21.67% 000-459800 Police Reports Fee 5,800.00 1,554.40 1,381.30 1,554.40 - 4,245.60 26.80% 000-45990 Fire - False Alarm Fee - - - - - - 0.00% TOTAL Fees 1,843,973.00 577,575.39 526,357.66 577,575.39 - 1,266,397.61 31.32% Fines 000-463000 Library Fines 22,000.00 2,694.21 5,180.44 2,694.21 - 19,305.79 12.25% TOTAL Fines 22,000.00 2,694.21 5,180.44 2,694.21 - 19,305.79 12.25% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31,2018 Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,077.00 - 19,321.28 - - 21,077.00 0.00% 000-473200 City of Seguin - Fire Contract 29,231.00 2,508.98 7,307.70 2,508.98 - 26,722.02 8.58% 000-473300 Guad Co - Library 218,000.00 54,288.00 18,096.00 54,288.00 - 163,712.00 24.90% 000-473400 Randolph AFB-Animal Cntrl 1,200.00 - - - - 1,200.00 0.00% 000-474200 Library Services - Cibolo 35,000.00 - 1.50 - - 35,000.00 0.00% 000-474210 Library Services-Selma 22,000.00 - - - - 22,000.00 0.00% 000-474400 Dispatch Service - Cibolo 166,000.00 - - - - 166,000.00 0.00% 000-474600 School Crossing Guard-Bexar 38,000.00 2,942.32 12,342.74 2,942.32 - 35,057.68 7.74% 000-474610 School Cross Guard-Guadalupe 38,500.00 6,207.67 8,852.76 6,207.67 - 32,292.33 16.12% 000-474700 School Officer Funding 348,000.00 - 63,750.00 - - 348,000.00 0.00% 000-474750 Crime Victim Liaison Agreement 50,000.00 - 6,250.00 - - 50,000.00 0.00% TOTAL Inter-Jurisdictional 967,008.00 65,946.97 135,921.98 65,946.97 - 901,061.03 6.82% Fund Transfers 000-480000 Indirect Costs - EMS 175,587.00 43,896.75 42,521.68 43,896.75 - 131,690.25 25.00% 000-480100 Indirect Costs - Hotel/Motel 67,582.00 16,895.53 16,601.25 16,895.53 - 50,686.47 25.00% 000-481000 Transfer In Reserves 1,609,075.00 - - - - 1,609,075.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.22 67,857.43 73,789.22 - 221,367.78 25.00% 000-486000 Interfund Chrges-Admin W&S 1,365,998.00 341,499.47 336,034.93 341,499.47 - 1,024,498.53 25.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 000-487000 Interfund Charges-Fleet 370,729.00 92,918.11 86,201.75 92,918.11 - 277,810.89 25.06% 000-488000 Interfund Charges-4B 456,630.00 228,315.00 220,697.50 228,315.00 - 228,315.00 50.00% 000-489000 Transfer In 70,000.00 - - - - 70,000.00 0.00% 000-489620 Contribution - SEDC - - - - - - 0.00% TOTAL Fund Transfers 4,445,965.00 797,314.08 769,914.54 797,314.08 - 3,648,650.92 17.93% Miscellaneous 000-491000 Interest Earned 35,000.00 16,198.08 3,993.55 16,198.08 - 18,801.92 46.28% 000-491200 Investment Income 200,000.00 61,850.50 34,112.55 61,850.50 - 138,149.50 30.93% 000-491800 Gain/Loss - - (4,843.84) - - - 0.00% 000-491900 Unrealized Gain/Loss - 1,993.00 (3,395.78) 1,993.00 - (1,993.00) 0.00% 000-493120 Donations-Public Library 10,000.00 5,892.50 525.15 5,892.50 - 4,107.50 58.93% 000-493130 Donations-Writing the Next Chap.- - - - - - 0.00% 000-493400 Donation - Animal Control 15,000.00 867.75 6,728.37 867.75 - 14,132.25 5.79% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31,2018 000-493401 Donations-A/C Microchip 1,000.00 15.00 255.00 15.00 - 985.00 1.50% 000-493402 Donations-Spay&Neuter 1,000.00 - - - - 1,000.00 0.00% 000-493404 Donations-TNR Program 500.00 - - - - 500.00 0.00% 000-493460 Donations-Parks 10,000.00 - - - - 10,000.00 0.00% 000-493465 Donations-Senior Center 10,000.00 3,064.03 2,850.53 3,064.03 - 6,935.97 30.64% 000-493503 Donations-Fire Rescue - - 350.00 - - - 0.00% 000-494481 LawEnforcemtOfficersStnd&Ed 3,650.00 - - - - 3,650.00 0.00% 000-494482 Grants - Police, Fire, Gen Fund 3,000.00 - - - - 3,000.00 0.00% 000-495100 Mobile Stage Rental Fees 2,100.00 - 550.00 - - 2,100.00 0.00% 000-497000 Misc Income-Gen Fund 45,000.00 (1,921.20) 54,636.80 (1,921.20) - 46,921.20 -4.27% 000-497005 Schertz Magazine Advertising 140,000.00 36,850.00 33,560.00 36,850.00 - 103,150.00 26.32% 000-497100 Misc Income-Police 3,800.00 1,275.41 985.80 1,275.41 - 2,524.59 33.56% 000-497200 Misc Income-Library 4,500.00 1,104.45 1,211.49 1,104.45 - 3,395.55 24.54% 000-497210 Misc Income-Library Copier 18,000.00 4,749.50 4,903.41 4,749.50 - 13,250.50 26.39% 000-497300 Misc Income-Animal Control - 115.00 128.75 115.00 - (115.00) 0.00% 000-497400 Misc Income-Streets Dept.60,000.00 5,444.25 7,976.10 5,444.25 - 54,555.75 9.07% 000-497500 Misc Income-TML Insurance 20,000.00 1,816.95 21,955.88 1,816.95 - 18,183.05 9.08% 000-497550 Misc Income-TML Reimbursemt 15,000.00 - 119.11 - - 15,000.00 0.00% 000-497600 Misc Income-Vending Mach.2,500.00 790.13 389.15 790.13 - 1,709.87 31.61% 000-497610 Misc Income- Muni Court - 150.00 2,036.40 150.00 - (150.00) 0.00% 000-498000 Reimbursmnt-Gen Fund 20,000.00 - 1,839.28 - - 20,000.00 0.00% 000-498100 Reimbursmnt Fire - Training 500.00 - - - - 500.00 0.00% 000-498105 Reimburmnt Police - DEA - 3,198.67 3,103.66 3,198.67 - (3,198.67) 0.00% 000-498107 Reimburmnt Police - Event - - - - - - 0.00% 000-498110 Reimbursmnt Fire - Emg. Acti-O 30,000.00 - 17,612.66 - - 30,000.00 0.00% 000-498150 Reimbursemnt - Library 6,000.00 - - - - 6,000.00 0.00% TOTAL Miscellaneous 656,550.00 143,454.02 191,584.02 143,454.02 - 513,095.98 21.85% TOTAL REVENUES 33,489,264.57 10,771,934.15 10,908,899.88 10,771,934.15 - 22,717,330.42 32.17% Cash in Bank Claim on Operating Cash Pool-Checking 4,926,935.06$ Cash in Investments LOGIC Investment-General Fund 8,939,261.25 LOGIC Investment-Equip Replacement 76,496.24 LOGIC Investment-Veh Replacement 516,883.06 LOGIC Investment-Air Condi Replacment 281,291.83 CAPITAL ONE Investment-General Fund 1,771,761.57 Total Cash in Bank & Investments 16,512,629.01$ GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2018 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2018-19 255,207 587,379 5,347,223 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 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2018-19 766,254 736,285 627,360 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% $- $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 2018-19 266,592 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 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 56,500.00 - - - - 56,500.00 0.00% Miscellaneous 100,260.00 33,119.33 21,277.05 33,119.33 - 67,140.67 33.03% TOTAL REVENUES 156,760.00 33,119.33 21,277.05 33,119.33 - 123,640.67 21.13% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental - - - - - - 0.00% TOTAL GENERAL GOVERNMENT - - - - - - 0.00% CULTURAL Festival of Angels 14,000.00 10,868.83 6,981.23 10,868.83 6,424.37 (3,293.20) 123.52% Employee Appreciation Event - - 8,333.76 - - - 0.00% 4th of July Jubilee 26,000.00 - - - 142.80 25,857.20 0.55% National Night Out 500.00 - - - - 500.00 0.00% Wilenchik Walk for Life 15,000.00 - - - 125.00 14,875.00 0.83% Schertz Fest 30,000.00 636.00 585.00 636.00 700.00 28,664.00 4.45% Schertz Sweetheart 24,000.00 1,378.68 197.26 1,378.68 27.88 22,593.44 5.86% Hal Baldwin Scholarship 15,510.00 10,611.62 7,952.61 10,611.62 - 4,898.38 68.42% Other Events 31,500.00 7,968.55 4,763.41 7,968.55 1,949.04 21,582.41 31.48% TOTAL CULTURAL 156,510.00 31,463.68 28,813.27 31,463.68 9,369.09 115,677.23 26.09% TOTAL EXPENDITURES 156,510.00 31,463.68 28,813.27 31,463.68 9,369.09 115,677.23 26.09% REVENUE OVER(UNDER) EXPEND 250.00 1,655.65 (7,536.22) 1,655.65 (9,369.09) 7,963.44 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 Cash in Bank Claim on Operating Cash Pool-Checking 70,487.36$ Cash in Investments Texas Class- Special Events 17,485.60 Total Cash in Bank & Investments 87,972.96$ SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2018 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 78,990.77 20,983.42 21,430.96 20,983.42 - 58,007.35 26.56% Fund Transfers 116,009.23 - - - - 116,009.23 0.00% TOTAL REVENUES 195,000.00 20,983.42 21,430.96 20,983.42 - 174,016.58 10.76% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental - - - - - - 0.00% TOTAL GENERAL GOVERNMENT - - - - - - 0.00% MISC & PROJECTS Projects 195,000.00 - - - - 195,000.00 0.00% TOTAL MISC & PROJECTS 195,000.00 - - - - 195,000.00 0.00% TOTAL EXPENDITURES 195,000.00 - - - - 195,000.00 0.00% REVENUE OVER(UNDER) EXPEND - 20,983.42 21,430.96 20,983.42 - (20,983.42) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 110-PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% 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 14,889.38 14,010.64 14,889.38 - 45,278.65 24.75% 000-421465 AT&T PEG Fee 18,822.74 6,094.04 7,420.32 6,094.04 - 12,728.70 32.38% TOTAL Franchises 78,990.77 20,983.42 21,430.96 20,983.42 - 58,007.35 26.56% Fund Transfers 000-489000 Transfer In 116,009.23 - - - - 116,009.23 0.00% TOTAL Fund Transfers 116,009.23 - - - - 116,009.23 0.00% TOTAL REVENUES 195,000.00 20,983.42 21,430.96 20,983.42 - 174,016.58 10.76% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF:DECEMBER 31, 2018 Cash in Bank Cash Balance 722,905.27$ Total Cash in Bank & Investments 722,905.27$ PEG FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2018 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 263,517.05 - 5,000.00 - - 263,517.05 0.00% Fees 24,439,057.45 5,735,445.54 5,597,030.84 5,735,446 - 18,703,611.91 23.47% Fund Transfers 162,858.00 35,250.00 35,377.50 35,250 - 127,608.00 21.64% Miscellaneous 347,111.00 56,364.70 59,867.27 56,365 - 290,746.30 16.24% TOTAL REVENUES 25,212,543.50 5,827,060.24 5,697,275.61 5,827,060.24 - 19,385,483.26 23.11% EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 499,900.00 108,542.86 121,145.01 108,542.86 - 391,357.14 21.71% Supplies 3,800.00 187.28 220.00 187.28 589.27 3,023.45 20.44% City Support Services 5,655.00 50.00 - 50.00 - 5,605.00 0.88% Utility Services 10,365.00 151.03 156.43 151.03 79.70 10,134.27 2.23% Operations Support 158,500.00 30,635.04 17,497.89 30,635.04 - 127,864.96 19.33% Staff Support 6,250.00 376.18 261.45 376.18 363.78 5,510.04 11.84% Professional Services 243,000.00 44,766.08 46,888.70 44,766.08 - 198,233.92 18.42% Maintenance Services 8,040.00 2,760.00 1,260.00 2,760.00 4,200.00 1,080.00 86.57% Operating Equipment 600.00 359.97 509.95 359.97 - 240.03 60.00% TOTAL BUSINESS OFFICE 936,110.00 187,828.44 187,939.43 187,828.44 5,232.75 743,048.81 20.62% W & S ADMINISTRATION Personnel Services 1,432,723.00 349,996.22 331,003.65 349,996.22 - 1,082,726.78 24.43% Supplies 187,500.00 11,143.97 26,485.11 11,143.97 36,782.78 139,573.25 25.56% Human Services 700.00 - - - - 700.00 0.00% City Support Services 230,500.00 43,665.44 44,440.98 43,665.44 795.54 186,039.02 19.29% Utility Services 3,526,800.00 662,708.66 724,921.35 662,708.66 628.35 2,863,462.99 18.81% Operations Support 11,300.00 1,313.08 1,329.47 1,313.08 2,949.66 7,037.26 37.72% Staff Support 35,000.00 8,653.35 1,744.67 8,653.35 2,005.77 24,340.88 30.45% City Assistance 1,500.00 - - - - 1,500.00 0.00% Professional Services 343,500.00 70,189.82 44,691.73 70,189.82 2,632.50 270,677.68 21.20% Fund Charges/Transfers 6,208,960.00 1,880,908.52 2,037,572.59 1,880,908.52 - 4,328,051.48 30.29% Maintenance Services 9,149,707.50 1,305,208.93 1,122,669.30 1,305,208.93 4,326.81 7,840,171.76 14.31% Other Costs 40,000.00 - 36,605.45 - 36,605.45 3,394.55 91.51% Debt Service 1,904,245.25 - - - - 1,904,245.25 0.00% Rental-Leasing 124,500.00 31,754.99 512.61 31,754.99 - 92,745.01 25.51% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31, 2018 Operating Equipment 9,000.00 - - - 725.53 8,274.47 8.06% Capital Outlay 315,000.00 190,315.00 - 190,315.00 204,162.64 (79,477.64) 125.23% TOTAL PUBLIC WORKS 23,520,935.75 4,555,857.98 4,371,976.91 4,555,857.98 291,615.03 18,673,462.74 20.61% MISC & PROJECTS PROJECTS Operations Support - - 964.26 - - - 0.00% Professional Services - - - - 6,172.50 (6,172.50) 0.00% TOTAL PROJECTS - - 964.26 - 6,172.50 (6,172.50) 0.00% TOTAL MISC & PROJECTS - - 964.26 - 6,172.50 (6,172.50) 0.00% TOTAL EXPENDITURES 24,457,045.75 4,743,686.42 4,560,880.60 4,743,686.42 303,020.28 19,410,339.05 20.63% ** REVENUE OVER(UNDER)EXPENSES **755,497.75 1,083,373.82 1,136,395.01 1,083,373.82 (303,020.28) (24,855.79) 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421490 Tower Leasing 263,517.05 - 5,000.00 - - 263,517.05 0.00% TOTAL Franchises 263,517.05 - 5,000.00 - - 263,517.05 0.00% Permits 000-432400 Development Permit - - - - - - 0.00% TOTAL Permits - - - - - - 0.00% Fees 000-455200 Garbage Collection Fee 5,217,962.06 1,306,937.95 1,164,746.45 1,306,937.95 - 3,911,024.11 25.05% 000-455600 Fire Line Fees 31,000.00 - 3,855.00 - - 31,000.00 0.00% 000-455700 Recycle Fee Revenue 315,500.00 84,488.61 75,130.79 84,488.61 - 231,011.39 26.78% 000-455800 W&S Line Constructn Reimbursemnt 20,000.00 5,782.00 9,151.00 5,782.00 - 14,218.00 28.91% 000-457100 Sale of Water 10,790,831.42 2,448,299.39 2,533,675.59 2,448,299.39 - 8,342,532.03 22.69% 000-457110 Edwards Water Lease 40,000.00 - 1.00 - - 40,000.00 0.00% 000-457120 Water Transfer Charge-Selma 6,233.00 21,246.88 - 21,246.88 - (15,013.88) 340.88% 000-457200 Sale of Meters 160,000.00 23,531.00 38,673.33 23,531.00 - 136,469.00 14.71% 000-457400 Sewer Charges 7,578,030.97 1,838,573.03 1,694,973.96 1,838,573.03 - 5,739,457.94 24.26% 000-457500 Water Penalties 277,000.00 6,086.68 76,023.72 6,086.68 - 270,913.32 2.20% 000-459200 NSF Check Fee-Water&Sewer 2,500.00 500.00 800.00 500.00 - 2,000.00 20.00% TOTAL Fees 24,439,057.45 5,735,445.54 5,597,030.84 5,735,445.54 - 18,703,611.91 23.47% Fund Transfers 000-486000 Transfer In- Reserve 21,858.00 - - - - 21,858.00 0.00% 000-486204 Interfnd Chrg-Drainage Bill 141,000.00 35,250.00 35,377.50 35,250.00 - 105,750.00 25.00% TOTAL Fund Transfers 162,858.00 35,250.00 35,377.50 35,250.00 - 127,608.00 21.64% Miscellaneous 000-490000 Misc Charges 1,000.00 2,752.00 2,622.00 2,752.00 - (1,752.00) 275.20% 000-491000 Interest Earned 25,000.00 17,979.55 6,210.11 17,979.55 - 7,020.45 71.92% 000-491200 Investment Income 180,000.00 34,837.57 21,586.05 34,837.57 - 145,162.43 19.35% 000-497000 Misc Income-W&S 15,000.00 795.58 1,751.36 795.58 - 14,204.42 5.30% 000-498110 Reimbursement-SSLGC 126,111.00 - 27,697.75 - - 126,111.00 0.00% TOTAL Miscellaneous 347,111.00 56,364.70 59,867.27 56,364.70 - 290,746.30 16.24% TOTAL REVENUES 25,212,543.50 5,827,060.24 5,697,275.61 5,827,060.24 - 19,385,483.26 23.11% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 Cash in Bank Claim on Operating Cash Pool-Checking -$ Cash in Investments Lone Star Investment-Water&Sewer 8,510,423.85 Lone Star Investment-W&S Customer Deposits 307,353.48 Lone Star Investment-W&S Equip Replacement 184,795.37 Lone Star Investment-W&S Veh Replacement 266,953.68 Schertz Bank & Trust-Certificate of Deposit 1,112,177.02 10,381,703.40$ Total Cash in Bank & Investments 10,381,703.40$ WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2018 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 6,194,079.80 1,528,499.62 1,571,300.26 1,528,499.62 - 4,665,580.18 24.68% Inter-Jurisdictional 3,025,485.39 1,017,400.87 777,856.62 1,017,400.87 - 2,008,084.52 33.63% Fund Transfers - - - - - - 0.00% Miscellaneous 125,750.00 19,565.90 104,720.50 19,565.90 - 106,184.10 15.56% TOTAL REVENUES 9,345,315.19 2,565,466.39 2,453,877.38 2,565,466.39 - 6,779,848.80 27.45% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 4,461,556.00 1,142,224.66 1,106,680.84 1,142,224.66 - 3,319,331.34 25.60% Supplies 431,050.00 91,460.18 102,233.54 91,460.18 37,420.00 302,169.82 29.90% City Support Services 99,500.00 32,051.49 24,613.10 32,051.49 - 67,448.51 32.21% Utility Services 127,000.00 23,597.70 19,269.33 23,597.70 1,315.80 102,086.50 19.62% Operations Support 73,700.00 21,094.68 13,851.83 21,094.68 160.00 52,445.32 28.84% Staff Support 79,250.00 11,622.66 6,927.54 11,622.66 6,253.05 61,374.29 22.56% City Assistance 568,866.81 46,675.16 137,316.70 46,675.16 45,738.90 476,452.75 16.25% Professional Services 162,140.00 17,742.33 21,047.61 17,742.33 39,039.01 105,358.66 35.02% Fund Charges/Transfers 2,694,628.42 681,777.83 1,144,670.34 681,777.83 - 2,012,850.59 25.30% Maintenance Services 12,000.00 960.00 - 960.00 299.00 10,741.00 10.49% Debt Service 288,895.00 - - - - 288,895.00 0.00% Rental-Leasing 141,000.00 34,186.62 17,385.21 34,186.62 - 106,813.38 24.25% Operating Equipment 89,550.00 13,996.84 1,613.51 13,996.84 18,425.14 57,128.02 36.21% Capital Outlay 6,500.00 - - - 6,500.00 - 100.00% TOTAL PUBLIC SAFETY 9,235,636.23 2,117,390.15 2,595,609.55 2,117,390.15 155,150.90 6,963,095.18 24.61% TOTAL EXPENDITURES 9,235,636.23 2,117,390.15 2,595,609.55 2,117,390.15 155,150.90 6,963,095.18 24.61% ** REVENUE OVER(UNDER) EXPENSES **109,678.96 448,076.24 (141,732.17) 448,076.24 (155,150.90) (183,246.38) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-456100 Ambulance/Mileage Transport 5,894,479.80 1,447,603.66 1,476,924.18 1,447,603.66 - 4,446,876.14 24.56% 000-456110 Subscription Program Fees 28,000.00 18,640.00 17,345.00 18,640.00 - 9,360.00 66.57% 000-456120 EMT Class - Fees 96,000.00 17,895.00 17,240.00 17,895.00 - 78,105.00 18.64% 000-456122 CE Class - Fees 21,500.00 - - - - 21,500.00 0.00% 000-456130 Immunization Fees 7,000.00 1,580.00 1,220.00 1,580.00 - 5,420.00 22.57% 000-456140 Billing Fees - External 25,000.00 5,336.23 4,779.93 5,336.23 - 19,663.77 21.34% 000-456150 Standby Fees 27,000.00 20,009.50 25,050.15 20,009.50 - 6,990.50 74.11% 000-456155 Community Services Support 75,000.00 6,474.20 27,156.00 6,474.20 - 68,525.80 8.63% 000-456160 MIH Services 20,000.00 6,362.00 1,585.00 6,362.00 - 13,638.00 31.81% 000-458110 Sales of Merchandise - GovDeal - 4,574.03 - 4,574.03 - (4,574.03) 0.00% 000-459200 NSF Check Fee 100.00 25.00 - 25.00 - 75.00 25.00% TOTAL Fees 6,194,079.80 1,528,499.62 1,571,300.26 1,528,499.62 - 4,665,580.18 24.68% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 843,577.17 70,298.17 - 70,298.17 - 773,279.00 8.33% 000-474300 Cibolo Support 410,582.70 102,645.68 86,616.91 102,645.68 - 307,937.02 25.00% 000-475100 Comal Co ESD #6 121,722.92 29,832.03 27,316.41 29,832.03 - 91,890.89 24.51% 000-475200 Live Oak Support 232,140.26 58,035.07 53,287.99 58,035.07 - 174,105.19 25.00% 000-475300 Universal City Support 300,091.66 75,022.92 70,320.93 75,022.92 - 225,068.74 25.00% 000-475400 Selma Support 148,697.12 37,174.28 27,971.59 37,174.28 - 111,522.84 25.00% 000-475500 Schertz Support 581,537.22 145,384.31 139,081.25 145,384.31 - 436,152.91 25.00% 000-475600 Santa Clara Support 10,789.68 2,697.42 2,611.84 2,697.42 - 8,092.26 25.00% 000-475800 Marion Support 16,346.66 4,086.67 3,796.74 4,086.67 - 12,259.99 25.00% 000-475910 TASPP Program 360,000.00 492,224.32 366,852.96 492,224.32 - (132,224.32) 136.73% TOTAL Inter-Jurisdictional 3,025,485.39 1,017,400.87 777,856.62 1,017,400.87 - 2,008,084.52 33.63% Miscellaneous 000-491000 Interest Earned 3,000.00 2,515.41 470.45 2,515.41 - 484.59 83.85% 000-491200 Investment Income 750.00 286.15 2,136.38 286.15 - 463.85 38.15% 000-493203 Donations-EMS 2,000.00 100.44 350.00 100.44 - 1,899.56 5.02% 000-493205 Donations- Golf Tournament 10,000.00 - - - - 10,000.00 0.00% 000-497000 Misc Income 50,000.00 11,589.20 93,699.37 11,589.20 - 38,410.80 23.18% 000-497100 Recovery of Bad Debt 60,000.00 5,074.70 8,064.30 5,074.70 - 54,925.30 8.46% TOTAL Miscellaneous 125,750.00 19,565.90 104,720.50 19,565.90 - 106,184.10 15.56% TOTAL REVENUES 9,345,315.19 2,565,466.39 2,453,877.38 2,565,466.39 - 6,779,848.80 27.45% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 Cash in Bank Claim on Operating Cash Pool-Checking 112,636.47$ Cash in Investments Texas Class- EMS Notes 2015 Investment 140.10 SR 2017 Ambulance-Logic 57,225.42 Total Cash in Bank & Investments 170,001.99$ SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: September 30, 2018 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Permits 3,000.00 1,180.00 700.00 1,180 - 1,820.00 39.33% Fees 1,208,500.00 309,179.00 291,655.57 309,179 - 899,321.00 25.58% Fund Transfers 493,783.00 - - - - 493,783.00 0.00% Miscellaneous 26,800.00 30,589.25 170,233.63 30,589 - (3,789.25) 114.14% TOTAL REVENUES 1,732,083.00 340,948.25 462,589.20 340,948.25 - 1,391,134.75 19.68% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 400,584.00 95,728.82 82,555.37 95,728.82 - 304,855.18 23.90% Supplies 5,700.00 531.45 687.17 531.45 - 5,168.55 9.32% City Support Services 1,000.00 2,879.51 3,437.69 2,879.51 - (1,879.51) 287.95% Utility Services 13,200.00 2,553.86 1,661.90 2,553.86 1,026.44 9,619.70 27.12% Operations Support 1,000.00 - - - - 1,000.00 0.00% Staff Support 10,000.00 830.86 1,093.20 830.86 774.86 8,394.28 16.06% City Assistance 500.00 - - - - 500.00 0.00% Professional Services 41,500.00 - 1,855.00 - - 41,500.00 0.00% Fund Charges/Transfers 532,162.00 132,790.50 124,073.68 132,790.50 - 399,371.50 24.95% Maintenance Services 30,000.00 43.00 530.32 43.00 - 29,957.00 0.14% Other costs 200.00 - - - - 200.00 0.00% Debt Service 121,212.50 - - - - 121,212.50 0.00% Rental/Leasing 5,500.00 - - - - 5,500.00 0.00% TOTAL DRAINAGE 1,162,558.50 235,358.00 215,894.33 235,358.00 1,801.30 925,399.20 20.40% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% 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: DECEMBER 31, 2018 PROJECTS City Support Services 7,354.00 - - - - 7,354.00 0.00% Operations Support 218.00 - 469.00 - - 218.00 0.00% Professional Services 29,749.00 703.00 3,626.00 703.00 20,367.00 8,679.00 70.83% Maintenance Services 517,412.00 66,851.64 97,423.20 66,851.64 419,082.65 31,477.71 93.92% TOTAL PROJECTS 554,733.00 67,554.64 101,518.20 67,554.64 439,449.65 47,728.71 91.40% TOTAL EXPENDITURES 1,717,291.50 302,912.64 317,412.53 302,912.64 441,250.95 973,127.91 43.33% ** REVENUE OVER(UNDER) EXPEND 14,791.50 38,035.61 145,176.67 38,035.61 (441,250.95) 418,006.84 204-DRAINAGE CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000-432400 Floodplain Permit 3,000.00 1,180.00 700.00 1,180.00 - 1,820.00 39.33% TOTAL Permits 3,000.00 1,180.00 700.00 1,180.00 - 1,820.00 39.33% Fees 000-457500 Drainage Penalties 10,000.00 66.19 3,694.57 66.19 - 9,933.81 0.66% 000-457600 Drainage Fee 1,198,500.00 309,112.81 287,961.00 309,112.81 - 889,387.19 25.79% TOTAL Fees 1,208,500.00 309,179.00 291,655.57 309,179.00 - 899,321.00 25.58% Fund Transfers 000-481000 Transfer In 493,783.00 - - - - 493,783.00 0.00% TOTAL Funds Transfers 493,783.00 - - - - 493,783.00 0.00% Miscellaneous 000-491000 Interest Earned 1,800.00 1,293.64 441.17 1,293.64 - 506.36 71.87% 000-491200 Investment Interest 25,000.00 5,177.52 5,547.96 5,177.52 - 19,822.48 20.71% 000-497000 Misc Income-Drainage - 24,118.09 164,244.50 24,118.09 - (24,118.09) 0.00% TOTAL Miscellaneous 26,800.00 30,589.25 170,233.63 30,589.25 - (3,789.25) 114.14% TOTAL REVENUES 1,732,083.00 340,948.25 462,589.20 340,948.25 - 1,391,134.75 19.68% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 Cash in Bank Claim on Operating Cash Pool-Checking 246,856.05$ Cash in Investments Lone Star Investment-Drainage Maint Fund 1,314,945.95 Total Cash in Bank & Investments 1,561,802.00$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2018 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 500,000.00 111,588.75 109,873.72 111,588.75 - 388,411.25 22.32% Miscellaneous 28,000.00 7,472.27 4,928.73 7,472.27 - 20,527.73 26.69% TOTAL REVENUES 528,000.00 119,061.02 114,802.45 119,061.02 - 408,938.98 22.55% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 110,650.00 49,020.75 44,342.31 49,020.75 - 61,629.25 44.30% Operations Support 65,500.00 2,086.00 3,486.00 2,086.00 - 63,414.00 3.18% Professional Services 3,000.00 12,806.91 - 12,806.91 - (9,806.91) 426.90% Fund Charges/Transfers 67,582.00 16,895.53 16,601.25 16,895.53 - 50,686.47 25.00% Maintenance Services 10,000.00 - - - - 10,000.00 0.00% TOTAL NONDEPARTMENTAL 256,732.00 80,809.19 64,429.56 80,809.19 - 175,922.81 31.48% TOTAL EXPENDITURES 256,732.00 80,809.19 64,429.56 80,809.19 - 175,922.81 31.48% REVENUE OVER(UNDER) EXPENDITURE 271,268.00 38,251.83 50,372.89 38,251.83 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 Cash in Bank Claim on Operating Cash Pool-Checking 73,564.25$ Cash in Investments Texas Class - Hotel Tax 1,781,871.90 Total Cash in Bank & Investments 1,855,436.15$ HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2018 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2018-19 38,655 36,314 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 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 70,000.00 6,000.00 - 6,000 - 64,000.00 8.57% Miscellaneous 30,000.00 1,492.93 1,259.70 1,492.93 - 28,507.07 4.98% TOTAL REVENUES 100,000.00 7,492.93 1,259.70 7,492.93 - 92,507.07 7.49% EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services 10,000.00 4,464.51 - 4,464.51 6,256.49 (721.00) 107.21% Operating Equipment 5,000.00 - - - - 5,000.00 0.00% Capital Outlay 85,000.00 57,342.19 - 57,342.19 8,448.44 19,209.37 77.40% TOTAL PARKLAND DEDICATION 100,000.00 61,806.70 - 61,806.70 14,704.93 23,488.37 76.51% TOTAL EXPENDITURES 100,000.00 61,806.70 - 61,806.70 14,704.93 23,488.37 76.51% REVENUE OVER(UNDER) EXPEND - (54,314) 1,260 (54,314) (14,705) 69,019 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458800 Parkland Dedication 70,000.00 6,000.00 - 6,000.00 - 64,000.00 8.57% TOTAL Fees 70,000.00 6,000.00 - 6,000.00 - 64,000.00 8.57% Miscellaneous 000-491000 Interest Earned 750.00 150.75 156.22 150.75 - 599.25 20.10% 000-491200 Investment Interest 7,000.00 1,342.18 1,103.48 1,342.18 - 5,657.82 19.17% 000-499100 Transfer From Parks Reserve 22,250.00 - - - - 22,250.00 0.00% TOTAL Miscellaneous 30,000.00 1,492.93 1,259.70 1,492.93 - 28,507.07 4.98% TOTAL REVENUES 100,000.00 7,492.93 1,259.70 7,492.93 - 92,507.07 7.49% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 Cash in Bank Current Claim on Operating Cash Pool-Checking 82,087.00 Cash in Investments Texas Class- Park Fund 238,443.83 Total in Investment Pool 238,443.83 Total Cash in Bank & Investments 320,530.83 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2018 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 72,500.00 (1,275.00) 17,402.90 (1,275) - 73,775.00 -1.76% Fund Transfers - - - - - - 0.00% Miscellaneous 7,750.00 1,742.08 1,119.25 1,742 - 6,007.92 22.48% TOTAL REVENUES 80,250.00 467.08 18,522.15 467.08 - 79,782.92 0.58% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services-Trees 75,000.00 6,900.00 1,890.00 6,900.00 - 68,100.00 9.20% TOTAL TREE MITIGATION 75,000.00 6,900.00 1,890.00 6,900.00 - 68,100.00 9.20% TOTAL EXPENDITURES 75,000.00 6,900.00 1,890.00 6,900.00 - 68,100.00 9.20% REVENUE OVER(UNDER) EXPEND 5,250.00 (6,432.92) 16,632.15 (6,432.92) - 11,682.92 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458900 Tree Mitigation 72,500.00 (1,275.00) 17,402.90 (1,275.00) - 73,775.00 -1.76% TOTAL Fees 72,500.00 (1,275.00) 17,402.90 (1,275.00) - 73,775.00 -1.76% Fund Transfers 000-481000 Transfer In - Reserves - - - - - - 0.00% TOTAL Fund Transfers - - - - - - 0.00% Miscellaneous 000-491000 Interest Earned 750.00 233.47 75.87 233.47 - 516.53 31.13% 000-491200 Investment Interest 7,000.00 1,508.61 1,043.38 1,508.61 - 5,491.39 21.55% TOTAL Miscellaneous 7,750.00 1,742.08 1,119.25 1,742.08 - 6,007.92 22.48% TOTAL REVENUES 80,250.00 467.08 18,522.15 467.08 - 79,782.92 0.58% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 Cash in Bank Claim on Operating Cash Pool-Checking $45,729.28 Cash in Investments MBIA Investment-Tree Mitigation 380,450.50 Total Cash in Bank & Investments $426,179.78 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2018 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 1,100,000.00 253,791.00 416,628.00 253,791.00 - 846,209.00 23.07% Miscellaneous 82,000.00 26,236.67 16,745.21 26,236.67 - 55,763.33 32.00% TOTAL REVENUES 1,182,000.00 280,027.67 433,373.21 280,027.67 - 901,972.33 23.69% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 256,000.00 - 484.00 - - 256,000.00 0.00% TOTAL NON DEPARTMENTAL 256,000.00 - 484.00 - - 256,000.00 0.00% TOTAL MISC & PROJECTS - - - - - - 0.00% TOTAL EXPENDITURES 256,000.00 - 484.00 - - 256,000.00 0.00% REVENUE OVER(UNDER) EXPENDITURES 926,000.00 280,027.67 432,889.21 280,027.67 - 645,972.33 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% 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 253,791.00 416,628.00 253,791.00 - 846,209.00 23.07% TOTAL Fees 1,100,000.00 253,791.00 416,628.00 253,791.00 - 846,209.00 23.07% Miscellaneous 000-491000 Interest Earned 7,000.00 1,226.01 898.21 1,226.01 - 5,773.99 17.51% 000-491200 Investment Income 75,000.00 25,010.66 15,847.00 25,010.66 - 49,989.34 33.35% TOTAL Miscellaneous 82,000.00 26,236.67 16,745.21 26,236.67 - 55,763.33 32.00% TOTAL REVENUES 1,182,000.00 280,027.67 433,373.21 280,027.67 - 901,972.33 23.69% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 Cash in Bank Claim on Operating Cash Pool-Checking 338,723.74$ Cash in Investments Lone Star Investment-Capital Recovery Water 6,447,133.79 Total Cash in Bank & Investments 6,785,857.53$ CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: December 31, 2018 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 600,000.00 126,768.00 271,198.68 126,768 - 473,232.00 21.13% Fund Transfers - - - - - - 0.00% Miscellaneous 44,000.00 24,515.06 9,993.13 24,515 - 19,484.94 55.72% TOTAL REVENUES 644,000.00 151,283.06 281,191.81 151,283.06 - 492,716.94 23.49% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 260,500.00 730.46 1,574.82 730.46 - 259,769.54 0.28% Fund Charges/Transfers - - - - - - 0.00% TOTAL NON DEPARTMENTAL 260,500.00 730.46 1,574.82 730.46 - 259,769.54 0.28% TOTAL EXPENDITURES 260,500.00 730.46 1,574.82 730.46 - 259,769.54 0.28% REVENUE OVER(UNDER) EXPENDITURES 383,500.00 150,552.60 279,616.99 150,552.60 - 232,947.40 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 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 600,000.00 126,768.00 269,398.68 126,768.00 - 473,232.00 21.13% 000-455913 Cap Recovery-North Sewer Tr - - 1,800.00 - - - 0.00% TOTAL Fees 600,000.00 126,768.00 271,198.68 126,768.00 - 473,232.00 21.13% Fund Transfers 000-481000 Transfer from Reserves - - - - - - 0.00% TOTAL Fund Transfers - - - - - - 0.00% Miscellaneous 000-491000 Interest Earned 4,000.00 1,335.71 706.20 1,335.71 - 2,664.29 33.39% 000-491200 Investment Income 40,000.00 21,045.35 19,984.05 21,045.35 - 18,954.65 52.61% 000-491800 Gain/Loss - - 411.62 - - - 0.00% 000-491900 Unrealized Gain/Loss-Cap One - 2,134.00 (11,108.74) 2,134.00 - (2,134.00) 0.00% TOTAL Miscellaneous 44,000.00 24,515.06 9,993.13 24,515.06 - 19,484.94 55.72% TOTAL REVENUES 644,000.00 151,283.06 281,191.81 151,283.06 - 492,716.94 23.49% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 Cash in Bank Claim on Operating Cash Pool-Checking 277,066.11$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 4,135,334.71 Capital One-Investment 1,771,761.57 Total Cash in Bank & Investments 6,184,162.39$ CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: September 30, 2018 505-TAX I&S CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 6,384,000.00 2,933,475.44 3,170,219.02 2,933,475.44 - 3,450,524.56 45.95% Fund Transfers 113,723.00 - - - - 113,723.00 0.00% Miscellaneous 156,000.00 5,270.25 5,222.40 5,270.25 - 150,729.75 3.38% TOTAL REVENUES 6,653,723.00 2,938,745.69 3,175,441.42 2,938,745.69 - 3,714,977.31 44.17% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 1,550.00 550.00 1,550.00 - 3,450.00 31.00% Debt Service 6,648,723.27 - - - - 6,648,723.27 0.00% TOTAL GENERAL GOVERNMENT 6,653,723.27 1,550.00 550.00 1,550.00 - 6,652,173.27 0.02% - TOTAL EXPENDITURES 6,653,723.27 1,550.00 550.00 1,550.00 - 6,652,173.27 0.02% ** REVENUE OVER(UNDER) EXPEND (0.27) 2,937,195.69 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 505-TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y-T-D BUDGET 25% 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 2,933,475.44 3,170,219.02 2,933,475.44 - 3,450,524.56 45.95% TOTAL Taxes 6,384,000.00 2,933,475.44 3,170,219.02 2,933,475.44 - 3,450,524.56 45.95% 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 933.01 576.67 933.01 - 5,066.99 15.55% 000-491200 Investment Earnings 50,000.00 4,337.24 4,645.73 4,337.24 - 45,662.76 8.67% 000-495020 Contribution from YMCA 100,000.00 - - - - 100,000.00 0.00% TOTAL Miscellaneous 156,000.00 5,270.25 5,222.40 5,270.25 - 150,729.75 3.38% TOTAL REVENUES 6,653,723.00 2,938,745.69 3,175,441.42 2,938,745.69 - 3,714,977.31 44.17% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% 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 550.00 550.00 550.00 - 4,450.00 11.00% 101-541502 Cost of Bond Issuance - 1,000.00 - 1,000.00 - (1,000.00) 0.00% TOTAL Professional Services 5,000.00 1,550.00 550.00 1,550.00 - 3,450.00 31.00% Debt Service 101-555612 Bond-GO Refunding 2010-Principal 300,000.00 - - - - 300,000.00 0.00% 101-555612.1 Bond-GO Refunding 2010 Interest 29,700.00 - - - - 29,700.00 0.00% 101-555629 GO Bond 2007-Principal 300,000.00 - - - - 300,000.00 0.00% 101-555629.1 GO Bond 2007-Interest 124,338.50 - - - - 124,338.50 0.00% 101-555631 GO Bond SR2009 Principal 210,000.00 - - - - 210,000.00 0.00% 101-555631.1 BO Bond SR2009 Interest 236,525.00 - - - - 236,525.00 0.00% 101-555633 GO SR2011 Principal 250,000.00 - - - - 250,000.00 0.00% 101-555633.1 GO SR2011 Interest 318,462.50 - - - - 318,462.50 0.00% 101-555634 GO SR2011A Refund Principal 485,000.00 - - - - 485,000.00 0.00% 101-555634.1 GO SR2011A Refund Interest 74,734.75 - - - - 74,734.75 0.00% 101-555635 GO SR2012 Principal 345,000.00 - - - - 345,000.00 0.00% 101-555635.1 GO SR2012 Interest 157,945.00 - - - - 157,945.00 0.00% 101-555638 Bond-GO 2014 Refund-Principal 100,000.00 - - - - 100,000.00 0.00% 101-555638.1 Bond-GO 2014 Refund-Interest 286,775.00 - - - - 286,775.00 0.00% 101-555639 Tax Note - SR2015 - Principal 35,000.00 - - - - 35,000.00 0.00% 101-555639.1 Tax Note - SR2015 - Interest 1,925.00 - - - - 1,925.00 0.00% 101-555640 Bond-Ref 2015 Bond- Principal 150,000.00 - - - - 150,000.00 0.00% 101-555640.1 Bond-GO Ref 2015- Interest 9,317.00 - - - - 9,317.00 0.00% 101-555641 Tax Note - SR2015A - Principal 660,000.00 - - - - 660,000.00 0.00% 101-555641.1 Tax Note - SR2015A - Interest 81,225.00 - - - - 81,225.00 0.00% 101-555642 GO Bond SR2016 Principal 215,000.00 - - - - 215,000.00 0.00% 101-555642.1 GO Bond SR2016 Interest 159,206.26 - - - - 159,206.26 0.00% 101-555643 CO Bond Tax SR2016 Principal 175,000.00 - - - - 175,000.00 0.00% 101-555643.1 CO Bond Tax SR2016 Interest 62,668.76 - - - - 62,668.76 0.00% 101-555644 CO Bond nonTax SR2016 Principal 55,000.00 - - - - 55,000.00 0.00% 101-555644 CO Bond nonTax SR2016 Interest 45,587.50 - - - - 45,587.50 0.00% 101-555645 CO Bond SR2017 Principal 280,000.00 - - - - 280,000.00 0.00% 101-555645.1 CO Bond SR2017 Interest 139,025.00 - - - - 139,025.00 0.00% 101-555646 Bond-GO SR2017 Principal 150,000.00 - - - - 150,000.00 0.00% 101-55646.1 Bond - GO SR2017 Interest 114,225.00 - - - - 114,225.00 0.00% 101-555647 Bond-GO 2018 Refund Principal 550,000.00 - 550,000.00 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2018 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% 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: DECEMBER 31, 2018 101-555647.1 Bond - GO 2018 Refund Interest 122,112.00 - - - - 122,112.00 0.00% 101-555900 Debt Service 424,951.00 - - - - 424,951.00 0.00% TOTAL Debt Service 6,648,723.27 - - - - 6,648,723.27 0.00% TOTAL EXPENDITURES 6,653,723.27 2,100.00 550.00 1,550.00 - 6,652,173.27 0.02% Cash in Bank Claim on Operating Cash Pool-Checking 1,700,754.80$ MBIA Investment- Tax I&S 2,339,498.57 Total Cash in Bank & Investments 4,040,253.37$ TAX I&S CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2018 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 4,242,580.00 981,160.11 999,460.90 981,160.11 - 3,261,419.89 23.13% Fund Transfers 1,249,164.00 - - - - 1,249,164.00 0.00% Miscellaneous 258,000.00 264,940.26 45,613.11 264,940.26 - (6,940.26) 102.69% TOTAL REVENUES 5,749,744.00 1,246,100.37 1,045,074.01 1,246,100.37 - 4,503,643.63 21.67% 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 Supplies 750.00 6.72 117.82 6.72 - 743.28 0.00% City Support Services 21,300.00 3,434.38 1,830.67 3,434.38 575.00 17,290.62 4.45% Utility Services 3,720.00 373.82 464.81 373.82 67.08 3,279.10 460.21% Operations Support 122,500.00 17,052.57 19,689.60 17,052.57 - 105,447.43 1.12% Staff Support 21,400.00 1,367.64 2,211.57 1,367.64 394.78 19,637.58 2.04% City Assistance 252,500.00 42.63 200,000.00 42.63 25.60 252,431.77 0.20% Professional Services 66,300.00 488.17 117.00 488.17 - 65,811.83 345.08% Fund Charges/Transfers 457,574.00 228,787.00 221,088.00 228,787.00 - 228,787.00 233.39% Maintenance Services 1,000.00 80.00 140.00 80.00 - 920.00 8.00% Operating Equipment 2,700.00 - 576.02 - - 2,700.00 0.00% TOTAL ECONO DEVELOPMENT 949,744.00 251,632.93 446,235.49 251,632.93 1,062.46 697,048.61 26.61% TOTAL EXPENDITURES 5,749,744.00 251,632.93 446,235.49 251,632.93 1,062.46 5,497,048.61 4.39% ** REVENUE OVER(UNDER) EXPEND - 994,467.44 598,838.52 994,467.44 (1,062.46) (993,404.98) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 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$ SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2018