Finding 2024-001 Reporting – Internal Control and Compliance over Reporting (Significant Deficiency) Information on the Federal Program: Assistance Listing Number: 14.218 Federal Program Name: CDBG‐Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: N/A Federal Award Number and Award Year: B-20-MW-06-0053 – FY20-21 B-21-MC-06-0053 – FY21-22 B-22-MC-06-0053 – FY22-23 B-23-MC-06-0053 – FY23-24 Criteria: Code of Federal Regulations, Title 2 – Federal Financial Assistance, Subtitle A – Office of Management and Budget Guidance for Federal Financial Assistance, Chapter II – Office of Management and Budget Guidance, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Award Requirements: Performance and Financial Monitoring and Reporting Section § 200.328 Financial reporting. (a) The Federal agency must require only OMB-approved government-wide data elements on recipient financial reports. At the time of publication, this consists of the Federal Financial Report (SF-425); however, this also applies to any future OMB-approved government-wide data elements available from the OMB-designated standards lead. (b) 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. (c) The recipient or subrecipient must submit financial reports as required by the Federal award. Reports submitted annually by the recipient or subrecipient must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. (d) The final financial report submitted by the recipient must be due no later than 120 calendar days after the conclusion of the period of performance. A subrecipient must submit a final financial report to a pass-through entity no later than 90 calendar days after the conclusion of the period of performance. See also § 200.344. The Federal agency or pass-through entity may extend the due date for any financial report with justification from the recipient or subrecipient. Section § 200.303 Internal Controls The recipient and subrecipient must: (a) Establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should align with the guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control-Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). (b) Comply with the U.S. Constitution, Federal statutes, regulations, and the terms and conditions of the Federal award. Condition and Context: For the Community Development Block Grants/Entitlement Grants Cluster, the City did not submit the reports within the required deadline: Report Type Award Number Period Date Due Date Submitted SF-425 Financial Program-wide reporting 7/1/2023 - 9/30/2023 10/30/2023 1/16/2024 SF-425 Financial Program-wide reporting 1/1/2024 - 3/31/2024 3/30/2024 7/24/2024 Four (4) quarterly financial reports were tested, and two (2) reports were not submitted by the required deadline. Cause: During the audit period, the City did not possess the operational processes/procedures necessary to guarantee timely submission of the SF-425 report. Effect: Failure to submit the SF-425 reports timely results in noncompliance with the reporting requirements in the grant agreement. Questioned Costs: None noted. Identification as a Repeat Finding, If Applicable: No. Recommendation: We recommend that the City strengthen their report submission process and procedures to ensure all required reports are properly reviewed and approved and submitted timely. When a report cannot be submitted by the due date, the City should request an extension from the funding agency and maintain a record of the approval. Management’s View and Corrective Action Plan: The City agrees with this finding. The City has already taken steps to improve its processes/procedures to insure timely submission of all required SF-425 reports.
2024-003 – Cash Management Approval Federal Programs – Research and Development Cluster (Assistance Listing No. 98.001) Federal Agencies - U.S. Agency for International Development Federal Award Year – July 1, 2023 to June 30, 2024 Compliance Requirement – Cash Management Criteria Requirement: Non-federal entities must minimize the time elapsing between the transfer of funds from the US Treasury or pass-through entity and disbursement by the non-federal entity for direct program or project costs and the proportionate share of allowable indirect costs, whether the payment is made by electronic funds transfer, or issuance or redemption of checks, warrants, or payment by other means (2 CFR section 200.305(b)). The reimbursement payment method is the preferred payment method if (a) the non-federal entity cannot the meet the requirements in 2 CFR section 200.305(b)(1) for advance payment, (b) the federal awarding agency sets a specific condition for use of the reimbursement or (c) if requested by the non-federal entity (2 CFR sections 200.305(b)(3) and 200.208). The reimbursement payment method also may be used on a federal award for construction or for other construction activity as specified in 2 CFR section 200.305(b)(3). Condition Found: For two out of thirty-one samples, the institution did not maintain appropriate documentation to evidence the approval of the drawdown request. This resulted in an ineffective control over the review and approval of cash drawdowns. Cause and Possible Asserted Effect: The grants department had turnover in the current year, which resulted in inconsistent documentation of approvals. Therefore, the institution’s control to review and approve cash drawdowns did not operate consistently to ensure requests for reimbursement were properly approved and evidence of the review was maintained. Identification of Questioned Costs: There are no questioned costs associated with this finding. Sampling: The sample was not intended to be and was not a statistically valid sample. Identification of Repeat Finding: This finding is not a repeat of a finding in the immediately prior year Recommendation: Our recommendation is for management to reinforce and train those individuals in the compliance control ownership role to ensure controls are operating as designed in order to prevent, or detect and correct noncompliance on a timely basis. Specifically, strengthening its processes and documentation requirements around the review and approval of cash drawdown requests. This will help ensure that controls are functioning as intended, thereby preventing or promptly identifying and rectifying instances of noncompliance. Views of Responsible Officials: Management agrees with the findings and recommendations. Through the merger with Old Dominion University, additional controls have been adopted around the processes and controls around the accuracy of the review and approval of cash drawdown requests.
2024-003 – Cash Management Approval Federal Programs – Research and Development Cluster (Assistance Listing No. 98.001) Federal Agencies - U.S. Agency for International Development Federal Award Year – July 1, 2023 to June 30, 2024 Compliance Requirement – Cash Management Criteria Requirement: Non-federal entities must minimize the time elapsing between the transfer of funds from the US Treasury or pass-through entity and disbursement by the non-federal entity for direct program or project costs and the proportionate share of allowable indirect costs, whether the payment is made by electronic funds transfer, or issuance or redemption of checks, warrants, or payment by other means (2 CFR section 200.305(b)). The reimbursement payment method is the preferred payment method if (a) the non-federal entity cannot the meet the requirements in 2 CFR section 200.305(b)(1) for advance payment, (b) the federal awarding agency sets a specific condition for use of the reimbursement or (c) if requested by the non-federal entity (2 CFR sections 200.305(b)(3) and 200.208). The reimbursement payment method also may be used on a federal award for construction or for other construction activity as specified in 2 CFR section 200.305(b)(3). Condition Found: For two out of thirty-one samples, the institution did not maintain appropriate documentation to evidence the approval of the drawdown request. This resulted in an ineffective control over the review and approval of cash drawdowns. Cause and Possible Asserted Effect: The grants department had turnover in the current year, which resulted in inconsistent documentation of approvals. Therefore, the institution’s control to review and approve cash drawdowns did not operate consistently to ensure requests for reimbursement were properly approved and evidence of the review was maintained. Identification of Questioned Costs: There are no questioned costs associated with this finding. Sampling: The sample was not intended to be and was not a statistically valid sample. Identification of Repeat Finding: This finding is not a repeat of a finding in the immediately prior year Recommendation: Our recommendation is for management to reinforce and train those individuals in the compliance control ownership role to ensure controls are operating as designed in order to prevent, or detect and correct noncompliance on a timely basis. Specifically, strengthening its processes and documentation requirements around the review and approval of cash drawdown requests. This will help ensure that controls are functioning as intended, thereby preventing or promptly identifying and rectifying instances of noncompliance. Views of Responsible Officials: Management agrees with the findings and recommendations. Through the merger with Old Dominion University, additional controls have been adopted around the processes and controls around the accuracy of the review and approval of cash drawdown requests.
2024-003 – Cash Management Approval Federal Programs – Research and Development Cluster (Assistance Listing No. 98.001) Federal Agencies - U.S. Agency for International Development Federal Award Year – July 1, 2023 to June 30, 2024 Compliance Requirement – Cash Management Criteria Requirement: Non-federal entities must minimize the time elapsing between the transfer of funds from the US Treasury or pass-through entity and disbursement by the non-federal entity for direct program or project costs and the proportionate share of allowable indirect costs, whether the payment is made by electronic funds transfer, or issuance or redemption of checks, warrants, or payment by other means (2 CFR section 200.305(b)). The reimbursement payment method is the preferred payment method if (a) the non-federal entity cannot the meet the requirements in 2 CFR section 200.305(b)(1) for advance payment, (b) the federal awarding agency sets a specific condition for use of the reimbursement or (c) if requested by the non-federal entity (2 CFR sections 200.305(b)(3) and 200.208). The reimbursement payment method also may be used on a federal award for construction or for other construction activity as specified in 2 CFR section 200.305(b)(3). Condition Found: For two out of thirty-one samples, the institution did not maintain appropriate documentation to evidence the approval of the drawdown request. This resulted in an ineffective control over the review and approval of cash drawdowns. Cause and Possible Asserted Effect: The grants department had turnover in the current year, which resulted in inconsistent documentation of approvals. Therefore, the institution’s control to review and approve cash drawdowns did not operate consistently to ensure requests for reimbursement were properly approved and evidence of the review was maintained. Identification of Questioned Costs: There are no questioned costs associated with this finding. Sampling: The sample was not intended to be and was not a statistically valid sample. Identification of Repeat Finding: This finding is not a repeat of a finding in the immediately prior year Recommendation: Our recommendation is for management to reinforce and train those individuals in the compliance control ownership role to ensure controls are operating as designed in order to prevent, or detect and correct noncompliance on a timely basis. Specifically, strengthening its processes and documentation requirements around the review and approval of cash drawdown requests. This will help ensure that controls are functioning as intended, thereby preventing or promptly identifying and rectifying instances of noncompliance. Views of Responsible Officials: Management agrees with the findings and recommendations. Through the merger with Old Dominion University, additional controls have been adopted around the processes and controls around the accuracy of the review and approval of cash drawdown requests.
2024-017 The Housing Finance Commission did not have adequate internal controls over reporting requirements for the Homeowner Assistance Fund program. Assistance Listing Number and Title: 21.026 COVID-19 Homeowner Assistance Fund Federal Grantor Name: U.S. Department of the Treasury Federal Award/Contract Number: None Pass-through Entity Name: None Pass-through Award/Contract Number: None Applicable Compliance Component: Reporting Known Questioned Cost Amount: None Prior Year Audit Finding: Yes, Finding 2023-025 Background The American Rescue Plan Act of 2021 provided $9.96 billion to the Homeowner Assistance Fund (HAF) program. The U.S. Department of the Treasury provides funds directly to states, U.S. territories and Indian tribes to assist eligible homeowners experiencing financial hardship due to the COVID-19 pandemic. Program funds can be used to prevent mortgage delinquencies and defaults, foreclosures, loss of utilities or home energy services, and homeowner displacement. The law prioritizes funds for homeowners who have experienced hardships, leveraging local and national income indicators to maximize the program’s impact. The Housing Finance Commission administers the HAF program in Washington. In fiscal year 2024, the Commission spent about $70.8 million in HAF funds. The Commission implemented a pilot program before launching the main HAF program. The Commission contracted with a contractor to help implement the main HAF program and maintain participant data. The Commission is required to submit an annual performance report that provides an overview of its intended and actual uses of funding to-date for the pilot and main HAF programs. The federal grantor identified two key lines items on the report that contained critical information: 1. Socially Disadvantaged Individuals (SDIs) – Quantifiable Objective Criteria: Participants are providing not less than 60% of funds to homeowners with income less than 100% area median income (AMI) or 100% of U.S. median income. 2. AMI – Quantifiable Objective Criteria: Participants target homeowners that are classified as SDI and 100% AMI or less. The HAF Plan, approved by the federal grantor, outlines the budget allocations, goals and types of assistance for the Washington HAF program. The HAF reporting portal automatically populates each section of the annual report template with information from this plan. The Commission is required to submit a narrative on the status of each section. Commission staff use participant data provided by the contractor to complete the report template. Once completed, the preparer submits the report in the HAF reporting portal without management review. Federal regulations require recipients to establish and follow internal controls to ensure compliance with program requirements. These controls include understanding grant requirements and monitoring the effectiveness of established controls. In prior audits, we reported the Commission did not have adequate internal controls over and did not comply with reporting requirements. The prior finding number was 2023-025. Description of Condition The Commission did not have adequate internal controls over reporting requirements for the HAF program. The contractor only provided summary-level data to the Commission at the time of reporting. As a result, Commission staff did not have detailed supporting documentation to review to verify that the total amounts in the contractor’s reports were complete and accurate. Additionally, the Commission did not have documented evidence to support that management reviewed the annual report before submission. We consider these internal control deficiencies to be a material weakness. Cause of Condition The Commission did not require the contractor to submit detailed support for the total numbers provided for reporting to ensure all categories were included. Additionally, the Commission did not ensure adequate management review of the report before submission. Effect of Condition Without establishing adequate internal controls, which should include reviewing the reports and the detailed supporting documentation to ensure the correct data is reported, management cannot ensure that the reports are complete and accurate. Recommendations We recommend the Commission: • Establish effective internal controls to ensure the reports are accurate and complete • Ensure that management performs and documents an adequate review of the supporting documentation before submitting reports to the grantor Commission’s Response The Commission concurs with this finding. The Commission has implemented a system of controls and management review to ensure that data reported to the federal grantor is complete and accurate. The auditor’s recommendations came after the FY 23 Annual Report was filed and will be reflected in the upcoming FY24 Annual Report. The new process has been used in the quarterly reporting. Auditor’s Remarks We thank the Commission for its cooperation and assistance throughout the audit. We will review the status of the Commission's corrective action during our next audit. Applicable Laws and Regulations Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), section 303, Internal controls, describes the requirements for auditees to maintain internal controls over federal programs and comply with federal program requirements. Title 2 CFR Part 200, Uniform Guidance, section 328, Financial reporting, states: (a) The Federal agency must require only OMB-approved government-wide data elements on recipient financial reports. At the time of publication, this consists of the Federal Financial Report (SF-425); however, this also applies to any future OMB-approved government-wide data elements available from the OMB-designated standards lead. (b) 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. (c) The recipient or subrecipient must submit financial reports as required by the Federal award. Reports submitted annually by the recipient or subrecipient must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. (d) The final financial report submitted by the recipient must be due no later than 120 calendar days after the conclusion of the period of performance. A subrecipient must submit a final financial report to a pass-through entity no later than 90 calendar days after the conclusion of the period of performance. See also § 200.344. The Federal agency or pass-through entity may extend the due date for any financial report with justification from the recipient or subrecipient. Title 2 CFR Part 200, Uniform Guidance, section 516, Audit findings, establishes reporting requirements for audit findings. The American Institute of Certified Public Accountants defines significant deficiencies and material weaknesses in its Codification of Statements on Auditing Standards, section 935, Compliance Audits, paragraph 11. The U.S. Department of the Treasury’s Homeowner Assistance Fund: Guidance on Participant Compliance and Reporting Responsibilities, states, in part: Programmatic Information Requirements HAF participants are required to submit an Annual Performance Report on an annual basis and demonstrate the impact of the HAF-financed programs. Reports should include data related to program outputs and outcomes against the stated objectives of the HAF participant’s HAF Grant Plan. Performance Goals HAF participants initially submitted performance goals on the use of HAF awarded funds in their approved Grantee Plan. Each one of the performance goals should have identified how the HAF participant will address homeowner needs and should have been disaggregated by key characteristics such as mortgage type, racial and ethnic demographics, and/or geographic areas, as appropriate. HAF participants will be required to provide a status update and quantitative measures, if applicable, on each of their initial performance goals set forth in their Grantee Plan. Please note, HAF participants will not have the ability to alter their original performance goals noted in their Grantee Plan nor add additional performance goals in the Annual Report. Methods for Targeting and HAF Funding HAF participants were asked in their original Grantee Plan to describe how the HAF participant will effectively target HAF award funds to (1) homeowners with incomes equal to or less than 100% of the area median income or equal to or less than 100% of the median income for the United States, whichever is greater; and (2) socially disadvantaged individuals. The description included the HAF participant’s targeting strategies. HAF participants will be required to provide an update on their targeting methods and if they have appropriately executed targeting methods according to their original Grantee Plan.
FINDING 2024-007 Subject: Special Education Cluster (IDEA) - Cash Management Federal Agency: Department of Education Federal Programs: Special Education Grants to States, COVID-19 - Special Education Grants to States, Special Education Preschool Grants, COVID-19 - Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.027X, 84.173, 84.173X Federal Award Numbers and Years (or Other Identifying Numbers): 21611-045-PN01, 22611-045-PN01, 22611-045-ARP, 21619-045-PN01, 22619-045-PN01, 22619-045-ARP Pass-Through Entity: Indiana Department of Education Compliance Requirement: Cash Management Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-007. INDIANA STATE BOARD OF ACCOUNTS 29 NORTH LAWRENCE COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The system of internal controls over the applicable reports, as established by the School Corporation, was not properly implemented, nor was it operating effectively to ensure that sufficient audit evidence was maintained to support the requests for reimbursement. The School Corporation submitted six reimbursement requests to the Indiana Department of Education during the audit period. The School Corporation was unable to provide documentation to support the underlying data accumulated and summarized in each of the reimbursement requests. The reported data could not be traced to the records that accumulate or summarize the data; therefore, we were unable to verify the accuracy and completeness of the reimbursement requests. As a result, we were unable to verify that program funds were expended prior to requesting reimbursement. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.305(b)(3) states in part: "Reimbursement is the preferred method when the requirements in paragraph (b) cannot be met, when the Federal awarding agency sets a specific condition per § 200.208, or when the non-Federal entity requests payment by reimbursement. . . ." Cause Due to turnover of staffing in both the Special Education personnel and the School Corporation's administrative office, the School Corporation's management had not developed nor implemented a system of internal controls that would have ensured compliance, or that supporting documentation would have been maintained and made available for audit, as it related to the grant agreement and the Cash Management compliance requirement. INDIANA STATE BOARD OF ACCOUNTS 30 NORTH LAWRENCE COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without a proper system of internal controls in place that operated effectively, the School Corporation did not retain and provide appropriate supporting documentation to support the reimbursement requests. This prevented the determination of the School Corporation's compliance with the compliance requirements listed above. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish an effective system of internal controls to ensure documentation for the reimbursement requests will be maintained and made available for audit as related to the grant agreement and the Cash Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-008 Subject: Special Education Cluster (IDEA) - Earmarking and Level of Effort Federal Agency: Department of Education Federal Programs: Special Education Grants to States, COVID-19 - Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.027X, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 21611-045-PN01, 22611-045-PN01, 22611-045-ARP, 22619-045-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-008. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. INDIANA STATE BOARD OF ACCOUNTS 31 NORTH LAWRENCE COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Earmarking The nonpublic proportionate share of expenditures for the 21611-045-PN01, 22611-045-PN01, 22611-045-ARP, and 22619-045-PN01 grant awards could not be verified for proper classification and do not meet the proportionate share requirement. In addition, 22611-045-PN01, 22611-045-ARP, and 22619-045-PN01 could not be verified as having any nonpublic expenses. The funds associated with these grants were, in some cases, comingled and/or overspent with multiple grant years and not adjusted properly. These errors were not corrected during the audit period. The nonpublic proportionate share of expenditures was determined by applying a percentage to the nonpublic school budgeted expenditures. These were the amounts reported to the Indiana Department of Education (IDOE). As such, we were unable to identify if the minimum amount per grant award was expended and properly reported to the IDOE as required. Level of Effort - Maintenance of Effort Maintenance of effort is a district-level test that determines whether the School Corporation is providing a consistent level of financial support to public schools from year-to-year. This rule ensures that the School Corporation does not use Special Education funds to shore up reductions in state and local support for public education. The IDOE performs the maintenance of effort calculation utilizing Form 9 information provided by the School Corporation from the prior year. As such, the amounts submitted to the IDOE in the prior year to be used in the computation are tested to ensure they were recorded properly in the School Corporation's records as to the account and object code. In fiscal years 2021-2022 and 2022-2023, 60 transactions were tested each year to ensure the disbursements were posted to the proper account and object code. For 30 of the 60 transactions selected in 2021-2022, as well as 47 of the 60 transactions selected in 2022-2023, appropriate supporting documentation was not provided for audit. As a result, 77 disbursements could not be verified as to whether they were posted to the proper account or object code. In addition, 60 disbursement line items were sampled from the IDOE Form 9 for both 2021-2022 and 2022-2023, to ensure the amounts agreed to the ledger. A total of 21 of the 60 disbursement line items in 2021-2022 and 2 of the 60 disbursement line items in 2022-2023 could not be traced to the ledger. Therefore, we were unable to determine if the disbursements for 23 disbursement line items were posted to the proper account or object code. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 32 NORTH LAWRENCE COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: . . . (g) Be adequately documented. . . ." 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of the nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Cause Due to turnover of staffing in both the Special Education personnel and the School Corporation's administrative office and recordkeeping issues, the School Corporation's management had not developed a system of internal controls that would have ensured compliance, or that supporting documentation would have been maintained and made available for audit, as related to the Matching, Level of Effort, Earmarking compliance requirement. Effect Without the proper implementation of an effectively designed system of internal controls, the School Corporation cannot ensure compliance with the level of effort - maintenance of effort and earmarking requirements. As a result, amounts reported to the oversight agency were not accurately reported. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure nonpublic proportionate share funds are appropriately allocated to the individual school based on expenses charged directly on behalf of that school. Supporting documentation for these expenses should be retained for audit. In addition, proper recordkeeping should be maintained to ensure compliance with the level of effort - maintenance of effort and earmarking requirements. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-012 Subject: Title I Grants to Local Educational Agencies - Level of Effort - Maintenance of Effort, Earmarking Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A210014, S010A220014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-011. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with the grant agreement and the Matching, Level of Effort, Earmarking compliance requirement. Level of Effort - Maintenance of Effort Maintenance of effort is a district-level test that determines whether the School Corporation is providing a consistent level of financial support to public schools from year-to-year. This rule ensures that the School Corporation does not use Title I funds to shore up reductions in state and local support for public education. The Indiana Department of Education (IDOE) performs the maintenance of effort calculation utilizing Form 9 information provided by the School Corporation. As such, the amounts submitted to the IDOE to be used in the computation are tested to ensure they were recorded properly in the School Corporation's records as to the account and object code. INDIANA STATE BOARD OF ACCOUNTS 41 NORTH LAWRENCE COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) In fiscal years 2022-2023 and 2023-2024, 60 transactions were tested each year to ensure the disbursements were posted to the proper account and object code. For 10 of the 60 transactions selected in 2022-2023, as well as 11 of the 60 transactions selected in 2023-2024, appropriate supporting documentation was not provided for audit. As a result, 21 disbursements could not be verified as to whether they were posted to the proper account or object codes. In addition, 60 disbursement line items were sampled from the IDOE Form 9 for both 2022-2023 and 2023-2024 to ensure the amounts agreed to the ledger. A total of 2 of the 60 disbursement line items in 2022-2023 and 6 of the 60 disbursement line items in 2023-2024 could not be traced to the ledger. Therefore, we were unable to determine if the disbursements for 8 disbursement line items were posted to the proper account or object code. Earmarking The School Corporation did not expend the required minimum amount from grant S010A210014 for parent and family engagement. In addition, the Homelessness Reservation for grants S010A210014 and S010A220014 did not expend the required minimum amounts. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.400 states in part: "(a) The non-Federal entity is responsible for the efficient and effective administration of the Federal award through the application of sound management practices. (b) The non-Federal entity assumes responsibility for administering Federal funds in a manner consistent with underlying agreements, program objectives, and the terms and conditions of the Federal award. . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: . . . (g) Be adequately documented. . . ." 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." INDIANA STATE BOARD OF ACCOUNTS 42 NORTH LAWRENCE COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 20 USC 6313(c)3 states: "(A) In general A local educational agency shall reserve such funds as are necessary under this part, determined in accordance with subparagraphs (B) and (C), to provide services comparable to those provided to children in schools funded under this part to serve— (i) homeless children and youths, including providing educationally related support services to children in shelters and other locations where children may live; (ii) children in local institutions for neglected children; and (iii) if appropriate, children in local institutions for delinquent children, and neglected or delinquent children in community day programs. (B) Method of determination The share of funds determined under subparagraph (A) shall be determined— (i) based on the total allocation received by the local educational agency; and (ii) prior to any allowable expenditures or transfers by the local educational agency. (C) Homeless children and youths Funds reserved under subparagraph (A)(i) may be— (i) determined based on a needs assessment of homeless children and youths in the local educational agency, taking into consideration the number and needs of homeless children and youths in the local educational agency, and which needs assessment may be the same needs assessment as conducted under section 11433(b)(1) of title 42; and (ii) used to provide homeless children and youths with services not ordinarily provided to other students under this part, including providing— (I) funding for the liaison designated pursuant to section 11432(g)(1)(J)(ii) of title 42; and (II) transportation pursuant to section 11432(g)(1)(J)(iii) of such title." 34 CFR 200.77 states in part: "Before allocating funds in accordance with § 200.78, an LEA must reserve funds as are reasonable and necessary to— (a) Provide services comparable to those provided to children in participating school attendance areas and schools to serve— (1) INDIANA STATE BOARD OF ACCOUNTS 43 NORTH LAWRENCE COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (i) Homeless children and youths, including providing educationally related support services to children in shelters and other locations where homeless children may live. (ii) Funds reserved under paragraph (a)(1)(i) of this section may be— (A) Determined based on a needs assessment of homeless children and youths in the LEA, taking into consideration the number and needs of those children, which may be the same needs assessment as conducted under section 723(b)(1) of the McKinney-Vento Homeless Assistance Act; and (B) Used to provide homeless children and youths with services not ordinarily provided to other students under this subpart, including providing— (1) Funding for the liaison designated under section 722(g)(1)(J)(ii) of the McKinney-Vento Homeless Assistance Act; and (2) Transportation pursuant to section 722(g)(1)(J)(iii) of that Act; (2) Children in local institutions for neglected children; and (2) Children in local institutions for neglected children; and (3) If appropriate (i) Children in local institutions for delinquent children; and (ii) Neglected and delinquent children in community-day school programs; (4) An LEA must determine the amount of funds reserved under paragraphs (a)(1)(i) and (a)(2) and (3) of this section based on the total allocation received by the LEA under subpart 2 of part A of title I of the ESEA prior to any allowable expenditures or transfers by the LEA; . . ." Cause Due to turnover of staffing in the School Corporation's administrative office and recordkeeping issues, the School Corporation's management had not developed a system of internal controls that would have ensured compliance, or that supporting documentation would have been maintained and made available for audit, related to the Matching, Level of Effort, Earmarking compliance requirement. Effect Without the proper implementation of an effectively designed system of internal controls, the School Corporation cannot ensure compliance with level of effort - maintenance of effort and earmarking requirements. As a result, amounts reported to the oversight agency were not accurately reported. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 44 NORTH LAWRENCE COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that the School Corporation's management establish internal controls to ensure Homelessness Reservation and Parental set-aside expenditures are monitored throughout the period of performance to ensure earmarking compliance requirements are met before expiration of the grant. Supporting documentation for these expenditures should be maintained. In addition, proper recordkeeping should be maintained to ensure compliance and comply with the grant agreement and the Matching, Level of Effort, Earmarking compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding Number: 2023-007 Repeat Finding: Yes Type of Finding: Material Weakness in Internal Control and Material Noncompliance Description: Subrecipient Monitoring and Management Major Program: AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023- 01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Subrecipient Monitoring Condition: The Organization did not comply with any of the subrecipient monitoring and management requirements in accordance with 2 CFR Part 200.332. Criteria: The subrecipient monitoring and management requirements that are codified in 2 CFR Part 200.332 requires the pass-through entity must: a. Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes: 1. Federal award identification; 2. All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; 3. Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the Federal awarding agency including identification of any required financial and performance reports. 4. (i) An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the passthrough entity must determine the appropriate rate in collaboration with the subrecipient, which is either: 1. The negotiated indirect cost rate between the pass-through entity and the subrecipient; 2. The de minimis indirect cost rate (ii) The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a Federally approved rate. (iii) 5. A requirement that the subrecipient permit the pass-through entity and auditors to have access to the subrecipient’s records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and 6. Appropriate terms and conditions concerning closeout of the subaward. b. Evaluate each subrecipient’s risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. c. Consider imposing specific subaward conditions upon a subrecipient if appropriate as described in § 200.208. d. Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: 1. Reviewing financial and performance reports required by the pass-through entity. 2. Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. 3. Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. 4. The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving crosscutting findings. If a subrecipient has a current Single Audit report posted in the Federal Audit Clearinghouse and has not otherwise been excluded from receipt of Federal funding (e.g., has been debarred or suspended), the pass-through entity may rely on the subrecipient's cognizant audit agency or cognizant oversight agency to perform audit follow-up and make management decisions related to cross-cutting findings in accordance with section § 200.513(a)(3)(vii). Such reliance does not eliminate the responsibility of the passthrough entity to issue subawards that conform to agency and award-specific requirements, to manage risk through ongoing subaward monitoring, and to monitor the status of the findings that are specifically related to the subaward. e. Depending upon the pass-through entity's assessment of risk posed by the subrecipient, the following monitoring tools may be useful for the pass-through entity to ensure proper accountability and compliance with program requirements and achievement of performance goals: 1. Providing subrecipients with training and technical assistance on program-related matters; and 2. Performing on-site reviews of the subrecipient's program operations; 3. Arranging for agreed-upon-procedures engagements as described in § 200.425. f. Verify that every subrecipient is audited as required by Subpart F of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in § 200.501. g. Consider whether the results of the subrecipient's audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity's own records. h. Consider taking enforcement action against noncompliant subrecipients as described in § 200.339 of this part and in program regulations. Cause: The Organization’s management was not aware of the subrecipient monitoring and management requirements. Effect: The Organization was not in compliance with any of the subrecipient monitoring and management requirements, resulting in a material noncompliance and a material weakness in internal controls over compliance. Recommendation: We recommend the Organization implement systems and procedures to ensure compliance with the subrecipient monitoring and management compliance requirements. View of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2023-007 Repeat Finding: Yes Type of Finding: Material Weakness in Internal Control and Material Noncompliance Description: Subrecipient Monitoring and Management Major Program: AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023- 01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Subrecipient Monitoring Condition: The Organization did not comply with any of the subrecipient monitoring and management requirements in accordance with 2 CFR Part 200.332. Criteria: The subrecipient monitoring and management requirements that are codified in 2 CFR Part 200.332 requires the pass-through entity must: a. Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes: 1. Federal award identification; 2. All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; 3. Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the Federal awarding agency including identification of any required financial and performance reports. 4. (i) An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the passthrough entity must determine the appropriate rate in collaboration with the subrecipient, which is either: 1. The negotiated indirect cost rate between the pass-through entity and the subrecipient; 2. The de minimis indirect cost rate (ii) The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a Federally approved rate. (iii) 5. A requirement that the subrecipient permit the pass-through entity and auditors to have access to the subrecipient’s records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and 6. Appropriate terms and conditions concerning closeout of the subaward. b. Evaluate each subrecipient’s risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. c. Consider imposing specific subaward conditions upon a subrecipient if appropriate as described in § 200.208. d. Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: 1. Reviewing financial and performance reports required by the pass-through entity. 2. Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. 3. Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. 4. The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving crosscutting findings. If a subrecipient has a current Single Audit report posted in the Federal Audit Clearinghouse and has not otherwise been excluded from receipt of Federal funding (e.g., has been debarred or suspended), the pass-through entity may rely on the subrecipient's cognizant audit agency or cognizant oversight agency to perform audit follow-up and make management decisions related to cross-cutting findings in accordance with section § 200.513(a)(3)(vii). Such reliance does not eliminate the responsibility of the passthrough entity to issue subawards that conform to agency and award-specific requirements, to manage risk through ongoing subaward monitoring, and to monitor the status of the findings that are specifically related to the subaward. e. Depending upon the pass-through entity's assessment of risk posed by the subrecipient, the following monitoring tools may be useful for the pass-through entity to ensure proper accountability and compliance with program requirements and achievement of performance goals: 1. Providing subrecipients with training and technical assistance on program-related matters; and 2. Performing on-site reviews of the subrecipient's program operations; 3. Arranging for agreed-upon-procedures engagements as described in § 200.425. f. Verify that every subrecipient is audited as required by Subpart F of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in § 200.501. g. Consider whether the results of the subrecipient's audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity's own records. h. Consider taking enforcement action against noncompliant subrecipients as described in § 200.339 of this part and in program regulations. Cause: The Organization’s management was not aware of the subrecipient monitoring and management requirements. Effect: The Organization was not in compliance with any of the subrecipient monitoring and management requirements, resulting in a material noncompliance and a material weakness in internal controls over compliance. Recommendation: We recommend the Organization implement systems and procedures to ensure compliance with the subrecipient monitoring and management compliance requirements. View of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
2 CFR § 2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 C.F.R. § 200.328 which states, unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMB-approved governmentwide data elements for collection of financial information (at time of publication the Federal Financial Report or such future, OMB-approved, governmentwide data elements available from the OMB-designated standards lead. This information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes, and preferably in coordination with performance reporting. The Federal awarding agency must use OMB-approved common information collections, as applicable, when providing financial and performance reporting information. 2 CFR § 2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR § 200.208 which states, in part, that Federal awarding agencies are responsible for ensuring that specific Federal award conditions are consistent with the program design reflected in § 200.202 and include clear performance expectations of recipients as required in § 200.301. The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed, in accordance with this section, based on an analysis of specified factors. Additional Federal award conditions may be added provided the applicant or non-Federal entity has been notified, and any additional requirements must be promptly removed once the conditions that prompted them have been satisfied. Additional Federal award conditions may include items such as additional, more detailed financial reports. The State of Ohio Community Development Block Grant (CDBG) Program Grant Agreements for the Village of Lafayette Water Line Project (B-W-20-1AB-1), Village of Harrod Water Line Project (B-W-20-1AB-2), the Gomer Wastewater Collection System Project (B-W-20-1AB-3), Community Development Program B-F-20-1AB-1, Community Development Block Grant B-F-22-1AB-1 and (Community Housing Impact and Preservation Program) B-C-21-1AB-1, state that the grantee shall submit the required reports in an adequate and timely fashion. Granter shall provide a format for these reports and shall instruct Grantee on the proper completion of said reports. All report forms and requirements listed herein shall be provided by Granter, but shall not be construed to limit Granter in making additional and/or further requests, nor in the change or addition of detail to the items listed. The Grantee shall submit to Granter a Status Report within 30 days of the request by Granter. The County submitted Status Reports; however possibly due to the failure of an existing control(s), two out of eight (twenty-five percent) Status Reports were submitted between five to twelve months late. For one out of eight (twelve percent) Status Reports the reported expenditures were $4,386 more than the supporting accounting records (see related finding number 2023-002). Reporting errors could adversely affect future grant awards. An additional control(s) and/or procedure(s) should be implemented to help ensure required reports are accurately prepared and submitted in a timely manner.
1. Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Material Weakness and Noncompliance 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 County submitted the required Project and Expenditure Report on April 10, 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 due to $1,210,069 identified as loss of revenue being excluded from Project and Expenditure Report. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports. Officials’ Response: See Corrective Action Plan.
1. Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Material Weakness and Noncompliance 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 County submitted the required Project and Expenditure Report on April 10, 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 due to $1,210,069 identified as loss of revenue being excluded from Project and Expenditure Report. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports. Officials’ Response: See Corrective Action Plan.
1. Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Material Weakness and Noncompliance 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 County submitted the required Project and Expenditure Report on April 10, 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 due to $1,210,069 identified as loss of revenue being excluded from Project and Expenditure Report. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports. Officials’ Response: See Corrective Action Plan.
1. Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Material Weakness and Noncompliance 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 County submitted the required Project and Expenditure Report on April 10, 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 due to $1,210,069 identified as loss of revenue being excluded from Project and Expenditure Report. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports. Officials’ Response: See Corrective Action Plan.
1. Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Material Weakness and Noncompliance 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 County submitted the required Project and Expenditure Report on April 10, 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 due to $1,210,069 identified as loss of revenue being excluded from Project and Expenditure Report. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports. Officials’ Response: See Corrective Action Plan.
1. Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Material Weakness and Noncompliance 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 County submitted the required Project and Expenditure Report on April 10, 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 due to $1,210,069 identified as loss of revenue being excluded from Project and Expenditure Report. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports. Officials’ Response: See Corrective Action Plan.
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 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 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 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 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-007 Repeat Finding: Yes Type of Finding: Material Weakness in Internal Control and Material Noncompliance Description: Subrecipient Monitoring and Management Major Program: AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023- 01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Subrecipient Monitoring Condition: The Organization did not comply with any of the subrecipient monitoring and management requirements in accordance with 2 CFR Part 200.332. Criteria: The subrecipient monitoring and management requirements that are codified in 2 CFR Part 200.332 requires the pass-through entity must: a. Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes: 1. Federal award identification; 2. All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; 3. Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the Federal awarding agency including identification of any required financial and performance reports. 4. (i) An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the passthrough entity must determine the appropriate rate in collaboration with the subrecipient, which is either: 1. The negotiated indirect cost rate between the pass-through entity and the subrecipient; 2. The de minimis indirect cost rate (ii) The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a Federally approved rate. (iii) 5. A requirement that the subrecipient permit the pass-through entity and auditors to have access to the subrecipient’s records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and 6. Appropriate terms and conditions concerning closeout of the subaward. b. Evaluate each subrecipient’s risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. c. Consider imposing specific subaward conditions upon a subrecipient if appropriate as described in § 200.208. d. Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: 1. Reviewing financial and performance reports required by the pass-through entity. 2. Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. 3. Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. 4. The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving crosscutting findings. If a subrecipient has a current Single Audit report posted in the Federal Audit Clearinghouse and has not otherwise been excluded from receipt of Federal funding (e.g., has been debarred or suspended), the pass-through entity may rely on the subrecipient's cognizant audit agency or cognizant oversight agency to perform audit follow-up and make management decisions related to cross-cutting findings in accordance with section § 200.513(a)(3)(vii). Such reliance does not eliminate the responsibility of the passthrough entity to issue subawards that conform to agency and award-specific requirements, to manage risk through ongoing subaward monitoring, and to monitor the status of the findings that are specifically related to the subaward. e. Depending upon the pass-through entity's assessment of risk posed by the subrecipient, the following monitoring tools may be useful for the pass-through entity to ensure proper accountability and compliance with program requirements and achievement of performance goals: 1. Providing subrecipients with training and technical assistance on program-related matters; and 2. Performing on-site reviews of the subrecipient's program operations; 3. Arranging for agreed-upon-procedures engagements as described in § 200.425. f. Verify that every subrecipient is audited as required by Subpart F of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in § 200.501. g. Consider whether the results of the subrecipient's audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity's own records. h. Consider taking enforcement action against noncompliant subrecipients as described in § 200.339 of this part and in program regulations. Cause: The Organization’s management was not aware of the subrecipient monitoring and management requirements. Effect: The Organization was not in compliance with any of the subrecipient monitoring and management requirements, resulting in a material noncompliance and a material weakness in internal controls over compliance. Recommendation: We recommend the Organization implement systems and procedures to ensure compliance with the subrecipient monitoring and management compliance requirements. View of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2023-007 Repeat Finding: Yes Type of Finding: Material Weakness in Internal Control and Material Noncompliance Description: Subrecipient Monitoring and Management Major Program: AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023- 01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Subrecipient Monitoring Condition: The Organization did not comply with any of the subrecipient monitoring and management requirements in accordance with 2 CFR Part 200.332. Criteria: The subrecipient monitoring and management requirements that are codified in 2 CFR Part 200.332 requires the pass-through entity must: a. Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes: 1. Federal award identification; 2. All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; 3. Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the Federal awarding agency including identification of any required financial and performance reports. 4. (i) An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the passthrough entity must determine the appropriate rate in collaboration with the subrecipient, which is either: 1. The negotiated indirect cost rate between the pass-through entity and the subrecipient; 2. The de minimis indirect cost rate (ii) The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a Federally approved rate. (iii) 5. A requirement that the subrecipient permit the pass-through entity and auditors to have access to the subrecipient’s records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and 6. Appropriate terms and conditions concerning closeout of the subaward. b. Evaluate each subrecipient’s risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. c. Consider imposing specific subaward conditions upon a subrecipient if appropriate as described in § 200.208. d. Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: 1. Reviewing financial and performance reports required by the pass-through entity. 2. Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. 3. Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. 4. The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving crosscutting findings. If a subrecipient has a current Single Audit report posted in the Federal Audit Clearinghouse and has not otherwise been excluded from receipt of Federal funding (e.g., has been debarred or suspended), the pass-through entity may rely on the subrecipient's cognizant audit agency or cognizant oversight agency to perform audit follow-up and make management decisions related to cross-cutting findings in accordance with section § 200.513(a)(3)(vii). Such reliance does not eliminate the responsibility of the passthrough entity to issue subawards that conform to agency and award-specific requirements, to manage risk through ongoing subaward monitoring, and to monitor the status of the findings that are specifically related to the subaward. e. Depending upon the pass-through entity's assessment of risk posed by the subrecipient, the following monitoring tools may be useful for the pass-through entity to ensure proper accountability and compliance with program requirements and achievement of performance goals: 1. Providing subrecipients with training and technical assistance on program-related matters; and 2. Performing on-site reviews of the subrecipient's program operations; 3. Arranging for agreed-upon-procedures engagements as described in § 200.425. f. Verify that every subrecipient is audited as required by Subpart F of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in § 200.501. g. Consider whether the results of the subrecipient's audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity's own records. h. Consider taking enforcement action against noncompliant subrecipients as described in § 200.339 of this part and in program regulations. Cause: The Organization’s management was not aware of the subrecipient monitoring and management requirements. Effect: The Organization was not in compliance with any of the subrecipient monitoring and management requirements, resulting in a material noncompliance and a material weakness in internal controls over compliance. Recommendation: We recommend the Organization implement systems and procedures to ensure compliance with the subrecipient monitoring and management compliance requirements. View of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
2 CFR § 2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 C.F.R. § 200.328 which states, unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMB-approved governmentwide data elements for collection of financial information (at time of publication the Federal Financial Report or such future, OMB-approved, governmentwide data elements available from the OMB-designated standards lead. This information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes, and preferably in coordination with performance reporting. The Federal awarding agency must use OMB-approved common information collections, as applicable, when providing financial and performance reporting information. 2 CFR § 2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR § 200.208 which states, in part, that Federal awarding agencies are responsible for ensuring that specific Federal award conditions are consistent with the program design reflected in § 200.202 and include clear performance expectations of recipients as required in § 200.301. The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed, in accordance with this section, based on an analysis of specified factors. Additional Federal award conditions may be added provided the applicant or non-Federal entity has been notified, and any additional requirements must be promptly removed once the conditions that prompted them have been satisfied. Additional Federal award conditions may include items such as additional, more detailed financial reports. The State of Ohio Community Development Block Grant (CDBG) Program Grant Agreements for the Village of Lafayette Water Line Project (B-W-20-1AB-1), Village of Harrod Water Line Project (B-W-20-1AB-2), the Gomer Wastewater Collection System Project (B-W-20-1AB-3), Community Development Program B-F-20-1AB-1, Community Development Block Grant B-F-22-1AB-1 and (Community Housing Impact and Preservation Program) B-C-21-1AB-1, state that the grantee shall submit the required reports in an adequate and timely fashion. Granter shall provide a format for these reports and shall instruct Grantee on the proper completion of said reports. All report forms and requirements listed herein shall be provided by Granter, but shall not be construed to limit Granter in making additional and/or further requests, nor in the change or addition of detail to the items listed. The Grantee shall submit to Granter a Status Report within 30 days of the request by Granter. The County submitted Status Reports; however possibly due to the failure of an existing control(s), two out of eight (twenty-five percent) Status Reports were submitted between five to twelve months late. For one out of eight (twelve percent) Status Reports the reported expenditures were $4,386 more than the supporting accounting records (see related finding number 2023-002). Reporting errors could adversely affect future grant awards. An additional control(s) and/or procedure(s) should be implemented to help ensure required reports are accurately prepared and submitted in a timely manner.
1. Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Material Weakness and Noncompliance 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 County submitted the required Project and Expenditure Report on April 10, 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 due to $1,210,069 identified as loss of revenue being excluded from Project and Expenditure Report. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports. Officials’ Response: See Corrective Action Plan.
1. Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Material Weakness and Noncompliance 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 County submitted the required Project and Expenditure Report on April 10, 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 due to $1,210,069 identified as loss of revenue being excluded from Project and Expenditure Report. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports. Officials’ Response: See Corrective Action Plan.
1. Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Material Weakness and Noncompliance 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 County submitted the required Project and Expenditure Report on April 10, 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 due to $1,210,069 identified as loss of revenue being excluded from Project and Expenditure Report. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports. Officials’ Response: See Corrective Action Plan.
1. Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Material Weakness and Noncompliance 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 County submitted the required Project and Expenditure Report on April 10, 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 due to $1,210,069 identified as loss of revenue being excluded from Project and Expenditure Report. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports. Officials’ Response: See Corrective Action Plan.
1. Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Material Weakness and Noncompliance 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 County submitted the required Project and Expenditure Report on April 10, 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 due to $1,210,069 identified as loss of revenue being excluded from Project and Expenditure Report. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports. Officials’ Response: See Corrective Action Plan.
1. Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Treasury Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? No Material Weakness and Noncompliance 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 County submitted the required Project and Expenditure Report on April 10, 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 due to $1,210,069 identified as loss of revenue being excluded from Project and Expenditure Report. Reporting errors could adversely affect future grant awards. Additional controls should be implemented to help ensure accuracy of the reports. Officials’ Response: See Corrective Action Plan.
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 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 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 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 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.
2 CFR § 2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 C.F.R. § 200.328 which states, unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMB-approved governmentwide data elements for collection of financial information (at time of publication the Federal Financial Report or such future, OMB-approved, governmentwide data elements available from the OMB-designated standards lead. This information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes, and preferably in coordination with performance reporting. The Federal awarding agency must use OMB-approved common information collections, as applicable, when providing financial and performance reporting information. 2 CFR § 2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR § 200.208 which states, in part, that Federal awarding agencies are responsible for ensuring that specific Federal award conditions are consistent with the program design reflected in § 200.202 and include clear performance expectations of recipients as required in § 200.301. The Federal awarding agency or pass- through entity may adjust specific Federal award conditions as needed, in accordance with this section, based on an analysis of specified factors. Additional Federal award conditions may be added provided the applicant or non-Federal entity has been notified, and any additional requirements must be promptly removed once the conditions that prompted them have been satisfied. Additional Federal award conditions may include items such as additional, more detailed financial reports. The various grant agreements for the program state that the grantee shall submit the required reports in an adequate and timely fashion. The Grantor shall provide a format for these reports and shall instruct the Grantee on the proper completion of said reports. All report forms and requirements listed herein shall be provided by the Grantor but shall not be construed to limit the Grantor in making additional and/or further requests, nor in the change or addition of detail to the items listed. The Grantee shall submit to the Grantor a Status Report within 30 days of the request by the Grantor. The County submitted Final and Status Reports; however, possibly due to the failure of existing controls, three out of three (one hundred percent) of Final and Status Reports tested were submitted late. Reporting errors could adversely affect future grant awards. Additional controls and/or procedures should be implemented to help ensure required reports are accurately prepared and submitted in a timely manner.
FINDING 2023-004 – Cash Management: Significant Deficiency over Internal Controls over Compliance Assistance Listing Number Federal Agency/Pass-through Entity – Program Name Award Year Questioned Costs 64.033 VA Supportive Services for Veteran Families Program 2023 $0 Criteria: Regulations at 31 CFR Part 205 implement the Cash Management Improvement Act of 1990 (CMIA), as amended (Pub. L. No. 101-453; 31 USC 6501 et seq.). Non-federal entities must establish written procedures to implement the requirements of 2 CFR section 200.305 ((2 CFR section 200.302(b)(6)). Non-federal entities must minimize the time elapsing between the transfer of funds from the US Treasury or pass-through entity and disbursement by the non-federal entity for direct program or project costs and the proportionate share of allowable indirect costs, whether the payment is made by electronic funds transfer, or issuance or redemption of checks, warrants, or payment by other means (2 CFR section 200.305(b)). The reimbursement payment method is the preferred payment method if (a) the non-federal entity cannot the meet the requirements in 2 CFR section 200.305(b)(1) for advance payment, (b) the federal awarding agency sets a specific condition for use of the reimbursement or (c) if requested by the non-federal entity (2 CFR sections 200.305(b)(3) and 200.208). Condition/Context: The Organization draws down funds based on a profit and loss report to signify the excess expenses incurred over the grant revenue. The Organization operates on a reimbursement basis. The request for reimbursements are not reviewed to ensure amounts have been paid with the Organization’s funds prior to the reimbursement request because certain expense codes do not relate to expenses paid but rather expenses incurred. Additionally, the frequency of draws during mid-months creates potential for errors when the reporting period has not been reconciled and therefore coded expenses are subject to change. Effect: Certain expenses included on the draw down total have not been paid for with Organization funds prior to the request or within 3 days of receipt of federal fund. Cause: There is no review to ensure the total only included expenses paid. Repeat finding: This is not a repeat finding. Recommendation: The Organization should reconcile program expenditures and requests for federal funds to ensure the total draw down is not in excess of disbursements paid by the Organization. Management should implement a review and approval process for reimbursement requests to verify that amounts drawn are supported by paid expenditures and appropriate documentation. Views of responsible officials and planned corrective actions: Management agrees with the recommendation and has developed a corrective action plan to address the finding.
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.
Subrecipient Monitoring Federal Department – U.S. Department of Health and Human Services Federal Award Identification Number and Year: NH75OT000024 and 2021 COVID-19 - Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises, Federal Assistance Listing #93.391 County Department – Department of Public Health Finding 2023 – 005 CRITERIA 2 CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D—Post Federal Award Requirements Standards for Financial and Program Management, Section 200.332. Requirements for pass-through entities, requires that “All pass-through entities must: (b) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F—Audit Requirements of this part, and the extent to which the same or similar subaward has been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of Federal awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a Federal awarding agency). (c) Consider imposing specific subaward conditions upon a subrecipient if appropriate as described in Section 200.208 Specific conditions. (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the pass-through entity. (2) Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and other means. (3) Issuing a management decision for audit findings pertaining to the Federal award provided to the subrecipient from the pass-through entity as required by Section 200.521 Management decision. (e) Depending upon the pass-through entity's assessment of risk posed by the subrecipient (as described in paragraph (b) of this section), the following monitoring tools may be useful for the pass-through entity to ensure proper accountability and compliance with program requirements and achievement of performance goals: (1) Providing subrecipients with training and technical assistance on program-related matters; and (2) Performing on-site reviews of the subrecipient's program operations; (3) Arranging for agreed-upon-procedures engagements as described in Section 200.425 Audit services. (f) Verify that every subrecipient is audited as required by Subpart F— Audit Requirements of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in Section 200.501 Audit requirements. (g) Consider whether the results of the subrecipient's audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity's own records. (h) Consider taking enforcement action against noncompliant subrecipients as described in Section 200.338 Remedies for noncompliance of this part and in program regulations.” CONDITION During the current audit period, the Cook County Department of Public Health (DPH) did not adequately comply with its subrecipient monitoring requirements in accordance with federal regulations. CAUSE Based on discussions with management, the cause of this finding was due to DPH/CCH identifying a consultant agency to conduct the subrecipient monitoring; this was accomplished October 2023. Current Status: These documents were created, shared with the auditor pending management approval; 1) Subrecipient Monitoring Policy 2). Subrecipient Commitment Form 3). Subrecipient Determination Tool 4). Subrecipient Risk Assessment and Monitoring Guide. EFFECT Failure to adequately monitor the activities and performance of a subrecipient could result in Federal awards being used for unauthorized purposes and DPH’s inability to adequately perform risk assessments on its subrecipient(s). QUESTIONED COSTS None. CONTEXT During the prior audit period, we noted 6 instances (of 27 subrecipients), whereby adequate documentation was not maintained to support both the financial and programmatic monitoring of these subrecipients. Also, we noted no evidence of the performance of subrecipients’ risk assessment and whether the subrecipients were required to have a Single audit conducted. This resulted in the 2022 audit finding and subsequent corrective action planned prepared by DPH to address the finding, which was anticipated to be completed by December 31, 2023. During the current audit period, we received DPH’s current year status of the prior audit finding, noting that risk assessment and monitoring will be ongoing during the 2023 Single audit. To assess the current year’s status, we reviewed 5 of 35 subrecipients, noting that risk assessments were conducted in April 2024. We also noted that 4 of the 5 subrecipients reviewed were subject to a Single Audit per the risk assessment documentation. However, we noted no evidence financial monitoring conducted, including whether a Single Audit report was obtained and reviewed by DPH. IDENTIFICATION OF REPEATED FINDINGS Repeated (Prior Finding No. 2022-009) RECOMMENDATION We recommend DPH implement its prior corrective action plan for any future subrecipients awarded under the federal program. Also, procedures should be in place to adequately document financial monitoring conducted, as well as the review of the Single Audit report, as required by federal regulations. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTIONS The County agrees with the finding and recommendation. The County’s corrective action plan is on page 56.
Subrecipient Monitoring Federal Department – U.S. Department of Health and Human Services Federal Award Identification Number and Year: NU58DP006993 and 2022/2023 COVID-19 - Community Health Workers for Public Health Response and Resilient, Federal Assistance Listing #93.495 County Department – Department of Public Health Finding 2023 – 006 CRITERIA 2 CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D—Post Federal Award Requirements Standards for Financial and Program Management, Section 200.332. Requirements for pass-through entities, requires that “All pass-through entities must: (b) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F—Audit Requirements of this part, and the extent to which the same or similar subaward has been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of Federal awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a Federal awarding agency). (c) Consider imposing specific subaward conditions upon a subrecipient if appropriate as described in Section 200.208 Specific conditions. (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the pass-through entity. (2) Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and other means. (3) Issuing a management decision for audit findings pertaining to the Federal award provided to the subrecipient from the pass-through entity as required by Section 200.521 Management decision. (e) Depending upon the pass-through entity's assessment of risk posed by the subrecipient (as described in paragraph (b) of this section), the following monitoring tools may be useful for the pass-through entity to ensure proper accountability and compliance with program requirements and achievement of performance goals: (1) Providing subrecipients with training and technical assistance on program-related matters; and (2) Performing on-site reviews of the subrecipient's program operations; (3) Arranging for agreed-upon-procedures engagements as described in Section 200.425 Audit services. (f) Verify that every subrecipient is audited as required by Subpart F— Audit Requirements of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in Section 200.501 Audit requirements. (g) Consider whether the results of the subrecipient's audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity's own records. (h) Consider taking enforcement action against noncompliant subrecipients as described in Section 200.338 Remedies for noncompliance of this part and in program regulations.” CONDITION During the current audit period, the Cook County Department of Public Health (DPH) did not perform adequate monitoring of its subrecipients as required by Federal regulations. CAUSE Based on discussions with management, the cause of this finding was due to DPH/CCH identifying a consultant agency to conduct the subrecipient monitoring; this was accomplished October 2023. Current Status: These documents were created, shared with the auditor pending management approval; 1) Subrecipient Monitoring Policy 2). Subrecipient Commitment Form 3). Subrecipient Determination Tool 4). Subrecipient Risk Assessment and Monitoring Guide. EFFECT Failure to adequately monitor the activities and performance of a subrecipient could result in Federal awards being used for unauthorized purposes and DPH’s inability to adequately perform risk assessments on its subrecipient(s). QUESTIONED COSTS None. CONTEXT During the current audit period, we noted 12 subrecipients were awarded funds. During our review of three (3) subrecipients, we noted the following: For all three subrecipients, we noted that adequate documentation was not maintained to support the financial monitoring of these subrecipients. Also, no documentation was provided to verify whether the subrecipients were required to have a Single Audit conducted, including DPH’s review of the report, and if applicable, issuance of a management decision on audit findings noted as required by 2 CFR 200.332d(3). For one subrecipient, we noted documentation was not maintained to support DPH’s evaluation of the subrecipient’s risk of noncompliance and the frequency of monitoring to be conducted by DPH based on the assessed risk. IDENTIFICATION OF REPEATED FINDINGS None. RECOMMENDATION We recommend DPH implement procedures to ensure that adequate documentation is maintained to support financial monitoring conducted, evaluation of each subrecipient’s risk of noncompliance and review of the Single Audit report, as required by federal regulations. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTIONS The County agrees with the finding and recommendation. The County’s corrective action plan is on page 56.
Subrecipient Monitoring Federal Department – U.S. Department of Health and Human Services Federal Award Identification Number and Year: NH75OT000024 and 2021 COVID-19 - Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises, Federal Assistance Listing #93.391 County Department – Department of Public Health Finding 2023 – 005 CRITERIA 2 CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D—Post Federal Award Requirements Standards for Financial and Program Management, Section 200.332. Requirements for pass-through entities, requires that “All pass-through entities must: (b) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F—Audit Requirements of this part, and the extent to which the same or similar subaward has been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of Federal awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a Federal awarding agency). (c) Consider imposing specific subaward conditions upon a subrecipient if appropriate as described in Section 200.208 Specific conditions. (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the pass-through entity. (2) Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and other means. (3) Issuing a management decision for audit findings pertaining to the Federal award provided to the subrecipient from the pass-through entity as required by Section 200.521 Management decision. (e) Depending upon the pass-through entity's assessment of risk posed by the subrecipient (as described in paragraph (b) of this section), the following monitoring tools may be useful for the pass-through entity to ensure proper accountability and compliance with program requirements and achievement of performance goals: (1) Providing subrecipients with training and technical assistance on program-related matters; and (2) Performing on-site reviews of the subrecipient's program operations; (3) Arranging for agreed-upon-procedures engagements as described in Section 200.425 Audit services. (f) Verify that every subrecipient is audited as required by Subpart F— Audit Requirements of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in Section 200.501 Audit requirements. (g) Consider whether the results of the subrecipient's audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity's own records. (h) Consider taking enforcement action against noncompliant subrecipients as described in Section 200.338 Remedies for noncompliance of this part and in program regulations.” CONDITION During the current audit period, the Cook County Department of Public Health (DPH) did not adequately comply with its subrecipient monitoring requirements in accordance with federal regulations. CAUSE Based on discussions with management, the cause of this finding was due to DPH/CCH identifying a consultant agency to conduct the subrecipient monitoring; this was accomplished October 2023. Current Status: These documents were created, shared with the auditor pending management approval; 1) Subrecipient Monitoring Policy 2). Subrecipient Commitment Form 3). Subrecipient Determination Tool 4). Subrecipient Risk Assessment and Monitoring Guide. EFFECT Failure to adequately monitor the activities and performance of a subrecipient could result in Federal awards being used for unauthorized purposes and DPH’s inability to adequately perform risk assessments on its subrecipient(s). QUESTIONED COSTS None. CONTEXT During the prior audit period, we noted 6 instances (of 27 subrecipients), whereby adequate documentation was not maintained to support both the financial and programmatic monitoring of these subrecipients. Also, we noted no evidence of the performance of subrecipients’ risk assessment and whether the subrecipients were required to have a Single audit conducted. This resulted in the 2022 audit finding and subsequent corrective action planned prepared by DPH to address the finding, which was anticipated to be completed by December 31, 2023. During the current audit period, we received DPH’s current year status of the prior audit finding, noting that risk assessment and monitoring will be ongoing during the 2023 Single audit. To assess the current year’s status, we reviewed 5 of 35 subrecipients, noting that risk assessments were conducted in April 2024. We also noted that 4 of the 5 subrecipients reviewed were subject to a Single Audit per the risk assessment documentation. However, we noted no evidence financial monitoring conducted, including whether a Single Audit report was obtained and reviewed by DPH. IDENTIFICATION OF REPEATED FINDINGS Repeated (Prior Finding No. 2022-009) RECOMMENDATION We recommend DPH implement its prior corrective action plan for any future subrecipients awarded under the federal program. Also, procedures should be in place to adequately document financial monitoring conducted, as well as the review of the Single Audit report, as required by federal regulations. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTIONS The County agrees with the finding and recommendation. The County’s corrective action plan is on page 56.
Subrecipient Monitoring Federal Department – U.S. Department of Health and Human Services Federal Award Identification Number and Year: NU58DP006993 and 2022/2023 COVID-19 - Community Health Workers for Public Health Response and Resilient, Federal Assistance Listing #93.495 County Department – Department of Public Health Finding 2023 – 006 CRITERIA 2 CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D—Post Federal Award Requirements Standards for Financial and Program Management, Section 200.332. Requirements for pass-through entities, requires that “All pass-through entities must: (b) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F—Audit Requirements of this part, and the extent to which the same or similar subaward has been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of Federal awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a Federal awarding agency). (c) Consider imposing specific subaward conditions upon a subrecipient if appropriate as described in Section 200.208 Specific conditions. (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the pass-through entity. (2) Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and other means. (3) Issuing a management decision for audit findings pertaining to the Federal award provided to the subrecipient from the pass-through entity as required by Section 200.521 Management decision. (e) Depending upon the pass-through entity's assessment of risk posed by the subrecipient (as described in paragraph (b) of this section), the following monitoring tools may be useful for the pass-through entity to ensure proper accountability and compliance with program requirements and achievement of performance goals: (1) Providing subrecipients with training and technical assistance on program-related matters; and (2) Performing on-site reviews of the subrecipient's program operations; (3) Arranging for agreed-upon-procedures engagements as described in Section 200.425 Audit services. (f) Verify that every subrecipient is audited as required by Subpart F— Audit Requirements of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in Section 200.501 Audit requirements. (g) Consider whether the results of the subrecipient's audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity's own records. (h) Consider taking enforcement action against noncompliant subrecipients as described in Section 200.338 Remedies for noncompliance of this part and in program regulations.” CONDITION During the current audit period, the Cook County Department of Public Health (DPH) did not perform adequate monitoring of its subrecipients as required by Federal regulations. CAUSE Based on discussions with management, the cause of this finding was due to DPH/CCH identifying a consultant agency to conduct the subrecipient monitoring; this was accomplished October 2023. Current Status: These documents were created, shared with the auditor pending management approval; 1) Subrecipient Monitoring Policy 2). Subrecipient Commitment Form 3). Subrecipient Determination Tool 4). Subrecipient Risk Assessment and Monitoring Guide. EFFECT Failure to adequately monitor the activities and performance of a subrecipient could result in Federal awards being used for unauthorized purposes and DPH’s inability to adequately perform risk assessments on its subrecipient(s). QUESTIONED COSTS None. CONTEXT During the current audit period, we noted 12 subrecipients were awarded funds. During our review of three (3) subrecipients, we noted the following: For all three subrecipients, we noted that adequate documentation was not maintained to support the financial monitoring of these subrecipients. Also, no documentation was provided to verify whether the subrecipients were required to have a Single Audit conducted, including DPH’s review of the report, and if applicable, issuance of a management decision on audit findings noted as required by 2 CFR 200.332d(3). For one subrecipient, we noted documentation was not maintained to support DPH’s evaluation of the subrecipient’s risk of noncompliance and the frequency of monitoring to be conducted by DPH based on the assessed risk. IDENTIFICATION OF REPEATED FINDINGS None. RECOMMENDATION We recommend DPH implement procedures to ensure that adequate documentation is maintained to support financial monitoring conducted, evaluation of each subrecipient’s risk of noncompliance and review of the Single Audit report, as required by federal regulations. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTIONS The County agrees with the finding and recommendation. The County’s corrective action plan is on page 56.
Criteria: Per 2 CFR Appendix A to Part 170, recipients (i.e. direct recipients) of grants or cooperative agreements are required to report first-tier sub-awards $30,000 or more to the Federal Funding Accountability and Transparency Act (FFATA) Sub-Award Reporting System (FSRS). The non-Federal entity must report each obligating action no later than the end of the month following the month in which the obligation was made. Condition/context: During testing, it was determined the Department did not submit the required reports to the FSRS following the obligation of federal funds, as required under the FFATA. Cause: The Department did not have adequate controls in place to verify the necessary reports were being properly submitted within the required time period under FFATA. Effect: Per 2 CFR 200.339, if a non-Federal entity fails to comply with Federal statutes, regulations or the terms and conditions of a Federal award, the Federal awarding agency or pass-through entity may impose additional conditions, as described in §200.208 Specific conditions. If the Federal awarding agency or pass-through entity determines that noncompliance cannot be remedied by imposing additional conditions, the Federal awarding agency or pass-through entity may take one or more of the following actions, as appropriate in the circumstances: (a) Temporarily withhold cash payments pending correction of the deficiency by the non-Federal entity or more severe enforcement action by the Federal awarding agency or pass-through entity. (b) Disallow (that is, deny both use of funds and any applicable matching credit for) all or part of the cost of the activity or action not in compliance. (c) Wholly or partly suspend or terminate the Federal award. (d) Initiate suspension or debarment proceedings as authorized under 2 CFR part 180 and Federal awarding agency regulations (or in the case of a pass-through entity, recommend such a proceeding be initiated by a Federal awarding agency). (e) Withhold further Federal awards for the project or program. (f) Take other remedies that may be legally available. Questioned costs: None. Identification as a repeat finding: No. Recommendation: We recommend the Department review its internal controls surrounding FFATA reporting and train all program managers responsible for federal funds on the processes in place to ensure all individuals responsible for completing and submitting the reports are properly trained to do so. Views of responsible officials: Management concurs with the finding. See Exhibit I for corrective action plan.
Criteria: Per 2 CFR Appendix A to Part 170, recipients (i.e. direct recipients) of grants or cooperative agreements are required to report first-tier sub-awards $30,000 or more to the Federal Funding Accountability and Transparency Act (FFATA) Sub-Award Reporting System (FSRS). The non-Federal entity must report each obligating action no later than the end of the month following the month in which the obligation was made. Condition/context: During testing, it was determined the Department did not submit the required reports to the FSRS following the obligation of federal funds, as required under the FFATA. Cause: The Department did not have adequate controls in place to verify the necessary reports were being properly submitted within the required time period under FFATA. Effect: Per 2 CFR 200.339, if a non-Federal entity fails to comply with Federal statutes, regulations or the terms and conditions of a Federal award, the Federal awarding agency or pass-through entity may impose additional conditions, as described in §200.208 Specific conditions. If the Federal awarding agency or pass-through entity determines that noncompliance cannot be remedied by imposing additional conditions, the Federal awarding agency or pass-through entity may take one or more of the following actions, as appropriate in the circumstances: (a) Temporarily withhold cash payments pending correction of the deficiency by the non-Federal entity or more severe enforcement action by the Federal awarding agency or pass-through entity. (b) Disallow (that is, deny both use of funds and any applicable matching credit for) all or part of the cost of the activity or action not in compliance. (c) Wholly or partly suspend or terminate the Federal award. (d) Initiate suspension or debarment proceedings as authorized under 2 CFR part 180 and Federal awarding agency regulations (or in the case of a pass-through entity, recommend such a proceeding be initiated by a Federal awarding agency). (e) Withhold further Federal awards for the project or program. (f) Take other remedies that may be legally available. Questioned costs: None. Identification as a repeat finding: No. Recommendation: We recommend the Department review its internal controls surrounding FFATA reporting and train all program managers responsible for federal funds on the processes in place to ensure all individuals responsible for completing and submitting the reports are properly trained to do so. Views of responsible officials: Management concurs with the finding. See Exhibit I for corrective action plan.
Information on the Federal Program: Federal Agency: U.S. Department of Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number 21.027 Compliance Requirement: Subrecipient Monitoring Type of Finding: Material Weakness in Internal Controls over Compliance, Modified Opinion Criteria: Title 2 U.S. Code of Federal Regulations (CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Section 200.332, Requirements for pass-through entities, states "All pass-through entities must: (a) ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward; (b) evaluate each subrecipient's risk of noncompliance with federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring; (c) consider imposing specific subaward conditions upon a subrecipient if appropriate as described in Section 200.208 (Specific conditions); (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved; (f) Verify that every subrecipient is audited as required by Subpart F of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in Section 200.501. 2 CFR 200.303 states in part: "The non-Federal enity must (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award." Condition: The City received a total State and Local Fiscal Recovery Funds (SLFRF) allocation of $3,431,839. In its March, 2022, Project and Expenditures Report, the City elected to use the standard allowance for identifying revenue loss and reported its Revenue Loss Due to Covid-19 Public Health Emergency as $3,431,839. During fiscal year ended September 30, 2023, the City made payments from its SLFRF federal award, totaling $1,600,000, to another local government entity for materials used by the other government for a water line project. The payments were supported by an invoice from the other government, to which were attached copies of invoices submitted to the other government by its vendors. The City reported in its March, 2023, Project and Expenditures Report that the payments were made under the Infrastructure: Drinking water: Transmission & distribution Project Expenditure Category and Subcategory. The City also reported the transactions as a subaward, including identification of the subrecipient, and reported each of the payments to the subrecipient in the Expenditures section, in that Project and Expenditures Report. The City was unable to provide: a copy of the subaward agreement that clearly identified the subaward to the subrecipient as a subaward and that included the information required by Section 200.332(a); supporting documentation that the City evaluated the subrecipient's risk of noncompliance as required by Section 200.332(b); supporting documentation that the City monitored the activities of the subrecipient as required by Section 200.332 (d); and/or supporting documentation that the City verified that the subrecipient was audited as required by Subpart F. Cause: The City did not have adequate internal controls to ensure compliance with the Subrecipient Monitoring compliance requirement. The City's past federal awards experience did not involve or include subawards. Effect or Potential Effect: Noncompliance by the subrecipient may occur due to the subrecipient not being aware of the federal program's requirements and due to the City not sufficiently monitoring the subrecipient. Recommendation: We recommend that management of the City design and implement a comprehensive system of internal controls over federal award compliance, including development of policies and procedures to ensure compliance with the Subrecipient Monitoring compliance requirement. Views of Responsible Officials and Planned Corrective Actions: See Corrective Action Plan
Criteria: Per 2 CFR Appendix A to Part 170, recipients (i.e. direct recipients) of grants or cooperative agreements are required to report first-tier sub-awards $30,000 or more to the Federal Funding Accountability and Transparency Act (FFATA) Sub-Award Reporting System (FSRS). The non-Federal entity must report each obligating action no later than the end of the month following the month in which the obligation was made. Condition/context: During testing, it was determined the Department did not submit the required reports to the FSRS following the obligation of federal funds, as required under the FFATA. Cause: The Department did not have adequate controls in place to verify the necessary reports were being properly submitted within the required time period under FFATA. Effect: Per 2 CFR 200.339, if a non-Federal entity fails to comply with Federal statutes, regulations or the terms and conditions of a Federal award, the Federal awarding agency or pass-through entity may impose additional conditions, as described in §200.208 Specific conditions. If the Federal awarding agency or pass-through entity determines that noncompliance cannot be remedied by imposing additional conditions, the Federal awarding agency or pass-through entity may take one or more of the following actions, as appropriate in the circumstances: (a) Temporarily withhold cash payments pending correction of the deficiency by the non-Federal entity or more severe enforcement action by the Federal awarding agency or pass-through entity. (b) Disallow (that is, deny both use of funds and any applicable matching credit for) all or part of the cost of the activity or action not in compliance. (c) Wholly or partly suspend or terminate the Federal award. (d) Initiate suspension or debarment proceedings as authorized under 2 CFR part 180 and Federal awarding agency regulations (or in the case of a pass-through entity, recommend such a proceeding be initiated by a Federal awarding agency). (e) Withhold further Federal awards for the project or program. (f) Take other remedies that may be legally available. Questioned costs: None. Identification as a repeat finding: No. Recommendation: We recommend the Department review its internal controls surrounding FFATA reporting and train all program managers responsible for federal funds on the processes in place to ensure all individuals responsible for completing and submitting the reports are properly trained to do so. Views of responsible officials: Management concurs with the finding. See Exhibit I for corrective action plan.
Criteria: Per 2 CFR Appendix A to Part 170, recipients (i.e. direct recipients) of grants or cooperative agreements are required to report first-tier sub-awards $30,000 or more to the Federal Funding Accountability and Transparency Act (FFATA) Sub-Award Reporting System (FSRS). The non-Federal entity must report each obligating action no later than the end of the month following the month in which the obligation was made. Condition/context: During testing, it was determined the Department did not submit the required reports to the FSRS following the obligation of federal funds, as required under the FFATA. Cause: The Department did not have adequate controls in place to verify the necessary reports were being properly submitted within the required time period under FFATA. Effect: Per 2 CFR 200.339, if a non-Federal entity fails to comply with Federal statutes, regulations or the terms and conditions of a Federal award, the Federal awarding agency or pass-through entity may impose additional conditions, as described in §200.208 Specific conditions. If the Federal awarding agency or pass-through entity determines that noncompliance cannot be remedied by imposing additional conditions, the Federal awarding agency or pass-through entity may take one or more of the following actions, as appropriate in the circumstances: (a) Temporarily withhold cash payments pending correction of the deficiency by the non-Federal entity or more severe enforcement action by the Federal awarding agency or pass-through entity. (b) Disallow (that is, deny both use of funds and any applicable matching credit for) all or part of the cost of the activity or action not in compliance. (c) Wholly or partly suspend or terminate the Federal award. (d) Initiate suspension or debarment proceedings as authorized under 2 CFR part 180 and Federal awarding agency regulations (or in the case of a pass-through entity, recommend such a proceeding be initiated by a Federal awarding agency). (e) Withhold further Federal awards for the project or program. (f) Take other remedies that may be legally available. Questioned costs: None. Identification as a repeat finding: No. Recommendation: We recommend the Department review its internal controls surrounding FFATA reporting and train all program managers responsible for federal funds on the processes in place to ensure all individuals responsible for completing and submitting the reports are properly trained to do so. Views of responsible officials: Management concurs with the finding. See Exhibit I for corrective action plan.
Information on the Federal Program: Federal Agency: U.S. Department of Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number 21.027 Compliance Requirement: Subrecipient Monitoring Type of Finding: Material Weakness in Internal Controls over Compliance, Modified Opinion Criteria: Title 2 U.S. Code of Federal Regulations (CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Section 200.332, Requirements for pass-through entities, states "All pass-through entities must: (a) ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward; (b) evaluate each subrecipient's risk of noncompliance with federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring; (c) consider imposing specific subaward conditions upon a subrecipient if appropriate as described in Section 200.208 (Specific conditions); (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved; (f) Verify that every subrecipient is audited as required by Subpart F of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in Section 200.501. 2 CFR 200.303 states in part: "The non-Federal enity must (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award." Condition: The City received a total State and Local Fiscal Recovery Funds (SLFRF) allocation of $3,431,839. In its March, 2022, Project and Expenditures Report, the City elected to use the standard allowance for identifying revenue loss and reported its Revenue Loss Due to Covid-19 Public Health Emergency as $3,431,839. During fiscal year ended September 30, 2023, the City made payments from its SLFRF federal award, totaling $1,600,000, to another local government entity for materials used by the other government for a water line project. The payments were supported by an invoice from the other government, to which were attached copies of invoices submitted to the other government by its vendors. The City reported in its March, 2023, Project and Expenditures Report that the payments were made under the Infrastructure: Drinking water: Transmission & distribution Project Expenditure Category and Subcategory. The City also reported the transactions as a subaward, including identification of the subrecipient, and reported each of the payments to the subrecipient in the Expenditures section, in that Project and Expenditures Report. The City was unable to provide: a copy of the subaward agreement that clearly identified the subaward to the subrecipient as a subaward and that included the information required by Section 200.332(a); supporting documentation that the City evaluated the subrecipient's risk of noncompliance as required by Section 200.332(b); supporting documentation that the City monitored the activities of the subrecipient as required by Section 200.332 (d); and/or supporting documentation that the City verified that the subrecipient was audited as required by Subpart F. Cause: The City did not have adequate internal controls to ensure compliance with the Subrecipient Monitoring compliance requirement. The City's past federal awards experience did not involve or include subawards. Effect or Potential Effect: Noncompliance by the subrecipient may occur due to the subrecipient not being aware of the federal program's requirements and due to the City not sufficiently monitoring the subrecipient. Recommendation: We recommend that management of the City design and implement a comprehensive system of internal controls over federal award compliance, including development of policies and procedures to ensure compliance with the Subrecipient Monitoring compliance requirement. Views of Responsible Officials and Planned Corrective Actions: See Corrective Action Plan
Federal Agency: U.S. Department of Health and Human Services AL Program: 93.323 Epidemiology and Laboratory Capacity for Infectious Disease Federal Award No.: NU50CK000513 Area: Cash Management Questioned Costs: $236,426 Criteria: In accordance with 2 CFR section 200.305(b)(3), reimbursement is preferred when the requirements in paragraph (b) cannot be met, when the Federal agency sets a specific condition per section 200.208. When the reimbursement method is used, the Federal agency or pass-through entity must make payment within 30 calendar days after receipt of the payment request unless the Federal agency or pass-through entity reasonably believes the request to be improper. Condition: Of forty transactions tested, aggregating $236,426 of a total population of $3,758,311, the following were noted: For forty (or 100%) samples tested, drawdown reports were not provided to substantiate that expenditures were incurred prior to the date of the reimbursement request. Cause: The FSM National Government lacked monitoring controls over adequate documentation and systematic filing of relevant documents supporting program costs. Effect: The FSM National Government appears to be in noncompliance with applicable cash management requirements and questioned cost of $236,426 is reported. Recommendation: The FSM National Government should strengthen and enforce compliance with the applicable cash management requirements and establish and implement systematic filing of relevant documentation supporting program costs for easy retrieval. Views of Responsible Officials: Management disagrees with the finding. Refer to FSM NG’s Views of Responsible Officials for their detailed response. Auditor Response: The finding remains as we could not locate nor find the required documentation within the files provided.