HomeMy WebLinkAboutFY2021 4th Qtr Financial Summary
Date: August 19, 2021
To: City Manager, City Council
From: Jacklyn Fleagle, Budget & Compliance Officer
Re: Quarterly Financial Summary for Period Ending June 30, 2021
Introduction
Attached to this memorandum are the City’s quarterly financial reports as of June 30, 2021.
The quarterly financial report includes combined summaries of all fund balances, revenues, and
expenditures for fiscal year 2021 through the end of the fiscal year. This report represents the
entire fiscal year’s activities, but the totals presented are still preliminary and unaudited.
Accruals will continue to be posted through August and September and until the annual financial
audit is completed by Bohnsack & Frommelt.
Revenue Analysis
This revenue analysis pertains to the revenue reports, Revenues by Fund and Revenues by
Type, on pages 5-7. In these two reports, the actual revenues would ideally be near 100% of
budget since we have completed the fiscal year; however, not all of the accrued revenues have
been received and posted yet.
For the major governmental funds, their actual revenues appear to have finished the year
slightly under or at their revised budget estimates. The General Fund is at 98.1 %, the Road
Use Tax Fund is at 101.8%, the Employee Benefits Fund is at 100.6%, and the Debt Service
Fund is at 100.7%. Some large accruals are still outstanding such as the final Hotel/Motel Tax
receipt (Other City Taxes) in the General Fund. The General Fund has also experienced
revenue shortfalls in Intergovernmental revenues due to timing of Capital Improvement Projects
and Culture & Recreation charges for services, Library Fines, and Police Services revenues due
to the pandemic.
In the major enterprise funds, the actual revenues as a percentage of the budget ranged
between 43.7% and 112.5%. The Water Fund finished with revenues at 96.8% of budget, the
Housing Authority Fund at 93.2% of budget and the Wastewater Fund at 96.3% of budget.
Some large accruals have yet to be made within the major enterprise funds for unbilled services
and receivables at year end. The major enterprise funds will finish the year with revenues close
to or higher than 100% of budget primarily due to conservative revenue budgeting for Charges
for Fees and Services and budget amendments done mid-year to account for impacts of the
COVID-19 pandemic.
The Transit Fund actual revenues currently stand at 43.7% of budget This difference in the
Transit Fund will be made up with the accrual of the Federal Operating grant. In addition, we are
expecting receipt of CARES Act funding to make up for the Transit Fund revenue shortfalls.
Several funds are below the 100% benchmark due to the timing of grants. These funds include
the Community Development Block Grant (CDBG) Fund at 68.3%, the HOME Fund at 37.2%,
and the Metro Planning Org of Johnson County at 82.8%. Additionally, both the Governmental
Projects and the Enterprise Projects Capital Funds are significantly below budget at 62.4% and
54.1%, respectively. Revenues for these funds are significantly below budget due to the timing
of the state and federal grant revenues and private loan repayments and not due to the
pandemic. These revenues have not yet been received or earned and will be amended into
next year’s budget.
1
The Other Shared Revenues Fund had revenues at 22,948.4% of budget. This is due to the
receipt of the first installment of the American Rescue Plan Act funding and various other
COVID-19 related grants that were previously unbudgeted in fiscal year 2021.
The combined total actual revenues for all budgetary funds through June are $179,112,510 or
97.3% of budget. The budget shortfall of $4,891,058 is primarily due to the timing of the
aforementioned grant revenues and other unrecorded accruals in addition to decreased
revenues due to the COVID-19 pandemic. Overall, the City’s revenues are slightly less than
projected, and most of the anomalies and budget variances can be explained either through
timing of accruals or grants or through pandemic related revenue losses.
Expenditure Analysis
This expenditure analysis pertains to the expenditure reports, Expenditures by Fund and
Expenditures by Fund by Department on pages 8-10. The analysis of the City’s expenditures
for fiscal year 2021 through June is similar to the analysis for the City’s revenues. We generally
expect the actual expenditure levels to be around 100% of budget at this time of year. Also,
similar to the revenues, not all accruals have been recorded and posted yet, and the COVID-19
pandemic has had a significant impact on some funds.
For the majority of the City’s funds, their actual expenditures are currently at or below 100% of
their budgeted expenditures. The General Fund is at 85.6% due to unspent monies within the
City Manager’s Department for Black Lives Matter and Economic Development, that will be
carried forward to fiscal year 2022, in addition to lower expenditures within Parks and
Recreation due to the impact of the COVID-19 pandemic.
There are several funds currently above 100% of their budgeted expenditures. The Employee
Benefits Fund is at 135.5% primarily due to large worker’s compensation claims. The Other
Shared Revenues fund came in over budget at 673.4% primarily due to COVID-19 related grant
monies received and spent within the fiscal year. Additionally, the Debt Service fund came in
over budget at 100.9% due to interest payments for the 2020 GO Bonds being higher than
anticipated. For the City’s enterprise funds; the Airport fund finished at 113.7% primarily due to
unbudgeted professional services and minor equipment purchases.
Some of the other funds have actual expenditures that are well below the 100% benchmark.
Those funds include the HOME Fund (38.0%), the CDBG Fund (65.4%), and the Emergency
Levy Fund (16.4%). Also, well below budget are the Governmental Projects Fund (31.6%), and
the Enterprise Projects Fund (28.0%). Most of these funds contain a great deal of grant and
project activity which does not always occur evenly throughout the fiscal year. Unexpended
appropriations will be carried forward into the next fiscal year and amended into the fiscal year
2022 budget.
The combined total actual expenditures for all budgetary funds through June are $157,664,774
or 70.7% of budget. When the capital project funds, the CDBG, Other Shared Revenues and
Emergency Levy funds are removed from the calculation, the actual percentage of expenditures
versus budget increases to 98.5%. Overall, the City’s expenditures are expected to finish at or
below budget.
Conclusion
Generally, there are no major immediate concerns to report with the City’s fund balances at
year-end, and no funds are presented with a negative fund balance at. This year-end report is
preliminary and accruals for revenues and expenditures are still outstanding. The City’s final
financial performance will be available for the start of the fiscal year 2022 budget process in
October. Additional information is available from the Finance Department upon request.
2
Beginning Ending Restricted, Unassigned
Fund Year-to-Date Transfers Year-to-Date Transfers Fund Committed, Fund
Balance Revenues In Expenditures Out Balance Assigned Balance
Budgetary Funds
General Fund
10** General Fund 41,640,906$ 58,473,936$ 16,639,310$ 55,282,496$ 11,042,749$ 50,428,907$ 15,483,224$ 34,945,684$
Special Revenue Funds
2100 Community Dev Block Grant (17,210) 1,431,648 - 1,253,229 141,285 19,924 - 19,924
2110 HOME (37,396) 323,187 - 281,357 - 4,434 - 4,434
2200 Road Use Tax Fund 3,547,923 9,156,758 622,374 6,895,226 3,183,187 3,248,642 - 3,248,642
2300 Other Shared Revenue 2,639 9,162,595 - 268,867 - 8,896,367 - 8,896,367
2350 Metro Planning Org of J.C. 434,368 326,231 378,577 759,938 - 379,238 - 379,238
2400 Employee Benefits 3,584,853 14,799,472 - 1,790,332 12,963,004 3,630,989 - 3,630,989
2450 Emergency Levy Fund 2,613 1,039,399 - 147,787 100,000 794,225 - 794,225
2500 Affordable Housing Fund 1,622,344 1,836,537 1,000,000 860,507 - 3,598,374 - 3,598,374
2510 Iowa City Property Manageme 186,172 85,162 - 76,763 - 194,571 - 194,571
26** Tax Increment Financing 783,349 2,679,149 51,716 951,082 1,108,346 1,454,787 1,159,892 294,895
2820 SSMID-Downtown District 4,100 503,091 - 507,191 - - - -
Debt Service Fund
5*** Debt Service 9,354,037 11,526,951 1,025,690 14,652,318 - 7,254,361 - 7,254,361
Enterprise Funds
710* Parking 2,171,685 3,816,297 250,000 3,356,514 607,312 2,274,156 303,702 1,970,454
715* Mass Transit 6,914,358 2,367,431 5,076,795 6,824,019 1,250,000 6,284,566 6,031,167 253,399
720* Wastewater 23,423,905 11,455,640 6,315,097 9,720,810 7,515,264 23,958,568 12,201,929 11,756,639
730* Water 13,016,182 9,321,688 2,764,311 9,070,655 3,950,522 12,081,004 5,988,412 6,092,592
7400 Refuse Collection 1,690,269 3,671,293 10,539 3,798,190 550,000 1,023,910 - 1,023,910
750* Landfill 24,875,610 8,286,921 1,382,881 5,615,542 3,277,498 25,652,372 23,535,451 2,116,921
7600 Airport 235,540 398,016 100,000 417,765 52,250 263,541 199,821 63,719
7700 Storm Water 1,088,776 1,614,119 1,001,986 597,005 1,724,419 1,383,458 389,000 994,458
79** Housing Authority 7,828,046 10,234,398 - 11,941,213 50,720 6,070,510 1,252,260 4,818,250
Capital Project Funds
Governmental Projects 27,975,543 14,882,303 5,225,999 17,292,800 - 30,791,044 - 30,791,044
Enterprise Projects 10,086,942 1,720,289 6,713,719 5,303,169 950,000 12,267,781 - 12,267,781 -
Total Budgetary Funds 180,415,552$ 179,112,510$ 48,558,996$ 157,664,774$ 48,466,555$ 201,955,729$ 66,544,858$ 135,410,870$
Non-Budgetary Funds
Internal Service Funds
810* Equipment 17,243,785$ 7,463,623$ 218,257$ 6,663,147$ 299,719$ 17,962,798$ 14,478,070$ 3,484,728$
8200 Risk Management 4,113,594 1,624,257 - 1,423,612 - 4,314,240 - 4,314,240
830* Information Technology 3,254,738 2,910,525 335,678 2,620,181 335,678 3,545,082 1,241,050 2,304,033
8400 Central Services 756,956 198,909 - 146,775 10,978 798,111 - 798,111
8500 Health Insurance Reserves 12,300,290 10,559,371 - 10,665,253 - 12,194,408 8,627,420 3,566,988
8600 Dental Insurance Reserves 374,616 396,698 - 347,747 - 423,567 - 423,567
Total Non-Budgetary Funds 38,043,980$ 23,153,383$ 553,935$ 21,866,716$ 646,375$ 39,238,207$ 24,346,539$ 14,891,667$
Total All Funds 218,459,532$ 202,265,893$ 49,112,930$ 179,531,490$ 49,112,930$ 241,193,935$ 90,891,398$ 150,302,538$
City of Iowa City
Fund Summary
Fiscal Year 2021 through June 30, 2021
3
2020
Actual
2021
Budget
2021
Revised
2021
Actual Variance Percent
Budgetary Fund Revenues
General Fund
10** General Fund 54,093,751$ 59,264,838$ 59,590,311$ 58,473,936$ (1,116,375)$ 98.1%
Special Revenue Funds
2100 Community Dev Block Grant 696,930 784,935 2,095,404 1,431,648 (663,756) 68.3%
2110 HOME 890,256 599,082 868,153 323,187 (544,966) 37.2%
2200 Road Use Tax Fund 9,343,122 8,935,700 8,995,478 9,156,758 161,280 101.8%
2300 Other Shared Revenue 12,500 - 39,927 9,162,595 9,122,668 22948.4%
2350 Metro Planning Org of Johnson Co 393,607 377,352 394,167 326,231 (67,936) 82.8%
2400 Employee Benefits 12,798,747 14,712,009 14,712,009 14,799,472 87,463 100.6%
2450 Emergency Levy Fund 2,613 1,001,442 1,001,442 1,039,399 37,957 103.8%
2500 Affordable Housing Fund (26,615) - 8,100 1,836,537 1,828,437 0.0%
2510 Iowa City Property Management 65,497 68,430 68,430 85,162 16,732 124.5%
26** Tax Increment Financing 3,479,948 2,608,203 2,608,203 2,679,149 70,946 102.7%
2820 SSMID-Downtown District 371,277 492,596 492,596 503,091 10,495 102.1%
Debt Service Fund
5*** Debt Service 12,084,974 11,450,899 11,450,899 11,526,951 76,052 100.7%
Enterprise Funds
710* Parking 4,555,583 5,935,900 3,402,700 3,816,297 413,597 112.2%
715* Mass Transit 5,114,607 4,457,460 5,420,191 2,367,431 (3,052,760) 43.7%
720* Wastewater 12,854,265 11,895,436 11,895,436 11,455,640 (439,796) 96.3%
730* Water 10,398,875 9,985,860 9,625,231 9,321,688 (303,543) 96.8%
7400 Refuse Collection 3,808,883 3,886,220 3,886,070 3,671,293 (214,777) 94.5%
750* Landfill 7,273,518 7,202,311 7,367,451 8,286,921 919,470 112.5%
7600 Airport 444,564 364,820 368,820 398,016 29,196 107.9%
7700 Storm Water 1,749,864 1,714,700 1,714,700 1,614,119 (100,581) 94.1%
79** Housing Authority 10,379,669 10,236,271 10,977,513 10,234,398 (743,115) 93.2%
Capital Project Funds
Governmental Projects 16,828,142 18,167,000 23,837,857 14,882,303 (8,955,554) 62.4%
Enterprise Projects 3,046,134 1,652,776 3,182,480 1,720,289 (1,462,191) 54.1%
Total Budgetary Revenues 170,660,713$ 175,794,240$ 184,003,568$ 179,112,510$ (4,891,058)$ 97.3%
Non-Budgetary Fund Revenues
Internal Service Funds
810* Equipment 7,106,528$ 7,448,587$ 7,520,479$ 7,463,623$ (56,856)$ 99.2%
8200 Risk Management 1,741,050 1,646,580 1,646,580 1,624,257 (22,323) 98.6%
830* Information Technology 2,693,000 2,495,792 2,495,792 2,910,525 414,733 116.6%
8400 Central Services 243,536 255,988 255,988 198,909 (57,079) 77.7%
8500 Health Insurance Reserves 10,272,878 11,196,638 11,196,638 10,559,371 (637,267) 94.3%
8600 Dental Insurance Reserves 411,351 458,475 458,475 396,698 (61,777) 86.5%
Total Non-Budgetary Revenues 22,468,344$ 23,502,060$ 23,573,952$ 23,153,383$ (420,569)$ 98.2%
Total Revenues - All Funds 193,129,057$ 199,296,300$ 207,577,520$ 202,265,893$ (5,311,627)$ 97.4%
City of Iowa City
Revenues by Fund
Fiscal Year 2021 through June 30, 2021
4
2020
Actual
2021
Budget
2021
Revised
2021
Actual Variance Percent
Budgetary Fund Revenues
Property Taxes 59,360,168$ 65,849,136$ 65,849,136$ 66,780,996$ 931,860$ 101.4%
Other City Taxes:
TIF Revenues 3,434,710 2,593,203 2,593,203 2,637,854 44,651 101.7%
Gas/Electric Excise Taxes 677,091 633,387 633,387 643,961 10,574 101.7%
Mobile Home Taxes 51,220 58,361 58,361 63,002 4,641 108.0%
Hotel/Motel Taxes 1,134,864 1,301,820 650,860 559,546 (91,314) 86.0%
Utility Franchise Tax 883,652 964,690 964,690 781,585 (183,105) 81.0%
Subtotal 6,181,536 5,551,461 4,900,501 4,685,947 (214,554) 95.6%
Licenses, Permits, & Fees:
General Use Permits 15,063 85,410 14,180 18,029 3,849 127.1%
Food & Liquor Licenses 95,476 126,710 126,710 24,651 (102,059) 19.5%
Professional License 3,925 6,160 6,160 3,760 (2,400) 61.0%
Franchise Fees 438,753 512,750 580,000 582,917 2,917 100.5%
Construction Permits & Insp Fees 1,742,746 1,954,820 1,794,820 1,707,958 (86,862) 95.2%
Misc Lic & Permits 68,060 49,620 49,620 73,547 23,927 148.2%
Subtotal 2,364,024 2,735,470 2,571,490 2,410,862 (160,628) 93.8%
Intergovernmental:
Fed Intergovernment Revenue 15,404,149 16,820,081 26,737,597 24,373,398 (2,364,199) 91.2%
Property Tax Credits 1,519,888 1,923,358 1,923,358 1,593,623 (329,735) 82.9%
Road Use Tax 9,163,303 8,820,140 8,820,140 9,015,426 195,286 102.2%
State 28E Agreements 2,107,692 1,976,419 2,394,419 2,128,143 (266,276) 88.9%
Operating Grants 66,984 69,580 69,580 61,849 (7,731) 88.9%
Disaster Assistance - - - 2,700 2,700 0.0%
Other State Grants 5,510,294 3,069,046 6,657,595 2,227,974 (4,429,621) 33.5%
Local 28E Agreements 1,280,923 2,883,620 2,900,435 1,410,557 (1,489,878) 48.6%
Subtotal 35,053,234 35,562,244 49,503,124 40,813,669 (8,689,455) 82.4%
Charges For Fees And Services:
Building & Development 492,643 428,570 428,570 2,517,466 2,088,896 587.4%
Police Services 188,901 100,000 30,000 13,523 (16,477) 45.1%
Animal Care Services 13,484 14,920 14,920 11,742 (3,178) 78.7%
Fire Services 8,880 9,060 9,060 11,074 2,014 122.2%
Transit Fees 968,924 1,220,390 750,390 637,606 (112,784) 85.0%
Culture & Recreation 467,105 776,548 568,278 267,221 (301,057) 47.0%
Misc Charges For Services 53,024 68,820 51,200 57,336 6,136 112.0%
Water Charges 10,051,603 9,748,310 9,448,310 9,215,461 (232,849) 97.5%
Wastewater Charges 12,353,935 11,631,416 11,631,416 11,276,574 (354,842) 96.9%
Refuse Charges 4,185,695 4,278,720 4,316,840 4,323,153 6,313 100.1%
Landfill Charges 5,961,888 6,224,330 6,410,000 7,253,855 843,855 113.2%
Storm Water Charges 1,730,056 1,700,000 1,700,000 1,600,076 (99,924) 94.1%
Parking Charges 4,795,660 6,378,760 3,775,260 4,154,129 378,869 110.0%
Subtotal 41,271,797 42,579,844 39,134,244 41,339,216 2,204,972 105.6%
Miscellaneous:
Code Enforcement 300,368 269,340 68,100 60,387 (7,713) 88.7%
Parking Fines 438,244 585,000 525,000 462,396 (62,604) 88.1%
Library Fines & Fees 60,545 100,000 10,000 4,328 (5,672) 43.3%
Contributions & Donations 496,111 309,310 544,237 350,499 (193,738) 64.4%
Printed Materials 39,128 46,710 46,710 20,086 (26,624) 43.0%
Animal Adoption 62,646 35,000 35,000 49,080 14,080 140.2%
Misc Merchandise 36,506 62,760 37,450 17,177 (20,273) 45.9%
Intra-City Charges 4,667,718 5,090,750 5,090,750 5,025,342 (65,408) 98.7%
Other Misc Revenue 913,580 795,155 769,200 901,499 132,299 117.2%
Special Assessments 294 570 570 2,134 1,564 374.4%
Subtotal 7,015,141$ 7,294,595$ 7,127,017$ 6,892,927$ (234,090)$ 96.7%
City of Iowa City
Revenues by Type
Fiscal Year 2021 through June 30, 2021
5
2020
Actual
2021
Budget
2021
Revised
2021
Actual Variance Percent
City of Iowa City
Revenues by Type
Fiscal Year 2021 through June 30, 2021
Use Of Money And Property:
Interest Revenues 3,277,337$ 1,705,802$ 1,209,842$ 983,814$ (226,028)$ 81.3%
Rents 1,177,377 1,331,104 1,062,629 1,100,488 37,859 103.6%
Royalties & Commissions 100,348 106,603 87,603 120,765 33,162 137.9%
Subtotal 4,555,062 3,143,509 2,360,074 2,205,067 (155,007) 93.4%
Other Financial Sources:
Debt Sales 13,012,385 11,871,140 11,161,140 12,744,378 1,583,238 114.2%
Sale Of Assets 901,476 501,700 1,051,700 616,257 (435,443) 58.6%
Insurance Recoveries 2,258 - - - - 0.0%
Loans 943,633 705,141 345,141 623,191 278,050 180.6%
Subtotal 14,859,751 13,077,981 12,557,981 13,983,826 1,425,845 111.4%
Total Budgetary Revenues 170,660,713$ 175,794,240$ 184,003,567$ 179,112,510$ (4,891,057) 97.3%
Non-Budgetary Fund Revenues
Internal Service Funds 22,468,344$ 23,502,060$ 23,573,952$ 23,153,383$ (420,569)$ 98.2%
Total Non-Budgetary Revenues 22,468,344$ 23,502,060$ 23,573,952$ 23,153,383$ (420,569)$ 98.2%
Total Revenues - All Funds 193,129,057$ 199,296,300$ 207,577,519$ 202,265,893$ (5,311,626)$ 97.4%
6
2020
Actual
2021
Budget
2021
Revised
2021
Actual Variance Percent
Budgetary Fund Expenditures
General Fund
10** General Fund 57,237,520$ 63,133,164$ 64,561,396$ 55,282,496$ 9,278,900$ 85.6%
Special Revenue Funds
2100 Community Dev Block Grant 710,805 734,915 1,916,454 1,253,229 663,225 65.4%
2110 HOME 864,090 471,281 739,827 281,357 458,470 38.0%
2200 Road Use Tax Fund 6,541,337 6,860,459 6,989,155 6,895,226 93,929 98.7%
2300 Other Shared Revenue 1,810 - 39,927 268,867 (228,940) 673.4%
2350 Metro Planning Org of Johnson Co. 666,417 785,929 784,616 759,938 24,678 96.9%
2400 Employee Benefits 1,380,902 1,321,730 1,321,730 1,790,332 (468,602) 135.5%
2450 Emergency Levy Fund - 900,800 900,800 147,787 753,013 16.4%
2500 Affordable Housing Fund 986,779 1,000,000 1,000,000 860,507 139,493 86.1%
2510 Iowa City Property Management 60,567 57,548 57,548 76,763 (19,215) 133.4%
26** Tax Increment Financing 1,545,792 1,240,029 1,159,444 951,082 208,362 82.0%
2820 SSMID-Downtown District 367,177 492,596 496,696 507,191 (10,495) 102.1%
Debt Service Fund
5*** Debt Service 13,038,331 14,519,819 14,519,819 14,652,318 (132,499) 100.9%
Enterprise Funds
710* Parking 13,153,203 6,937,252 4,271,531 3,356,514 915,017 78.6%
715* Mass Transit 8,285,908 7,988,973 7,916,023 6,824,019 1,092,004 86.2%
720* Wastewater 8,928,996 9,904,664 9,916,375 9,720,810 195,565 98.0%
730* Water 8,512,594 9,048,440 9,325,504 9,070,655 254,849 97.3%
7400 Refuse Collection 3,687,875 3,920,390 3,963,567 3,798,190 165,377 95.8%
750* Landfill 5,337,862 5,456,843 5,550,685 5,615,542 (64,857) 101.2%
7600 Airport 421,723 367,708 367,283 417,765 (50,482) 113.7%
7700 Storm Water 603,911 679,879 679,161 597,005 82,156 87.9%
79** Housing Authority 9,904,793 10,139,876 12,783,432 11,941,213 842,219 93.4%
Capital Project Funds
Governmental Projects 24,661,959 22,705,470 54,748,115 17,292,800 37,455,315 31.6%
Enterprise Projects 5,947,033 6,834,650 18,955,820 5,303,169 13,652,651 28.0%
Total Budgetary Expenditures 172,847,385$ 175,502,415$ 222,964,908$ 157,664,774$ 65,300,134$ 70.7%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment 5,786,860$ 6,156,284$ 8,585,156$ 6,663,147$ 1,922,009$ 77.6%
8200 Risk Management 1,511,332 1,623,630 1,623,630 1,423,612 200,018 87.7%
830* Information Technology 2,430,267 2,513,842 2,789,022 2,620,181 168,841 93.9%
8400 Central Services 188,400 225,477 251,671 146,775 104,896 58.3%
8500 Health Insurance Reserves 9,129,477 11,070,318 11,070,318 10,665,253 405,065 96.3%
8600 Dental Insurance Reserves 295,202 449,071 449,071 347,747 101,324 77.4%
Total Non-Budgetary Expenditures 19,341,538$ 22,038,622$ 24,768,868$ 21,866,716$ 2,902,152$ 88.3%
Total Expenditures - All Funds 192,188,923$ 197,541,037$ 247,733,776$ 179,531,490$ 68,202,286$ 72.5%
City of Iowa City
Expenditures by Fund
Fiscal Year 2021 through June 30, 2021
7
2020
Actual
2021
Budget
2021
Revised
2021
Actual Variance Percent
Budgetary Funds Expenditures
General Fund
10** General Fund
City Council 149,211$ 159,554$ 157,929$ 148,836$ 9,093$ 94.2%
City Clerk 491,473 524,699 557,494 530,843 26,651 95.2%
City Attorney 836,849 867,117 871,776 823,919 47,857 94.5%
City Manager 3,727,694 4,286,206 5,571,166 3,742,396 1,828,770 67.2%
Finance 4,089,409 4,631,600 4,958,666 3,834,842 1,123,824 77.3%
Police 14,503,070 15,667,193 15,805,126 14,476,451 1,328,676 91.6%
Fire 8,477,009 9,035,169 9,048,784 8,918,022 130,762 98.6%
Parks & Recreation 8,574,238 10,443,623 10,542,308 8,348,278 2,194,030 79.2%
Library 6,327,197 7,092,059 6,949,366 6,081,082 868,284 87.5%
Senior Center 913,616 1,038,668 1,027,646 926,978 100,668 90.2%
Neighborhood & Development Services 6,066,892 5,614,025 5,309,960 4,274,402 1,035,558 80.5%
Public Works 2,478,292 3,117,289 3,103,713 2,568,025 535,688 82.7%
Transportation & Resource Management 602,569 655,962 657,462 608,423 49,039 92.5%
Total General Fund 57,237,520 63,133,164 64,561,396 55,282,496 9,278,900 85.6%
Special Revenue Funds
2100 Community Dev Block Grant
Neighborhood & Development Services 710,805 734,915 1,916,454 1,253,229 663,225 65.4%
2110 HOME
Neighborhood & Development Services 864,090 471,281 739,827 281,357 458,470 38.0%
2200 Road Use Tax Fund
Public Works 6,541,337 6,860,459 6,989,155 6,895,226 93,929 98.7%
2300 Other Shared Revenue
Neighborhood & Development Services 1,810 - 39,927 268,867 (228,940) 673.4%
2350 Metro Planning Org of Johnson Co
Neighborhood & Development Services 666,417 785,929 784,616 759,938 24,678 96.9%
2400 Employee Benefits
Finance 1,380,902 1,321,730 1,321,730 1,790,332 (468,602) 135.5%
2450 Emergency Levy Fund
City Manager - 900,800 900,800 147,787 753,013 16.4%
2500 Affordable Housing Fund
Neighborhood & Development Services 986,779 1,000,000 1,000,000 860,507 139,493 86.1%
2510 Iowa City Property Management
Neighborhood & Development Services 60,567 57,548 57,548 76,763 (19,215) 133.4%
26** Tax Increment Financing
Finance 1,545,792 1,240,029 1,159,444 951,082 208,362 82.0%
2820 SSMID-Downtown District
Finance 367,177 492,596 496,696 507,191 (10,495) 102.1%
Total Special Revenue Funds 13,125,677 13,865,287 15,406,197 13,792,278 1,613,919 89.5%
Debt Service Fund
5*** Debt Service
Finance 13,038,331 14,519,819 14,519,819 14,652,318 (132,499) 100.9%
Total Debt Service Fund 13,038,331 14,519,819 14,519,819 14,652,318 (132,499) 100.9%
City of Iowa City
Expenditures by Fund by Department
Fiscal Year 2021 through June 30, 2021
8
2020
Actual
2021
Budget
2021
Revised
2021
Actual Variance Percent
City of Iowa City
Expenditures by Fund by Department
Fiscal Year 2021 through June 30, 2021
Enterprise Funds
710* Parking
Transportation & Resource Management 13,153,203$ 6,937,252$ 4,271,531$ 3,356,514$ 915,017$ 78.6%
715* Mass Transit
Transportation & Resource Management 8,285,908 7,988,973 7,916,023 6,824,019 1,092,004 86.2%
720* Wastewater
Public Works 8,928,996 9,904,664 9,916,375 9,720,810 195,565 98.0%
730* Water
Public Works 8,512,594 9,048,440 9,325,504 9,070,655 254,849 97.3%
7400 Refuse Collection
Transportation & Resource Management 3,687,875 3,920,390 3,963,567 3,798,190 165,377 95.8%
750* Landfill
Transportation & Resource Management 5,337,862 5,456,843 5,550,685 5,615,542 (64,857) 101.2%
7600 Airport
Airport Operations 421,723 367,708 367,283 417,765 (50,482) 113.7%
7700 Storm Water
Public Works 603,911 679,879 679,161 597,005 82,156 87.9%
79** Housing Authority
Neighborhood & Development Services 9,904,793 10,139,876 12,783,432 11,941,213 842,219 93.4%
Total Enterprise Funds 58,836,864 54,444,025 54,773,561 51,341,714 3,431,847 93.7%
Capital Project Funds
Governmental Projects 24,661,959 22,705,470 54,748,115 17,292,800 37,455,315 31.6%
Enterprise Projects 5,947,033 6,834,650 18,955,820 5,303,169 13,652,651 28.0%
Total Capital Project Funds 30,608,993 29,540,120 73,703,935 22,595,969 51,107,966 30.7%
Total Budgetary Expenditures 172,847,385$ 175,502,415$ 222,964,908$ 157,664,774$ 65,300,134$ 70.7%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment
Public Works 5,786,860$ 6,156,284$ 8,585,156$ 6,663,147$ 1,922,009$ 77.6%
8200 Risk Management
Finance 1,511,332 1,623,630 1,623,630 1,423,612 200,018 87.7%
830* Information Technology
Finance 2,430,267 2,513,842 2,789,022 2,620,181 168,841 93.9%
8400 Central Services
Finance 188,400 225,477 251,671 146,775 104,896 58.3%
8500 Health Insurance Reserves
Finance 9,129,477 11,070,318 11,070,318 10,665,253 405,065 96.3%
8600 Dental Insurance Reserves
Finance 295,202 449,071 449,071 347,747 101,324 77.4%
Total Internal Service Funds 19,341,538 22,038,622 24,768,868 21,866,716 2,902,152 88.3%
Total Non-Budgetary Expenditures 19,341,538$ 22,038,622$ 24,768,868$ 21,866,716$ 2,902,152$ 88.3%
Total Expenditures - All Funds 192,188,923$ 197,541,037$ 247,733,776$ 179,531,490$ 68,202,286$ 72.5%
9