City of Marietta

Finding Number: 2023-002 Assistance Listing Number and Title: Coronavirus State And Local Fiscal Recovery Funds AL # 21.027 Federal Award Identification Number / Year: 2022 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Noncompliance and Material Weakness 2 CFR § 1000.10 gives regulatory effect to Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, set forth at 2 CFR part 200 for the Department of Treasury. 2 CFR 200.328 (b) provides that The Federal agency or pass-through entity must collect financial reports no less than annually. The Federal agency or pass-through entity may not collect financial reports more frequently than quarterly unless a specific condition has been implemented in accordance with § 200.208. To the extent practicable, the Federal agency or pass-through entity should collect financial reports in coordination with performance reports. 31 CFR 35.4(c) requires recipients, in part, during the period of performance, to provide the Secretary of the U.S. Department of Treasury periodic reports providing detailed accounting of the uses of funds, modifications to a State or Territory's tax revenue sources, and such other information as the Secretary may require for the administration of this section. The U.S. Department of Treasury provided supplementary information on reporting requirements in its interim final rule for State and Local Fiscal Recovery Funds for 31 CFR Part 35 and provided further guidance in its Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guide. Metropolitan cities and counties with a population below 250,000 residents that are allocated less than $10 million in SLFRF funding, and NEUs that are allocated less than $10 million in SLFRF funding are required to submit Project and Expenditure Report by April 30, 2022, and then annually thereafter. The City submitted the required Project and Expenditure Report on April 26, 2023, which is within the required timeframe. However, due to the failure of existing controls, the expenditures reported did not agree to the accounting records with the Current Expenditures being overstated by $650,606. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports.

Finding Number: 2023-002 Planned Corrective Action: City Auditor has confirmed the ARPA 3/31/24 and 3/31/25 Project and Expenditure Reports submitted agree to City Accounting records. Anticipated Completion Date: July 3, 2025 Responsible Contact Person: City Auditor Sherri Hess

Finding Number: 2023-002 Assistance Listing Number and Title: Coronavirus State And Local Fiscal Recovery Funds AL # 21.027 Federal Award Identification Number / Year: 2022 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Noncompliance and Material Weakness 2 CFR § 1000.10 gives regulatory effect to Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, set forth at 2 CFR part 200 for the Department of Treasury. 2 CFR 200.328 (b) provides that The Federal agency or pass-through entity must collect financial reports no less than annually. The Federal agency or pass-through entity may not collect financial reports more frequently than quarterly unless a specific condition has been implemented in accordance with § 200.208. To the extent practicable, the Federal agency or pass-through entity should collect financial reports in coordination with performance reports. 31 CFR 35.4(c) requires recipients, in part, during the period of performance, to provide the Secretary of the U.S. Department of Treasury periodic reports providing detailed accounting of the uses of funds, modifications to a State or Territory's tax revenue sources, and such other information as the Secretary may require for the administration of this section. The U.S. Department of Treasury provided supplementary information on reporting requirements in its interim final rule for State and Local Fiscal Recovery Funds for 31 CFR Part 35 and provided further guidance in its Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guide. Metropolitan cities and counties with a population below 250,000 residents that are allocated less than $10 million in SLFRF funding, and NEUs that are allocated less than $10 million in SLFRF funding are required to submit Project and Expenditure Report by April 30, 2022, and then annually thereafter. The City submitted the required Project and Expenditure Report on April 26, 2023, which is within the required timeframe. However, due to the failure of existing controls, the expenditures reported did not agree to the accounting records with the Current Expenditures being overstated by $650,606. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports.

Finding Number: 2023-002 Planned Corrective Action: City Auditor has confirmed the ARPA 3/31/24 and 3/31/25 Project and Expenditure Reports submitted agree to City Accounting records. Anticipated Completion Date: July 3, 2025 Responsible Contact Person: City Auditor Sherri Hess

Finding Number: 2023-003 Assistance Listing Number and Title: Coronavirus State And Local Fiscal Recovery Funds AL # 21.027 Federal Award Identification Number: 2022ARCCB1134/ 2022-AR-LEP-937 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: Ohio Department of Public Safety Repeat Finding from Prior Audit? No Noncompliance and Material Weakness 2 CFR § 1000.10 gives regulatory effect to Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, set forth at 2 CFR part 200 for the Department of Treasury. 2 CFR 200.329 provides the recipient and subrecipient are responsible for the oversight of the Federal award. The recipient and subrecipient must monitor their activities under Federal awards to ensure they are compliant with all requirements and meeting performance expectations. Monitoring by the recipient and subrecipient must cover each program, function, or activity. The Office of Criminal Justice Service Standard Subgrant Conditions Handbook provides all OCJS projects are required to submit Quarterly Subgrant Reports. This report must show actual expenditures, describe progress towards achieving objectives, and include supporting documentation (such as purchase orders, vouchers, invoices, payroll allocation reports, payroll summaries, timesheets, etc.) for expenditures. The reports shall be submitted no later than the last day of the month following the calendar quarter end. A report must be submitted every quarter, even when there has been zero expenditure or when a payment is not being requested. • The City submitted the quarterly report for the quarter ending March 31, 2023 for the COVID-19: Coronavirus State And Local Fiscal Recovery Funds AL# 21.027 Marietta Municipal Court Diversion/Backlog Grant 2022ARCCB1134 after the required deadline. • The City submitted the quarterly report for the quarter ending March 31, 2023 for the COVID-19: Coronavirus State And Local Fiscal Recovery Funds AL# 21.027 Employee Retention Grant 2022-AR-LEP-937 after the required deadline. Further, the City did not submit a report for the quarter ended September 30, 2023. The failure to timely submit the required reports was due to insufficient controls and could result in action taken by the pass-through entity. The City should establish procedures to help ensure all required reports are submitted timely.

Finding Number: 2023-003 Planned Corrective Action: City Auditor will stay in contact with Municipal Court Administrator and the Police Captain to ensure they submit Quarterly Reports on a timely basis. Anticipated Completion Date: July 3, 2025 Responsible Contact Person: City Auditor Sherri Hess

Finding Number: 2023-003 Assistance Listing Number and Title: Coronavirus State And Local Fiscal Recovery Funds AL # 21.027 Federal Award Identification Number: 2022ARCCB1134/ 2022-AR-LEP-937 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: Ohio Department of Public Safety Repeat Finding from Prior Audit? No Noncompliance and Material Weakness 2 CFR § 1000.10 gives regulatory effect to Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, set forth at 2 CFR part 200 for the Department of Treasury. 2 CFR 200.329 provides the recipient and subrecipient are responsible for the oversight of the Federal award. The recipient and subrecipient must monitor their activities under Federal awards to ensure they are compliant with all requirements and meeting performance expectations. Monitoring by the recipient and subrecipient must cover each program, function, or activity. The Office of Criminal Justice Service Standard Subgrant Conditions Handbook provides all OCJS projects are required to submit Quarterly Subgrant Reports. This report must show actual expenditures, describe progress towards achieving objectives, and include supporting documentation (such as purchase orders, vouchers, invoices, payroll allocation reports, payroll summaries, timesheets, etc.) for expenditures. The reports shall be submitted no later than the last day of the month following the calendar quarter end. A report must be submitted every quarter, even when there has been zero expenditure or when a payment is not being requested. • The City submitted the quarterly report for the quarter ending March 31, 2023 for the COVID-19: Coronavirus State And Local Fiscal Recovery Funds AL# 21.027 Marietta Municipal Court Diversion/Backlog Grant 2022ARCCB1134 after the required deadline. • The City submitted the quarterly report for the quarter ending March 31, 2023 for the COVID-19: Coronavirus State And Local Fiscal Recovery Funds AL# 21.027 Employee Retention Grant 2022-AR-LEP-937 after the required deadline. Further, the City did not submit a report for the quarter ended September 30, 2023. The failure to timely submit the required reports was due to insufficient controls and could result in action taken by the pass-through entity. The City should establish procedures to help ensure all required reports are submitted timely.

Finding Number: 2023-003 Planned Corrective Action: City Auditor will stay in contact with Municipal Court Administrator and the Police Captain to ensure they submit Quarterly Reports on a timely basis. Anticipated Completion Date: July 3, 2025 Responsible Contact Person: City Auditor Sherri Hess