Loading...
VII.1. 2023 Audit and Annual Comprehensive Financial Report CITY OF HOPKINS Memorandum To: Honorable Mayor and Council Members Mike Mornson, City Manager From: Nick Bishop, Finance Director Date: June 11, 2024 Subject: 2023 Audit and Annual Comprehensive Financial Report _____________________________________________________________________ PURPOSE Informational. INFORMATION Abdo has completed the City’s Audit for the year ended December 31, 2023. The Auditor’s Report is dated June 3, 2024. Justin Nilson, Partner will present their results. The Executive Governance Summary and Other Required Reports are attached. Due to its size the Annual Comprehensive Report is not included in the packet. It is available on the City’s online document archives: https://lf.hopkinsmn.com/WebLink/DocView.aspx?id=483707&dbid=1&repo=Hopkins FUTURE ACTION None Finance Department Executive Governance Summary City of Hopkins Hopkins, Minnesota For the year ended December 31, 2023 June 3, 2024 Management, Honorable Mayor and City Council City of Hopkins, Minnesota We have audited the financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the City of Hopkins, Minnesota (the City), for the year ended December 31, 2023. Professional standards require that we provide you with information about our responsibilities under generally accepted auditing standards, Government Auditing Standards, as well as certain information related to the planned scope and timing of our audit. We have communicated such information in our letter to you dated December 18, 2023. Professional standards also require that we communicate to you the following information related to our audit. Significant Audit Findings In planning and performing our audit of the financial statements, we considered the City'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 City’s internal control. Accordingly, we do not express an opinion on the effectiveness of the City’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 and therefore, material weaknesses or significant deficiencies may exist that were not identified. Given these limitations, during our audit we did not identify any deficiencies in internal control that we consider to be material weaknesses or significant deficiencies. 2 Compliance and Other Matters As part of obtaining reasonable assurance about whether the City'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. Also, in accordance with the Uniform Guidance, we examined, on a test basis, evidence about the City’s compliance with the types of compliance requirements described in the “U.S. Office of Management and Budget (OMB) Compliance Supplement” applicable to each of its major Federal programs for the purpose of expressing an opinion on the City’s compliance with those requirements and for compliance with federal statutes, regulations, and the terms and conditions of its federal awards applicable to its federal programs. While our audit provides a reasonable basis for our opinion, it does not provide a legal determination on the City’s compliance with those requirements. The results of our tests disclosed one instance of noncompliance or other matters that is required to be reported under Governmental Auditing Standards or Minnesota statutes described below as finding 2023-001. 2023-001 Uniform Guidance Policy Condition: During our audit, we discovered the City did not develop written procedures as required by the Uniform Guidance for Cash Management of Federal Funds - §200.302(b)(6). Criteria: The City “must” establish and maintain effective internal control over Federal awards that provides reasonable assurance that the City is managing Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal awards. Cause: The City did not have these written policies and procedures in place sufficient to comply with the Uniform Guidance requirements. Effect: The City was out of compliance with this requirement. Recommendation: The City should implement written policies and procedures to adhere to the above mentioned Uniform Guidance requirements. Management response: The City will establish written policies and procedures to ensure future compliance with the Uniform Guidance requirements. 3 Qualitative Aspects of Accounting Practices Management is responsible for the selection and use of appropriate accounting policies. The significant accounting policies used by the City are described in Note 1 to the financial statements. No new accounting policies were adopted and the application of existing policies were not changed during the year ended December 31, 2023 . We noted no transactions entered into by the City during the year for which there is a lack of authoritative guidance or consensus. All significant transactions have been recognized in the financial statements in the proper period. Accounting estimates are an integral part of the financial statements prepared by management and are based on management’s knowledge and experience about past and current events and assumptions about future events. Certain accounting estimates are particularly sensitive because of their significance to the financial statements and because of the possibility that future events affecting them may differ significantly from those expected . The most sensitive estimates affecting the financial statements are included below: •Management’s estimate of depreciation is based on estimated useful lives of the assets. Depreciation is calculated using the straight-line method. •Allocations of gross wages and payroll benefits are approved by City Council within the City’s budget and are derived from each employee’s estimated time to be spent servicing the respective functions of the City. These allocations are also used in allocating accrued compensated absences payable. •The City’s liability for other post-employment benefits was estimated to be zero primarily based on the assumption that employees, whom participate in the health insurance plan, will retire after the age of 65 and not continue to participate in the plan following retirement. •Management’s estimate of its pension liability is based on several factors including, but not limited to, anticipated investment return rate, retirement age for active employees, life expectancy, salary increases and form of annuity payment upon retirement. •Management’s estimate of its lease receivable is based on the present value of future lease payments expected to be received during the lease term. We evaluated the key factors and assumptions used to develop these accounting estimates in determining that it is reasonable in relation to the financial statements taken as a whole. The disclosures in the financial statements are neutral, consistent, and clear. Certain financial statement disclosures are particularly sensitive because of their significance to financial statement users. 4 Difficulties Encountered in Performing the Audit We encountered no significant difficulties in dealing with management in performing and completing our audit. Corrected and Uncorrected Misstatements Professional standards require us to accumulate all known and likely misstatements identified during the audit, other than those that are trivial, and communicate them to the appropriate level of management. Management has corrected all such misstatements. In addition, none of the misstatements detected as a result of audit procedures and corrected by management were material, either individually or in the aggregate, to each opinion unit’s financial statements taken as a whole. Disagreements with Management For purposes of this letter, professional standards define a disagreement with management as a financial accounting, reporting, or auditing matter, whether or not resolved to our satisfaction, that could be significant to the financial statements or the auditor’s report. We are pleased to report that no such disagreements arose during the course of our audit. Management Representations We have requested certain representations from management that are included in the management representation letter dated June 3, 2024. Management Consultations with Other Independent Accountants In some cases, management may decide to consult with other accountants about auditing and accounting matters, similar to obtaining a “second opinion” on certain situations. If a consultation involves application of an accounting principle to the governmental unit’s financial statements or a determination of the type of auditor’s opinion that may be expressed on those statements, our professional standards require the consulting accountant to check with us to determine that the consultant has all the relevant facts. To our knowledge, there were no such consultations with other accountants. Other Audit Findings or Issues We generally discuss a variety of matters, including the application of accounting principles and auditing standards, with management each year prior to retention as the City’s auditors. However, these discussions occurred in the normal course of our professional relationship and our responses were not a condition to our retention. 5 Other Matters We applied certain limited procedures to the required supplementary information (RSI) (Management’s Discussion and Analysis, the Schedules of Employer’s Share of the Net Pension Liability, the Schedules of Employer’s Contributions, the Schedule of Changes in Net Pension Liability (Asset) and Related Ratios ), and the Schedules of Employer’s Contributions, and the Schedule of changes in the City's OPEB Liability), which is information that supplements the basic financial statements. Our procedures consisted of inquiries of management regarding 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 did not audit the RSI and do not express an opinion or provide any assurance on the RSI. We were engaged to report on the supplementary information (Combining and Individual Fund Financial Statements and Schedules), which accompany the financial statements but are not RSI. With respect to this supplementary information, we made certain inquiries of management and evaluated the form, content, and methods of preparing the information to determine that the information complies with accounting principles generally accepted in the United States of America, the method of preparing it has not changed from the prior period, and the information is appropriate and complete in relation to our audit of the financial statements. We compared and reconciled the supplementary information to the underlying accounting records used to prepare the financial statements or to the financial statements themselves. We were not engaged to report on the introductory section or statistical sections, which accompany the financial statements but are not RSI. We did not audit or perform other procedures on this other information and we do not express an opinion or provide any assurance on them. Future Accounting Standard Changes The following Governmental Accounting Standards Board (GASB) Statements have been issued and may have an impact on future City financial statements: (1) GASB Statement No. 100 - Accounting Changes and Error Corrections Effective: 12/31/2024 GASB Statement No. 101 - Compensated Absences Effective: 12/31/2024 GASB Statement No. 102 – Certain Risk Disclosures Effective: 12/31/2025 Further information on upcoming GASB pronouncements. * * * * Restriction on Use This purpose of this communication is solely for the information and use of the City Council and management of the City and is not intended to be, and should not be used by anyone other than those specified parties. Our audit would not necessarily disclose all weaknesses in the system because it was based on selected tests of the accounting records and related data. The comments and recommendations in the report are purely constructive in nature, and should be read in this context. If you have any questions or wish to discuss any of the items contained in this letter, please feel free to contact us at you r convenience. We wish to thank you for the continued opportunity to be of service and for the courtesy and cooperation extended to us by your staff. Abdo Minneapolis, Minnesota June 3, 2024 6 Other Required Reports City of Hopkins Hopkins, Minnesota For the year ended December 31, 2023 City of Hopkins, Minnesota Other Required Reports Table of Contents For the Year Ended December 31, 2023 Page No. Other Required Reports Independent Auditor’s Report on Minnesota Legal Compliance 3 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 4 Federal Financial Award Programs Independent Auditor’s Report on Compliance for Each Major Program and on Internal Control over Compliance Required by The Uniform Guidance 7 Schedule of Expenditures of Federal Awards 10 Notes to the Schedule of Expenditures of Federal Awards 11 Schedule of Findings, Questioned Costs, and Responses 12 Corrective Action Plan 14 Schedule of Prior Year Audit Findings 15 2 INDEPENDENT AUDITOR’S REPORT ON MINNESOTA LEGAL COMPLIANCE Honorable Mayor and City Council City of Hopkins, Minnesota 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 the financial statements of the governmental activities, the business-type activities, each major fund and the aggregate remaining fund information of the City of Hopkins, Minnesota (the City), as of and for the year ended December 31, 2023, and the related notes to the financial statements, and have issued our report thereon dated June 3, 2024. In connection with our audit, nothing came to our attention that caused us to believe that the City of Hopkins failed to comply with the provisions of the contracting and bidding, deposits and investments, conflicts of interest, public indebtedness, claims and disbursements, miscellaneous provisions, and tax increment financing sections of the Minnesota Legal Compliance Audit Guide for Cities , promulgated by the State Auditor pursuant to Minn. Stat. § 6.65 , insofar as they relate to accounting matters. However, our audit was not directed primarily toward obtaining knowledge of such noncompliance. Accordingly, had we performed additional procedures, other matters may have come to our attention regarding the City’s noncompliance with the above referenced provisions, insofar as they relate to accounting matters. The purpose of this report is solely to describe the scope of our testing of compliance and the results of that testing, and not to provide an opinion on compliance. Accordingly, this communication is not suitable for any other purpose. Abdo Minneapolis, Minnesota June 3, 2024 3 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 Honorable Mayor and City Council City of Hopkins, Minnesota We have audited, in accordance with the 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, the financial statements of the governmental activities, the business-type activities, each major fund and the aggregate remaining fund information of the City of Hopkins, Minnesota (the City), as of and for the year ended December 31, 2023, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements, and have issued our report thereon dated June 3, 2024. Report on Internal Control Over Financial Reporting In planning and performing our audit of the financial statements, we considered the City'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 City’s internal control. Accordingly, we do not express an opinion on the effectiveness of the City’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 may exist that have not been identified. Compliance and Other Matters As part of obtaining reasonable assurance about whether the City'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 one instance of noncompliance or other matters that is required to be reported under Government Auditing Standards as noted as finding 2023-001. 4 The City’s Responses to Findings The City’s responses to the findings identified in our audit are described in the accompanying Schedule of Findings, Questioned Costs, and Responses. The City’s responses were not subject to the auditing procedures applied in the audit of the financial statements, and accordingly, we express no opinion on them. 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 City’s internal control and compliance. Accordingly, this communication is not suitable for any other purpose. Abdo Minneapolis, Minnesota June 3, 2024 5 FEDERAL FINANCIAL AWARD PROGRAMS CITY OF HOPKINS HOPKINS, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2023 6 INDEPENDENT AUDITOR’S REPORT ON COMPLIANCE FOR EACH MAJOR PROGRAM AND ON INTERNAL CONTROL OVER COMPLIANCE REQUIRED BY THE UNIFORM GUIDANCE Honorable Mayor and City Council City of Hopkins, Minnesota Report on Compliance for Each Major Federal Program Opinion on Each Major Federal Program We have audited the City of Hopkins, Minnesota (the City) compliance with the types of compliance requirements described in the OMB Compliance Supplement that could have a direct and material effect on each of the City’s major federal programs for the year ended December 31, 2023. The City’s major federal programs are identified in the summary of auditor’s results section of the accompanying Schedule of F indings, Responses and Questioned Costs. In our opinion, the City complied, in all material respects, with the types of compliance requirements referred to above that could have a direct and material effect on each of its major federal programs for the year ended December 31, 2023. Basis for Opinion on Each Major Federal Program We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; 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 City 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 each major federal program. Our audit does not provide a legal determination of the City ’s compliance with the compliance requirements referred to above. 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 City’s federal programs. 7 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 City ’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 generally accepted auditing standards, 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 City’s compliance with the requirements of each major federal program as a whole. In performing an audit in accordance with generally accepted auditing standards, 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 City’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 City’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 City’s internal control over compliance. Accordingly, no such opinion is expressed. 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. Other Matters The results of our auditing procedures disclosed instances of noncompliance which are required to be reported in accordance with the Uniform Guidance and which are described in the accompanying schedule of findings and questioned costs as item 2023-001. Our opinion on each major federal program is not modified with respect to these matters. Government Auditing Standards requires the auditor to perform limited procedures on the City’s response to the noncompliance findings identified in our audit described in the accompanying schedule of findings and questioned costs. The City’s responses were not subjected to the other a uditing procedures applied in the audit of compliance and, accordingly, we express no opinion on the responses. Report on Internal Control Over Compliance 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. 8 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. Given these limitations, during our audit we did not identify any deficiencies in internal control over compliance that we consider to be material weaknesses, as defined above. However, material weaknesses or significant deficiencies in internal control over compliance may exist that were not identified. 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. Report on Schedule of Expenditures of Federal Awards Required by the Uniform Guidance We have audited the accompanying financial statements of the governmental activities, the business-type activities, each major fund and the aggregate remaining fund information of the City of Hopkins, Minnesota (the City), as of and for the year ended December 31, 2023, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements. We issued our report thereon dated June 3, 2024, which contained unmodified opinions on those financial statements. Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the basic financial statements. The accompanying schedule of expenditures of federal awards is presented for purposes of additional analysis as required by the Uniform Guidance and is 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 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 auditing standards generally accepted in the United States of America. In our opinion, the schedule of expenditures of federal awards is fairly stated in all material respects in relation to the basic financial statements as a whole. 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. Abdo Minneapolis, Minnesota June 3, 2024 9 City of Hopkins, Minnesota Schedule of Expenditures of Federal Awards For the Year Ended December 31, 2023 Funding Source Federal Domestic Assistance Number Program Expenditures Department of Homeland Security 97.083 $ 42,000 U.S. Department of Treasury 21.027C 622,226 Department of Housing and Urban Development Direct 14.870 69,267 Department of Housing and Urban Development Direct 14.850 174,070 Department of Housing and Urban Development 14.872 150,942 Total 1,058,505$ Direct Public Housing Capital Fund Public and Indian Housing Direct Staffing for Adequate Fire and Emergency Response (SAFER) Hopkins Public Schools COVID-19 Coronavirus State and Local Fiscal Recovery Funds Resident Opportunity and Supportive Services Administering Department Program Name/Number 10 City of Hopkins, Minnesota Notes to the Schedule of Expenditures of Federal Awards For the Year Ended December 31, 2023 Note 1: Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal awards programs of City of Hopkins, Minnesota (the City). The City's reporting entity is defined in Note 1A to the City's financial statements. The information in this schedule is prese nted 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). All federal awards received directly from Federal agencies as well as Federal awards passed through other government agencies are included on the schedule. Note 2: Summary of Significant Accounting Policies for Expenditures Expenditures reported on this schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles in OMB Circular A -122, Cost Principles for Non-Profit- Organizations, or the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Note 3: Pass-through Entity Identifying Numbers Pass-through entity identifying numbers are presented where available. Note 4: Subrecipients No federal expenditures presented in this schedule were provided to subrecipients. Note 5: Indirect Cost Rate During the year ended December 31, 2023, the City did not elect to use the 10 percent de Minimis indirect cost rate. 11 City of Hopkins, Minnesota Schedule of Findings, Questioned Costs, and Responses For the Year Ended December 31, 2023 City of Hopkins Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 Section I - Summary of Auditor's Results Financial Statements Type of auditor's report issued Unmodified Internal control over financial reporting Material weaknesses identified?No Significant deficiencies identified not considered to be material weaknesses?No Noncompliance material to financial statements noted?No Federal Awards Internal control over major programs Material weaknesses identified?No Significant deficiencies identified not considered to be material weaknesses?Yes Type of auditor's report issued on compliance for major programs Unmodified Any audit findings disclosed that are required to be reported in accordance with 2CFR section 200.516(a)?No Identification of Major Programs/Projects CFDA No. Coronavirus State and Local Fiscal Recovery Funds 21.027C Dollar threshold used to distinguish between Type A and Type B Programs 750,000$ Auditee qualified as low-risk auditee?No Section II - Financial Statement Findings Section III - Major Federal Award Findings and Questioned Costs A significant deficiency in internal control over major programs are reported in the Independent Auditor's Report on Compliance for Each Major Program and Report on Internal Control Over Compliance Required by the Uniform Guidance . Finding 2023-001 is reported as a significant deficiency. Section IV - Schedule of Prior Year Audit Findings There were prior year audit findings that are reported on the schedule of prior year audit findings. Other Issues None Corrective Action Plans are attached as required to be reported under the Federal Single Audit Act. 12 City of Hopkins, Minnesota Schedule of Findings, Questioned Costs, and Responses (continued) For the Year Ended December 31, 2023 2023-001 Uniform Guidance Policy Condition: During our audit, we discovered the City did not develop written procedures as required by the Uniform Guidance for Cash Management of Federal Funds - §200.302(b)(6). Criteria: The City “must” establish and maintain effective internal control over Federal awards that provides reasonable assurance that the City is managing Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal awards. Cause: The City did not have these written policies and procedures in place sufficient to comply with the Uniform Guidance requirements. Effect: The City was out of compliance with this requirement. Recommendation: The City should implement written policies and procedures to adhere to the above mentioned Uniform Guidance requirements. Management response: The City will establish written policies and procedures to ensure future compliance with the Uniform Guidance requirements. 13 CORRECTIVE ACTION PLAN The following is our response to findings in the audit as of December 31, 2023 FINDING 2023-001 - Uniform Guidance written policies and procedures During our audit, we discovered the City did not develop written procedures as required by the Uniform Guidance. Corrective Action Plan (CAP): 1. Explanation of Disagreement with Audit Finding: There is no disagreement with the audit finding. 2. Actions Planned in Response to Finding: The City Council will adopt written federal grant policies and procedures. 3. Official Responsible for Ensuring CAP: Nick Bishop, Finance Director, is the official responsible for ensuring corrective action. 3. Planned Completion Date for CAP: Fiscal year end 2024. 4. Plan to Monitor Completion of CAP: The City Council will be monitoring this corrective action plan. Sincerely, Nick Bishop City Finance Director 14 City of Hopkins, Minnesota Schedule of Prior Year Audit Findings For the Year Ended December 31, 2023 2022-001 Declaration for Payment Condition: Auditing for legal compliance requires a review of the City’s deposits and investments. Our audit indicated an instance of non-compliance that we believe needs to be remedied. Criteria: Minnesota statute 471.38 requires that each declaration for payment be signed to the effect that such account, claim, or demand is just and correct and that no part of it has been paid. The statute is satisfied if on the back of City checks is a declaration as defined in Minnesota statute 471.391 reading “I declare under the penalties of law that this account, claim, or demand is just and correct and that no part of it has been paid.” Cause: The City and more specifically, the Housing Authority did not have the required statement on the back of their checks during 2022. Effect: The City is out of compliance with this Minnesota statute. Recommendation: The City should apply the declaration noted above to all City checks in future years. Management Response: The City agrees with the finding and has added the declaration to all check stock, including those paid by the Housing Authority. Current Status This finding is not reported in the current year. 2022-002 Timely Transmittal of State Fire Aid Condition: During our audit, we noted that the City had not made timely deposits of State Fire aid to City Fire Relief Association. Criteria: Minnesota statute 477B.04 requires the City to transmit the fire aid payment to the treasurer of the Fire Relief Association within 30 days after receipt. Cause: The City did not remit the receipt of state fire aid in the timeframe noted above. Effect: The City is out of compliance with this Minnesota statute. Recommendation: We recommend that City review the statute and implement procedures to ensure the transmittal of fire state aid receipts in accordance with statute in future years. Management Response: The City agrees with the finding and recommendation and has implemented. Current Status This finding is not reported in the current year. 15 City of Hopkins, Minnesota Schedule of Prior Year Audit Findings For the Year Ended December 31, 2023 2022-003 Uniform Guidance written policies and procedures Condition: During our audit, we discovered the City did not develop written procedures as required by the Uniform Guidance for the following: • Determination of Allowable of Costs - §200.302(b)(7) • Time and Effort - §200.430(a) • Cash Management of Federal Funds - §200.302(b)(6) • Conflict of Interest - §200.318(c)(1-2) The City must also ensure that existing written procedures are in compliance with: • General Procurement Standards - §200.318-.326 • Equipment Management Requirements - §200.313 Criteria: The City “must” establish and maintain effective internal control over Federal awards that provides reasonable assurance that the City is managing Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal awards. Cause: The City did not have these written policies and procedures in place sufficient to comply with the Uniform Guidance requirements. Effect: The City was out of compliance with this requirement. Recommendation: The City should implement written policies and procedures to adhere to the above mentioned Uniform Guidance requirements. Management response: The City will establish written policies and procedures to ensure future compliance with the Uniform Guidance requirements. Current Status The City is establishing policies in fiscal year 2024 and finding is repeated for the year ended December 31, 2023. 16 City of Hopkins, Minnesota Schedule of Prior Year Audit Findings (Continued) For the Year Ended December 31, 2023 2022-004 Incomplete Schedule of Expenditures of Federal Awards Condition: In our recent audit, we identified that the Schedule of Expenditures of Federal Awards (SEFA) for the fiscal year ended 2022 was incomplete. Not all federal programs and expenditures were reported in the SEFA. Criteria: In compliance with Uniform Guidance 2 CFR 200.510(b), the auditee must prepare a SEFA that includes the total federal awards expended in the fiscal year. The SEFA must list individual federal programs by federal agency, along with respective direct and pass-through funding. Cause: The cause of the condition appears to be a lack of thorough review and reconciliation processes to verify the completeness and accuracy of the SEFA. This resulted in certain federal awards not being included in the schedule. Effect: The incomplete SEFA could lead to non-compliance with federal regulations and could potentially jeopardize future federal funding. It could also result in inaccurate reporting and decision-making. Recommendation: We recommend that management implement a more robust review and reconciliation process to ensure the completeness and accuracy of the SEFA. This should include, but not limited to, cross - checking the SEFA against the general ledger and grant files, and seeking confirmation from all departments that all federal awards have been reported. Management response: Management acknowledges the finding and will implement a more robust review process, which will include additional reconciliation procedures and inter-departmental communication to ensure all federal awards are reported accurately in the SEFA. We are committed to adhering to all federal regulations and ensuring the accuracy of our financial reporting. 17