HomeMy WebLinkAbout06 2023Page 1 of 7
OVERVIEW
This monthly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through June 30, 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 56,713,145$
Licenses and permits 3,908,209
Grants / intergovernmental 2,489,902
Charges for services 5,503,578
Fines and penalties 1,971,551
Miscellaneous 1,085,806
Investment Earnings 1,401,575
Insurance recoveries 17,423
TOTAL REVENUES 73,091,189
EXPENDITURES:
Personnel 35,961,289
Supplies 1,141,186
Contracted Services 10,213,027
Capital Outlay 120,634
Internal Services 10,245,367
TOTAL EXPENDITURES 57,681,503
Transfers In -
Transfers Out (15,539)
NET TRANSFERS (15,539)
CHANGE IN FUND BALANCE 15,394,147
BEGINNING FUND BALANCE, Jan 1 83,605,978
Prior Period Adjustment 22,212
BEGINNING FUND BALANCE, Jan 1 - restated 83,628,190
ENDING FUND BALANCE, Jun 30 99,022,337$
ECONOMIC DEVELOPMENT RESERVE 2,500,000
OPERATING RESERVES 13,585,276
AVAILABLE FUND BALANCE, Jun 30 82,937,061$
Monthly Financial Report June 2023
Monthly Financial Report City of Renton, Washington June 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 71,646
TOTAL REVENUES 109,965
EXPENDITURES:
Principal 2,533,188
Interest 582,995
TOTAL EXPENDITURES 3,116,183
Transfers In 2,595,376
NET TRANSFERS 2,595,376
CHANGE IN FUND BALANCE (410,842)
BEGINNING FUND BALANCE, Jan 1 5,262,665
ENDING FUND BALANCE, Jun 30 4,851,823$
Debt Service Reserve 2,711,725
AVAILABLE FUND BALANCE 2,140,098$
Monthly Financial Report City of Renton, Washington June 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 217,060$ -$ 2,142,926$ -$ -$ -$ -$ -$
Licenses and permits - 27,949 - - - - - -
Grants / intergovernmental - - - 4,011 - - - -
Charges for services - - - - 29,416 121,821 - -
Fines and penalties - - - - - - - 490
Contributions - - - - - - 106,159 -
Investment Earnings 11,200 6,331 99,320 7,015 30,951 306 5,117 2,382
Sale of Fixed Assets - - - 247,852 - - - -
TOTAL REVENUES 228,260 34,280 2,242,246 258,878 60,367 122,127 111,276 2,872
EXPENDITURES:
Personnel - - - 6,142 - - - -
Supplies - 21,238 - - - - 448 -
Contracted Services 74,041 62,023 15,000 4,131 187,519 116,195 20,625 4,544
TOTAL EXPENDITURES 74,041 83,261 15,000 10,273 187,519 116,195 21,073 4,544
-
Transfers In - - - - - - - -
Transfers Out - - - - (2,595,376) - - -
NET TRANSFERS - - - - (2,595,376) - - -
CHANGE IN FUND BALANCE 154,219 (48,981) 2,227,246 248,605 (2,722,528) 5,932 90,203 (1,672)
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, Jun 30 866,603$ 404,166$ 8,337,636$ 703,233$ 1,659$ 5,932$ 430,017$ 171,132$
CS Impact
Mitigation
Transportation
Impact
Mitigation REET 1 REET 2
Municipal
Facilities CIP
Capital
Investment
Family First
Center
REVENUES:
Taxes -$ -$ 1,053,793$ 1,053,792$ -$ -$ -$
Grants / intergovernmental - - - - 1,807,815 3,735,568 20,000
Charges for services 77,825 515,918 - - 21,246 9,862 -
Contributions - - - - - 200,000 2,980,000
Investment Earnings 22,836 100,082 48,078 89,563 306,052 205,564 32,260
TOTAL REVENUES 100,661 616,000 1,101,871 1,143,355 2,135,113 4,150,994 3,032,260
EXPENDITURES:
Personnel - - - - 26,719 43,117 -
Supplies - - - - - 28,455 -
Contracted Services - - - - 278,516 74,308 -
Capital Outlay - - - - 9,590,339 4,261,494 2,014,827
TOTAL EXPENDITURES - - - - 9,895,574 4,407,374 2,014,827
Transfers In - - - - - - -
Transfers Out - - - - - - -
NET TRANSFERS - - - - - - -
CHANGE IN FUND BALANCE 100,661 616,000 1,101,871 1,143,355 (7,760,461) (256,380) 1,017,433
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, Jun 30 1,696,050$ 7,580,011$ 4,151,582$ 7,163,316$ 16,910,923$ 12,305,595$ 3,812,728$
Monthly Financial Report City of Renton, Washington June 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 -$ -$ -$ -$ 35,900$ -$ 16,125$
Grants / intergovernmental 29,954 165,834 - 38,125 - - 1,265,143
Charges for services 3,248,675 12,348,401 1,418,493 8,190,725 5,985,098 10,031,792 6,740,212
Rents, leases, and misc fees - - 271,148 160,422 - - -
Interest and other misc 132,151 51,249 27,710 1,106,874 700,985 86,355 1,268,398
TOTAL REVENUES 3,410,780 12,565,484 1,717,351 9,496,146 6,721,983 10,118,147 9,289,878
EXPENSES:
Personnel 559,664 276,290 872,151 2,343,501 1,215,980 - 1,939,205
Supplies 41,413 9,616 238,038 470,379 78,570 - 65,626
Contracted Services 222,917 10,154,501 77,309 1,502,090 1,194,257 10,129,590 763,844
Internal Services 222,848 263,508 234,167 1,470,285 999,594 - 1,494,860
TOTAL OPERATING EXPENSES 1,046,842 10,703,915 1,421,665 5,786,255 3,488,401 10,129,590 4,263,535
CAPITAL, AND TRANSFERS 2,363,938 1,861,569 295,686 3,709,891 3,233,582 (11,443) 5,026,343
DEBT SERVICE:
Principal - - 22,212 272,647 - - -
Interest - - 896 83,511 36,575 - 45,117
TOTAL DEBT SERVICE - - 23,108 356,158 36,575 - 45,117
CAPITAL OUTLAY 290,891 - 16,462 2,322,625 469,552 - 728,592
Transfers In - - 77,500 - - - -
Transfers Out - - (77,500) (861) - - -
NET TRANSFERS - - - (861) - - -
CHANGE IN FUND BALANCE 2,073,047 1,861,569 256,116 1,030,247 2,727,455 (11,443) 4,252,634
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, Jun 30 10,998,736$ 5,812,760$ 1,866,043$ 49,238,324$ 25,578,326$ 6,225,699$ 32,567,390$
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,754,574$ 5,412,760$ 1,078,553$ 46,137,514$ 23,941,738$ 5,845,699$ 30,567,309$
Monthly Financial Report City of Renton, Washington June 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 -$ -$ 122,644$ -$ -$ -$ -$
Equipment rental m&o 1,653,515 - 3,677,798 - - - -
Print and mail - - - - 255,569 - -
Communications - - - - 540,581 - -
Facilities - - - 3,408,314 - - -
Interest and other misc 184,827 322,304 111,374 8,246 5,086 105,978 278,847
Internal service fund misc:
Vehicle / equipment capital recovery 1,661,609 - - - - - -
Insurance premiums - 1,442,089 - - - - -
Worker's comp/unemployment - 860,038 - - - - -
Benefit premiums - - - - - 6,630,422 912,500
Other misc 661 9,912 11,454 50,701 - 265,266 87,092
Insurance recoveries 30,568 195,938 - - - 2,141 -
TOTAL REVENUES 3,531,180 2,830,281 3,923,270 3,467,261 801,236 7,003,807 1,278,439
EXPENSES:
Personnel 577,290 713,648 1,659,348 1,796,509 474,394 6,156,834 656,644
Supplies 863,430 - 171,381 519,497 25,015 2,035 -
Contracted Services 207,500 1,107,987 1,698,390 824,787 161,375 240,164 38,123
Internal Services 65,682 - 3,269 136,543 2,348 51,876 -
TOTAL OPERATING EXPENSES 1,713,902 1,821,635 3,532,388 3,277,336 663,132 6,450,909 694,767
AMOUNT AVAILABLE FOR DEBT SERVICE,
CAPITAL, AND TRANSFERS 1,817,278 1,008,646 390,882 189,925 138,104 552,898 583,672
TOTAL DEBT SERVICE - - - - - - -
CAPITAL OUTLAY 1,705,389 - 946,430 7,550 - - -
Transfers In - - 16,400 - - - -
Transfers Out - - - - - - -
NET TRANSFERS - - 16,400 - - - -
CHANGE IN FUND BALANCE 111,889 1,008,646 (539,148) 182,375 138,104 552,898 583,672
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, Jun 30 13,389,524$ 24,229,666$ 8,482,195$ 1,120,297$ 566,828$ 7,488,542$ 20,512,464$
Insurance Reserves - 16,897,915 - - - 4,559,148 20,512,464
Opearting Reserves 13,351,008 - 2,326,091 - - - -
AVAILABLE FUND BALANCE 38,516$ 7,331,751$ 6,156,104$ 1,120,297$ 566,828$ 2,929,394$ -$
Monthly Financial Report City of Renton, Washington June 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,566$ -$
Investment Earnings 114,519 -
Collected for Others - 1,198,412
TOTAL REVENUES 314,085 1,198,412
EXPENDITURES:
Distributions to Others 162,889 589,574
TOTAL EXPENDITURES 125,002 589,574
NET TRANSFERS - -
CHANGE IN FUND BALANCE 189,083 608,838
BEGINNING FUND BALANCE, Jan 1 8,733,791 -
ENDING FUND BALANCE, Jun 30 8,922,874$ 608,838$
Monthly Financial Report City of Renton, Washington June 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 June 30, 2023
Funds
Balance
01/01/2022
Budgeted
Revenue
Revenue
06/30/23
Total Funds
Available
Budgeted
Expenditure
Expenditure
06/30/23 Ending Balance
GENERAL FUND 83,605,978 133,148,027 73,113,401 156,719,379 138,565,955 57,697,042 99,022,337
SPECIAL REVENUE FUNDS:10,967,354 5,152,674 3,060,306 14,027,660 5,642,007 3,107,282 10,920,378
110 Hotel Motel 712,384 200,000 228,260 940,644 454,616 74,041 866,603
127 Cable Communication 453,147 57,674 34,280 487,427 255,586 83,261 404,166
130 Housing and Supportive Services 6,110,390 3,500,000 2,242,246 8,352,636 260,000 15,000 8,337,636
135 Springbrook Wetlands Bank 454,628 - 258,878 713,506 40,000 10,273 703,233
140 Police Seizure 339,814 - 111,276 451,090 339,814 21,073 430,017
141 Police CSAM Seizure 172,804 - 2,872 175,676 172,804 4,544 171,132
31X School District Impact Mitigation - 995,000 122,127 122,127 995,000 116,195 5,932
304 Fire Mitigation 2,724,187 400,000 60,367 2,784,554 3,124,187 2,782,895 1,659
DEBT SERVICE FUND 5,262,665 5,755,022 2,705,341 7,968,006 5,565,690 3,116,183 4,851,823
CAPITAL PROJECT FUNDS (CIP):57,657,726 63,242,649 12,280,254 69,937,980 107,866,332 16,317,775 53,620,205
303 Community Services Mitigation 1,595,389 86,500 100,661 1,696,050 1,090,000 - 1,696,050
305 Transportation Mitigation 6,964,011 1,780,000 616,000 7,580,011 5,817,897 - 7,580,011
308 REET1 3,049,711 2,300,000 1,101,871 4,151,582 3,500,000 - 4,151,582
309 REET2 6,019,961 2,300,000 1,143,355 7,163,316 5,403,625 - 7,163,316
316 Municipal Facilities CIP 24,671,384 10,441,251 2,135,113 26,806,497 35,030,341 9,895,574 16,910,923
317 Transportation CIP 12,561,975 41,712,746 4,150,994 16,712,969 53,190,642 4,407,374 12,305,595
346 New Family First Center Dvlpmnt 2,795,295 4,622,152 3,032,260 5,827,555 3,833,827 2,014,827 3,812,728
ENTERPRISE FUNDS:120,097,653 113,328,675 53,397,269 173,494,922 179,033,479 41,207,644 132,287,278
4X2 Airport Operating & CIP 8,925,689 4,531,000 3,410,780 12,336,469 9,546,030 1,337,733 10,998,736
403 Solid Waste Utility 3,951,191 25,533,751 12,565,484 16,516,675 25,980,244 10,703,915 5,812,760
4X4 Golf Operating & CIP 1,609,927 3,504,825 1,794,851 3,404,778 3,853,974 1,538,735 1,866,043
4X5 Water Operating & CIP 48,208,077 20,789,505 9,496,146 57,704,223 52,379,968 8,465,899 49,238,324
4X6 Waste Water Operating & CIP 22,850,871 12,064,965 6,721,983 29,572,854 25,445,102 3,994,528 25,578,326
416 King County Metro 6,237,142 19,358,929 10,118,147 16,355,289 20,173,811 10,129,590 6,225,699
4X7 Surface Water Operating & CIP 28,314,756 27,545,700 9,289,878 37,604,634 41,654,350 5,037,244 32,567,390
INTERNAL SERVICE FUNDS:73,751,080 50,607,131 22,851,874 96,602,954 56,678,469 20,813,438 75,789,516
501 Equipment Repair/Replacement 13,277,635 9,885,963 3,531,180 16,808,815 9,812,590 3,419,291 13,389,524
502 Insurance 23,221,020 4,997,328 2,830,281 26,051,301 7,358,743 1,821,635 24,229,666
503 Information Services 9,021,343 8,830,085 3,939,670 12,961,013 13,962,728 4,478,818 8,482,195
504 Facilities 937,922 7,142,137 3,467,261 4,405,183 7,265,712 3,284,886 1,120,297
505 Communications 428,724 1,593,402 801,236 1,229,960 1,711,701 663,132 566,828
512 Insurance, Healthcare 6,935,644 16,123,216 7,003,807 13,939,451 15,197,161 6,450,909 7,488,542
522 Insurance, Leoff1 Retirees HC 19,928,792 2,035,000 1,278,439 21,207,231 1,369,834 694,767 20,512,464
FIDUCIARY FUNDS:8,733,791 400,000 1,512,497 10,246,288 253,475 714,576 9,531,712
611 Firemens' Pension 8,733,791 400,000 314,085 9,047,876 253,475 125,002 8,922,874
630 Custodial Fund - - 1,198,412 1,198,412 - 589,574 608,838
TOTAL FUNDS 360,076,247 371,634,178 168,920,942 528,997,189 493,605,407 142,973,940 386,023,249