===== PAGE 1 =====

Financial Statements June 30, 2023 Dubuque County ===== PAGE 2 ===== Officials ..... 1 Independent Auditor's Report ..... 2 Management's Discussion and Analysis ..... 6 Basic Financial Statements: Government-wide Financial Statements: Exhibit A – Statement of Net Position ..... 16 Exhibit B – Statement of Activities ..... 18 Governmental Fund Financial Statements: Exhibit C – Balance Sheet ..... 19 Government Fund Financial Statements: Exhibit D – Reconciliation of the Balance Sheet ..... 21 Exhibit E – Statement of Revenues, Expenditures, and Changes in Fund Balances ..... 22 Exhibit F – Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances – Governmental Funds to the Statement of Activities ..... 23 Proprietary Fund Financial Statements: Exhibit G – Statement of Net Position ..... 24 Exhibit H – Statement of Revenues, Expenses and Changes in Net Position ..... 25 Exhibit I – Statement of Cash Flows ..... 26 Fiduciary Fund Financial Statement: Exhibit J – Statement of Fiduciary Net Position ..... 27 Exhibit K – Statement of Changes in Fiduciary Net Position ..... 28 Notes to Financial Statements ..... 29 Required Supplementary Information: Budgetary Comparison Schedule of Receipts, Disbursements, and Changes in Balances – Budget and Actual (Cash Basis) – All Governmental and Proprietary Funds and Budget to GAAP Reconciliation ..... 55 Notes to Required Supplementary Information – Budgetary Reporting ..... 56 Schedule of the County's Proportionate Share of the Net Pension Liability ..... 57 Schedule of the County Contributions ..... 58 Notes to Required Supplementary Information – Pension Liability ..... 59 Schedule of Changes in the County's Total OPEB Liability, Related Ratios and Notes ..... 60 Other Supplementary Information: Nonmajor Governmental Funds: Schedule 1 – Combining Balance Sheet ..... 61 Schedule 2 – Combining Statement of Revenues, Expenditures, and Changes in Fund Balances ..... 63 Custodial Funds: Schedule 3 – Combining Statement of Fiduciary Net Position ..... 65 Schedule 4 – Combining Statement of Changes in Fiduciary Net Position ..... 67 Schedule 5 – Schedule of Revenues by Source and Expenditures by Function – All Governmental Funds ..... 69 ===== PAGE 3 ===== ## Information Provided to Comply with Government Auditing Standards and the Uniform Guidance Independent Auditor's Report on Internal Control over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards ..... 70 Independent Auditor's Report on Compliance for the Major Federal Program and Report on Internal Control over Compliance Required by the Uniform Guidance ..... 72 Schedule of Expenditures of Federal Awards ..... 75 Notes to the Schedule of Expenditures of Federal Awards ..... 79 Schedule of Findings and Questioned Costs ..... 81 ===== PAGE 4 =====

Dubuque County ===== PAGE 5 =====

Name	Title	Term Expires
Ann McDonough	Board of Supervisors	January, 2027
Wayne Kenniker	Board of Supervisors	January, 2027
Harley Pothoff	Board of Supervisors	January, 2025
Kevin Dragotto	County Auditor	January, 2025
Michael Clasen	County Treasurer	January, 2027
Karol Kennedy	County Recorder	January, 2025
Joe Kennedy	County Sheriff	January, 2025
Scott Nelson	County Attorney	January, 2027
Billie Selby	County Assessor	January, 2028
Troy Patzner	City Assessor	January, 2026

===== PAGE 6 ===== # Independent Auditor's Report To the Officials of Dubuque County: Report on the Audit of the Financial Statements ## Opinions We have audited the financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of Dubuque County, Iowa, (County) as of and for the year ended June 30, 2023, and the related notes to the financial statements, which collectively comprise the County's basic financial statements as listed in the table of contents. In our opinion, the accompanying financial statements referred to above present fairly, in all material respects, the respective financial position of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of Dubuque County, Iowa, as of June 30, 2023, and the respective changes in financial position, and, where applicable, cash flows thereof for the year then ended in accordance with accounting principles generally accepted in the United States of America. ## Basis for Opinions We conducted our audit in accordance with auditing standards generally accepted in the United States of America (GAAS) and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States (Government Auditing Standards). Our responsibilities under those standards are further described in the Auditor's Responsibilities for the Audit of the Financial Statements section of our report. We are required to be independent of the County and to meet our other ethical responsibilities, in accordance with the relevant ethical requirements relating to our audit. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinions. ## Responsibilities of Management for the Financial Statements Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. ===== PAGE 7 ===== In preparing the financial statements, management is required to evaluate whether there are conditions or events, considered in the aggregate, that raise substantial doubt about the County's ability to continue as a going concern for twelve months beyond the financial statement date, including any currently known information that may raise substantial doubt shortly thereafter. ## Auditor's Responsibilities for the Audit of the Financial Statements Our objectives are to obtain reasonable assurance about whether the financial statements as a whole are free from material misstatement, whether due to fraud or error, and to issue an auditor's report that includes our opinions. Reasonable assurance is a high level of assurance but is not absolute assurance and therefore is not a guarantee that an audit conducted in accordance with GAAS and Government Auditing Standards will always detect a material misstatement when it exists. The risk of not detecting a material misstatement resulting from fraud is higher than for one resulting from error, as fraud may involve collusion, forgery, intentional omissions, misrepresentations, or the override of internal control. Misstatements are considered material if there is a substantial likelihood that, individually or in the aggregate, they would influence the judgment made by a reasonable user based on the financial statements. In performing an audit in accordance with GAAS and Government Auditing Standards, we: • Exercise professional judgment and maintain professional skepticism throughout the audit. Identify and assess the risks of material misstatement of the financial statements, whether due to fraud or error, and design and perform audit procedures responsive to those risks. Such procedures include examining, on a test basis, evidence regarding the amounts and disclosures in the financial statements. Obtain an understanding of internal control relevant to the audit in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the County's internal control. Accordingly, no such opinion is expressed. Evaluate the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluate the overall presentation of the financial statements. - Conclude whether, in our judgment, there are conditions or events, considered in the aggregate, that raise substantial doubt about the County's ability to continue as a going concern for a reasonable period of time. We are required to communicate with those charged with governance regarding, among other matters, the planned scope and timing of the audit, significant audit findings, and certain internal control-related matters that we identified during the audit. ===== PAGE 8 ===== ## Required Supplementary Information Accounting principles generally accepted in the United States of America require that the management’s discussion and analysis and other required supplementary information listed in the table of contents be presented to supplement the basic financial statements. Such information is the responsibility of management and, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. We have applied certain limited procedures to the required supplementary information in accordance with GAAS, which consisted of inquiries of management about the methods of preparing the information and comparing the information for consistency with management’s responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We do not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. ## Supplementary Information Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise Dubuque County’s basic financial statements. We previously audited, in accordance with the standards referred to in the third paragraph of this report, the financial statements for the nine years ended June 30, 2022 (which are not presented herein) and expressed unmodified opinions on those financial statements. The combining nonmajor fund statements, the schedule of revenues by source and expenditures by function, and the schedule of expenditures of federal awards required by Title 2 U.S. Code of Federal Regulations, Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform Guidance), are presented for purposes of additional analysis and are not a required part of the basic financial statements. Such information is the responsibility of management and was derived from and relates directly to the underlying accounting and other records used to prepare the basic financial statements. The information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with GAAS. In our opinion, the combining nonmajor fund statements, the schedule of revenues by source and expenditures by function, and the schedule of expenditures of federal awards are fairly stated, in all material respects, in relation to the basic financial statements as a whole. ## Other Information Management is responsible for the other information included in the Financial Statements. The other information comprises the list of officials but does not include the basic financial statements and our auditor's report thereon. Our opinions on the basic financial statements do not cover the other information, and we do not express an opinion or any form of assurance thereon. ===== PAGE 9 ===== In connection with our audit of the basic financial statements, our responsibility is to read the other information and consider whether a material inconsistency exists between the other information and the basic financial statements, or the other information otherwise appears to be materially misstated. If, based on the work performed, we conclude that an uncorrected material misstatement of the other information exists, we are required to describe it in our report. ## Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated December 15, 2023, on our consideration of the County's internal control over financial reporting and on our tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, and other matters. The purpose of that report is solely to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the County's internal control over financial reporting or on compliance. That report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the County's internal control over financial reporting and compliance.

Dubuque, Iowa December 15, 2023 ===== PAGE 10 ===== # MANAGEMENT'S DISCUSSION AND ANALYSIS Dubuque County provides this management's discussion and analysis of its financial statements. This narrative overview and analysis of the financial activities is for the fiscal year ended June 30, 2023. We encourage readers to consider the information presented here in conjunction with the County's financial statements, which follow. ## FINANCIAL HIGHLIGHTS The assets and deferred outflows of the County exceeded the liabilities and deferred inflows at the close of the most recent fiscal year by $191,052,193 (net position). The County's net position increased by $19,348,590. As of the close of the fiscal year, the County's governmental funds reported combined ending fund balances of $55,012,254, an increase of $473,154 in comparison with the prior year. At the end of the current fiscal year, unassigned fund balance for the general fund was $25,358,494 or 68.14% of total general fund expenditures. Total long-term liabilities of the governmental activities decreased by $1,796,815 (6.02%) during the current fiscal year. ## USING THIS ANNUAL REPORT The annual report consists of a series of financial statements and other information, as follows: Management’s Discussion and Analysis introduces the basic financial statements and provides an analytical overview of the County’s financial activities. The Government-wide Financial Statements consist of a statement of net position and a statement of activities. These provide information about the activities of Dubuque County as a whole and present an overall view of the County's finances. The Fund Financial Statements tell how governmental services were financed in the short term as well as what remains for future spending. Fund financial statements report Dubuque County's operations in more detail than the government-wide statements by providing information about the most significant funds. The remaining statements provide financial information about activities for which Dubuque County acts solely as an agent or custodian for the benefit of those outside of County government (Custodial Funds). Notes to Financial Statements provide additional information essential to a full understanding of the data provided in the basic financial statements. Required Supplementary Information further explains and supports the financial statements with a comparison of the County's budget for the year, the County's proportionate share of the net pension liability (asset) and related contributions, as well as presenting Schedule of Changes in County's Total OPEB Liability and Related Ratios and Notes. Supplementary Information provides detailed information about the nonmajor governmental and the individual Custodial Funds. In addition, the Schedule of Expenditures of Federal Awards provides details of various federal programs benefiting the County. ===== PAGE 11 ===== ## Reporting the County as a Whole ## Government-wide Financial Statements One of the most important questions asked about the County's finances is, "Is the County as a whole better off or worse off as a result of the year's activities?" The statement of net position and the statement of activities report information about the County as a whole and about its activities in a way that helps answer this question. These statements include all assets and liabilities using the accrual basis of accounting and the economic resources measurement focus, which is similar to the accounting used by most private-sector companies. All of the current year's revenues and expenses are taken into account, regardless of when cash is received or paid. The statement of net position presents all of the County's assets, deferred outflows of resources, liabilities, and deferred inflows of resources, with the difference reported as "net position." Over time, increases or decreases in the County's net position may serve as a useful indicator of whether the financial position of the County is improving or deteriorating. The statement of activities presents information showing how the County's net position changed during the most recent fiscal year. All changes in net position are reported as soon as the event or change occurs, regardless of the timing of related cash flows. Thus, revenues and expenses are reported in this statement for some items that will not result in cash flows until future fiscal periods. The County’s governmental activities are presented in the statement of net position and the statement of activities. The government-wide financial statements distinguish functions of the County that are principally supported by taxes and intergovernmental revenues (governmental activities) from other functions that are intended to recover all or a significant portion of their costs through users fees and charges (business-type activities). Governmental activities include public safety and legal services, physical health and social services, mental health, county environment and education, roads and transportation, governmental services to residents, administration, interest on long-term debt and other non-program activities. Property tax and state and federal grants finance most of these activities. Sunnycrest Manor Operations is the sole business-type activity of the County. The government-wide financial statements can be found on pages 16–18 of this report. ## Fund Financial Statements A fund is a grouping of related accounts that is used to maintain control over resources that have been segregated for specific activities or objectives. The County, like other state and local governments, uses fund accounting to ensure and demonstrate compliance with finance-related legal requirements. ===== PAGE 12 ===== The County has three kinds of funds: 1) Governmental funds account for most of the County's basic services. These focus on how money flows into and out of those funds, and the balances left at year-end that are available for spending. These governmental funds include: 1) the General Fund, 2) the Special Revenue Funds, such as American Rescue Plan, Rural Services and Secondary Roads, 3) Capital Projects, such as Local Option Tax, and 4) the Debt Service Fund. These funds are reported using the current financial resources measurement focus and the modified accrual basis of accounting, which measures cash and all other financial assets that can readily be converted to cash. The governmental fund financial statements provide a detailed, short-term view of the County's general governmental operations and the basic services it provides. Governmental fund information helps one determine whether there are more or fewer financial resources that can be spent in the near future to finance the County's programs. The County maintains 21 individual governmental funds. Information is presented separately in the governmental fund balance sheet and in the governmental fund statement of revenues, expenditures, and changes in fund balances for the general fund, American rescue plan fund, rural services fund, secondary roads fund, debt service fund, and the local option tax fund, all of which are considered to be major funds. Data from the other 15 funds are combined into a single, aggregated presentation. Individual fund data for each of these nonmajor governmental funds is provided in the form of combining statements elsewhere in this report. The governmental funds required financial statements include a balance sheet and a statement of revenues, expenditures and changes in fund balances. The basic governmental fund financial statements can be found on pages 19-23 of this report. 2) Proprietary funds account for the services which the County provides. Proprietary funds are reported in the same way as the Government-wide statements. The County's enterprise fund (one type of proprietary fund) is the same as its business-type activities but provides more detail and additional information, such as cash flows. The County has one enterprise fund for Sunnycrest Operations. The basic proprietary fund financial statements can be found on pages 24-26 of this report. 3) Fiduciary funds are used to report assets held in a trust or agency capacity for others and cannot be used to support the County's own programs. These fiduciary funds include custodial funds that account for emergency management services, joint 911 services and the County and City assessors, to name a few. The fiduciary funds required financial statements include a statement of fiduciary net position and a statement of changes in fiduciary net position. The basic fiduciary fund financial statements can be found on page 27-28 of this report. A summary reconciliation between the government-wide financial statements and the governmental fund financial statements follows the governmental fund financial statements. ===== PAGE 13 ===== Notes to the financial statements. The notes provide additional information that is essential to a full understanding of the data provided in the government-wide and fund financial statements. The notes to the financial statements can be found on pages 29-54 of this report. Other information. In addition to the basic financial statements and accompanying notes, this report also presents certain required supplementary information concerning the County's actual results in comparison to their original and amended budgets, the County's proportionate share of the net pension liability (asset) and related contributions, and the schedule of changes in county's total OPEB Liability and related ratios and notes. Required supplementary information can be found on pages 55-60 of this report. ## GOVERNMENT-WIDE FINANCIAL ANALYSIS As noted earlier, net position may serve over time as a useful indicator of a County's financial position. In the case of the County, assets and deferred outflows exceeded liabilities and deferred inflows by $191,052,193 at the close of the most recent fiscal year.

Dubuque County's Net Position

	Governmental Activities		Business-Type Activities		Total
	2023	2022	2023	2022	2023	2022
Current and Other Assets	$ 101,932,484	$ 120,322,175	$ 3,482,507	$ 3,671,927	$ 105,414,991	$ 123,994,102
Capital Assets	167,389,094	153,075,813	-	-	167,389,094	153,075,813
Total assets	269,321,578	273,397,988	3,482,507	3,671,927	272,804,085	277,069,915
Deferred Outflows of Resources	2,903,892	3,029,843	935,276	1,000,737	3,839,168	4,030,580
Long-Term Liabilities	31,412,444	31,662,791	4,131,817	1,613,869	35,544,261	33,276,660
Other Liabilities	10,786,708	23,858,374	671,995	758,639	11,458,703	24,617,013
Total liabilities	42,199,152	55,521,165	4,803,812	2,372,508	47,002,964	57,893,673
Deferred Inflows of Resources	37,879,749	47,430,941	708,347	4,072,278	38,588,096	51,503,219
Net Position
Net investment in capital assets	151,199,286	135,238,024	-	-	151,199,286	135,238,024
Restricted	21,100,594	27,870,898	-	-	21,100,594	27,870,898
Unrestricted (deficit)	19,846,689	10,366,803	(1,094,376)	(1,772,122)	18,752,313	8,594,681
Total net position	$ 192,146,569	$ 173,475,725	$ (1,094,376)	$ (1,772,122)	$ 191,052,193	$ 171,703,603

The largest portion of the County's net position (79.14%) reflects its investment in capital assets (e.g., land, buildings, infrastructure, and equipment), less any related debt used to acquire those assets that is still outstanding. The County uses these capital assets to provide services to citizens; consequently, these assets are not available for future spending. Although the County's investment in its capital assets is reported net of related debt, it should be noted that the resources needed to repay this debt must be provided from other sources, since the capital assets themselves cannot be used to liquidate these liabilities. ===== PAGE 14 ===== Unrestricted net position, the part of net position that can be used to finance day-to-day operations without constraints established by debt covenants, enabling legislation, or other legal requirements, increased from $8,594,681 at June 30, 2022 to $18,752,313 at the end of this year, an increase of 118.19%. Governmental activities. Governmental activities increased the County's position by $18,670,844. Business-Type activities. Business-type activities increased the County's position by $677,746. A condensed version of the Statement of Activities as of June 30, 2023, follows:

Dubuque County's Changes in Net Position

	Governmental Activities		Business-Type Activities		Total
	2023	2022	2023	2022	2023	2022
Program Revenues
Fines, fees, and charges for services	$ 4,163,989	$ 4,049,421	$ 10,324,202	$ 10,088,283	$ 14,488,191	$ 14,137,704
Operating grants and contributions	21,140,102	7,946,421	-	95,836	21,140,102	8,042,257
Capital grants and contributions	6,583,404	962,569	-	-	6,583,404	962,569
General Revenues
Property and other County tax	33,194,779	34,164,139	-	-	33,194,779	34,164,139
Penalty and interest on property tax	181,179	193,268	-	-	181,179	193,268
State tax credits	2,393,470	2,570,815	-	-	2,393,470	2,570,815
Local option sales tax	5,159,445	5,412,295	-	-	5,159,445	5,412,295
Gambling taxes	621,276	669,842	-	-	621,276	669,842
Unrestricted investment earnings	960,636	221,937	-	-	960,636	221,937
Miscellaneous	1,299,487	920,825	144,707	146,307	1,444,194	1,067,132
Total revenues	75,697,767	57,111,532	10,468,909	10,330,426	86,166,676	67,441,958
Program Expenses
Public safety and legal services	19,993,571	17,397,392	-	-	19,993,571	17,397,392
Physical health and social services	4,516,424	2,232,111	-	-	4,516,424	2,232,111
Mental health	-	3,754,153	-	-	-	3,754,153
County environment and education	7,709,880	4,204,592	-	-	7,709,880	4,204,592
Roads and transportation	13,913,309	14,012,188	-	-	13,913,309	14,012,188
Governmental services to residents	1,859,250	1,876,299	-	-	1,859,250	1,876,299
Administration	5,815,885	4,743,464	-	-	5,815,885	4,743,464
Non-program	185,542	82,737	-	-	185,542	82,737
Interest on long-term debt	708,511	781,627	-	-	708,511	781,627
Sunnycrest Operations	-	-	12,115,714	10,890,763	12,115,714	10,890,763
Total expenses	54,702,372	49,084,563	12,115,714	10,890,763	66,818,086	59,975,326
Increase (Decrease) in Net Position Before Transfers	20,995,395	8,026,969	(1,646,805)	(560,337)	19,348,590	7,466,632
Transfers	(2,324,551)	(1,427,469)	2,324,551	1,427,469	-	-
Increase (Decrease) in Net Position	18,670,844	6,599,500	677,746	867,132	19,348,590	7,466,632
Net Position (Deficit) Beginning of the Year	173,475,725	166,876,225	(1,772,122)	(2,639,254)	171,703,603	164,236,971
Net Position (Deficit) End of the Year	$ 192,146,569	$ 173,475,725	$ (1,094,376)	$ (1,772,122)	$ 191,052,193	$ 171,703,603

Taxes decreased by $969,361 or 2.84%, during the year. This decrease represents a taxable valuation growth of 3.04%, along with a 52.817-cent decrease in the MHDD levy, a 2.104-cent increase in the general fund levy, and a 1.376-cent decrease in the debt service levy totaling a 52.089-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 $55,012,254, an increase of $473,154 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 $25,358,494, while the total fund balance reached $31,284,187. 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 68.14% of total general fund expenditures, while total fund balance represents 84.07% of that same amount. The fund balance of the County's general fund increased $6,000,752 during the current fiscal year. Key factors in this increase are as follows: Revenues increased $2,975,073, due to increases in revenue categories, property and other County tax of $833,263, intergovernmental of $780,819, use of money and property of $1,228,618, and miscellaneous of $257,390. Expenditures increased $5,591,448 primarily due to an increase in public safety and legal services of $937,184, county environment and education of $1,212,627, physical health and social services of $2,074,455, and administration of $942,651. Other financing sources (uses) increased due to an $8,952,918 increase to transfers in for the current year. The rural services fund has a total fund balance of $618,097, which is an increase of $132,624 from the prior year. Key factors in this increase are as follows: Revenues increased $179,876 due to increases in the property and other county tax revenue category of $102,086 along with increases in intergovernmental of $82,491. Expenditures increased $60,306 due to increased expenses in the county environment and education. Other financing sources (uses) had an increase in funds transferred out of $105,056. ===== PAGE 16 ===== The secondary roads fund has a total fund balance of $5,610,872, which is a decrease of $4,388,390 from the prior year. Key factors in this decrease are as follows: Revenue increased $1,318,839 due to an increase in the intergovernmental revenue category of $1,160,709 along with an increase of $123,775 in miscellaneous revenue. Expenditures increased by $5,391,622 due to an increase in the capital projects of $4,293,109 along with a increase of $1,098,513 in the roads and transportation activities. An increase in Other Financing Sources of $113,661 is attributed to the increase in transfers of $100,056 along with an increase of $13,605 for sale of capital assets. The local option tax fund has a total fund balance of $3,893,819, which is a decrease of $977,104 from the prior year. A key factor in the decrease was: Revenue decreased by $527,827 due to $252,850 decrease in property and other county tax along with an decrease of $278,228 of miscellaneous revenues, while expenses increased by $127,298 due to more capital road projects. The debt service fund has a total fund balance of $7,870,435, which is a decrease of $403,796 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 (deficit) of $(1,094,376), an increase of $677,746 from the prior year. Key factors in the increase were: An increase in revenues of $138,483 along with an increase in expenses of $1,224,951 led to a $1,086,468 increase in the fund's net loss before transfers. There was an $897,082 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 28, 2022, net of transfers, increased revenues by $773,393 and increased disbursements by $20,919,714. This amendment reflects deliberations made by the Board of Supervisors during work sessions. The second amendment, on April 24, 2023, net of transfers, increased revenues by $763,809 and increased disbursements by $1,632,608. This amendment reflects deliberations made by the Board of Supervisors during work sessions. The third amendment, on May 30, 2023, net of transfers, increased revenue by $5,410 and increased disbursements by $794,258. 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 $12,028,721 resulted in an amended total revenue of $72,467,256. The net increase in disbursements and other uses of $33,832,689 resulted in an amended total of $111,714,893. Actual cash disbursements for the year totaled $71,336,458, which is $24,472,163 less than the final amended budget. The largest factor contributing to the difference were county environment and education of $13,399,352 and administration disbursements which were $2,538,289 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 public safety and legal services disbursements due to timing of projects were $2,419,374 less than budgeted. ===== PAGE 18 ===== ## CAPITAL ASSETS AND DEBT ADMINISTRATION ## Capital Assets At the end of FY23, Dubuque County had $167,389,094 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 $14,313,281 or 9.35% over last year.

Capital Assets of Governmental Activities at Year-End

June 30,

	June 30,
	2023	2022
Land	$ 5,951,746	$ 5,586,516
Construction in Progress	15,749,544	4,888,207
Buildings	26,015,494	26,272,700
Improvements Other Than Buildings	1,948,412	1,905,310
Machinery and Equipment	17,687,904	18,355,929
Infrastructure	100,035,994	96,067,151
Total	$ 167,389,094	$ 153,075,813

The County had depreciation expense of $8,534,789 for the year ended June 30, 2023, and total accumulated depreciation as of June 30, 2023 of $114,101,892. The County's final fiscal year 2023 capital budget included approximately $17.8 million for capital projects, which included secondary road construction. Additional information on the County's capital assets can be found in Note 6 on pages 41-42 of this report. ## Long-term Liabilities At year-end, the County had total long-term liabilities of $28,843,637 compared to $30,602,624 last year, a decrease of $1,758,987 (5.75%), as detailed below:

	Governmental Activities		Business- Type Activities		Total
	2023	2022	2023	2022	2023	2022
Bonds Payable	$ 16,189,808	$ 17,837,789	$ -	$ -	$ 16,189,808	$ 17,837,789
Landfill Bonds Payable	6,610,000	7,060,000	-	-	6,610,000	7,060,000
Loan Payable	83,284	124,492	-	-	83,284	124,492
Compensated Absences	5,185,156	4,842,782	775,389	737,561	5,960,545	5,580,343
Total	$ 28,068,248	$ 29,865,063	$ 775,389	$ 737,561	$ 28,843,637	$ 30,602,624

For more detailed information on the County's debt and amortization terms, please refer to Note 8 on page 43-44 of this report. ===== PAGE 19 ===== ## Economic Factors and Next Year's Budgets and Rates The unemployment rate for the County is currently 2.9%, up 0.3% from the previous year and comparable with the State of Iowa rate of 3.0% and the 3.8% national rate. Currently, there are 60,300 non-farm jobs in Dubuque County, an increase of 1,300 from the previous year. Taxes levied for fiscal year 2024 will increase by $809,060, or 2.39% from the fiscal year 2023 budget. This increase represents a taxable valuation growth of 1.62%, an increase of 20.000-cents in the county-wide tax levy rate and no change in the rural levy rate. The 2024 County-wide levy rate is $5.55009 per thousand dollars of taxable value. Net property tax revenue represents 52% of total revenues and other sources, a decrease of 2% from the prior year. Rural residents will pay $9.20911 per thousand dollars of taxable value, including the rural service levy of $3.65902. ## Requests for Information This financial report is designed to provide our citizens, taxpayers, customers, and creditors with a general overview of Dubuque County's finances and to show the County's accountability for the money it receives. Questions concerning any of the information provided in this report or requests for additional financial information should be addressed to the Dubuque County Auditor's Office, 720 Central Avenue, Dubuque, Iowa 52001. ===== PAGE 20 =====

Basic Financial Statements Dubuque County ===== PAGE 21 =====

	Governmental Activities	Business-Type Activities	Total
Assets
Cash and Pooled Investments	$ 53,540,423	$ 1,098,325	$ 54,638,748
Receivables
Property tax
Delinquent	61,623	-	61,623
Succeeding year	35,438,458	-	35,438,458
Interest and penalty on property tax	49,692	-	49,692
Accounts	166,301	16,733	183,034
Accrued interest	451,592	-	451,592
Due from Other Governments	8,823,748	2,249,583	11,073,331
Prepaid Expenses	1,608,225	50,446	1,658,671
Inventories	998,490	67,420	1,065,910
Notes Receivable	597,588	-	597,588
Lease Receivable	196,344	-	196,344
Capital Assets
Capital assets, not being depreciated	21,701,290	-	21,701,290
Capital assets (net of accumulated depreciation)	145,687,804	-	145,687,804
Total assets	269,321,578	3,482,507	272,804,085
Deferred Outflows of Resources
Pension Related Deferred Outflows	2,602,586	817,880	3,420,466
OPEB Related Deferred Outflows	301,306	117,396	418,702
Total deferred outflows of resources	2,903,892	935,276	3,839,168
Liabilities
Accounts Payable	2,012,191	104,745	2,116,936
Salaries and Benefits Payable	1,252,961	459,287	1,712,248
Accrued Interest Payable	57,113	-	57,113
Due to Other Governments	492,516	107,963	600,479
Unearned Revenue	6,971,927	-	6,971,927
Long-Term Liabilities
Portion due or payable within one year
Bonds and notes payable, net	1,904,598	-	1,904,598
Compensated absences	1,835,200	274,436	2,109,636
Portion due or payable after one year
Bonds and notes payable, net	20,978,494	-	20,978,494
Compensated absences	3,349,956	500,953	3,850,909
Net pension liability	1,852,407	2,699,717	4,552,124
Total OPEB liability	1,491,789	656,711	2,148,500
Total liabilities	42,199,152	4,803,812	47,002,964

===== PAGE 22 =====

	Governmental Activities	Business-Type Activities	Total
Deferred Inflows of Resources
Deferred Property Tax Revenue	$ 35,438,458	$ -	$ 35,438,458
Deferred Items Related to Leases	196,344	-	196,344
Pension Related Deferred Inflows	1,586,027	452,928	2,038,955
OPEB Related Deferred Inflows	658,920	255,419	914,339
Total deferred inflows of resources	37,879,749	708,347	38,588,096
Net Position
Net Investment in Capital Assets	151,199,286	-	151,199,286
Restricted For
Supplemental levy purposes	4,691,118	-	4,691,118
Secondary roads purposes	5,626,187	-	5,626,187
Economic development	869,513	-	869,513
Debt service	1,206,755	-	1,206,755
Capital projects	6,992,911	-	6,992,911
Other purposes	1,714,110	-	1,714,110
Unrestricted (Deficit)	19,846,689	(1,094,376)	18,752,313
Total net position (deficit)	$ 192,146,569	$ (1,094,376)	$ 191,052,193

===== PAGE 23 =====

		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	$ 19,993,571	$ 1,106,063	$ 7,593,268	$ -	$ (11,294,240)	$ -	$ (11,294,240)
Physical health and social services	4,516,424	57,411	1,396,605	-	(3,062,408)	-	(3,062,408)
County environment and education	7,709,880	608,640	2,903,895	250,000	(3,947,345)	-	(3,947,345)
Roads and transportation	13,913,309	135,261	6,416,479	6,333,404	(1,028,165)	-	(1,028,165)
Governmental services to residents	1,859,250	1,640,534	1,501,000	-	1,282,284	-	1,282,284
Administration	5,815,885	616,080	1,115,496	-	(4,084,309)	-	(4,084,309)
Non-program	185,542	-	-	-	(185,542)	-	(185,542)
Interest on long-term debt	708,511	-	213,359	-	(495,152)	-	(495,152)
Total Governmental Activities	54,702,372	4,163,989	21,140,102	6,583,404	(22,814,877)	-	(22,814,877)
Business Type Activities
Sunnycrest operations	12,115,714	10,324,202	-	-	-	(1,791,512)	(1,791,512)
Total Government	$ 66,818,086	$ 14,488,191	$ 21,140,102	$ 6,583,404	(22,814,877)	(1,791,512)	(24,606,389)
General Revenues
Property and other County tax levied for General purposes					31,147,574	-	31,147,574
Debt service					2,047,205	-	2,047,205
Penalty and interest on property tax					181,179	-	181,179
State tax credits					2,393,470	-	2,393,470
Local option sales tax					5,159,445	-	5,159,445
Gambling taxes					621,276	-	621,276
Unrestricted investment earnings					960,636	-	960,636
Miscellaneous					1,299,487	144,707	1,444,194
Total General Revenues					43,810,272	144,707	43,954,979
Transfers					(2,324,551)	2,324,551	-
Change in Net Position					18,670,844	677,746	19,348,590
Net Position (Deficit) Beginning of Year, as restated					173,475,725	(1,772,122)	171,703,603
Net Position (Deficit) End of Year					$ 192,146,569	$ (1,094,376)	$ 191,052,193

===== PAGE 24 =====

Dubuque County Exhibit C – Balance Sheet Governmental Funds June 30, 2023

		Special Revenue			Capital Projects			Nonmajor Governmental Funds	Total Governmental Funds
	General	Rural Services	Secondary Roads	American Rescue Plan	Local Option Tax	Debt Service		Nonmajor Governmental Funds	Total Governmental Funds
Assets
Cash and Pooled Investments	$ 30,997,111	$ 637,406	$ 4,546,212	$ 6,324,908	$ 3,753,210	$ 1,261,402	$ 6,020,174	$ 53,540,423
Receivables
Property tax
Delinquent	42,800	15,704	-	-	-	3,119	-	61,623
Succeeding year	27,852,872	5,865,019	-	-	-	1,720,567	-	35,438,458
Interest and penalty on property tax	49,692	-	-	-	-	-	-	49,692
Accounts	161,946	-	4,355	-	-	-	-	166,301
Accrued interest	448,885	-	2,517	-	-	-	190	451,592
Due From Other Funds	2,113	-	20,057	-	-	-	-	22,170
Due From Other Governments	1,038,157	-	791,911	-	383,680	6,610,000	-	8,823,748
Inventories	76,444	-	922,046	-	-	-	-	998,490
Prepaid Expenses	1,545,634	-	62,591	-	-	-	-	1,608,225
Notes Receivable	416,000	-	-	-	-	-	181,588	597,588
Lease Receivable	196,344	-	-	-	-	-	-	196,344
Total assets	$ 62,827,998	$ 6,518,129	$ 6,349,689	$ 6,324,908	$ 4,136,890	$ 9,595,088	$ 6,201,952	$ 101,954,654

===== PAGE 25 =====

		Special Revenue			Capital Projects			Nonmajor Governmental Funds	Total Governmental Funds
	General	Rural Services	Secondary Roads	American Rescue Plan	Local Option Tax	Debt Service
Liabilities, Deferred Inflows of Resources, and Fund Balances
Liabilities
Accounts payable	$ 1,286,583	$ 4,013	$ 477,524	$ -	$ 243,071	$ 1,000	$ -	$ 2,012,191
Salaries and benefits payable	1,056,299	12,670	183,992	-	-	-	-	1,252,961
Due to other funds	19,544	2,626	-	-	-	-	-	22,170
Due to other governments	425,530	-	61,986	-	-	-	5,000	492,516
Unearned revenue	184,911	-	-	6,324,908	-	-	462,108	6,971,927
Total liabilities	2,972,867	19,309	723,502	6,324,908	243,071	1,000	467,108	10,751,765
Deferred Inflows of Resources
Unavailable revenues
Succeeding year
property tax	27,852,872	5,865,019	-	-	-	1,720,567	-	35,438,458
Other	521,728	15,704	15,315	-	-	3,086	-	555,833
Deferred items related to leases	196,344	-	-	-	-	-	-	196,344
Total deferred inflows of resources	28,570,944	5,880,723	15,315	-	-	1,723,653	-	36,190,635
Fund Balances
Nonspendable	1,668,078	-	984,637	-	-	-	-	2,652,715
Restricted	4,257,615	618,097	4,626,235	-	3,893,819	7,870,435	5,132,545	26,398,746
Committed	-	-	-	-	-	-	602,299	602,299
Unassigned	25,358,494	-	-	-	-	-	-	25,358,494
Total fund balances	31,284,187	618,097	5,610,872	-	3,893,819	7,870,435	5,734,844	55,012,254
Total liabilities, deferred inflows of resources, and fund balances	$ 62,827,998	$ 6,518,129	$ 6,349,689	$ 6,324,908	$ 4,136,890	$ 9,595,088	$ 6,201,952	$ 101,954,654

===== PAGE 26 =====

Total Governmental Fund Balances		$ 55,012,254
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,951,746
Construction in progress	15,749,544
Infrastructure, net of $84,852,518 accumulated depreciation	100,035,994
Buildings, net of $12,867,714 accumulated depreciation	26,015,494
Machinery and equipment, net of $14,880,739 accumulated depreciation	17,687,904
Improvements other than buildings, net of $1,500,921 accumulated depreciation	1,948,412
Total capital assets		167,389,094
Other long-term assets are not available to pay current period expenditures and, therefore, are deferred in the governmental funds.
Property taxes and intergovernmental		555,833
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		2,903,892
Deferred inflows of resources		(2,244,947)
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, 2023 are:
Accrued interest on debt	(57,113)
Bonds and notes payable	(22,453,194)
Unamortized premiums on the issuance of bonds	(429,898)
Compensated absences	(5,185,156)
Net pension liability	(1,852,407)
Total OPEB liability	(1,491,789)
Total long-term liabilities		(31,469,557)
Net Position of Governmental Activities		$ 192,146,569

===== PAGE 27 =====

		Special Revenue			Capital Projects		Nonmajor Governmental Funds	Total Governmental Funds
	General	Rural Services	Secondary Roads	American Rescue Plan	Local Option Tax	Debt Service	Nonmajor Governmental Funds	Total Governmental Funds
Revenues
Property and other County tax	$ 26,057,674	$ 5,601,843	$ -	$ -	$ 5,159,445	$ 2,047,268	$ 109,719	$ 38,975,949
Interest and penalty on property tax	171,970	-	-	-	-	-	-	171,970
Intergovernmental	5,025,793	369,980	7,305,627	12,576,613	-	362,356	34,188	25,674,557
Licenses and permits	85,676	16,600	104,890	-	-	-	-	207,166
Charges for service	2,727,840	34,146	7,250	-	-	-	202,080	2,971,316
Use of money and property	1,029,571	-	13,721	-	16,348	-	8,527	1,068,167
Miscellaneous	688,621	-	317,832	-	-	-	67,971	1,074,424
Total revenues	35,787,145	6,022,569	7,749,320	12,576,613	5,175,793	2,409,624	422,485	70,143,549
Expenditures
Operating
Public safety and legal services	18,891,766	-	-	-	-	-	327,866	19,219,632
Physical health and social services	4,502,959	-	-	-	-	-	-	4,502,959
County environment and education	5,433,851	1,017,673	-	1,706,990	-	-	116,074	8,274,588
Roads and transportation	515,690	-	9,779,181	-	-	-	-	10,294,871
Governmental services to residents	1,926,119	-	-	-	-	-	-	1,926,119
Administration	5,701,883	-	-	-	-	-	-	5,701,883
Non-program	185,542	-	-	-	-	-	-	185,542
Debt service	-	-	-	-	-	2,811,420	42,450	2,853,870
Capital projects	56,032	-	7,171,128	869,623	6,152,897	-	152,027	14,401,707
Total expenditures	37,213,842	1,017,673	16,950,309	2,576,613	6,152,897	2,811,420	638,417	67,361,171
Excess (Deficiency) of Revenues Over (Under) Expenditures	(1,426,697)	5,004,896	(9,200,989)	10,000,000	(977,104)	(401,796)	(215,932)	2,782,378
Other Financing Sources (Uses)
Transfers in	10,002,000	-	4,797,272	-	-	-	325,000	15,124,272
Transfers out	(2,574,551)	(4,872,272)	-	(10,000,000)	-	(2,000)	-	(17,448,823)
Sale of capital assets	-	-	15,327	-	-	-	-	15,327
Total Other Financing Sources (Uses)	7,427,449	(4,872,272)	4,812,599	(10,000,000)	-	(2,000)	325,000	(2,309,224)
Net Change in Fund Balances	6,000,752	132,624	(4,388,390)	-	(977,104)	(403,796)	109,068	473,154
Fund Balances Beginning of Year	25,283,435	485,473	9,999,262	-	4,870,923	8,274,231	5,625,776	54,539,100
Fund Balances End of Year	$ 31,284,187	$ 618,097	$ 5,610,872	$ -	$ 3,893,819	$ 7,870,435	$ 5,734,844	$ 55,012,254

===== PAGE 28 =====

Net Change in Fund Balances - Total Governmental Funds	< /td > < td style = 'text-align: center; word-wrap: break-word;' > 473,154 < /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;' > 17,191,958	14,360,246
Contributed capital assets	5,703,077
Depreciation expense	(8,534,789)
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.		(46,965)
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	42,981
Repayments	2,096,208
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:\nProperty tax	8,760
Other	22,544
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.		31,304
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:\nChange in accrued interest on debt	6,170
Change in compensated absences	(342,374)
Pension income	512,653
OPEB expense	(120,459)
		55,990
Change in Net Position of Governmental Activities	$ 18,670,844

===== PAGE 29 =====

Dubuque CountyExhibit G – Statement of Net PositionProprietary FundJune 30, 2023

	Sunnycrest Operations
Assets
Cash and Pooled Investments	$ 1,098,325
Receivables
Accounts	16,733
Due From Other Governments	2,249,583
Inventories	67,420
Prepaid Expenses	50,446
Total assets	3,482,507
Deferred Outflows of Resources
Pension Related Deferred Outflows	817,880
OPEB Related Deferred Outflows	117,396
Total deferred outflows of resources	935,276
Liabilities
Accounts payable	104,745
Salaries and benefits payable	459,287
Due to other governments	107,963
Long-term liabilities
Portions due or payable within one year
Compensated absences	274,436
Portions due or payable after one year
Compensated absences	500,953
Net pension liability	2,699,717
Total OPEB liability	656,711
Total liabilities	4,803,812
Deferred Inflows of Resources
Pension Related Deferred Inflows	452,928
OPEB Related Deferred Inflows	255,419
Total deferred inflows of resources	708,347
Net Position
Unrestricted (Deficit)	$ (1,094,376)

===== PAGE 30 =====

	Sunnycrest Operations
Operating Revenues	$ 9,182,730
Intergovernmental Charges for service	1,141,472
Miscellaneous	144,707
Total revenues	10,468,909
Operating Expenses
Salaries and wages	5,803,389
Employee benefits	2,622,878
Services	2,498,705
Supplies	685,008
Utilities	320,057
Insurance	149,036
Repairs and maintenance	36,641
Total operating expenses	12,115,714
Operating Loss	(1,646,805)
Transfers In	2,324,551
Change in Net Position	677,746
Net Position (Deficit) Beginning of Year	(1,772,122)
Net Position (Deficit) End of Year	$ (1,094,376)

===== PAGE 31 =====

	Sunnycrest Operations
Cash Flows From Operating Activities
Cash received from services provided	$ 11,498,926
Cash received from other revenues	144,707
Cash paid for personnel services	(9,098,640)
Cash paid to suppliers	(3,893,704)
Net cash (used in) operating activities	(1,348,711)
Cash Flows From Noncapital Financing Activities
Transfer from the General Fund	2,324,551
Net Increase in Cash and Cash Equivalents	975,840
Cash and Cash Equivalents Beginning of Year	122,485
Cash and Cash Equivalents End of Year	$ 1,098,325
Reconciliation of Operating Loss to Net Cash Used
For Operating Activities
Operating loss	$ (1,646,805)
Adjustments to reconcile operating loss to net cash used in operating activities
Changes in assets and liabilities
Receivables	1,174,724
Inventory	8,465
Prepaids	(17,929)
Accounts payable	(194,793)
Accrued liabilities	145,977
Net pension liability	2,594,047
Deferred outflow of resources	65,461
Deferred inflow of resources	(3,363,931)
Other post employment benefit obligation	(113,927)
Net cash (used in) operating activities	$ (1,348,711)

===== PAGE 32 =====

Assets
Cash and Pooled Investments	$ 7,757,411
County Treasurer	235,356
Other County officials
Receivables
Property tax	183,086
Delinquent	119,750,518
Succeeding year	4,954
Special assessments	32,489
Accounts	467
Interest	19,309
Due From Other Governments
Total assets	127,983,590
Liabilities, Deferred Inflows of
Resources, and Fund Balances
Liabilities
Accounts payable	12,405
Salaries and benefits payable	107,114
Due to other governments	5,404,000
Trust payable	121,784
Total liabilities	5,645,303
Deferred Inflows of Resources
Unavailable revenues
Succeeding year
property tax	119,750,518
Net Position
Restricted for individuals, organizations
and other governments	$ 2,587,769

===== PAGE 33 =====

Additions
Property and other county tax	$ 126,732,761
911 surcharge	572,322
State tax credits	8,087,829
Drivers license fees	37,291,294
Office fees and collections	3,705,425
Intergovernmental	1,357,774
Assessments	269,521
Trusts	507,155
Use of money	2,422
Miscellaneous	72,474
Total additions	178,598,977
Deductions
Agency remittances
To other governments	177,976,147
Trusts paid out	506,925
Total deductions	178,483,072
Changes in Net Position	115,905
Net Position Beginning of Year	2,471,864
Net Position End of Year	$ 2,587,769

===== PAGE 34 ===== ## Note 1 - Summary of Significant Accounting Policies Dubuque County is a political subdivision of the State of Iowa and operates under the Home Rule provisions of the Constitution of Iowa. The County operates under the Board of Supervisors form of government. Elections are on a partisan basis. Other elected officials operate independently with the Board of Supervisors. These officials are the Auditor, Treasurer, Recorder, Sheriff, and Attorney. The County provides numerous services to citizens, including law enforcement, health and social services, parks and cultural activities, planning and zoning, roadway construction and maintenance, and general administrative services. The County's financial statements are prepared in conformity with accounting principles generally accepted in the United States of America as prescribed by the Governmental Accounting Standards Board. ## Reporting Entity For financial reporting purposes, Dubuque County has included all funds, organizations, agencies, boards, commissions, and authorities. The County has also considered all potential component units for which it is financially accountable, and other organizations for which the nature and significance of their relationship with the County are such that exclusion would cause the County's financial statements to be misleading or incomplete. The Governmental Accounting Standards Board has set forth criteria to be considered in determining financial accountability. These criteria include appointing a voting majority of an organization's governing body and (1) the ability of the County to impose its will on that organization or (2) the potential for the organization to provide specific benefits to or impose specific financial burdens on the County. Based on the above criteria, the County has determined that there are no potential component units which must be included in the County's financial statements as of and for the year ended June 30, 2023. ## Jointly Governed Organizations The County also participates in several jointly governed organizations that provide goods or services to the citizenry of the County but do not meet the criteria of a joint venture since there is no ongoing financial interest or responsibility by the participating governments. The County Board of Supervisors are members of or appoint representatives to the following boards and commissions: Dubuque County Assessor's Conference Board, Dubuque City Assessor's Conference Board, Dubuque County Emergency Management Commission, Dubuque Metropolitan Area Solid Waste Agency, Dubuque County Joint 911 Service Board, and Dubuque County Early Childhood Iowa Board. Financial transactions of these organizations are included in the County's financial statements only to the extent of the County's fiduciary relationship with the organization and, as such, are reported in the Custodial Funds of the County. ## Basis of Presentation Government-wide Financial Statements – The Statement of Net Position and the Statement of Activities report information on all of the nonfiduciary activities of the County. For the most part, the effect of interfund activity has been removed from these statements. Governmental activities, which normally are supported by property tax, intergovernmental revenues, and other nonexchange transactions, are reported separately from business-type activities, which rely on a significant extent on fees and charges for services. ===== PAGE 35 ===== The Statement of Net Position presents the County's nonfiduciary assets, deferred outflows of resources, liabilities, and deferred inflows of resources, with the difference reported as net position. Net position is reported in the following categories: Net investment in capital assets consists of capital assets, net of accumulated depreciation and reduced by outstanding balances for bonds, notes, and other debt attributable to the acquisition, construction, or improvement of those assets. Restricted net position results when constraints placed on net position use are either externally imposed or imposed by law through constitutional provisions or enabling legislation. Unrestricted net position consists of net position not meeting the definition of the two preceding categories. Unrestricted net position often has constraints on resources imposed by management which can be removed or modified. The Statement of Activities demonstrates the degree to which the direct expenses of a given function are offset by program revenues. Direct expenses are those clearly identifiable with a specific function. Program revenues include (1) charges to customers or applicants who purchase, use, or directly benefit from goods, services, or privileges provided by a given function, and (2) grants, contributions, and interest restricted to meeting the operational or capital requirements of a particular function. Property tax and other items not properly included among program revenues are reported instead as general revenues. Fund Financial Statements – Separate financial statements are provided for governmental funds, proprietary funds and fiduciary funds, even though the latter are excluded from the government-wide financial statements. Major individual governmental funds are reported as separate columns in the fund financial statements. All remaining governmental funds are aggregated and reported as nonmajor governmental funds. The County reports the following major governmental funds: General Fund – The General Fund is the general operating fund of the County. All general tax revenues and other revenues not allocated by law or contractual agreement to some other fund are accounted for in this fund. From the fund are paid the general operating expenditures, the fixed charges, and the capital improvement costs not paid from other funds. Special Revenue Funds – The Rural Services Fund is used to account for property tax and other revenues to provide services which are primarily intended to benefit those persons residing in the County outside of incorporated city areas. The American Rescue Plan Fund is used to account for the American Rescue Plan dollars allocated to the County to be used for pandemic response needs and rebuilding a stronger and more equitable economy. The Secondary Roads Fund is used to account for the road use tax allocation from the state of Iowa, required transfers from the General and Rural Services Funds, and other revenues to be used for secondary road construction and maintenance. Capital Projects Fund – The Local Option Tax Fund is used to account for revenue received from a 1% sales tax to be used for rural road construction. ===== PAGE 36 ===== Debt Service – The Debt Service Fund is utilized to account for revenues to be used for the payment of interest and principal on the County's general long-term debt. The County reports the following major proprietary fund: Sunnycrest Operations – The Sunnycrest Operations Fund is utilized to account for revenues and expenses related to the operations of Sunnycrest. Sunnycrest's building and other capital assets are owned and maintained by the Dubuque County Hospital at Sunnycrest Manor Board of Trustees. The Board of Trustees is a separate governmental entity and is not included within the County's financial statements. Additionally, the County reports the following fund type: Fiduciary Funds – Custodial Funds are used to account for assets held by the County as an agent for individuals, private organizations, other governmental units, and/or other funds. ## Measurement Focus and Basis of Accounting The government-wide, proprietary and fiduciary fund financial statements are reported using the economic resources measurement focus and the accrual basis of accounting. Revenues are recorded when earned and expenses are recorded when a liability is incurred, regardless of the timing of related cash flows. Property tax is recognized as revenue in the year for which it is levied. Grants and similar items are recognized as revenue as soon as all eligibility requirements imposed by the provider have been satisfied. Governmental fund financial statements are reported using the current financial resources measurement focus and the modified accrual basis of accounting. Revenues are recognized as soon as they are both measurable and available. Revenues are considered to be available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. For this purpose, the County considers revenues to be available if they are collected within 60 days after year end. Property tax, intergovernmental revenues (shared revenues, grants, and reimbursements from other governments) and interest are considered to be susceptible to accrual. All other revenue items are considered to be measurable and available only when cash is received by the County. Expenditures generally are recorded when a liability is incurred, as under accrual accounting. However, principal and interest on long-term debt, claims and judgments, and compensated absences are recorded as expenditures only when payment is due. Capital asset acquisitions are reported as expenditures in governmental funds. Proceeds of general long-term debt and acquisitions under capital leases are reported as other financing sources. Under the terms of grant agreements, the County funds certain programs by a combination of specific cost-reimbursement grants, categorical block grants, and general revenues. Thus, when program expenses are incurred, there are both restricted and unrestricted net position available to finance the program. It is the County's policy to first apply cost-reimbursement grant resources to such programs, followed by categorical block grants, and then by general revenues. ===== PAGE 37 ===== When an expenditure is incurred in governmental funds which can be paid either using restricted or unrestricted resources, the County's policy is to pay the expenditure from restricted fund balance and then from less-restrictive classifications – committed, assigned, and then unassigned fund balances. Proprietary funds distinguish operating revenues and expenses from nonoperating items. Operating revenues and expenses generally result from providing services and producing and delivering goods in connection with a proprietary fund's principal ongoing operations. The principal operating revenues from the County's proprietary funds are charges for services. Operating expenses for the proprietary funds include cost of personnel services, contractual services, and operating supplies. All revenues and expenses not meeting this definition are reported as nonoperating revenues and expenses. The County maintains its financial records on the cash basis. The financial statements of the County are prepared by making memorandum adjusting entries to the cash basis financial records. Assets, Deferred Outflows of Resources, Liabilities, Deferred Inflows of Resources, and Fund Equity The following accounting policies are followed in preparing the financial statements: Cash and Pooled Investments – The cash balances of most County funds are pooled and invested. Interest earned on investments is recorded in the General Fund unless otherwise provided by law. Investments are stated at fair value, except for the investment in the Iowa Public Agency Investment Trust which is valued at amortized cost and non-negotiable certificates of deposit which are valued at amortized cost. For purposes of the Statement of Cash Flows, all short-term investments that are highly liquid are considered to be cash equivalents. Cash equivalents also include highly liquid investments with an original maturity date no longer than three months. Property Tax Receivable – Property tax in governmental funds is accounted for using the modified accrual basis of accounting. Property tax receivable is recognized in these funds on the levy or lien date, which is the date the tax asking is certified by the County Board of Supervisors. Delinquent property tax receivable represents unpaid taxes for the current and prior years. The succeeding year property tax receivable represents taxes certified by the Board of Supervisors to be collected in the next fiscal year for the purposes set out in the budget for the next fiscal year. By statute, the Board of Supervisors is required to certify its budget in March of each year for the subsequent fiscal year. However, by statute, the tax asking and budget certification for the following fiscal year becomes effective on the first day of that year. Although the succeeding year property tax receivable has been recorded, the related revenue is deferred in both the government-wide and fund financial statements and will not be recognized as revenue until the year for which it is levied. Property tax revenue recognized in these funds becomes due and collectible in September and March of the fiscal year with a 1 1/2% per month penalty for delinquent payments; is based on January 1, 2021, assessed property valuations; is for the tax accrual period July 1, 2022 through June 30, 2023, and reflects the tax asking contained in the budget certified by the County Board of Supervisors in March 2022. ===== PAGE 38 ===== Interest and Penalty on Property Tax Receivable – Interest and penalty on property tax receivable represents the amount of interest and penalty that was due and payable but has not been collected. Due from and Due to Other Funds – During the course of its operations, the County has numerous transactions between funds. To the extent certain transactions between funds had not been paid or received as of June 30, 2023, balances of interfund amounts receivable or payable have been recorded in the fund financial statements. Due from Other Governments – Due from other governments represents amounts due from the State of Iowa, various shared revenues, grants, and reimbursements from other governments. Inventories – Inventories are valued at cost using the first-in, first-out method. Inventories consist of expendable supplies held for consumption. Inventories of governmental funds are recorded as expenditures when consumed rather than when purchased. Capital Assets – Capital assets, which include property, equipment and vehicles, intangibles, and infrastructure assets (e.g., roads, bridges, curbs, gutters, sidewalks, and similar items which are immovable and of value only to the County), are reported in the applicable governmental or business-type activities column in the government-wide Statement of Net Position. Capital assets are recorded at historical cost if purchased or constructed. Donated capital assets are recorded at acquisition value. The costs of normal maintenance and repair that do not add to the value of the asset or materially extend asset lives are not capitalized. Reportable capital assets are defined by the County as assets with initial, individual costs in excess of the following thresholds and estimated useful lives in excess of two years. There are no capitalization thresholds for land and buildings. All acquisitions for land and buildings are capitalized.

Asset Class	Amount
Infrastructure	$	50,000
Intangibles		50,000
Improvements other than buildings		5,000
Machinery and equipment		5,000

Capital assets of the County are depreciated using the straight-line method over the following estimated useful lives:

Asset Class	Estimated Useful Lives (In Years)
Infrastructure	10-65
Buildings	15-50
Improvements other than buildings	10-25
Intangibles	5-20
Machinery and equipment	5-20

===== PAGE 39 ===== Leases – A lessor should recognize a lease receivable and a deferred inflow of resources at the commencement of the lease term, with certain exceptions for leases of assets held as investments, certain regulated- leases, short-term leases, and leases that transfer ownership of the underlying asset. A lessor should not derecognize the asset underlying the lease. The lease receivable should be measured at the present value of lease payments expected to be received during the lease term. The deferred inflow of resources should be measured at the value of the lease receivable plus any payments received at or before the commencement of the lease term that relate to future periods. Deferred Outflows of Resources – Deferred outflows of resources represent a consumption of net position that applies to a future period(s) and will not be recognized as an outflow of resources (expense/expenditure) until then. Deferred outflows of resources consist of unrecognized items not yet charged to pension and OPEB expense and contributions from the County after the measurement date but before the end of the County's reporting period. Due to Other Governments – Due to other governments represents taxes and other revenues collected by the County and payments for services which will be remitted to other governments. Unearned Revenue – Although certain revenues are measurable, they are not available. Available means collected within the current year or expected to be collected soon enough thereafter to be used to pay liabilities of the current year. Unearned revenue in the governmental fund financial statements represents the amount of assets that have been recognized, but the related revenue has not been recognized since the County has not made a qualifying expenditure. Unearned revenue consists of unspent American Rescue Plan Act and opioid settlement proceeds. Trusts Payable – Trusts payable represents amounts due to others which are held by various County officials in fiduciary capacities until the underlying legal matters are resolved. Compensated Absences – County employees accumulate a limited amount of earned but unused vacation and sick leave hours for subsequent use or for payment upon termination, death, or retirement. A liability is recorded when incurred in the government-wide, proprietary fund, and fiduciary fund financial statements. A liability for these amounts is reported in governmental fund financial statements only for employees who have resigned or retired. The compensated absences liability has been computed based on rates of pay in effect at June 30, 2023. The compensated absences liability attributable to the governmental activities will be paid primarily by the General and Secondary Roads Funds. Long-Term Liabilities – In the government-wide and proprietary fund financial statements, long-term debt and other long-term obligations are reported as liabilities in the applicable governmental activities or proprietary fund Statement of Net Position. In the governmental fund financial statements, the face amount of debt issued is reported as other financing sources. Issuance costs, whether or not withheld from the actual debt proceeds received, are reported as debt service expenditures. ===== PAGE 40 ===== Pensions – For purposes of measuring the net pension liability (asset), deferred outflows of resources and deferred inflows of resources related to pensions and pension expense, information about the fiduciary net position of the Iowa Public Employees' Retirement System (IPERS) and additions to/deductions from IPERS' fiduciary net position have been determined on the same basis as they are reported by IPERS. For this purpose, benefit payments, including refunds of employee contributions, are recognized when due and payable in accordance with the benefit terms. Investments are reported at fair value. The net pension liability (asset) attributable to the governmental activities will be paid primarily by the General and Secondary Roads Funds. Total OPEB Liability – For purposes of measuring the total OPEB liability, deferred outflows of resources related to OPEB, deferred inflows of resources related to OPEB, and OPEB expense, information has been determined based on Dubuque County's actuary report. For this purpose, benefit payments are recognized when due and payable in accordance with the benefit terms. The total OPEB liability attributable to the governmental activities will be paid primarily by the General and Secondary Roads Funds. Deferred Inflows of Resources – Deferred inflows of resources represents an acquisition of net position applicable to a future year(s) which will not be recognized as an inflow of resources (revenue) until that time. Although certain revenues are measurable, they are not available. Available means collected within the current period or expected to be collected soon enough thereafter to be used to pay liabilities of the current period. Deferred inflows of resources in the governmental fund financial statements represent the amount of assets that have been recognized, but the related revenue has not been recognized since the assets are not collected within the current period or expected to be collected soon enough thereafter to be used to pay liabilities of the current period. Deferred inflows of resources consists of succeeding year property tax receivable and other receivables not collected within sixty days after year end. In addition, deferred inflows related to leases where the County is the lessor is reported in the governmental funds balance sheet and state of net position. The deferred inflows of resources related to leases are recognized as an inflow of resources (revenue) over the term of the lease. Deferred inflows of resources in the Statement of Net Position consist of succeeding year property tax receivables that will not be recognized until the year for which it is levied, deferred inflows of resources related to OPEB, the unamortized portion of the net difference between projected and actual earnings on IPERS' investments, and other unrecognized items not yet credited to pension expense. Fund Equity – In the governmental fund financial statements, fund balances are classified as follows: Nonspendable – Amounts which cannot be spent because they are in a nonspendable form or because they are legally or contractually required to be maintained intact. Restricted – Amounts restricted to specific purposes when constraints placed on the use of the resources are either externally imposed by creditors, grantors or state or federal laws or are imposed by law through constitutional provisions or enabling legislation. Committed – Amounts which can be used only for specific purposes pursuant to constraints formally imposed by the Board of Supervisors through ordinance or resolution approved prior to year-end. Committed amounts cannot be used for any other purpose unless the Board of Supervisors removes or changes the specified use by taking the same action it employed to commit those amounts. ===== PAGE 41 ===== Assigned – Amounts the Board of Supervisors intend to use for specific purposes. Unassigned – All amounts not included in the preceding classifications. When an expenditure is incurred for the purposes for which both restricted and unrestricted fund balances/net position are available, the County considers restricted funds to have been spent first. When an expenditure is incurred for which committed, assigned, or unassigned fund balances/net position are available, the County considers amounts to have been spent first out of committed funds, then assigned funds, and finally unassigned funds, as needed, unless the Board of Supervisors has provided otherwise in its commitment or assignment.

Fund Balance Classificati	Purpose	Fund	Amount
Nonspendable	Prepaid Expenses	General	$ 1,545,634
	Prepaid Expenses	Secondary Roads	62,591
	Notes Receivable	General	46,000
	Inventories	General	76,444
	Inventories	Secondary Roads	922,046
			$ 2,652,715
Restricted	Supplemental
	Levy Purposes	General	$ 3,767,615
	Notes Receivable	General	370,000
	Fire and EMS	General	120,000
	Rural Services	Rural Services	618,097
		Rural Community Transportation Program	70,268
	Secondary Roads	Secondary Roads	4,626,235
	Capital Projects	Local Option Tax	3,893,819
		Capital Projects	2,200,000
		Emergency Radio System	357,019
		Courthouse Roof	24,305
	Conservation	REAP Fund	168,568
		Conservation Land Acquisition	517,768
	Records Management	County Recorder's Records Management	59,597
	Economic
	Development	Rural Economic Development	953,144
	Gold Dome Projects	Gold Dome	56,507
	Public Safety	Sheriff Forfeiture	265,564
		Drug Task Force	86,444
		Commissary	373,361
	Debt Obligations	Debt Service	7,870,435
			$ 26,398,746
Committed	Capital Projects	West Campus Complex	$ 602,299

===== PAGE 42 ===== ## Budgets and Budgetary Accounting The budgetary comparison and related disclosures are reported as Required Supplementary Information. ### Implementation of GASB Statement No. 96 As of July 1, 2022, the County adopted GASB Statement No. 96, Subscription Based Information Technology Arrangements (SBITA). The objective of this Statement is to better meet the information needs of financial statement users by improving accounting and financial reporting for SBITAs by governments. There is no impact to the County after review of the county's arrangements. Therefore, there was no need to record a capital asset or deferred inflows of resources related to SBITAs. ## Note 2 - Cash and Pooled Investments The County's deposits in banks at June 30, 2023, were entirely covered by federal depository insurance or by the State Sinking Fund in accordance with Chapter 12C of the Code of Iowa. This chapter provides for additional assessments against the depositories to insure there will be no loss of public funds. The County is authorized by statute to invest public funds in obligations of the United States government, its agencies and instrumentalities; certificates of deposit or other evidences of deposit at federally insured depository institutions approved by the Board of Supervisors; prime eligible bankers acceptances; certain high rated commercial paper; perfected repurchase agreements; certain registered open-end management investment companies; certain joint investment trusts; and warrants or improvement certificates of a drainage district. At June 30, 2023, the County had the following investments:

Investment Maturities (In Years)

Investment Type	Investment Maturities (in Years)
Investment Type	Less Than 1	1 to 5	6 to 10	Amount
U.S. Treasury Securities	$ 4,024,700	$ 289,137	$- -	$ 4,313,837
Federal Agency Obligations	3,015,403	6,153,317	- -	9,168,720
Total Investments	$ 7,040,103	$ 6,442,454	$- -	$ 13,482,557

The County uses the fair value hierarchy established by generally accepted accounting principles based on the valuation inputs used to measure the fair value of the asset. Level 1 inputs are quoted prices in active markets for identical assets. Level 2 inputs are significant other observable inputs. Level 3 inputs are significant unobservable inputs. The U. S. Treasury securities and federal agency obligations are valued by the custodians of the securities using pricing models based on credit quality, time to maturity, stated interest rates and market assumptions (Level 2 inputs). ===== PAGE 43 ===== Interest Rate Risk. The County's investment policy limits the investment of operating funds (funds expected to be expended in the current budget year or within 15 months of receipt) to instruments that mature within 397 days. Funds not identified as operating funds may be invested in investments with maturities longer than 397 days, but the maturities shall be consistent with the needs and use of the County. The County did not hold any operating fund investments with a maturity greater than 397 days during the year. Credit Risk. The County's investment policy limits investments in commercial paper and other corporate debt to the top two highest classifications. The County did not invest in any commercial paper or other corporate debt during the year. The County's investments held during the year ended June 30, 2023 were rated Aa2. Concentration of Credit Risk. The County's investment policy does not allow for a prime bankers' acceptance or commercial paper and other corporate debt balances to be greater than 10% of its total deposits and investments. The policy also limits the amount that can be invested in a single issue to five percent of its total deposits and investments. The County held no such investments during the year. Custodial Credit Risk – Deposits. In the case of deposits, this is the risk that in the event of a bank failure, the County’s deposits may not be returned to it. The County’s deposits are entirely covered by federal depository insurance or by the State Sinking Fund in accordance with Chapter 12C of the Code of Iowa. This chapter provides for additional assessments against the depositories to insure there will be no loss of public funds. Custodial Credit Risk – Investments. For an investment, this is the risk that, in the event of the failure of the counterparty, the County will not be able to recover the value of its investments or collateral securities that are in the possession of an outside party. The County had no custodial risk with regards to investments, since all investments were held by the County or it's agent in the County's name. ## Note 3 - Interfund Balances The detail of interfund receivables and payables at June 30, 2023 is as follows:

Receivable Fund	Payable Fund	Amount
General	General	$ 1,681
	Rural Services	432
		2,113
Secondary Roads	General	17,863
	Rural Services	2,194
		20,057
		$ 22,170

===== PAGE 44 ===== These balances result from the time lag between the dates interfund goods and services are provided and reimbursable expenditures occur, transactions are recorded in the accounting system and payments between funds are made. The detail of interfund transfers for the year ended June 30, 2023 is as follows:

Transfer to	Transfer from	Amount
General Fund	ARPA\nDebt Service	10,000,000n2,000 < /td > < /tr > < tr > < td style = 'text-align: center; word-wrap: break-word;' > < /td > < td style = 'text-align: center; word-wrap: break-word;' > < /td > < td style = 'text-align: center; word-wrap: break-word;' > 10,002,000 < /td > < /tr > < tr > < td style = 'text-align: center; word-wrap: break-word;' > Secondary Roads < /td > < td style = 'text-align: center; word-wrap: break-word;' > Rural Services < /td > < td style = 'text-align: center; word-wrap: break-word;' > 4,797,272 < /td > < /tr > < tr > < td style = 'text-align: center; word-wrap: break-word;' > Nonmajor Governmental Funds < /td > < td style = 'text-align: center; word-wrap: break-word;' > General FundnRural Services < /td > < td style = 'text-align: center; word-wrap: break-word;' > 250,000n75,000 < /td > < /tr > < tr > < td style = 'text-align: center; word-wrap: break-word;' > < /td > < td style = 'text-align: center; word-wrap: break-word;' > < /td > < td style = 'text-align: center; word-wrap: break-word;' > 325,000 < /td > < /tr > < tr > < td style = 'text-align: center; word-wrap: break-word;' > Sunnycrest Operations < /td > < td style = 'text-align: center; word-wrap: break-word;' > General Fund < /td > < td style = 'text-align: center; word-wrap: break-word;' > 2,324,551 < /td > < /tr > < tr > < td style = 'text-align: center; word-wrap: break-word;' > < /td > < td style = 'text-align: center; word-wrap: break-word;' > < /td > < td style = 'text-align: center; word-wrap: break-word;' > 17,448,823

Transfers generally move resources from the fund statutorily required to collect the resources to the fund statutorily required to expend the resources. The transfer to Sunnycrest Operations Fund represents an operating subsidy from the General Fund. ## Note 4 - Notes Receivable The County has made funds available for interest-free loans to rural Dubuque County fire departments and EMS services to purchase fire protection and life support equipment through the County Assistance Fund. These amounts are to be repaid to the County in annual installments. The balance of these notes receivable at June 30, 2023 was $370,000. The County has guaranteed receivables through the Rural Economic Development Intermediary Relending Program with four loans to businesses located in Dubuque County, totaling $181,588 at June 30, 2023. The loans are accounted for in the Rural Economic Development Fund and mature in varying amounts through June 30, 2032. The County has made an interest-free loan to the City of Rickardsville for a sewer relocation project. This amount is to be repaid to the County in annual installments. The balance of this note receivable at June 30, 2023 was $46,000. ===== PAGE 45 ===== ## Note 5 - Leases The County leases a portion of its facilities for a cellular tower antenna site. The lease was entered into in fiscal year 2001 and is non-cancelable for an initial period of ten years, with five renewal periods of five years. The County believes the lessee will exercise the renewal options with reasonable certainty. The agreements allow for 10% increases at renewals. During the fiscal year, the County recognized $20,993 in lease revenue related to the agreement. At June 30, 2023, the County recorded $196,344 in lease receivables and deferred inflows of resources for the arrangement. The County used an interest rate of 2.5%, based on the rates available to finance construction projects over the similar time periods.

	June 30, 2022\nBalance	Additions	Deletions	June 30, 2023\nBalance
Lease Receivable	$ 208,153	$-	$ 11,809	$ 196,344

Remaining amounts to be received associated with these leases are as follows:

Fiscal Year Ended June 30,	Principal		Interest		Total
	$	12,107	$	4,965	$	17,072
2024		12,414		4,659		17,073
2025		14,436		4,345		18,781
2026		14,801		3,980		18,781
2027		15,175		3,606		18,781
2028		87,608		11,931		99,539
2029-2033		39,803		1,517		41,320
2034-2035
Total	$	196,344	$	35,003	$	231,347

===== PAGE 46 ===== ## Note 6 - Capital Assets Capital assets activity for the year ended June 30, 2023 was as follows:

	Balance Beginning of Year	Increases	Decreases	Balance End of Year
Governmental Activities
Capital assets not being depreciated
Land and land improvements	$ 5,586,516	$ 365,230	$ -	$ 5,951,746
Construction in progress	4,888,207	20,342,269	9,480,932	15,749,544
Total capital assets, not being depreciated	10,474,723	20,707,499	9,480,932	21,701,290
Capital assets being depreciated
Buildings	38,152,605	730,603	-	38,883,208
Improvements other than buildings	3,292,959	156,374	-	3,449,333
Machinery and equipment	31,361,354	1,634,377	427,088	32,568,643
Infrastructure	175,741,398	9,147,114	-	184,888,512
Total capital assets, being depreciated	248,548,316	11,668,468	427,088	259,789,696
Less accumulated depreciation for Buildings	11,879,905	987,809	-	12,867,714
Improvements other than buildings	1,387,649	113,272	-	1,500,921
Machinery and equipment	13,005,425	2,255,437	380,123	14,880,739
Infrastructure	79,674,247	5,178,271	-	84,852,518
Total accumulated depreciation	105,947,226	8,534,789	380,123	114,101,892
Total capital assets, being depreciated, net	142,601,090	3,133,679	46,965	145,687,804
Governmental Activities Capital Assets, Net	$ 153,075,813	$ 23,841,178	$ 9,527,897	$ 167,389,094

===== PAGE 47 ===== Depreciation expense was charged to the following functions of the County:

Governmental Activities
Public safety and legal services	$ 1,370,524
Physical health and social services	16,544
Mental health	6,015
County environment and education	518,162
Roads and transportation	6,124,616
Governmental services to residents	2,856
Administration	496,072
Total depreciation expense - governmental activities	$ 8,534,789

Construction Commitments – The County has recognized as a liability only that portion of construction contracts representing construction completed through June 30, 2023. The County has additional commitments for construction contracts of $7,801,065 as of June 30, 2023. These commitments will be funded by current assets and federal and state grants. ## Note 7 - Due to Other Governments The County acts as a fee and tax collection agent for various governmental units. Tax collections are remitted to those governments in the month following collection. A summary of amounts due to other governments related to tax collections at June 30, 2023 is as follows:

Fund	Description	Amount
Custodial
County Recorder	Collections	$ 135,285
County Recorder's Electronic Transaction Fee		2,391
County Sheriff		36,109
Drainage District Fund		734
Agricultural Extension Education Fund		3,824
Schools Fund		445,216
Area Schools Fund		32,091
Corporations Fund		462,382
Townships Fund		8,892
Auto License and Use Tax Fund		4,268,060
Brucellosis and Tuberculosis Eradication Fund		78
Joint Disaster Services Fund		34
County Hospital Fund		8,745
County Libraries		159
Total for custodial funds	$ 5,404,000

===== PAGE 48 ===== ## Note 8 - Long-Term Liabilities A summary of changes in long-term liabilities for the year ended June 30, 2023 is as follows:

Governmental Activities:	Balance\nBeginning of\nYear	Increases	Decreases	Balance\nEnd\nof Year	Amounts\nDue Within\nOne Year
General Obligation Bonds/Notes
Bonds	$ 17,365,000	$ -	$ 1,605,000	$ 15,760,000	$ 1,355,000
Premiums	472,789	-	42,981	429,808	42,981
Total bonds payable	17,837,789	-	1,647,981	16,189,808	1,397,981
Landfill bonds	7,060,000	-	450,000	6,610,000	465,000
Rural Economic
Development Loan	124,492	-	41,208	83,284	41,617
Total General Obligation Bonds/Notes	25,022,281	-	2,139,189	22,883,092	1,904,598
Compensated Absences	4,842,782	2,109,242	1,766,868	5,185,156	1,835,200
Total Non-current Liabilities	$ 29,865,063	$ 2,109,242	$ 3,906,057	$ 28,068,248	$ 3,739,798
Business-Type Activities	Balance			Balance	Amounts
	Beginning of			End	Due Within
	Year	Increases	Decreases	of Year	One Year
Compensated Absences	$ 737,561	$ 302,046	$ 264,218	$ 775,389	$ 274,436

Dubuque County has borrowed funds through the Rural Economic Development Intermediary Relending Program in order to provide economic development loans to industries within Dubuque County. The stated interest rate is 1%. The indebtedness is guaranteed with loans the County has made to various businesses at interest rates ranging from 2.0% – 4.0%. This obligation is owed to the United States Department of Agriculture and therefore constitutes a direct borrowing. During fiscal year 2015, the County issued $4,500,000 of General Obligation Bonds for the purpose of funding the construction of landfill facility improvements by the Dubuque Metropolitan Area Solid Waste Agency (DMASWA), of which the County is an organized member. The proceeds of the bonds were transferred to DMASWA. The County and DMASWA have signed a long term note payable to the County to reimburse the County for all debt service payments related to the bond issue. The interest rates on the bonds range from 2.00% to 4.00%, with a maturity date of June 1, 2034. During fiscal year 2017, the County issued $5,100,000 of General Obligation Bonds for the purpose of funding the construction of landfill facility improvements by the Dubuque Metropolitan Area Solid Waste Agency (DMASWA), of which the County is an organized member. The proceeds of the bonds were transferred to DMASWA. The County and DMASWA have signed a long term note payable to the County to reimburse the County for all debt service payments related to the bond issue. The interest rates on the bonds range from 3.00% to 3.25%, with a maturity date of June 1, 2036. During fiscal year 2018, the County issued $10,175,000 of General Obligation Bonds for the purpose of paying the cost, to the extent, of acquiring and installing emergency communications equipment and systems. The interest rates on the bonds range from 2.00% to 3.00%, with a maturity date of June 1, 2033. ===== PAGE 49 ===== During fiscal year 2018, The County borrowed $1,430,000 of General Obligation Bonds for the purpose of paying the cost, to that extent, of undertaking an urban renewal project in the Greater Downtown Urban Renewal Area of which consists of exterior renovations and roofing repairs to the Dubuque County courthouse. The interest rates on the bonds range from 2.00% to 2.60% with a maturity date of June 1, 2023. During fiscal year 2019, the County borrowed $11,830,000 of General Obligation Bonds for the urban renewal project in the City of Dubuque's Dubuque Industrial Center Economic Development District consisting of constructing a new County building including administrative office space and a maintenance and storage shop. The interest rates on the bonds range from 3.00% to 5.00%, with a maturity date of June 1, 2033. A summary of the County's June 30, 2023, indebtedness is as follows:

General Obligation

Years Ending\nJune 30,	General Obligation Bonds		General Obligation\nLandfill Bonds
	Principal	Interest	Principal	Interest
2024	$ 1,355,000	$ 482,581	$ 465,000	$ 198,609
2025	1,405,000	428,031	475,000	186,065
2026	1,460,000	378,181	490,000	172,965
2027	1,515,000	326,031	505,000	158,865
2028	1,560,000	277,856	520,000	144,327
2029-2033	8,465,000	725,650	2,860,000	480,055
2034-2036	-	-	1,295,000	74,760
Total	$ 15,760,000	$ 2,618,330	$ 6,610,000	$ 1,415,646
Rural Economic\nDevelopment Loan			Total
Years Ending\nJune 30,	Principal	Interest	Principal	Interest
2024	$ 41,617	$ 833	$ 1,861,617	$ 682,023
2025	41,667	517	1,921,667	614,613
2026	-	-	1,950,000	551,146
2027	-	-	2,020,000	484,896
2028	-	-	2,080,000	422,183
2029-2033	-	-	11,325,000	1,205,705
2034-2036	-	-	1,295,000	74,760
Total	$ 83,284	$ 1,350	$ 22,453,284	$ 4,035,326

===== PAGE 50 ===== ## Note 9 - Pension Plan Plan Description – IPERS membership is mandatory for employees of the County, except for those covered by another retirement system. Employees of the County are provided with pensions through a cost-sharing multiple employer defined benefit pension plan administered by Iowa Public Employees' Retirement System (IPERS). IPERS issues a stand-alone financial report which is available to the public by mail at P.O. Box 9117, Des Moines, Iowa 50306-9117 or at www.ipers.org. IPERS benefits are established under Iowa Code Chapter 97B and the administrative rules thereunder. Chapter 97B and the administrative rules are the official plan documents. The following brief description is provided for general informational purposes only. Refer to the plan documents for more information. Pension Benefits – A Regular member may retire at normal retirement age and receive monthly benefits without an early-retirement reduction. Normal retirement age is age 65, any time after reaching age 62 with 20 or more years of covered employment, or when the member's years of service plus the member's age at the last birthday equals or exceeds 88, whichever comes first. These qualifications must be met on the member's first month of entitlement to benefits. Members cannot begin receiving retirement benefits before age 55. The formula used to calculate a Regular member's monthly IPERS benefit includes: A multiplier (based on years of service). The member's highest five-year average salary, except for members with service before June 30, 2012 will use the highest three-year average salary as of that date will be used if it is greater than the highest five-year average salary. Sheriff and deputy and protection occupation members may retire at normal retirement age, which is generally at age 55. Sheriff, deputies and protection occupation members may retire any time after reaching age 50 with 22 or more years of covered employment. The formula used to calculate a sheriff, deputy's or protection occupation member's monthly IPERS benefit includes: 60% of average salary after completion of 22 years of service, plus an additional 1.5% of average salary for years of service greater than 22 years of service but not more than 30 years of service. The member's highest three-year average salary. If a member retires before normal retirement age, the member's monthly retirement benefit will be permanently reduced by an early-retirement reduction. The early-retirement reduction is calculated differently for service earned before and after July 1, 2012. For service earned before July 1, 2012, the reduction is 0.25% for each month that the member receives benefits before the member's earliest normal retirement age. For service earned starting July 1, 2012, the reduction is 0.50% for each month that the member receives benefits before age 65. ===== PAGE 51 ===== Generally, once a member selects a benefit option, a monthly benefit is calculated and remains the same for the rest of the member's lifetime. However, to combat the effects of inflation, retirees who began receiving benefits prior to July 1990 receive a guaranteed dividend with their regular November benefit payments. Disability and Death Benefits – A vested member who is awarded federal Social Security disability or Railroad Retirement disability benefits is eligible to claim IPERS benefits regardless of age. Disability benefits are not reduced for early retirement. If a member dies before retirement, the member's beneficiary will receive a lifetime annuity or a lump-sum payment equal to the present actuarial value of the member's accrued benefit or calculated with a set formula, whichever is greater. When a member dies after retirement, death benefits depend on the benefit option the member selected at retirement. Contributions – Contribution rates are established by IPERS following the annual actuarial valuation, which applies IPERS' Contribution Rate Funding Policy and Actuarial Amortization Method. Statute limits the amount rates can increase or decrease each year to 1 percentage point. IPERS Contribution Rate Funding Policy requires that the actuarial contribution rate be determined using the “entry age normal” actuarial cost method and the actuarial assumptions and methods approved by the IPERS Investment Board. The actuarial contribution rate covers normal cost plus the unfunded actuarial liability payment based on a 30-year amortization period. The payment to amortize the unfunded actuarial liability is determined as a level percentage of payroll, based on the Actuarial Amortization Method adopted by the Investment Board. In fiscal year 2023, pursuant to the required rate, Regular members contributed 6.29% of covered payroll and the County contributed 9.44% of covered payroll for a total rate of 15.73%. The sheriff, deputies and the County each contributed 8.76% of covered payroll for a total rate of 17.52%. Protection occupation members contributed 6.21% of covered payroll and the County contributed 9.31% of covered payroll for a total rate of 15.52%. The County's contributions to IPERS for the year ended June 30, 2023 were $2,243,764. Net Pension Liabilities (Asset), Pension Expense, and Deferred Outflows of Resources and Deferred Inflows of Resources Related to Pensions – At June 30, 2023, the County reported a liability (asset) of $4,552,124 for its proportionate share of the net pension liability (asset). The net pension liability (asset) was measured as of June 30, 2022, and the total pension liability (asset) used to calculate the net pension liability (asset) was determined by an actuarial valuation as of that date. The County's proportion of the net pension liability (asset) was based on the County's share of contributions to the pension plan relative to the contributions of all IPERS participating employers. As of June 30, 2022, the County's collective proportion was 0.1205%, which was a decrease of 1.95% from its collective proportion measured as of June 30, 2021. ===== PAGE 52 ===== For the year ended June 30, 2023, the County recognized pension expense (income) of ($790,023). At June 30, 2023, the County reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources:

	Deferred Outflows of Resources	Deferred Inflows of Resources
Differences Between Expected and Actual Results	$ 853,648	$ 112,883
Changes of Assumptions	6,245	511,703
Net Difference Between Projected and Actual Earnings on IPERS' Investments	-	1,045,233
Changes in Proportion and Differences Between County Contributions and Proportionate Share of Contributions	316,809	369,136
County Contributions Subsequent to the Measurement Date	2,243,764	-
Total	$ 3,420,466	$ 2,038,955

$2,243,764 reported as deferred outflows of resources related to pensions resulting from the County contributions subsequent to the measurement date will be recognized as a reduction of the net pension liability (asset) in the year ended June 30, 2024. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized in pension expense as follows:

Years Ended June 30,	Total
2024	$ (1,136,344)
2025	(787,527)
2026	(1,550,997)
2027	2,653,000
2028	(40,385)
	$ (862,253)

There were no non-employer contributing entities at IPERS. ===== PAGE 53 ===== Actuarial Assumptions – The total pension liability (asset) in the June 30, 2022 actuarial valuation was determined using the following actuarial assumptions, applied to all periods included in the measurement as follows:

Rate of inflation (effective June 30, 2017)	2.60% per annum
Rates of salary increase (effective June 30, 2017)	3.25 to 16.25% average, including inflation Rates vary by membership group.
Long-term investment rate of return (effective June 30, 2017)	7.00% compounded annually, net of investment expense, including inflation
Wage growth (effective June 30, 2017)	3.25% per annum based on 2.60% inflation and 0.65% real wage inflation.

The actuarial assumptions used in the June 30, 2022 valuation were based on the results of a quadrennial experience study covering the period of July 1, 2017 through June 30, 2021. Mortality rates used in the 2022 valuation were based on the PubG-2010 mortality tables with mortality improvements modeled using Scale MP-2021. The long-term expected rate of return on IPERS' investments was determined using a building-block method in which best-estimate ranges of expected future real rates (expected returns, net of pension plan investment expense and inflation) are developed for each major asset class. These ranges are combined to produce the long-term expected rate of return by weighting the expected future real rates of return by the target asset allocation percentage and by adding expected inflation. The target allocation and best estimates of arithmetic real rates of return for each major asset class are summarized in the following table:

Asset Class	Asset Allocation	Long-Term Expected Real Rate of Return
Domestic equity	22.0%	3.57%
International equity	17.5	4.79
Global smart beta equity	6.0	4.16
Core plus fixed income	20.0	1.66
Public credit	4.0	3.77
Cash	1.0	0.77
Private equity	13.0	7.57
Private real assets	8.5	3.55
Private credit	8.0	3.63
	100%

===== PAGE 54 ===== Discount Rate – The discount rate used to measure the total pension liability (asset) was 7.00%. The projection of cash flows used to determine the discount rate assumed that employee contributions will be made at the contractually required rate and that contributions from the County will be made at contractually required rates, actuarially determined. Based on those assumptions, IPERS' fiduciary net position was projected to be available to make all projected future benefit payments of current active and inactive employees. Therefore, the long-term expected rate of return on IPERS' investments was applied to all periods of projected benefit payments to determine the total pension liability (asset). Sensitivity of the County's Proportionate Share of the Net Pension Liability (Asset) to Changes in the Discount Rate – The following presents the County's proportionate share of the net pension liability (asset) calculated using the discount rate of 7.00%, as well as what the County's proportionate share of the net pension liability (asset) would be if it were calculated using a discount rate that is 1% lower (6.00%) or 1% higher (8.00%) than the current rate.

	1% Decrease (6.00%)	Discount Rate (7.00%)	1% Increase (8.00%)
County's proportionate share of the net pension liability (asset)	$ 14,739,552	$ 4,552,124	$ (4,404,794)

IPERS' Fiduciary Net Position – Detailed information about the pension plan's fiduciary net position is available in the separately issued IPERS financial report which is available on IPERS' website at www.ipers.org. Payables to IPERS – All legally required County contributions and legally required employee contributions which had been withheld from employee wages were remitted by the County to IPERS by June 30, 2023. ## Note 10 - Other Postemployment Benefits (OPEB) Plan Description – The County operates a single-employer retiree benefit plan which provides medical/prescription drug benefits for retirees and their spouses. Group insurance benefits are established under Iowa Code Chapter 509A.13. No assets are accumulated in a trust that meets the criteria in paragraph 4 of GASB Statement No.75. The plan does not issue a stand-alone financial report. OPEB Benefits -The medical/prescription drug coverage, which is a partially self-insured medical plan, is administered by Wellmark BCBS. Retirees under age 65 pay the same premium for the medical/prescription drug benefit as active employees, which results in an implicit rate subsidy and an OPEB liability. ===== PAGE 55 ===== Retired participants must be age 55 or older at retirement. At June 30, 2023, the following employees were covered by the benefit terms:

Inactive employees or beneficiaries receiving benefit payments	14
Active employees	327
Total	341

Total OPEB Liability – The County’s total OPEB liability of $2,148,500 was measured as of June 30, 2023 and was determined by an actuarial valuation as of June 30, 2022. Actuarial Assumptions – The total OPEB liability in the June 30, 2023 interim actuarial valuation was determined using the following actuarial assumptions and the entry age normal actuarial cost method, applied to all periods included in the measurement. Rate of inflation (effective June 30, 2021) 2.60% per annum Rates of salary increase (effective June 30, 2021) 3.25% per annum including inflation Discount rate (effective June 30, 2023) Healthcare cost trend rate (effective June 30, 2023) 4.13% compounded annually including inflation 7.00% initial rate decreasing by 0.5% annually to an ultimate rate of 4.50% Discount Rate – The discount rate used to measure the total OPEB liability was 4.13% which reflects the index rate for 20-year tax-exempt general obligation municipal bonds with an average rating of AA/Aa or higher as of the measurement date. Mortality rates are from the SOA Public Plan 2010 tables. Annual retirement probabilities are based on varying rates by age and turnover probabilities mirror those used by IPERS. The actuarial assumptions used in the June 30, 2023 interim valuation were based on the results of an actuarial experience study with dates corresponding to those listed above. ===== PAGE 56 =====

Changes in the Total OPEB Liability

	Total OPEB Liability
Total OPEB liability beginning of year	$ 2,568,366
Changes for the year
Service cost	257,890
Interest	112,964
Changes in assumptions	(6,202)
Differences between expected and actual experiences	(654,638)
Benefit payments	(129,880)
Net changes	(419,866)
Total OPEB liability end of year	$ 2,148,500

Changes of assumptions reflect a change in the discount rate from 4.09% in fiscal year 2022 to 4.13% in fiscal year 2023. Sensitivity of the County's Total OPEB Liability to Changes in the Discount Rate – The following presents the total OPEB liability of the County, as well as what the County's total OPEB liability would be if it were calculated using a discount rate that is 1% lower (3.13%) or 1% higher (5.13%) than the current discount rate.

	1% Decrease\n(3.13%)	Discount Rate\n(4.13%)	1% Increase\n(5.13%)
Total OPEB liability (asset)	$ 2,307,764	$ 2,148,500	1,998,252 < /td > < /tr > < /table > Sensitivity of the County'sTotal OPEB Liability to Changes in the Healthcare Cost Trend Rates – The following presents the total OPEB liability of the County, as well as what the County'stotal OPEB liability would be it were calculated using healthcare cost trend rates that are 1% lower (6.00%) or 1% higher (8.00%) than the current healthcare cost trend rates. < table border = 1 style = 'margin: auto; word-wrap: break-word;' > < tr > < td style = 'text-align: center; word-wrap: break-word;' > < /td > < td style = 'text-align: center; word-wrap: break-word;' > 1% Decreasen(6.00% decreasing to 3.50%) < /td > < td style = 'text-align: center; word-wrap: break-word;' > Healthcare Cost Trend Ratesn(7.00% decreasing to 4.50%) < /td > < td style = 'text-align: center; word-wrap: break-word;' > 1% Increasen(8.00% decreasing to 5.50%) < /td > < /tr > < tr > < td style = 'text-align: center; word-wrap: break-word;' > Total OPEB liability (asset) < /td > < td style = 'text-align: center; word-wrap: break-word;' > 1,863,944	$ 2,148,500	$ 2,485,117

===== PAGE 57 ===== OPEB Expense and Deferred Outflows and Inflows of Resources Related to OPEB – For the year ended June 30, 2023, the County recognized OPEB expense of $295,197. At June 30, 2023, the County reported deferred outflows and inflows of resources related to OPEB from the following resources:

	Deferred Outflows of Resources	Deferred Inflows of Resources
Changes in assumptions	$ 68,075	$ 226,886
Differences between expected and actual experience	350,627	687,453
Total	$ 418,702	$ 914,339

The amount reported as deferred outflows and inflows of resources related to OPEB will be recognized as OPEB expense as follows:

Year Ending June 30,	Amount
2024	$ (75,657)
2025	(75,659)
2026	(49,855)
2027	(39,267)
2028	(49,265)
Thereafter	(205,934)
Total	$ (495,637)

## Note 11 - Risk Management The County is exposed to various risks of loss related to torts; theft of, damage to and destruction of assets; errors and omissions; injuries to employees; and natural disasters. Dubuque County is a member in the Iowa Communities Assurance Pool, as allowed by Chapter 331.301 of the Code of Iowa. The Iowa Communities Assurance Pool (Pool) is a local government risk-sharing pool whose nearly 800 members include various governmental entities throughout the State of Iowa. The Pool was formed in August 1986 for the purpose of managing and funding third-party liability claims against its members. The Pool provides coverage and protection in the following categories: general liability, employment practices liability, cyber liability, automobile liability, public officials liability, law enforcement liability, auto physical damage, and property coverage. There have been no reductions in insurance coverage from prior years. Each member’s annual casualty contributions to the Pool fund current operations and provide capital. Annual casualty operating contributions are those amounts necessary to fund, on a cash basis, the Pool’s general and administrative expenses, claims, claims expenses and reinsurance expenses estimated for the fiscal year, plus all or any portion of any deficiency in capital. Capital contributions are made during the first six years of membership and are maintained at a level determined by the Board not to exceed 300% of basis rate. ===== PAGE 58 ===== The Pool also provides property coverage. Members who elect such coverage make annual operating contributions which are necessary to fund, on a cash basis, the Pool's general and administrative expenses and reinsurance premiums, all of which are due and payable in the current year, plus all or any portion of any deficiency in capital. Any year-end operating surplus is transferred to capital. Deficiencies in operations are offset by transfers from capital and, if insufficient, by the subsequent year's member contributions. The County's property and casualty contributions to the risk pool are recorded as expenditures from its operating funds at the time of payment to the risk pool. The County's contributions to the Pool for the year ended June 30, 2023, were $643,739. The Pool uses reinsurance and excess risk-sharing agreements to reduce its exposure to large losses. The Pool retains general, automobile, police professional, and public officials' liability risks up to $500,000 per claim. Claims exceeding $500,000 are reinsured through reinsurance and excess risk-sharing agreements up to the amount of risk-sharing protection provided by the County's risk-sharing certificate. Property and automobile physical damage risks are retained by the Pool up to $250,000 each occurrence, each location. Property risks exceeding $250,000 are reinsured through reinsurance and excess risk-sharing agreements up to the amount of risk-sharing protection provided by the County's risk-sharing certificate. The Pool's intergovernmental contract with its members provides that in the event a casualty claim, property loss or series of claims or losses exceeds the amount of risk sharing protection provided by the County's risk-sharing certificate, or in the event a casualty claim, property loss or series of claims or losses exhausts the Pool's funds and any excess risk-sharing recoveries, then payment of such claims or losses shall be the obligation of the respective individual member against whom the claim was made or the loss was incurred. The County does not report a liability for losses in excess of reinsurance or excess risk sharing recoveries unless it is deemed probable such losses have occurred and the amount of such loss can be reasonably estimated. Accordingly, at June 30, 2023, no liability has been recorded in the County's financial statements. As of June 30, 2023, settled claims have not exceeded the risk pool or reinsurance coverage since the Pool's inception. Members agree to continue membership in the Pool for a period of not less than one full year. After such period, a member who has given 60 days prior written notice may withdraw from the Pool. Upon withdrawal, payments for all casualty claims and claim expenses become the sole responsibility of the withdrawing member, regardless of whether a claim was incurred or reported prior to the member's withdrawal. Upon withdrawal, a formula set forth in the Pool's intergovernmental contract with its members is applied to determine the amount (if any) to be refunded to the withdrawing member. The County also carries commercial insurance purchased from other insurers for coverage associated with workers' compensation and employee blanket bond. The County assumes liability for any deductibles and claims in excess of coverage limitations. The County assumes responsibility for workers' compensation in excess of $1,000,000 on Coverage B – Employers Liability. The County assumes responsibility for an employee fidelity loss in excess of $100,000 for all employees and in excess of $150,000 for the Treasurer, two Assistant Treasurers and County Auditor. Settled claims resulting from these risks have not exceeded commercial insurance coverage in any of the past three fiscal years. ===== PAGE 59 ===== ## Note 12 - Tax Abatements Governmental Accounting Standards Board Statement No. 77 defines tax abatements as a reduction in tax revenues that results from an agreement between one or more governments and an individual or entity in which (a) one or more governments promise to forgo tax revenues to which they are otherwise entitled and (b) the individual or entity promises to take a specific action after the agreement has been entered into that contributes to economic development or otherwise benefits the governments or the citizens of those governments. ## County Tax Abatements The County provides tax abatements for urban renewal and economic development projects with tax increment financing as provided for in Chapters 15A and 403 of the Code of Iowa. For these types of projects, the County enters into agreements with developers which require the County, after developers meet the terms of the agreements, to rebate a portion of the property tax paid by the developers, to pay the developers an economic development grant or to pay the developers a predetermined dollar amount. No other commitments were made by the County as part of these agreements. For the year ended June 30, 2023, the County abated 114,652 of property tax under the urban renewal and economic development projects. ## Tax Abatement of Other Entities Property tax revenues of the County were reduced by the following amounts for the year ended June 30, 2023 under agreements entered into by the following entities: Entity __City of Dubuque < table border = 1 style = 'margin: auto; word-wrap: break-word;' > < tr > < td style = 'text-align: center; word-wrap: break-word;' > Tax Abatement Program < /td > < td style = 'text-align: center; word-wrap: break-word;' > Amount of Tax Abated < /td > < /tr > < tr > < td style = 'text-align: center; word-wrap: break-word;' > Urban renewal and economic development projects < /td > < td style = 'text-align: center; word-wrap: break-word;' > 474,261 ## Note 13 - Conduit Debt Obligations From time to time, the County has issued Industrial Revenue Bonds to provide financial assistance to private sector entities for the acquisition and construction of industrial and commercial facilities deemed to be in the public interest. The bonds are secured by the property financed and are payable solely from payments received on the underlying mortgage loans. Upon repayment of the bonds, ownership of the acquired facilities transfers to the private-sector entity served by the bond issuance. Neither the County, the State, nor any political subdivision thereof is obligated in any manner for repayment of the bonds. Accordingly, the bonds are not reported as liabilities in the accompanying financial statements. At June 30, 2023 there were two series of Industrial Revenue Bonds outstanding with a principal amount payable of $9,944,945. ===== PAGE 60 =====

Required Supplementary Information June 30, 2023 Dubuque County ===== PAGE 61 =====

	Governmental Funds	Budgeted Amounts		Final to Net Variance - Positive (Negative)
	Actual	Original	Final	Final to Net Variance - Positive (Negative)
Receipts
Property and other County tax	$ 38,998,410	$ 38,265,896	$ 38,259,753	$ 738,657
Interest and penalty on property tax	171,753	116,000	116,000	55,753
Intergovernmental	13,042,010	11,686,169	12,648,477	393,533
Licenses and permits	219,801	126,380	128,155	91,646
Charges for service	2,746,669	2,678,858	2,744,711	1,958
Use of money and property	1,111,236	461,483	723,872	387,364
Miscellaneous	1,421,151	1,683,586	1,940,016	(518,865)
Total receipts	57,711,030	55,018,372	56,560,984	1,150,046
Disbursements
Public safety and legal services	18,920,825	19,480,246	21,340,199	2,419,374
Physical health and social services	6,654,303	5,701,860	8,548,785	1,894,482
County environment and education	8,077,985	5,904,139	21,477,337	13,399,352
Roads and transportation	10,648,958	11,760,476	11,969,373	1,320,415
Governmental services to residents	1,947,263	2,458,110	2,458,110	510,847
Administration	6,060,835	7,275,089	8,599,124	2,538,289
Non-program	590,825	1,189,100	780,000	189,175
Debt service	2,810,420	2,810,521	2,810,521	101
Capital projects	15,625,044	15,882,500	17,825,172	2,200,128
Total disbursements	71,336,458	72,462,041	95,808,621	24,472,163
Excess (Deficiency) of Receipts Over (Under)
Disbursements	(13,625,428)	(17,443,669)	(39,247,637)	25,622,209
Other Financing Sources, Net	-	-	-	-
Excess (Deficiency) of Receipts and Other Financing
Sources Over (Under) Disbursements and Other
Financing Uses	(13,625,428)	(17,443,669)	(39,247,637)	25,622,209
Balance Beginning of Year	66,939,657	54,396,890	66,939,657	-
Balance End of Year	$ 53,314,229	$ 36,953,221	$ 27,692,020	$ 25,622,209
Reconciliation Between Cash and Modified
Accrual Basis	Governmental Funds
	Cash	Accrual	Modified
	Basis	Adjustments	Accrual Basis
Revenues	$ 57,711,030	$ 12,432,519	$ 70,143,549
Expenditures	71,336,458	(3,975,287)	67,361,171
Net	(13,625,428)	16,407,806	2,782,378
Other Financing Sources, Net	-	(2,309,224)	(2,309,224)
Beginning Fund Balances	66,939,657	(12,400,557)	54,539,100
Ending Fund Balances	$ 53,314,229	$ 1,698,025	$ 55,012,254

===== PAGE 62 ===== 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 $23,346,580. 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, 2023, disbursements did not exceed the amounts budgeted by function. However, disbursements in certain departments exceeded the amounts appropriated. ===== PAGE 63 =====

	2023	2022	2021	2020	2019	2018	2017	2016	2015
County's Collective Proportion of the Net Pension Liability (Asset)	0.1205%	2.0735%	0.2005%	0.1788%	0.1850%	0.2202%	0.2140%	0.2041%	0.2022%
County's Collective Proportionate Share of the Pension Liability (Asset)	$ 4,552,124	$ (7,158,407)	$ 14,086,544	$ 10,354,574	$ 11,704,126	$ 14,666,250	$ 13,468,470	$ 10,087,987	$ 8,020,809
County's Covered Payroll	$ 22,839,627	$ 22,473,787	$ 21,451,477	$ 20,581,251	$ 19,893,713	$ 20,155,663	$ 19,112,016	$ 19,006,685	$ 19,336,737
County's Collective Proportionate Share of the Net Pension Liability (Asset) as a Percentage of its Covered Payroll	19.93%	-31.85%	65.67%	50.31%	58.83%	72.76%	70.47%	53.08%	41.48%
IPERS' Net Position as a Percentage of the Total Pension Liability (Asset)	91.40%	100.81%	82.90%	85.45%	83.62%	82.21%	81.82%	85.19%	87.61%

In accordance with GASB Statement No. 68, the amounts presented for each fiscal year were determined as of June 30 of the preceding year. Note: GASB Statement No. 68 requires ten years of information to be presented in this table. However, until a full 10-year trend is compiled, the County will present information for those years for which information is available. ===== PAGE 64 =====

	2023	2022	2021	2020	2019	2018	2017	2016	2015	2014
Statutorily Required Contribution	$ 2,243,764	$ 2,126,005	$ 2,110,593	$ 2,035,439	$ 1,958,931	$ 1,794,370	$ 1,839,953	$ 1,762,938	$ 1,735,597	$ 1,786,173
Contributions in Relation to the Statutorily Required Contribution	2,243,764	2,126,005	2,110,593	2,035,439	1,958,931	1,794,370	1,839,953	1,762,938	1,735,597	1,786,173
Contribution Deficiency (Excess)	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
County's Covered Payroll	$ 24,283,748	$ 22,839,627	$ 22,473,787	$ 21,451,477	$ 20,581,251	$ 19,893,713	$ 20,155,663	$ 19,112,016	$ 19,006,685	$ 19,336,737
Contributions as a Percentage of Covered Payroll	9.24%	9.31%	9.39%	9.49%	9.52%	9.02%	9.13%	9.22%	9.13%	9.24%

===== PAGE 65 ===== ## Changes of Benefit Terms There are no significant changes in benefit terms. ## Changes of Assumptions The 2022 valuation incorporated the following refinements after a quadrennial experience study: • Changed mortality assumptions to the PubG-2010 mortality tables with mortality improvements modeled using Scale MP-2021. • Adjusted retirement rates for Regular members. - Lowered disability rates for Regular members. • Adjusted termination rates for all membership groups. The 2018 valuation implemented the following refinements as a result of a demographic assumption study dated June 28, 2018: • Changed mortality assumptions to the RP-2014 mortality tables with mortality improvements modeled using Scale MP-2017. • Adjusted retirement rates. Lowered disability rates. • Adjusted the probability of a vested Regular member electing to receive a deferred benefit. • Adjusted the merit component of the salary increase assumption. ## The 2017 valuation implemented the following refinements as a result of an experience study dated March 24, 2017: • Decreased the inflation assumption from 3.00% to 2.60%. • Decreased the assumed rate of interest on member accounts from 3.75% to 3.50% per year. • Decreased the discount rate from 7.50% to 7.00%. • Decreased the wage growth assumption from 4.00% to 3.25%. • Decreased the payroll growth assumption from 4.00% to 3.25%. ## The 2014 valuation implemented the following refinements as a result of a quadrennial experience study: • Decreased the inflation assumption from 3.25% to 3.00%. • Decreased the assumed rate of interest on member accounts from 4.00% to 3.75% per year. • Adjusted male mortality rates for retirees in the Regular membership group. • Reduced retirement rates for sheriffs and deputies between the ages of 55 and 64. • Moved from an open 30-year amortization period to a closed 30-year amortization period for the UAL (unfunded actuarial liability) beginning June 30, 2014. Each year thereafter, changes in the UAL from plan experience will be amortized on a separate closed 20-year period. ===== PAGE 66 =====

	2023	2022	2021	2020	2019	2018
Service Cost	$ 257,890	$ 242,268	$ 220,497	$ 144,984	$ 140,196	$ 143,379
Interest	112,964	53,938	58,989	69,058	75,109	73,520
Changes in Assumptions	(6,202)	(295,163)	72,778	806	52,050	10,664
Differences Between Expected and Actual Experiences	(654,638)	409,929	5,743	79,179	(136,760)	(217,066)
Benefit Payments	(129,880)	(125,866)	(142,811)	(96,086)	(120,983)	(119,445)
Net Change in Total OPEB Liability	(419,866)	285,106	215,196	197,941	9,612	(108,948)
Total OPEB Liability Beginning of year	2,568,366	2,283,260	2,068,064	1,870,123	1,860,511	1,969,459
Total OPEB Liability End of Year	$ 2,148,500	$ 2,568,366	$ 2,283,260	$ 2,068,064	$ 1,870,123	$ 1,860,511
Covered-Employee Payroll	$ 21,913,254	$ 20,613,984	$ 19,711,846	$ 19,260,214	$ 18,733,868	$ 18,144,182
Total OPEB Liability as a Percentage of Covered-Employee Payroll	9.8%	12.5%	11.6%	10.7%	10.0%	10.3%

Notes to Schedule of Changes in the County's Total OPEB Liability and Related Ratios No assets are accumulated in a trust that meets the criteria in paragraph 4 of GASB Statement 75. Changes in benefit terms: There were no significant changes in benefit terms. Changes in assumptions: The 2022 valuation implemented the following refinements as a result of a new actuarial opinion date June 30, 2023: Changed mortality assumptions to the SOA Public Plan 2010 tables. Changes in assumptions and other inputs reflect the effects of changes in the discount rate each period. The following are the discount rates used in each period.

Year Ended June 30, 2023	4.13%
Year Ended June 30, 2022	4.09%
Year Ended June 30, 2021	2.19%
Year Ended June 30, 2020	2.66%
Year Ended June 30, 2019	3.51%
Year Ended June 30, 2018	3.87%
Year Ended June 30, 2017	3.58%

GASB Statement No.75 requires ten years of information to be presented in this table. However, until a full 10-year trend is compiled, the County will present information for those years for which information is available. ===== PAGE 67 =====

Other Supplementary Information June 30, 2023 Dubuque County ===== PAGE 68 =====

	Special Revenue
	REAP Fund	County Recorder's Records Management	Rural Economic Development	Gold Dome	Sheriff Forfeiture	TIF	Drug Task Force	Rural Community Transportation	Commissary	Opioid
Assets
Cash and Pooled Investments Receivables	$ 168,455	$ 59,558	$ 771,556	$ 56,469	$ 265,564	$ -	$ 86,444	$ 75,268	$ 373,361	$ 462,108
Accrued interest	113	39	-	38	-	-	-	-	-	-
Notes Receivable	-	-	181,588	-	-	-	-	-	-	-
Total assets	$ 168,568	$ 59,597	$ 953,144	$ 56,507	$ 265,564	$ -	$ 86,444	$ 75,268	$ 373,361	$ 462,108
Liabilities, Deferred Inflows of Resources, and Fund Balances
Liabilities
Due to other governments	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 5,000	- < /td > < td colspan = "3" > -
Unearned revenue	-	-	-	-	-	-	-	-	-	462,108
Total liabilities	-	-	-	-	-	-	-	5,000	-	462,108
Fund Balances
Restricted	$ 168,568	59,597	953,144	56,507	265,564	-	86,444	70,268	373,361	-
Committed	-	-	-	-	-	-	-	-	-	-
Total fund balances	168,568	59,597	953,144	56,507	265,564	-	86,444	70,268	373,361	-
Total liabilities, deferred inflows of resources, and fund balances	$ 168,568	$ 59,597	$ 953,144	$ 56,507	$ 265,564	$ -	$ 86,444	$ 75,268	$ 373,361	$ 462,108

===== PAGE 69 =====

	Capital Projects
	Capital Projects	Conservation Land Acquisition	Emergency Radio System	West Campus Complex	Courthouse Roof	Total
Assets
Cash and Pooled Investments	$ 2,200,000	$ 517,768	$ 357,019	$ 602,299	$ 24,305	$ 6,020,174
Receivables
Accrued interest	-	-	-	-	-	-	190
Notes Receivable	-	-	-	-	-	-	181,588
Total assets	$ 2,200,000	$ 517,768	$ 357,019	$ 602,299	$ 24,305	$ 6,201,952
Liabilities, Deferred Inflows of Resources, and Fund Balances
Liabilities
Due to other governments	$ -	$ -	$ -	$ -	$ -	$ 5,000
Unearned revenue	-	-	-	-	-	462,108
Total liabilities	-	-	-	-	-	467,108
Fund Balances
Restricted	2,200,000	517,768	357,019	-	24,305	5,132,545
Committed	-	-	-	602,299	-	602,299
Total fund balances	2,200,000	517,768	357,019	602,299	24,305	5,734,844
Total liabilities, deferred inflows of resources, and fund balances	$ 2,200,000	$ 517,768	$ 357,019	$ 602,299	$ 24,305	$ 6,201,952

===== PAGE 70 =====

Dubuque County Schedule 2 – Combining Statement of Revenues, Expenditures, and Changes in Fund Balances Nonmajor Governmental Funds Year Ended June 30, 2023

	Special Revenue
	REAP Fund	County Recorder's Records Management	Rural Economic Development	Gold Dome	Sheriff Forfeiture	TIF	Drug Task Force	Rural Community Transportation	Commissary	Opioid
Revenues
Property and other County tax	$ -	$ -	$ -	$ -	$ -	$ 109,719	$ -	$ -	$ -	$ -	$ -
Intergovernmental Charges for service	29,255	-	-	-	-	4,933	-	-	-	-	-
Use of money and property	-	13,088	-	-	-	-	-	-	188,992	-	-
Miscellaneous	615	206	6,696	209	748	-	53	-	-	-	-
Total revenues	29,870	13,294	6,696	209	748	114,652	68,024	-	188,992	-	-
Expenditures
Operating
Public safety and legal services	-	-	-	-	15,000	-	72,997	-	239,869	-	-
County environment and education	-	-	1,422	-	-	114,652	-	-	-	-	-
Debt Service	-	-	42,450	-	-	-	-	-	-	-	-
Capital projects	-	-	-	-	-	-	59,444	80,000	-	-	-
Total expenditures	-	-	43,872	-	15,000	114,652	132,441	80,000	239,869	-	-
Excess (Deficiency) of Revenues Over (Under) Expenditures	29,870	13,294	(37,176)	209	(14,252)	-	(64,417)	(80,000)	(50,877)	-	-
Other Financing Sources
Transfers in	-	-	-	-	-	-	-	75,000	-	-	-
Net Change in Fund Balances	29,870	13,294	(37,176)	209	(14,252)	-	(64,417)	(5,000)	(50,877)	-	-
Fund Balances Beginning of Year	138,698	46,303	990,320	56,298	279,816	-	150,861	75,268	424,238	-	-
Fund Balances End of Year	$ 168,568	$ 59,597	$ 953,144	$ 56,507	$ 265,564	$ -	$ 86,444	$ 70,268	$ 373,361	$ -	-

===== PAGE 71 =====

	Capital Projects
	Capital Projects	Conservation Land Acquisition	Emergency Radio System	West Campus Complex	Courthouse Roof	Total
Revenues
Property and other County tax	$ -	$ -	$ -	$ -	$ -	$ 109,719
Intergovernmental Charges for service	-	-	-	-	-	34,188
Use of money and property	-	-	-	-	-	202,080
Miscellaneous	-	-	-	-	-	8,527
	-	-	-	-	-	67,971
Total revenues	-	-	-	-	-	422,485
Expenditures
Operating
Public safety and legal services	-	-	-	-	-	327,866
County environment and education	-	-	-	-	-	116,074
Debt Service	-	-	-	-	-	42,450
Capital projects	-	12,583	-	-	-	152,027
Total expenditures	-	12,583	-	-	-	638,417
Excess (Deficiency) of Revenues Over (Under) Expenditures	-	(12,583)	-	-	-	(215,932)
Other Financing Sources
Transfers in	-	250,000	-	-	-	325,000
Net Change in Fund Balances	-	237,417	-	-	-	109,068
Fund Balances Beginning of Year	2,200,000	280,351	357,019	602,299	24,305	5,625,776
Fund Balances End of Year	$ 2,200,000	$ 517,768	$ 357,019	$ 602,299	$ 24,305	$ 5,734,844

===== PAGE 72 =====

	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,391	$ -	$ 981,416	$ 734	$ 2,811	$ 595,098	$ 366,661	$ 329,670
Other County officials	-	131,999	-	103,357	-	-	-	-	-	-
Receivables
Property tax
Delinquent	-	-	-	-	-	-	1,013	1,591	831	115,546
Succeeding year	-	-	-	-	-	-	620,350	627,020	730,275	73,046,946
Special assessments	-	-	-	-	-	-	-	-	-	-
Accounts	-	3,286	-	-	29,203	-	-	-	-	-
Interest	-	-	-	-	467	-	-	-	-	-
Due From Other Governments	-	-	-	-	19,309	-	-	-	-	-
Total assets	-	135,285	2,391	103,357	1,030,395	734	624,174	1,223,709	1,097,767	73,492,162
Liabilities, Deferred Inflows of Resources, and Fund Balances
Liabilities
Accounts payable	-	-	-	-	3,714	-	-	51	322	-
Salaries and benefits payable	-	-	-	-	-	-	-	31,985	31,424	-
Due to other governments	-	135,285	2,391	36,109	-	734	3,824	-	-	445,216
Trust payable	-	-	-	67,248	-	-	-	-	-	-
Total liabilities	-	135,285	2,391	103,357	3,714	734	3,824	32,036	31,746	445,216
Deferred Inflows of Resources Unavailable revenues
Succeeding year
property tax	-	-	-	-	-	-	620,350	627,020	730,275	73,046,946
Net Position
Restricted for individuals, organizations and other governments	$ -	$ -	$ -	$ -	$ 1,026,681	$ -	$ -	$ 564,653	$ 335,746	$ -

===== PAGE 73 =====

5,103,168	37,213,029	970,576	-	9,531	-	1,429,623	-	-	119,750,518
$-	$-	$-	$-	$-	$-	130,317	$-	461,411	$68,961

	Area School Fund	Corporations Fund	Townships Fund	Auto License and Use Tax Fund	Brucellosis and Tuberculosis Eradication Fund	Joint Disaster Services Fund	County Hospital Fund	County Libraries	Tax Sales	Total
$	24,314	$ 406,174	$ 6,156	$ 4,268,060	$ 57	$ 137,852	$ 60,964	$ 506,092	$ 68,961	$ 7,757,411
	7,777	51,254	2,736	-	21	-	2,317	-	-	183,086
	5,103,168	37,213,029	970,576	-	9,531	-	1,429,623	-	-	119,750,518
	-	4,954	-	-	-	-	-	-	-	4,954
	-	-	-	-	-	-	-	-	-	32,489
	-	-	-	-	-	-	-	-	-	467
	-	-	-	-	-	-	-	-	-	19,309
5,135,259	37,675,411	979,468	4,268,060	9,609	137,852	1,492,904	506,092	68,961	127,983,590
	-	-	-	-	-	1,459	-	6,859	-	12,405
	-	-	-	-	-	6,042	-	37,663	-	107,114
	32,091	462,382	8,892	4,268,060	78	34	8,745	159	-	5,404,000
	-	-	-	-	-	-	54,536	-	-	121,784
32,091	462,382	8,892	4,268,060	78	7,535	63,281	44,681	-	-	5,645,303

Net Position Restricted for individuals, organizations and other governments Deferred Inflows of Resources Unavailable revenues Succeeding year property tax Total liabilities Liabilities Accounts payable Salaries and benefits payable Due to other governments Trust payable Liabilities, Deferred Inflows of Resources, and Fund Balances Total assets Cash and Pooled Investments County Treasurer Other County officials Receivables Property tax Delinquent Succeeding year Special assessments Accounts Interest Due From Other Governments Assets ===== PAGE 74 ===== Dubuque County Schedule 4 – Combining Statement of Changes in Fiduciary Net Position Custodial Funds Custodial Funds Year Ended June 30, 2023

	County Recorder's Electronic Transaction		County Sheriff	911 Fund	Drainage District Fund	Agricultural Extension Education Fund	County Assessor Fund	City Assessor Fund	Schools Fund
County Auditor	County Recorder	County Electronic Transaction	County Sheriff	911 Fund	Drainage District Fund	Agricultural Extension Education Fund	County Assessor Fund	City Assessor Fund	Schools Fund
$	-	$	-	$	-	$ 600,083	$ 714,416	714,318	$ 68,490,166
	-	-	-	572,322	-	-	-	-	-
	-	-	-	-	-	43,157	46,541	56,825	3,564,823
	-	-	-	-	-	-	-	-	-
	-	1,175,082	13,088	1,997,039	-	-	-	-	-
	-	-	-	12,000	-	-	-	-	-
	-	-	-	-	-	-	-	-	-
	-	-	486,760	-	-	-	-	-	-
	-	-	-	2,421	1	-	-	-	-
	-	-	-	8,090	-	-	943	1,015	-
	-	1,175,082	13,088	2,483,799	594,833	1 643,240	761,900	772,158	72,054,989
	-	1,175,082	13,088	1,997,293	712,726	1 643,240	727,895	721,333	72,054,989
	24	-	-	486,506	-	-	-	-	-
	24	1,175,082	13,088	2,483,799	712,726	1 643,240	727,895	721,333	72,054,989
	(24)	-	-	-	(117,893)	-	34,005	50,825	-
	24	-	-	-	1,144,574	-	530,648	284,921	-
$	-	$	-	$ 1,026,681	$ -	$ -	$ 564,653	$ 335,746	$

Additions
Property and other county tax
911 surcharge
State tax credits
Drivers license fees
Office fees and collections
Intergovernmental
Assessments
Trusts
Use of money
Miscellaneous
Total additions
Deductions
Agency remittances
To other governments
Trusts paid out
Total deductions
Changes in Net Position
Net Position Beginning of Year
Net Position End of Year

===== PAGE 75 =====

	Area\nSchool\nFund	Corporations\nFund	Townships\nFund	Auto\nLicense and\nUse Tax\nFund	Brucellosis and\nTuberculosis\nEradication\nFund	Joint\nDisaster\nServices\nFund	County\nHospital\nFund	County\nLibraries	Tax\nSales	Total
Additions
Property and other county tax	$ 4,766,298	$ 49,134,593	$ 928,546	$ -	$ 12,197	$ -	$ 1,372,144	$ -	$ -	$ 126,732,761
911 surcharge	-	-	-	-	-	-	-	-	-	572,322
State tax credits	249,474	3,975,791	48,636	-	925	-	101,657	-	-	8,087,829
Drivers license fees	-	-	-	37,291,294	-	-	-	-	-	37,291,294
Office fees and collections	-	-	-	-	-	-	-	1,273	518,943	3,705,425
Intergovernmental	-	-	-	-	-	259,434	-	1,086,340	-	1,357,774
Assessments	-	269,521	-	-	-	-	-	-	-	269,521
Trusts	-	-	-	-	-	-	20,395	-	-	507,155
Use of money	-	-	-	-	-	-	-	-	-	2,422
Miscellaneous	-	-	-	-	-	52,579	-	9,847	-	72,474
Total additions	5,015,772	53,379,905	977,182	37,291,294	13,122	312,013	1,494,196	1,097,460	518,943	178,598,977
Deductions
Agency remittances
To other governments	5,015,772	53,379,905	977,182	37,291,294	13,122	290,549	1,473,801	1,038,893	449,982	177,976,147
Trusts paid out	-	-	-	-	-	-	20,395	-	-	506,925
Total deductions	5,015,772	53,379,905	977,182	37,291,294	13,122	290,549	1,494,196	1,038,893	449,982	178,483,072
Changes in Net Position	-	-	-	-	-	21,464	-	58,567	68,961	115,905
Net Position Beginning of Year	-	-	-	-	-	108,853	-	402,844	-	2,471,864
Net Position End of Year	$ -	$ -	$ -	$ -	$ -	$ 130,317	$ -	$ 461,411	$ 68,961	$ 2,587,769

===== PAGE 76 =====

	2023	2022	2021	2020	2019	2018	2017	2016	2015	2014
Revenues
Property and other County tax	$ 38,975,949	$ 40,261,097	$ 39,626,620	$ 37,945,349	$ 37,162,550	$ 36,149,564	$ 35,169,160	$ 33,901,929	$ 33,618,015	$ 32,608,325
Interest and penalty on property tax	171,970	191,455	332,471	73,711	172,767	203,421	223,218	211,608	200,781	221,863
Intergovernmental	25,674,557	11,608,765	14,563,582	12,404,499	13,589,892	11,009,764	13,089,056	17,769,685	22,165,495	19,631,019
Licenses and permits	207,166	163,347	155,640	135,994	153,709	160,630	158,763	145,890	117,945	113,407
Charges for service	2,971,316	3,136,621	3,185,509	2,554,705	2,493,642	2,420,783	2,397,698	2,415,214	3,594,730	3,709,160
Use of money and property	1,068,167	(175,250)	486,655	1,570,447	1,509,004	467,584	257,042	309,741	201,157	133,029
Miscellaneous	1,074,424	942,787	822,702	2,115,421	1,193,412	922,065	783,502	694,356	618,640	518,874
Total revenues	$ 70,143,549	$ 56,128,822	$ 59,173,179	$ 56,800,126	$ 56,274,976	$ 51,333,811	$ 52,078,439	$ 55,448,423	$ 60,516,763	$ 56,935,677
Expenditures
Operating
Public safety and legal services	$ 19,219,632	$ 18,259,549	$ 16,490,602	$ 16,748,197	$ 15,619,905	$ 14,924,604	$ 14,614,405	$ 14,422,347	$ 14,060,278	$ 13,584,345
Physical health and social services	4,502,959	2,427,504	2,841,039	3,037,836	2,042,448	1,965,078	1,943,714	1,799,294	12,035,761	12,568,583
Mental health	-	3,809,859	3,917,929	3,500,154	2,630,242	2,885,354	3,344,164	3,293,083	3,302,104	2,629,888
County environment and education	8,274,588	5,309,563	4,463,273	4,304,966	2,741,616	4,989,707	2,349,931	2,568,409	2,634,780	2,693,106
Roads and transportation	10,294,871	8,717,340	9,718,085	8,190,126	8,399,903	8,510,116	7,745,152	8,355,856	7,164,104	7,426,206
Governmental services to residents	1,926,119	2,066,922	2,106,595	2,202,436	1,866,737	1,615,917	1,489,051	1,351,855	1,340,195	1,372,871
Administration	5,701,883	4,759,232	5,004,321	4,842,990	6,085,688	3,844,095	6,996,165	11,607,385	6,973,229	6,434,258
Non-program	185,542	82,737	216,806	113,187	1,280,069	1,356,582	1,373,141	1,305,967	615,170	579,716
Debt service	2,853,870	2,856,645	2,853,385	3,053,218	4,830,531	5,050,975	1,902,214	985,400	703,925	607,076
Capital projects	14,401,707	9,267,105	7,310,674	11,172,316	25,676,622	11,094,575	11,644,315	5,454,851	6,859,625	5,804,916
Total expenditures	$ 67,361,171	$ 57,556,456	$ 54,922,709	$ 57,165,426	$ 71,173,761	$ 56,237,003	$ 53,402,252	$ 51,144,447	$ 55,689,171	$ 53,700,965

===== PAGE 77 =====

Information Provided to Comply with Government Auditing Standards and the Uniform Guidance June 30, 2023 Dubuque County ===== PAGE 78 ===== # Independent Auditor's Report on Internal Control over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards To the Officials of Dubuque County: We have audited, in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States (Government Auditing Standards), the financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of Dubuque County, Iowa, (County) as of and for the year ended June 30, 2023, and the related notes to the financial statements, which collectively comprise the County's basic financial statements and have issued our report thereon dated December 15, 2023. ## Report on Internal Control over Financial Reporting In planning and performing our audit of the financial statements, we considered the County's internal control over financial reporting (internal control) as a basis for designing audit procedures that are appropriate in the circumstances for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the County's internal control. Accordingly, we do not express an opinion on the effectiveness of the County's internal control. A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, misstatements on a timely basis. A material weakness is a deficiency, or a combination of deficiencies, in internal control, such that there is a reasonable possibility that a material misstatement of the entity's financial statements will not be prevented, or detected and corrected on a timely basis. A significant deficiency is a deficiency, or a combination of deficiencies, in internal control that is less severe than a material weakness, yet important enough to merit attention by those charged with governance. Our consideration of internal control was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control that might be material weaknesses or significant deficiencies. Given these limitations, during our audit we did not identify any deficiencies in internal control that we consider to be material weaknesses. However, material weaknesses or significant deficiencies may exist that were not identified. ===== PAGE 79 ===== ## Report on Compliance and Other Matters As part of obtaining reasonable assurance about whether the County's financial statements are free from material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the financial statements. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards. However, we noted certain immaterial instances of non-compliance or other matters which are described in Part IV of the accompanying schedule of findings and questioned costs. Comments involving statutory and other legal matters about the County’s operations for the year ended June 30, 2023 are based exclusively on knowledge obtained from procedures performed during our audit of the financial statements of the County. Since our audit was based on tests and samples, not all transactions that might have had an impact on the comments were necessarily audited. The comments involving statutory and other legal matters are not intended to constitute legal interpretations of those statutes. ## County's Response to Finding Government Auditing Standards requires the auditor to perform limited procedures on the County's response to the finding identified in our audit and described in the accompanying schedule of findings and questioned costs. The County's response was not subjected to the other auditing procedures applied in the audit of the financial statements and, accordingly, we express no opinion on the response. ## Purpose of this Report The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the entity's internal control or on compliance. This report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the entity's internal control and compliance. Accordingly, this communication is not suitable for any other purpose.

Dubuque, Iowa December 15, 2023 ===== PAGE 80 ===== # Independent Auditor's Report on Compliance for the Major Federal Program and Report on Internal Control Over Compliance Required by the Uniform Guidance The Officials of Dubuque County: ## Report on Compliance for the Major Federal Program ## Qualified Opinion We have audited Dubuque County, Iowa’s (County) compliance with the types of compliance requirements identified as subject to audit in the OMB Compliance Supplement that could have a direct and material effect on the County’s major federal program for the year ended June 30, 2023. The County’s major federal program is identified in the summary of auditor’s results section of the accompanying schedule of findings and questioned costs. Qualified Opinion on the Coronavirus State and Local Fiscal Recovery Funds Program (21.027) In our opinion, except for the noncompliance described in the Basis for Qualified Opinion section of our report, the County complied, in all material respects, with the compliance requirements referred to above that could have a direct and material effect on its major Federal program identified in the summary of auditor's results section of the accompanying schedule of findings and questioned costs for the year ended June 30, 2023. ## Basis for Qualified Opinion We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America (GAAS); the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States (Government Auditing Standards); and the audit 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). Our responsibilities under those standards and the Uniform Guidance are further described in the Auditor's Responsibilities for the Audit of Compliance section of our report. We are required to be independent of the County and to meet our other ethical responsibilities, in accordance with relevant ethical requirements relating to our audit. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our opinion on compliance for the major federal program. Our audit does not provide a legal determination of the County's compliance with the compliance requirements referred to above. ===== PAGE 81 ===== Matter Giving Rise to Qualified Opinion on the Coronavirus State and Local Fiscal Recovery Funds Program (21.027) As described in the accompanying schedule of findings and questioned costs, the County did not comply with requirements regarding Assistance Listing No. 21.027 Coronavirus State and Local Fiscal Recovery Funds as described in finding 2023-001 for Reporting. Compliance with such requirements is necessary, in our opinion, for the County to comply with the requirements applicable to that program. ## Responsibilities of Management for Compliance Management is responsible for compliance with the requirements referred to above and for the design, implementation, and maintenance of effective internal control over compliance with the requirements of laws, statutes, regulations, rules and provisions of contracts or grant agreements applicable to the County's federal programs. ## Auditor's Responsibilities for the Audit of Compliance Our objectives are to obtain reasonable assurance about whether material noncompliance with the compliance requirements referred to above occurred, whether due to fraud or error, and express an opinion on the County's compliance based on our audit. Reasonable assurance is a high level of assurance but is not absolute assurance and therefore is not a guarantee that an audit conducted in accordance with GAAS, Government Auditing Standards, and the Uniform Guidance will always detect material noncompliance when it exists. The risk of not detecting material noncompliance resulting from fraud is higher than for that resulting from error, as fraud may involve collusion, forgery, intentional omissions, misrepresentations, or the override of internal control. Noncompliance with the compliance requirements referred to above is considered material, if there is a substantial likelihood that, individually or in the aggregate, it would influence the judgment made by a reasonable user of the report on compliance about the County's compliance with the requirements of the major federal program as a whole. In performing an audit in accordance with GAAS, Government Auditing Standards, and the Uniform Guidance, we: Exercise professional judgment and maintain professional skepticism throughout the audit. Identify and assess the risks of material noncompliance, whether due to fraud or error, and design and perform audit procedures responsive to those risks. Such procedures include examining, on a test basis, evidence regarding the County's compliance with the compliance requirements referred to above and performing such other procedures as we considered necessary in the circumstances. Obtain an understanding of the County's internal control over compliance relevant to the audit in order to design audit procedures that are appropriate in the circumstances and to test and report on internal control over compliance in accordance with the Uniform Guidance, but not for the purpose of expressing an opinion on the effectiveness of the County's internal control over compliance. Accordingly, no such opinion is expressed. ===== PAGE 82 ===== We are required to communicate with those charged with governance regarding, among other matters, the planned scope and timing of the audit and any significant deficiencies and material weaknesses in internal control over compliance that we identified during the audit. Government Auditing Standards requires the auditor to perform limited procedures on the County's response to the noncompliance findings identified in our compliance audit described in the accompanying schedule of findings and questioned costs. The County's response was not subjected to the other auditing procedures applied in the audit of compliance and, accordingly, we express no opinion on the response. ## Report on Internal Control over Compliance Our consideration of internal control over compliance was for the limited purpose described in the Auditor's Responsibilities for the Audit of Compliance section above and was not designed to identify all deficiencies in internal control over compliance that might be material weaknesses or significant deficiencies in internal control over compliance and therefore, material weaknesses or significant deficiencies may exist that were not identified. However, as discussed below, we did identify a certain deficiency in internal control over compliance that we consider to be a material weakness. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. A material weakness in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over compliance, such that there is a reasonable possibility that material noncompliance with a type of compliance requirement of a federal program will not be prevented, or detected and corrected, on a timely basis. A significant deficiency in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over compliance with a type of compliance requirement of a federal program that is less severe than a material weakness in internal control over compliance, yet important enough to merit attention by those charged with governance. We consider the deficiency in internal control over compliance described in the accompanying schedule of findings and questioned costs as item 2023-001 to be a material weakness. Our audit was not designed for the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, no such opinion is expressed. Government Auditing Standards requires the auditor to perform limited procedures on the County's response to the internal control over the compliance finding identified in our compliance audit described in the accompanying schedule of findings and questioned costs. The County's response was not subjected to the other auditing procedures applied in the audit of compliance and, accordingly, we express no opinion on the response. The purpose of this report on internal control over compliance is solely to describe the scope of our testing of internal control over compliance and the results of that testing based on the requirements of the Uniform Guidance. Accordingly, this report is not suitable for any other purpose.

Dubuque, Iowa December 15, 2023 ===== PAGE 83 =====

Federal Grantor/Pass-Through Grantor/Program or Cluster Title	Federal Financial Assistance Listing	Pass-Through Entity Identifying Number	Federal Expenditures	Amounts Passed-Through to Subrecipients
Department of Agriculture
Pass-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	$ 51,074	$ -
Direct Program
Watershed Protection and Flood Prevention	10.904		157,650	-
Total Department of Agriculture			208,724	-
Department of Justice
Pass-Through Program From Iowa Department of Justice
Crime Victim Assistance	16.575	VP-23-125-VWC	33,620	-
Crime Victim Assistance	16.575	VP-22-125-VWC	373	-
Total Crime Victim Assistance			33,993	-
Violence Against Women Formula Grants	16.588	VW-23-52-PR	35,367	-
Direct Program
Bulletproof Vest Partnership Program	16.607		4,577	-
Pass-Through Program From Governor's Office of Drug Control Policy
Public Safety Partnership and Community Policing Grants	16.710	22-COPS HEROIN-02	13,376	5,430
Public Safety Partnership and Community Policing Grants	16.710	21-CAMP-04	3,791	2,178
Public Safety Partnership and Community Policing Grants	16.710	19-COPS HEROIN-02	3,528	876
Total Public Safety Partnership and Community Policing Grants			20,695	8,484
Edward Byrne Memorial Justice Assistance Grant Program	16.738	20-JAG-444697	66,465	33,232
Direct Program
Equitable Sharing Program	16.922		15,000	-
Total Department of Justice			176,097	41,716

===== PAGE 84 =====

Federal Grantor/Pass-Through Grantor/Program or Cluster Title	Federal Financial Assistance Listing	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	23-402-MOPT, Task 25-00-00	$ 12,936	$-
State and Community Highway Safety	20.600	22-402-MOPT, Task 24-00-00	8,117	-
Total State and Community Highway Safety			21,053	-
National Priority Safety Programs	20.616	22-405d-F24*SE, Task 01-00-00	2,166	-
National Priority Safety Programs	20.616	23-405d-M6OT 00-25-00	3,560	-
Total National Priority Safety Programs			5,726	-
Total Highway Safety Cluster			26,779	-
Direct Program
National Infrastructure Investments	20.933		489,873	-
Total Department of Transportation			516,652	-
Department of Treasury
Direct Program
COVID-19 - Coronavirus State and Local Fiscal Recovery Funds	21.027		12,576,613	1,706,990
Environmental Protection Agency
Pass-Through Program From Iowa Department of Natural Resources
Nonpoint Source Implementation Grants	66.460	23ESDWQBMAES	10,000	-
Election Assistance Commission
Pass-Through Program From Iowa Election Assistance Commission
COVID-19 - HAVA Election Security Grants	90.404	331-7122-HAVA	1,000	-

===== PAGE 85 =====

Federal Grantor/Pass-Through Grantor/Program or Cluster Title	Federal Financial Assistance Listing	Pass-Through Entity Identifying Number	Federal Expenditures	Amounts Passed-Through to Subrecipients
Department of Health and Human Services Pass-Through Program From Buchanan County
Public Health Emergency Preparedness	93.069	5881BT01	$ 24,843	$ -
Iowa Department of Public Health COVID-19 - Epidemiology and Laboratory Capacity for Infectious Diseases	93.323	5885BT431 #12	302,566	-
COVID-19 - Epidemiology and Laboratory Capacity for Infectious Diseases	93.323	5885BT431 #14	13,070	-
COVID-19 - Epidemiology and Laboratory Capacity for Infectious Diseases	93.323	5885BT431 #13	6,908	-
Total Epidemiology and Laboratory Capacity for Infectious Diseases			322,544	-
COVID-19 - Immunization Cooperative Agreements	93.268	5885BT431 #8	65,877	55,877
COVID-19 - Immunization Cooperative Agreements	93.268	5885BT431 #17	19,331	19,331
Immunization Cooperative Agreements	93.268	5883I429	18,895	18,895
Total Immunization Cooperative Agreements			104,103	94,103
Well-Integrated Screening and Evaluation for Women Across the Nation	93.436	5883NB11WW	7,000	7,000
Well-Integrated Screening and Evaluation for Women Across the Nation	93.436	5882NB11WWE	1,075	1,075
Total Well-Integrated Screening and Evaluation for Women Across the Nation			8,075	8,075

===== PAGE 86 =====

Federal Grantor/Pass-Through Grantor/Program or Cluster Title	Federal Financial Assistance Listing	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 Title IV-E Prevention Program	93.472	N/A	$ 1,519	$ -
Direct Program COVID-19 - Provider Relief Fund and American Rescue Plan Rural Distribution	93.498		95,836	-
Pass-Through Program From Iowa Department of Human Services Child Support Enforcement Human Services Administrative Reimbursement	93.563	BOC 19-005	149,955	-
Refugee and Entrant Assistance - State-Administered Programs CCDF Cluster Child Care Mandatory and Matching Funds of the Child Care and Development Fund	93.566	N/A	139	-
Foster Care - Title IV-E	93.596	N/A	11,675	-
Adoption Assistance - Title IV-E	93.658	N/A	10,709	-
Social Services Block Grant	93.659	N/A	5,978	-
Children's Health Insurance Program	93.667	N/A	13,510	-
Medicaid Cluster Medical Assistance Program	93.767	N/A	890	-
Iowa Department of Public Health Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations	93.778	N/A	58,830	-
Total Department of Health and Human Services		5883NB11	23,104	23,104
			831,710	125,282
Department of Homeland Security Pass-Through Program From Iowa Department of Homeland Security and Emergency Management COVID-19 - Disaster Grants-Public Assistance	93.898
	97.036	4018-DR-IA	233,459	-

Total Federal Financial Assistance ===== PAGE 87 ===== ## 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, 2023. 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 position or fund balance, or cash flows 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 for 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 88 ===== 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	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 (included in 2023 Schedule)	93.498	-	-	95,836
Total Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution		$ 129,642	$ 512,241	$ 95,836

===== PAGE 89 ===== ## 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\nNone Reported
Noncompliance material to financial statements noted?	No
Federal Awards
Internal control over major program:\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 program:	Qualified
Any audit findings disclosed that are required to be reported in accordance with Uniform Guidance 2 CFR 200.516(a):	Yes
Identification of major program:
Name of Federal Program	Federal Financial Assistance Listing
COVID-19 - Coronavirus State and Local Fiscal Recovery Funds	21.027
Dollar threshold used to distinguish between type A and type B programs:	$ 750,000
Audited by qualified as low risk auditor?	No

Auditee qualified as low-risk auditee? No ===== PAGE 90 ===== ## Part II: Financial Statement Findings: There were no findings to report. Part III: Federal Award Findings and Questioned Costs: ## 2023 -001 Department of the Treasury FFAL #21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Applicable Federal Award Number and Year – SLFRP0515 for 2021 ## Reporting 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. Condition: The County’s quarterly Project and Expenditure Reports were not reviewed and approved by a separate individual outside of the preparer. The reports submitted in fiscal year 2023 did not contain obligation and expenditure information for $10,000,000 in revenue replacement expenditures allocated to fiscal year 2023 eligible employee wages. Cause: The County did not have an internal control process in place to ensure a secondary review and approval of the Project and Expenditure Reports. Effect: Without a secondary review and approval, there is a greater possibility that the reports may not be accurately completed. Questioned Costs: None reported. Context: A nonstatistical sample of two out of the four quarterly Project and Expenditure Reports 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 the Project and Expenditure Reports. Views of Responsible Officials: Moving forward, the Finance Director will review and approve the reports prior to being submitted. ===== PAGE 91 ===== ## Part IV: Other Findings Related to Required Statutory Reporting: 2023-IA-A Certified Budget – Disbursements during the year ended June 30, 2023 did not exceed the amount budgeted by function. However, during the year ended June 30, 2023, 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. 2023-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. 2023-IA-C Travel Expense – No expenditures of County money for travel expenses of spouses of County officials and/or employees were noted. 2023-IA-D Business Transactions – Business transactions between the County and County officials and/or employees are detailed as follows:

Name, Title, and Business Connection	Transaction Description	Amount
Mary Lammers, periodic elections employee, children own White Front Feed and Seed	Services	$ 30,911
Janelle Duwe, Deputy Treasurer, son owns JDs Groundskeeping	Services	14,625

According to Chapter 331.342 of the Code of Iowa, an officer or employee of a County shall not have an interest, direct or indirect, in a contract with that County. The provision does not apply to transactions that do not exceed a cumulative total purchase price of $6,000 in a fiscal year or to contracts made by a County upon competitive bid. The transactions involving Mary Lammers and Janelle Duwe were not entered into through competitive bidding. 2023-IA-E Restricted Donor Activity – No transactions were noted between the County, County officials, County employees and restricted donors in compliance with Chapter 68B of the Code of Iowa. ===== PAGE 92 ===== ## Part IV: Other Findings Related to Required Statutory Reporting: (continued) 2023-IA-F Bond Coverage – Surety bond coverage of County officials and employees is in accordance with statutory provisions. The amount of coverage should be reviewed annually to ensure that the coverage is adequate for current operations. 2023-IA-G Board Minutes – No transactions were found that we believe should have been approved in the Board minutes but were not. 2023-IA-H Deposits and Investments – No instances of noncompliance with the deposit and investment provisions of Chapters 12B and 12C of the Code of Iowa and the County's investment policy were noted. 2023-IA-I Resource Enhancement and Protection Certification – The County properly dedicated property tax revenue to conservation purposes as required by Chapter 455A.19(1)(b) of the Code of Iowa in order to receive the additional REAP funds allocated in accordance with subsections (b)(2) and (b)(3). 2023-IA-J Annual Urban Renewal Report – The annual urban renewal report was properly approved and certified to the Iowa Department of Management on or before December 1. 2023-IA-K Tax Increment Financing – The Special Revenue Tax Increment Financing (TIF) Fund properly disbursed payments for TIF loans and rebates. Also, the County properly completed the Tax Increment Debt Certificate forms to request TIF property taxes.