Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
03-Third Quarter Financial Report
CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2018 - 2019 ********************************* CURRENT CURRENT Y-T-D BUDGET 75% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET General Fund, 101 Total Revenues 34,156,549 28,312,410.52 75.00 5,844,063.05 82.89% Total General Government 6,685,482 4,577,681.49 260,564.01 1,847,236.15 72.37% Total Public Safety 14,526,571 10,811,696.26 301,972.14 3,412,902.90 76.51% Total Public Environment 841,685 403,048.27 5,534.89 433,101.84 48.54% Total Parks & Recreation 2,675,790 1,622,642.63 140,894.42 912,252.95 65.91% Total Cultural 967,904 738,838.92 15,525.93 213,539.15 77.94% Total Health 500,269 349,687.63 2,786.32 147,795.05 70.46% Total Internal Services 6,755,987 4,056,253.52 447,384.95 2,252,348.53 66.66% Total Misc & Projects 377,666 230,672.01 68,985.09 78,008.90 79.34% Total Expenditures 33,331,354 22,790,520.73 1,243,647.75 9,297,185.47 72.11% Revenue Over(Under) Expenditures 825,194.62 5,521,889.79 General Fund, 101 Total Cash in Bank & Investments 18,702,103.58 Special Events Fund, 106 Total Revenues 156,760 81,609.55 0.00 75,150.45 52.06% Total Expenditures 177,708 84,105.83 30,551.78 63,050.39 64.52% Revenue Over(Under) Expenditures (20,948)(2,496.28) Special Events Fund, 106 Total Cash in Bank & Investments 89,783.90 Peg Fund, 110 Total Revenues 195,000 65,067.98 0.00 129,932.02 33.37% Total Expenditures 195,000 3,258.50 0.00 191,741.50 1.67% Revenue Over(Under) Expenditures 0 61,809.48 Peg Fund, 110 Total Cash in Bank & Investments 766,989.83 Water & Sewer, 202 Total Revenues 25,735,522 17,611,257.67 0.00 8,124,263.83 68.43% Total Expenditures 24,980,024 16,292,311.65 879,422.22 7,808,289.88 68.74% Revenue Over(Under) Expenditures 755,498 1,318,946.02 Water & Sewer, 202 Total Cash in Bank & Investments 10,445,687.96 Quarterly Statement Schertz, Texas AS OF :JUNE 30, 2019 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ********************************* 2018 - 2019 ******************************** CURRENT CURRENT Y-T-D BUDGET 75% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET EMS, 203 Total Revenues 9,345,315 7,310,951.42 0.00 2,034,363.77 78.23% Total Expenditures 9,235,636 7,004,813.90 68,513.00 2,162,309.33 76.59% Revenue Over(Under) Expenditures 109,679 306,137.52 EMS, 203 Total Cash in Bank & Investments 584,695.16 Drainage, 204 Total Revenues 2,265,362 956,251.20 0.00 1,309,110.80 42.21% Total Expenditures 2,250,571 1,373,702.08 276,960.39 599,908.03 73.34% Revenue Over(Under) Expenditures 14,792 (417,450.88) Drainage, 204 Total Cash in Bank & Investments 1,116,089.15 Hotel Tax, 314 Total Revenues 528,000 398,046.85 0.00 129,953.15 75.39% Total Expenditures 256,732 153,728.88 484.60 102,518.52 60.07% Revenue Over(Under) Expenditures 271,268 244,317.97 Hotel Tax, 314 Total Cash in Bank & Investments 2,057,716.40 Park, 317 Total Revenues 176,512 25,898.91 0.00 150,613.09 14.67% Total Expenditures 176,512 101,191.53 5,881.49 69,438.98 60.66% Revenue Over(Under) Expenditures 0 (75,292.62) Park, 317 Total Cash in Bank & Investments 298,867.83 Tree Mitigation, 319 Total Revenues 80,250 10,047.85 (6,875.00)77,077.15 3.95% Total Expenditures 75,000 11,500.00 0.00 63,500.00 15.33% Revenue Over(Under) Expenditures 5,250 (1,452.15) Tree Mitigation, 319 Total Cash in Bank & Investments 430,352.23 Capital Recovery Water, 411 Total Revenues 2,557,000 809,472.82 0.00 1,747,527.18 31.66% Total Expenditures 1,631,000 1,375,984.00 0.00 255,016.00 84.36% Revenue Over(Under) Expenditures 926,000 (566,511.18) Capital Recovery Water, 411 Total Cash in Bank & Investments 5,925,562.60 Quarterly Statement Schertz, Texas AS OF :JUNE 30, 2019 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ********************************* 2018 - 2019 ******************************** CURRENT CURRENT Y-T-D BUDGET 75% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Capital Recovery Sewer, 421 Total Revenues 644,000 497,788.59 0.00 146,211.41 77.30% Total Expenditures 260,500 3,927.07 0.00 256,572.93 1.51% Revenue Over(Under) Expenditures 383,500 493,861.52 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 6,512,273.79 I&S, 505 Total Revenues 6,653,723 6,518,327.65 0.00 135,395.35 97.97% Total Expenditures 6,653,723 5,499,277.26 886,213.14 268,232.87 95.97% Revenue Over(Under) Expenditures 0 1,019,050.39 I&S, 505 Total Cash in Bank & Investments 2,118,908.81 SED Corporation, 620 Total Revenues 5,749,744 3,819,006.20 0.00 1,930,737.80 66.42% Total Expenditures 5,749,744 549,566.09 2,970.03 5,197,207.88 9.61% Revenue Over(Under) Expenditures 0 3,269,440.11 SED Corporation, 620 Total Cash in Bank & Investments 20,252,547.19 Total Cash in Bank & Investments 69,301,578.43 Quarterly Statement Schertz, Texas AS OF :JUNE 30, 2019 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 21,519,002.00 3,058,819.01 18,222,896.77 20,278,693.68 - 1,240,308.32 94.24% Franchises 2,373,686.57 552,873.39 1,659,047.44 1,623,950.13 - 749,736.44 68.41% Permits 1,604,320.00 307,228.58 1,800,538.63 1,002,440.47 - 601,879.53 62.48% Licenses 56,760.00 18,030.05 59,080.00 50,972.05 - 5,787.95 89.80% Fees 1,843,973.00 620,236.19 1,922,030.09 1,774,742.98 75.00 69,155.02 96.25% Fines 22,000.00 3,430.23 16,788.84 10,834.12 - 11,165.88 49.25% Inter-Jurisdictional 967,008.00 169,977.76 577,401.34 636,831.56 - 330,176.44 65.86% Fund Transfers 5,063,249.00 797,314.18 2,088,655.98 2,163,155.44 - 2,900,093.56 42.72% Miscellaneous 706,550.00 299,387.92 731,142.66 770,790.09 - (64,240.09) 109.09% TOTAL REVENUES 34,156,548.57 5,827,297.31 27,077,581.75 28,312,410.52 75.00 5,844,063.05 82.89% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 35,009.00 9,804.97 27,215.43 27,759.71 14.40 7,234.89 79.33% Supplies 1,000.00 351.78 142.73 618.45 - 381.55 61.85% City Support Services 27,500.00 6,583.90 17,776.31 24,488.07 99.99 2,911.94 89.41% Utility Services - - 465.07 - - - 0.00% Operations Support 300.00 - 29.00 178.40 116.00 5.60 98.13% Staff Support 32,150.00 939.48 22,065.73 17,699.11 - 14,450.89 55.05% Professional Services 8,000.00 3,900.00 - 5,850.00 - 2,150.00 73.13% TOTAL CITY COUNCIL 103,959.00 21,580.13 67,694.27 76,593.74 230.39 27,134.87 73.90% CITY MANAGER Personnel Services 1,123,847.00 287,938.17 1,014,294.20 789,670.99 39.47 334,136.54 70.27% Supplies 2,000.00 619.85 440.50 1,411.29 89.19 499.52 75.02% City Support Services 6,000.00 - 8,154.32 - - 6,000.00 0.00% Utility Services 2,000.00 - 1,009.05 414.39 - 1,585.61 20.72% Operations Support 50.00 - - - - 50.00 0.00% Staff Support 26,625.00 3,768.16 10,292.73 8,413.76 2,429.43 15,781.81 40.73% Operating Equipment 1,000.00 1,056.06 - 1,370.45 - (370.45) 137.05% TOTAL CITY MANAGER 1,161,522.00 293,382.24 1,034,190.80 801,280.88 2,558.09 357,683.03 69.21% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 MUNICIPAL COURT Personnel Services 254,795.00 73,571.36 229,613.43 224,178.28 - 30,616.72 87.98% Supplies 2,000.00 148.52 949.18 967.40 491.24 541.36 72.93% City Support Services 975.00 - 157.86 326.17 - 648.83 33.45% Operations Support 3,000.00 93.00 69.00 124.00 769.00 2,107.00 29.77% Staff Support 8,510.00 1,804.10 2,889.63 4,426.10 - 4,083.90 52.01% Court Support 700.00 - 96.00 318.00 - 382.00 45.43% Professional Services 73,960.00 12,350.00 44,629.27 37,822.56 10,800.00 25,337.44 65.74% Maintenance Services 3,000.00 450.00 1,500.00 1,350.00 1,450.00 200.00 93.33% TOTAL MUNICIPAL COURT 346,940.00 88,416.98 279,904.37 269,512.51 13,510.24 63,917.25 81.58% CUSTOMER RELATIONS-311 Personnel Services 120,977.00 29,177.29 93,101.77 91,953.56 - 29,023.44 76.01% Supplies 150.00 32.99 72.30 69.41 12.62 67.97 54.69% Staff Support 530.00 123.94 46.98 123.94 41.15 364.91 31.15% Operating Equipment 300.00 - 554.62 - 269.78 30.22 89.93% TOTAL CUSTOMER RELATIONS-311 121,957.00 29,334.22 93,775.67 92,146.91 323.55 29,486.54 75.82% PLANNING & ZONING Personnel Services 210,124.00 55,099.25 160,369.92 153,645.83 - 56,478.17 73.12% Supplies 2,862.65 380.80 438.91 489.15 - 2,373.50 17.09% Operations Support 174.00 - 7.20 7.00 - 167.00 4.02% Staff Support 26,755.00 5,640.00 9,212.22 9,439.82 637.00 16,678.18 37.66% Professional Services 100.00 5.00 - 14.00 - 86.00 14.00% Operating Equipment 250.00 852.38 - 852.38 - (602.38) 340.95% TOTAL PLANNING & ZONING 240,265.65 61,977.43 170,028.25 164,448.18 637.00 75,180.47 68.71% LEGAL SERVICES Operations Support 10,000.00 219.75 1,636.59 1,617.30 685.00 7,697.70 23.02% Professional Services 150,000.00 24,945.15 72,629.46 75,600.50 - 74,399.50 50.40% TOTAL LEGAL SERVICES 160,000.00 25,164.90 74,266.05 77,217.80 685.00 82,097.20 48.69% CITY SECRETARY Personnel Services 186,399.00 50,650.15 143,836.45 155,942.55 - 30,456.45 83.66% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 Supplies 1,150.00 52.63 762.45 1,034.19 80.38 35.43 96.92% City Support Services 15,000.00 2,141.60 6,957.75 2,973.03 803.46 11,223.51 25.18% Operations Support 100.00 - 59.90 27.95 - 72.05 27.95% Staff Support 4,400.00 1,144.30 2,192.98 4,029.32 25.00 345.68 92.14% TOTAL CITY SECRETARY 207,049.00 53,988.68 153,809.53 164,007.04 908.84 42,133.12 79.65% NON-DEPARTMENTAL City Support Services 615,202.00 57,545.22 287,499.90 377,951.50 54,919.27 182,331.23 70.36% Operations Support 163,500.00 52,522.09 105,138.31 97,691.89 3,223.18 62,584.93 61.72% Staff Support 250.00 73.20 80.00 73.20 - 176.80 29.28% City Assistance 1,879,730.00 1,007,118.99 1,566,862.31 1,297,887.61 145,384.29 436,458.10 76.78% Professional Services 51,235.00 12,527.09 48,419.14 35,022.64 - 16,212.36 68.36% Fund Chrgs/Transfrs-Spec Events Fnd 67,250.00 - - - - 67,250.00 0.00% TOTAL NON-DEPARTMENTAL 2,777,167.00 1,129,786.59 2,007,999.66 1,808,626.84 203,526.74 765,013.42 72.45% PUBLIC AFFAIRS Personnel Services 288,461.00 81,525.92 211,808.37 232,665.69 - 55,795.31 80.66% Supplies 1,050.00 85.96 1,423.95 472.45 42.18 535.37 49.01% City Support Services 4,000.00 - - 610.14 1,365.00 2,024.86 Operations Support 43,500.00 5,710.24 12,317.98 12,300.67 1,659.40 29,539.93 32.09% Staff Support 10,100.00 4,218.62 1,919.87 6,393.04 1,178.59 2,528.37 74.97% Professional Services 304,980.00 106,756.86 3,120.00 238,426.42 1,014.72 65,538.86 78.51% Operating Equipment - - 27.97 - - - 0.00% TOTAL PUBLIC AFFAIRS 652,091.00 198,297.60 230,618.14 490,868.41 5,259.89 155,962.70 76.08% ENGINEERING Personnel Services 614,373.00 171,625.91 472,524.32 485,370.43 - 129,002.57 79.00% Supplies 2,720.00 511.80 491.77 632.10 43.00 2,044.90 24.82% City Support Services 900.00 - 650.00 - - 900.00 0.00% Utility Services 4,118.00 1,690.17 1,844.78 3,626.77 - 491.23 88.07% Operations Support 100.00 - 47.70 - - 100.00 0.00% Staff Support 12,658.00 1,639.67 2,788.16 3,067.53 - 9,590.47 24.23% Professional Services 71,000.00 472.50 3,477.50 1,266.02 1,160.00 68,573.98 3.42% Operating Equipment 3,351.00 109.99 - 109.99 1,614.06 1,626.95 51.45% Capital Outlay 30,000.00 - - - 28,440.40 1,559.60 94.80% TOTAL ENGINEERING 739,220.00 176,050.04 481,824.23 494,072.84 31,257.46 213,889.70 71.07% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 GIS Personnel Services 166,886.00 49,331.32 128,352.36 133,386.01 - 33,499.99 79.93% Supplies 1,740.00 - 253.86 - 1,145.86 594.14 65.85% Staff Support 4,600.00 781.00 3,258.82 3,957.48 - 642.52 86.03% Rental/Leasing 2,085.00 520.95 1,562.85 1,562.85 520.95 1.20 99.94% TOTAL GIS 175,311.00 50,633.27 133,427.89 138,906.34 1,666.81 34,737.85 80.19% TOTAL GENERAL GOVERNMENT 6,685,481.65 2,128,612.08 4,727,538.86 4,577,681.49 260,564.01 1,847,236.15 72.37% PUBLIC SAFETY POLICE Personnel Services 7,246,007.00 1,906,406.71 4,749,904.74 5,335,543.21 - 1,910,463.79 73.63% Supplies 59,348.32 14,325.05 37,670.26 46,117.91 777.44 12,452.97 79.02% City Support Services 26,000.00 - 24,229.52 25,229.31 - 770.69 97.04% Utility Services 127,278.50 26,639.41 54,464.55 60,585.51 - 66,692.99 47.60% Operations Support 12,121.00 2,522.00 1,503.25 4,321.00 - 7,800.00 35.65% Staff Support 148,368.53 39,372.97 74,139.28 94,925.86 14,187.47 39,255.20 73.54% City Assistance 18,200.00 3,091.04 7,869.69 7,364.33 1,852.60 8,983.07 50.64% Professional Services 70,443.00 11,579.96 44,614.30 54,827.80 727.65 14,887.55 78.87% Maintenance Services 62,645.00 17,640.00 31,367.21 30,385.00 325.00 31,935.00 49.02% Operating Equipment 86,074.65 24,892.04 25,642.45 210,630.66 3,920.93 (128,476.94) 249.26% Capital Outlay 499,322.30 62,247.43 476,480.06 333,826.06 40,164.20 125,332.04 74.90% TOTAL POLICE 8,355,808.30 2,108,716.61 5,527,885.31 6,203,756.65 61,955.29 2,090,096.36 74.99% FIRE RESCUE Personnel Services 4,552,388.00 1,173,952.65 3,166,888.62 3,546,416.01 - 1,005,971.99 77.90% Supplies 23,554.00 7,298.97 7,081.26 11,912.40 1,234.71 10,406.89 55.82% Utility Services 61,600.00 12,221.30 28,092.79 34,971.24 560.00 26,068.76 57.68% Operations Support 550.00 - 58.00 236.09 - 313.91 42.93% Staff Support 181,052.00 41,755.59 115,084.25 114,351.25 31,623.22 35,077.53 80.63% City Assistance 23,000.00 1,477.74 6,831.32 6,716.68 264.51 16,018.81 30.35% Professional Services 33,500.00 27,805.00 23,425.00 33,465.00 - 35.00 99.90% Maintenance Services 74,496.00 20,658.74 45,239.53 32,740.50 8,933.51 32,821.99 55.94% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 Other Costs - - 3,420.94 1,594.08 - (1,594.08) 0.00% Rental/Leasing 33,900.00 14,307.99 28,104.03 22,209.63 - 11,690.37 65.52% Operating Equipment 112,144.00 27,666.76 39,397.29 64,095.99 18,869.27 29,178.74 73.98% Capital Outlay 179,000.00 - 79,652.55 - 176,976.89 2,023.11 98.87% TOTAL FIRE RESCUE 5,275,184.00 1,327,144.74 3,543,275.58 3,868,708.87 238,462.11 1,168,013.02 77.86% INSPECTIONS Personnel Services 729,754.00 232,670.50 480,082.48 607,759.34 - 121,994.66 83.28% Supplies 4,115.00 716.11 1,231.63 2,039.76 33.35 2,041.89 50.38% Utility Services 5,000.00 1,802.20 2,925.80 4,074.32 - 925.68 81.49% Operations Support 2,219.00 124.00 910.00 946.60 80.50 1,191.90 46.29% Staff Support 29,961.00 7,067.14 10,707.32 14,798.88 1,397.30 13,764.82 54.06% Professional Services 70,000.00 14,350.00 123,890.00 55,645.00 30.00 14,325.00 79.54% Operating Equipment 530.00 475.40 4,373.06 1,005.38 - (475.38) 189.69% Capital Outlay 54,000.00 - - 52,961.46 13.59 1,024.95 98.10% TOTAL INSPECTIONS 895,579.00 257,205.35 624,120.29 739,230.74 1,554.74 154,793.52 82.72% TOTAL PUBLIC SAFETY 14,526,571.30 3,693,066.70 9,695,281.18 10,811,696.26 301,972.14 3,412,902.90 76.51% PUBLIC ENVIRONMENT STREETS Supplies 101,850.00 22,024.32 55,051.98 59,631.49 3,956.12 38,262.39 62.43% Utility Services 181,700.00 49,235.01 114,016.31 124,119.45 843.00 56,737.55 68.77% Staff Support 14,550.00 3,984.96 7,072.75 13,471.69 735.77 342.54 97.65% Professional Services 15,000.00 - 7,937.00 6,345.00 - 8,655.00 42.30% Maintenance Services 285,500.00 - 68,820.79 646.36 - 284,853.64 0.23% Rental/Lease 4,000.00 1,600.00 3,200.57 2,650.00 - 1,350.00 66.25% Operating Equipment 9,800.00 1,264.61 4,809.70 2,736.54 - 7,063.46 27.92% Capital Outlay 229,285.00 37,050.00 40,735.16 193,447.74 - 35,837.26 84.37% TOTAL STREETS 841,685.00 115,158.90 301,644.26 403,048.27 5,534.89 433,101.84 48.54% TOTAL PUBLIC ENVIRONMENT 841,685.00 115,158.90 301,644.26 403,048.27 5,534.89 433,101.84 48.54% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 PARKS & RECREATION PARKS DEPARTMENT Personnel Services 673,965.00 148,612.69 357,700.32 430,759.88 - 243,205.12 63.91% Supplies 71,896.83 24,608.72 51,633.37 50,547.28 7,444.73 13,904.82 80.66% City Support Services 10,000.00 7,542.06 7,480.57 12,447.26 4,602.56 (7,049.82) 170.50% Utility Services 220,500.00 75,994.41 166,911.70 159,352.80 2,421.18 58,726.02 73.37% Operations Support 1,847.39 1,514.39 878.97 1,514.39 333.00 - 100.00% Staff Support 14,895.30 3,465.89 7,280.55 13,801.47 668.24 425.59 97.14% Professional Services 137,500.00 63,896.46 43,018.24 80,675.54 2,202.50 54,621.96 60.27% Maintenance Services 77,478.75 1,072.24 13,446.56 6,875.23 16,839.00 53,764.52 30.61% Rental/Leasing 5,946.73 2,173.42 28,530.65 5,398.62 451.08 97.03 98.37% Operating Equipment 72,350.00 31,621.98 16,543.49 49,797.43 14,128.99 8,423.58 88.36% Capital Outlay 323,927.00 174,769.34 14,278.54 234,531.34 76,124.08 13,271.58 95.90% TOTAL PARKS DEPARTMENT 1,610,307.00 535,271.60 707,702.96 1,045,701.24 125,215.36 439,390.40 72.71% SWIM POOL Supplies 25,500.00 6,941.57 8,225.09 6,781.28 159.67 18,559.05 27.22% Utility Services 16,500.00 11,017.98 10,717.14 20,284.61 2,332.66 (6,117.27) 137.07% Professional Services - - - - 2,992.50 (2,992.50) 0.00% Maintenance Services 597,878.00 173,618.57 261,592.53 310,129.82 7,934.00 279,814.18 53.20% Operating Equipment - 6,660.51 1,031.82 6,660.51 - (6,660.51) 0.00% TOTAL SWIM POOL 639,878.00 198,238.63 281,566.58 343,856.22 13,418.83 282,602.95 55.83% EVENT FACILITIES Personnel Services 299,770.00 68,318.68 46,066.78 182,310.43 - 117,459.57 60.82% Supplies 6,150.00 599.00 3,043.07 1,963.51 105.90 4,080.59 33.65% Utility Services 51,350.00 9,042.71 24,788.14 24,042.72 - 27,307.28 46.82% Operations Support 11,200.00 4,475.22 3,843.59 9,178.42 - 2,021.58 81.95% Staff Support 5,135.00 88.66 651.83 2,173.37 515.77 2,445.86 52.37% Maintenance Services 20,000.00 - - - 20,000.00 0.00% Operating Equipment 32,000.00 880.56 8,317.43 13,416.72 1,638.56 16,944.72 47.05% TOTAL EVENT FACILITIES 425,605.00 83,404.83 86,710.84 233,085.17 2,260.23 190,259.60 55.30% TOTAL PARKS & RECREATION 2,675,790.00 816,915.06 1,075,980.38 1,622,642.63 140,894.42 912,252.95 65.91% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 CULTURAL LIBRARY Personnel Services 750,254.00 214,212.75 583,642.46 598,044.85 - 152,209.15 79.71% Supplies 15,500.00 2,861.80 6,615.65 7,431.01 1,859.23 6,209.76 59.94% Utility Services 55,500.00 12,764.31 30,240.62 31,571.54 - 23,928.46 56.89% Operations Support 3,650.00 349.97 3,147.92 1,529.92 317.99 1,802.09 50.63% Staff Support 5,700.00 1,406.33 4,718.01 4,100.35 - 1,599.65 71.94% Professional Services 2,300.00 - 2,318.00 2,364.00 - (64.00) 102.78% Operating Equipment 135,000.00 23,434.49 92,741.33 93,797.25 13,348.71 27,854.04 79.37% TOTAL LIBRARY 967,904.00 255,029.65 723,423.99 738,838.92 15,525.93 213,539.15 77.94% TOTAL CULTURAL 967,904.00 255,029.65 723,423.99 738,838.92 15,525.93 213,539.15 77.94% HEALTH ANIMAL SERVICES Personnel Services 327,839.00 92,023.65 218,582.38 245,006.75 - 82,832.25 74.73% Supplies 37,380.00 8,265.08 20,212.35 27,735.19 2,670.34 6,974.47 81.34% City Support Services 3,500.00 - 791.96 - - 3,500.00 0.00% Utility Services 44,000.00 10,514.58 26,261.80 42,085.54 - 1,914.46 95.65% Operations Support 1,000.00 - 256.07 229.67 - 770.33 22.97% Staff Support 13,750.00 2,431.42 3,269.34 5,993.97 115.98 7,640.05 44.44% City Assistance 17,000.00 4,097.15 11,075.32 12,856.76 - 4,143.24 75.63% Professional Services 25,800.00 4,351.50 11,547.01 13,081.45 - 12,718.55 50.70% Maintenance Services 7,500.00 640.00 2,095.00 885.27 - 6,614.73 11.80% Operating Equipment 22,500.00 980.00 8,044.40 1,813.03 - 20,686.97 8.06% TOTAL ANIMAL SERVICES 500,269.00 123,303.38 302,135.63 349,687.63 2,786.32 147,795.05 70.46% TOTAL HEALTH 500,269.00 123,303.38 302,135.63 349,687.63 2,786.32 147,795.05 70.46% INTERNAL SERVICE 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 INFORMATION TECHNOLOGY Personnel Services 626,643.00 189,303.77 422,271.75 512,517.17 33.00 114,092.83 81.79% Supplies 9,140.00 941.29 6,761.48 4,080.62 159.38 4,900.00 46.39% City Support Services 920,029.00 133,550.01 551,412.47 470,292.76 6,197.50 443,538.74 51.79% Utility Services 235,768.00 44,679.48 145,871.83 139,464.93 - 96,303.07 59.15% Staff Support 43,600.00 15,860.64 26,211.63 35,130.03 18.00 8,451.97 80.61% Professional Services 477,919.00 35,105.00 5,745.10 45,955.00 111,410.96 320,553.04 32.93% Maintenance Services 14,500.00 3,087.57 10,098.86 8,343.79 3,948.66 2,207.55 84.78% Operating Equipment 429,660.00 102,880.04 162,360.91 263,275.11 7,901.53 158,483.36 63.11% Capital Outlay 33,500.00 30.15 1,609.96 5,397.15 25,430.25 2,672.60 92.02% TOTAL INFORMATION TECHNOLOGY 2,790,759.00 525,437.95 1,332,343.99 1,484,456.56 155,099.28 1,151,203.16 58.75% HUMAN RESOURCES Personnel Services 424,635.00 110,916.10 307,456.70 307,524.14 - 117,110.86 72.42% Supplies 700.00 173.68 524.02 551.57 48.76 99.67 85.76% Human Services 74,500.00 24,151.63 38,386.91 43,828.48 11,757.97 18,913.55 74.61% City Support Services - - 204.36 - - - 0.00% Utility Services - - 341.91 - - - 0.00% Operations Support 6,700.00 169.00 6,306.20 2,956.16 744.50 2,999.34 55.23% Staff Support 36,500.00 5,302.87 7,514.84 19,890.70 2,559.89 14,049.41 61.51% City Assistance 10,000.00 2,038.00 7,745.00 9,095.00 - 905.00 90.95% Professional Services 132,350.00 1,503.00 6,927.75 4,482.00 - 127,868.00 3.39% Operating Equipment 2,000.00 - - - 279.99 1,720.01 14.00% TOTAL HUMAN RESOURCES 687,385.00 144,254.28 375,407.69 388,328.05 15,391.11 283,665.84 58.73% FINANCE Personnel Services 573,362.00 151,491.92 416,965.27 425,434.20 - 147,927.80 74.20% Supplies 4,575.00 1,026.52 2,412.26 3,128.55 183.85 1,262.60 72.40% City Support Services - 138.00 - - - 0.00% Operations Support 2,155.00 - 1,200.00 - - 2,155.00 0.00% Staff Support 9,495.00 2,040.40 5,298.48 3,476.40 150.00 5,868.60 38.19% Professional Sevices 34,500.00 12,999.75 16,005.00 22,531.75 - 11,968.25 65.31% Operating Equipment 1,395.00 164.66 - 559.66 690.69 144.65 89.63% TOTAL FINANCE 625,482.00 167,723.25 442,019.01 455,130.56 1,024.54 169,326.90 72.93% PURCHASING & ASSET MGT 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 Personnel Services 210,449.00 57,835.45 149,624.08 163,888.23 - 46,560.77 77.88% Supplies 1,450.00 43.10 180.57 1,276.95 29.99 143.06 90.13% Utility Services - - 193.35 - - - 0.00% Operations Support 7,450.00 3,126.50 53.15 5,065.50 - 2,384.50 67.99% Staff Support 6,700.00 1,472.63 2,566.61 3,018.83 546.85 3,134.32 53.22% City Assistance 3,000.00 349.00 423.00 1,578.00 30.00 1,392.00 53.60% Operating Equipment 350.00 - 545.99 - - 350.00 0.00% TOTAL PURCHASING & ASSET MGT 229,399.00 62,826.68 153,586.75 174,827.51 606.84 53,964.65 76.48% FLEET SERVICE Personnel Services 354,881.00 77,672.39 234,103.75 205,728.02 - 149,152.98 57.97% Supplies 167,530.00 46,361.70 114,243.56 135,018.02 14,730.68 17,781.30 89.39% City Support Services 16,500.00 13,263.11 13,117.77 15,846.80 - 653.20 96.04% Utility Services 8,000.00 2,629.05 6,958.86 6,076.94 - 1,923.06 75.96% Staff Support 20,682.00 9,996.21 6,525.33 14,592.46 97.65 5,991.89 71.03% Maintenance Services 199,750.00 33,964.40 136,018.52 120,591.09 34,399.88 44,759.03 77.59% Operating Equipment 8,200.00 2,981.92 1,296.86 6,444.59 211.97 1,543.44 81.18% Capital Outlay 105,000.00 - 26,491.00 36,943.00 61,649.75 6,407.25 93.90% TOTAL FLEET SERVICE 880,543.00 186,868.78 538,755.65 541,240.92 111,089.93 228,212.15 74.08% FACILITY SERVICES Personnel Services 691,769.00 181,040.31 589,215.89 508,039.95 - 183,729.05 73.44% Supplies 146,800.00 21,076.11 82,776.58 70,704.25 5,211.40 70,884.35 51.71% Utility Services 170,500.00 40,916.86 101,303.28 104,934.47 - 65,565.53 61.55% Operation Support - - 24,734.67 - - - 0.00% Staff Support 15,800.00 1,716.46 5,231.83 4,535.24 268.12 10,996.64 30.40% Professional Services 85,550.00 13,217.10 28,364.61 50,703.75 13,673.62 21,172.63 75.25% Maintenance Services 373,535.91 111,659.97 154,731.11 258,538.21 117,872.04 (2,874.34) 100.77% Rental/Leasing 1,000.00 - 3,077.95 400.00 - 600.00 40.00% Operating Equipment 21,000.00 3,988.00 1,920.02 3,988.00 1,239.92 15,772.08 24.89% Capital Outlay 36,464.09 - - 10,426.05 25,908.15 129.89 99.64% TOTAL BUILDING MAINTENANCE 1,542,419.00 373,614.81 991,355.94 1,012,269.92 164,173.25 365,975.83 76.27% TOTAL INTERNAL SERVICE 6,755,987.00 1,460,725.75 3,833,469.03 4,056,253.52 447,384.95 2,252,348.53 66.66% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 317,666.00 78,216.23 217,420.35 219,356.13 66,485.09 31,824.78 89.98% Operating Equipment 15,000.00 9,219.87 - 11,315.88 - 3,684.12 75.44% TOTAL CITY ASSISTANCE 332,666.00 87,436.10 217,420.35 230,672.01 66,485.09 35,508.90 89.33% 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 377,666.00 87,436.10 217,420.35 230,672.01 68,985.09 78,008.90 79.34% TOTAL EXPENDITURES 33,331,353.95 8,680,247.62 20,876,893.68 22,790,520.73 1,243,647.75 9,297,185.47 72.11% REVENUE OVER(UNDER) EXPEND.825,194.62 (2,852,950.31) 6,200,688.07 5,521,889.79 (1,243,572.75) (3,453,122.42) 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 13,122,952.00 187,401.24 11,771,798.48 13,382,027.14 - (259,075.14) 101.97% 000-411110 Disabled Veterans Assistance - 201,117.19 - 201,117.19 - (201,117.19) 0.00% 000-411200 Advalorem Tax - Delinquent 50,000.00 22,108.22 41,144.33 47,315.92 - 2,684.08 94.63% 000-411300 Advalorem Tax - P&I 50,000.00 21,696.06 71,139.17 53,119.80 - (3,119.80) 106.24% 000-411500 Sales Tax Revenue-Gen Fund 8,252,000.00 2,612,076.68 6,306,016.63 6,555,232.11 - 1,696,767.89 79.44% 000-411600 Bingo Tax 50.00 - 11.25 24.30 - 25.70 48.60% 000-411700 Mixed Beverage Tax 44,000.00 14,419.62 32,786.91 39,857.22 - 4,142.78 90.58% TOTAL Taxes 21,519,002.00 3,058,819.01 18,222,896.77 20,278,693.68 - 1,240,308.32 94.24% Franchises 000-421200 Center Point/Entex Energy 82,988.93 16,556.47 66,523.69 75,797.43 - 7,191.50 91.33% 000-421220 City Public Service 1,022,833.82 247,917.05 678,190.96 691,053.50 - 331,780.32 67.56% 000-421240 Guadalupe Valley Elec Co-op 423,553.61 89,884.32 319,143.24 290,851.33 - 132,702.28 68.67% 000-421250 New Braunfels Utilities 74,472.96 20,697.77 50,591.13 49,206.13 - 25,266.83 66.07% 000-421300 Time Warner-State Franchise 298,637.68 86,087.76 231,124.09 241,405.05 - 57,232.63 80.84% 000-421460 AT&T Franchise Fee 152,418.58 45,857.04 100,641.54 110,962.48 - 41,456.10 72.80% 000-421480 Other Telecom Franchise 162,780.99 8,591.42 99,253.12 48,218.99 - 114,562.00 29.62% 000-421500 Solid Waste Franchise Fee 156,000.00 37,281.56 113,579.67 116,455.22 - 39,544.78 74.65% TOTAL Franchises 2,373,686.57 552,873.39 1,659,047.44 1,623,950.13 - 749,736.44 68.41% Permits 000-431100 Home Occupation Permit 500.00 35.00 490.00 490.00 - 10.00 98.00% 000-431205 Building Permit - Residential 618,520.00 106,810.00 522,865.50 338,844.00 - 279,676.00 54.78% 000-431210 Building Permit - Commercial 270,000.00 30,071.00 641,774.50 64,500.00 - 205,500.00 23.89% 000-431215 Building Permit - General 220,000.00 72,199.00 220,209.00 251,797.00 - (31,797.00) 114.45% 000-431300 Mobile Home Permit 300.00 225.00 250.00 625.00 - (325.00) 208.33% 000-431400 Signs Permit 5,800.00 1,605.00 3,661.00 6,319.00 - (519.00) 108.95% 000-431500 Food Establishmnt Permit 63,000.00 1,795.00 57,890.00 59,735.00 - 3,265.00 94.82% 000-431600 Garage Sale Permit - - - - - - 0.00% 000-431700 Plumbing Permit 128,800.00 28,526.00 126,215.95 89,659.00 - 39,141.00 69.61% 000-431750 Electrical Permit 65,500.00 15,980.00 61,840.00 50,280.00 - 15,220.00 76.76% 000-431800 Mechanical Permit 65,900.00 16,320.00 57,460.00 44,880.00 - 21,020.00 68.10% 000-431900 Solicitor/Peddler Permit 1,500.00 4,780.00 1,910.00 6,030.00 - (4,530.00) 402.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 1,950.00 4,550.00 6,050.00 - 450.00 93.08% 000-432100 Security Alarm Permit 36,000.00 11,200.00 36,163.00 33,896.00 - 2,104.00 94.16% 000-432300 Grading/Clearing Permit 15,000.00 3,601.00 12,641.72 11,138.13 - 3,861.87 74.25% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 000-432400 Development Permit 81,000.00 5,835.58 23,554.48 16,494.84 64,505.16 20.36% 000-435000 Fire Permit 25,000.00 6,296.00 27,223.48 21,702.50 - 3,297.50 86.81% 000-436010 Network Nodes - - 1,750.00 - - - 0.00% TOTAL Permits 1,604,320.00 307,228.58 1,800,538.63 1,002,440.47 - 601,879.53 62.48% Licenses 000-441000 Alcohol Beverage License 8,000.00 2,575.00 5,515.00 5,590.00 - 2,410.00 69.88% 000-441300 Mobile Home License 160.00 - 80.00 80.00 - 80.00 50.00% 000-442000 Contractors License 45,600.00 14,700.00 51,510.00 43,250.00 - 2,350.00 94.85% 000-444000 Pet License 3,000.00 755.05 1,975.00 2,052.05 - 947.95 68.40% TOTAL Licenses 56,760.00 18,030.05 59,080.00 50,972.05 - 5,787.95 89.80% Fees 000-451000 Municipal Court Fines 382,303.00 181,253.18 460,672.85 521,861.53 - (139,558.53) 136.50% 000-451100 Arrest Fee 21,012.00 6,663.33 16,467.07 19,506.42 - 1,505.58 92.83% 000-451110 Expunction Fee 120.00 - - - - 120.00 0.00% 000-451200 Warrant Fees 98,000.00 19,757.90 58,742.81 56,539.38 - 41,460.62 57.69% 000-451210 Court - Claims & Judgements - - 806.10 (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 886.16 2,253.07 2,603.70 - 172.30 93.79% 000-451400 Traffic Fine Costs TTL 6,000.00 3,103.55 7,557.48 9,188.61 - (3,188.61) 153.14% 000-451510 Juvenile Case Mgmt Fee 23,236.00 7,389.73 18,826.52 21,727.66 - 1,508.34 93.51% 000-451520 Truancy Fee 3,934.00 1,357.96 3,237.96 4,038.57 (104.57) 102.66% 000-451600 Technology Fund Fee 18,793.00 5,861.03 15,068.61 17,361.82 - 1,431.18 92.38% 000-451700 Security Fee 7,475.00 4,395.77 11,396.40 13,021.38 - (5,546.38) 174.20% 000-451800 Time Payment Fee - City 4,119.00 1,403.37 3,858.78 3,892.55 - 226.45 94.50% 000-451850 State Fines 10% Service Fee 20,000.00 8,017.77 21,475.76 27,394.30 - (7,394.30) 136.97% 000-451900 DPS Payment - Local 6,210.00 1,540.69 4,625.21 4,338.95 - 1,871.05 69.87% 000-452000 Child Safety Fee 4,874.00 2,309.62 4,944.11 7,491.38 - (2,617.38) 153.70% 000-452100 Platting Fees 57,000.00 9,500.00 41,250.00 37,500.00 - 19,500.00 65.79% 000-452200 Site Plan Fee 38,000.00 11,500.00 33,000.00 25,500.00 - 12,500.00 67.11% 000-452300 Plan Check Fee 514,260.00 99,952.00 655,138.00 344,984.93 - 169,275.07 67.08% 000-452320 Tree Mitigation Admin Fee 12,000.00 1,162.50 17,368.50 937.50 - 11,062.50 7.81% 000-452400 BOA/Zoning Fees 6,500.00 1,000.00 3,277.64 2,750.00 - 3,750.00 42.31% 000-452600 Specific Use/Zone Chng Fee 18,000.00 5,500.00 21,200.00 18,800.00 - (800.00) 104.44% 000-452710 Zoning Ltr & Dev Rights 1,950.00 750.00 1,200.00 3,000.00 - (1,050.00) 153.85% 000-453100 Reinspection Fees 100,100.00 63,875.00 115,500.00 170,090.00 - (69,990.00) 169.92% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 000-453110 Swim Pool Inspection Fee 2,920.00 1,210.00 2,620.00 1,320.00 - 1,600.00 45.21% 000-453200 Lot Abatement 5,000.00 750.00 1,615.00 750.00 - 4,250.00 15.00% 000-453211 Admin Fee-Inspections 15,500.00 2,600.00 21,600.00 9,300.00 - 6,200.00 60.00% 000-453310 Misc Inspection Fee - 100.00 3,213.00 400.00 - (400.00) 0.00% 000-453710 Foster Care 1,200.00 200.00 850.00 350.00 - 850.00 29.17% 000-454200 Pool Gate Admission Fee 24,000.00 8,184.25 6,881.00 8,130.25 - 15,869.75 33.88% 000-454300 Seasonal Pool Pass Fee 5,000.00 3,750.00 3,510.00 3,750.00 - 1,250.00 75.00% 000-456120 Senior Center Meal Fee - - 802.00 401.00 - (401.00) 0.00% 000-456500 Haz Mat Fees 5,000.00 - - 1,041.25 - 3,958.75 20.83% 000-456600 Fire Re-inspection Fee 1,000.00 200.00 895.00 350.00 - 650.00 35.00% 000-456600 Sale of General Fixed Asset 20,000.00 - 19,251.61 - - 20,000.00 0.00% 000-458100 Sale of Merchandise - 1,475.00 - 2,071.39 (2,071.39) 0.00% 000-458110 Sale of Merchandise-GovDeal 25,000.00 24,636.04 34,628.95 100,155.24 - (75,155.24) 400.62% 000-458400 Civic Center Rental Fees 197,000.00 76,636.00 153,079.50 179,295.37 75.00 17,629.63 91.05% 000-458401 Capital Recovery Fee-Civic Cntr 7,500.00 7,015.00 6,245.00 12,880.00 - (5,380.00) 171.73% 000-458450 North Center Rental Fees 23,000.00 7,335.00 19,785.00 19,789.50 3,210.50 86.04% 000-458460 Senior Center Rental 7,200.00 1,400.00 2,500.00 5,600.00 - 1,600.00 77.78% 000-458500 Community Center Rental Fees 35,000.00 12,642.50 31,659.50 33,091.00 - 1,909.00 94.55% 000-458510 Grand Ballroom Rental Fees - - - 2,500.00 (2,500.00) 0.00% 000-458540 Bluebonnet Hall Rental Fees - - - 75.00 (75.00) 0.00% 000-458550 Pavilion Rental Fees 20,000.00 7,410.50 15,597.50 15,076.50 - 4,923.50 75.38% 000-458560 Chamber of Comm rent 7,800.00 1,950.00 5,850.00 5,850.00 - 1,950.00 75.00% 000-458570 Non-Resident SYSA League 10,000.00 19,170.00 13,080.00 19,170.00 - (9,170.00) 191.70% 000-458650 NonResident User Fee-BVYA 10,000.00 - 9,090.00 3,240.00 - 6,760.00 32.40% 000-458660 BVYA Utility Reimbursement 15,000.00 - 13,295.98 7,165.84 - 7,834.16 47.77% 000-458670 SYSA Utility Reimbursement 15,000.00 - 5,464.58 1,923.89 - 13,076.11 12.83% 000-458675 Lions Futbol Utility Reimbursement 10,000.00 - 2,344.00 7,032.00 - 2,968.00 70.32% 000-458700 Vehicle Impoundment 10,000.00 - 8,070.00 4,720.00 - 5,280.00 47.20% 000-459200 NSF Check Fee 100.00 50.00 25.00 100.00 - - 100.00% 000-459300 Notary Fee 200.00 24.00 90.00 42.00 - 158.00 21.00% 000-459400 Maps, Copies, UDC, & Misc F - 15.00 25.00 30.00 - (30.00) 0.00% 000-459600 Animal Adoption Fee 12,500.00 3,360.00 12,912.90 8,870.12 - 3,629.88 70.96% 000-459700 Pet Impoundment Fee 6,300.00 1,731.34 4,797.20 3,721.34 - 2,578.66 59.07% 000-459800 Police Reports Fee 5,800.00 1,212.00 4,385.50 4,237.50 - 1,562.50 73.06% 000-45990 Fire - False Alarm Fee - - - - - - 0.00% TOTAL Fees 1,843,973.00 620,236.19 1,922,030.09 1,774,742.98 75.00 69,155.02 96.25% Fines 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 000-463000 Library Fines 22,000.00 3,430.23 16,788.84 10,834.12 - 11,165.88 49.25% TOTAL Fines 22,000.00 3,430.23 16,788.84 10,834.12 - 11,165.88 49.25% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,077.00 - 21,077.76 5,269.44 - 15,807.56 25.00% 000-473200 City of Seguin - Fire Contract 29,231.00 7,526.94 21,923.10 22,580.82 - 6,650.18 77.25% 000-473300 Guad Co - Library 218,000.00 54,288.00 144,768.00 162,864.00 - 55,136.00 74.71% 000-473400 Randolph AFB-Animal Cntrl 1,200.00 - 200.00 - - 1,200.00 0.00% 000-474200 Library Services - Cibolo 35,000.00 - 35,001.50 - - 35,000.00 0.00% 000-474210 Library Services-Selma 22,000.00 - 21,750.00 23,475.00 - (1,475.00) 106.70% 000-474400 Dispatch Service - Cibolo 166,000.00 - 120,000.00 80,000.00 - 86,000.00 48.19% 000-474600 School Crossing Guard-Bexar 38,000.00 10,999.59 33,059.39 23,465.59 - 14,534.41 61.75% 000-474610 School Cross Guard-Guadalupe 38,500.00 11,913.65 33,361.59 27,918.48 - 10,581.52 72.52% 000-474700 School Officer Funding 348,000.00 84,119.48 127,500.00 265,128.13 - 82,871.87 76.19% 000-474750 Crime Victim Liaison Agreement 50,000.00 1,130.10 18,760.00 26,130.10 - 23,869.90 52.26% TOTAL Inter-Jurisdictional 967,008.00 169,977.76 577,401.34 636,831.56 - 330,176.44 65.86% Fund Transfers 000-480000 Indirect Costs - EMS 175,587.00 43,896.75 127,565.16 131,690.25 - 43,896.75 75.00% 000-480100 Indirect Costs - Hotel/Motel 67,582.00 16,895.49 49,803.75 50,686.51 - 16,895.49 75.00% 000-481000 Transfer In Reserves 2,226,359.00 - - - - 2,226,359.00 0.00% 000-482100 Transfer From Reserves-Ct Tech 26,207.00 - - - - 26,207.00 0.00% 000-485000 Interfund Charge-Drainage 295,157.00 73,789.26 203,572.41 221,367.74 - 73,789.26 75.00% 000-486000 Interfund Chrges-Admin W&S 1,365,998.00 341,499.51 1,008,104.91 1,024,498.49 - 341,499.51 75.00% 000-486202 Transfer In-W&S 4,000.00 - - - - 4,000.00 0.00% 000-486203 Transfer In-EMS 4,000.00 - - - - 4,000.00 0.00% 000-486204 Transfer in-Drainage 1,000.00 - - - 1,000.00 0.00% 000-487000 Interfund Charges-Fleet 370,729.00 92,918.17 258,214.75 278,282.45 - 92,446.55 75.06% 000-488000 Interfund Charges-4B 456,630.00 228,315.00 441,395.00 456,630.00 - - 100.00% 000-489000 Transfer In 70,000.00 - - - - 70,000.00 0.00% 000-489620 Contribution - SEDC - - - - - - 0.00% TOTAL Fund Transfers 5,063,249.00 797,314.18 2,088,655.98 2,163,155.44 - 2,900,093.56 42.72% Miscellaneous 000-491000 Interest Earned 35,000.00 15,860.56 21,003.29 56,715.91 - (21,715.91) 162.05% 000-491200 Investment Income 235,000.00 114,378.71 167,013.00 312,347.84 - (77,347.84) 132.91% 000-491800 Gain/Loss - (9,567.37) (16,041.86) (9,867.17) - 9,867.17 0.00% 000-491900 Unrealized Gain/Loss - 4,643.12 (8.73) 15,679.05 - (15,679.05) 0.00% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 000-493000 Donations-Others - - 20.00 50.00 - (50.00) 0.00% 000-493120 Donations-Public Library 10,000.00 625.15 5,831.16 7,658.32 - 2,341.68 76.58% 000-493130 Donations-Writing the Next Chap.- - - - - - 0.00% 000-493400 Donation - Animal Control 15,000.00 1,495.00 12,295.67 2,624.75 - 12,375.25 17.50% 000-493401 Donations-A/C Microchip 1,000.00 45.00 495.00 75.00 - 925.00 7.50% 000-493402 Donations-Spay&Neuter 1,000.00 - 87.00 - - 1,000.00 0.00% 000-493404 Donations-TNR Program 500.00 - - - - 500.00 0.00% 000-493460 Donations-Parks 10,000.00 700.00 10,825.00 3,160.51 - 6,839.49 31.61% 000-493465 Donations-Senior Center 10,000.00 3,705.17 8,232.55 8,886.70 - 1,113.30 88.87% 000-493502 Donations-PD - 2,255.00 28,599.00 (24,345.00) - 24,345.00 0.00% 000-493503 Donations-Fire Rescue - 1,100.00 15,350.00 1,600.00 - (1,600.00) 0.00% 000-494481 LawEnforcemtOfficersStnd&Ed 3,650.00 - 3,823.43 4,341.18 - (691.18) 118.94% 000-494482 Grants - Police, Fire, Gen Fund 3,000.00 - 1,473.67 - - 3,000.00 0.00% 000-495100 Mobile Stage Rental Fees 2,100.00 2,050.00 2,100.00 2,050.00 - 50.00 97.62% 000-497000 Misc Income-Gen Fund 60,000.00 8,525.67 68,702.88 34,730.54 - 25,269.46 57.88% 000-497005 Schertz Magazine Advertising 140,000.00 37,125.00 108,055.00 110,325.00 - 29,675.00 78.80% 000-497100 Misc Income-Police 3,800.00 2,782.30 8,375.02 7,442.90 - (3,642.90) 195.87% 000-497150 Misc Income-Fire Department - - 970.11 - - - 0.00% 000-497200 Misc Income-Library 4,500.00 1,251.25 3,855.20 3,603.60 - 896.40 80.08% 000-497210 Misc Income-Library Copier 18,000.00 5,739.10 14,220.15 15,604.20 - 2,395.80 86.69% 000-497300 Misc Income-Animal Control - 145.00 298.75 320.00 - (320.00) 0.00% 000-497400 Misc Income-Streets Dept.60,000.00 10,040.00 22,503.97 18,644.25 - 41,355.75 31.07% 000-497460 Misc Income-Parks - 139.80 - 139.80 (139.80) 0.00% 000-497500 Misc Income-TML Insurance 20,000.00 975.79 33,050.83 17,217.74 - 2,782.26 86.09% 000-497550 Misc Income-TML Reimbursemt 15,000.00 1,530.65 1,471.48 1,530.65 - 13,469.35 10.20% 000-497600 Misc Income-Vending Mach.2,500.00 766.04 1,786.33 2,130.82 - 369.18 85.23% 000-497610 Misc Income- Muni Court - 4.20 2,036.40 154.20 - (154.20) 0.00% 000-498000 Reimbursmnt-Gen Fund 20,000.00 - 8,355.21 - - 20,000.00 0.00% 000-498100 Reimbursmnt Fire - Training 500.00 - - - - 500.00 0.00% 000-498105 Reimburmnt Police - DEA - 3,214.51 10,561.95 12,794.70 - (12,794.70) 0.00% 000-498107 Reimburmnt Police - Event - - - - - - 0.00% 000-498110 Reimbursmnt Fire - Emg. Acti-O 30,000.00 89,858.27 179,445.81 152,156.41 - (122,156.41) 507.19% 000-498150 Reimbursemnt - Library 6,000.00 - 6,355.39 13,018.19 - (7,018.19) 216.97% TOTAL Miscellaneous 706,550.00 299,387.92 731,142.66 770,790.09 - (64,240.09) 109.09% TOTAL REVENUES 34,156,548.57 5,827,297.31 27,077,581.75 28,312,410.52 75.00 5,844,063.05 82.89% Cash in Bank Claim on Operating Cash Pool-Checking 515,305.49$ Cash in Investments LOGIC Investment-General Fund 14,884,626.15 LOGIC Investment-Equip Replacement 77,639.55 LOGIC Investment-Veh Replacement 523,505.70 LOGIC Investment-Air Condi Replacment 284,895.96 BBVA CD Investment 1,015,620.41 CAPITAL ONE Investment-General Fund 1,400,510.32 Total Cash in Bank & Investments 18,702,103.58$ GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2018-19 255,207 587,379 5,347,223 5,289,147 160,362 85,307 60,277 71,690 55,434 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 571,251 769,881 603,905 647,650 699,759 950,507 2017-18 644,584 686,048 615,170 627,981 744,714 583,818 673,567 750,755 640,283 840,254 795,116 634,780 2016-17 574,470 758,598 580,171 560,431 747,281 486,739 432,444 669,542 553,540 566,565 696,536 573,973 2015-16 479,069 744,668 529,686 493,136 783,019 530,498 531,707 615,841 568,508 523,141 691,061 678,167 2014-15 495,499 638,904 505,026 421,339 795,382 450,965 494,050 723,404 465,966 496,241 759,879 508,305 18.9%7.3% 2.0%-9.0% 3.4% 3.4% -3.8% -6.8% 48.5% $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 $1,000,000 Sales Tax -General Fund OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2018-19 270,225 203,885 199,326 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 75% 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,255.13 100,876.92 81,609.55 - 18,650.45 81.40% TOTAL REVENUES 156,760.00 33,255.13 100,876.92 81,609.55 - 75,150.45 52.06% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental - - - - - - 0.00% TOTAL GENERAL GOVERNMENT - - - - - - 0.00% CULTURAL Festival of Angels 16,255.00 29.00 10,566.23 17,361.29 - (1,106.29) 106.81% Employee Appreciation Event - - 12,003.97 - - - 0.00% 4th of July Jubilee 26,000.00 2,526.90 142.88 2,526.90 28,020.80 (4,547.70) 117.49% National Night Out 500.00 - - - - 500.00 0.00% Wilenchik Walk for Life 15,000.00 1,314.13 3,409.68 9,365.50 - 5,634.50 62.44% Schertz Fest 42,943.00 5,165.16 653.98 636.00 700.00 41,607.00 3.11% Schertz Sweetheart 24,000.00 7,073.35 12,482.01 9,527.69 201.94 14,270.37 40.54% Hal Baldwin Scholarship 15,510.00 844.31 13,537.61 11,455.93 - 4,054.07 73.86% Other Events 37,500.00 12,507.63 16,715.69 33,232.52 1,629.04 2,638.44 92.96% TOTAL CULTURAL 177,708.00 29,460.48 69,512.05 84,105.83 30,551.78 63,050.39 64.52% TOTAL EXPENDITURES 177,708.00 29,460.48 69,512.05 84,105.83 30,551.78 63,050.39 64.52% REVENUE OVER(UNDER) EXPEND (20,948.00) 3,794.65 31,364.87 (2,496.28) (30,551.78) 12,100.06 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fund Transfers 000-486101 Transfer In - General Fund 56,500.00 - - - - 56,500.00 0.00% TOTAL Fund Transfers 56,500.00 - - - - 56,500.00 0.00% Miscellaneous 000-491200 Investment Income 250.00 112.13 214.73 332.05 - (82.05) 132.82% 000-492200 Wilenchik Walk for Life 15,000.00 335.00 10,525.00 9,305.50 - 5,694.50 62.04% 000-493000 July 4th Activities 26,000.00 11,611.00 22,125.00 11,541.00 - 14,459.00 44.39% 000-493150 SchertzQ 30,000.00 - 200.00 (1,250.00) - 31,250.00 -4.17% 000-493256 Donations - Police Events 3,000.00 - - - - 3,000.00 0.00% 000-493455 Proceeds-Festival of Angels 1,500.00 - 1,305.00 4,170.00 - (2,670.00) 278.00% 000-493460 Schertz Sweetheart 488.00 (20.81) 488.00 - (488.00) 0.00% 000-493470 Moving on Main 3,000.00 3,010.00 680.00 4,560.00 (1,560.00) 152.00% 000-493621 Hal Baldwin Scholarship 15,510.00 - 20,105.00 28,820.00 - (13,310.00) 185.82% 000-497000 Misc Income 6,000.00 17,699.00 45,743.00 23,643.00 - (17,643.00) 394.05% TOTAL Miscellaneous 100,260.00 33,255.13 100,876.92 81,609.55 - 18,650.45 81.40% TOTAL REVENUES 156,760.00 33,255.13 100,876.92 81,609.55 - 75,150.45 52.06% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 72,072.71$ Cash in Investments Texas Class- Special Events 17,711.19 Total Cash in Bank & Investments 89,783.90$ SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 78,990.77 22,167.15 21,430.96 65,067.98 - 13,922.79 82.37% Fund Transfers 116,009.23 - - - - 116,009.23 0.00% TOTAL REVENUES 195,000.00 22,167.15 21,430.96 65,067.98 - 129,932.02 33.37% EXPENDITURE SUMMARY MISC & PROJECTS Projects 195,000.00 3,258.50 - 3,258.50 - 191,741.50 1.67% TOTAL MISC & PROJECTS 195,000.00 3,258.50 - 3,258.50 - 191,741.50 1.67% TOTAL EXPENDITURES 195,000.00 3,258.50 - 3,258.50 - 191,741.50 1.67% REVENUE OVER(UNDER) EXPEND - 18,908.65 21,430.96 61,809.48 - (61,809.48) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 110-PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421350 Time Warner - PEG Fee 60,168.03 15,565.30 14,010.64 45,952.85 - 14,215.18 76.37% 000-421465 AT&T PEG Fee 18,822.74 6,601.85 7,420.32 19,115.13 - (292.39) 101.55% TOTAL Franchises 78,990.77 22,167.15 21,430.96 65,067.98 - 13,922.79 82.37% Fund Transfers 000-489000 Transfer In 116,009.23 - - - - 116,009.23 0.00% TOTAL REVENUES 195,000.00 22,167.15 21,430.96 65,067.98 - 129,932.02 33.37% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 Cash in Bank Cash Balance 766,989.83$ Total Cash in Bank & Investments 766,989.83$ PEG FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 263,517.05 76,948.84 212,931.15 221,553 - 41,964.47 84.08% Fees 24,439,057.45 5,972,235.32 16,961,368.30 16,897,492 - 7,541,565.00 69.14% Fund Transfers 685,836.00 35,250.00 106,132.50 105,750 - 580,086.00 15.42% Miscellaneous 347,111.00 134,608.46 223,060.58 386,463 - (39,351.64) 111.34% TOTAL REVENUES 25,735,521.50 6,219,042.62 17,503,492.53 17,611,257.67 - 8,124,263.83 68.43% EXPENDITURE SUMMARY NON DEPARTMENTAL Transfer to Public Improvements 125,000.00 125,000.00 - 125,000.00 - - 100.00% Other Finance Source - - - - - - 0.00% TOTAL NON DEPARTMENTAL 125,000.00 125,000.00 - 125,000.00 - - 100.00% BUSINESS OFFICE Personnel Services 499,900.00 128,381.07 348,976.16 338,721.64 - 161,178.36 67.76% Supplies 3,800.00 149.20 1,501.23 1,330.70 426.58 2,042.72 46.24% City Support Services 5,655.00 - - 250.00 - 5,405.00 4.42% Utility Services 10,365.00 2,260.98 750.65 2,750.17 - 7,614.83 26.53% Operations Support 158,500.00 47,443.63 107,682.12 95,062.65 1.15 63,436.20 59.98% Staff Support 6,250.00 1,309.27 2,184.21 3,378.64 - 2,871.36 54.06% Professional Services 243,000.00 30,611.22 151,695.14 138,014.66 - 104,985.34 56.80% Maintenance Services 8,040.00 1,260.00 4,860.00 5,280.00 1,680.00 1,080.00 86.57% Operating Equipment 600.00 - 3,656.94 359.97 - 240.03 60.00% TOTAL BUSINESS OFFICE 936,110.00 211,415.37 621,306.45 585,148.43 2,107.73 348,853.84 62.73% W & S ADMINISTRATION Personnel Services 1,432,723.00 388,630.64 913,816.58 1,027,815.67 - 404,907.33 71.74% Supplies 187,500.00 64,367.49 129,687.81 131,177.66 53,171.12 3,151.22 98.32% Human Services 700.00 - - - - 700.00 0.00% City Support Services 157,535.00 266.53 59,227.78 51,713.57 - 105,821.43 32.83% Utility Services 3,526,800.00 843,885.76 2,409,094.21 2,323,636.88 341.03 1,202,822.09 65.89% Operations Support 11,300.00 2,468.05 4,542.20 6,789.25 - 4,510.75 60.08% Staff Support 35,000.00 6,407.09 19,914.82 22,470.83 688.38 11,840.79 66.17% City Assistance 1,500.00 35.00 111.00 35.00 - 1,465.00 2.33% Professional Services 416,465.00 100,499.36 223,289.14 285,785.77 4,256.00 126,423.23 69.64% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% 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: JUNE 30, 2019 Fund Charges/Transfers 6,208,960.00 1,401,109.43 4,027,690.52 5,131,952.36 - 1,077,007.64 82.65% Maintenance Services 9,149,707.50 1,995,774.37 5,315,601.90 5,485,660.86 341,363.49 3,322,683.15 63.69% Other Costs 40,000.00 - 36,615.45 38,435.72 - 1,564.28 96.09% Debt Service 1,904,245.25 - 738,634.30 267,516.90 232,025.00 1,404,703.35 26.23% Rental-Leasing 124,500.00 (116,400.00) 2,782.95 (51,106.56) - 175,606.56 -41.05% Operating Equipment 9,000.00 - 826.79 475.98 2,827.40 5,696.62 36.70% Capital Outlay 712,978.00 178,720.82 - 689,542.46 39,087.00 (15,651.46) 102.20% TOTAL PUBLIC WORKS 23,918,913.75 4,865,764.54 13,881,835.45 15,411,902.35 673,759.42 7,833,251.98 67.25% MISC & PROJECTS PROJECTS Operations Support - - 964.26 - - - 0.00% Professional Services - 14,336.25 8,457.50 14,336.25 19,186.25 (33,522.50) 0.00% Maintenance Services - 155,924.62 391,537.00 155,924.62 184,368.82 (340,293.44) 0.00% TOTAL PROJECTS - 170,260.87 400,958.76 170,260.87 203,555.07 (373,815.94) 0.00% TOTAL MISC & PROJECTS - 170,260.87 400,958.76 170,260.87 203,555.07 (373,815.94) 0.00% TOTAL EXPENDITURES 24,980,023.75 5,247,440.78 14,904,100.66 16,292,311.65 879,422.22 7,808,289.88 68.74% ** REVENUE OVER(UNDER)EXPENSES **755,497.75 971,601.84 2,599,391.87 1,318,946.02 (879,422.22) 315,973.95 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421490 Tower Leasing 263,517.05 76,948.84 212,931.15 221,552.58 - 41,964.47 84.08% TOTAL Franchises 263,517.05 76,948.84 212,931.15 221,552.58 - 41,964.47 84.08% Permits 000-432400 Development Permit - - - - - - 0.00% TOTAL Permits - - - - - - 0.00% Fees 000-455200 Garbage Collection Fee 5,217,962.06 1,256,046.68 3,683,425.10 3,771,210.08 - 1,446,751.98 72.27% 000-455600 Fire Line Fees 31,000.00 - 29,015.00 33,160.00 - (2,160.00) 106.97% 000-455700 Recycle Fee Revenue 315,500.00 84,021.58 231,075.94 245,432.05 - 70,067.95 77.79% 000-455800 W&S Line Constructn Reimbursemnt 20,000.00 4,972.00 28,379.57 14,999.00 - 5,001.00 75.00% 000-457100 Sale of Water 10,790,831.42 2,778,648.56 7,522,464.90 7,307,807.00 - 3,483,024.42 67.72% 000-457110 Edwards Water Lease 40,000.00 6,072.53 28,172.25 34,243.78 - 5,756.22 85.61% 000-457120 Water Transfer Charge-Selma 6,233.00 - 6,232.51 28,808.83 - (22,575.83) 462.20% 000-457200 Sale of Meters 160,000.00 22,847.06 115,295.03 63,073.06 - 96,926.94 39.42% 000-457400 Sewer Charges 7,578,030.97 1,819,453.14 5,117,543.30 5,391,274.43 - 2,186,756.54 71.14% 000-457500 Water Penalties 277,000.00 (501.23) 197,564.70 5,509.22 - 271,490.78 1.99% 000-459200 NSF Check Fee-Water&Sewer 2,500.00 675.00 2,200.00 1,975.00 - 525.00 79.00% TOTAL Fees 24,439,057.45 5,972,235.32 16,961,368.30 16,897,492.45 - 7,541,565.00 69.14% Fund Transfers 000-486000 Transfer In- Reserve 544,836.00 - - - - 544,836.00 0.00% 000-486204 Interfnd Chrg-Drainage Bill 141,000.00 35,250.00 106,132.50 105,750.00 - 35,250.00 75.00% TOTAL Fund Transfers 685,836.00 35,250.00 106,132.50 105,750.00 - 580,086.00 15.42% Miscellaneous 000-490000 Misc Charges 1,000.00 2,431.00 8,392.00 7,621.00 - (6,621.00) 762.10% 000-491000 Interest Earned 25,000.00 16,376.00 22,380.68 51,161.25 - (26,161.25) 204.65% 000-491200 Investment Income 180,000.00 53,228.36 91,546.16 178,982.36 - 1,017.64 99.43% 000-496000 Water Construction Reserve - - 1.00 - - - 0.00% 000-497000 Misc Income-W&S 15,000.00 711.67 2,730.99 46,119.14 - (31,119.14) 307.46% 000-497550 TML Reimbursements - - - - - - 0.00% 000-498100 Reimbursement-EMS Loan - - - - - - 0.00% 000-498110 Reimbursement-SSLGC 126,111.00 61,861.43 98,008.75 102,578.89 - 23,532.11 81.34% 000-498200 Reimbursement- W&S Project - - 1.00 - - - 0.00% TOTAL Miscellaneous 347,111.00 134,608.46 223,060.58 386,462.64 - (39,351.64) 111.34% TOTAL REVENUES 25,735,521.50 6,219,042.62 17,503,492.53 17,611,257.67 - 8,124,263.83 68.43% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 487,525.78$ Cash in Investments Lone Star Investment-Water&Sewer 8,077,058.66 Lone Star Investment-W&S Customer Deposits 311,331.11 Lone Star Investment-W&S Equip Replacement 187,186.91 Lone Star Investment-W&S Veh Replacement 270,408.48 Schertz Bank & Trust-Certificate of Deposit 1,112,177.02 9,958,162.18$ Total Cash in Bank & Investments 10,445,687.96$ WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 6,194,079.80 1,617,550.35 3,555,138.12 4,524,540.08 - 1,669,539.72 73.05% Inter-Jurisdictional 3,025,485.39 456,822.11 2,580,799.82 2,704,324.96 - 321,160.43 89.38% Fund Transfers - - - - - - 0.00% Miscellaneous 125,750.00 395,890.43 120,543.12 82,086.38 - 43,663.62 65.28% TOTAL REVENUES 9,345,315.19 2,470,262.89 6,256,481.06 7,310,951.42 - 2,034,363.77 78.23% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 4,446,474.29 1,126,901.66 3,060,046.39 3,207,376.79 82.85 1,239,014.65 72.13% Supplies 431,050.00 96,061.98 279,912.50 287,115.76 30,753.71 113,180.53 73.74% City Support Services 98,000.00 25,743.00 47,413.10 63,446.73 658.35 33,894.92 65.41% Utility Services 128,500.00 33,095.61 79,738.00 87,869.29 - 40,630.71 68.38% Operations Support 88,781.71 15,342.54 43,629.05 52,484.77 - 36,296.94 59.12% Staff Support 79,250.00 16,146.25 38,975.69 39,783.61 13,037.10 26,429.29 66.65% City Assistance 568,866.81 141,276.40 376,251.55 417,322.06 1,390.50 150,154.25 73.60% Professional Services 162,140.00 25,130.80 73,439.10 72,603.76 13,000.02 76,536.22 52.80% Fund Charges/Transfers 2,694,628.42 1,771,048.04 1,711,805.50 2,509,229.23 - 185,399.19 93.12% Maintenance Services 12,000.00 3,840.00 6,720.00 5,099.00 - 6,901.00 42.49% Debt Service 288,895.00 - 115,788.13 114,481.36 5,025.00 169,388.64 41.37% Rental-Leasing 141,000.00 32,278.40 87,050.22 100,780.31 - 40,219.69 71.48% Operating Equipment 89,550.00 7,909.41 30,940.22 40,721.23 4,565.47 44,263.30 50.57% Capital Outlay 6,500.00 - 605,731.76 6,500.00 - - 100.00% TOTAL PUBLIC SAFETY 9,235,636.23 3,294,774.09 6,557,441.21 7,004,813.90 68,513.00 2,162,309.33 76.59% TOTAL EXPENDITURES 9,235,636.23 3,294,774.09 6,557,441.21 7,004,813.90 68,513.00 2,162,309.33 76.59% ** REVENUE OVER(UNDER) EXPENSES **109,678.96 (824,511.20) (300,960.15) 306,137.52 (68,513.00) (127,945.56) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-456100 Ambulance/Mileage Transport 5,894,479.80 1,575,379.21 3,327,848.13 4,320,369.51 - 1,574,110.29 73.30% 000-456110 Subscription Program Fees 28,000.00 860.00 24,775.00 23,430.00 - 4,570.00 83.68% 000-456120 EMT Class - Fees 96,000.00 13,854.06 65,465.00 64,179.06 - 31,820.94 66.85% 000-456122 CE Class - Fees 21,500.00 2,654.00 20,712.52 17,022.00 - 4,478.00 79.17% 000-456130 Immunization Fees 7,000.00 568.40 3,008.17 2,283.74 - 4,716.26 32.62% 000-456140 Billing Fees - External 25,000.00 6,152.09 16,744.45 17,286.54 - 7,713.46 69.15% 000-456150 Standby Fees 27,000.00 - 28,300.70 21,509.50 - 5,490.50 79.66% 000-456155 Community Services Support 75,000.00 10,364.59 60,681.19 31,143.70 - 43,856.30 41.52% 000-456160 MIH Services 20,000.00 7,718.00 6,660.00 22,692.00 - (2,692.00) 113.46% 000-458110 Sales of Merchandise - GovDeal - - 842.96 4,574.03 - (4,574.03) 0.00% 000-459200 NSF Check Fee 100.00 - 100.00 50.00 - 50.00 50.00% TOTAL Fees 6,194,079.80 1,617,550.35 3,555,138.12 4,524,540.08 - 1,669,539.72 73.05% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 843,577.17 - 562,385.36 843,578.04 - (0.87) 100.00% 000-474300 Cibolo Support 410,582.70 102,645.68 346,467.64 307,937.04 - 102,645.66 75.00% 000-475100 Comal Co ESD #6 121,722.92 31,775.76 116,812.50 93,383.55 - 28,339.37 76.72% 000-475200 Live Oak Support 232,140.26 58,035.07 213,151.96 174,105.21 - 58,035.05 75.00% 000-475300 Universal City Support 300,091.66 75,022.92 281,283.72 225,068.76 - 75,022.90 75.00% 000-475400 Selma Support 148,697.12 37,174.28 111,886.36 111,522.84 - 37,174.28 75.00% 000-475500 Schertz Support 581,537.22 145,384.31 556,325.00 436,152.93 - 145,384.29 75.00% 000-475600 Santa Clara Support 10,789.68 2,697.42 10,447.36 8,092.26 - 2,697.42 75.00% 000-475800 Marion Support 16,346.66 4,086.67 15,186.96 12,260.01 - 4,086.65 75.00% 000-475910 TASPP Program 360,000.00 - 366,852.96 492,224.32 - (132,224.32) 136.73% TOTAL Inter-Jurisdictional 3,025,485.39 456,822.11 2,580,799.82 2,704,324.96 - 321,160.43 89.38% Miscellaneous 000-491000 Interest Earned 3,000.00 1,104.44 2,971.22 4,468.87 - (1,468.87) 148.96% 000-491200 Investment Income 750.00 3,340.57 5,923.33 6,680.96 - (5,930.96) 890.79% 000-493203 Donations-EMS 2,000.00 525.00 400.00 625.44 - 1,374.56 31.27% 000-493205 Donations- Golf Tournament 10,000.00 (2,160.00) 18,595.00 (2,160.00) - 12,160.00 -21.60% 000-497000 Misc Income 50,000.00 383,865.96 47,814.80 43,217.58 - 6,782.42 86.44% 000-497100 Recovery of Bad Debt 60,000.00 550.00 44,838.77 2,237.00 - 57,763.00 3.73% 000-497110 Collection Agency-Bad Debt - 8,664.46 - 27,016.53 (27,016.53) 0.00% TOTAL Miscellaneous 125,750.00 395,890.43 120,543.12 82,086.38 - 43,663.62 65.28% TOTAL REVENUES 9,345,315.19 2,470,262.89 6,256,481.06 7,310,951.42 - 2,034,363.77 78.23% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 21,014.69$ Cash in Investments EMS-Logic 505,599.74 SR 2017 Ambulance-Logic 58,080.73 Total Cash in Bank & Investments 584,695.16$ SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Permits 3,000.00 900.00 2,820.00 2,760 - 240.00 92.00% Fees 1,208,500.00 307,614.80 878,363.68 902,361 - 306,139.12 74.67% Fund Transfers 1,027,062.00 - - - - 1,027,062.00 0.00% Miscellaneous 26,800.00 7,959.73 186,312.72 51,130 - (24,330.32) 190.78% TOTAL REVENUES 2,265,362.00 316,474.53 1,067,496.40 956,251.20 - 1,309,110.80 42.21% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 400,584.00 79,308.31 246,905.05 242,012.89 - 158,571.11 60.42% Supplies 5,700.00 2,118.60 3,210.39 2,998.96 197.59 2,503.45 56.08% City Support Services 1,000.00 - 6,508.54 3,266.01 - (2,266.01) 326.60% Utility Services 13,200.00 3,970.63 8,822.13 10,062.75 600.00 2,537.25 80.78% Operations Support 1,000.00 - - - - 1,000.00 0.00% Staff Support 10,000.00 3,009.72 4,441.71 5,934.12 222.12 3,843.76 61.56% City Assistance 500.00 63.00 98.00 63.00 - 437.00 12.60% Professional Services 41,500.00 750.00 8,918.00 1,475.00 - 40,025.00 3.55% Fund Charges/Transfers 532,162.00 132,790.50 373,745.53 398,371.50 - 133,790.50 74.86% Maintenance Services 30,000.00 3,543.04 1,089.91 4,334.04 - 25,665.96 14.45% Other costs 200.00 - 100.00 100.00 - 100.00 50.00% Debt Service 121,212.50 - 4,093.63 3,099.64 - 118,112.86 2.56% Rental/Leasing 5,500.00 55.00 - 55.00 - 5,445.00 1.00% Operating Equipment - - 519.99 - - - 0.00% Capital Outlay 74,348.00 - - 74,049.78 - 298.22 99.60% TOTAL DRAINAGE 1,236,906.50 225,608.80 658,452.88 745,822.69 1,019.71 490,064.10 60.38% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% 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: JUNE 30, 2019 PROJECTS City Support Services 8,839.48 - - - - 8,839.48 0.00% Operations Support 1,228.52 - 469.00 566.50 - 662.02 46.11% Professional Services 53,789.00 3,097.50 68,426.58 9,451.50 11,618.50 32,719.00 39.17% Maintenance Services 949,807.00 268,898.75 383,955.25 617,861.39 264,322.18 67,623.43 92.88% TOTAL PROJECTS 1,013,664.00 271,996.25 452,850.83 627,879.39 275,940.68 109,843.93 89.16% TOTAL EXPENDITURES 2,250,570.50 497,605.05 1,111,303.71 1,373,702.08 276,960.39 599,908.03 73.34% ** REVENUE OVER(UNDER) EXPEND 14,791.50 (181,130.52) (43,807.31) (417,450.88) (276,960.39) 709,202.77 204-DRAINAGE CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000-432400 Floodplain Permit 3,000.00 900.00 2,820.00 2,760.00 - 240.00 92.00% TOTAL Permits 3,000.00 900.00 2,820.00 2,760.00 - 240.00 92.00% Fees 000-457500 Drainage Penalties 10,000.00 (34.17) 8,682.25 32.02 - 9,967.98 0.32% 000-457600 Drainage Fee 1,198,500.00 307,648.97 869,681.43 902,328.86 - 296,171.14 75.29% TOTAL Fees 1,208,500.00 307,614.80 878,363.68 902,360.88 - 306,139.12 74.67% Fund Transfers 000-481000 Transfer In 1,027,062.00 - - - - 1,027,062.00 0.00% TOTAL Funds Transfers 1,027,062.00 - - - - 1,027,062.00 0.00% Miscellaneous 000-491000 Interest Earned 1,800.00 356.74 1,230.02 2,876.01 - (1,076.01) 159.78% 000-491200 Investment Interest 25,000.00 7,593.75 20,831.27 24,113.12 - 886.88 96.45% 000-497000 Misc Income-Drainage - 9.24 164,251.43 24,141.19 - (24,141.19) 0.00% TOTAL Miscellaneous 26,800.00 7,959.73 186,312.72 51,130.32 - (24,330.32) 190.78% TOTAL REVENUES 2,265,362.00 316,474.53 1,067,496.40 956,251.20 - 1,309,110.80 42.21% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30,2019 Cash in Bank Claim on Operating Cash Pool-Checking 85,013.26$ Cash in Investments Lone Star Investment-Drainage Maint Fund 1,031,075.89 Total Cash in Bank & Investments 1,116,089.15$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 500,000.00 152,783.80 364,536.59 362,222.28 - 137,777.72 72.44% Miscellaneous 28,000.00 12,519.04 19,176.60 35,824.57 - (7,824.57) 127.94% TOTAL REVENUES 528,000.00 165,302.84 383,713.19 398,046.85 - 129,953.15 75.39% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 110,650.00 8,956.00 66,916.30 66,128.54 - 44,521.46 59.76% Operations Support 65,500.00 3,472.00 28,889.17 10,430.00 - 55,070.00 15.92% Professional Services 3,000.00 12,198.89 3,000.00 26,483.83 484.60 (23,968.43) 898.95% Fund Charges/Transfers 67,582.00 16,895.49 49,803.75 50,686.51 - 16,895.49 75.00% Maintenance Services 10,000.00 - - - - 10,000.00 0.00% Capital Outlay - - 8,255.00 - - - 0.00% TOTAL NONDEPARTMENTAL 256,732.00 41,522.38 156,864.22 153,728.88 484.60 102,518.52 60.07% TOTAL EXPENDITURES 256,732.00 41,522.38 156,864.22 153,728.88 484.60 102,518.52 60.07% REVENUE OVER(UNDER) EXPENDITURE 271,268.00 123,780.46 226,848.97 244,317.97 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 52,414.80$ Cash in Investments Texas Class - Hotel Tax 2,005,301.60 Total Cash in Bank & Investments 2,057,716.40$ HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2018-19 44,431 43,858 40,307 38,034 41,886 55,316 44,285 43,642 36,501 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 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 70,000.00 1,000.00 139,000.00 11,000 - 59,000.00 15.71% Fund Transfers 76,512.00 - - - - 76,512.00 0.00% Miscellaneous 30,000.00 1,839.96 4,729.96 14,898.91 - 15,101.09 49.66% TOTAL REVENUES 176,512.00 2,839.96 143,729.96 25,898.91 - 150,613.09 14.67% EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services 10,000.00 375.00 8,250.00 4,839.51 5,881.49 (721.00) 107.21% Operating Equipment 5,000.00 9,510.60 - 9,510.60 - (4,510.60) 190.21% Capital Outlay 161,512.00 12,231.00 87,495.40 86,841.42 - 74,670.58 53.77% TOTAL PARKLAND DEDICATION 176,512.00 22,116.60 95,745.40 101,191.53 5,881.49 69,438.98 60.66% TOTAL EXPENDITURES 176,512.00 22,116.60 95,745.40 101,191.53 5,881.49 69,438.98 60.66% REVENUE OVER(UNDER) EXPEND - (19,276.64) 47,984.56 (75,292.62) (5,881.49) 81,174.11 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458800 Parkland Dedication 70,000.00 1,000.00 139,000.00 11,000.00 - 59,000.00 15.71% TOTAL Fees 70,000.00 1,000.00 139,000.00 11,000.00 - 59,000.00 15.71% Fund Transfers 000-48100 Transfer In- Reserves 76,512.00 - - - - 76,512.00 0.00% TOTAL Fund Transfers 76,512.00 - - - - 76,512.00 0.00% Miscellaneous 000-491000 Interest Earned 750.00 310.45 574.92 825.65 - (75.65) 110.09% 000-491200 Investment Interest 7,000.00 1,529.51 4,155.04 5,102.76 - 1,897.24 72.90% 000-493700 Donations - 8,557.00 (8,557.00) 0.00% 000-497000 Misc Income - - - 413.50 - (413.50) 0.00% 000-499100 Transfer From Parks Reserve 22,250.00 - - - - 22,250.00 0.00% TOTAL Miscellaneous 30,000.00 1,839.96 4,729.96 14,898.91 - 15,101.09 49.66% TOTAL REVENUES 176,512.00 2,839.96 143,729.96 25,898.91 - 150,613.09 14.67% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 Cash in Bank Current Claim on Operating Cash Pool-Checking 57,347.57 Cash in Investments Texas Class- Park Fund 241,520.26 Total in Investment Pool 241,520.26 Total Cash in Bank & Investments 298,867.83 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 72,500.00 3,457.50 102,680.00 2,183 (6,875.00) 77,192.50 -6.47% Fund Transfers - - - - - - 0.00% Miscellaneous 7,750.00 2,641.92 4,626.24 7,865 - (115.35) 101.49% TOTAL REVENUES 80,250.00 6,099.42 107,306.24 10,047.85 (6,875.00) 77,077.15 3.95% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services-Trees 75,000.00 - 3,243.00 11,500.00 - 63,500.00 15.33% TOTAL TREE MITIGATION 75,000.00 - 3,243.00 11,500.00 - 63,500.00 15.33% TOTAL EXPENDITURES 75,000.00 - 3,243.00 11,500.00 - 63,500.00 15.33% REVENUE OVER(UNDER) EXPEND 5,250.00 6,099.42 104,063.24 (1,452.15) (6,875.00) 13,577.15 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458900 Tree Mitigation 72,500.00 3,457.50 102,680.00 2,182.50 (6,875.00) 77,192.50 -6.47% TOTAL Fees 72,500.00 3,457.50 102,680.00 2,182.50 (6,875.00) 77,192.50 -6.47% Miscellaneous 000-491000 Interest Earned 750.00 201.49 697.25 639.80 - 110.20 85.31% 000-491200 Investment Interest 7,000.00 2,440.43 3,928.99 7,225.55 - (225.55) 103.22% TOTAL Miscellaneous 7,750.00 2,641.92 4,626.24 7,865.35 - (115.35) 101.49% TOTAL REVENUES 80,250.00 6,099.42 107,306.24 10,047.85 (6,875.00) 77,077.15 3.95% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking $44,993.11 Cash in Investments MBIA Investment-Tree Mitigation 385,359.12 Total Cash in Bank & Investments $430,352.23 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 1,100,000.00 256,289.40 1,232,491.40 683,186.40 - 416,813.60 62.11% Fund Transfers 1,375,000.00 - - - - 1,375,000.00 0.00% Miscellaneous 82,000.00 42,190.50 68,070.94 126,286.42 - (44,286.42) 154.01% TOTAL REVENUES 2,557,000.00 298,479.90 1,300,562.34 809,472.82 - 1,747,527.18 31.66% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 256,000.00 500.00 1,000.00 984.00 - 255,016.00 0.38% Fund Charges/Transfers 1,375,000.00 - - 1,375,000.00 - - 100.00% TOTAL NON DEPARTMENTAL 1,631,000.00 500.00 1,000.00 1,375,984.00 - 255,016.00 84.36% TOTAL MISC & PROJECTS - - - - - - 0.00% TOTAL EXPENDITURES 1,631,000.00 500.00 1,000.00 1,375,984.00 - 255,016.00 84.36% REVENUE OVER(UNDER) EXPENDITURES 926,000.00 297,979.90 1,299,562.34 (566,511.18) - 1,492,511.18 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% 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 256,289.40 1,232,491.40 683,186.40 - 416,813.60 62.11% TOTAL Fees 1,100,000.00 256,289.40 1,232,491.40 683,186.40 - 416,813.60 62.11% Fund Transfers 000-481000 Transfer from Reserves 1,375,000.00 - - - - 1,375,000.00 0.00% TOTAL Fund Transfers 1,375,000.00 - - - - 1,375,000.00 - Miscellaneous - 000-491000 Interest Earned 7,000.00 856.17 4,639.32 2,883.66 - 4,116.34 41.20% 000-491200 Investment Income 75,000.00 41,334.33 63,431.62 123,402.76 - (48,402.76) 164.54% TOTAL Miscellaneous 82,000.00 42,190.50 68,070.94 126,286.42 - (44,286.42) 154.01% TOTAL REVENUES 2,557,000.00 298,479.90 1,300,562.34 809,472.82 - 1,747,527.18 31.66% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 77,327.79$ Cash in Investments Lone Star Investment-Capital Recovery Water 5,848,234.81 Total Cash in Bank & Investments 5,925,562.60$ CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 600,000.00 142,606.20 676,192.80 376,493 - 223,507.08 62.75% Fund Transfers - - - - - - 0.00% Miscellaneous 44,000.00 38,402.51 54,514.90 121,296 - (77,295.67) 275.67% TOTAL REVENUES 644,000.00 181,008.71 730,707.70 497,788.59 - 146,211.41 77.30% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 260,500.00 1,241.20 4,268.02 3,927.07 - 256,572.93 1.51% Fund Charges/Transfers - - 487,848.00 - - - 0.00% TOTAL NON DEPARTMENTAL 260,500.00 1,241.20 492,116.02 3,927.07 - 256,572.93 1.51% TOTAL EXPENDITURES 260,500.00 1,241.20 492,116.02 3,927.07 - 256,572.93 1.51% REVENUE OVER(UNDER) EXPENDITURES 383,500.00 179,767.51 238,591.68 493,861.52 - (110,361.52) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% 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 153,406.20 658,192.80 387,292.92 - 212,707.08 64.55% 000-455913 Cap Recovery-North Sewer Tr - (10,800.00) 18,000.00 (10,800.00) - 10,800.00 0.00% TOTAL Fees 600,000.00 142,606.20 676,192.80 376,492.92 - 223,507.08 62.75% Fund Transfers 000-481000 Transfer from Reserves - - - - - - 0.00% TOTAL Fund Transfers - - - - - - 0.00% Miscellaneous 000-491000 Interest Earned 4,000.00 699.95 3,535.50 2,804.71 - 1,195.29 70.12% 000-491200 Investment Income 40,000.00 33,599.43 72,247.63 101,613.43 - (61,613.43) 254.03% 000-491800 Gain/Loss - 164.06 (11,134.94) (8,566.94) - 8,566.94 0.00% 000-491900 Unrealized Gain/Loss-Cap One - 3,939.07 (10,133.29) 25,444.47 - (25,444.47) 0.00% TOTAL Miscellaneous 44,000.00 38,402.51 54,514.90 121,295.67 - (77,295.67) 275.67% TOTAL REVENUES 644,000.00 181,008.71 730,707.70 497,788.59 - 146,211.41 77.30% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 54,055.03$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 4,664,933.00 Capital One-Investment 1,793,285.76 Total Cash in Bank & Investments 6,512,273.79$ CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019 505-TAX I&S CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 6,384,000.00 113,796.33 6,082,876.52 6,362,910.44 - 21,089.56 99.67% Fund Transfers 113,723.00 - - - - 113,723.00 0.00% Miscellaneous 156,000.00 12,889.28 418,263.87 155,417.21 - 582.79 99.63% TOTAL REVENUES 6,653,723.00 126,685.61 6,501,140.39 6,518,327.65 - 135,395.35 97.97% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 - 2,150.00 46,880.27 1,800.00 (43,680.27) 973.61% Debt Service 6,648,723.27 - 5,815,642.93 5,452,396.99 884,413.14 311,913.14 95.31% TOTAL GENERAL GOVERNMENT 6,653,723.27 - 5,817,792.93 5,499,277.26 886,213.14 268,232.87 95.97% - TOTAL EXPENDITURES 6,653,723.27 - 5,817,792.93 5,499,277.26 886,213.14 268,232.87 95.97% ** REVENUE OVER(UNDER) EXPEND (0.27) 126,685.61 683,347.46 1,019,050.39 (886,213.14) (132,837.52) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 505-TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y-T-D BUDGET 75% 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 113,796.33 6,082,876.52 6,362,910.44 - 21,089.56 99.67% TOTAL Taxes 6,384,000.00 113,796.33 6,082,876.52 6,362,910.44 - 21,089.56 99.67% 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 473.18 4,291.72 6,672.61 - (672.61) 111.21% 000-491200 Investment Earnings 50,000.00 12,416.10 28,203.15 29,303.03 - 20,696.97 58.61% 000-495015 Contribution from SED - - 360,769.00 - - - 0.00% 000-495020 Contribution from YMCA 100,000.00 - 25,000.00 100,000.00 - - 100.00% 000-498000 Proceeds From Refunding Debt - - - 19,441.57 - (19,441.57) 0.00% TOTAL Miscellaneous 156,000.00 12,889.28 418,263.87 155,417.21 - 582.79 99.63% TOTAL REVENUES 6,653,723.00 126,685.61 6,501,140.39 6,518,327.65 - 135,395.35 97.97% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF NON DEPARTMENTAL BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101-541500 Paying Agent 5,000.00 - 2,150.00 2,350.00 1,800.00 850.00 83.00% 101-541502 Cost of Bond Issuance - - - 44,530.27 - (44,530.27) 0.00% TOTAL Professional Services 5,000.00 - 2,150.00 46,880.27 1,800.00 (43,680.27) 0.83 Debt Service 101-555612 Bond-GO Refunding 2010-Principal 300,000.00 - 285,000.00 300,000.00 - - 100.00% 101-555612.1 Bond-GO Refunding 2010 Interest 29,700.00 - 21,375.00 4,500.00 - 25,200.00 15.15% 101-555629 GO Bond 2007-Principal 300,000.00 - 290,000.00 300,000.00 - - 100.00% 101-555629.1 GO Bond 2007-Interest 124,338.50 - 71,123.25 65,221.75 - 59,116.75 52.45% 101-555630 GO Bond SR2008 Principal - - 475,000.00 - - - 0.00% 101-555630.1 GO Bond SR2008 Interest - - 210,487.60 - - - 0.00% 101-555631 GO Bond SR2009 Principal 210,000.00 - 550,000.00 93,575.00 - 116,425.00 44.56% 101-555631.1 BO Bond SR2009 Interest 236,525.00 - 129,037.50 120,100.00 - 116,425.00 50.78% 101-555633 GO SR2011 Principal 250,000.00 - 240,000.00 250,000.00 - - 100.00% 101-555633.1 GO SR2011 Interest 318,462.50 - 165,618.75 161,418.75 157,043.75 - 100.00% 101-555634 GO SR2011A Refund Principal 485,000.00 - 635,000.00 485,000.00 - - 100.00% 101-555634.1 GO SR2011A Refund Interest 74,734.75 - 47,590.25 40,192.50 - 34,542.25 53.78% 101-555635 GO SR2012 Principal 345,000.00 - 335,000.00 345,000.00 - - 100.00% 101-555635.1 GO SR2012 Interest 157,945.00 - 87,397.50 80,697.50 77,247.50 - 100.00% 101-555636 Tax Note - SR2013 - Principal - - 170,000.00 - - - 0.00% 101-555636.1 Tax Note - SR2013 - Interest - - 1,445.00 - - - 0.00% 101-555637 Tax Note - SR 2013A - Principal - - 165,000.00 - - - 0.00% 101-555637.1 Tax Note - SR2013 - Interest - - 1,072.49 - - - 0.00% 101-555638 Bond-GO 2014 Refund-Principal 100,000.00 - 100,000.00 100,000.00 - - 100.00% 101-555638.1 Bond-GO 2014 Refund-Interest 286,775.00 - 145,637.50 144,137.50 142,637.50 - 100.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,263.02 960.45 - 964.55 49.89% 101-555640 Bond-Ref 2015 Bond- Principal 150,000.00 - 490,000.00 660,000.00 - (510,000.00) 440.00% 101-555640.1 Bond-GO Ref 2015- Interest 9,317.00 - 48,812.50 43,912.50 37,312.50 (71,908.00) 871.79% 101-555641 Tax Note - SR2015A - Principal 660,000.00 - - - - 660,000.00 0.00% 101-555641.1 Tax Note - SR2015A - Interest 81,225.00 - 5,731.58 4,608.88 - 76,616.12 5.67% 101-555642 GO Bond SR2016 Principal 215,000.00 - 205,000.00 215,000.00 - - 100.00% 101-555642.1 GO Bond SR2016 Interest 159,206.26 - 85,853.13 81,753.13 77,453.13 - 100.00% 101-555643 CO Bond Tax SR2016 Principal 175,000.00 - 55,000.00 55,000.00 - 120,000.00 31.43% 101-555643.1 CO Bond Tax SR2016 Interest 62,668.76 - 24,031.25 23,206.25 22,381.25 17,081.26 72.74% 101-555644 CO Bond nonTax SR2016 Principal 55,000.00 - 165,000.00 175,000.00 - (120,000.00) 318.18% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% 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: JUNE 30, 2019 101-555644 CO Bond nonTax SR2016 Interest 45,587.50 - 36,384.38 33,084.38 29,584.38 (17,081.26) 137.47% 101-555645 CO Bond SR2017 Principal 280,000.00 - 245,000.00 280,000.00 - - 100.00% 101-555645.1 CO Bond SR2017 Interest 139,025.00 - 107,075.56 71,612.50 67,412.50 - 100.00% 101-555646 Bond-GO SR2017 Principal 150,000.00 - 135,000.00 150,000.00 - - 100.00% 101-55646.1 Bond - GO SR2017 Interest 114,225.00 - 85,706.67 58,237.50 55,987.50 - 100.00% 101-555647 Bond-GO 2018 Refund Principal 550,000.00 - 550,000.00 - 100.00% 101-555647.1 Bond - GO 2018 Refund Interest 122,112.00 - - 63,971.00 - 58,141.00 52.39% 101-555648 Bond-CO SR2018 - Principal - - 210,000.00 (210,000.00) 0.00% 101-555648.1 Bond-CO 2018 - Interest - - 118,569.80 96,381.25 (214,951.05) 0.00% 101-555649 Bond-GO 2018 Ref - Principal - - 95,000.00 (95,000.00) 0.00% 101-555649.1 Bond-GO 2018 Ref - Interest - - 72,637.60 120,971.88 (193,609.48) 0.00% 101-555900 Debt Service 424,951.00 - - - - 424,951.00 0.00% TOTAL Debt Service 6,648,723.27 - 5,815,642.93 5,452,396.99 884,413.14 311,913.14 95.31% TOTAL EXPENDITURES 6,653,723.27 - 5,817,792.93 5,499,277.26 886,213.14 268,232.87 95.97% Cash in Bank Claim on Operating Cash Pool-Checking 25,643.71$ MBIA Investment- Tax I&S 2,093,265.10 Total Cash in Bank & Investments 2,118,908.81$ TAX I&S CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 4,242,580.00 1,306,037.63 3,153,311.12 3,277,614.12 - 964,965.88 77.26% Fund Transfers 1,249,164.00 - - - - 1,249,164.00 0.00% Miscellaneous 258,000.00 121,846.36 182,940.21 541,392.08 - (283,392.08) 209.84% TOTAL REVENUES 5,749,744.00 1,427,883.99 3,336,251.33 3,819,006.20 - 1,930,737.80 66.42% EXPENDITURE SUMMARY NONDEPARTMENTAL City Assistance 4,800,000.00 - - - - 4,800,000.00 0.00% TOTAL NONDEPARTMENTAL 4,800,000.00 - - - - 4,800,000.00 0.00% ECONOMIC DEVELOPMENT Personnel Services - - - - - - 0.00% Supplies 750.00 224.90 356.14 251.76 77.87 420.37 10.38% City Support Services 21,300.00 598.63 4,589.09 5,057.25 431.25 15,811.50 8.10% Utility Services 3,720.00 534.08 1,726.75 1,293.25 - 2,426.75 1571.57% Operations Support 122,500.00 23,923.93 56,211.62 58,462.53 2,421.91 61,615.56 10.87% Staff Support 21,400.00 3,588.66 9,993.75 10,890.98 39.00 10,470.02 0.95% City Assistance 252,500.00 21.65 425,098.32 164.88 - 252,335.12 6.11% Professional Services 66,300.00 13,534.50 15,260.13 15,415.67 - 50,884.33 690.16% Fund Charges/Transfers 457,574.00 228,787.00 802,945.00 457,574.00 - - 233.39% Maintenance Services 1,000.00 - 385.00 80.00 - 920.00 8.00% Operating Equipment 2,700.00 375.77 576.02 375.77 - 2,324.23 13.92% TOTAL ECONO DEVELOPMENT 949,744.00 271,589.12 1,317,141.82 549,566.09 2,970.03 397,207.88 58.18% TOTAL EXPENDITURES 5,749,744.00 271,589.12 1,317,141.82 549,566.09 2,970.03 5,197,207.88 9.61% ** REVENUE OVER(UNDER) EXPEND - 1,156,294.87 2,019,109.51 3,269,440.11 (2,970.03) (3,266,470.08) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 173,959.81$ Cash in Investments Texas Class Investment-Economic Development Corp 17,958,902.24 Schertz Bank & Trust-Certificate of Deposit 1,033,016.49 Schertz Bank & Trust-Certificate of Deposit 1,086,668.65 Total Cash in Bank & Investments 20,252,547.19$ SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2019