Loading...
2023.08 Monthly Budget ReportDQf!�C�WARD MONTHLY BUDGET FINANCIAL STATUS UPDATE To: Mayor and Council members From: Noah Crocker, Finance Director Period: August 2023 OVERVIEW: The Finance Department is committed to providing clear information to the Mayor, Council, and staff regarding the budget status of the City. We have prepared the following reports to keep you up to date on the current budget status of the City. 1) Budget Report 2) Detail Fund Summary Report BUDGET REPORT: The Budget report will first provide Operational Funds and follow up with Capital Projects Funds. This report does not include beginning fund balance. This report is designed to provide a high-level view of each fund reviewing total revenues and expenses. The report does provide expense information by department. The goal of the City is to pay all current budget year expenses with current budget year revenues. We are not quite there yet, and this will show in the Surplus (Deficit) line at the end of each fund. We expect that future budget cycles will smooth out revenues and expenditures. The Budget Report provides information on current revenues and expenditures by fund including the following: • The original budgeted amount. • Current budget which would reflect any amendments that have been made. • Period activity which details the revenue and expense activity for the period in which the report was run. • Fiscal activity will provide the year-to-date expense and revenue amounts. • Variance Shows the difference between budgeted and actual. • Percent remaining is the amount still needed to reach the budgeted amount. CASH AND INVESTMENT FUND SUMMARY The Cash and Investment Fund Summary provides information on current total cash & investment balances by Fund. POINTS OF INTEREST: Current Expense Fund 001—The Current Expense Fund is used for the general governmental functions of the City. As of August 31, 2023, 62% of budgeted revenues were received. However, excluding Other financing from the calculation the city has collected 87% of budgeted revenues. The table provides budget versus actual (YTD) data by source of revenue. 2023 2023 Current % of Received Revenue Source Original Budget 2023 YTD Budget Property Tax 2,223,000 2,223,000 1,209,981 Received 54.43% PeriodBudget 8,359 Sales Tax 6,565,000 6,565,000 5,091,780 77.56% 725,037 Other Taxes 2,136, 000 2,136, 000 1,951,968 91.38% 138,073 Total Taxes 10,924,000 10,924,000 8,253,729 75.56% 871,470 Licenses & Permits 600,400 600,400 1,105,354 184.10% 149,940 Intergovernmental Revenue 432,500 476,800 519,073 108.87% - Charges for Goods & Services 448,600 448,600 579,937 129.28% 89,608 Fines & Penalties 128,000 128,000 72,904 56.96% 10,329 Misc Revenues 122,200 122,218 577,594 472.59% 93,100 Non -Revenues - - 2,218 #DIV/0! (374) Other Financing 0.03% (Capital Contributions) - 5,000,000 1,675 - REVENUE TOTALS 12,655,700 17,700,018 11,112,483 62.78% 1,214,073 SALES TAX REVENUES SUMMARY • Total 2023 Budget: $6,565,000 • Total 2023 YTD Actuals: $5,091,780 • Year -to -Date Actual revenue collected is 1.78% higher when compared to Prior Year -to Date Actuals • Year -to -Date Actual revenue collected is 19.67% higher when compared to Year -to Date Budgeted The following tables provide additional sales tax information: Table 1: shows revenue received by month over a three-year period. Monthly Sales Tax -Three Year Comparison 800,000 700,000 ■ 2021 Actual 600,000 ■ 2022 Actual ■ 2023 YTO Actual 500,000 400,000 300,000 200,000 100,000 0 ,J\J J�Jyc e��ec ooec Je�oec `e�oec � P c heQ �o Qe Table 2: provides current data for sales tax revenue collected Year-to-date. $800,000 Sales Tax Revenues $700,000 $600,000 $500,000 $400,000 Actuals2023 Budget 2023 $300,000 $200,000 $100,000 Q P yeQ�' �o Oe Real Estate Excise Tax (REET) Fund 109 and Impact Mitigation Fee Fund 111 The City's Real Estate Excise Tax receipts fluctuate monthly. August 2023 receipts are lower than August 2022 by 0.10%. The table below shows balances through August for REET 1 & 2 and Impact fees. These restricted funds are used as a local funding source for capital projects that have been documented in the City's comprehensive plans. REET funds are also used for debt payments. The table above shows 2023 beginning fund balances, biennial revenue received to date, expenses budgeted for the biennium and expenses which are obligated for future projects but have not yet been officially budgeted. The intent of this table is to snapshot and illustrate available balances and what is projected for the end of the biennium. Impact Fees received for August 2023 are as follows: o Parks $205,778 o Transportation $171,443 o School District Impact $50,837 REET revenues received in August: o REET 1 $86,286 o REET 2 $86,286 Capital Construction Fund 302 —The McCormick Woods Splash Pad Retrofit is nearing completion and at this time the project is waiting for a control panel to be delivered by end of September 2023. The City Hall construction has started in August with the Roof, siding, and windows. Street Capital Construction Fund 304 —Bay Street Pedestrian Path right of way efforts continue. The City has contracted with Skilling's Inc for Design and Right of Way Services for the Bethel -Lincoln Round -About project. Design for the project is in progress. ENTERPRISE/UTILITY FUNDS: Water operation - Water operations budgeted revenue in the amount of $3,712,000 for 2023. Through August, the City has received $2,660,116 or —72% of the 2023 budgeted revenues. Revenues for the water utility, in winter and spring, are typically lower with larger monthly revenues received during the warmer summer and fall months. Water Operations expended $1,990,614 through August representing —62% of the 2023 budget. In addition, the water operational budget includes transfers which occur throughout the year. The City manages its transfers according to policy goals, cashflow needs, and realized expenses for water capital projects, stabilization targets, and debt service payments. The 2023 budget includes $790,550 for transfers. A total of $177,663 was transferred out to fund 413 for Water Main Replacement expenses. 500,000 400,000 300,000 200,000 100,000 Water Service Payments Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ 2021 ■ 2022 ■ 2023 Sewer operation — Sewer operations budgeted revenue in the amount of $5,696,424 is budgeted for 2023. Through August, the City has received $4,319,776 or —76% of the 2023 budgeted revenues. Sewer Operations expended $2,848,703 through August representing —58% of the 2023 budget. The sewer operational expense budget includes transfers which occur throughout the year. The City manages its transfers according to policy goals, cashflow needs, and realized expenses for sewer capital projects, stabilization targets, and debt service payments. The 2023 budget includes $563,000 for transfers. A total of $666 was transferred out to fund 433 for Marina Pump Station expenses and close out of McCormick Sewer Lift Station #2. Sewer Service Payments 400,000 M M ■ ■ ■ r = = = ■ 2021 300,000 111111 ■ 2022 ■ 2023 200,000 i Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Storm Drainage operations- Storm Operations budgeted revenue in the amount of $1,745,100 for 2023. Through August, the City has received $1,428,900 or —82% of its annual budgeted revenue. Storm Drainage Operations expended $946,815 through August representing —47% of the 2023 operating budget. The storm drainage operational budget includes transfers which occur throughout the year. The City manages its transfers according to policy goals, cashflow needs, and realized expenses for storm capital projects, stabilization targets, and debt service payments. The 2023 budget includes $778,200 for transfers. A total of $146,300 was transferred out to fund 424 for LTGO Bond 2017 Storm Debt Payments. There were no transfers in August. Storm Drainage Payments 180,000 160,000 140,000 — 120,000 — 100,000 — ■ 2021 80,000 — ■ 2022 60,000 — ■ 2023 40,000 — 20,000 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Budget Report Departmen... Fund: 001- Current Expense Revenue 00 - Revenues Expense 01- Finance 02 - Court 03 - Law Enforcement 04 - Community Development 05 - Public Works 06 - Miscellaneous 07 - Administration OPERATING BUDGET For Fiscal: 2023 Period Ending: 08/31/2023 Group Summary Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 12,655,700.00 17,700,018.27 1,214,073.11 11,112,482.85-6,587,535.42 37.22% Revenue Total: 12,655,700.00 17,700,018.27 1,214,073.11 11,112,482.85-6,587,535.42 37.22% Expense Total: Fund: 001- Current Expense Surplus (Deficit): Fund: 002 - City Street Fund Revenue 00 - Revenues Revenue Total: 1,102,600.00 1,102,600.00 84,245.82 627,588.33 475,011.67 43.08% 742,800.00 742,800.00 40,999.84 345,911.78 396,888.22 53.43% 5,795,350.00 5,795,350.00 373,933.77 3,083,788.91 2,711,561.09 46.79% 2,448,085.00 2,957,885.00 162,752.57 1,771,602.42 1,186,282.58 40.11% 2,249,300.00 2,249,300.00 111,946.11 1,180,124.50 1,069,175.50 47.53% 6,290,000.00 10,835,500.00 398,543.06 717,635.53 10,117,864.47 93.38% 1,800,120.00 1,800,120.00 121,342.78 1,029,319.52 770,800.48 42.82% 20,428,255.00 25,483,555.00 1,293,763.95 8,755,970.99 16,727,584.01 65.64% -7,772,555.00 -7,783,536.73 -79,690.84 2,356,511.86 10,140,048.59 130.28% 3,553,504.00 3,879,528.35 148,979.99 1,579,852.52 -2,299,675.83 59.28% 3,553,504.00 3,879,528.35 148,979.99 1,579,852.52 -2,299,675.83 59.28% Expense 05 - Public Works 3,482,796.00 3,482,796.00 882,055.22 1,841,664.30 1,641,131.70 47.12% Expense Total: 3,482,796.00 3,482,796.00 882,055.22 1,841,664.30 1,641,131.70 47.12% Fund: 002 - City Street Fund Surplus (Deficit): 70,708.00 396,732.35 -733,075.23 -261,811.78 -658,544.13 165.99% Fund: 003 - Stabilization Fund Revenue 00 - Revenues 180,000.00 180,040.46 13,510.97 276,293.31 96,252.85 53.46% Revenue Total: 180,000.00 180,040.46 13,510.97 276,293.31 96,252.85 53.46% Fund: 003 - Stabilization Fund Total: 180,000.00 180,040.46 13,510.97 276,293.31 96,252.85 53.46% Fund: 103 - Criminal Justice Revenue 00 - Revenues 391,000.00 391,074.72 36,599.06 326,106.26 -64,968.46 16.61% Revenue Total: 391,000.00 391,074.72 36,599.06 326,106.26 -64,968.46 16.61% Expense 03 - Law Enforcement 629,900.00 629,900.00 9,410.90 301,695.82 328,204.18 52.10% Expense Total: 629,900.00 629,900.00 9,410.90 301,695.82 328,204.18 52.10% Fund: 103 - Criminal Justice Surplus (Deficit): -238,900.00 -238,825.28 27,188.16 24,410.44 263,235.72 110.22% Fund: 104 - Special Investigative Unit Revenue 00 - Revenues 4,000.00 4,004.54 278.02 2,105.41 -1,899.13 47.42% Revenue Total: 4,000.00 4,004.54 278.02 2,105.41 -1,899.13 47.42% Expense 03 - Law Enforcement 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00% Expense Total: 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00% Fund: 104 - Special Investigative Unit Surplus (Deficit): 0.00 4.54 278.02 2,105.41 2,100.8746,274.67% Fund: 107 - Community Events Revenue 00 - Revenues 125,200.00 125,219.81 16,989.04 109,968.75 -15,251.06 12.18% Revenue Total: 125,200.00 125,219.81 16,989.04 109,968.75 -15,251.06 12.18% Expense 07 - Administration 125,200.00 125,200.00 8,205.27 19,833.96 105,366.04 84.16% Expense Total: 125,200.00 125,200.00 8,205.27 19,833.96 105,366.04 84.16% Fund: 107 - Community Events Surplus (Deficit): 0.00 19.81 8,783.77 90,134.79 90,114.9854,896.42% 9/18/2023 11:38:41 AM Page 13 of 17 Budget Report For Fiscal: 2023 Period Ending: 08/31/2023 Variance Original Current Period Fiscal Favorable Percent Departmen... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 108 - Paths & Trails Revenue 00 - Revenues 1,000.00 1,015.93 183.38 1,294.53 278.60 27.42% Revenue Total: 1,000.00 1,015.93 183.38 1,294.53 278.60 27.42% Fund: 108 - Paths & Trails Total: 1,000.00 1,015.93 183.38 1,294.53 278.60 27.42% Fund: 109 - Real Estate Excise Tax Revenue 00 - Revenues 800,000.00 800,092.62 184,213.16 1,442,993.92 642,901.30 80.35% Revenue Total: 800,000.00 800,092.62 184,213.16 1,442,993.92 642,901.30 80.35% Expense 06 - Miscellaneous 3,854,500.00 3,716,485.39 326,585.71 532,993.65 3,183,491.74 85.66% Expense Total: 3,854,500.00 3,716,485.39 326,585.71 532,993.65 3,183,491.74 85.66% Fund: 109 - Real Estate Excise Tax Surplus (Deficit): -3,054,500.00 -2,916,392.77 -142,372.55 910,000.27 3,826,393.04 131.20% Fund: 111- Impact Mitigation Fee Revenue 00 - Revenues 5,669,300.00 5,669,344.72 459,829.35 3,959,447.12 -1,709,897.60 30.16% Revenue Total: 5,669,300.00 5,669,344.72 459,829.35 3,959,447.12 -1,709,897.60 30.16% Expense 06 - Miscellaneous 3,695,300.00 4,371,200.00 771,053.26 1,464,867.82 2,906,332.18 66.49% Expense Total: 3,695,300.00 4,371,200.00 771,053.26 1,464,867.82 2,906,332.18 66.49% Fund: 111- Impact Mitigation Fee Surplus (Deficit): 1,974,000.00 1,298,144.72 -311,223.91 2,494,579.30 1,196,434.58 -92.16% Fund: 206 - Bond Redemption Fund Revenue 00 - Revenues 300,400.00 300,400.00 271,701.14 299,652.28 -747.72 0.25% Revenue Total: 300,400.00 300,400.00 271,701.14 299,652.28 -747.72 0.25% Expense 06 - Miscellaneous 300,400.00 300,400.00 271,701.14 299,652.28 747.72 0.25% Expense Total: 300,400.00 300,400.00 271,701.14 299,652.28 747.72 0.25% Fund: 206 - Bond Redemption Fund Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00% Fund: 411- Water Operating Revenue 00 - Revenues 3,712,000.00 3,712,013.25 530,291.61 2,660,116.24 -1,051,897.01 28.34% Revenue Total: 3,712,000.00 3,712,013.25 530,291.61 2,660,116.24 -1,051,897.01 28.34% Expense 05 - Public Works 3,190,850.00 3,190,850.00 233,902.55 1,990,614.87 1,200,235.13 37.61% 06 - Miscellaneous 790,550.00 790,550.00 177,663.19 344,077.14 446,472.86 56.48% Expense Total: 3,981,400.00 3,981,400.00 411,565.74 2,334,692.01 1,646,707.99 41.36% Fund: 411- Water Operating Surplus (Deficit): Fund: 412 - Water Stabilization Revenue 00 - Revenues Revenue Total: Fund: 412 - Water Stabilization Total: Fund: 414 - Water Debt Service Revenue 00 - Revenues 563,400.00 563,400.00 0.00 54,196.19-509,203.81 90.38% Revenue Total: 563,400.00 563,400.00 0.00 54,196.19-509,203.81 90.38% -269,400.00-269,386.75 118,725.87 325,424.23 594,810.98 220.80% Expense 06 - Miscellaneous Expense Total Fund: 414 - Water Debt Service Surplus (Deficit) 0.00 93.84 4,509.37 32,353.71 32,259.87 34,377.53% 0.00 93.84 4,509.37 32,353.71 32,259.87 34,377.53% 0.00 93.84 4,509.37 32,353.71 32,259.87 34,377.53% 563,400.00 563,400.00 0.00 54,196.19 509,203.81 90.38% 563,400.00 563,400.00 0.00 54,196.19 509,203.81 90.38% 0.00 0.00 0.00 0.00 0.00 0.00% 9/18/2023 11:38:41 AM Page 14 of 17 Budget Report For Fiscal: 2023 Period Ending: 08/31/2023 Variance Original Current Period Fiscal Favorable Percent Departmen... Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 421- Storm Drainage Utility Revenue 00 - Revenues 1,745,100.00 1,745,181.61 210,684.87 1,428,900.55 -316,281.06 18.12% Revenue Total: 1,745,100.00 1,745,181.61 210,684.87 1,428,900.55 -316,281.06 18.12% Expense 05 - Public Works 2,030,852.00 2,030,852.00 109,106.58 946,815.70 1,084,036.30 53.38% 06 - Miscellaneous 778,200.00 378,200.00 146,500.61 236,669.06 141,530.94 37.42% Expense Total: 2,809,052.00 2,409,052.00 255,607.19 1,183,484.76 1,225,567.24 50.87% Fund: 421- Storm Drainage Utility Surplus (Deficit): -1,063,952.00 -663,870.39 -44,922.32 245,415.79 909,286.18 136.97% Fund: 422 - Storm Drainage Stabilization Revenue 00 - Revenues 0.00 33.58 2,533.55 18,177.64 18,144.06 54,032.34% Revenue Total: 0.00 33.58 2,533.55 18,177.64 18,144.0654,032.34% Fund: 422 - Storm Drainage Stabilization Total: 0.00 33.58 2,533.55 18,177.64 18,144.06 54,032.34% Fund: 424 - Storm Drainage Debt Service Revenue 00 - Revenues 178,200.00 178,200.00 146,300.61 177,876.54 -323.46 0.18% Revenue Total: 178,200.00 178,200.00 146,300.61 177,876.54 -323.46 0.18% Expense 06 - Miscellaneous 178,200.00 178,200.00 146,300.61 177,876.54 323.46 0.18% Expense Total: 178,200.00 178,200.00 146,300.61 177,876.54 323.46 0.18% Fund: 424 - Storm Drainage Debt Service Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00% Fund: 431- Sewer Operating Revenue 00 - Revenues 5,696,400.00 5,696,424.61 625,845.41 4,319,776.81 -1,376,647.80 24.17% Revenue Total: 5,696,400.00 5,696,424.61 625,845.41 4,319,776.81 -1,376,647.80 24.17% Expense 05 - Public Works 4,857,032.00 4,947,032.00 310,364.42 2,848,703.91 2,098,328.09 42.42% 06 - Miscellaneous 563,000.00 563,000.00 666.44 20,746.77 542,253.23 96.31% Expense Total: 5,420,032.00 5,510,032.00 311,030.86 2,869,450.68 2,640,581.32 47.92% Fund: 431- Sewer Operating Surplus (Deficit): 276,368.00 186,392.61 314,814.55 1,450,326.13 1,263,933.52-678.10% Fund: 432 - Sewer Stabilization Revenue 00 - Revenues 0.00 30.18 6,748.47 48,418.77 48,388.59 60,333.30% Revenue Total: 0.00 30.18 6,748.47 48,418.77 48,388.59 60,333.30% Fund: 432 - Sewer Stabilization Total: 0.00 30.18 6,748.47 48,418.77 48,388.59 60,333.30% Fund: 434 - Sewer Debt Service Revenue 00 - Revenues 298,700.00 298,721.67 2,607.79 36,056.66 -262,665.01 87.93% Revenue Total: 298,700.00 298,721.67 2,607.79 36,056.66 -262,665.01 87.93% Expense 06 - Miscellaneous 23,700.00 23,700.00 0.00 17,346.30 6,353.70 26.81% Expense Total: 23,700.00 23,700.00 0.00 17,346.30 6,353.70 26.81% Fund: 434 - Sewer Debt Service Surplus (Deficit): 275,000.00 275,021.67 2,607.79 18,710.36 -256,311.31 93.20% Fund: 500 - Equipment Rental and Revolving Revenue 00 - Revenues 1,869,500.00 1,869,517.83 72,387.87 1,158,626.00 -710,891.83 38.03% Revenue Total: 1,869,500.00 1,869,517.83 72,387.87 1,158,626.00 -710,891.83 38.03% Expense 10 - ER&R 4,064,700.00 4,064,700.00 191,329.57 727,448.89 3,337,251.11 82.10% 9/18/2023 11:38:41 AM Page 15 of 17 Budget Report Departmen... For Fiscal: 2023 Period Ending: 08/31/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining Expense Total: 4,064,700.00 4p064?700.00 Fund: 500 - Equipment Rental and Revolving Surplus (Deficit):-2,195,200.00-2,195,182.17 Report Surplus (Deficit):-11,817,431.00-11,729,664.40 191,329.57 727,448.89 3,337,251.11 82.10% -118,941.70 431,177.11 2,626,359.28 119.64% -930,342.65 8,463,521.87 20,193,186.27 172.15% 9/18/2023 11:38:41 AM Page 16 of 17 City of Port Orchard ORCHARD Account Typ... Fund: 302 - Capital Construction CAPITAL BUDGET Original Current Total Budget Total Budget Budget Report Group Summary For Fiscal: 2023 Period Ending: 08/31/2023 Variance Period Fiscal Favorable Percent Activity Activity (Unfavorable) Remaining Revenue 2,053,500.00 18,854,600.00 1,025,076.88 1,393,668.57 -17,460,931.43 92.61% Expense 1,808,400.00 18,261,400.00 1,078,095.20 1,756,670.33 16,504,729.67 90.38% Fund: 302 - Capital Construction Surplus (Deficit): 245,100.00 593,200.00 -53,018.32 -363,001.76 -956,201.76 161.19% Fund: 304 - Street Capital Projects Revenue 13,478,100.00 14,660,000.00 283,612.26 753,298.24 -13,906,701.76 94.86% Expense 12,095,700.00 11,938,820.12 235,175.73 715,085.10 11,223,735.02 94.01% Fund: 304 - Street Capital Projects Surplus (Deficit): 1,382,400.00 2,721,179.88 48,436.53 38,213.14 -2,682,966.74 98.60% Fund: 413 - Water Capital Revenue 16,450,700.00 20,188,100.00 448,441.01 2,112,145.42 -18,075,954.58 89.54% Expense 10,540,600.00 10,540,600.00 215,731.67 503,245.52 10,037,354.48 95.23% Fund: 413 - Water Capital Surplus (Deficit): 5,910,100.00 9,647,500.00 232,709.34 1,608,899.90 -8,038,600.10 83.32% Fund: 423 - Storm Drainage Capital Facil Revenue 1,194,500.00 793,200.00 451.63 62,684.56 -730,515.44 92.10% Expense 1,100,000.00 700,000.00 0.00 555,792.52 144,207.48 20.60% Fund: 423 - Storm Drainage Capital Facil Surplus (Deficit): 94,500.00 93,200.00 451.63 -493,107.96 -586,307.96 629.09% Fund: 433 - Sewer Capital Revenue 25,532,700.00 25,959,700.00 417,026.27 2,536,762.45 -23,422,937.55 90.23% Expense 14,632,900.00 14,632,900.00 85,272.47 556,077.31 14,076,822.69 96.20% Fund: 433 - Sewer Capital Surplus (Deficit): 10,899,800.00 11,326,800.00 331,753.80 1,980,685.14 -9,346,114.86 82.51% Report Surplus (Deficit): 18,531,900.00 24,381,879.88 560,332.98 2,771,688.46 -21,610,191.42 88.63% 9/18/2023 12:49:05 PM Page 1 of 2 Detail Report 9/18/2023 12:17:52 PM CASH & INVESTMENT Fund Beginning Balance Total Activity Ending Balance 001- Current Expense 16,744,958.97 -79,690.84 16,665,268.13 002 - City Street Fund 3,242,431.10 -733,075.23 2,509,355.87 003 - Stabilization Fund 3,003,741.88 13,510.97 3,017,252.85 103 - Criminal Justice 644,947.56 27,188.16 672,135.72 104 - Special Investigative Unit 99,722.85 278.02 100,000.87 107 - Community Events 403,131.21 8,783.77 411,914.98 108 - Paths & Trails 14,895.22 183.38 15,078.60 109 - Real Estate Excise Tax 5,235,080.20 -142,372.55 5,092,707.65 111- Impact Mitigation Fee 8,110,358.49 -311,223.91 7,799,134.58 206 - Bond Redemption Fund 0.00 0.00 0.00 302 - Capital Construction 237,647.66 -53,018.32 184,629.34 304 - Street Capital Projects 2,288,827.42 48,436.53 2,337,263.95 401- Water -Sewer Utilities 0.00 0.00 0.00 403 - Water -Sewer Cumulative Reserve 0.00 0.00 0.00 411- Water Operating 4,337,566.93 118,725.87 4,456,292.80 412 - Water Stabilization 994,250.50 4,509.37 998 759.87 413 - Water Capital 8,935,131.85 232,709.34 9,167,841.19 414 - Water Debt Service 0.00 0.00 0.00 421- Storm Drainage Utility 1,701,056.50 -44,922.32 1,656,134.18 422 - Storm Drainage Stabilization 558,610.51 2,533.55 561,144.06 423 - Storm Drainage Capital Facil 99,577.84 451.63 100,029.47 424 - Storm Drainage Debt Service 0.00 0.00 0.00 431- Sewer Operating 7,044,186.97 314,814.55 7,359,001.52 432 - Sewer Stabilization 1,487,940.12 6,748.47 1,494,688.59 433 - Sewer Capital 7,431,687.81 331,753.80 7,763,441.61 434 - Sewer Debt Service 574,980.90 2,607.79 577,588.69 500 - Equipment Rental and Revolving 4,540,200.98 -118,941.70 4,421,259.28 631- Trust and Agency 10,676.57 878.04 11,554.61 632 - Wastewater Treatment Facil Fee 5,792,783.29 -48,680.24 5,744,103.05 Grand Total: 83,534,393.33 -417,811.87 83,116,581.46 Date Range: 08/01/2023 - 08/31/2023 Fund Summary Page 5 of 5