| Governmental Activities | Business-Type Activities | Total |
| 2022 | 2021\n(Not Restated) | 2022 | 2021\n(Not Restated) | 2022 | 2021\n(Not Restated) |
| Program Revenues | | | | | | |
| Fines, fees, and charges for services | $ 4,049,421 | $ 4,344,375 | $ 10,088,283 | $ 9,862,460 | $ 14,137,704 | $ 14,206,835 |
| Operating grants and contributions | 7,946,421 | 10,514,432 | 95,836 | 512,241 | 8,042,257 | 11,026,673 |
| Capital grants and contributions | 962,569 | 6,497,650 | - | - | 962,569 | 6,497,650 |
| General Revenues | | | | | | |
| Property and other County tax | 34,164,139 | 34,051,730 | - | - | 34,164,139 | 34,051,730 |
| Penalty and interest on property tax | 193,268 | 322,611 | - | - | 193,268 | 322,611 |
| State tax credits | 2,570,815 | 2,618,123 | - | - | 2,570,815 | 2,618,123 |
| Local option sales tax | 5,412,295 | 4,836,411 | - | - | 5,412,295 | 4,836,411 |
| Gambling taxes | 669,842 | 634,355 | - | - | 669,842 | 634,355 |
| Unrestricted investment earnings | 221,937 | 394,575 | - | - | 221,937 | 394,575 |
| Miscellaneous | 920,825 | 1,065,494 | 146,307 | 140,256 | 1,067,132 | 1,205,750 |
| Total revenues | 57,111,532 | 65,279,756 | 10,330,426 | 10,514,957 | 67,441,958 | 75,794,713 |
| Program Expenses | | | | | | |
| Public safety and legal services | 17,397,392 | 17,620,663 | - | - | 17,397,392 | 17,620,663 |
| Physical health and social services | 2,232,111 | 2,863,496 | - | - | 2,232,111 | 2,863,496 |
| Mental health | 3,754,153 | 3,888,009 | - | - | 3,754,153 | 3,888,009 |
| County environment and education | 4,204,592 | 4,657,512 | - | - | 4,204,592 | 4,657,512 |
| Roads and transportation | 14,012,188 | 14,039,130 | - | - | 14,012,188 | 14,039,130 |
| Governmental services to residents | 1,876,299 | 2,189,711 | - | - | 1,876,299 | 2,189,711 |
| Administration | 4,743,464 | 4,736,765 | - | - | 4,743,464 | 4,736,765 |
| Non-program | 82,737 | 216,806 | - | - | 82,737 | 216,806 |
| Interest on long-term debt | 781,627 | 867,660 | - | - | 781,627 | 867,660 |
| Sunnycrest Operations | - | - | 10,890,763 | 12,032,885 | 10,890,763 | 12,032,885 |
| Total expenses | 49,084,563 | 51,079,752 | 10,890,763 | 12,032,885 | 59,975,326 | 63,112,637 |
| Increase (Decrease) in Net Position Before Transfers | 8,026,969 | 14,200,004 | (560,337) | (1,517,928) | 7,466,632 | 12,682,076 |
| Transfers | (1,427,469) | (1,171,000) | 1,427,469 | 1,171,000 | - | - |
| Increase (Decrease) in Net Position | 6,599,500 | 13,029,004 | 867,132 | (346,928) | 7,466,632 | 12,682,076 |
| Net Position (Deficit) Beginning of the Year, as restated | 166,876,225 | 153,847,221 | (2,639,254) | (2,292,326) | 164,236,971 | 151,554,895 |
| Net Position (Deficit) End of the Year | $ 173,475,725 | $ 166,876,225 | $ (1,772,122) | $ (2,639,254) | $ 171,703,603 | $ 164,236,971 |
Taxes increased by $112,409 or .33%, during the year. This increase represents a taxable valuation growth of 2.69%, along with a 4-cent decrease in the MHDD levy, a .908-cent increase in the general fund levy, and a .908-cent decrease in the debt service levy totaling a 4-cent decrease in the county wide levy. There was no change in the rural levy.
===== PAGE 15 =====
## Financial Analysis of the Government's Funds
As noted earlier, the County used fund accounting to ensure and demonstrate compliance with finance-related legal requirements.
Governmental funds. The focus of the County's governmental funds is to provide information on near-term inflows, outflows, and balances of spendable resources. Such information is useful in assessing the County's financing requirements. In particular, fund balance may serve as a useful measure of a County's net resources available for spending at the end of the fiscal year.
As of the end of the current fiscal year, the County's governmental funds reported combined ending fund balances of $54,539,100, a decrease of $2,852,243 in comparison with the prior year.
The general fund is the chief operating fund of the County. At the end of the current fiscal year, unassigned fund balance of the general fund was $17,804,097, while the total fund balance reached $25,283,435. As a measure of the general fund's liquidity, it may be useful to compare both unassigned fund balance and total fund balance to total fund expenditures. Unassigned fund balance represents 56.30% of total general fund expenditures, while total fund balance represents 79.95% of that same amount.
The fund balance of the County's general fund decreased $335,792 during the current fiscal year. Key factors in this decrease are as follows:
Revenues decreased $2,312,641, due to increases in revenue categories, property and other County tax of $678,409 along with decreases in intergovernmental of $1,896,587, use or money and property of $660,042 and miscellaneous of $217,488.
Expenses increased $1,288,025 primarily due to an increase in public safety and legal services of $1,723,249 and county environment and education of $888,647, along with a decrease of physical health and social services of $413,535 and administration of $245,089.
Other financing sources (uses) decreased due to a $426,582 decrease to transfers for the current year.
The rural services fund has a total fund balance of $485,473, which is an increase of $118,110 from the prior year. Key factors in this increase are as follows:
Revenues increased $133,110 due to increases in the property and other county tax revenue category.
Expenses decreased $42,386 due to decreased expenses in the county environment and education.
Other Financing Sources had an increase in funds transferred out of $106,704.
===== PAGE 16 =====
The secondary roads fund has a total fund balance of $9,999,262, which is a decrease of $429,268 from the prior year. Key factors in this decrease are as follows:
Revenue decreased $640,831 due to a decrease in the intergovernmental revenue category.
Expenses increased by $1,948,019 due to an increase in the capital projects of $2,537,165 along with a decrease of $589,146 in the roads and transportation activities.
An increase in Other Financing Sources of $84,982 is attributed to the increase in transfers of $136,704 along with an offsetting decrease of $51,722 for sale of capital assets.
The mental health fund has a total fund balance of $0, which is a decrease of $1,354,200 from the prior year. Key factors in this decrease are as follows:
Revenue decreased by $1,019,852, due to a decrease of $780,167 in the property and other County tax and a decrease of $239,821 in the intergovernmental revenue categories.
Expense decreased by $108,070 due to the decrease in the mental health activity.
The local option tax fund has a total fund balance of $4,870,923, which is a decrease of $321,979 from the prior year. A key factor in the decrease was:
Revenue increased by $854,209 due to $575,884 increase in property and other county tax along with an increase of $278,228 of miscellaneous revenues, while expenses increased by $3,272,899 due to more capital road projects.
The debt service fund has a total fund balance of $8,274,231, which is a decrease of $375,556 from the prior year.
Proprietary Funds. The County's proprietary fund provides the same type of information found in the government-wide financial statements, but in more detail.
The Sunnycrest Manor Operations proprietary fund has a total net position of $(1,772,122), an increase of $867,132 from the prior year. Key factors in the increase were:
An increase in revenues of $231,874 along with a decrease in expenses of $1,142,122 led to a $957,591 decrease in the fund's net loss.
There was a $256,469 increase in transfers to the fund.
===== PAGE 17 =====
## Budgetary Highlights
In accordance with the Code of Iowa, the Board of Supervisors annually adopts a budget following a required public notice and hearing for all governmental funds. Although the budget document presents functional disbursements by fund, the legal level of control is at the aggregated functional level, not at the fund or fund type level. The budget may be amended during the year utilizing similar statutorily prescribed procedures. The County budget is prepared on the cash basis.
Over the course of the year, the County amended its operating budget three times.
The first amendment, on November 8, 2021, net of transfers, increased revenues by $520,850 and increased disbursements by $5,929,596. This amendment reflects deliberations made by the Board of Supervisors during work sessions.
The second amendment, on March 21, 2022, net of transfers, increased revenues by $11,130,685 and increased disbursements by $2,373,937. This amendment reflects deliberations made by the Board of Supervisors during work sessions.
The third amendment, on May 31, 2022, net of transfers, increased revenue by $138,422 and increased disbursements by $998,663. This amendment reflects changes made by the Board of Supervisors during department work sessions and deliberations.
The net increase in revenues and other sources of $11,082,177 resulted in an amended total revenue of $71,396,751. The net increase in disbursements and other uses of $9,272,196 resulted in an amended total of $75,689,167.
Actual cash disbursements for the year totaled $58,213,620, which is $12,356,331 less than the final amended budget. The largest factor contributing to the difference were physical health and social services of $2,237,108 and county environment and education disbursements which were $2,329,364 less than the budgeted amount. This is largely due to timing of capital projects that were appropriated but not used in FY2023. Also contributing was roads and transportation disbursements due to timing of projects were $1,675,589 less than budgeted.
===== PAGE 18 =====
## CAPITAL ASSETS AND DEBT ADMINISTRATION
## Capital Assets
At the end of FY22, Dubuque County had $153,075,813 invested in a broad range of capital assets, including public safety equipment, buildings, park facilities, roads and bridges. This amount represents a net increase (including additions and deletions) of $3,660,673 or 2.45% over last year.
| Governmental Activities | Business-Type Activities | Total |
| Assets | | | |
| Cash and Pooled Investments | $ 67,161,156 | $ 122,485 | $ 67,283,641 |
| Receivables | | | |
| Property tax | | | |
| Delinquent | 61,553 | - | 61,553 |
| Succeeding year | 33,991,225 | - | 33,991,225 |
| Interest and penalty on property tax | 40,266 | - | 40,266 |
| Accounts | 102,756 | 28,964 | 131,720 |
| Accrued interest | 7,741 | - | 7,741 |
| Due from Other Governments | 8,721,571 | 3,412,076 | 12,133,647 |
| Prepaid Expenses | 1,112,057 | 32,517 | 1,144,574 |
| Inventories | 1,152,890 | 75,885 | 1,228,775 |
| Notes Receivable | 498,730 | - | 498,730 |
| Lease Receivable | 208,153 | - | 208,153 |
| Capital Assets | | | |
| Capital assets, not being depreciated | 10,474,723 | - | 10,474,723 |
| Capital assets (net of accumulated depreciation) | 142,601,090 | - | 142,601,090 |
| Net Pension Asset | 7,264,077 | - | 7,264,077 |
| Total assets | 273,397,988 | 3,671,927 | 277,069,915 |
| Deferred Outflows of Resources | | | |
| Pension Related Deferred Outflows | 2,671,051 | 861,934 | 3,532,985 |
| OPEB Related Deferred Outflows | 358,792 | 138,803 | 497,595 |
| Total deferred outflows of resources | 3,029,843 | 1,000,737 | 4,030,580 |
| Liabilities | | | |
| Accounts Payable | 3,367,664 | 346,141 | 3,713,805 |
| Salaries and Benefits Payable | 1,085,603 | 351,138 | 1,436,741 |
| Accrued Interest Payable | 63,283 | - | 63,283 |
| Due to Other Governments | 311,080 | 61,360 | 372,440 |
| Unearned Revenue | 19,030,744 | - | 19,030,744 |
| Long-Term Liabilities | | | |
| Portion due or payable within one year | | | |
| Bonds and notes payable, net | 2,139,186 | - | 2,139,186 |
| Compensated absences | 1,581,207 | 240,820 | 1,822,027 |
| Portion due or payable after one year | | | |
| Bonds and notes payable, net | 22,883,095 | - | 22,883,095 |
| Compensated absences | 3,261,575 | 496,741 | 3,758,316 |
| Net pension liability | - | 105,670 | 105,670 |
| Total OPEB liability | 1,797,728 | 770,638 | 2,568,366 |
| Total liabilities | 55,521,165 | 2,372,508 | 57,893,673 |
===== PAGE 22 =====
| Governmental Activities | Business-Type Activities | Total |
| Deferred Inflows of Resources | | | |
| Deferred Property Tax Revenue | $ 33,991,225 | $ - | $ 33,991,225 |
| Deferred Items Related to Leases | 208,153 | - | 208,153 |
| Pension Related Deferred Inflows | 12,941,555 | 3,954,237 | 16,895,792 |
| OPEB Related Deferred Inflows | 290,008 | 118,041 | 408,049 |
| Total deferred inflows of resources | 47,430,941 | 4,072,278 | 51,503,219 |
| Net Position | | | |
| Net Investment in Capital Assets | 135,238,024 | - | 135,238,024 |
| Restricted For | | | |
| Supplemental levy purposes | 6,437,803 | - | 6,437,803 |
| Secondary roads purposes | 10,083,819 | - | 10,083,819 |
| Economic development | 865,309 | - | 865,309 |
| Debt service | 1,154,616 | - | 1,154,616 |
| Capital projects | 7,732,598 | - | 7,732,598 |
| Other purposes | 1,596,753 | - | 1,596,753 |
| Unrestricted (Deficit) | 10,366,803 | (1,772,122) | 8,594,681 |
| Total net position (deficit) | $ 173,475,725 | $ (1,772,122) | $ 171,703,603 |
===== PAGE 23 =====
| Expenses | Program Revenues | Net (Expense) Revenue and Changes in Net Position |
| Fees, Fines and Charges for Services | Operating Grants and Contributions | Capital Grants and Contributions | Governmental Activities | Business Type Activities | Total |
| Functions/Programs | | | | | | | |
| Governmental Activities | | | | | | | |
| Public safety and legal services | $ 17,397,392 | $ 1,095,972 | $ 596,473 | $ - | $ (15,704,947) | $ - | $ (15,704,947) |
| Physical health and social services | 2,232,111 | 41,942 | 748,345 | - | (1,441,824) | - | (1,441,824) |
| Mental health | 3,754,153 | 325,152 | - | - | (3,429,001) | - | (3,429,001) |
| County environment and education | 4,204,592 | 563,912 | 177,884 | 18,811 | (3,443,985) | - | (3,443,985) |
| Roads and transportation | 14,012,188 | 106,771 | 6,130,007 | 925,357 | (6,850,053) | - | (6,850,053) |
| Governmental services to residents | 1,876,299 | 1,801,971 | 10,000 | - | (64,328) | - | (64,328) |
| Administration | 4,743,464 | 113,701 | 55,203 | - | (4,574,560) | - | (4,574,560) |
| Non-program | 82,737 | - | - | 18,401 | (64,336) | - | (64,336) |
| Interest on long-term debt | 781,627 | - | 228,509 | - | (553,118) | - | (553,118) |
| Total Governmental Activities | 49,084,563 | 4,049,421 | 7,946,421 | 962,569 | (36,126,152) | - | (36,126,152) |
| Business Type Activities | | | | | | | |
| Sunnycrest operations | 10,890,763 | 10,088,283 | 95,836 | - | - | (706,644) | (706,644) |
| Total Government | $ 59,975,326 | $ 14,137,704 | $ 8,042,257 | $ 962,569 | (36,126,152) | (706,644) | (36,832,796) |
| General Revenues | | | | | | | |
| Property and other County tax levied for General purposes | | | | | | | |
| Debt service | | | | | 32,118,153 | - | 32,118,153 |
| Penalty and interest on property tax | | | | | 2,045,986 | - | 2,045,986 |
| State tax credits | | | | | 193,268 | - | 193,268 |
| Local option sales tax | | | | | 2,570,815 | - | 2,570,815 |
| Gambling taxes | | | | | 5,412,295 | - | 5,412,295 |
| Unrestricted investment earnings | | | | | 669,842 | - | 669,842 |
| Miscellaneous | | | | | 221,937 | - | 221,937 |
| | | | | 920,825 | 146,307 | 1,067,132 |
| Total General Revenues | | | | | 44,153,121 | 146,307 | 44,299,428 |
| Transfers | | | | | (1,427,469) | 1,427,469 | - |
| Change in Net Position | | | | | 6,599,500 | 867,132 | 7,466,632 |
| Net Position (Deficit) Beginning of Year, as restated | | | | | 166,876,225 | (2,639,254) | 164,236,971 |
| Net Position (Deficit) End of Year | | | | | $ 173,475,725 | $ (1,772,122) | $ 171,703,603 |
===== PAGE 24 =====
| | Special Revenue | Capital Projects | Debt Service | Nonmajor Governmental Funds | Total Governmental Funds |
| General | Rural Services | Secondary Roads | American Rescue Plan | Mental Health | Local Option Tax |
| Liabilities, Deferred Inflows of Resources, and Fund Balances | | | | | | | | | | |
| Liabilities | | | | | | | | | | |
| Accounts payable | $ 1,050,977 | $ 3,530 | $ 780,534 | $ - | $ - | $ 1,531,623 | $ 1,000 | $ - | $ 3,367,664 | |
| Salaries and benefits payable | 884,089 | 12,487 | 189,027 | - | - | - | - | - | 1,085,603 | |
| Due to other funds | 6,499 | 568 | - | - | - | - | - | - | 7,067 | |
| Due to other governments | 195,055 | 105 | 115,920 | - | - | - | - | - | 311,080 | |
| Unearned revenue | 129,223 | - | - | 18,901,521 | - | - | - | - | 19,030,744 | |
| Total liabilities | 2,265,843 | 16,690 | 1,085,481 | 18,901,521 | - | 1,531,623 | 1,000 | - | 23,802,158 | |
| Deferred Inflows of Resources | | | | | | | | | | |
| Unavailable revenues | | | | | | | | | | |
| Succeeding year | | | | | | | | | | |
| property tax | 26,130,423 | 5,746,909 | - | - | - | - | 2,113,893 | - | 33,991,225 | |
| Other | 421,757 | 15,066 | 84,557 | - | - | - | 3,149 | - | 524,529 | |
| Deferred items related to leases | 208,153 | - | - | - | - | - | - | - | 208,153 | |
| Total deferred inflows of resources | 26,760,333 | 5,761,975 | 84,557 | - | - | - | 2,117,042 | - | 34,723,907 | |
| Fund Balances | | | | | | | | | | |
| Nonspendable | 1,301,919 | - | 1,029,028 | - | - | - | - | - | 2,330,947 | |
| Restricted | 6,177,419 | 485,473 | 8,970,234 | - | - | 4,870,923 | 8,274,231 | 5,023,477 | 33,801,757 | |
| Committed | - | - | - | - | - | - | - | 602,299 | 602,299 | |
| Unassigned | 17,804,097 | - | - | - | - | - | - | - | 17,804,097 | |
| Total fund balances | 25,283,435 | 485,473 | 9,999,262 | - | - | 4,870,923 | 8,274,231 | 5,625,776 | 54,539,100 | |
| Total liabilities, deferred inflows of resources, and fund balances | $ 54,309,611 | $ 6,264,138 | $ 11,169,300 | $ 18,901,521 | $ - | $ 6,402,546 | $ 10,392,273 | $ 5,625,776 | $ 113,065,165 | |
===== PAGE 26 =====
| Total Governmental Fund Balances | $ 54,539,100 |
| Amounts Reported for Governmental Activities in the Statement of Net Position is Different Because: |
| Capital assets used in governmental activities are not current financial resources and, therefore, are not reported in the governmental funds. |
| These assets consist of: |
| Land | $ 5,586,516 |
| Construction in progress | 4,888,207 |
| Infrastructure, net of $79,674,247 accumulated depreciation | 96,067,151 |
| Buildings, net of $11,879,905 accumulated depreciation | 26,272,700 |
| Machinery and equipment, net of $13,005,425 accumulated depreciation | 18,355,929 |
| Improvements other than buildings, net of $1,387,649 accumulated depreciation | 1,905,310 |
| Total capital assets | 153,075,813 |
| Other long-term assets are not available to pay current period expenditures and, therefore, are deferred in the governmental funds. |
| Property taxes and intergovernmental | 524,529 |
| Pension and OPEB related deferred outflows of resources and deferred inflows of resources are not due and payable in the current year and, therefore, are not reported in the governmental funds, as follows: |
| Deferred outflows of resources | 3,029,843 |
| Deferred inflows of resources | (13,231,563) |
| Net pension asset | 7,264,077 |
| Long-term liabilities applicable to the County's governmental activities are not due and payable in the current period and, therefore, are not reported as fund liabilities. Interest on long-term debt is not accrued in governmental funds, but rather is recognized as an expenditure when due. All liabilities - both current and long-term - are reported in the Statement of Net Position. |
| Balances at June 30, 2022 are: |
| Accrued interest on debt | (63,283) |
| Bonds and notes payable | (24,549,492) |
| Unamortized premiums on the issuance of bonds | (472,789) |
| Compensated absences | (4,842,782) |
| Total OPEB liability | (1,797,728) |
| Total long-term liabilities | (31,726,074) |
| Net Position of Governmental Activities | $ 173,475,725 |
===== PAGE 27 =====
| | Special Revenue | Capital Projects | Nonmajor Governmental Funds | Total Governmental Funds |
| General | Rural Services | Secondary Roads | American Rescue Plan | Mental Health | Local Option Tax | Debt Service |
| Revenues | | | | | | | | | |
| Property and other County tax | $ 25,224,411 | $ 5,499,757 | $ - | $ - | $ 1,957,087 | $ 5,412,295 | $ 2,049,259 | $ 118,288 | $ 40,261,097 |
| Interest and penalty on property tax | 191,455 | - | - | - | - | - | - | - | 191,455 |
| Intergovernmental | 4,244,974 | 287,489 | 6,144,918 | - | 498,436 | - | 391,380 | 41,568 | 11,608,765 |
| Licenses and permits | 69,317 | 14,600 | 79,430 | - | - | - | - | - | 163,347 |
| Charges for service | 2,849,731 | 40,847 | 6,825 | - | - | - | - | 239,218 | 3,136,621 |
| Use of money and property | (199,047) | - | 5,251 | - | - | 13,097 | - | 5,449 | (175,250) |
| Miscellaneous | 431,231 | - | 194,057 | - | 136 | 278,228 | - | 39,135 | 942,787 |
| Total revenues | 32,812,072 | 5,842,693 | 6,430,481 | - | 2,455,659 | 5,703,620 | 2,440,639 | 443,658 | 56,128,822 |
| Expenditures | | | | | | | | | |
| Operating | | | | | | | | | |
| Public safety and legal services | 17,954,582 | - | - | - | - | - | - | 304,967 | 18,259,549 |
| Physical health and social services | 2,427,504 | - | - | - | - | - | - | - | 2,427,504 |
| Mental health | - | - | - | - | 3,809,859 | - | - | - | 3,809,859 |
| County environment and education | 4,221,224 | 957,367 | - | - | - | - | - | 130,972 | 5,309,563 |
| Roads and transportation | 36,672 | - | 8,680,668 | - | - | - | - | - | 8,717,340 |
| Governmental services to residents | 2,066,922 | - | - | - | - | - | - | - | 2,066,922 |
| Administration | 4,759,232 | - | - | - | - | - | - | - | 4,759,232 |
| Non-program | 82,737 | - | - | - | - | - | - | - | 82,737 |
| Debt service | - | - | - | - | - | - | 2,814,195 | 42,450 | 2,856,645 |
| Capital projects | 73,522 | - | 2,878,019 | - | - | 6,025,599 | - | 289,965 | 9,267,105 |
| Total expenditures | 31,622,395 | 957,367 | 11,558,687 | - | 3,809,859 | 6,025,599 | 2,814,195 | 768,354 | 57,556,456 |
| Excess (Deficiency) of Revenues Over (Under) Expenditures | 1,189,677 | 4,885,326 | (5,128,206) | - | (1,354,200) | (321,979) | (373,556) | (324,696) | (1,427,634) |
| Other Financing Sources (Uses) | | | | | | | | | |
| Transfers in | 2,000 | - | 4,697,216 | - | - | - | - | 170,000 | 4,869,216 |
| Transfers out | (1,527,469) | (4,767,216) | - | - | - | - | (2,000) | - | (6,296,685) |
| Sale of capital assets | - | - | 1,722 | - | - | - | - | 1,138 | 2,860 |
| Total Other Financing Sources (Uses) | (1,525,469) | (4,767,216) | 4,698,938 | - | - | - | (2,000) | 171,138 | (1,424,609) |
| Net Change in Fund Balances | (335,792) | 118,110 | (429,268) | - | (1,354,200) | (321,979) | (375,556) | (153,558) | (2,852,243) |
| Fund Balances Beginning of Year, as restated | 25,619,227 | 367,363 | 10,428,530 | - | 1,354,200 | 5,192,902 | 8,649,787 | 5,779,334 | 57,391,343 |
| Fund Balances End of Year | $ 25,283,435 | $ 485,473 | $ 9,999,262 | $ - | $ - | $ 4,870,923 | $ 8,274,231 | $ 5,625,776 | $ 54,539,100 |
===== PAGE 28 =====
| Net Change in Fund Balances - Total Governmental Funds | (2,852,243) < /td > < /tr > < tr > < td style = 'text-align: center; word-wrap: break-word;' > Amounts Reported for Governmental Activities in the Statement of Activities are Different Because:nGovernmental funds report capital outlays as expenditures while governmental activities report depreciation expense to allocate those expenditures over the life of the assets. Capital outlay expenditures and contributed capital assets exceeded depreciation expense in the current year, as follows:nExpenditures for capital assets < /td > < td style = 'text-align: center; word-wrap: break-word;' > 11,068,326 |
| Contributed capital assets | 860,412 |
| Depreciation expense | (8,073,534) |
| In the Statement of Activities, only the gain or the loss of capital assets is reported, whereas in the governmental funds, the entire proceeds from the sale increase financial resources. Thus, the change in net position differs from the change in fund balances by the book value of assets being disposed. | 3,855,204 |
| Debt proceeds and capital leases are reported as financing sources in governmental funds and thus contribute to the change in fund balance. In the Statement of Net Position, however, issuing debt increases long-term liabilities and does not affect the Statement of Activities. Similarly, repayment of principal is an expenditure in the governmental funds but reduces the liability in the Statement of Net Position. Amortization of bond premiums | (194,531) |
| Repayments | 42,981 |
| 2,025,802 |
| Because some revenues will not be collected for several months after the County's year end, they are not considered available revenues and are deferred in the governmental funds as follows: Property tax | 2,068,783 |
| Grant proceeds | (13,007) |
| 132,445 |
| The current year County employer share of IPERS contributions are reported as expenditures in the governmental funds, but are reported as a deferred inflow of resources in the Statement of Net Position. | 119,438 |
| Some expenses reported in the Statement of Activities do not require the use of current financial resources and, therefore, are not reported as expenditures in the governmental funds as follows: Change in accrued interest on debt | 6,235 |
| Change in compensated absences | 368,122 |
| Pension income | 1,768,430 |
| OPEB expense | (122,823) |
| 2,019,964 |
| Change in Net Position of Governmental Activities | $ 6,599,500 |
===== PAGE 29 =====
| Sunnycrest Operations |
| Assets | |
| Cash and Pooled Investments | $ 122,485 |
| Receivables | |
| Accounts | 28,964 |
| Due From Other Governments | 3,412,076 |
| Inventories | 75,885 |
| Prepaid Expenses | 32,517 |
| Total assets | 3,671,927 |
| Deferred Outflows of Resources | |
| Pension Related Deferred Outflows | 861,934 |
| OPEB Related Deferred Outflows | 138,803 |
| Total deferred outflows of resources | 1,000,737 |
| Liabilities | |
| Accounts payable | 346,141 |
| Salaries and benefits payable | 351,138 |
| Due to other governments | 61,360 |
| Long-Term Liabilities | |
| Portions due or payable within one year | |
| Compensated absences | 240,820 |
| Portions due or payable after one year | |
| Compensated absences | 496,741 |
| Net pension liability | 105,670 |
| Total OPEB liability | 770,638 |
| Total liabilities | 2,372,508 |
| Deferred Inflows of Resources | |
| Pension Related Deferred Inflows | 3,954,237 |
| OPEB Related Deferred Inflows | 118,041 |
| Total deferred inflows of resources | 4,072,278 |
| Net Position | |
| Unrestricted (Deficit) | $ (1,772,122) |
| Sunnycrest Operations |
| Cash Flows From Operating Activities | |
| Cash received from services provided | $ 9,731,867 |
| Cash received from other revenues | 146,307 |
| Cash paid for personnel services | (8,508,706) |
| Cash paid to suppliers | (2,981,948) |
| Net cash (used in) operating activities | (1,612,480) |
| Cash Flows From Noncapital Financing Activities | |
| Transfer from the General Fund | 1,427,469 |
| Grants received | 95,836 |
| Net cash provided by noncapital financing activities | 1,523,305 |
| Net Decrease in Cash and Cash Equivalents | (89,175) |
| Cash and Cash Equivalents Beginning of Year | 211,660 |
| Cash and Cash Equivalents End of Year | $ 122,485 |
| Reconciliation of Operating Loss to Net Cash Used For Operating Activities | |
| Operating loss | $ (656,173) |
| Adjustments to reconcile operating loss to net cash used in operating activities | |
| Changes in assets and liabilities | |
| Receivables | (356,416) |
| Inventory | (8,879) |
| Prepaids | (4,247) |
| Accounts payable | 292,374 |
| Accrued liabilities | (45,292) |
| Net pension liability | (5,052,460) |
| Deferred outflow of resources | 340,156 |
| Deferred inflow of resources | 3,801,651 |
| Other post employment benefit obligation | 76,806 |
| Net cash (used in) operating activities | $ (1,612,480) |
===== PAGE 32 =====
| Balance Beginning of Year | Increases | Decreases | Balance End of Year |
| Governmental Activities | | | | |
| Capital assets not being depreciated | | | | |
| Land and land improvements | $ 5,493,452 | $ 93,064 | $ - | $ 5,586,516 |
| Construction in progress | 3,272,956 | 10,319,387 | 8,704,136 | 4,888,207 |
| Total capital assets, not being depreciated | 8,766,408 | 10,412,451 | 8,704,136 | 10,474,723 |
| Capital assets being depreciated | | | | |
| Buildings | 37,267,536 | 885,069 | - | 38,152,605 |
| Improvements other than buildings | 3,268,359 | 24,600 | - | 3,292,959 |
| Machinery and equipment | 33,457,790 | 1,525,421 | 3,621,857 | 31,361,354 |
| Infrastructure | 167,956,065 | 7,785,333 | - | 175,741,398 |
| Total capital assets, being depreciated | 241,949,750 | 10,220,423 | 3,621,857 | 248,548,316 |
| Less accumulated depreciation for Buildings | 10,912,538 | 967,367 | - | 11,879,905 |
| Improvements other than buildings | 1,271,030 | 116,619 | - | 1,387,649 |
| Machinery and equipment | 14,282,872 | 2,149,879 | 3,427,326 | 13,005,425 |
| Infrastructure | 74,834,578 | 4,839,669 | - | 79,674,247 |
| Total accumulated depreciation | 101,301,018 | 8,073,534 | 3,427,326 | 105,947,226 |
| Total capital assets, being depreciated, net | 140,648,732 | 2,146,889 | 194,531 | 142,601,090 |
| Governmental Activities Capital Assets, Net | $ 149,415,140 | $ 12,559,340 | $ 8,898,667 | $ 153,075,813 |
===== PAGE 47 =====
Depreciation expense was charged to the following functions of the County:
| Governmental Funds | Budgeted Amounts | Final to Net Variance - Positive (Negative) |
| Actual | Original | Final |
| Receipts | | | | |
| Property and other County tax | $ 40,220,218 | $ 38,855,730 | $ 39,315,927 | $ 904,291 |
| Interest and penalty on property tax | 215,898 | 116,000 | 116,000 | 99,898 |
| Intergovernmental | 21,602,136 | 10,684,285 | 22,027,228 | (425,092) |
| Licenses and permits | 153,188 | 126,380 | 126,380 | 26,808 |
| Charges for service | 2,894,618 | 2,641,542 | 2,772,858 | 121,760 |
| Use of money and property | 227,496 | 710,186 | 577,114 | (349,618) |
| Miscellaneous | 913,587 | 1,353,455 | 1,342,028 | (428,441) |
| Total receipts | 66,227,141 | 54,487,578 | 66,277,535 | (50,394) |
| Disbursements | | | | |
| Public safety and legal services | 18,137,703 | 18,163,635 | 19,370,425 | 1,232,722 |
| Physical health and social services | 3,942,028 | 6,336,083 | 6,179,136 | 2,237,108 |
| Mental health | 3,772,567 | 3,606,757 | 3,908,646 | 136,079 |
| County environment and education | 5,208,779 | 5,184,225 | 7,538,143 | 2,329,364 |
| Roads and transportation | 8,468,281 | 9,733,605 | 10,143,870 | 1,675,589 |
| Governmental services to residents | 2,054,071 | 2,323,935 | 2,363,705 | 309,634 |
| Administration | 4,708,376 | 5,731,981 | 6,387,029 | 1,678,653 |
| Non-program | 25,533 | 1,190,000 | 1,200,000 | 1,174,467 |
| Debt service | 2,813,195 | 2,813,646 | 2,813,646 | 451 |
| Capital projects | 9,083,087 | 6,183,888 | 10,665,351 | 1,582,264 |
| Total disbursements | 58,213,620 | 61,267,755 | 70,569,951 | 12,356,331 |
| Excess (Deficiency) of Receipts Over (Under) | | | | |
| Disbursements | 8,013,521 | (6,780,177) | (4,292,416) | 12,305,937 |
| Other Financing Sources, Net | 666,369 | - | - | 666,369 |
| Excess (Deficiency) of Receipts and Other Financing | | | | |
| Sources Over (Under) Disbursements and Other | | | | |
| Financing Uses | 8,679,890 | (6,780,177) | (4,292,416) | 12,972,306 |
| Balance Beginning of Year | 58,259,767 | 31,361,912 | 57,829,065 | 430,702 |
| Balance End of Year | $ 66,939,657 | $ 24,581,735 | $ 53,536,649 | $ 13,403,008 |
| Reconciliation Between Cash and Modified | | | | |
| Accrual Basis | Governmental Funds | |
| Cash | Accrual | Modified | |
| Basis | Adjustments | Accrual Basis | |
| Revenues | $ 66,227,141 | $ (10,098,319) | $ 56,128,822 | |
| Expenditures | 58,213,620 | (657,164) | 57,556,456 | |
| Net | 8,013,521 | (9,441,155) | (1,427,634) | |
| Other Financing Sources, Net | 666,369 | (2,090,978) | (1,424,609) | |
| Beginning Fund Balances | 58,259,767 | (868,424) | 57,391,343 | |
| Ending Fund Balances | $ 66,939,657 | $ (12,400,557) | $ 54,539,100 | |
===== PAGE 64 =====
The budgetary comparison is presented as Required Supplementary Information in accordance with Governmental Accounting Standards Board Statement No. 41 for governments with significant budgetary perspective differences resulting from not being able to present budgetary comparisons for the General Fund and each major Special Revenue Fund.
In accordance with the Code of Iowa, the County Board of Supervisors annually adopts a budget on the cash basis following required public notice and hearing for all funds, except the Commissary Special Revenue Funds and Custodial Funds, and appropriates the amount deemed necessary for each of the different County offices and departments. The budget may be amended during the year utilizing similar statutorily prescribed procedures. Encumbrances are not recognized on the cash basis budget and appropriations lapse at year end.
Formal and legal budgetary control is based upon ten major classes of expenditures known as functions, not by fund. These ten functions are: public safety and legal services, physical health and social services, mental health, county environment and education, roads and transportation, governmental services to residents, administration, non-program, debt service and capital projects. Function disbursements required to be budgeted include disbursements for the General Fund, the Special Revenue Funds, the Debt Service Fund, and the Capital Projects Fund. Although the budget document presents function disbursements by fund, the legal level of control is at the aggregated function level, not by fund. Legal budgetary control is also based upon the appropriation to each office or department. During the year, three budget amendments increased budgeted disbursements by $9,302,196. The budget amendments are reflected in the final budgeted amounts.
In addition, annual budgets are similarly adopted in accordance with the Code of Iowa by the appropriate governing body as indicated: for the County Extension Office by the County Agricultural Extension Council, for the County Assessor by the County Conference Board, for the City Assessor by the City Conference Board, for the 911 System by the Joint 911 Service Board, and for Emergency Management Services by the County Emergency Management Commission.
During the year ended June 30, 2022, disbursements did not exceed the amounts budgeted by function. However, disbursements in certain departments exceeded the amounts appropriated.
===== PAGE 65 =====
| Special Revenue |
| REAP Fund | County Recorder's Records Management | Rural Economic Development | Gold Dome | Sheriff Forfeiture | TIF | Drug Task Force | Rural Community Transportation | Commissary |
| Revenues | | | | | | | | | |
| Property and other County tax | $ - | $ - | $ - | $ - | $ - | $ 118,288 | $ - | $ - | $ - |
| Intergovernmental Charges for service | 28,884 | - | - | - | - | 12,684 | - | - | - |
| Use of money and property | - | 18,602 | - | - | - | - | - | - | 220,616 |
| Miscellaneous | 129 | 37 | 4,755 | 56 | 456 | - | 16 | - | - |
| - | - | - | - | - | - | 37,614 | - | 21 |
| Total revenues | 29,013 | 18,639 | 4,755 | 56 | 456 | 130,972 | 37,630 | - | 220,637 |
| Expenditures | | | | | | | | | |
| Operating | | | | | | | | | |
| Public safety and legal services | - | - | - | - | 26,881 | - | 50,985 | - | 227,101 |
| County environment and education | - | - | - | - | - | 130,972 | - | - | - |
| Debt Service | - | - | 42,450 | - | - | - | - | - | - |
| Capital projects | - | - | - | - | - | - | - | 70,000 | - |
| Total expenditures | - | - | 42,450 | - | 26,881 | 130,972 | 50,985 | 70,000 | 227,101 |
| Excess (Deficiency) of Revenues Over (Under) Expenditures | 29,013 | 18,639 | (37,695) | 56 | (26,425) | - | (13,355) | (70,000) | (6,464) |
| Other Financing Sources | | | | | | | | | |
| Transfers in | - | - | - | - | - | - | - | 70,000 | - |
| Sale of capital assets | - | - | - | - | - | - | 1,138 | - | - |
| Total Other Financing Sources | - | - | - | - | - | - | 1,138 | 70,000 | - |
| Net Change in Fund Balances | 29,013 | 18,639 | (37,695) | 56 | (26,425) | - | (12,217) | - | (6,464) |
| Fund Balances Beginning of Year | 109,685 | 27,664 | 1,028,015 | 56,242 | 306,241 | - | 163,078 | 75,268 | 430,702 |
| Fund Balances End of Year | $ 138,698 | $ 46,303 | $ 990,320 | $ 56,298 | $ 279,816 | $ - | $ 150,861 | $ 75,268 | $ 424,238 |
===== PAGE 73 =====
| Capital Projects | |
| Capital Projects | Conservation Land Acquisition | Emergency Radio System | West Campus Complex | Courthouse Roof | Total |
| Revenues | | | | | | |
| Property and other County tax | $ - | $ - | $ - | $ - | $ - | $ 118,288 |
| Intergovernmental Charges for service | - | - | - | - | - | 41,568 |
| Use of money and property | - | - | - | - | - | 239,218 |
| Miscellaneous | - | - | 1,500 | - | - | 5,449 |
| | | | | | 39,135 |
| Total revenues | - | - | 1,500 | - | - | 443,658 |
| Expenditures | | | | | | |
| Operating | | | | | | |
| Public safety and legal services | - | - | - | - | - | 304,967 |
| County environment and education | - | - | - | - | - | 130,972 |
| Debt Service | - | - | - | - | - | 42,450 |
| Capital projects | - | 112,222 | 107,743 | - | - | 289,965 |
| Total expenditures | - | 112,222 | 107,743 | - | - | 768,354 |
| Excess (Deficiency) of Revenues Over (Under) Expenditures | - | (112,222) | (106,243) | - | - | (324,696) |
| Other Financing Sources | | | | | | |
| Transfers in | | 100,000 | - | - | - | 170,000 |
| Sale of capital assets | - | - | - | - | - | 1,138 |
| Total Other Financing Sources | - | 100,000 | - | - | - | 171,138 |
| Net Change in Fund Balances | - | (12,222) | (106,243) | - | - | (153,558) |
| Fund Balances Beginning of Year | 2,200,000 | 292,573 | 463,262 | 602,299 | 24,305 | 5,779,334 |
| Fund Balances End of Year | $ 2,200,000 | $ 280,351 | $ 357,019 | $ 602,299 | $ 24,305 | $ 5,625,776 |
===== PAGE 74 =====
| County Auditor | County Recorder | County Recorder's Electronic Transaction | County Sheriff | 911 Fund | Drainage District Fund | Agricultural Extension Education Fund | County Assessor Fund | City Assessor Fund | Schools Fund |
| Assets | | | | | | | | | | |
| Cash and Pooled Investments | | | | | | | | | | |
| County Treasurer | $ - | $ - | $ 2,710 | $ - | $ 1,026,948 | $ 734 | $ 2,465 | $ 553,357 | $ 316,398 | $ 330,803 |
| Other County officials | 6,632 | 145,503 | - | 199,386 | - | - | - | - | - | - |
| Receivables | | | | | | | | | | |
| Property tax | | | | | | | | | | |
| Delinquent | - | - | - | - | - | - | 1,026 | 1,519 | 930 | 117,291 |
| Succeeding year | - | - | - | - | - | - | 618,562 | 740,860 | 731,978 | 70,568,658 |
| Special assessments | - | - | - | - | - | - | - | - | - | - |
| Accounts | - | 5,942 | - | - | 35,961 | - | - | - | - | - |
| Due From Other Governments | - | - | - | - | 86,990 | - | - | - | - | - |
| Total assets | 6,632 | 151,445 | 2,710 | 199,386 | 1,149,899 | 734 | 622,053 | 1,295,736 | 1,049,306 | 71,016,752 |
| Liabilities, Deferred Inflows of Resources, and Fund Balances | | | | | | | | | | |
| Liabilities | | | | | | | | | | |
| Accounts payable | - | - | - | - | 5,325 | - | - | 2,586 | 1,500 | - |
| Salaries and benefits payable | - | - | - | - | - | - | - | 21,642 | 30,907 | - |
| Due to other governments | - | 151,445 | 2,710 | 112,758 | - | 734 | 3,491 | - | - | 448,094 |
| Trust payable | 6,608 | - | - | 86,628 | - | - | - | - | - | - |
| Total liabilities | 6,608 | 151,445 | 2,710 | 199,386 | 5,325 | 734 | 3,491 | 24,228 | 32,407 | 448,094 |
| Deferred Inflows of Resources | | | | | | | | | | |
| Unavailable revenues | | | | | | | | | | |
| Succeeding year | | | | | | | | | | |
| property tax | - | - | - | - | - | - | 618,562 | 740,860 | 731,978 | 70,568,658 |
| Net Position | | | | | | | | | | |
| Restricted for individuals, organizations and other governments | $ 24 | $ - | $ - | $ - | $ 1,144,574 | $ - | $ - | $ 530,648 | $ 284,921 | $ - |
===== PAGE 75 =====
| Area | Townships | Auto License and Use Tax Fund | Brucellosis and Tuberculosis Eradication Fund | Joint Disaster Services Fund | County Hospital Fund | County Libraries | Tax Sales | Total | |
| Area | Townships | Auto License and Use Tax Fund | Brucellosis and Tuberculosis Eradication Fund | Joint Disaster Services Fund | County Hospital Fund | County Libraries | Tax Sales | Total | |
| Assets | | | | | | | | | | | | | |
| Cash and Pooled Investments | | | | | | | | | | | | | |
| County Treasurer | $ | 23,025 | $ | 334,590 | $ | 5,699 | $ | 4,206,827 | $ | 116,225 | $ | 81,196 | $ 444,178 |
| Other County officials | - | - | - | - | - | - | - | - | - | - | - | - | |
| Receivables | | | | | | | | | | | | | |
| Property tax | | | | | | | | | | | | | |
| Delinquent | 7,872 | | 53,964 | | 2,601 | | - | 21 | - | 2,345 | - | - | |
| Succeeding year | 4,915,923 | | 34,308,427 | | 952,308 | | - | 12,572 | - | 1,414,395 | - | - | |
| Special assessments | - | | 4,935 | | - | | - | - | - | - | - | - | |
| Accounts | - | | - | | - | | - | - | - | - | - | - | |
| Due From Other Governments | - | | - | | - | | - | - | - | - | - | 41,903 | |
| | | | | | | | | | | | 86,990 | |
| Total assets | 4,946,820 | | 34,701,916 | | 960,608 | | 4,206,827 | 12,731 | 116,225 | 1,497,936 | 444,178 | - | |
| Liabilities, Deferred Inflows of Resources, and Fund Balances | | | | | | | | | | | | | |
| Liabilities | | | | | | | | | | | | | |
| Accounts payable | - | | - | | - | | - | 2,547 | - | 9,613 | - | 21,571 | |
| Salaries and benefits payable | - | | - | | - | | - | 4,793 | - | 31,417 | - | 88,759 | |
| Due to other governments | 30,897 | | 393,489 | | 8,300 | | 4,206,827 | 159 | 32 | 8,610 | 304 | 5,367,850 | |
| Trust payable | - | | - | | - | | - | - | 74,931 | - | - | 168,167 | |
| Total liabilities | 30,897 | | 393,489 | | 8,300 | | 4,206,827 | 159 | 7,372 | 83,541 | 41,334 | - | |
| Deferred Inflows of Resources Unavailable revenues | | | | | | | | | | | | | |
| Succeeding year | | | | | | | | | | | | | |
| property tax | 4,915,923 | | 34,308,427 | | 952,308 | | - | 12,572 | - | 1,414,395 | - | - | |
| Net Position | | | | | | | | | | | | | |
| Restricted for individuals, organizations and other governments | $ | - | $ | - | $ | - | $ | - | $ | 108,853 | $ 402,844 | $ - | |
===== PAGE 76 =====
Dubuque County
Schedule 4 – Combining Statement of Changes in Fiduciary Net Position
Custodial Funds
Year Ended June 30, 2022
| Federal Grantor/Pass-Through Grantor/Program or Cluster Title | Federal Financial Assistance Listing/CFDA Number | Pass-Through Entity Identifying Number | Federal Expenditures | Amounts Passed-Through to Subrecipients |
| Department of Agriculture\nPass-Through Program From Iowa Department of Human Services Human Services Administrative Reimbursement SNAP Cluster State Administrative Matching Grants for the Supplemental Nutrition Assistance Program | 10.561 | N/A | $ 53,880 | $- |
| Direct Program Watershed Protection and Flood Prevention | 10.904 | | 149,000 | - |
| Total Department of Agriculture | | | 202,880 | - |
| Department of Justice\nPass-Through Program From Iowa Department of Justice COVID-19 - Coronavirus Emergency Supplemental Funding Program | 16.034 | 2020-VD-BX-0302 | 8,729 | - |
| Crime Victim Assistance | 16.575 | VP-22-125-VWC | 34,403 | - |
| Violence Against Women Formula Grants | 16.588 | VW-21-41-LE | 1,097 | 970 |
| Violence Against Women Formula Grants | 16.588 | VW-22-41-LE | 736 | 218 |
| Violence Against Women Formula Grants | 16.588 | VW-22-52-PR | 46,000 | - |
| Total Violence Against Women Formula Grants | 47,833 | 1,188 |
| Direct Program Bulletproof Vest Partnership Program | 16.607 | | 4,586 | - |
| Pass-Through Program From Governor's Office of Drug Control Policy Public Safety Partnership and Community Policing Grants | 16.710 | 19-CAMP-05 | 7,422 | 2,856 |
| Public Safety Partnership and Community Policing Grants | 16.710 | 19-COPS HEROIN-02 | 6,998 | 2,309 |
| Total Public Safety Partnership and Community Policing Grants | 14,420 | 5,165 |
| Edward Byrne Memorial Justice Assistance Grant Program | 16.738 | 17-JAG-343653 | 63,300 | 31,650 |
| Direct Program Equitable Sharing Program | 16.922 | | 26,880 | - |
| Total Department of Justice | | | 200,151 | 38,003 |
===== PAGE 87 =====
| Federal Grantor/Pass-Through Grantor/Program or Cluster Title | Federal Financial Assistance Listing/CFDA Number | Pass-Through Entity Identifying Number | Federal Expenditures | Amounts Passed-Through to Subrecipients |
| Department of Transportation | | | | |
| Pass-Through Program From Governor's Traffic Safety Bureau Highway Safety Cluster | | | | |
| State and Community Highway Safety | 20.600 | 21-402-MOPT, Task 15-00-0 | 5,868 | $- |
| State and Community Highway Safety | 20.600 | 22-402-MOPT, Task 24-00-00 | 12,634 | $- |
| State and Community Highway Safety | 20.600 | PAP 22-405d-F24*SE Task 24-00-00 | 1,710 | $- |
| Total Highway Safety Cluster | | | 20,212 | $- |
| Direct Program | | | | |
| Rebuilding American Infrastructure with Sustainability and Equity | 20.933 | | 50,034 | $- |
| Total Department of Transportation | | | 70,246 | $- |
| Election Assistance Commission | | | | |
| Pass-Through Program From Iowa Election Assistance Commission | | | | |
| COVID-19 -HAVA Election Security Grants | 90.404 | 331-11320-HAVA | 10,000 | $- |
| Department of Health and Human Services | | | | |
| Pass-Through Program From Buchanan County | | | | |
| Public Health Emergency Preparedness | 93.069 | 5881BT01 | 11,246 | $- |
| Iowa Department of Public Health | | | | |
| Epidemiology and Laboratory Capacity for Infectious Diseases | 93.323 | 5885BT431 #12 | 40,915 | $- |
| Immunization Cooperative Agreements | 93.268 | 5881I429E | 18,000 | 18,000 |
| Immunization Cooperative Agreements | 93.268 | 5885BT431 #7 | 57,279 | - |
| Immunization Cooperative Agreements | 93.268 | 5885BT431 #8 | 94,801 | 94,801 |
| Total Immunization Cooperative Agreements | | | 170,080 | 112,801 |
| Well-Integrated Screening and Evaluation for Women Across the Nation | 93.436 | 5881NB11WW | 1,075 | 1,075 |
| Well-Integrated Screening and Evaluation for Women Across the Nation | 93.436 | 5881NB11WWE | 8,725 | 8,725 |
| Total Well-Integrated Screening and Evaluation for Women Across the Nation | | | 9,800 | 9,800 |
===== PAGE 88 =====
| Federal Grantor/Pass-Through Grantor/Program or Cluster Title | Federal Financial Assistance Listing/CFDA Number | Pass-Through Entity Identifying Number | Federal Expenditures | Amounts Passed-Through to Subrecipients |
| Department of Health and Human Services (continued) Pass-Through Program From Iowa Department of Human Services Human Services Administrative Reimbursement | 93.472 | N/A | $ 1,875 | $- |
| Title IV-E Prevention Program |
| Direct Program | | | | |
| COVID-19 - Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution | 93.498 | | 213,848 | - |
| Pass-Through Program From Iowa Department of Human Services Child Support Enforcement Human Services Administrative Reimbursement | 93.563 | BOC 19-005 | 179,118 | - |
| Refugee and Entrant Assistance - State-Administered Programs CCDF Cluster | 93.566 | N/A | 62 | - |
| Child Care Mandatory and Matching Funds of the Child Care and Development Fund | 93.596 | N/A | 14,037 | - |
| Foster Care - Title IV-E | 93.658 | N/A | 14,343 | - |
| Adoption Assistance - Title IV-E | 93.659 | N/A | 7,870 | - |
| Social Services Block Grant | 93.667 | N/A | 14,646 | - |
| Children's Health Insurance Program | 93.767 | N/A | 1,110 | - |
| Medicaid Cluster Medical Assistance Program | 93.778 | N/A | 63,569 | - |
| Pass-Through Program From Iowa Department of Public Health Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations | 93.898 | 5881NB11E | 24,654 | 24,654 |
| Total Department of Health and Human Services | | | 767,173 | 147,255 |
| Department of Homeland Security | | | | |
| Pass-Through Program From Iowa Department of Homeland Security and Emergency Management COVID-19 - Disaster Grants-Public Assistance | 97.036 | 4018-DR-IA | 73,604 | - |
| Total Federal Financial Assistance | | | $ 1,324,054 | $ 185,258 |
===== PAGE 89 =====
## Note 1 - Basis of Presentation
The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of Dubuque County, Iowa, under programs of the federal government for the year ended June 30, 2021. The information is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the schedule presents only a selected portion of the operations of the County, it is not intended to and does not present the financial position, changes in net assets (or net position or fund balance), or cash flows (if applicable) of the County.
## Note 2 - Summary of Significant Accounting Policies
Expenditures reported in the schedule are reported on the modified accrual basis of accounting, except τ or subrecipient expenditures, which are recorded on the cash basis. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement.
## Note 3 - Indirect Cost Rate
The County has not elected to use the 10% de minimis cost rate.
## Note 4 - Provider Relief Funds
The County received amounts from the U.S. Department of Health and Human Services (HHS) through the Provider Relief Fund (PRF) and American Rescue Plan (ARP) program (Federal Financial Assistance Listing/CFDA #93.498). The County incurred eligible expenses and, therefore recognized revenue totaling $129,642, $512,241, and $95,836 for the years ended June 30, 2020, June 30, 2021, and June 30, 2022, respectively, in the financial statements. However, the PRF expenditures are not recognized on the schedule until the expenditures are required to be included on the report to HHS, as required under the PRF program.
===== PAGE 90 =====
The following summarized the Provider Relief Funds and the timing of when the amounts were recognized in the financial statements.
| Federal Department/Program Title/Grant Name | Federal Financial Assistance Listing/Federal CFDA Number | Amounts Recognized in Accordance with GAAP for the Year Ended June 30, 2020 | Amounts Recognized in Accordance with GAAP for the Year Ended June 30, 2021 | Amounts Recognized in Accordance with GAAP for the Year Ended June 30, 2022 |
| Department of Health and Human Services\nHealth Resources and Services Administration | | | | |
| COVID-19 - Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution - Period 1 (included in 2021 Schedule) | 93.498 | $ 129,642 | $ 298,393 | $- |
| COVID-19 - Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution - Period 2 (included in 2022 Schedule) | 93.498 | - | 121,650 | - |
| COVID-19 - Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution - Period 3 (included in 2022 Schedule) | 93.498 | - | 92,198 | - |
| COVID-19 - Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution - Period 4 (not included in 2022 Schedule) | 93.498 | - | - | 95,836 |
| Total Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution | | $ 129,642 | $ 512,241 | $ 95,836 |
===== PAGE 91 =====
## Part I: Summary of the Independent Auditor's Results:
| Financial Statements |
| Type of auditor's report issued | Unmodified |
| Internal control over financial reporting:\nMaterial weaknesses identified\nSignificant deficiencies identified not considered to be material weaknesses | No\nYes |
| Noncompliance material to financial statements noted? | No |
| Federal Awards |
| Internal control over major programs:\nMaterial weaknesses identified\nSignificant deficiencies identified not considered to be material weaknesses | Yes\nNone Reported |
| Type of auditor's report issued on compliance for major programs: | Qualified for 93.268\nUnmodified for 93.498 |
| Any audit findings disclosed that are required to be reported in accordance with Uniform Guidance 2 CFR 200.516(a): | Yes |
| Identification of major programs: |
| Name of Federal Program | Federal Financial Assistance Listing /CFDA Number |
| Immunization Cooperative Agreements | 93.268 |
| COVID-19 Provider Relief Fund and American Rescue Plan (ARP)\nRural Distribution | 93.498 |
| Dollar threshold used to distinguish between type A and type B programs: | $ 750,000 |
| Auditee qualified as low-risk auditee? | Yes |
===== PAGE 92 =====
Part II: Financial Statement Findings:
## 2022 -001 County Recorder Segregation of Duties Significant Deficiency
Criteria: Properly designed segregation of duties allows entities to initiate, authorize, record, process, and report financial data reliably in accordance with generally accepted accounting principles.
Condition: The County Recorder's Office has various procedures implemented to enhance internal controls. However, due to staffing constraints, the County is still unable to fully segregate the receipt and posting functions.
Cause: With a limited number of office employees, segregation of duties is difficult.
Effect: Since job functions were not properly segregated, misstatements may not have been prevented or detected on a timely basis in the normal course of operations.
Recommendation: County officials should review the operating procedures of the office to obtain the maximum internal control possible under the circumstances.
Views of Responsible Officials: Posting functions are rotated weekly between multiple staff and cross verified on nearly a daily basis. Since it is a small office, all employees are needed to receive transactions.
## Part III: Federal Award Findings and Questioned Costs:
2022-002 Department of Health and Human Services
CFDA #93.498
COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution
Applicable Federal Award Number and Year – Periods 2 and 3 TIN #426004597
Activities Allowed or Unallowed and Allowable Costs/Cost Principles and Reporting Material Weakness in Internal Control Over Compliance
Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award.
Condition: The Center’s final expenditure listing identified as eligible and claimed under the Provider Relief Fund program was not reviewed and approved by a separate individual outside of the preparer. In addition, the County’s special reports submitted to the Department of Health and Human Services for Periods 2 and 3 TIN #426004597 were not reviewed and approved by a separate individual outside of the preparer.
===== PAGE 93 =====
## Part III: Federal Award Findings and Questioned Costs: (continued)
Cause: The County did not have an internal control process in place to ensure a secondary review and approval of eligible expenditures that were summarized from the underlying support to the final expenditure listing was documented. The summary spreadsheet was used to claim allowable costs under the federal program. In addition, the review and approval of the reports submitted to the Department of Health and Human Services for Periods 2 and 3 were not performed by someone other than the preparer of the report.
Effect: Without a secondary review and approval, there is a possibility that ineligible expenditures may be claimed under the program and the report may not be accurately completed.
Questioned Costs: None reported.
Context: Testing was performed over general and administrative expenses and healthcare related expenses, including personnel costs and certain supplies for activities allowed and unallowed and allowable costs/cost principles. A nonstatistical sample of 17 transactions totaling $129,627 out of $213,848 were tested. In addition, key line items were tested on the Period 2 and Period 3 Department of Health and Human Services special reports.
Repeat Finding from Prior Years: No
Recommendation: We recommend the County implement a control process which includes a secondary review and approval of the summarized final expenditure listing used to claim the allowable costs under the federal program and secondary review and approval of required reports to be submitted to the federal agency.
Views of Responsible Officials: Moving forward, the Finance Director and/or Administrator will review and approve the expenditures and reports prior to being submitted.
===== PAGE 94 =====
Part III: Federal Award Findings and Questioned Costs: (continued)
2022-003 Department of Health and Human Services
Iowa Department of Public Health
CFDA #93.268
Immunization Cooperative Agreements
Applicable Federal Award Number and Year – 5881I429E, 5885BT431 #7, and 5885BT431 #8 for 2022
## Cash Management
Material Weakness in Internal Control Over Compliance
Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. The Cash Management Improvement Act of 1990-31 CFR 205.33 requires that when grant funds are advanced, recipients must follow procedures to minimize the time elapsing between the transfer of funds and disbursement.
Condition: The County’s requests for reimbursement submitted to the Iowa Department of Public Health were not reviewed and approved by a separate individual outside of the preparer. In addition, on two occasions the County held grant funds in excess of seven weeks.
Cause: The County did not have an internal control process in place to ensure a secondary review and approval of the requests for reimbursement.
Effect: Without a secondary review and approval, there is a possibility that the requests for reimbursement contain errors, which could lead to ineligible expenditures being claimed under the program and noncompliance with federal requirements regarding the Cash Management Improvement Act.
Questioned Costs: None reported.
Context: A nonstatistical sample of 6 requests for reimbursement out of 21 were tested.
Repeat Finding from Prior Years: No
Recommendation: We recommend the County implement a control process which includes a secondary review and approval of all requests for reimbursements.
Views of Responsible Officials: The VNA will submit the claim to the Health Department for approval before submitting going forward.
===== PAGE 95 =====
Part III: Federal Award Findings and Questioned Costs: (continued)
2022-004 Department of Health and Human Services
Iowa Department of Public Health
CFDA #93.268
Immunization Cooperative Agreements
Applicable Federal Award Number and Year – 58811429E, 5885BT431 #7, and 5885BT431 #8 for 2022
## Subrecipient Monitoring and Special Tests and Provisions
Material Weakness in Internal Control Over Compliance and Material Noncompliance
Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award.
Subrecipient monitoring requirements are contained in 2 CFR 200.331 through 2 CFR 200.333 and include requirements to identify the award and applicable requirements to the subrecipient and monitor the activities of the subrecipient.
Condition: The County did not formally communicate the required information to the subrecipient. No subrecipient agreement was executed. In addition, no monitoring activities were documented, including monitoring of the program's special tests and provisions.
Cause: The County did not have an internal control process in place to ensure subrecipient monitoring requirements were met.
Effect: Without the proper communication of applicable requirements and monitoring of the subrecipient, there is a possibility that federal statutes, regulations, and the terms and conditions of the federal award, including the program's special tests and provisions, were not complied with.
Questioned Costs: None reported.
Context: $112,801 was passed through to one subrecipient during the year ended June 30, 2022.
Repeat Finding from Prior Years: No
Recommendation: We recommend the County implement a control process which includes the applicable subrecipient monitoring requirements.
Views of Responsible Officials: Dubuque County is working with the Dubuque Visiting Nurse Association on implementing a subrecipient agreement and will put a control process in place to monitor.
===== PAGE 96 =====
## Part IV: Other Findings Related to Required Statutory Reporting:
2022-IA-A Certified Budget – Disbursements during the year ended June 30, 2022 did not exceed the amount budgeted by function. However, during the year ended June 30, 2022, disbursements exceeded the amounts appropriated in various departments.
Recommendation – The budget should have been amended in accordance with Chapter 331.435 of the Code of Iowa before disbursements were allowed to exceed the budget.
Chapter 331.434 (6) of the Code of Iowa authorizes the Board of Supervisors, by resolution, to increase or decrease appropriations of one office or department by increasing or decreasing the appropriation of another office or department as long as the function budget is not increased. Such increases or decreases should be made before disbursements are allowed to exceed the appropriation.
Views of Responsible Officials – The County works to complete all amendments in a timely manner. Continued efforts will be made to ensure compliance.
2022-IA-B Questionable Expenditures – No expenditures that we believe may not meet the requirements of public purpose as defined in an Attorney General's opinion dated April 25, 1979, were noted.
2022-IA-C Travel Expense – No expenditures of County money for travel expenses of spouses of County officials and/or employees were noted.
2022-IA-D Business Transactions – Business transactions between the County and County officials and/or employees are detailed as follows: