HomeMy WebLinkAboutMONTH 2022 10Page 1 of 7
OVERVIEW
This monthly financial report reflects the City’s revenue and expenditures/expenses for the fiscal year through October 31,
2022. 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 2021-2022 Adopted Budget.
General
REVENUES:
Taxes 87,319,158$
Licenses and permits 6,361,821
Grants / intergovernmental 16,926,636
Charges for services 8,868,422
Fines and penalties 3,424,348
Miscellaneous 1,781,444
Sale of general fixed assets 2,000
Investment Earnings 608,486
Insurance recoveries 165,298
TOTAL REVENUES 125,457,613
EXPENDITURES:
Personnel 55,943,520
Supplies 1,494,424
Contracted Services 16,327,778
Principal 225,309
Capital Outlay 116,926
Internal Services 15,359,943
TOTAL EXPENDITURES 89,467,900
Transfers In 14,187
Transfers Out (5,812,895)
NET TRANSFERS (5,798,708)
CHANGE IN FUND BALANCE 30,191,005
BEGINNING FUND BALANCE, Jan 1 69,102,662
Prior Period Adjustment 379,682
BEGINNING FUND BALANCE, Jan 1 - restated 69,482,344
ENDING FUND BALANCE, Oct 31 99,673,349$
ECONOMIC DEVELOPMENT RESERVE 2,500,000
OPERATING RESERVES 11,537,583
AVAILABLE FUND BALANCE, Oct 31 85,635,766$
Monthly Financial Report October 2022
Monthly Financial Report City of Renton, Washington October 2022
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
2021-2022 Adopted Budget.
General
Governmental
Misc Debt
REVENUES:
Grants / intergovernmental 44,705$
Investment Earnings 31,635
TOTAL REVENUES 76,340
EXPENDITURES:
Principal 609,547
Interest 715,058
TOTAL EXPENDITURES 1,324,605
Transfers In 611,550
NET TRANSFERS 611,550
CHANGE IN FUND BALANCE (636,715)
BEGINNING FUND BALANCE, Jan 1 5,218,125
ENDING FUND BALANCE, Oct 31 4,581,410$
Debt Service Reserve 2,717,575
AVAILABLE FUND BALANCE 1,863,835$
Monthly Financial Report City of Renton, Washington October 2022
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 418,325$ -$ 3,616,580$ -$ -$ -$ -$ -$
Licenses and permits - 62,730 - - - - - -
Charges for services - - - - 1,189,749 4,057,180 - -
Fines and penalties - - - - - - - 9,578
Contributions 20,000 - - - - - 125,480 -
Investment Earnings 5,424 3,874 26,433 2,591 17,976 3,771 3,234 1,075
Sale of Fixed Assets - - - 230,300 - - - -
TOTAL REVENUES 443,749 66,604 3,643,013 232,891 1,207,725 4,060,951 128,714 10,653
EXPENDITURES:
Personnel - - - 5,324 - - - -
Supplies - 159,574 - - - - - -
Contracted Services 288,478 162,659 1,521,852 4,400 - 3,959,023 8,609 44
Capital Outlay - - - - - - 139,791 18,311
TOTAL EXPENDITURES 288,478 322,233 1,521,852 9,724 - 3,959,023 148,400 18,355
-
Transfers In - - - - - - -
Transfers Out - - - - - -
NET TRANSFERS - - - - - - -
CHANGE IN FUND BALANCE 155,271 (255,629) 2,121,161 223,167 1,207,725 101,928 (19,686) (7,702)
BEGINNING FUND BALANCE, Jan 1 728,421 731,245 3,171,729 234,325 1,960,733 12 631,525 174,826
Prior Period Adjustment - - - - - - - -
BEGINNING FUND BALANCE, Jan 1 - restated 728,421 731,245 3,171,729 234,325 1,960,733 12 631,525 174,826
ENDING FUND BALANCE, Oct 31 883,692$ 475,616$ 5,292,890$ 457,492$ 3,168,458$ 101,940$ 611,839$ 167,124$
CS Impact
Mitigation
Transportation
Impact
Mitigation REET 1 REET 2
Municipal
Facilities CIP
Capital
Investment
Family First
Center
REVENUES:
Taxes -$ -$ 3,049,640$ 3,049,640$ -$ -$ -$
Grants / intergovernmental - - - - 361,629 8,943,928 1,510,001
Charges for services 1,472,269 8,383,231 - - 33,950 - -
Fines and penalties - - - - - (214) -
Contributions - - - - 842,154 - 5,017,221
Sale of general fixed assets - - - - - - -
Investment Earnings 28,412 70,921 41,297 68,798 114,263 57,242 55,595
TOTAL REVENUES 1,500,681 8,454,152 3,090,937 3,118,438 1,351,996 9,000,956 6,582,817
EXPENDITURES:
Personnel - - - - 338,615 81,847 -
Supplies - - - - - 90,430 -
Contracted Services - - - - 149,937 176,125 40,974
Capital Outlay - - - - 3,406,472 14,654,044 8,732,280
TOTAL EXPENDITURES - - - - 3,895,024 15,002,446 8,773,254
Transfers In - - - - 3,000,000 - 56,518
Transfers Out - - - - (56,518) - 33
NET TRANSFERS - - - - 2,943,482 - 56,485
CHANGE IN FUND BALANCE 1,500,681 8,454,152 3,090,937 3,118,438 400,454 (6,001,490) (2,133,952)
BEGINNING FUND BALANCE, Jan 1 3,433,393 5,159,035 4,508,117 8,773,145 16,824,783 10,868,853 8,238,935
Prior Period Adjustment - - - - - - -
BEGINNING FUND BALANCE, Jan 1 - restated 3,433,393 5,159,035 4,508,117 8,773,145 16,824,783 10,868,853 8,238,935
ENDING FUND BALANCE, Oct 31 4,934,074$ 13,613,187$ 7,599,054$ 11,891,583$ 17,225,237$ 4,867,363$ 6,104,983$
Monthly Financial Report City of Renton, Washington October 2022
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 2021-2022 Adopted Budget.
Airport
Solid Waste
Utility Golf Course Water Utility
Wastewater
Utility Metro
Surface Water
Utility
REVENUES:
Licenses and permits -$ -$ -$ -$ 71,945$ -$ 30,084$
Grants / intergovernmental 57,529 34,783 - - - - 1,252,859
Charges for services 2,845,661 18,078,943 2,493,389 15,763,411 9,747,391 16,201,749 10,671,172
Interdepartmental services - - - - - - -
Fines and penalties - - - - 56 - -
Rents, leases, and misc fees 19,137 - 453,793 204,696 - - -
Interest and other misc 122,121 26,386 (110,498) 1,297,788 749,671 38,420 1,505,056
TOTAL REVENUES 3,044,448 18,140,112 2,836,684 17,265,895 10,569,063 16,240,169 13,459,171
EXPENSES:
Personnel 919,504 382,326 1,403,424 3,667,803 1,978,648 - 3,163,981
Supplies 72,281 7,571 334,917 936,210 53,519 - 66,827
Contracted Services 584,281 17,130,879 115,977 2,786,709 1,936,755 13,844,330 1,659,666
Internal Services 341,856 293,728 345,495 2,107,536 1,483,261 - 2,171,265
TOTAL OPERATING EXPENSES 1,917,922 17,814,504 2,199,813 9,498,258 5,452,183 13,844,330 7,061,739
CAPITAL, AND TRANSFERS 1,126,526 325,608 636,871 7,767,637 5,116,880 2,395,839 6,397,432
DEBT SERVICE:
Principal - - 29,395 315,517 - - -
Interest - - 1,416 91,087 39,657 - 48,178
TOTAL DEBT SERVICE - - 30,811 406,604 39,657 - 48,178
CAPITAL OUTLAY 151,642 - 418,513 2,551,305 3,071,890 - 3,392,158
Transfers In - - 186,100 - - - -
Transfers Out - - (186,100) - (7,297) - (3,975)
NET TRANSFERS - - - - (7,297) - (3,975)
CHANGE IN FUND BALANCE 974,884 325,608 187,547 4,809,728 1,998,036 2,395,839 2,953,121
BEGINNING FUND BALANCE, Jan 1 7,741,751 3,392,243 1,222,897 43,849,867 20,788,687 3,764,012 21,682,758
ENDING FUND BALANCE, Oct 31 8,716,635$ 3,717,851$ 1,410,444$ 48,659,595$ 22,786,723$ 6,159,851$ 24,635,879$
Restricted for Debt Service - - - 1,394,050 661,227 - 754,868
Operating Reserve 241,390 400,000 746,233 1,712,156 962,039 380,000 1,204,613
AVAILABLE FUND BALANCE 8,475,245$ 3,317,851$ 664,211$ 45,553,389$ 21,163,457$ 5,779,851$ 22,676,398$
Monthly Financial Report City of Renton, Washington October 2022
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 -$ -$ 221,311$ -$ -$ -$ -$
Grants / intergovernmental - - - - 3,000 - 38,624
Charges for services:
Equipment rental m&o 2,391,537 - 6,846,561 - - - -
Print and mail - - - - 357,456 - -
Communications - - - - 672,514 - -
Facilities - - - 4,870,241 - - -
IT service contracts - - - - - - -
Interest and other misc 72,891 131,678 35,620 4,489 978 48,116 121,010
Internal service fund misc:
Vehicle / equipment capital recovery 2,491,493 - - - - - -
Insurance premiums - 1,847,270 - - - - -
Worker's comp/unemployment - 1,297,949 - - - - -
Benefit premiums - - - - - 10,484,100 1,968,513
Other misc 2,499 104,843 319 86,026 - 358,690 111,929
Disposal of capital assets 22,430 - - - - - -
Insurance recoveries - 45,045 - - - - -
TOTAL REVENUES 4,980,850 3,426,785 7,103,811 4,960,756 1,033,948 10,890,906 2,240,076
EXPENSES:
Personnel 912,631 906,935 2,634,105 2,915,926 656,232 9,068,514 1,015,648
Supplies 1,333,004 68 1,109,112 743,805 39,144 2,145 -
Contracted Services 305,160 2,536,362 2,381,534 1,402,078 237,239 403,020 43,560
Internal Services 35,724 - - 109,581 1,526 70,252 -
TOTAL OPERATING EXPENSES 2,586,519 3,443,365 6,124,751 5,171,390 934,141 9,543,931 1,059,208
AMOUNT AVAILABLE FOR DEBT SERVICE,
CAPITAL, AND TRANSFERS 2,394,331 (16,580) 979,060 (210,634) 99,807 1,346,975 1,180,868
TOTAL DEBT SERVICE - - - - - - -
CAPITAL OUTLAY 384,842 - 105,052 15,149 - - -
Transfers In - 152,772 2,086,034 11,045 - - -
Transfers Out - (51,420) - - - - -
NET TRANSFERS - 101,352 2,086,034 11,045 - - -
CHANGE IN FUND BALANCE 2,009,489 84,772 2,960,042 (214,738) 99,807 1,346,975 1,180,868
BEGINNING FUND BALANCE, Jan 1 10,125,169 20,494,538 3,653,455 785,189 141,517 6,655,137 18,188,260
ENDING FUND BALANCE, Oct 31 12,134,658$ 20,579,310$ 6,613,497$ 570,451$ 241,324$ 8,002,112$ 19,369,128$
Insurance Reserves - 20,579,310 - - - 4,123,049 19,369,128
Opearting Reserves 9,305,868 - 2,068,477 - - - -
AVAILABLE FUND BALANCE 2,828,790$ -$ 4,545,020$ 570,451$ 241,324$ 3,879,063$ -$
Monthly Financial Report City of Renton, Washington October 2022
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 182,841$ -$
Investment Earnings 50,233 -
Collected for Others - 1,638,070
TOTAL REVENUES 233,074 1,638,070
EXPENDITURES:
Distributions to Others 223,359 1,351,465
TOTAL EXPENDITURES 188,972 1,351,465
NET TRANSFERS - -
CHANGE IN FUND BALANCE 44,102 286,605
BEGINNING FUND BALANCE, Jan 1 8,371,183 -
ENDING FUND BALANCE, Oct 31 8,415,285$ 286,605$
Monthly Financial Report City of Renton, Washington October 2022
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 October 31, 2022
Funds
Balance
01/01/2022
Budgeted
Revenue
Revenue
10/31/22
Total Funds
Available
Budgeted
Expenditure
Expenditure
10/31/22 Ending Balance
GENERAL FUND 69,102,662 138,107,723 125,851,482 194,954,144 144,233,971 95,280,795 99,673,349
SPECIAL REVENUE FUNDS:7,632,816 9,897,979 9,794,300 17,427,116 8,741,401 6,268,065 11,159,051
110 Hotel Motel 728,421 225,000 443,749 1,172,170 618,207 288,478 883,692
127 Cable Communication 731,245 57,674 66,604 797,849 460,209 322,233 475,616
130 Housing and Supportive Services 3,171,729 3,490,000 3,643,013 6,814,742 1,710,000 1,521,852 5,292,890
135 Springbrook Wetlands Bank 234,325 231,305 232,891 467,216 51,000 9,724 457,492
140 Police Seizure 631,525 - 128,714 760,239 631,525 148,400 611,839
141 Police CSAM Seizure 174,826 - 10,653 185,479 174,826 18,355 167,124
31X School District Impact Mitigation 12 4,595,000 4,060,951 4,060,963 4,595,000 3,959,023 101,940
304 Fire Mitigation 1,960,733 1,299,000 1,207,725 3,168,458 500,634 - 3,168,458
DEBT SERVICE FUND 5,218,125 4,533,969 687,890 5,906,015 4,341,920 1,324,605 4,581,410
CAPITAL PROJECT FUNDS (CIP):57,806,261 101,217,561 36,156,495 93,962,756 141,358,340 27,727,275 66,235,481
303 Community Services Mitigation 3,433,393 1,386,500 1,500,681 4,934,074 3,380,595 - 4,934,074
305 Transportation Mitigation 5,159,035 8,044,696 8,454,152 13,613,187 6,851,255 - 13,613,187
308 REET1 4,508,117 2,300,000 3,090,937 7,599,054 5,579,996 - 7,599,054
309 REET2 8,773,145 2,300,000 3,118,438 11,891,583 6,921,118 - 11,891,583
316 Municipal Facilities CIP 16,824,783 20,848,957 4,351,996 21,176,779 37,665,866 3,951,542 17,225,237
317 Transportation CIP 10,868,853 53,494,765 9,000,956 19,869,809 63,181,252 15,002,446 4,867,363
336 New Library Development - - - - - - -
346 New Family First Center Dvlpmnt 8,238,935 12,842,643 6,639,335 14,878,270 17,778,258 8,773,287 6,104,983
ENTERPRISE FUNDS:102,442,215 115,114,412 81,741,642 184,183,857 171,626,571 68,096,879 116,086,978
4X2 Airport Operating & CIP 7,741,751 3,456,518 3,044,448 10,786,199 9,388,477 2,069,564 8,716,635
403 Solid Waste Utility 3,392,243 24,133,272 18,140,112 21,532,355 24,885,563 17,814,504 3,717,851
4X4 Golf Operating & CIP 1,222,897 3,428,832 3,022,784 4,245,681 3,655,054 2,835,237 1,410,444
4X5 Water Operating & CIP 43,849,867 20,933,613 17,265,895 61,115,762 51,456,362 12,456,167 48,659,595
4X6 Waste Water Operating & CIP 20,788,687 12,462,963 10,569,063 31,357,750 26,104,765 8,571,027 22,786,723
416 King County Metro 3,764,012 18,495,877 16,240,169 20,004,181 18,495,877 13,844,330 6,159,851
4X7 Surface Water Operating & CIP 21,682,758 32,203,337 13,459,171 35,141,929 37,640,473 10,506,050 24,635,879
INTERNAL SERVICE FUNDS:60,043,265 50,755,494 36,886,983 96,930,248 49,754,860 29,419,768 67,510,480
501 Equipment Repair/Replacement 10,125,169 6,445,116 4,980,850 15,106,019 7,264,417 2,971,361 12,134,658
502 Insurance 20,494,538 6,309,425 3,579,557 24,074,095 4,637,888 3,494,785 20,579,310
503 Information Services 3,653,455 13,669,859 9,189,845 12,843,300 14,413,705 6,229,803 6,613,497
504 Facilities 785,189 6,676,675 4,971,801 5,756,990 6,858,180 5,186,539 570,451
505 Communications 141,517 1,377,535 1,033,948 1,175,465 1,384,885 934,141 241,324
512 Insurance, Healthcare 6,655,137 13,566,817 10,890,906 17,546,043 13,743,496 9,543,931 8,002,112
522 Insurance, Leoff1 Retirees HC 18,188,260 2,710,067 2,240,076 20,428,336 1,452,289 1,059,208 19,369,128
FIDUCIARY FUNDS:8,371,183 290,000 1,871,144 10,242,327 200,475 1,540,437 8,701,890
611 Firemens' Pension 8,371,183 290,000 233,074 8,604,257 200,475 188,972 8,415,285
630 Custodial Fund - - 1,638,070 1,638,070 - 1,351,465 286,605
TOTAL FUNDS 310,616,527 419,917,138 292,989,936 603,606,463 520,257,538 229,657,824 373,948,639