Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
02-Second Quarter Financial Report
CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2018 - 2019 ********************************* CURRENT CURRENT Y-T-D BUDGET 50% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET General Fund, 101 Total Revenues 34,156,549 22,457,556.64 0.00 11,698,991.93 65.75% Total General Government 6,766,932 2,448,034.11 512,740.64 3,806,156.90 43.75% Total Public Safety 14,526,571 7,065,668.10 672,917.16 6,787,986.04 53.27% Total Public Environment 1,641,982 666,400.62 64,621.92 910,959.46 44.52% Total Parks & Recreation 2,675,790 804,763.03 330,554.35 1,540,472.62 42.43% Total Cultural 967,904 483,809.27 16,717.55 467,377.18 51.71% Total Health 500,269 226,384.25 10,138.00 263,746.75 47.28% Total Internal Services 6,678,237 2,595,527.77 339,291.54 3,743,417.69 43.95% Total Misc & Projects 377,666 144,165.45 118,113.53 115,387.02 69.45% Total Expenditures 34,135,351 14,434,752.60 2,065,094.69 17,635,503.66 48.34% Revenue Over(Under) Expenditures 21,197.62 8,022,804.04 General Fund, 101 Total Cash in Bank & Investments 20,744,509.67 Special Events Fund, 106 Total Revenues 156,760 48,354.42 0.00 108,405.58 30.85% Total Expenditures 177,708 54,645.35 8,945.92 114,116.73 35.78% Revenue Over(Under) Expenditures (20,948)(6,290.93) Special Events Fund, 106 Total Cash in Bank & Investments 85,989.25 Peg Fund, 110 Total Revenues 195,000 42,900.83 0.00 152,099.17 22.00% Total Expenditures 195,000 0.00 0.00 195,000.00 0.00% Revenue Over(Under) Expenditures 0 42,900.83 Peg Fund, 110 Total Cash in Bank & Investments 744,822.68 Water & Sewer, 202 Total Revenues 25,735,522 11,405,794.52 0.00 14,329,726.98 44.32% Total Expenditures 24,980,024 10,929,391.44 383,716.67 13,666,915.64 45.29% Revenue Over(Under) Expenditures 755,498 476,403.08 Water & Sewer, 202 Total Cash in Bank & Investments 9,347,677.63 Quarterly Statement Schertz, Texas AS OF :MARCH 31, 2019 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ********************************* 2017 - 2018 ******************************** CURRENT CURRENT Y-T-D BUDGET 50% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET EMS, 203 Total Revenues 9,345,315 5,212,957.49 0.00 4,132,357.70 55.78% Total Expenditures 9,235,636 4,867,899.36 181,424.15 4,186,312.72 54.67% Revenue Over(Under) Expenditures 109,679 345,058.13 EMS, 203 Total Cash in Bank & Investments 314,107.82 Drainage, 204 Total Revenues 1,806,431 639,776.67 0.00 1,166,654.33 35.42% Total Expenditures 1,791,640 802,047.25 234,796.02 754,796.23 57.87% Revenue Over(Under) Expenditures 14,792 (162,270.58) Drainage, 204 Total Cash in Bank & Investments 1,372,660.72 Hotel Tax, 314 Total Revenues 528,000 232,744.01 0.00 295,255.99 44.08% Total Expenditures 256,732 112,206.50 0.00 144,525.50 43.71% Revenue Over(Under) Expenditures 271,268 120,537.51 Hotel Tax, 314 Total Cash in Bank & Investments 1,933,935.94 Park, 317 Total Revenues 176,512 22,502.45 0.00 154,009.55 12.75% Total Expenditures 176,512 79,074.93 15,567.29 81,869.78 53.62% Revenue Over(Under) Expenditures 0 (56,572.48) Park, 317 Total Cash in Bank & Investments 317,587.97 Tree Mitigation, 319 Total Revenues 80,250 3,948.43 (1,075.00)77,376.57 3.58% Total Expenditures 75,000 11,500.00 0.00 63,500.00 15.33% Revenue Over(Under) Expenditures 5,250 (7,551.57) Tree Mitigation, 319 Total Cash in Bank & Investments 424,252.81 Capital Recovery Water, 411 Total Revenues 2,557,000 510,992.92 0.00 2,046,007.08 19.98% Total Expenditures 1,631,000 484.00 0.00 1,630,516.00 0.03% Revenue Over(Under) Expenditures 926,000 510,508.92 Capital Recovery Water, 411 Total Cash in Bank & Investments 7,002,582.70 Quarterly Statement Schertz, Texas AS OF :MARCH 31, 2019 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ********************************* 2018 - 2019 ******************************** CURRENT CURRENT Y-T-D BUDGET 50% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Capital Recovery Sewer, 421 Total Revenues 644,000 316,779.88 0.00 327,220.12 49.19% Total Expenditures 260,500 2,685.87 0.00 257,814.13 1.03% Revenue Over(Under) Expenditures 383,500 314,094.01 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 6,332,506.28 I&S, 505 Total Revenues 6,653,723 6,372,200.47 0.00 281,522.53 95.77% Total Expenditures 6,653,723 5,454,746.99 0.00 1,198,976.28 81.98% Revenue Over(Under) Expenditures 0 917,453.48 I&S, 505 Total Cash in Bank & Investments 2,017,311.90 SED Corporation, 620 Total Revenues 5,749,744 2,420,021.44 0.00 3,329,722.56 42.09% Total Expenditures 5,749,744 277,976.97 3,235.87 5,468,531.16 4.89% Revenue Over(Under) Expenditures 0 2,142,044.47 SED Corporation, 620 Total Cash in Bank & Investments 19,247,640.96 Total Cash in Bank & Investments 69,885,586.33 69,885,586.33 Quarterly Statement Schertz, Texas AS OF :MARCH 31, 2019 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 21,519,002.00 9,066,435.85 15,728,865.45 17,277,673.13 - 4,241,328.87 80.29% Franchises 2,373,686.57 515,950.82 1,062,676.12 1,052,836.33 - 1,320,850.24 44.35% Permits 1,604,320.00 287,403.35 1,118,226.24 695,211.89 - 909,108.11 43.33% Licenses 56,760.00 20,992.00 31,000.00 32,942.00 - 23,818.00 58.04% Fees 1,843,973.00 577,120.01 1,210,955.51 1,153,331.79 - 690,641.21 62.55% Fines 22,000.00 4,709.68 11,964.08 7,403.89 - 14,596.11 33.65% Inter-Jurisdictional 967,008.00 400,906.83 399,434.46 466,853.80 - 500,154.20 48.28% Fund Transfers 5,063,249.00 568,527.18 1,539,829.20 1,365,841.26 - 3,697,407.74 26.98% Miscellaneous 706,550.00 243,296.46 515,360.65 405,462.55 - 301,087.45 57.39% TOTAL REVENUES 34,156,548.57 11,685,342.18 21,618,311.71 22,457,556.64 - 11,698,991.93 65.75% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 35,009.00 8,321.36 17,574.26 17,954.74 14.40 17,039.86 51.33% Supplies 1,000.00 167.75 62.91 266.67 72.15 661.18 33.88% City Support Services 27,500.00 11,818.24 17,256.97 17,904.17 233.85 9,361.98 65.96% Utility Services - - 267.48 - - - 0.00% Operations Support 300.00 - 29.00 178.40 116.00 5.60 98.13% Staff Support 32,150.00 4,894.06 21,926.49 16,759.63 306.36 15,084.01 53.08% Professional Services 8,000.00 1,950.00 - 1,950.00 - 6,050.00 24.38% TOTAL CITY COUNCIL 103,959.00 27,151.41 57,117.11 55,013.61 742.76 48,202.63 53.63% CITY MANAGER Personnel Services 1,123,847.00 242,506.76 765,122.93 501,732.82 12,036.99 610,077.19 45.72% Supplies 2,000.00 571.72 440.50 791.44 110.17 1,098.39 45.08% City Support Services 6,000.00 - 8,154.32 - - 6,000.00 0.00% Utility Services 2,000.00 104.02 575.28 414.39 - 1,585.61 20.72% Operations Support 50.00 - - - - 50.00 0.00% Staff Support 26,625.00 2,211.96 7,772.60 4,645.60 1,045.33 20,934.07 21.37% Operating Equipment 1,000.00 - - 314.39 - 685.61 31.44% TOTAL CITY MANAGER 1,161,522.00 245,394.46 782,065.63 507,898.64 13,192.49 640,430.87 44.86% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 MUNICIPAL COURT Personnel Services 254,795.00 66,966.23 152,679.33 150,606.92 7,741.44 96,446.64 62.15% Supplies 2,000.00 467.13 657.35 818.88 - 1,181.12 40.94% City Support Services 975.00 - 157.86 326.17 - 648.83 33.45% Operations Support 3,000.00 - 69.00 31.00 - 2,969.00 1.03% Staff Support 8,510.00 1,710.10 2,053.31 2,622.00 106.72 5,781.28 32.06% Court Support 700.00 150.00 96.00 318.00 - 382.00 45.43% Professional Services 73,960.00 13,500.00 28,306.71 25,472.56 19,850.00 28,637.44 61.28% Maintenance Services 3,000.00 450.00 1,000.00 900.00 1,900.00 200.00 93.33% TOTAL MUNICIPAL COURT 346,940.00 83,243.46 185,019.56 181,095.53 29,598.16 136,246.31 60.73% CUSTOMER RELATIONS-311 Personnel Services 120,977.00 26,492.77 61,026.02 62,776.27 1,171.34 57,029.39 52.86% Supplies 150.00 33.58 68.93 36.42 - 113.58 24.28% Staff Support 830.00 - - - 830.00 0.00% Operating Equipment - - 554.62 - - - 0.00% TOTAL CUSTOMER RELATIONS-311 121,957.00 26,526.35 61,649.57 62,812.69 1,171.34 57,972.97 52.46% PLANNING & ZONING Personnel Services 210,124.00 45,121.78 104,142.97 98,546.58 2,113.88 109,463.54 47.91% Supplies 2,862.65 - 199.06 108.35 49.08 2,705.22 5.50% Operations Support 174.00 7.00 7.20 7.00 - 167.00 4.02% Staff Support 26,755.00 2,532.00 3,827.92 3,799.82 - 22,955.18 14.20% Professional Services 100.00 4.00 - 9.00 - 91.00 9.00% Operating Equipment 250.00 - - - - 250.00 0.00% TOTAL PLANNING & ZONING 240,265.65 47,664.78 108,177.15 102,470.75 2,162.96 135,631.94 43.55% LEGAL SERVICES Operations Support 10,000.00 1,055.80 687.29 1,397.55 118.50 8,483.95 15.16% Professional Services 150,000.00 28,741.52 46,802.11 50,655.35 - 99,344.65 33.77% TOTAL LEGAL SERVICES 160,000.00 29,797.32 47,489.40 52,052.90 118.50 107,828.60 32.61% CITY SECRETARY Personnel Services 186,399.00 51,403.46 94,244.05 105,292.40 3,053.00 78,053.60 58.13% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 Supplies 1,150.00 730.09 616.86 981.56 14.40 154.04 86.61% City Support Services 15,000.00 136.79 2,059.17 831.43 - 14,168.57 5.54% Operations Support 100.00 - 47.00 27.95 - 72.05 27.95% Staff Support 4,400.00 1,547.57 2,156.98 2,885.02 - 1,514.98 65.57% TOTAL CITY SECRETARY 207,049.00 53,817.91 99,124.06 110,018.36 3,067.40 93,963.24 54.62% NON-DEPARTMENTAL City Support Services 696,652.00 89,658.35 284,453.40 320,406.28 109,838.54 266,407.18 61.76% Operations Support 163,500.00 6,552.46 69,996.73 45,169.80 4,682.52 113,647.68 30.49% Staff Support 250.00 - 80.00 - - 250.00 0.00% City Assistance 1,879,730.00 145,384.31 720,318.28 290,768.62 290,768.60 1,298,192.78 30.94% Professional Services 51,235.00 9,678.95 31,719.05 21,775.25 - 29,459.75 42.50% Fund Chrgs/Transfrs-Spec Events Fnd 67,250.00 - - - - 67,250.00 0.00% TOTAL NON-DEPARTMENTAL 2,858,617.00 251,274.07 1,106,567.46 678,119.95 405,289.66 1,775,207.39 37.90% PUBLIC AFFAIRS Personnel Services 288,461.00 83,977.14 145,094.37 151,139.77 4,285.47 133,035.76 53.88% Supplies 1,050.00 305.35 819.34 386.49 31.99 631.52 39.86% City Support Services 4,000.00 - - 610.14 - 3,389.86 15.25% Operations Support 43,500.00 6,231.73 6,807.49 6,590.43 1,760.85 35,148.72 19.20% Staff Support 10,100.00 1,948.42 670.74 2,209.42 1,318.41 6,572.17 34.93% Professional Services 304,980.00 58,606.08 - 131,669.56 33,102.74 140,207.70 54.03% TOTAL PUBLIC AFFAIRS 652,091.00 151,068.72 153,391.94 292,605.81 40,499.46 318,985.73 51.08% RECORDS MANAGEMENT Personnel Services - (14,245.54) 22,500.59 - - 0.00% Supplies - - 4,403.22 - - - 0.00% TOTAL RECORDS MANAGEMENT - (14,245.54) 26,903.81 - - - 0.00% SCHERTZ MAGAZINE Personnel Services - (5,510.31) 63,669.39 - - 0.00% Opperations Support - - 953.92 - - - 0.00% Staff Support - - 1,390.19 - - - 0.00% Professional Services - - 132,936.93 (350.00) - 350.00 0.00% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 TOTAL SCHERTZ MAGAZINE - (5,510.31) 198,950.43 (350.00) - 350.00 0.00% ENGINEERING Personnel Services 614,373.00 143,770.30 309,267.19 313,744.52 12,182.74 288,445.74 53.05% Supplies 2,720.00 38.99 246.36 120.30 - 2,599.70 4.42% City Support Services 900.00 - - - - 900.00 0.00% Utility Services 4,118.00 1,136.63 988.09 1,936.60 196.57 1,984.83 51.80% Operations Support 100.00 - 47.70 - - 100.00 0.00% Staff Support 12,658.00 1,284.92 1,415.68 1,427.86 130.00 11,100.14 12.31% Professional Services 71,000.00 598.10 2,652.50 793.52 - 70,206.48 1.12% 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 146,828.94 314,617.52 318,022.80 12,509.31 408,687.89 44.71% GIS Personnel Services 166,886.00 37,006.16 84,482.66 84,054.69 2,200.84 80,630.47 51.69% Supplies 1,740.00 - 208.47 - 1,145.86 594.14 65.85% Staff Support 4,600.00 3,176.48 946.92 3,176.48 - 1,423.52 69.05% Rental/Leasing 2,085.00 347.30 1,041.90 1,041.90 1,041.90 1.20 99.94% TOTAL GIS 175,311.00 40,529.94 86,679.95 88,273.07 4,388.60 82,649.33 52.86% TOTAL GENERAL GOVERNMENT 6,766,931.65 1,083,541.51 3,227,753.59 2,448,034.11 512,740.64 3,806,156.90 43.75% PUBLIC SAFETY POLICE Personnel Services 7,246,007.00 1,552,776.80 3,140,798.94 3,429,136.50 110,221.02 3,706,649.48 48.85% Supplies 59,348.32 3,577.89 30,949.74 31,792.86 6,391.65 21,163.81 64.34% City Support Services 26,000.00 1,000.00 24,229.52 25,229.31 - 770.69 97.04% Utility Services 127,278.50 18,092.42 31,283.81 33,946.10 - 93,332.40 26.67% Operations Support 12,121.00 1,110.00 814.25 1,799.00 1,530.00 8,792.00 27.46% Staff Support 148,368.53 31,405.61 43,494.61 55,552.89 13,178.39 79,637.25 46.32% City Assistance 18,200.00 3,754.14 4,421.62 4,273.29 2,723.01 11,203.70 38.44% Professional Services 70,443.00 18,683.48 25,272.41 43,247.84 884.50 26,310.66 62.65% Maintenance Services 62,645.00 - 24,293.49 12,745.00 11,100.00 38,800.00 38.06% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 Operating Equipment 86,074.65 148,483.16 21,455.67 185,738.62 18,438.62 (118,102.59) 237.21% Capital Outlay 499,322.30 271,578.63 262,196.48 271,578.63 102,411.00 125,332.67 74.90% TOTAL POLICE 8,355,808.30 2,050,462.13 3,609,210.54 4,095,040.04 266,878.19 3,993,890.07 52.20% FIRE RESCUE Personnel Services 4,552,388.00 1,072,913.20 2,027,926.35 2,372,463.36 67,062.88 2,112,861.76 53.59% Supplies 20,554.00 1,807.70 3,750.76 4,613.43 5,905.96 10,034.61 51.18% Utility Services 64,600.00 13,548.93 16,628.08 22,749.94 - 41,850.06 35.22% Operations Support 550.00 138.00 58.00 236.09 - 313.91 42.93% Staff Support 181,052.00 54,276.04 82,643.99 72,595.66 23,144.14 85,312.20 52.88% City Assistance 23,000.00 300.00 3,592.92 5,238.94 - 17,761.06 22.78% Professional Services 33,500.00 - 4,900.00 5,660.00 21,620.00 6,220.00 81.43% Maintenance Services 74,496.00 4,412.86 9,927.83 12,081.76 3,773.68 58,640.56 21.28% Other Costs - - 102.05 1,594.08 - (1,594.08) 0.00% Rental/Leasing 33,900.00 3,950.82 24,153.21 7,901.64 7,901.64 18,096.72 46.62% Operating Equipment 117,644.00 22,979.40 16,850.23 36,429.23 21,092.13 60,122.64 48.89% Capital Outlay 179,000.00 - 34,880.40 - 172,408.89 6,591.11 96.32% TOTAL FIRE RESCUE 5,280,684.00 1,174,326.95 2,225,413.82 2,541,564.13 322,909.32 2,416,210.55 54.24% INSPECTIONS Personnel Services 729,754.00 180,238.35 312,957.23 375,088.84 14,809.65 339,855.51 53.43% Supplies 4,115.00 152.65 639.78 1,323.65 433.29 2,358.06 42.70% Utility Services 5,000.00 1,255.36 1,779.71 2,272.12 - 2,727.88 45.44% Operations Support 2,219.00 628.00 523.00 822.60 - 1,396.40 37.07% Staff Support 29,961.00 5,008.01 4,266.06 7,731.74 2,281.44 19,947.82 33.42% Professional Services 70,000.00 18,895.00 64,190.00 41,295.00 13,705.00 15,000.00 78.57% Operating Equipment 530.00 - 4,014.09 529.98 - 0.02 100.00% Capital Outlay 54,000.00 - - - 51,832.24 2,167.76 95.99% TOTAL INSPECTIONS 895,579.00 206,177.37 388,369.87 429,063.93 83,061.62 383,453.45 57.18% MARSHAL'S OFFICE Personnel Services - (21,173.53) 176,741.85 - - - 0.00% Supplies - - 2,628.66 - 68.03 (68.03) 0.00% Utility Services - - 2,343.97 - - - 0.00% Staff Support - (479.00) 1,599.51 - - - 0.00% Maintenance Services - - 1,000.00 - - - 0.00% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 Operating Equipment - - 2,542.52 - - - 0.00% TOTAL MARSHAL'S OFFICE - (21,652.53) 186,856.51 - 68.03 (68.03) 0.00% TOTAL PUBLIC SAFETY 14,532,071.30 3,409,313.92 6,409,850.74 7,065,668.10 672,917.16 6,793,486.04 53.25% PUBLIC ENVIRONMENT STREETS Personnel Services 800,297.00 147,182.21 404,111.35 378,511.25 13,242.14 408,543.61 48.95% Supplies 102,450.00 22,996.77 38,390.09 37,607.17 13,024.68 51,818.15 49.42% Utility Services 181,700.00 44,028.39 68,377.14 74,884.44 - 106,815.56 41.21% Staff Support 14,550.00 5,845.53 4,612.23 9,486.73 452.70 4,610.57 68.31% Professional Services 15,000.00 1,315.00 7,937.00 6,345.00 - 8,655.00 42.30% Maintenance Services 285,500.00 646.36 - 646.36 - 284,853.64 0.23% Rental/Lease 4,000.00 1,050.00 2,895.32 1,050.00 900.00 2,050.00 48.75% Operating Equipment 9,800.00 1,471.93 4,209.74 1,471.93 1,002.40 7,325.67 25.25% Capital Outlay 228,685.00 - 33,260.38 156,397.74 36,000.00 36,287.26 84.13% TOTAL STREETS 1,641,982.00 224,536.19 563,793.25 666,400.62 64,621.92 910,959.46 44.52% TOTAL PUBLIC ENVIRONMENT 1,641,982.00 224,536.19 563,793.25 666,400.62 64,621.92 910,959.46 44.52% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 673,965.00 128,348.01 242,188.15 282,147.19 10,034.82 381,782.99 43.35% Supplies 98,400.00 10,714.45 33,484.66 25,009.02 10,009.89 63,381.09 35.59% City Support Services 10,000.00 441.74 2,625.30 4,905.20 3,560.87 1,533.93 84.66% Utility Services 220,500.00 41,193.85 82,006.71 83,358.39 15,543.33 121,598.28 44.85% Operations Support 1,000.00 - 878.97 - 662.51 337.49 66.25% Staff Support 12,665.00 5,574.90 4,492.63 10,300.58 1,168.70 1,195.72 90.56% Professional Services 137,500.00 1,868.44 20,780.00 16,779.08 5,173.44 115,547.48 15.97% Maintenance Services 67,500.00 2,640.59 12,978.31 5,802.99 750.00 60,947.01 9.71% Rental/Leasing 3,500.00 2,455.20 18,759.44 3,225.20 - 274.80 92.15% Operating Equipment 72,350.00 14,450.55 5,639.25 18,175.45 8,583.48 45,591.07 36.99% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 Capital Outlay 312,927.00 59,762.00 14,278.54 59,762.00 239,067.75 14,097.25 95.50% TOTAL PARKS DEPARTMENT 1,610,307.00 267,449.73 438,111.96 509,465.10 294,554.79 806,287.11 49.93% SWIM POOL Supplies 25,500.00 (160.29) 5,756.13 (160.29) - 25,660.29 -0.63% Utility Services 16,500.00 4,626.21 5,313.74 9,266.63 2,844.06 4,389.31 73.40% Maintenance Services 597,878.00 54,604.50 144,747.43 136,511.25 29,276.25 432,090.50 27.73% TOTAL SWIM POOL 639,878.00 59,070.42 155,817.30 145,617.59 32,120.31 462,140.10 27.78% EVENT FACILITIES Personnel Services 299,770.00 53,722.25 30,174.73 113,991.75 3,494.33 182,283.92 39.19% Supplies 6,150.00 523.45 1,883.94 1,364.51 204.10 4,581.39 25.51% Utility Services 51,350.00 9,520.47 15,418.20 15,000.01 - 36,349.99 29.21% Operations Support 11,200.00 2,233.36 3,814.59 4,703.20 - 6,496.80 41.99% Staff Support 5,135.00 454.75 320.54 2,084.71 - 3,050.29 40.60% Maintenance Services 20,000.00 - - - 20,000.00 0.00% Operating Equipment 32,000.00 188.03 5,224.77 12,536.16 180.82 19,283.02 39.74% TOTAL EVENT FACILITIES 425,605.00 66,642.31 56,836.77 149,680.34 3,879.25 272,045.41 36.08% TOTAL PARKS & RECREATION 2,675,790.00 393,162.46 650,766.03 804,763.03 330,554.35 1,540,472.62 42.43% CULTURAL LIBRARY Personnel Services 750,254.00 174,145.74 385,341.56 383,832.10 14,869.55 351,552.35 53.14% Supplies 15,500.00 2,296.04 3,301.50 4,569.21 648.00 10,282.79 33.66% Utility Services 55,500.00 11,673.03 17,258.13 18,807.23 - 36,692.77 33.89% Operations Support 3,650.00 931.98 2,599.95 1,179.95 - 2,470.05 32.33% Staff Support 5,700.00 1,256.56 2,331.46 2,694.02 - 3,005.98 47.26% Professional Services 2,300.00 - 2,318.00 2,364.00 - (64.00) 102.78% Operating Equipment 135,000.00 39,529.39 65,362.17 70,362.76 1,200.00 63,437.24 53.01% TOTAL LIBRARY 967,904.00 229,832.74 478,512.77 483,809.27 16,717.55 467,377.18 51.71% TOTAL CULTURAL 967,904.00 229,832.74 478,512.77 483,809.27 16,717.55 467,377.18 51.71% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 HEALTH ANIMAL SERVICES Personnel Services 327,839.00 70,369.50 145,141.00 152,983.10 6,060.23 168,795.67 48.51% Supplies 37,380.00 8,543.08 15,442.37 19,470.11 1,246.04 16,663.85 55.42% City Support Services 3,500.00 - 675.68 - - 3,500.00 0.00% Utility Services 44,000.00 24,597.33 16,498.73 31,570.96 - 12,429.04 71.75% Operations Support 1,000.00 229.67 256.07 229.67 - 770.33 22.97% Staff Support 13,750.00 2,012.00 2,364.60 3,562.55 701.70 9,485.75 31.01% City Assistance 17,000.00 3,119.71 6,512.27 8,759.61 714.93 7,525.46 55.73% Professional Services 25,800.00 4,824.95 7,531.01 8,729.95 915.00 16,155.05 37.38% Maintenance Services 7,500.00 - 1,775.00 245.27 480.00 6,774.73 9.67% Operating Equipment 22,500.00 - 334.97 833.03 - 21,666.97 3.70% TOTAL ANIMAL SERVICES 500,269.00 113,696.24 196,531.70 226,384.25 10,117.90 263,766.85 47.27% ENVIRONMENTAL HEALTH Personnel Services - (3,480.84) 88,203.06 - - - 0.00% Utility Services - - - - 20.10 (20.10) 0.00% Operations Support - - 76.00 - - - 0.00% Staff Support - - 2,279.26 - - - 0.00% City Assistance - - 94.80 - - - 0.00% Professional Services - - 2,525.00 - - - 0.00% Maintenance Services - - 2,950.00 - - - 0.00% Operating Equipment - - 1,666.74 - - - 0.00% TOTAL ANIMAL SERVICES - (3,480.84) 98,079.81 - 20.10 (20.10) 0.00% TOTAL HEALTH 500,269.00 110,215.40 294,611.51 226,384.25 10,138.00 263,746.75 47.28% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 626,643.00 148,313.65 276,956.60 323,213.40 11,300.34 292,129.26 53.38% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 Supplies 9,140.00 2,379.42 6,110.03 3,139.33 184.20 5,816.47 36.36% City Support Services 920,029.00 157,730.59 293,149.29 336,742.75 43,202.00 540,084.25 41.30% Utility Services 235,768.00 52,499.94 89,560.17 94,785.45 8,932.92 132,049.63 43.99% Staff Support 43,600.00 8,605.01 16,003.19 19,269.39 7,554.01 16,776.60 61.52% Professional Services 477,919.00 3,390.00 - 10,850.00 34,793.00 432,276.00 9.55% Maintenance Services 14,500.00 2,916.15 1,629.52 5,256.22 521.86 8,721.92 39.85% Operating Equipment 429,660.00 36,625.16 136,384.07 160,395.07 1,569.11 267,695.82 37.70% Capital Outlay 33,500.00 - - 5,367.00 25,430.25 2,702.75 91.93% TOTAL INFORMATION TECHNOLOGY 2,790,759.00 412,459.92 819,792.87 959,018.61 133,487.69 1,698,252.70 39.15% HUMAN RESOURCES Personnel Services 424,635.00 90,834.78 204,786.68 196,608.04 5,634.40 222,392.56 47.63% Supplies 700.00 360.90 246.22 377.89 17.49 304.62 56.48% Human Services 74,500.00 10,803.38 26,021.03 19,676.85 16,708.97 38,114.18 48.84% City Support Services - - 204.36 - - - 0.00% Utility Services - - 227.94 - - - 0.00% Operations Support 9,000.00 1,885.16 5,968.55 2,787.16 445.50 5,767.34 35.92% Staff Support 36,500.00 7,882.62 1,335.38 14,587.83 1,056.32 20,855.85 42.86% City Assistance 10,000.00 6,287.00 2,585.00 7,057.00 - 2,943.00 70.57% Professional Services 54,600.00 2,979.00 4,693.50 2,979.00 - 51,621.00 5.46% Operating Equipment 2,000.00 - - - 279.99 1,720.01 14.00% TOTAL HUMAN RESOURCES 611,935.00 121,032.84 246,068.66 244,073.77 24,142.67 343,718.56 43.83% FINANCE Personnel Services 573,362.00 131,396.89 285,351.20 273,942.28 9,366.16 290,053.56 49.41% Supplies 4,575.00 1,245.78 1,879.91 2,102.03 64.98 2,407.99 47.37% City Support Services - - 138.00 - - - 0.00% Operations Support 2,155.00 - - - - 2,155.00 0.00% Staff Support 9,495.00 1,036.00 2,269.26 1,436.00 - 8,059.00 15.12% Professional Sevices 34,500.00 9,532.00 16,005.00 9,532.00 505.00 24,463.00 29.09% Operating Equipment 1,395.00 395.00 - 395.00 855.35 144.65 89.63% TOTAL FINANCE 625,482.00 143,605.67 305,643.37 287,407.31 10,791.49 327,283.20 47.68% PURCHASING & ASSET MGT Personnel Services 210,449.00 47,393.34 108,428.62 106,052.78 2,297.92 102,098.30 51.49% Supplies 1,450.00 1,211.93 119.44 1,233.85 43.10 173.05 88.07% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 Utility Services - - 95.02 - - - 0.00% Operations Support 5,150.00 1,939.00 - 1,939.00 608.00 2,603.00 49.46% Staff Support 6,700.00 1,054.00 2,102.74 1,546.20 47.94 5,105.86 23.79% City Assistance 3,000.00 937.00 172.00 1,229.00 - 1,771.00 40.97% Operating Equipment 350.00 - - - - 350.00 0.00% TOTAL PURCHASING & ASSET MGT 227,099.00 52,535.27 110,917.82 112,000.83 2,996.96 112,101.21 50.64% FLEET SERVICE Personnel Services 354,881.00 57,614.69 158,304.54 128,055.63 3,861.11 222,964.26 37.17% Supplies 167,230.00 55,078.07 62,487.43 88,656.32 12,849.38 65,724.30 60.70% City Support Services 11,000.00 300.00 2,826.44 2,583.69 999.00 7,417.31 32.57% Utility Services 8,000.00 2,282.15 3,426.76 3,447.89 - 4,552.11 43.10% Staff Support 20,982.00 3,296.99 5,629.69 4,596.25 4,644.42 11,741.33 44.04% Maintenance Services 149,750.00 47,249.52 101,971.45 86,626.69 11,472.38 51,650.93 65.51% Operating Equipment 8,200.00 1,680.54 1,296.86 3,462.67 453.82 4,283.51 47.76% Capital Outlay 155,000.00 - - 36,943.00 28,379.75 89,677.25 42.14% TOTAL FLEET SERVICE 875,043.00 167,501.96 335,943.17 354,372.14 62,659.86 458,011.00 47.66% FACILITY SERVICES Personnel Services 691,769.00 143,788.08 375,569.01 326,999.64 15,457.07 349,312.29 49.50% Supplies 146,800.00 28,017.01 57,316.64 49,628.14 7,009.08 90,162.78 38.58% Utility Services 170,500.00 39,464.59 65,998.97 64,017.61 - 106,482.39 37.55% Operation Support - - 10,058.80 - - - 0.00% Staff Support 15,800.00 1,425.04 3,932.57 2,818.78 289.82 12,691.40 19.67% Professional Services 85,550.00 18,736.81 12,191.21 37,486.65 - 48,063.35 43.82% Maintenance Services 373,535.91 77,146.66 95,051.71 146,878.24 56,548.75 170,108.92 54.46% Rental/Leasing 1,000.00 - 3,077.95 400.00 - 600.00 40.00% Operating Equipment 21,000.00 - - - - 21,000.00 0.00% Capital Outlay 36,464.09 10,426.05 - 10,426.05 25,908.15 129.89 99.64% TOTAL BUILDING MAINTENANCE 1,542,419.00 319,004.24 623,196.86 638,655.11 105,212.87 798,551.02 48.23% TOTAL INTERNAL SERVICE 6,672,737.00 1,216,139.90 2,441,562.75 2,595,527.77 339,291.54 3,737,917.69 43.98% MISC & PROJECTS 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 CITY ASSISTANCE City's Assistance to Agencies 317,666.00 87,501.49 129,824.13 141,139.90 108,392.56 68,133.54 78.55% Operating Equipment 15,000.00 2,607.09 - 3,025.55 7,220.97 4,753.48 68.31% TOTAL CITY ASSISTANCE 332,666.00 90,108.58 129,824.13 144,165.45 115,613.53 72,887.02 78.09% 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 90,108.58 129,824.13 144,165.45 118,113.53 115,387.02 69.45% TOTAL EXPENDITURES 34,135,350.95 6,756,850.70 14,196,674.77 14,434,752.60 2,065,094.69 17,635,503.66 48.34% REVENUE OVER(UNDER) EXPEND.21,197.62 4,928,491.48 7,421,636.94 8,022,804.04 (2,065,094.69) (5,936,511.73) 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 13,122,952.00 7,004,816.14 11,614,505.26 13,194,625.90 - (71,673.90) 100.55% 000-411200 Advalorem Tax - Delinquent 50,000.00 5,855.78 22,767.74 25,207.70 - 24,792.30 50.42% 000-411300 Advalorem Tax - P&I 50,000.00 21,834.16 51,101.91 31,423.74 - 18,576.26 62.85% 000-411500 Sales Tax Revenue-Gen Fund 8,252,000.00 2,020,211.90 4,018,571.99 4,000,953.89 - 4,251,046.11 48.48% 000-411600 Bingo Tax 50.00 - 11.25 24.30 - 25.70 48.60% 000-411700 Mixed Beverage Tax 44,000.00 13,717.87 21,907.30 25,437.60 - 18,562.40 57.81% TOTAL Taxes 21,519,002.00 9,066,435.85 15,728,865.45 17,277,673.13 - 4,241,328.87 80.29% Franchises 000-421200 Center Point/Entex Energy 82,988.93 35,480.00 50,514.59 56,570.15 - 26,418.78 68.17% 000-421220 City Public Service 1,022,833.82 222,119.44 413,558.62 443,136.45 - 579,697.37 43.32% 000-421240 Guadalupe Valley Elec Co-op 423,553.61 95,877.75 214,711.14 190,713.14 - 232,840.47 45.03% 000-421250 New Braunfels Utilities 74,472.96 15,582.17 30,825.59 30,262.83 - 44,210.13 40.64% 000-421300 Time Warner-State Franchise 298,637.68 70,567.32 143,037.67 148,058.13 - 150,579.55 49.58% 000-421460 AT&T Franchise Fee 152,418.58 46,840.23 67,721.23 78,936.43 - 73,482.15 51.79% 000-421480 Other Telecom Franchise 162,780.99 2,881.73 68,226.00 39,627.57 - 123,153.42 24.34% 000-421500 Solid Waste Franchise Fee 156,000.00 26,602.18 74,081.28 65,531.63 - 90,468.37 42.01% TOTAL Franchises 2,373,686.57 515,950.82 1,062,676.12 1,052,836.33 - 1,320,850.24 44.35% Permits 000-431100 Home Occupation Permit 500.00 210.00 420.00 455.00 - 45.00 91.00% 000-431205 Building Permit - Residential 618,520.00 102,433.00 342,707.50 232,034.00 - 386,486.00 37.51% 000-431210 Building Permit - Commercial 270,000.00 21,520.00 409,516.00 34,429.00 - 235,571.00 12.75% 000-431215 Building Permit - General 220,000.00 69,889.00 79,723.00 179,598.00 - 40,402.00 81.64% 000-431300 Mobile Home Permit 300.00 275.00 50.00 400.00 - (100.00) 133.33% 000-431400 Signs Permit 5,800.00 2,834.00 2,299.00 4,714.00 - 1,086.00 81.28% 000-431500 Food Establishmnt Permit 63,000.00 6,920.00 56,865.00 57,940.00 - 5,060.00 91.97% 000-431600 Garage Sale Permit - - 2,135.00 - - - 0.00% 000-431700 Plumbing Permit 128,800.00 31,225.00 83,129.70 61,133.00 - 67,667.00 47.46% 000-431750 Electrical Permit 65,500.00 16,780.00 37,780.00 34,300.00 - 31,200.00 52.37% 000-431800 Mechanical Permit 65,900.00 13,620.00 35,560.00 28,560.00 - 37,340.00 43.34% 000-431900 Solicitor/Peddler Permit 1,500.00 920.00 410.00 1,250.00 - 250.00 83.33% 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,900.00 3,100.00 4,100.00 - 2,400.00 63.08% 000-432100 Security Alarm Permit 36,000.00 10,130.00 20,516.00 22,696.00 - 13,304.00 63.04% 000-432300 Grading/Clearing Permit 15,000.00 3,386.13 6,160.36 7,537.13 - 7,462.87 50.25% 000-432400 Development Permit 81,000.00 1,472.22 17,490.68 10,659.26 70,340.74 13.16% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 000-435000 Fire Permit 25,000.00 3,889.00 18,524.00 15,406.50 - 9,593.50 61.63% 000-436010 Network Nodes - - 1,750.00 - - - 0.00% TOTAL Permits 1,604,320.00 287,403.35 1,118,226.24 695,211.89 - 909,108.11 43.33% Licenses 000-441000 Alcohol Beverage License 8,000.00 705.00 3,625.00 3,015.00 - 4,985.00 37.69% 000-441300 Mobile Home License 160.00 40.00 40.00 80.00 - 80.00 50.00% 000-442000 Contractors License 45,600.00 19,800.00 25,850.00 28,550.00 - 17,050.00 62.61% 000-444000 Pet License 3,000.00 447.00 1,485.00 1,297.00 - 1,703.00 43.23% TOTAL Licenses 56,760.00 20,992.00 31,000.00 32,942.00 - 23,818.00 58.04% Fees 000-451000 Municipal Court Fines 382,303.00 176,797.70 290,466.00 340,608.35 - 41,694.65 89.09% 000-451100 Arrest Fee 21,012.00 6,257.81 9,918.42 12,843.09 - 8,168.91 61.12% 000-451110 Expunction Fee 120.00 - - - - 120.00 0.00% 000-451200 Warrant Fees 98,000.00 21,804.38 40,528.31 36,781.48 - 61,218.52 37.53% 000-451210 Court - Claims & Judgements - - - (214.89) - 214.89 0.00% 000-451320 Civil Justice Fee-Court 29.00 - - - - 29.00 0.00% 000-451321 Civil Justice Fee-State 262.00 - - - - 262.00 0.00% 000-451340 Judicial Fee - City 2,776.00 857.32 1,387.92 1,717.54 - 1,058.46 61.87% 000-451400 Traffic Fine Costs TTL 6,000.00 2,874.63 4,618.91 6,085.06 - (85.06) 101.42% 000-451510 Juvenile Case Mgmt Fee 23,236.00 7,139.34 11,596.80 14,337.93 - 8,898.07 61.71% 000-451520 Truancy Fee 3,934.00 1,309.79 2,016.94 2,680.61 1,253.39 68.14% 000-451600 Technology Fund Fee 18,793.00 5,733.26 9,218.22 11,500.79 - 7,292.21 61.20% 000-451700 Security Fee 7,475.00 4,299.94 7,008.59 8,625.61 - (1,150.61) 115.39% 000-451800 Time Payment Fee - City 4,119.00 1,277.18 2,764.98 2,489.18 - 1,629.82 60.43% 000-451850 State Fines 10% Service Fee 20,000.00 8,209.18 14,386.50 19,376.53 - 623.47 96.88% 000-451900 DPS Payment - Local 6,210.00 1,598.25 3,225.21 2,798.26 - 3,411.74 45.06% 000-452000 Child Safety Fee 4,874.00 1,862.27 2,199.65 5,181.76 - (307.76) 106.31% 000-452100 Platting Fees 57,000.00 6,500.00 21,250.00 28,000.00 - 29,000.00 49.12% 000-452200 Site Plan Fee 38,000.00 7,000.00 26,500.00 14,000.00 - 24,000.00 36.84% 000-452300 Plan Check Fee 514,260.00 113,972.00 417,410.00 245,032.93 - 269,227.07 47.65% 000-452320 Tree Mitigation Admin Fee 12,000.00 - 5,093.40 (225.00) - 12,225.00 -1.88% 000-452400 BOA/Zoning Fees 6,500.00 750.00 2,000.00 1,750.00 - 4,750.00 26.92% 000-452600 Specific Use/Zone Chng Fee 18,000.00 5,300.00 19,300.00 13,300.00 - 4,700.00 73.89% 000-452710 Zoning Ltr & Dev Rights 1,950.00 1,200.00 750.00 2,250.00 - (300.00) 115.38% 000-453100 Reinspection Fees 100,100.00 58,165.00 64,075.00 106,215.00 - (6,115.00) 106.11% 000-453110 Swim Pool Inspection Fee 2,920.00 110.00 - 110.00 - 2,810.00 3.77% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 000-453120 Inspections Plan Review - - 1,140.00 - - - 0.00% 000-453211 Admin Fee-Inspections 15,500.00 2,400.00 11,400.00 6,700.00 - 8,800.00 43.23% 000-453310 Misc Inspection Fee - - 2,000.00 300.00 - (300.00) 0.00% 000-453710 Foster Care 1,200.00 50.00 450.00 150.00 - 1,050.00 12.50% 000-454200 Pool Gate Admission Fee 24,000.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) 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 50.00 450.00 150.00 - 850.00 15.00% 000-456600 Sale of General Fixed Asset 20,000.00 - 19,251.61 - - 20,000.00 0.00% 000-458100 Sale of Merchandise-GovDeal - 1,475.00 - 1,786.39 (1,786.39) 000-458110 Sale of Merchandise-GovDeal 25,000.00 39,402.51 30,786.06 75,519.20 - (50,519.20) 302.08% 000-458400 Civic Center Rental Fees 197,000.00 53,521.00 102,834.00 102,559.37 - 94,440.63 52.06% 000-458401 Capital Recovery Fee-Civic Cntr 7,500.00 2,875.00 2,120.00 5,865.00 - 1,635.00 78.20% 000-458450 North Center Rental Fees 23,000.00 6,227.00 11,885.00 12,454.50 10,545.50 54.15% 000-458460 Senior Center Rental 7,200.00 2,100.00 - 4,200.00 - 3,000.00 58.33% 000-458500 Community Center Rental Fees 35,000.00 9,832.50 20,305.50 20,448.50 - 14,551.50 58.42% 000-458550 Pavilion Rental Fees 20,000.00 5,295.00 7,762.50 7,976.00 - 12,024.00 39.88% 000-458560 Chamber of Comm rent 7,800.00 1,950.00 3,900.00 3,900.00 - 3,900.00 50.00% 000-458570 Non-Resident SYSA League 10,000.00 - 13,080.00 - - 10,000.00 0.00% 000-458650 NonResident User Fee-BVYA 10,000.00 - 3,000.00 3,240.00 - 6,760.00 32.40% 000-458660 BVYA Utility Reimbursement 15,000.00 7,165.84 - 7,165.84 - 7,834.16 47.77% 000-458670 SYSA Utility Reimbursement 15,000.00 1,923.89 2,582.29 1,923.89 - 13,076.11 12.83% 000-458675 Lions Futbol Utility Reimbursement 10,000.00 3,516.00 2,344.00 7,032.00 - 2,968.00 70.32% 000-458700 Vehicle Impoundment 10,000.00 2,810.00 5,670.00 4,720.00 - 5,280.00 47.20% 000-459200 NSF Check Fee 100.00 50.00 - 50.00 - 50.00 50.00% 000-459300 Notary Fee 200.00 18.00 78.00 18.00 - 182.00 9.00% 000-459400 Maps, Copies, UDC, & Misc F - 5.00 10.00 15.00 - (15.00) 0.00% 000-459600 Animal Adoption Fee 12,500.00 1,339.12 7,176.00 5,510.12 - 6,989.88 44.08% 000-459700 Pet Impoundment Fee 6,300.00 625.00 3,682.20 1,990.00 - 4,310.00 31.59% 000-459800 Police Reports Fee 5,800.00 1,471.10 2,932.50 3,025.50 - 2,774.50 52.16% 000-45990 Fire - False Alarm Fee - - - - - - 0.00% TOTAL Fees 1,843,973.00 577,120.01 1,210,955.51 1,153,331.79 - 690,641.21 62.55% Fines 000-463000 Library Fines 22,000.00 4,709.68 11,964.08 7,403.89 - 14,596.11 33.65% TOTAL Fines 22,000.00 4,709.68 11,964.08 7,403.89 - 14,596.11 33.65% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,077.00 5,269.44 21,077.76 5,269.44 - 15,807.56 25.00% 000-473200 City of Seguin - Fire Contract 29,231.00 12,544.90 12,179.50 15,053.88 - 14,177.12 51.50% 000-473300 Guad Co - Library 218,000.00 54,288.00 126,672.00 108,576.00 - 109,424.00 49.81% 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 23,475.00 21,750.00 23,475.00 - (1,475.00) 106.70% 000-474400 Dispatch Service - Cibolo 166,000.00 80,000.00 - 80,000.00 - 86,000.00 48.19% 000-474600 School Crossing Guard-Bexar 38,000.00 9,523.68 18,347.83 12,466.00 - 25,534.00 32.81% 000-474610 School Cross Guard-Guadalupe 38,500.00 9,797.16 17,955.87 16,004.83 - 22,495.17 41.57% 000-474700 School Officer Funding 348,000.00 181,008.65 127,500.00 181,008.65 - 166,991.35 52.01% 000-474750 Crime Victim Liaison Agreement 50,000.00 25,000.00 18,750.00 25,000.00 - 25,000.00 50.00% TOTAL Inter-Jurisdictional 967,008.00 400,906.83 399,434.46 466,853.80 - 500,154.20 48.28% Fund Transfers 000-480000 Indirect Costs - EMS 175,587.00 43,896.75 85,043.40 87,793.50 - 87,793.50 50.00% 000-480100 Indirect Costs - Hotel/Motel 67,582.00 16,895.49 33,202.50 33,791.02 - 33,790.98 50.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 135,714.90 147,578.48 - 147,578.52 50.00% 000-486000 Interfund Chrges-Admin W&S 1,365,998.00 341,499.51 672,069.90 682,998.98 - 682,999.02 50.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,446.17 172,403.50 185,364.28 - 185,364.72 50.00% 000-488000 Interfund Charges-4B 456,630.00 - 441,395.00 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 5,063,249.00 568,527.18 1,539,829.20 1,365,841.26 - 3,697,407.74 26.98% Miscellaneous 000-491000 Interest Earned 35,000.00 24,657.27 13,053.64 40,855.35 - (5,855.35) 116.73% 000-491200 Investment Income 235,000.00 134,195.97 89,074.84 197,969.13 - 37,030.87 84.24% 000-491800 Gain/Loss - 881.84 (4,690.52) (299.80) - 299.80 0.00% 000-491900 Unrealized Gain/Loss - 4,090.05 (9,470.15) 11,035.93 - (11,035.93) 0.00% 000-493000 Donations-Others - 50.00 - 50.00 - (50.00) 0.00% 000-493120 Donations-Public Library 10,000.00 1,140.67 4,965.80 7,033.17 - 2,966.83 70.33% 000-493400 Donation - Animal Control 15,000.00 262.00 10,274.87 1,129.75 - 13,870.25 7.53% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 000-493401 Donations-A/C Microchip 1,000.00 15.00 360.00 30.00 - 970.00 3.00% 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 2,460.51 8,000.00 2,460.51 - 7,539.49 24.61% 000-493465 Donations-Senior Center 10,000.00 2,117.50 5,167.90 5,181.51 - 4,818.49 51.82% 000-493502 Donations-PD - (26,600.00) - (26,600.00) - 26,600.00 0.00% 000-493503 Donations-Fire Rescue - 500.00 10,350.00 500.00 - (500.00) 0.00% 000-494481 LawEnforcemtOfficersStnd&Ed 3,650.00 - 3,823.43 - - 3,650.00 0.00% 000-494482 Grants - Police, Fire, Gen Fund 3,000.00 - 2,970.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 60,000.00 28,825.79 58,546.17 26,904.59 - 33,095.41 44.84% 000-497005 Schertz Magazine Advertising 140,000.00 36,350.00 64,485.00 73,200.00 - 66,800.00 52.29% 000-497100 Misc Income-Police 3,800.00 3,385.19 2,088.71 4,660.60 - (860.60) 122.65% 000-497200 Misc Income-Library 4,500.00 1,247.90 2,469.59 2,352.35 - 2,147.65 52.27% 000-497210 Misc Income-Library Copier 18,000.00 5,115.60 9,245.60 9,865.10 - 8,134.90 54.81% 000-497300 Misc Income-Animal Control - 60.00 298.75 175.00 - (175.00) 0.00% 000-497400 Misc Income-Streets Dept.60,000.00 3,160.00 11,696.10 8,604.25 - 51,395.75 14.34% 000-497500 Misc Income-TML Insurance 20,000.00 14,425.00 33,050.83 16,241.95 - 3,758.05 81.21% 000-497550 Misc Income-TML Reimbursemt 15,000.00 - 628.14 - - 15,000.00 0.00% 000-497600 Misc Income-Vending Mach.2,500.00 574.65 924.57 1,364.78 - 1,135.22 54.59% 000-497610 Misc Income- Muni Court - - 2,036.40 150.00 - (150.00) 0.00% 000-498000 Reimbursmnt-Gen Fund 20,000.00 - 1,639.44 - - 20,000.00 0.00% 000-498100 Reimbursmnt Fire - Training 500.00 - - - - 500.00 0.00% 000-498105 Reimburmnt Police - DEA - 6,381.52 7,933.34 9,580.19 - (9,580.19) 0.00% 000-498107 Reimburmnt Police - Event - - - - - - 0.00% 000-498110 Reimbursmnt Fire - Emg. Acti-O 30,000.00 - 179,445.81 13,018.19 - 16,981.81 43.39% 000-498150 Reimbursemnt - Library 6,000.00 - 6,355.39 - - 6,000.00 0.00% TOTAL Miscellaneous 706,550.00 243,296.46 515,360.65 405,462.55 - 301,087.45 57.39% TOTAL REVENUES 34,156,548.57 11,685,342.18 21,618,311.71 22,457,556.64 - 11,698,991.93 65.75% Cash in Bank Claim on Operating Cash Pool-Checking 182,208.54$ Cash in Investments LOGIC Investment-General Fund 18,279,994.22 LOGIC Investment-Equip Replacement 77,150.15 LOGIC Investment-Veh Replacement 520,205.72 LOGIC Investment-Air Condi Replacment 283,100.05 CAPITAL ONE Investment-General Fund 1,401,850.99 Total Cash in Bank & Investments 20,744,509.67$ GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2019 50% OF OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2018-19 255,207 587,379 5,347,223 5,289,147 1,630,362 85,307 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 50% OF OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2018-19 766,254 736,285 627,360 571,251 769,881 603,905 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 50% OF OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2018-19 270,225 203,885 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 50% 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 15,235.09 74,050.43 48,354.42 - 51,905.58 48.23% TOTAL REVENUES 156,760.00 15,235.09 74,050.43 48,354.42 - 108,405.58 30.85% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental - - - - - - 0.00% TOTAL GENERAL GOVERNMENT - - - - - - 0.00% CULTURAL Festival of Angels 16,255.00 6,463.46 10,566.23 17,332.29 29.00 (1,106.29) 106.81% Employee Appreciation Event - - 9,807.85 - - - 0.00% 4th of July Jubilee 26,000.00 - 100.00 - 142.80 25,857.20 0.55% National Night Out 500.00 - - - - 500.00 0.00% Wilenchik Walk for Life 15,000.00 2,886.21 2,485.68 2,886.21 5,165.16 6,948.63 53.68% Schertz Fest 42,943.00 - 620.00 636.00 700.00 41,607.00 3.11% Schertz Sweetheart 24,000.00 1,075.66 5,860.11 2,454.34 509.37 21,036.29 12.35% Hal Baldwin Scholarship 15,510.00 - 8,537.61 10,611.62 - 4,898.38 68.42% Other Events 37,500.00 12,756.34 6,350.36 20,724.89 2,399.59 14,375.52 61.67% TOTAL CULTURAL 177,708.00 23,181.67 44,327.84 54,645.35 8,945.92 114,116.73 35.78% TOTAL EXPENDITURES 177,708.00 23,181.67 44,327.84 54,645.35 8,945.92 114,116.73 35.78% REVENUE OVER(UNDER) EXPEND (20,948.00) (7,946.58) 29,722.59 (6,290.93) (8,945.92) (5,711.15) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% 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 150.59 126.43 219.92 - 30.08 87.97% 000-492200 Wilenchik Walk for Life 15,000.00 8,970.50 10,565.00 8,970.50 - 6,029.50 59.80% 000-493000 July 4th Activities 26,000.00 - - (70.00) - 26,070.00 -0.27% 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-493470 Moving on Main 3,000.00 1,550.00 - 1,550.00 1,450.00 51.67% 000-493621 Hal Baldwin Scholarship 15,510.00 70.00 20,105.00 28,820.00 - (13,310.00) 185.82% 000-497000 Misc Income 6,000.00 4,494.00 41,749.00 5,944.00 - 56.00 99.07% TOTAL Miscellaneous 100,260.00 15,235.09 74,050.43 48,354.42 - 51,905.58 48.23% TOTAL REVENUES 156,760.00 15,235.09 74,050.43 48,354.42 - 108,405.58 30.85% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 68,390.19$ Cash in Investments Texas Class- Special Events 17,599.06 Total Cash in Bank & Investments 85,989.25$ SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2019 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 78,990.77 21,917.41 21,430.96 42,900.83 - 36,089.94 54.31% Fund Transfers 116,009.23 - - - - 116,009.23 0.00% TOTAL REVENUES 195,000.00 21,917.41 21,430.96 42,900.83 - 152,099.17 22.00% 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 - 21,917.41 21,430.96 42,900.83 - (42,900.83) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 110-PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% 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,498.17 14,010.64 30,387.55 - 29,780.48 50.50% 000-421465 AT&T PEG Fee 18,822.74 6,419.24 7,420.32 12,513.28 - 6,309.46 66.48% TOTAL Franchises 78,990.77 21,917.41 21,430.96 42,900.83 - 36,089.94 54.31% 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 21,917.41 21,430.96 42,900.83 - 152,099.17 22.00% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 Cash in Bank Cash Balance 744,822.68$ Total Cash in Bank & Investments 744,822.68$ PEG FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2019 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 263,517.05 144,603.74 71,188.08 144,604 - 118,913.31 54.87% Fees 24,439,057.45 5,203,178.60 10,949,250.23 10,938,824 - 13,500,233.29 44.76% Fund Transfers 685,836.00 35,250.00 70,755.00 70,500 - 615,336.00 10.28% Miscellaneous 347,111.00 195,501.92 147,971.73 251,867 - 95,244.38 72.56% TOTAL REVENUES 25,735,521.50 5,578,534.26 11,239,165.04 11,405,794.52 - 14,329,726.98 44.32% EXPENDITURE SUMMARY NON DEPARTMENTAL Transfer to Public Improvements 125,000.00 - - - - 125,000.00 0.00% Other Finance Source - - - - - - 0.00% TOTAL NON DEPARTMENTAL 125,000.00 - - - - 125,000.00 0.00% BUSINESS OFFICE Personnel Services 499,900.00 101,797.71 229,611.32 210,340.57 11,095.75 278,463.68 44.30% Supplies 3,800.00 994.22 535.50 1,181.50 111.45 2,507.05 34.03% City Support Services 5,655.00 200.00 - 250.00 - 5,405.00 4.42% Utility Services 10,365.00 338.16 409.38 489.19 185.82 9,689.99 6.51% Operations Support 158,500.00 16,890.47 60,398.42 47,619.02 - 110,880.98 30.04% Staff Support 6,250.00 1,693.19 606.85 2,069.37 352.00 3,828.63 38.74% Professional Services 243,000.00 61,551.49 91,240.34 106,690.99 - 136,309.01 43.91% Maintenance Services 8,040.00 1,260.00 4,020.00 4,020.00 2,940.00 1,080.00 86.57% Operating Equipment 600.00 - 3,516.95 359.97 - 240.03 60.00% TOTAL BUSINESS OFFICE 936,110.00 184,725.24 390,338.76 373,020.61 14,685.02 548,404.37 41.42% W & S ADMINISTRATION Personnel Services 1,432,723.00 289,188.81 586,116.96 639,185.03 33,418.50 760,119.47 46.95% Supplies 187,500.00 65,899.22 94,022.82 77,043.19 52,828.51 57,628.30 69.26% Human Services 700.00 - - - - 700.00 0.00% City Support Services 157,535.00 7,781.60 45,681.20 51,447.04 129.71 105,958.25 32.74% Utility Services 3,526,800.00 817,042.46 1,498,219.91 1,479,751.12 164.83 2,046,884.05 41.96% Operations Support 11,300.00 3,008.12 2,716.07 4,321.20 105.00 6,873.80 39.17% Staff Support 35,000.00 7,410.39 15,009.69 16,063.74 316.63 18,619.63 46.80% City Assistance 1,500.00 - - - - 1,500.00 0.00% Professional Services 416,465.00 115,096.59 132,969.98 185,286.41 1,300.00 229,878.59 44.80% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% 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: MARCH 31, 2019 Fund Charges/Transfers 6,208,960.00 1,849,934.41 3,207,226.80 3,730,842.93 - 2,478,117.07 60.09% Maintenance Services 9,149,707.50 2,184,677.56 3,652,710.45 3,489,886.49 60,435.03 5,599,385.98 38.80% Other Costs 40,000.00 38,435.72 36,605.45 38,435.72 - 1,564.28 96.09% Debt Service 1,904,245.25 267,516.90 738,634.30 267,516.90 - 1,636,728.35 14.05% Rental-Leasing 124,500.00 33,538.45 2,782.95 65,293.44 - 59,206.56 52.44% Operating Equipment 9,000.00 475.98 26.85 475.98 249.55 8,274.47 8.06% Capital Outlay 712,978.00 320,506.64 - 510,821.64 213,911.39 (11,755.03) 101.65% TOTAL PUBLIC WORKS 23,918,913.75 6,000,512.85 10,012,723.43 10,556,370.83 362,859.15 12,999,683.77 45.65% MISC & PROJECTS PROJECTS Operations Support - - 964.26 - - - 0.00% Professional Services - - 5,371.25 - 6,172.50 (6,172.50) 0.00% Maintenance Services - - 229,917.25 - - - 0.00% TOTAL PROJECTS - - 236,252.76 - 6,172.50 (6,172.50) 0.00% TOTAL MISC & PROJECTS - - 236,252.76 - 6,172.50 (6,172.50) 0.00% TOTAL EXPENDITURES 24,980,023.75 6,185,238.09 10,639,314.95 10,929,391.44 383,716.67 13,666,915.64 45.29% ** REVENUE OVER(UNDER)EXPENSES **755,497.75 (606,703.83) 599,850.09 476,403.08 (383,716.67) 662,811.34 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421490 Tower Leasing 263,517.05 144,603.74 71,188.08 144,603.74 - 118,913.31 54.87% TOTAL Franchises 263,517.05 144,603.74 71,188.08 144,603.74 - 118,913.31 54.87% Permits 000-432400 Development Permit - - - - - - 0.00% TOTAL Permits - - - - - - 0.00% Fees 000-455200 Garbage Collection Fee 5,217,962.06 1,221,867.48 2,394,541.45 2,528,805.43 - 2,689,156.63 48.46% 000-455600 Fire Line Fees 31,000.00 33,160.00 29,015.00 33,160.00 - (2,160.00) 106.97% 000-455700 Recycle Fee Revenue 315,500.00 76,921.86 152,577.33 161,410.47 - 154,089.53 51.16% 000-455800 W&S Line Constructn Reimbursemnt 20,000.00 4,245.00 17,549.79 10,027.00 - 9,973.00 50.14% 000-457100 Sale of Water 10,790,831.42 2,080,759.03 4,731,138.41 4,529,158.44 - 6,261,672.98 41.97% 000-457110 Edwards Water Lease 40,000.00 28,171.25 28,172.25 28,171.25 - 11,828.75 70.43% 000-457120 Water Transfer Charge-Selma 6,233.00 7,561.95 - 28,808.83 - (22,575.83) 462.20% 000-457200 Sale of Meters 160,000.00 16,695.00 74,228.83 40,226.00 - 119,774.00 25.14% 000-457400 Sewer Charges 7,578,030.97 1,733,248.26 3,382,308.39 3,571,821.29 - 4,006,209.68 47.13% 000-457500 Water Penalties 277,000.00 (76.23) 138,093.78 6,010.45 - 270,989.55 2.17% 000-459200 NSF Check Fee-Water&Sewer 2,500.00 625.00 1,625.00 1,225.00 - 1,275.00 49.00% TOTAL Fees 24,439,057.45 5,203,178.60 10,949,250.23 10,938,824.16 - 13,500,233.29 44.76% 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 70,755.00 70,500.00 - 70,500.00 50.00% TOTAL Fund Transfers 685,836.00 35,250.00 70,755.00 70,500.00 - 615,336.00 10.28% Miscellaneous 000-490000 Misc Charges 1,000.00 2,450.00 5,587.00 5,202.00 - (4,202.00) 520.20% 000-491000 Interest Earned 25,000.00 16,805.70 11,419.61 34,785.25 - (9,785.25) 139.14% 000-491200 Investment Income 180,000.00 90,916.37 60,033.39 125,753.94 - 54,246.06 69.86% 000-496000 Water Construction Reserve - - 1.00 - - - 0.00% 000-497000 Misc Income-W&S 15,000.00 44,612.39 1,845.71 45,407.97 - (30,407.97) 302.72% 000-498110 Reimbursement-SSLGC 126,111.00 40,717.46 69,085.02 40,717.46 - 85,393.54 32.29% TOTAL Miscellaneous 347,111.00 195,501.92 147,971.73 251,866.62 - 95,244.38 72.56% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 TOTAL REVENUES 25,735,521.50 5,578,534.26 11,239,165.04 11,405,794.52 - 14,329,726.98 44.32% Cash in Bank Claim on Operating Cash Pool-Checking 42,743.87$ Cash in Investments Lone Star Investment-Water&Sewer 7,428,726.42 Lone Star Investment-W&S Customer Deposits 309,348.72 Lone Star Investment-W&S Equip Replacement 186,178.58 Lone Star Investment-W&S Veh Replacement 268,503.02 Schertz Bank & Trust-Certificate of Deposit 1,112,177.02 9,304,933.76$ Total Cash in Bank & Investments 9,347,677.63$ WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: MARCH 31,2019 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 6,194,079.80 1,379,603.84 2,513,260.44 2,908,083.46 - 3,285,996.34 46.95% Inter-Jurisdictional 3,025,485.39 1,230,101.98 1,683,463.09 2,247,502.85 - 777,982.54 74.29% Fund Transfers - - - - - - 0.00% Miscellaneous 125,750.00 408,980.51 125,849.91 57,371.18 - 68,378.82 45.62% TOTAL REVENUES 9,345,315.19 3,018,686.33 4,322,573.44 5,212,957.49 - 4,132,357.70 55.78% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 4,461,556.00 938,250.47 2,021,682.37 2,080,475.13 58,657.27 2,322,423.60 47.95% Supplies 431,050.00 100,199.10 187,659.08 191,659.28 58,552.49 180,838.23 58.05% City Support Services 99,500.00 5,752.24 45,213.10 37,803.73 9,979.00 51,717.27 48.02% Utility Services 127,000.00 31,175.98 48,991.48 54,773.68 1,504.82 70,721.50 44.31% Operations Support 73,700.00 17,828.73 30,905.78 37,142.23 867.00 35,690.77 51.57% Staff Support 79,250.00 12,014.70 22,283.63 23,637.36 12,104.07 43,508.57 45.10% City Assistance 568,866.81 229,370.50 274,953.37 276,045.66 1,233.77 291,587.38 48.74% Professional Services 162,140.00 29,730.63 47,774.67 47,472.96 26,000.02 88,667.02 45.31% Fund Charges/Transfers 2,694,628.42 1,955,907.87 1,356,558.95 1,895,335.24 - 799,293.18 70.34% Maintenance Services 12,000.00 299.00 4,800.00 1,259.00 2,880.00 7,861.00 34.49% Debt Service 288,895.00 114,481.36 115,788.13 114,481.36 - 174,413.64 39.63% Rental-Leasing 141,000.00 34,315.29 69,665.01 68,501.91 - 72,498.09 48.58% Operating Equipment 89,550.00 18,814.98 10,851.48 32,811.82 9,645.71 47,092.47 47.41% Capital Outlay 6,500.00 6,500.00 - 6,500.00 - - 100.00% TOTAL PUBLIC SAFETY 9,235,636.23 3,494,640.85 4,237,127.05 4,867,899.36 181,424.15 4,186,312.72 54.67% TOTAL EXPENDITURES 9,235,636.23 3,494,640.85 4,237,127.05 4,867,899.36 181,424.15 4,186,312.72 54.67% ** REVENUE OVER(UNDER) EXPENSES **109,678.96 (475,954.52) 85,446.39 345,058.13 (181,424.15) (53,955.02) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-456100 Ambulance/Mileage Transport 5,894,479.80 1,298,535.37 2,328,954.97 2,746,139.03 - 3,148,340.77 46.59% 000-456110 Subscription Program Fees 28,000.00 3,895.00 23,485.00 22,515.00 - 5,485.00 80.41% 000-456120 EMT Class - Fees 96,000.00 32,430.00 51,065.00 50,325.00 - 45,675.00 52.42% 000-456122 CE Class - Fees 21,500.00 14,368.00 18,382.52 14,368.00 - 7,132.00 66.83% 000-456130 Immunization Fees 7,000.00 135.34 2,536.81 1,715.34 - 5,284.66 24.50% 000-456140 Billing Fees - External 25,000.00 5,798.22 11,042.69 11,134.45 - 13,865.55 44.54% 000-456150 Standby Fees 27,000.00 1,500.00 25,338.95 21,509.50 - 5,490.50 79.66% 000-456155 Community Services Support 75,000.00 14,304.91 48,874.50 20,779.11 - 54,220.89 27.71% 000-456160 MIH Services 20,000.00 8,612.00 3,480.00 14,974.00 - 5,026.00 74.87% 000-458110 Sales of Merchandise - GovDeal - - - 4,574.03 - (4,574.03) 0.00% 000-459200 NSF Check Fee 100.00 25.00 100.00 50.00 - 50.00 50.00% TOTAL Fees 6,194,079.80 1,379,603.84 2,513,260.44 2,908,083.46 - 3,285,996.34 46.95% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 843,577.17 773,279.87 492,087.19 843,578.04 - (0.87) 100.00% 000-474300 Cibolo Support 410,582.70 102,645.68 173,233.82 205,291.36 - 205,291.34 50.00% 000-475100 Comal Co ESD #6 121,722.92 31,775.76 57,148.44 61,607.79 - 60,115.13 50.61% 000-475200 Live Oak Support 232,140.26 58,035.07 106,575.98 116,070.14 - 116,070.12 50.00% 000-475300 Universal City Support 300,091.66 75,022.92 140,641.86 150,045.84 - 150,045.82 50.00% 000-475400 Selma Support 148,697.12 37,174.28 55,943.18 74,348.56 - 74,348.56 50.00% 000-475500 Schertz Support 581,537.22 145,384.31 278,162.50 290,768.62 - 290,768.60 50.00% 000-475600 Santa Clara Support 10,789.68 2,697.42 5,223.68 5,394.84 - 5,394.84 50.00% 000-475800 Marion Support 16,346.66 4,086.67 7,593.48 8,173.34 - 8,173.32 50.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 1,230,101.98 1,683,463.09 2,247,502.85 - 777,982.54 74.29% Miscellaneous 000-491000 Interest Earned 3,000.00 849.02 1,608.85 3,364.43 - (364.43) 112.15% 000-491200 Investment Income 750.00 3,054.24 4,706.50 3,340.39 - (2,590.39) 445.39% 000-493203 Donations-EMS 2,000.00 - 350.00 100.44 - 1,899.56 5.02% 000-493205 Donations- Golf Tournament 10,000.00 - 600.00 - - 10,000.00 0.00% 000-497000 Misc Income 50,000.00 390,112.88 89,245.26 30,526.85 - 19,473.15 61.05% 000-497100 Recovery of Bad Debt 60,000.00 14,964.37 29,339.30 20,039.07 - 39,960.93 33.40% TOTAL Miscellaneous 125,750.00 408,980.51 125,849.91 57,371.18 - 68,378.82 45.62% TOTAL REVENUES 9,345,315.19 3,018,686.33 4,322,573.44 5,212,957.49 - 4,132,357.70 55.78% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 256,393.22$ Cash in Investments Texas Class- EMS Notes 2015 Investment - SR 2017 Ambulance-Logic 57,714.60 Total Cash in Bank & Investments 314,107.82$ SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2019 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Permits 3,000.00 680.00 1,460.00 1,860 - 1,140.00 62.00% Fees 1,208,500.00 285,567.08 583,948.94 594,746 - 613,753.92 49.21% Fund Transfers 568,131.00 - - - - 568,131.00 0.00% Miscellaneous 26,800.00 12,581.34 177,570.63 43,171 - (16,370.59) 161.08% TOTAL REVENUES 1,806,431.00 298,828.42 762,979.57 639,776.67 - 1,166,654.33 35.42% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 400,584.00 66,975.76 148,622.09 162,704.58 8,113.31 229,766.11 42.64% Supplies 5,700.00 348.91 1,521.21 880.36 94.12 4,725.52 17.10% City Support Services 1,000.00 386.50 5,128.49 3,266.01 - (2,266.01) 326.60% Utility Services 13,200.00 3,538.26 4,267.10 6,092.12 82.60 7,025.28 46.78% Operations Support 1,000.00 - - - - 1,000.00 0.00% Staff Support 10,000.00 2,093.54 2,708.65 2,924.40 470.94 6,604.66 33.95% City Assistance 500.00 - 98.00 - - 500.00 0.00% Professional Services 41,500.00 725.00 8,840.00 725.00 - 40,775.00 1.75% Fund Charges/Transfers 532,162.00 132,790.50 249,671.77 265,581.00 - 266,581.00 49.91% Maintenance Services 30,000.00 748.00 872.14 791.00 - 29,209.00 2.64% Other costs 200.00 100.00 100.00 100.00 - 100.00 50.00% Debt Service 121,212.50 3,099.64 4,093.63 3,099.64 - 118,112.86 2.56% Rental/Leasing 5,500.00 - - - - 5,500.00 0.00% Operating Equipment - - 519.99 - - - 0.00% Capital Outlay 74,348.00 - - - 74,347.40 0.60 100.00% TOTAL DRAINAGE 1,236,906.50 210,806.11 426,443.07 446,164.11 83,108.37 707,634.02 42.79% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% 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: MARCH 31, 2019 PROJECTS City Support Services 7,354.00 - - - - 7,354.00 0.00% Operations Support 218.00 566.50 469.00 566.50 - (348.50) 259.86% Professional Services 29,749.00 5,651.00 8,120.00 6,354.00 14,716.00 8,679.00 70.83% Maintenance Services 517,412.00 282,111.00 255,055.25 348,962.64 136,971.65 31,477.71 93.92% TOTAL PROJECTS 554,733.00 288,328.50 263,644.25 355,883.14 151,687.65 47,162.21 91.50% TOTAL EXPENDITURES 1,791,639.50 499,134.61 690,087.32 802,047.25 234,796.02 754,796.23 57.87% ** REVENUE OVER(UNDER) EXPEND 14,791.50 (200,306.19) 72,892.25 (162,270.58) (234,796.02) 411,858.10 204-DRAINAGE CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 50% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000-432400 Floodplain Permit 3,000.00 680.00 1,460.00 1,860.00 - 1,140.00 62.00% TOTAL Permits 3,000.00 680.00 1,460.00 1,860.00 - 1,140.00 62.00% Fees 000-457500 Drainage Penalties 10,000.00 - 6,200.25 66.19 - 9,933.81 0.66% 000-457600 Drainage Fee 1,198,500.00 285,567.08 577,748.69 594,679.89 - 603,820.11 49.62% TOTAL Fees 1,208,500.00 285,567.08 583,948.94 594,746.08 - 613,753.92 49.21% Fund Transfers 000-481000 Transfer In 568,131.00 - - - - 568,131.00 0.00% TOTAL Funds Transfers 568,131.00 - - - - 568,131.00 0.00% Miscellaneous 000-491000 Interest Earned 1,800.00 1,225.63 1,015.63 2,519.27 - (719.27) 139.96% 000-491200 Investment Interest 25,000.00 11,341.85 12,308.19 16,519.37 - 8,480.63 66.08% 000-497000 Misc Income-Drainage - 13.86 164,246.81 24,131.95 - (24,131.95) 0.00% TOTAL Miscellaneous 26,800.00 12,581.34 177,570.63 43,170.59 - (16,370.59) 161.08% TOTAL REVENUES 1,806,431.00 298,828.42 762,979.57 639,776.67 - 1,166,654.33 35.42% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 49,178.58$ Cash in Investments Lone Star Investment-Drainage Maint Fund 1,323,482.14 Total Cash in Bank & Investments 1,372,660.72$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2019 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 500,000.00 97,849.73 170,897.43 209,438.48 - 290,561.52 41.89% Miscellaneous 28,000.00 15,833.26 10,998.38 23,305.53 - 4,694.47 83.23% TOTAL REVENUES 528,000.00 113,682.99 181,895.81 232,744.01 - 295,255.99 44.08% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 110,650.00 8,151.79 57,046.36 57,172.54 - 53,477.46 51.67% Operations Support 65,500.00 4,872.00 9,492.00 6,958.00 - 58,542.00 10.62% Professional Services 3,000.00 1,478.03 3,000.00 14,284.94 - (11,284.94) 476.16% Fund Charges/Transfers 67,582.00 16,895.49 33,202.50 33,791.02 - 33,790.98 50.00% Maintenance Services 10,000.00 - - - - 10,000.00 0.00% TOTAL NONDEPARTMENTAL 256,732.00 31,397.31 102,740.86 112,206.50 - 144,525.50 43.71% TOTAL EXPENDITURES 256,732.00 31,397.31 102,740.86 112,206.50 - 144,525.50 43.71% REVENUE OVER(UNDER) EXPENDITURE 271,268.00 82,285.68 79,154.95 120,537.51 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 140,504.13$ Cash in Investments Texas Class - Hotel Tax 1,793,431.81 Total Cash in Bank & Investments 1,933,935.94$ HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2019 50% OF OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2018-19 38,655 36,314 18,923 63,367 15,560 81,868 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 $90,000 HOTEL OCCUPANCY TAX 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 70,000.00 4,000.00 24,000.00 10,000 - 60,000.00 14.29% Fund Transfers 76,512.00 - - - - 76,512.00 0.00% Miscellaneous 30,000.00 2,595.52 2,758.68 12,502.45 - 17,497.55 41.67% TOTAL REVENUES 176,512.00 6,595.52 26,758.68 22,502.45 - 154,009.55 12.75% EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services 10,000.00 - - 4,464.51 6,256.49 (721.00) 107.21% Operating Equipment 5,000.00 - - - 1,332.80 3,667.20 26.66% Capital Outlay 161,512.00 17,268.23 59,139.06 74,610.42 7,978.00 78,923.58 51.13% TOTAL PARKLAND DEDICATION 176,512.00 17,268.23 59,139.06 79,074.93 15,567.29 81,869.78 53.62% TOTAL EXPENDITURES 176,512.00 17,268.23 59,139.06 79,074.93 15,567.29 81,869.78 53.62% REVENUE OVER(UNDER) EXPEND - (10,672.71) (32,380.38) (56,572.48) (15,567.29) 72,139.77 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458800 Parkland Dedication 70,000.00 4,000.00 24,000.00 10,000.00 - 60,000.00 14.29% TOTAL Fees 70,000.00 4,000.00 24,000.00 10,000.00 - 60,000.00 14.29% 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 364.45 312.11 515.20 - 234.80 68.69% 000-491200 Investment Interest 7,000.00 2,231.07 2,446.57 3,573.25 - 3,426.75 51.05% 000-493700 Donations - 8,000.00 (8,000.00) 0.00% 000-497000 Misc Income - 414.00 - 414.00 - (414.00) 0.00% 000-499100 Transfer From Parks Reserve 22,250.00 - - - - 22,250.00 0.00% TOTAL Miscellaneous 30,000.00 2,595.52 2,758.68 12,502.45 - 17,497.55 41.67% TOTAL REVENUES 176,512.00 6,595.52 26,758.68 22,502.45 - 154,009.55 12.75% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 Cash in Bank Current Claim on Operating Cash Pool-Checking 77,597.22 Cash in Investments Texas Class- Park Fund 239,990.75 Total in Investment Pool 239,990.75 Total Cash in Bank & Investments 317,587.97 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2019 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 72,500.00 - 33,121.10 (1,275) (1,075.00) 74,850.00 -3.24% Fund Transfers - - - - - - 0.00% Miscellaneous 7,750.00 3,481.35 2,543.77 5,223 - 2,526.57 67.40% TOTAL REVENUES 80,250.00 3,481.35 35,664.87 3,948.43 (1,075.00) 77,376.57 3.58% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services-Trees 75,000.00 4,600.00 2,443.00 11,500.00 - 63,500.00 15.33% TOTAL TREE MITIGATION 75,000.00 4,600.00 2,443.00 11,500.00 - 63,500.00 15.33% TOTAL EXPENDITURES 75,000.00 4,600.00 2,443.00 11,500.00 - 63,500.00 15.33% REVENUE OVER(UNDER) EXPEND 5,250.00 (1,118.65) 33,221.87 (7,551.57) (1,075.00) 13,876.57 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458900 Tree Mitigation 72,500.00 - 33,121.10 (1,275.00) (1,075.00) 74,850.00 -3.24% TOTAL Fees 72,500.00 - 33,121.10 (1,275.00) (1,075.00) 74,850.00 -3.24% Fund Transfers 000-481000 Transfer In - Reserves - - - - - - 0.00% TOTAL Fund Transfers - - - - - - 0.00% Miscellaneous 000-491000 Interest Earned 750.00 204.84 230.40 438.31 - 311.69 58.44% 000-491200 Investment Interest 7,000.00 3,276.51 2,313.37 4,785.12 - 2,214.88 68.36% TOTAL Miscellaneous 7,750.00 3,481.35 2,543.77 5,223.43 - 2,526.57 67.40% TOTAL REVENUES 80,250.00 3,481.35 35,664.87 3,948.43 (1,075.00) 77,376.57 3.58% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 Cash in Bank Claim on Operating Cash Pool-Checking $41,334.12 Cash in Investments MBIA Investment-Tree Mitigation 382,918.69 Total Cash in Bank & Investments $424,252.81 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2019 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 1,100,000.00 173,106.00 836,401.40 426,897.00 - 673,103.00 38.81% Fund Transfers 1,375,000.00 - - - - 1,375,000.00 0.00% Miscellaneous 82,000.00 57,859.25 38,178.50 84,095.92 - (2,095.92) 102.56% TOTAL REVENUES 2,557,000.00 230,965.25 874,579.90 510,992.92 - 2,046,007.08 19.98% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 256,000.00 484.00 1,000.00 484.00 - 255,516.00 0.19% Fund Charges/Transfers 1,375,000.00 - - - 1,375,000.00 0.00% TOTAL NON DEPARTMENTAL 1,631,000.00 484.00 1,000.00 484.00 - 1,630,516.00 0.03% TOTAL MISC & PROJECTS - - - - - - 0.00% TOTAL EXPENDITURES 1,631,000.00 484.00 1,000.00 484.00 - 1,630,516.00 0.03% REVENUE OVER(UNDER) EXPENDITURES 926,000.00 230,481.25 873,579.90 510,508.92 - 415,491.08 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% 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 173,106.00 836,401.40 426,897.00 - 673,103.00 38.81% TOTAL Fees 1,100,000.00 173,106.00 836,401.40 426,897.00 - 673,103.00 38.81% Miscellaneous 000-491000 Interest Earned 7,000.00 801.48 2,325.23 2,027.49 - 4,972.51 28.96% 000-491200 Investment Income 75,000.00 57,057.77 35,853.27 82,068.43 - (7,068.43) 109.42% TOTAL Miscellaneous 82,000.00 57,859.25 38,178.50 84,095.92 - (2,095.92) 102.56% TOTAL REVENUES 1,182,000.00 230,965.25 874,579.90 510,992.92 - 671,007.08 43.23% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 212,147.22$ Cash in Investments Lone Star Investment-Capital Recovery Water 6,790,435.48 Total Cash in Bank & Investments 7,002,582.70$ CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2019 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 600,000.00 107,118.72 470,317.32 233,887 - 366,113.28 38.98% Fund Transfers - - - - - - 0.00% Miscellaneous 44,000.00 51,119.62 26,289.97 82,893 - (38,893.16) 188.39% TOTAL REVENUES 644,000.00 158,238.34 496,607.29 316,779.88 - 327,220.12 49.19% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 260,500.00 1,589.01 362,879.23 2,685.87 - 257,814.13 1.03% Fund Charges/Transfers - - - - - - 0.00% TOTAL NON DEPARTMENTAL 260,500.00 1,589.01 362,879.23 2,685.87 - 257,814.13 1.03% TOTAL EXPENDITURES 260,500.00 1,589.01 362,879.23 2,685.87 - 257,814.13 1.03% REVENUE OVER(UNDER) EXPENDITURES 383,500.00 156,649.33 133,728.06 314,094.01 - 69,405.99 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% 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 107,118.72 459,517.32 233,886.72 - 366,113.28 38.98% 000-455913 Cap Recovery-North Sewer Tr - - 10,800.00 - - - 0.00% TOTAL Fees 600,000.00 107,118.72 470,317.32 233,886.72 - 366,113.28 38.98% Fund Transfers 000-481000 Transfer from Reserves - - - - - - 0.00% TOTAL Fund Transfers - - - - - - 0.00% Miscellaneous 000-491000 Interest Earned 4,000.00 769.05 1,801.76 2,104.76 - 1,895.24 52.62% 000-491200 Investment Income 40,000.00 44,347.80 43,160.95 68,014.00 - (28,014.00) 170.04% 000-491800 Gain/Loss - (7,785.69) 597.17 (8,731.00) - 8,731.00 0.00% 000-491900 Unrealized Gain/Loss-Cap One - 13,788.46 (19,269.91) 21,505.40 - (21,505.40) 0.00% TOTAL Miscellaneous 44,000.00 51,119.62 26,289.97 82,893.16 - (38,893.16) 188.39% TOTAL REVENUES 644,000.00 158,238.34 496,607.29 316,779.88 - 327,220.12 49.19% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 184,469.88$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 4,363,145.95 Capital One-Investment 1,784,890.45 Total Cash in Bank & Investments 6,332,506.28$ CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2019 505-TAX I&S CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 6,384,000.00 3,315,638.67 5,981,785.20 6,249,114.11 - 134,885.89 97.89% Fund Transfers 113,723.00 - - - - 113,723.00 0.00% Miscellaneous 156,000.00 117,816.11 381,582.06 123,086.36 - 32,913.64 78.90% TOTAL REVENUES 6,653,723.00 3,433,454.78 6,363,367.26 6,372,200.47 - 281,522.53 95.77% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 1,800.00 2,150.00 2,350.00 - 2,650.00 47.00% Debt Service 6,648,723.27 4,406,189.59 5,815,642.93 5,452,396.99 - 1,196,326.28 82.01% TOTAL GENERAL GOVERNMENT 6,653,723.27 4,407,989.59 5,817,792.93 5,454,746.99 - 1,198,976.28 81.98% - TOTAL EXPENDITURES 6,653,723.27 4,407,989.59 5,817,792.93 5,454,746.99 - 1,198,976.28 81.98% ** REVENUE OVER(UNDER) EXPEND (0.27) (974,534.81) 545,574.33 917,453.48 - (917,453.75) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 505-TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y-T-D BUDGET 50% 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 3,315,638.67 5,981,785.20 6,249,114.11 - 134,885.89 97.89% TOTAL Taxes 6,384,000.00 3,315,638.67 5,981,785.20 6,249,114.11 - 134,885.89 97.89% 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 5,266.42 3,214.51 6,199.43 - (199.43) 103.32% 000-491200 Investment Earnings 50,000.00 12,549.69 17,598.55 16,886.93 - 33,113.07 33.77% 000-495015 Contribution from SED - - 360,769.00 - - - 0.00% 000-495020 Contribution from YMCA 100,000.00 100,000.00 - 100,000.00 - - 100.00% TOTAL Miscellaneous 156,000.00 117,816.11 381,582.06 123,086.36 - 32,913.64 78.90% TOTAL REVENUES 6,653,723.00 3,433,454.78 6,363,367.26 6,372,200.47 - 281,522.53 95.77% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% 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 1,800.00 2,150.00 2,350.00 - 2,650.00 47.00% 101-541502 Cost of Bond Issuance - (1,000.00) - - - - 0.00% TOTAL Professional Services 5,000.00 1,800.00 2,150.00 2,350.00 - 2,650.00 0.47 Debt Service 101-555612 Bond-GO Refunding 2010-Principal 300,000.00 300,000.00 285,000.00 300,000.00 - - 100.00% 101-555612.1 Bond-GO Refunding 2010 Interest 29,700.00 4,500.00 21,375.00 4,500.00 - 25,200.00 15.15% 101-555629 GO Bond 2007-Principal 300,000.00 300,000.00 290,000.00 300,000.00 - - 100.00% 101-555629.1 GO Bond 2007-Interest 124,338.50 65,221.75 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 93,575.00 550,000.00 93,575.00 - 116,425.00 44.56% 101-555631.1 BO Bond SR2009 Interest 236,525.00 120,100.00 129,037.50 120,100.00 - 116,425.00 50.78% 101-555633 GO SR2011 Principal 250,000.00 250,000.00 240,000.00 250,000.00 - - 100.00% 101-555633.1 GO SR2011 Interest 318,462.50 161,418.75 165,618.75 161,418.75 - 157,043.75 50.69% 101-555634 GO SR2011A Refund Principal 485,000.00 485,000.00 635,000.00 485,000.00 - - 100.00% 101-555634.1 GO SR2011A Refund Interest 74,734.75 40,192.50 47,590.25 40,192.50 - 34,542.25 53.78% 101-555635 GO SR2012 Principal 345,000.00 345,000.00 335,000.00 345,000.00 - - 100.00% 101-555635.1 GO SR2012 Interest 157,945.00 80,697.50 87,397.50 80,697.50 - 77,247.50 51.09% 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,000.00 - - 100.00% 101-555638.1 Bond-GO 2014 Refund-Interest 286,775.00 144,137.50 145,637.50 144,137.50 - 142,637.50 50.26% 101-555639 Tax Note - SR2015 - Principal 35,000.00 - - - - 35,000.00 0.00% 101-555639.1 Tax Note - SR2015 - Interest 1,925.00 960.45 1,263.02 960.45 - 964.55 49.89% 101-555640 Bond-Ref 2015 Bond- Principal 150,000.00 660,000.00 490,000.00 660,000.00 - (510,000.00) 440.00% 101-555640.1 Bond-GO Ref 2015- Interest 9,317.00 43,912.50 48,812.50 43,912.50 - (34,595.50) 471.32% 101-555641 Tax Note - SR2015A - Principal 660,000.00 - - - - 660,000.00 0.00% 101-555641.1 Tax Note - SR2015A - Interest 81,225.00 4,608.88 5,731.58 4,608.88 - 76,616.12 5.67% 101-555642 GO Bond SR2016 Principal 215,000.00 215,000.00 205,000.00 215,000.00 - - 100.00% 101-555642.1 GO Bond SR2016 Interest 159,206.26 81,753.13 85,853.13 81,753.13 - 77,453.13 51.35% 101-555643 CO Bond Tax SR2016 Principal 175,000.00 55,000.00 55,000.00 55,000.00 - 120,000.00 31.43% 101-555643.1 CO Bond Tax SR2016 Interest 62,668.76 23,206.25 24,031.25 23,206.25 - 39,462.51 37.03% 101-555644 CO Bond nonTax SR2016 Principal 55,000.00 175,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: MARCH 31, 2019 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% 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: MARCH 31, 2019 101-555644 CO Bond nonTax SR2016 Interest 45,587.50 33,084.38 36,384.38 33,084.38 - 12,503.12 72.57% 101-555645 CO Bond SR2017 Principal 280,000.00 280,000.00 245,000.00 280,000.00 - - 100.00% 101-555645.1 CO Bond SR2017 Interest 139,025.00 71,612.50 107,075.56 71,612.50 - 67,412.50 51.51% 101-555646 Bond-GO SR2017 Principal 150,000.00 150,000.00 135,000.00 150,000.00 - - 100.00% 101-55646.1 Bond - GO SR2017 Interest 114,225.00 58,237.50 85,706.67 58,237.50 - 55,987.50 50.98% 101-555647 Bond-GO 2018 Refund Principal 550,000.00 - 550,000.00 - 101-555647.1 Bond - GO 2018 Refund Interest 122,112.00 63,971.00 - 63,971.00 - 58,141.00 52.39% 101-555648 Bond-CO SR2018 - Principal - - 210,000.00 101-555648.1 Bond-CO 2018 - Interest - - 118,569.80 101-555649 Bond-GO 2018 Ref - Principal - - 95,000.00 101-555649.1 Bond-GO 2018 Ref - Interest - - 72,637.60 101-555900 Debt Service 424,951.00 - - - - 424,951.00 0.00% TOTAL Debt Service 6,648,723.27 4,406,189.59 5,815,642.93 5,452,396.99 - 1,692,533.68 82.01% TOTAL EXPENDITURES 6,653,723.27 4,407,989.59 5,817,792.93 5,454,746.99 - 1,692,533.68 81.98% Cash in Bank Claim on Operating Cash Pool-Checking 261,462.90$ MBIA Investment- Tax I&S 1,755,849.00 Total Cash in Bank & Investments 2,017,311.90$ TAX I&S CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2019 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 4,242,580.00 1,026,115.17 2,009,296.10 2,000,475.72 - 2,242,104.28 47.15% Fund Transfers 1,249,164.00 - - - - 1,249,164.00 0.00% Miscellaneous 258,000.00 154,605.46 108,773.90 419,545.72 - (161,545.72) 162.61% TOTAL REVENUES 5,749,744.00 1,180,720.63 2,118,070.00 2,420,021.44 - 3,329,722.56 42.09% 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 20.14 238.49 26.86 184.31 538.83 24.57% City Support Services 21,300.00 1,024.24 2,416.00 4,458.62 431.25 16,410.13 5.59% Utility Services 3,720.00 385.35 996.48 759.17 106.59 2,854.24 931.32% Operations Support 122,500.00 17,480.59 42,412.94 34,538.60 1,084.99 86,876.41 6.85% Staff Support 21,400.00 5,934.68 7,276.69 7,302.32 1,052.96 13,044.72 5.59% City Assistance 252,500.00 100.60 200,000.00 143.23 - 252,356.77 0.75% Professional Services 66,300.00 1,393.00 9,239.13 1,881.17 - 64,418.83 345.08% Fund Charges/Transfers 457,574.00 - 802,945.00 228,787.00 - 228,787.00 233.39% Maintenance Services 1,000.00 - 175.00 80.00 - 920.00 8.00% Operating Equipment 2,700.00 - 576.02 - 375.77 2,324.23 13.92% TOTAL ECONO DEVELOPMENT 949,744.00 26,338.60 1,066,275.75 277,976.97 3,235.87 668,531.16 29.61% TOTAL EXPENDITURES 5,749,744.00 26,338.60 1,066,275.75 277,976.97 3,235.87 5,468,531.16 4.89% ** REVENUE OVER(UNDER) EXPEND - 1,154,382.03 1,051,794.25 2,142,044.47 (3,235.87) (2,138,808.60) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2019 Cash in Bank Claim on Operating Cash Pool-Checking 664,321.45$ Cash in Investments Texas Class Investment-Economic Development Corp 16,475,559.61 Schertz Bank & Trust-Certificate of Deposit 1,033,016.49 Schertz Bank & Trust-Certificate of Deposit 1,074,743.41 Total Cash in Bank & Investments 19,247,640.96$ SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2019