Loading...
HomeMy WebLinkAbout07 2023Page 1 of 7 OVERVIEW This monthly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through July 31, 2023. A detailed analysis, including budget to actual comparison, will be prepared quarterly in accordance with the City’s financial management policies. GENERAL FUND The General Fund is used to account for resources that are not generally dedicated for a specific purpose. The General Fund is used to meet the basic services that the City provides including, but not limited to, police protection, parks and recreation, human services, municipal court, street maintenance and planning, economic development, and administrative functions. The table below displays the year-to-date revenues and expenditures for the General Fund. Economic Development and Operating reserves are established internally in accordance with the City’s Policy on Stabilization Funds, as outlined in the 2023-2024 Adopted Budget. General REVENUES: Taxes 66,839,346$ Licenses and permits 4,186,460 Grants / intergovernmental 3,229,349 Charges for services 6,343,591 Fines and penalties 2,248,699 Miscellaneous 1,256,954 Investment Earnings 1,699,681 Insurance recoveries 17,423 TOTAL REVENUES 85,821,503 EXPENDITURES: Personnel 42,224,162 Supplies 1,312,901 Contracted Services 12,503,759 Capital Outlay 120,634 Internal Services 10,245,367 TOTAL EXPENDITURES 66,406,823 Transfers In - Transfers Out (15,539) NET TRANSFERS (15,539) CHANGE IN FUND BALANCE 19,399,141 BEGINNING FUND BALANCE, Jan 1 83,605,978 Prior Period Adjustment 25,925 BEGINNING FUND BALANCE, Jan 1 - restated 83,631,903 ENDING FUND BALANCE, Jul 31 103,031,044$ ECONOMIC DEVELOPMENT RESERVE 2,500,000 OPERATING RESERVES 13,585,276 AVAILABLE FUND BALANCE, Jul 31 86,945,768$ Monthly Financial Report July 2023 Monthly Financial Report City of Renton, Washington July 2023 Page 2 of 7 DEBT SERVICE FUND Debt service funds are used to account for the accumulation of resources for the payment of principal and interest related to the City’s general obligation bond issues. The table below displays the year-to-date revenues and expenditures for the City’s debt service fund. Debt service reserves are established internally in accordance with the City’s Policy on Stabilization Funds, as outlined in the 2023-2024 Adopted Budget. General Governmental Misc Debt REVENUES: Grants / intergovernmental 38,319$ Investment Earnings 84,478 TOTAL REVENUES 122,797 EXPENDITURES: Principal 2,748,188 Interest 603,764 TOTAL EXPENDITURES 3,351,952 Transfers In 2,595,376 NET TRANSFERS 2,595,376 CHANGE IN FUND BALANCE (633,779) BEGINNING FUND BALANCE, Jan 1 5,262,665 ENDING FUND BALANCE, Jul 31 4,628,886$ Debt Service Reserve 2,711,725 AVAILABLE FUND BALANCE 1,917,161$ Monthly Financial Report City of Renton, Washington July 2023 Page 3 of 7 SPECIAL REVENUE FUNDS Special revenue funds are used to account for revenues that are to be used for a specific purpose as required by law or legislative action. The table below displays the year-to-date revenues and expenditures for the City’s special revenue funds. CAPITAL PROJECT FUNDS Capital project funds are used to account for the acquisition and construction of major capital facilities and equipment. The table below displays the year-to-date revenues and expenditures for the City’s capital project funds. Hotel-Motel Tax Cable Communications Housing and Supportive Services Springbrook Wetlands Fire Impact Mitigation School District Impact Mitigation Police Seizure Police CSAM Seizure REVENUES: Taxes 268,055$ -$ 2,511,212$ -$ -$ -$ -$ -$ Licenses and permits - 41,047 - - - - - - Grants / intergovernmental - - - 4,011 - - - - Charges for services - - - - 30,246 133,198 - - Fines and penalties - - - - - - - 490 Contributions - - - - - - 106,159 - Investment Earnings 13,537 7,509 122,513 8,972 30,951 305 6,313 2,858 Sale of Fixed Assets - - - 247,852 - - - - TOTAL REVENUES 281,592 48,556 2,633,725 260,835 61,197 133,503 112,472 3,348 EXPENDITURES: Personnel - - - 6,281 - - - - Supplies - 45,738 - - - - 28,950 - Contracted Services 100,889 71,281 23,500 4,132 189,178 122,127 28,673 4,544 TOTAL EXPENDITURES 100,889 117,019 23,500 10,413 189,178 122,127 57,623 4,544 - Transfers In - - - - - - - - Transfers Out - - - - (2,595,376) - - - NET TRANSFERS - - - - (2,595,376) - - - CHANGE IN FUND BALANCE 180,703 (68,463) 2,610,225 250,422 (2,723,357) 11,376 54,849 (1,196) BEGINNING FUND BALANCE, Jan 1 712,384 453,147 6,110,390 454,628 2,724,187 - 339,814 172,804 Prior Period Adjustment - - - - - - - - BEGINNING FUND BALANCE, Jan 1 - restated 712,384 453,147 6,110,390 454,628 2,724,187 - 339,814 172,804 ENDING FUND BALANCE, Jul 31 893,087$ 384,684$ 8,720,615$ 705,050$ 830$ 11,376$ 394,663$ 171,608$ CS Impact Mitigation Transportation Impact Mitigation REET 1 REET 2 Municipal Facilities CIP Capital Investment Family First Center REVENUES: Taxes -$ -$ 1,369,943$ 1,369,943$ -$ -$ -$ Grants / intergovernmental - - - - 2,239,577 5,846,628 20,000 Charges for services 81,102 528,126 - - 21,245 9,862 - Contributions - - - - - 211,489 2,980,000 Investment Earnings 27,558 121,190 59,622 109,480 350,909 240,002 42,691 TOTAL REVENUES 108,660 649,316 1,429,565 1,479,423 2,611,731 6,307,981 3,042,691 EXPENDITURES: Personnel - - - - 30,174 43,847 - Supplies - - - - - 51,938 - Contracted Services - - - - 346,851 80,808 - Capital Outlay - - - - 10,767,235 6,614,653 2,083,877 TOTAL EXPENDITURES - - - - 11,144,260 6,791,246 2,083,877 Transfers In - - - - - - - Transfers Out - - - - - - - NET TRANSFERS - - - - - - - CHANGE IN FUND BALANCE 108,660 649,316 1,429,565 1,479,423 (8,532,529) (483,265) 958,814 BEGINNING FUND BALANCE, Jan 1 1,595,389 6,964,011 3,049,711 6,019,961 24,671,384 12,561,975 2,795,295 Prior Period Adjustment - - - - - - - BEGINNING FUND BALANCE, Jan 1 - restated 1,595,389 6,964,011 3,049,711 6,019,961 24,671,384 12,561,975 2,795,295 ENDING FUND BALANCE, Jul 31 1,704,049$ 7,613,327$ 4,479,276$ 7,499,384$ 16,138,855$ 12,078,710$ 3,754,109$ Monthly Financial Report City of Renton, Washington July 2023 Page 4 of 7 ENTERPRISE FUNDS Enterprise funds are used to account for operations that are financed and operated in a manner similar to private business enterprises. The table below displays the year-to-date revenues and expenses of the City’s enterprise funds. Amounts restricted for debt service are in accordance with revenue bond requirements. Operating reserves are established internally in accordance with the City’s Policy on Stabilization Funds, as outlined in the 2023-2024 Adopted Budget. Airport Solid Waste Utility Golf Course Water Utility Wastewater Utility Metro Surface Water Utility REVENUES: Licenses and permits -$ -$ -$ -$ 38,525$ -$ 16,125$ Grants / intergovernmental 149,837 165,834 - 623,720 - - 1,265,143 Charges for services 3,654,063 13,633,140 1,830,335 10,121,781 7,019,011 11,801,468 7,952,827 Rents, leases, and misc fees - - 354,558 190,249 - - - Interest and other misc 162,639 66,596 33,722 1,251,172 782,701 103,709 1,361,567 TOTAL REVENUES 3,966,539 13,865,570 2,218,615 12,186,922 7,840,237 11,905,177 10,595,662 EXPENSES: Personnel 653,597 328,611 1,034,734 2,747,407 1,419,368 - 2,274,244 Supplies 44,799 10,083 269,239 562,775 89,842 - 71,916 Contracted Services 290,381 12,838,191 94,481 1,820,005 1,401,665 11,824,722 961,603 Internal Services 222,848 263,508 234,167 1,470,285 999,594 - 1,494,860 TOTAL OPERATING EXPENSES 1,211,625 13,440,393 1,632,621 6,600,472 3,910,469 11,824,722 4,802,623 CAPITAL, AND TRANSFERS 2,754,914 425,177 585,994 5,586,450 3,929,768 80,455 5,793,039 DEBT SERVICE: Principal - - 25,925 272,647 - - - Interest - - 1,035 83,511 36,575 - 45,117 TOTAL DEBT SERVICE - - 26,960 356,158 36,575 - 45,117 CAPITAL OUTLAY 694,110 - 291,162 2,791,367 728,638 - 933,280 Transfers In - - 77,500 - - - - Transfers Out - - (77,500) (861) - - - NET TRANSFERS - - - (861) - - - CHANGE IN FUND BALANCE 2,060,804 425,177 267,872 2,438,064 3,164,555 80,455 4,814,642 BEGINNING FUND BALANCE, Jan 1 8,925,689 3,951,191 1,609,927 48,208,077 22,850,871 6,237,142 28,314,756 ENDING FUND BALANCE, Jul 31 10,986,493$ 4,376,368$ 1,877,799$ 50,646,141$ 26,015,426$ 6,317,597$ 33,129,398$ Restricted for Debt Service - - - 1,394,051 661,227 - 754,868 Operating Reserve 244,162 400,000 787,490 1,706,759 975,361 380,000 1,245,213 AVAILABLE FUND BALANCE 10,742,331$ 3,976,368$ 1,090,309$ 47,545,331$ 24,378,838$ 5,937,597$ 31,129,317$ Monthly Financial Report City of Renton, Washington July 2023 Page 5 of 7 INTERNAL SERVICE FUNDS Internal service funds are used to account for the goods and services furnished by one City department to other City departments on a cost reimbursement basis. The table below displays the year-to-date revenues and expenses of the City’s internal service funds. Insurance reserves for the Healthcare Fund are established at a rate of 31% of current year budgeted expenses. 100% of the Retiree Healthcare fund balance is reserved for OPEB. Equipment Rental Insurance Information Technology Facilities Communications Healthcare Retiree Healthcare REVENUES: Technology Fee -$ -$ 133,800$ -$ -$ -$ -$ Equipment rental m&o 1,659,986 - 3,677,798 - - - - Print and mail - - - - 255,569 - - Communications - - - - 540,581 - - Facilities - - - 3,408,314 - - - Interest and other misc 221,379 385,917 133,465 10,142 6,375 127,823 335,704 Internal service fund misc: Vehicle / equipment capital recovery 1,661,609 - - - - - - Insurance premiums - 1,442,089 - - - - - Worker's comp/unemployment - 1,022,148 - - - - - Benefit premiums - - - - - 7,734,379 912,500 Other misc 695 9,912 11,454 56,432 - 265,266 87,092 Insurance recoveries 41,181 196,626 - - - 2,141 - TOTAL REVENUES 3,584,850 3,056,692 3,956,517 3,474,888 802,525 8,129,609 1,335,296 EXPENSES: Personnel 672,519 850,301 1,925,067 2,110,287 555,105 7,063,638 748,686 Supplies 968,331 - 215,373 581,719 29,365 2,200 - Contracted Services 223,186 2,490,351 1,992,364 987,690 181,567 290,102 44,594 Internal Services 65,682 - 3,269 136,543 2,348 51,876 - TOTAL OPERATING EXPENSES 1,929,718 3,340,652 4,136,073 3,816,239 768,385 7,407,816 793,280 AMOUNT AVAILABLE FOR DEBT SERVICE, CAPITAL, AND TRANSFERS 1,655,132 (283,960) (179,556) (341,351) 34,140 721,793 542,016 TOTAL DEBT SERVICE - - - - - - - CAPITAL OUTLAY 1,744,178 - 962,859 18,731 - - - Transfers In - - 70,766 - - - - Transfers Out - (54,366) - - - - - NET TRANSFERS - (54,366) 70,766 - - - - CHANGE IN FUND BALANCE (89,046) (338,326) (1,071,649) (360,082) 34,140 721,793 542,016 BEGINNING FUND BALANCE, Jan 1 13,277,635 23,221,020 9,021,343 937,922 428,724 6,935,644 19,928,792 ENDING FUND BALANCE, Jul 31 13,188,589$ 22,882,694$ 7,949,694$ 577,840$ 462,864$ 7,657,437$ 20,470,808$ Insurance Reserves - 16,897,915 - - - 4,559,148 20,470,808 Opearting Reserves 13,188,589 - 2,326,091 - - - - AVAILABLE FUND BALANCE -$ 5,984,779$ 5,623,603$ 577,840$ 462,864$ 3,098,289$ -$ Monthly Financial Report City of Renton, Washington July 2023 Page 6 of 7 FIDUCIARY FUNDS Fiduciary funds are used to account for assets held by the City in a trustee capacity. These assets are not available for City use as they are not City assets. The table below displays year-to-date revenues and expenditures of the City’s fiduciary funds. Firemens' Pension Custodial Fund REVENUES: Intergovernmental 199,567$ -$ Investment Earnings 137,851 - Collected for Others - 1,393,023 TOTAL REVENUES 337,418 1,393,023 EXPENDITURES: Distributions to Others 146,360 993,283 TOTAL EXPENDITURES 146,360 993,283 NET TRANSFERS - - CHANGE IN FUND BALANCE 191,058 399,740 BEGINNING FUND BALANCE, Jan 1 8,733,791 - ENDING FUND BALANCE, Jul 31 8,924,849$ 399,740$ Monthly Financial Report City of Renton, Washington July 2023 Page 7 of 7 CONTACT INFORMATION This report is prepared by the Finance Department. For additional financial information, please also review our website: http://www.rentonwa.gov/. For any questions about the report, please feel free to contact Nate Malone nmalone@rentonwa.gov or Kristin Trivelas ktrivelas@rentonwa.gov . City of Renton All Funds - Revenue, Expenditures and Fund Balances Budgetary Basis through July 31, 2023 Funds Balance 01/01/2022 Budgeted Revenue Revenue 07/31/23 Total Funds Available Budgeted Expenditure Expenditure 07/31/23 Ending Balance GENERAL FUND 83,605,978 133,148,027 85,847,428 169,453,406 138,565,955 66,422,362 103,031,044 SPECIAL REVENUE FUNDS:10,967,354 5,152,674 3,535,228 14,502,582 5,642,007 3,220,669 11,281,913 110 Hotel Motel 712,384 200,000 281,592 993,976 454,616 100,889 893,087 127 Cable Communication 453,147 57,674 48,556 501,703 255,586 117,019 384,684 130 Housing and Supportive Services 6,110,390 3,500,000 2,633,725 8,744,115 260,000 23,500 8,720,615 135 Springbrook Wetlands Bank 454,628 - 260,835 715,463 40,000 10,413 705,050 140 Police Seizure 339,814 - 112,472 452,286 339,814 57,623 394,663 141 Police CSAM Seizure 172,804 - 3,348 176,152 172,804 4,544 171,608 31X School District Impact Mitigation - 995,000 133,503 133,503 995,000 122,127 11,376 304 Fire Mitigation 2,724,187 400,000 61,197 2,785,384 3,124,187 2,784,554 830 DEBT SERVICE FUND 5,262,665 5,755,022 2,718,173 7,980,838 5,565,690 3,351,952 4,628,886 CAPITAL PROJECT FUNDS (CIP):57,657,726 63,242,649 15,629,367 73,287,093 107,866,332 20,019,383 53,267,710 303 Community Services Mitigation 1,595,389 86,500 108,660 1,704,049 1,090,000 - 1,704,049 305 Transportation Mitigation 6,964,011 1,780,000 649,316 7,613,327 5,817,897 - 7,613,327 308 REET1 3,049,711 2,300,000 1,429,565 4,479,276 3,500,000 - 4,479,276 309 REET2 6,019,961 2,300,000 1,479,423 7,499,384 5,403,625 - 7,499,384 316 Municipal Facilities CIP 24,671,384 10,441,251 2,611,731 27,283,115 35,030,341 11,144,260 16,138,855 317 Transportation CIP 12,561,975 41,712,746 6,307,981 18,869,956 53,190,642 6,791,246 12,078,710 346 New Family First Center Dvlpmnt 2,795,295 4,622,152 3,042,691 5,837,986 3,833,827 2,083,877 3,754,109 ENTERPRISE FUNDS:120,097,653 113,328,675 62,656,222 182,753,875 179,033,479 49,404,653 133,349,222 4X2 Airport Operating & CIP 8,925,689 4,531,000 3,966,539 12,892,228 9,546,030 1,905,735 10,986,493 403 Solid Waste Utility 3,951,191 25,533,751 13,865,570 17,816,761 25,980,244 13,440,393 4,376,368 4X4 Golf Operating & CIP 1,609,927 3,504,825 2,296,115 3,906,042 3,853,974 2,028,243 1,877,799 4X5 Water Operating & CIP 48,208,077 20,789,505 12,186,922 60,394,999 52,379,968 9,748,858 50,646,141 4X6 Waste Water Operating & CIP 22,850,871 12,064,965 7,840,237 30,691,108 25,445,102 4,675,682 26,015,426 416 King County Metro 6,237,142 19,358,929 11,905,177 18,142,319 20,173,811 11,824,722 6,317,597 4X7 Surface Water Operating & CIP 28,314,756 27,545,700 10,595,662 38,910,418 41,654,350 5,781,020 33,129,398 INTERNAL SERVICE FUNDS:73,751,080 50,607,131 24,411,143 98,162,223 56,678,469 24,972,297 73,189,926 501 Equipment Repair/Replacement 13,277,635 9,885,963 3,584,850 16,862,485 9,812,590 3,673,896 13,188,589 502 Insurance 23,221,020 4,997,328 3,056,692 26,277,712 7,358,743 3,395,018 22,882,694 503 Information Services 9,021,343 8,830,085 4,027,283 13,048,626 13,962,728 5,098,932 7,949,694 504 Facilities 937,922 7,142,137 3,474,888 4,412,810 7,265,712 3,834,970 577,840 505 Communications 428,724 1,593,402 802,525 1,231,249 1,711,701 768,385 462,864 512 Insurance, Healthcare 6,935,644 16,123,216 8,129,609 15,065,253 15,197,161 7,407,816 7,657,437 522 Insurance, Leoff1 Retirees HC 19,928,792 2,035,000 1,335,296 21,264,088 1,369,834 793,280 20,470,808 FIDUCIARY FUNDS:8,733,791 400,000 1,730,441 10,464,232 253,475 1,139,643 9,324,589 611 Firemens' Pension 8,733,791 400,000 337,418 9,071,209 253,475 146,360 8,924,849 630 Custodial Fund - - 1,393,023 1,393,023 - 993,283 399,740 TOTAL FUNDS 360,076,247 371,634,178 196,528,002 556,604,249 493,605,407 168,530,959 388,073,290