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.
2023-002 – Financial Reporting Finding Type: Material Noncompliance; Material Weakness in Internal Control over Compliance Program: Rural Communities Opioid Response – Planning/Rural Health Outreach and Rural Network Development Program (AL# 93.912); U.S. Department of Health and Human Services; Direct award; all grant numbers. Criteria: The Organization failed to follow the financial reporting requirements in 2 CFR section 200.328. The Organization did not trace the amounts reported to accounting records that support the audited financial statements and the schedule of expenditures of federal awards to verify accuracy and completeness. Condition: Reported amounts were not reviewed and matched to the accounting records accurately prior to submission. Cause: The Organization does not have an adequate level of review in place to properly monitor the amounts being reported for compliance. Actual amounts reported were inaccurate and did not match the actual expenses up to that point in time. The Organization did not follow the specific steps noted in 2 CFR section 200.328 of tracing amounts to records and verifying for accuracy and completeness. Effect: The Organization may not be eligible for future funding or might have to pay back federal funds received for not appropriately identifying and reporting their actual expenses. Questioned Costs: No costs were questioned as a result of this finding. Recommendation: The Organization should implement procedures for verifying accuracy and completeness prior to submission. View of Responsible Officials: Management agrees with the finding and plans to implement procedures for verifying accuracy and completeness prior to submission.
2023-002 – Financial Reporting Finding Type: Material Noncompliance; Material Weakness in Internal Control over Compliance Program: Rural Communities Opioid Response – Planning/Rural Health Outreach and Rural Network Development Program (AL# 93.912); U.S. Department of Health and Human Services; Direct award; all grant numbers. Criteria: The Organization failed to follow the financial reporting requirements in 2 CFR section 200.328. The Organization did not trace the amounts reported to accounting records that support the audited financial statements and the schedule of expenditures of federal awards to verify accuracy and completeness. Condition: Reported amounts were not reviewed and matched to the accounting records accurately prior to submission. Cause: The Organization does not have an adequate level of review in place to properly monitor the amounts being reported for compliance. Actual amounts reported were inaccurate and did not match the actual expenses up to that point in time. The Organization did not follow the specific steps noted in 2 CFR section 200.328 of tracing amounts to records and verifying for accuracy and completeness. Effect: The Organization may not be eligible for future funding or might have to pay back federal funds received for not appropriately identifying and reporting their actual expenses. Questioned Costs: No costs were questioned as a result of this finding. Recommendation: The Organization should implement procedures for verifying accuracy and completeness prior to submission. View of Responsible Officials: Management agrees with the finding and plans to implement procedures for verifying accuracy and completeness prior to submission.
2023-002 – Financial Reporting Finding Type: Material Noncompliance; Material Weakness in Internal Control over Compliance Program: Rural Communities Opioid Response – Planning/Rural Health Outreach and Rural Network Development Program (AL# 93.912); U.S. Department of Health and Human Services; Direct award; all grant numbers. Criteria: The Organization failed to follow the financial reporting requirements in 2 CFR section 200.328. The Organization did not trace the amounts reported to accounting records that support the audited financial statements and the schedule of expenditures of federal awards to verify accuracy and completeness. Condition: Reported amounts were not reviewed and matched to the accounting records accurately prior to submission. Cause: The Organization does not have an adequate level of review in place to properly monitor the amounts being reported for compliance. Actual amounts reported were inaccurate and did not match the actual expenses up to that point in time. The Organization did not follow the specific steps noted in 2 CFR section 200.328 of tracing amounts to records and verifying for accuracy and completeness. Effect: The Organization may not be eligible for future funding or might have to pay back federal funds received for not appropriately identifying and reporting their actual expenses. Questioned Costs: No costs were questioned as a result of this finding. Recommendation: The Organization should implement procedures for verifying accuracy and completeness prior to submission. View of Responsible Officials: Management agrees with the finding and plans to implement procedures for verifying accuracy and completeness prior to submission.
2023-002 – Financial Reporting Finding Type: Material Noncompliance; Material Weakness in Internal Control over Compliance Program: Rural Communities Opioid Response – Planning/Rural Health Outreach and Rural Network Development Program (AL# 93.912); U.S. Department of Health and Human Services; Direct award; all grant numbers. Criteria: The Organization failed to follow the financial reporting requirements in 2 CFR section 200.328. The Organization did not trace the amounts reported to accounting records that support the audited financial statements and the schedule of expenditures of federal awards to verify accuracy and completeness. Condition: Reported amounts were not reviewed and matched to the accounting records accurately prior to submission. Cause: The Organization does not have an adequate level of review in place to properly monitor the amounts being reported for compliance. Actual amounts reported were inaccurate and did not match the actual expenses up to that point in time. The Organization did not follow the specific steps noted in 2 CFR section 200.328 of tracing amounts to records and verifying for accuracy and completeness. Effect: The Organization may not be eligible for future funding or might have to pay back federal funds received for not appropriately identifying and reporting their actual expenses. Questioned Costs: No costs were questioned as a result of this finding. Recommendation: The Organization should implement procedures for verifying accuracy and completeness prior to submission. View of Responsible Officials: Management agrees with the finding and plans to implement procedures for verifying accuracy and completeness prior to submission.
2023-002 – Financial Reporting Finding Type: Material Noncompliance; Material Weakness in Internal Control over Compliance Program: Rural Communities Opioid Response – Planning/Rural Health Outreach and Rural Network Development Program (AL# 93.912); U.S. Department of Health and Human Services; Direct award; all grant numbers. Criteria: The Organization failed to follow the financial reporting requirements in 2 CFR section 200.328. The Organization did not trace the amounts reported to accounting records that support the audited financial statements and the schedule of expenditures of federal awards to verify accuracy and completeness. Condition: Reported amounts were not reviewed and matched to the accounting records accurately prior to submission. Cause: The Organization does not have an adequate level of review in place to properly monitor the amounts being reported for compliance. Actual amounts reported were inaccurate and did not match the actual expenses up to that point in time. The Organization did not follow the specific steps noted in 2 CFR section 200.328 of tracing amounts to records and verifying for accuracy and completeness. Effect: The Organization may not be eligible for future funding or might have to pay back federal funds received for not appropriately identifying and reporting their actual expenses. Questioned Costs: No costs were questioned as a result of this finding. Recommendation: The Organization should implement procedures for verifying accuracy and completeness prior to submission. View of Responsible Officials: Management agrees with the finding and plans to implement procedures for verifying accuracy and completeness prior to submission.
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.
2023‐011 Department of Treasury Federal Financial Assistance Listing/ALN 21.027 COVID‐19 Coronavirus State and Local Fiscal Recovery Funds Reporting Material Noncompliance and Material Weakness in Internal Control over Compliance Criteria ‐ In accordance with 2 CFR Part 200.328 and 31 CFR Section 354(c), the federal program requires quarterly and annual project and expenditure reporting be submitted to the granting oversight agency. Condition ‐ We requested copies of the submitted reports and supporting documentation for the year under audit in order to perform the compliance testing. These items could not be reproduced to verify that the reporting was submitted as required under the audit. Cause ‐ The Organization did not have proper procedures to ensure preparation and submission of the required reporting under the federal award. Effect ‐ The deficiency in internal controls resulted in material noncompliance to the Organization. Questioned Costs ‐ None reported. Context/Sampling ‐ No sampling was performed as supporting documentation to allow for testing of the reporting requirement was unavailable. Recommendation ‐ We recommend the Organization update its policies and procedures to allow for the proper identification of all reporting requirements, preparation and review of reports to be submitted, and accumulation of appropriate supporting documentation and schedules. Views of Responsible Officials ‐ Management is in agreement with the finding. Repeat Finding – This is a not a repeat finding.
2023‐011 Department of Treasury Federal Financial Assistance Listing/ALN 21.027 COVID‐19 Coronavirus State and Local Fiscal Recovery Funds Reporting Material Noncompliance and Material Weakness in Internal Control over Compliance Criteria ‐ In accordance with 2 CFR Part 200.328 and 31 CFR Section 354(c), the federal program requires quarterly and annual project and expenditure reporting be submitted to the granting oversight agency. Condition ‐ We requested copies of the submitted reports and supporting documentation for the year under audit in order to perform the compliance testing. These items could not be reproduced to verify that the reporting was submitted as required under the audit. Cause ‐ The Organization did not have proper procedures to ensure preparation and submission of the required reporting under the federal award. Effect ‐ The deficiency in internal controls resulted in material noncompliance to the Organization. Questioned Costs ‐ None reported. Context/Sampling ‐ No sampling was performed as supporting documentation to allow for testing of the reporting requirement was unavailable. Recommendation ‐ We recommend the Organization update its policies and procedures to allow for the proper identification of all reporting requirements, preparation and review of reports to be submitted, and accumulation of appropriate supporting documentation and schedules. Views of Responsible Officials ‐ Management is in agreement with the finding. Repeat Finding – This is a not a repeat finding.
2023‐011 Department of Treasury Federal Financial Assistance Listing/ALN 21.027 COVID‐19 Coronavirus State and Local Fiscal Recovery Funds Reporting Material Noncompliance and Material Weakness in Internal Control over Compliance Criteria ‐ In accordance with 2 CFR Part 200.328 and 31 CFR Section 354(c), the federal program requires quarterly and annual project and expenditure reporting be submitted to the granting oversight agency. Condition ‐ We requested copies of the submitted reports and supporting documentation for the year under audit in order to perform the compliance testing. These items could not be reproduced to verify that the reporting was submitted as required under the audit. Cause ‐ The Organization did not have proper procedures to ensure preparation and submission of the required reporting under the federal award. Effect ‐ The deficiency in internal controls resulted in material noncompliance to the Organization. Questioned Costs ‐ None reported. Context/Sampling ‐ No sampling was performed as supporting documentation to allow for testing of the reporting requirement was unavailable. Recommendation ‐ We recommend the Organization update its policies and procedures to allow for the proper identification of all reporting requirements, preparation and review of reports to be submitted, and accumulation of appropriate supporting documentation and schedules. Views of Responsible Officials ‐ Management is in agreement with the finding. Repeat Finding – This is a not a repeat finding.
Information on the Federal Program: Coronavirus State and Local Fiscal Recovery Funds (SLFRF) – 21.027 Compliance Requirements: Reporting – Timely Submission Type of Finding: Significant deficiency. Criteria: In accordance with 2 CFR 200.328 and the U.S. Department of the Treasury’s SLFRF Compliance and Reporting Guidance, recipients must submit accurate and timely Project and Expenditure Reports by the due dates established by Treasury. Additionally, under 2 CFR 200.303, recipients must establish and maintain effective internal controls over compliance with federal award requirements. Condition: The County did not submit two quarterly Project & Expenditure Reports to the U.S. Department of the Treasury within the required deadlines during 2023 for the SLFRF program. Questioned Costs: $0 Effect: Noncompliance with federal reporting requirements. However, the reports were ultimately submitted and accepted. Cause: Internal control process failure. Repeat Finding: No Recommendation: Management should implement procedures to ensure timely submission of all required SLFRF reports. Management’s Response: We agree with this finding and recommendation. Please see attached action plan related to this finding in this report.
Reporting Finding Number: 2023-004 Assistance Listing Number and Title: AL # 14.871 - Section 8 Housing Choice Vouchers/Housing Voucher Cluster Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Housing and Urban Development Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? Yes Prior Audit Finding Number: 2022-005 Noncompliance and Material Weakness 2 CFR § 2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR § 200.328 which provides that, 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. 24 CFR § 5.801 (d)(1) provides that unaudited financial statements will be required 60 days after the PHA's fiscal year end, and audited financial statements will then be required no later than 9 months after the PHA's fiscal year end, in accordance with the Single Audit Act and 2 CFR part 200, subpart F. In addition, 24 CFR § 5.801 (b)(1) provides that entities to which this subpart is applicable must provide to HUD such financial information as required by HUD prepared in accordance with Generally Accepted Accounting Principles (GAAP). The Authority submitted its audited submission for the year ended December 31, 2022 in the Financial Assessment Sub-system (FASS-PH) on October 30, 2024. The Authority had received a ninety-two-day extension until December 31, 2023. This submission was not within the required timeframes or extension. The delays in submissions were due to investigations into fraudulent transactions by the former Executive Director. The failure to timely submit the required financial information reduces the U.S. Department of Housing and Urban Development’s ability to monitor subrecipients. The Authority should continue working with their compiler and auditors to rectify the accounting issues resulting from the actions of the former Executive Director. Once that is completed, the Authority should timely remit the required reports.
Reporting Finding Number: 2023-004 Assistance Listing Number and Title: AL # 14.871 - Section 8 Housing Choice Vouchers/Housing Voucher Cluster Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Housing and Urban Development Compliance Requirement: Reporting Pass-Through Entity: N/A Repeat Finding from Prior Audit? Yes Prior Audit Finding Number: 2022-005 Noncompliance and Material Weakness 2 CFR § 2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR § 200.328 which provides that, 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. 24 CFR § 5.801 (d)(1) provides that unaudited financial statements will be required 60 days after the PHA's fiscal year end, and audited financial statements will then be required no later than 9 months after the PHA's fiscal year end, in accordance with the Single Audit Act and 2 CFR part 200, subpart F. In addition, 24 CFR § 5.801 (b)(1) provides that entities to which this subpart is applicable must provide to HUD such financial information as required by HUD prepared in accordance with Generally Accepted Accounting Principles (GAAP). The Authority submitted its audited submission for the year ended December 31, 2022 in the Financial Assessment Sub-system (FASS-PH) on October 30, 2024. The Authority had received a ninety-two-day extension until December 31, 2023. This submission was not within the required timeframes or extension. The delays in submissions were due to investigations into fraudulent transactions by the former Executive Director. The failure to timely submit the required financial information reduces the U.S. Department of Housing and Urban Development’s ability to monitor subrecipients. The Authority should continue working with their compiler and auditors to rectify the accounting issues resulting from the actions of the former Executive Director. Once that is completed, the Authority should timely remit the required reports.
2 CFR § 1000 gives regulatory effect to the United States Department of Treasury for 2 CFR § 200.328 and 200.329(c)(1) which states, in part, that 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. Testing over the Village's quarterly reporting requirements for the SLFRF program identified only one quarterly report being submitted on September 9, 2022 which was prior to any SLFRF funding expenditures being made. The SLFRF funding expenditures began on February 2, 2023 with no additional quarterly reports submitted. The Village was unable to provide support to show that the Final Reporting requirement was met. Failure to timely submit the required reports to the pass-through entity could result in material noncompliance and potential loss of future funding.
Criteria: 2 CFR 200.328 (financial and performance reporting) and the terms and conditions of the U.S. Department of the Treasury SLFRF award (ALN 21.027) as administered by the City of Chicago Department of Family & Support Services (DFSS). Required program reports must be complete, accurate, and submitted by the specified due dates. Condition: During the audit period ended December 31, 2023, certain required SYEP program reports were submitted after their due dates. One report required resubmission due to errors identified during review. Cause: A centralized compliance calendar and documented pre‑submission review process were not in place; responsibilities and deadlines were not consistently tracked across program and finance staff. Effect: Noncompliance with reporting requirements increased the risk of delayed reimbursements and impaired management and grantor oversight. Questioned Costs: None were identified. Context: Reporting deviations occurred during 2023 for ALN 21.027 (SYEP). Other reports reviewed were timely and supported by the underlying records. Recommendation: Establish and maintain a Uniform Guidance compliance calendar; implement a pre‑submission peer review checklist that ties reports to the general ledger/SEFA; standardize reporting templates; and provide training to staff on 2 CFR 200 and DFSS contract reporting requirements. Views of Responsible Officials: Management concurs with the finding and has implemented the corrective actions described in the Corrective Action Plan for Finding 2023‑002, including a reporting calendar, pre‑submission reviews, standardized templates, automated reminders, and staff training.
Criteria: 2 CFR 200.328 (financial and performance reporting) and the terms and conditions of the U.S. Department of the Treasury SLFRF award (ALN 21.027) as administered by the City of Chicago Department of Family & Support Services (DFSS). Required program reports must be complete, accurate, and submitted by the specified due dates. Condition: During the audit period ended December 31, 2023, certain required SYEP program reports were submitted after their due dates. One report required resubmission due to errors identified during review. Cause: A centralized compliance calendar and documented pre‑submission review process were not in place; responsibilities and deadlines were not consistently tracked across program and finance staff. Effect: Noncompliance with reporting requirements increased the risk of delayed reimbursements and impaired management and grantor oversight. Questioned Costs: None were identified. Context: Reporting deviations occurred during 2023 for ALN 21.027 (SYEP). Other reports reviewed were timely and supported by the underlying records. Recommendation: Establish and maintain a Uniform Guidance compliance calendar; implement a pre‑submission peer review checklist that ties reports to the general ledger/SEFA; standardize reporting templates; and provide training to staff on 2 CFR 200 and DFSS contract reporting requirements. Views of Responsible Officials: Management concurs with the finding and has implemented the corrective actions described in the Corrective Action Plan for Finding 2023‑002, including a reporting calendar, pre‑submission reviews, standardized templates, automated reminders, and staff training.
Department of Transportation Federal Financial Assistance Listing 20.106; Awards AIP3‐46‐0050‐54, AIP3‐46‐0050‐59, AIP3‐46‐0050‐60, and AIP3‐46‐0050‐62. COVID‐19 Airport Improvement Program Reporting Significant Deficiency in Internal Control over Compliance Criteria ‐ 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal controls over the federal awards that provide assurance that the entity is managing the federal awards in compliance with federal statutes, regulations, and the conditions of the federal award. 2 CFR 200.327 and 2 CFR 200.328 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with the program requirements. Condition ‐ The SF‐425 annual report dated September 30, 2023, for award AIP3‐46‐0050‐54 underreported the federal share of expenditures by $80,133, while the FAA Form 5100‐127 annual report dated December 31, 2022, for all awards underreported the externally restricted assets by $397,646. Cause ‐ The Authority does not have an internal control structure designed to ensure amounts reported on SF‐425 and FAA Form 5100‐127 reports are adequately reviewed and agree to underlying accounting records. Effect ‐ Lack of compliance with designed internal controls over reporting could result in the Authority reporting incorrect or incomplete information. Questioned Costs ‐ None reported. Context/Sampling ‐ A nonstatistical sample of 10 reports out of 31 reports. Repeat Finding from Prior Year – Yes, prior year finding 2022‐002 Recommendation ‐ Management should determine and formalize reporting responsibilities between the Airport and the State and establish review processes to ensure that amounts included in SF‐425 and FAA Form 5100‐127 reports agree with the underlying accounting records. Views of Responsible Officials ‐ Management agrees with the finding.
Department of Transportation Federal Financial Assistance Listing 20.106; Awards AIP3‐46‐0050‐54, AIP3‐46‐0050‐59, AIP3‐46‐0050‐60, and AIP3‐46‐0050‐62. COVID‐19 Airport Improvement Program Reporting Significant Deficiency in Internal Control over Compliance Criteria ‐ 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal controls over the federal awards that provide assurance that the entity is managing the federal awards in compliance with federal statutes, regulations, and the conditions of the federal award. 2 CFR 200.327 and 2 CFR 200.328 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with the program requirements. Condition ‐ The SF‐425 annual report dated September 30, 2023, for award AIP3‐46‐0050‐54 underreported the federal share of expenditures by $80,133, while the FAA Form 5100‐127 annual report dated December 31, 2022, for all awards underreported the externally restricted assets by $397,646. Cause ‐ The Authority does not have an internal control structure designed to ensure amounts reported on SF‐425 and FAA Form 5100‐127 reports are adequately reviewed and agree to underlying accounting records. Effect ‐ Lack of compliance with designed internal controls over reporting could result in the Authority reporting incorrect or incomplete information. Questioned Costs ‐ None reported. Context/Sampling ‐ A nonstatistical sample of 10 reports out of 31 reports. Repeat Finding from Prior Year – Yes, prior year finding 2022‐002 Recommendation ‐ Management should determine and formalize reporting responsibilities between the Airport and the State and establish review processes to ensure that amounts included in SF‐425 and FAA Form 5100‐127 reports agree with the underlying accounting records. Views of Responsible Officials ‐ Management agrees with the finding.
Department of Transportation Federal Financial Assistance Listing 20.106; Awards AIP3‐46‐0050‐54, AIP3‐46‐0050‐59, AIP3‐46‐0050‐60, and AIP3‐46‐0050‐62. COVID‐19 Airport Improvement Program Reporting Significant Deficiency in Internal Control over Compliance Criteria ‐ 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal controls over the federal awards that provide assurance that the entity is managing the federal awards in compliance with federal statutes, regulations, and the conditions of the federal award. 2 CFR 200.327 and 2 CFR 200.328 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with the program requirements. Condition ‐ The SF‐425 annual report dated September 30, 2023, for award AIP3‐46‐0050‐54 underreported the federal share of expenditures by $80,133, while the FAA Form 5100‐127 annual report dated December 31, 2022, for all awards underreported the externally restricted assets by $397,646. Cause ‐ The Authority does not have an internal control structure designed to ensure amounts reported on SF‐425 and FAA Form 5100‐127 reports are adequately reviewed and agree to underlying accounting records. Effect ‐ Lack of compliance with designed internal controls over reporting could result in the Authority reporting incorrect or incomplete information. Questioned Costs ‐ None reported. Context/Sampling ‐ A nonstatistical sample of 10 reports out of 31 reports. Repeat Finding from Prior Year – Yes, prior year finding 2022‐002 Recommendation ‐ Management should determine and formalize reporting responsibilities between the Airport and the State and establish review processes to ensure that amounts included in SF‐425 and FAA Form 5100‐127 reports agree with the underlying accounting records. Views of Responsible Officials ‐ Management agrees with the finding.
Department of Transportation Federal Financial Assistance Listing 20.106; Awards AIP3‐46‐0050‐54, AIP3‐46‐0050‐59, AIP3‐46‐0050‐60, and AIP3‐46‐0050‐62. COVID‐19 Airport Improvement Program Reporting Significant Deficiency in Internal Control over Compliance Criteria ‐ 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal controls over the federal awards that provide assurance that the entity is managing the federal awards in compliance with federal statutes, regulations, and the conditions of the federal award. 2 CFR 200.327 and 2 CFR 200.328 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with the program requirements. Condition ‐ The SF‐425 annual report dated September 30, 2023, for award AIP3‐46‐0050‐54 underreported the federal share of expenditures by $80,133, while the FAA Form 5100‐127 annual report dated December 31, 2022, for all awards underreported the externally restricted assets by $397,646. Cause ‐ The Authority does not have an internal control structure designed to ensure amounts reported on SF‐425 and FAA Form 5100‐127 reports are adequately reviewed and agree to underlying accounting records. Effect ‐ Lack of compliance with designed internal controls over reporting could result in the Authority reporting incorrect or incomplete information. Questioned Costs ‐ None reported. Context/Sampling ‐ A nonstatistical sample of 10 reports out of 31 reports. Repeat Finding from Prior Year – Yes, prior year finding 2022‐002 Recommendation ‐ Management should determine and formalize reporting responsibilities between the Airport and the State and establish review processes to ensure that amounts included in SF‐425 and FAA Form 5100‐127 reports agree with the underlying accounting records. Views of Responsible Officials ‐ Management agrees with the finding.
Section III – Federal Award Findings and Questioned Costs Finding #2023-001: Program Title: Early Head Start Childcare Partnership Assistance Listing: 93.600 Contract Grant Number:06-HP000201-03 Federal Award Years: July 1, 2022 to June 30, 2023 Federal Agency: U.S. Department of Health and Human Services Allowable Costs and Reporting Type of Finding: Questioned Cost and Other Noncompliance Criteria: The 2 CFR part 200 establishes costs principles for determining costs applicable to Federal Award and requires costs be adequately documented. In addition, 2 CFR section 200.328 establishes financial information be reported in accordance with terms and conditions of the federal award. This award is subject to the requirements set forth in 45 CFR Part 75, which defines unliquidated obligations as obligations incurred for direct and indirect expenses incurred but not yet paid or charged to the award and does not include a future commitment of funds for which an obligation or expense has not been incurred. Condition: Based on procedures performed, we identified expenditures recorded for future program expenses totaling $160,597 not yet obligated or incurred. As a result, amounts unspent were improperly reported as unliquidated obligations on the federal financial report for the budget period ended June 30, 2023. Questioned Costs: Based on review of accounting records and reconciliation of unused federal funds prepared by Family Service, we identified questioned costs totaling $160,597 for the Early Head Start program. Cause: Lack of documentation to support costs were obligated or incurred for direct or indirect program expense for Early Head Start prior to the end of the budget period. In addition, Family Service did not request an extension for additional time to use unspent funds on future program expenses. Effect: Noncompliance with Allowable Costs and Reporting compliance requirements of the Uniform Guidance and terms and conditions of the federal award. Repeat Finding: No Recommendation: We recommend Family Service improve procedures for tracking, reporting, and use of obligated and/or unspent funds to ensure compliance with the compliance requirements and terms and conditions of the federal award. Views of responsible officials: Management agrees with the recommendations to improve tracking and reporting of obligated and/or use of unspent funds to conform with the compliance requirements and terms and conditions of the federal award. Unfortunately, the advanced funds drawn for building remodeling and maintenance were unspent because of serious delays due to systemic problems with obtaining certificates of occupancy and permits in a timely manner.
Finding Number: 2023-004 Federal Program: Airport Improvement Program Federal Award Identification Number and Year: All Airport Improvement Program awards, 2020, 2021, 2022, 2023 Assistance Listing Number (ALN): 20.106 Federal Awarding Agency: U.S. Department of Transportation Pass-through Entity: None Repeat Finding: No Material Weakness and Noncompliance – Reporting Criteria: Unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMBapproved 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. (2 CFR 200.328). Until the grant is completed and closed, recipients are responsible for submitting formal reports as follows: A signed/dated SF-270 (non-construction projects) or SF-271 or equivalent (construction projects) and SF- 425 annually, due 90 days after the end of each federal fiscal year in which this grant is open (due December 31 of each year this grant is open). Condition: The Airport did not file the required reports within the timeframes above. Questioned Costs: None. Identification of How Questioned Costs Were Computed: N/A Context: Standard Forms 425 and Standard Forms 271 for the reporting period ended September 30, 2023 were filed on January 19, 2024. Cause and Effect: The Airport did not prepare or submit the required forms by December 31, 2023. The SF-425 and SF-271 reports for the period ending September 30, 2023 were submitted 19 days after the due date. Recommendation: The Airport should implement controls and processes to ensure that the required reports are submitted timely. Views of Responsible Officials and Corrective Action Plan: See Corrective Action Plan.
Finding Number: 2023-004 Federal Program: Airport Improvement Program Federal Award Identification Number and Year: All Airport Improvement Program awards, 2020, 2021, 2022, 2023 Assistance Listing Number (ALN): 20.106 Federal Awarding Agency: U.S. Department of Transportation Pass-through Entity: None Repeat Finding: No Material Weakness and Noncompliance – Reporting Criteria: Unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMBapproved 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. (2 CFR 200.328). Until the grant is completed and closed, recipients are responsible for submitting formal reports as follows: A signed/dated SF-270 (non-construction projects) or SF-271 or equivalent (construction projects) and SF- 425 annually, due 90 days after the end of each federal fiscal year in which this grant is open (due December 31 of each year this grant is open). Condition: The Airport did not file the required reports within the timeframes above. Questioned Costs: None. Identification of How Questioned Costs Were Computed: N/A Context: Standard Forms 425 and Standard Forms 271 for the reporting period ended September 30, 2023 were filed on January 19, 2024. Cause and Effect: The Airport did not prepare or submit the required forms by December 31, 2023. The SF-425 and SF-271 reports for the period ending September 30, 2023 were submitted 19 days after the due date. Recommendation: The Airport should implement controls and processes to ensure that the required reports are submitted timely. Views of Responsible Officials and Corrective Action Plan: See Corrective Action Plan.
Finding Number: 2023-004 Federal Program: Airport Improvement Program Federal Award Identification Number and Year: All Airport Improvement Program awards, 2020, 2021, 2022, 2023 Assistance Listing Number (ALN): 20.106 Federal Awarding Agency: U.S. Department of Transportation Pass-through Entity: None Repeat Finding: No Material Weakness and Noncompliance – Reporting Criteria: Unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMBapproved 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. (2 CFR 200.328). Until the grant is completed and closed, recipients are responsible for submitting formal reports as follows: A signed/dated SF-270 (non-construction projects) or SF-271 or equivalent (construction projects) and SF- 425 annually, due 90 days after the end of each federal fiscal year in which this grant is open (due December 31 of each year this grant is open). Condition: The Airport did not file the required reports within the timeframes above. Questioned Costs: None. Identification of How Questioned Costs Were Computed: N/A Context: Standard Forms 425 and Standard Forms 271 for the reporting period ended September 30, 2023 were filed on January 19, 2024. Cause and Effect: The Airport did not prepare or submit the required forms by December 31, 2023. The SF-425 and SF-271 reports for the period ending September 30, 2023 were submitted 19 days after the due date. Recommendation: The Airport should implement controls and processes to ensure that the required reports are submitted timely. Views of Responsible Officials and Corrective Action Plan: See Corrective Action Plan.
Finding Number: 2023-004 Federal Program: Airport Improvement Program Federal Award Identification Number and Year: All Airport Improvement Program awards, 2020, 2021, 2022, 2023 Assistance Listing Number (ALN): 20.106 Federal Awarding Agency: U.S. Department of Transportation Pass-through Entity: None Repeat Finding: No Material Weakness and Noncompliance – Reporting Criteria: Unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMBapproved 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. (2 CFR 200.328). Until the grant is completed and closed, recipients are responsible for submitting formal reports as follows: A signed/dated SF-270 (non-construction projects) or SF-271 or equivalent (construction projects) and SF- 425 annually, due 90 days after the end of each federal fiscal year in which this grant is open (due December 31 of each year this grant is open). Condition: The Airport did not file the required reports within the timeframes above. Questioned Costs: None. Identification of How Questioned Costs Were Computed: N/A Context: Standard Forms 425 and Standard Forms 271 for the reporting period ended September 30, 2023 were filed on January 19, 2024. Cause and Effect: The Airport did not prepare or submit the required forms by December 31, 2023. The SF-425 and SF-271 reports for the period ending September 30, 2023 were submitted 19 days after the due date. Recommendation: The Airport should implement controls and processes to ensure that the required reports are submitted timely. Views of Responsible Officials and Corrective Action Plan: See Corrective Action Plan.
Finding Number: 2023-004 Federal Program: Airport Improvement Program Federal Award Identification Number and Year: All Airport Improvement Program awards, 2020, 2021, 2022, 2023 Assistance Listing Number (ALN): 20.106 Federal Awarding Agency: U.S. Department of Transportation Pass-through Entity: None Repeat Finding: No Material Weakness and Noncompliance – Reporting Criteria: Unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMBapproved 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. (2 CFR 200.328). Until the grant is completed and closed, recipients are responsible for submitting formal reports as follows: A signed/dated SF-270 (non-construction projects) or SF-271 or equivalent (construction projects) and SF- 425 annually, due 90 days after the end of each federal fiscal year in which this grant is open (due December 31 of each year this grant is open). Condition: The Airport did not file the required reports within the timeframes above. Questioned Costs: None. Identification of How Questioned Costs Were Computed: N/A Context: Standard Forms 425 and Standard Forms 271 for the reporting period ended September 30, 2023 were filed on January 19, 2024. Cause and Effect: The Airport did not prepare or submit the required forms by December 31, 2023. The SF-425 and SF-271 reports for the period ending September 30, 2023 were submitted 19 days after the due date. Recommendation: The Airport should implement controls and processes to ensure that the required reports are submitted timely. Views of Responsible Officials and Corrective Action Plan: See Corrective Action Plan.
Finding Number: 2023-004 Federal Program: Airport Improvement Program Federal Award Identification Number and Year: All Airport Improvement Program awards, 2020, 2021, 2022, 2023 Assistance Listing Number (ALN): 20.106 Federal Awarding Agency: U.S. Department of Transportation Pass-through Entity: None Repeat Finding: No Material Weakness and Noncompliance – Reporting Criteria: Unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMBapproved 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. (2 CFR 200.328). Until the grant is completed and closed, recipients are responsible for submitting formal reports as follows: A signed/dated SF-270 (non-construction projects) or SF-271 or equivalent (construction projects) and SF- 425 annually, due 90 days after the end of each federal fiscal year in which this grant is open (due December 31 of each year this grant is open). Condition: The Airport did not file the required reports within the timeframes above. Questioned Costs: None. Identification of How Questioned Costs Were Computed: N/A Context: Standard Forms 425 and Standard Forms 271 for the reporting period ended September 30, 2023 were filed on January 19, 2024. Cause and Effect: The Airport did not prepare or submit the required forms by December 31, 2023. The SF-425 and SF-271 reports for the period ending September 30, 2023 were submitted 19 days after the due date. Recommendation: The Airport should implement controls and processes to ensure that the required reports are submitted timely. Views of Responsible Officials and Corrective Action Plan: See Corrective Action Plan.
Finding Number: 2023-004 Federal Program: Airport Improvement Program Federal Award Identification Number and Year: All Airport Improvement Program awards, 2020, 2021, 2022, 2023 Assistance Listing Number (ALN): 20.106 Federal Awarding Agency: U.S. Department of Transportation Pass-through Entity: None Repeat Finding: No Material Weakness and Noncompliance – Reporting Criteria: Unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMBapproved 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. (2 CFR 200.328). Until the grant is completed and closed, recipients are responsible for submitting formal reports as follows: A signed/dated SF-270 (non-construction projects) or SF-271 or equivalent (construction projects) and SF- 425 annually, due 90 days after the end of each federal fiscal year in which this grant is open (due December 31 of each year this grant is open). Condition: The Airport did not file the required reports within the timeframes above. Questioned Costs: None. Identification of How Questioned Costs Were Computed: N/A Context: Standard Forms 425 and Standard Forms 271 for the reporting period ended September 30, 2023 were filed on January 19, 2024. Cause and Effect: The Airport did not prepare or submit the required forms by December 31, 2023. The SF-425 and SF-271 reports for the period ending September 30, 2023 were submitted 19 days after the due date. Recommendation: The Airport should implement controls and processes to ensure that the required reports are submitted timely. Views of Responsible Officials and Corrective Action Plan: See Corrective Action Plan.
Finding Number: 2023-004 Federal Program: Airport Improvement Program Federal Award Identification Number and Year: All Airport Improvement Program awards, 2020, 2021, 2022, 2023 Assistance Listing Number (ALN): 20.106 Federal Awarding Agency: U.S. Department of Transportation Pass-through Entity: None Repeat Finding: No Material Weakness and Noncompliance – Reporting Criteria: Unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMBapproved 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. (2 CFR 200.328). Until the grant is completed and closed, recipients are responsible for submitting formal reports as follows: A signed/dated SF-270 (non-construction projects) or SF-271 or equivalent (construction projects) and SF- 425 annually, due 90 days after the end of each federal fiscal year in which this grant is open (due December 31 of each year this grant is open). Condition: The Airport did not file the required reports within the timeframes above. Questioned Costs: None. Identification of How Questioned Costs Were Computed: N/A Context: Standard Forms 425 and Standard Forms 271 for the reporting period ended September 30, 2023 were filed on January 19, 2024. Cause and Effect: The Airport did not prepare or submit the required forms by December 31, 2023. The SF-425 and SF-271 reports for the period ending September 30, 2023 were submitted 19 days after the due date. Recommendation: The Airport should implement controls and processes to ensure that the required reports are submitted timely. Views of Responsible Officials and Corrective Action Plan: See Corrective Action Plan.
Reporting Fiscal year ending :2023 Federal Program: Head Start 93.600 Questioned Costs: None Condition: During our audit, we noted that the Head Start program did not submit the required semi-annual form 425 and form 429 reports within the specified deadlines. The reports for the were submitted 10 and 15 days late, respectively. Criteria: According to 2 CFR Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), specifically 2 CFR § 200.328, recipients of federal awards must submit performance and financial reports to the federal awarding agency in a timely manner. The specific reporting deadlines are outlined in the award terms and conditions. Cause:The delay in submitting the reports was due to insufficient internal controls over the reporting process. Specifically, there was a lack of adequate staff training on the reporting requirements and no established procedures to ensure timely submission. Effect: Non-compliance with reporting requirements can result in delayed funding, reduced confidence from the federal awarding agency, and potential negative impacts on program operations. Continued noncompliance may also lead to more severe consequences such as the suspension of funding. Recommendation: We recommend that the Head Start program management take the requirements: Implement a formalized reporting schedule with clearly defined deadlines, establish a review process to verify the accuracy and timeliness of reports before submission and assign specific staff members to oversee compliance with reporting requirements. View of Responsible Officals: We will take the necessary steps to get clear deadlines from the awarding agency on the reporting dates for Head Start and update our formal reporting schedule with those dates. The Head Start Fund Accountant will work with the Administrative Assistant/Facilities Manager in gathering the necessary information earlier in the year for the yearly property reporting (SF-429). The Head Start Fund Accountant will email copies of these reports to the Director of Head Start to ensure compliance.
Reporting Fiscal year ending :2023 Federal Program: Head Start 93.600 Questioned Costs: None Condition: During our audit, we noted that the Head Start program did not submit the required semi-annual form 425 and form 429 reports within the specified deadlines. The reports for the were submitted 10 and 15 days late, respectively. Criteria: According to 2 CFR Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), specifically 2 CFR § 200.328, recipients of federal awards must submit performance and financial reports to the federal awarding agency in a timely manner. The specific reporting deadlines are outlined in the award terms and conditions. Cause:The delay in submitting the reports was due to insufficient internal controls over the reporting process. Specifically, there was a lack of adequate staff training on the reporting requirements and no established procedures to ensure timely submission. Effect: Non-compliance with reporting requirements can result in delayed funding, reduced confidence from the federal awarding agency, and potential negative impacts on program operations. Continued noncompliance may also lead to more severe consequences such as the suspension of funding. Recommendation: We recommend that the Head Start program management take the requirements: Implement a formalized reporting schedule with clearly defined deadlines, establish a review process to verify the accuracy and timeliness of reports before submission and assign specific staff members to oversee compliance with reporting requirements. View of Responsible Officals: We will take the necessary steps to get clear deadlines from the awarding agency on the reporting dates for Head Start and update our formal reporting schedule with those dates. The Head Start Fund Accountant will work with the Administrative Assistant/Facilities Manager in gathering the necessary information earlier in the year for the yearly property reporting (SF-429). The Head Start Fund Accountant will email copies of these reports to the Director of Head Start to ensure compliance.
Information on the Federal Program: Assistance Listing Number 21.027 – Coronavirus State and Local Fiscal Recovery Funds. Compliance Requirement: Reporting. Type of Finding: Significant deficiency in internal control over major federal programs. Criteria: The Uniform Guidance at 2 CFR 200.328 requires certain recipients of Coronavirus State and Local Fiscal Recovery Funds to submit quarterly and annual project and expenditure reports to the U.S. Department of the Treasury including, but not limited to, total obligations of funds, total expenditures of funds, and total number of projects. Condition: We noted that multiple quarterly reports did not accurately report total expenditures as of the date of the reporting period. Cause: Tracking spreadsheets were not appropriately updated to capture all expenditures of federal funds. Effect or Potential Effect: The County has a significant deficiency in internal control with respect to reporting of federal expenditures. Recommendation: Controls should require a secondary review and reconciliation of quarterly and annual reports to the County’s general ledger prior to submission by the grant director.
Section III – Federal Award Findings and Questioned Costs 2023-001: Compliance with Reporting Requirements (Repeat Finding) Federal Agency: Department of Health and Human Services (“HHS”), Health Resources and Services Administration (“HRSA”) Assistance Listing Program Title: Congressional Directives Federal Award Project Title: Community Project Funding/ Congressionally Directed Spending ‐ Construction Assistance Listing Number: 93.493 Federal Award Identification Number: CE146567 Criteria In accordance with 2 CFR 200.328 and the notice of award (“NoA”), there are financial and other reporting requirements that the entity must complete and submit to HHS. The NoA has the following financial and other reporting requirements that were subject to testing: 1. Within 90 days of project completion, a final report is required to be submitted. The project was completed on July 28, 2023 and the final report was required to be submitted by October 26, 2023; 2. A semi-annual progress report is required to be submitted every May and December until the project is completed. The first semi-annual progress report was due December 14, 2023 and; 3. The recipient must submit an annual Federal Financial Report (“FFR”), due October 30, 2023 for the annual period August 1, 2022 to July 31, 2023. Condition The conditions of the noncompliance identified are as follows: 4. The final report, due by October 26, 2023, was not submitted to HHS until August 13, 2024. 2. As the final report was not yet completed, the December semi-annual report was required to be submitted. The semi-annual report was submitted December 21, 2023, which was past the stated deadline of December 14, 2023. 3. The FFR submitted on October 24, 2023 for the period ended July 31, 2023 included $0 of federal expenditures when $749,892 of federal expenditures were incurred through the period ended July 31, 2023 based on our review of the underlying expenditure detail. Questioned Costs None Cause Management did not have an adequate understanding of the reporting requirements of the award and the control was not designed to ensure that reports were completed and submitted to the agency in a timely manner. Effect The late submission of the final report and the December 2023 semi-annual report and the submission of inaccurate financial data in the annual FFR causes Flushing to be out of compliance with specific grant reporting requirements. Recommendation We recommend Flushing enhance its control around the monitoring of grant reporting requirements, including evaluating report due dates, confirming reporting requirements with the granting agency as appropriate, and performing reviews prior to submission to ensure all reports are being completed accurately and submitted in a timely manner. Management’s Views and Corrective Action Plan Management’s Views and Corrective Action Plan is included at the end of this report.
Finding Number 2023-002 Assistance Listing #21.027 Coronavirus State and Local Fiscal Recovery Funds (SLFRF) Reporting Immaterial Noncompliance Criteria: In accordance with 2 CFR 200.328 and 31 CFR section 35.4(c) Reporting and requests for other information, grantees are required to file quarterly Project and Expenditure Reports listing significant projects, significant payments to subrecipients, subawards, and expenditure awards greater than $50,000. Condition: The Tribe incorrectly listed some project vendors as a subrecipients on the Project and Expenditure reports. Cause: Treasury guidance for reporting subrecipients versus contractors was in transition during the reporting periods for the year. Effect: The Tribe reported subrecipients on the Project and Expenditures Reports, but did not have any subrecipients of Coronavirus State and Local Fiscal Recovery Funds (SLFRF). Recommendation: Update reporting to ensure payments are reported as project vendors rather than subrecipients. Management's Response: Management recognizes that the error exists and has not been able to correct the report due to US Treasury’s portal not accepting prior period revisions. Treasury has changed its guidance on SLFRF multiple times over the past several years which has created an increased risk in filing errors for all reporting for these funds..
Finding Number: 2023-003 Federal Program: CDBG – Entitlement Grants Cluster Federal Award Identification Number and Year: B-22-MC-39-0001, 2022; B-20-MW-39-0001, 2020 Assistance Listing Number (ALN): 14.218 Federal Awarding Agency: Department of Housing and Urban Development Pass-through Entity: None Repeat Finding: No Material Weakness and Noncompliance – Reporting Criteria: 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. (2 CFR 200.328). The Quarterly Cash on Hand report must be submitted to the respective field office within 30 days after the end of the reporting period. Condition: The City did not file the required reports within the timeframes above. Questioned Costs: None. Identification of How Questioned Costs Were Computed: N/A Context: The City submitted its Quarter 3 financial reports due July 30, 2023 on August 4, 2023. Cause and Effect: The City did not submit the required financial reports within the required timeframe. Recommendation: The City should implement controls and processes to ensure that the required reports are submitted timely. Views of Responsible Officials and Corrective Action Plan: See Corrective Action Plan.
Finding Number: 2023-003 Federal Program: CDBG – Entitlement Grants Cluster Federal Award Identification Number and Year: B-22-MC-39-0001, 2022; B-20-MW-39-0001, 2020 Assistance Listing Number (ALN): 14.218 Federal Awarding Agency: Department of Housing and Urban Development Pass-through Entity: None Repeat Finding: No Material Weakness and Noncompliance – Reporting Criteria: 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. (2 CFR 200.328). The Quarterly Cash on Hand report must be submitted to the respective field office within 30 days after the end of the reporting period. Condition: The City did not file the required reports within the timeframes above. Questioned Costs: None. Identification of How Questioned Costs Were Computed: N/A Context: The City submitted its Quarter 3 financial reports due July 30, 2023 on August 4, 2023. Cause and Effect: The City did not submit the required financial reports within the required timeframe. Recommendation: The City should implement controls and processes to ensure that the required reports are submitted timely. Views of Responsible Officials and Corrective Action Plan: See Corrective Action Plan.
Finding Number: 2023-002 Federal Program: Staffing for Adequate Fire and Emergency Response 2020 Federal Award Identification Number and Year: EMW-2020-FF-00837, 2021 Assistance Listing Number (ALN): 97.083 Federal Awarding Agency: Federal Emergency Management Agency Pass-through Entity: None Repeat Finding: No Material Weakness and Noncompliance – Reporting Criteria: 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. (2 CFR 200.328). Programmatic reports must be submitted through the Federal Emergency Management Agency’s (FEMA) GO portal no later than January 30 (for the period of July 1 – December 31) and no later than July 30 (for the period of January 1 – June 30). (FEMA Grant Programs Directorate Information Bulletin Number 468, dated April 4, 2022). Condition: The City did not file the required reports within the timeframes above. Questioned Costs: None. Identification of How Questioned Costs Were Computed: N/A Context: The City submitted its programmatic report due July 30, 2023 on December 1, 2023. The City submitted its programmatic report due January 30, 2024 on March 30, 2024. Cause and Effect: The City did not submit the required programmatic reports within the required timeframes. Recommendation: The City should implement controls and processes to ensure that the required reports are submitted timely. Views of Responsible Officials and Corrective Action Plan: See Corrective Action Plan.
2 CFR § 200.328 provides the Federal awarding agency may solicit only the standard, OMB-approved governmentwide data elements for collection of financial information. This information must be collected with the frequency required by the terms and conditions of the Federal award.The American Rescue Plan Act Statewide Planning Award states that Grantee shall submit to Grantor Project Progress Reports. Grantee agrees to provide Grantor with project progress reports, communicating the important activities and accomplishments of the project, on a semi-annual basis for the period ending March 31 and September 30, or any portion thereof, for the entire project period. Reports are due no later than two weeks following the end of the semi-annual period. Reports shall be in clear format, not exceeding six pages, and shall: i. Document accomplishments, benefits, and impacts of the project. The Grantee should identify activities that have led to specific outcomes, such as job creation/retention, private investment, increased regional collaboration, engagement with historically excluded groups or regions, enhanced regional capacity, or other positive economic development benefits; ii. Identify any upcoming or potential press events or opportunities for collaborative press engagement to highlight the benefits of the award investment; iii. Compare progress on the project with the targeted schedule, explaining nay departures, identifying how those departures will be remedied, and projecting the course of work for the next semi-annual reporting period; iv. Outline challenges impending or that my impede progress on the project over the next semi-annual reporting period and identify ways to address those challenges; v. Outline any areas in which assistance is needed to support the project; and vi. Provide any other information that would be helpful for Grantor to know.The Project Progress Report for the semi-annual basis for the period ending March 31 contained the required information; however, due to insufficient controls over ensuring reports are submitted by the required due date, it was not submitted timely within the two weeks following the end of the semi-annual period and was submitted on October 16, 2023, six months late by the Commission.Failure to submit reports on a timely basis could result in delays in federal funding or other penalties and sanctions.The Commission should ensure that all federal reports are submitted timely.
2 CFR § 200.328 provides the Federal awarding agency may solicit only the standard, OMB-approved governmentwide data elements for collection of financial information. This information must be collected with the frequency required by the terms and conditions of the Federal award.The American Rescue Plan Act Statewide Planning Award states that Grantee shall submit to Grantor Project Progress Reports. Grantee agrees to provide Grantor with project progress reports, communicating the important activities and accomplishments of the project, on a semi-annual basis for the period ending March 31 and September 30, or any portion thereof, for the entire project period. Reports are due no later than two weeks following the end of the semi-annual period. Reports shall be in clear format, not exceeding six pages, and shall: i. Document accomplishments, benefits, and impacts of the project. The Grantee should identify activities that have led to specific outcomes, such as job creation/retention, private investment, increased regional collaboration, engagement with historically excluded groups or regions, enhanced regional capacity, or other positive economic development benefits; ii. Identify any upcoming or potential press events or opportunities for collaborative press engagement to highlight the benefits of the award investment; iii. Compare progress on the project with the targeted schedule, explaining nay departures, identifying how those departures will be remedied, and projecting the course of work for the next semi-annual reporting period; iv. Outline challenges impending or that my impede progress on the project over the next semi-annual reporting period and identify ways to address those challenges; v. Outline any areas in which assistance is needed to support the project; and vi. Provide any other information that would be helpful for Grantor to know.The Project Progress Report for the semi-annual basis for the period ending March 31 contained the required information; however, due to insufficient controls over ensuring reports are submitted by the required due date, it was not submitted timely within the two weeks following the end of the semi-annual period and was submitted on October 16, 2023, six months late by the Commission.Failure to submit reports on a timely basis could result in delays in federal funding or other penalties and sanctions.The Commission should ensure that all federal reports are submitted timely.
FINDING 2023-001 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): ILBC-2023-Body Camera-00052 Pass-Through Entity: Indiana Department of Homeland Security Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 13 KOSCIUSKO COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The County Sheriff applied for the Indiana Local Body Camera Grant (ILBC). The grant is a reimbursable grant through the Indiana Department of Homeland Security. The County Sheriff was awarded this grant on January 1, 2023, with a grant cost amount of up to $31,920 to be spent from January 1, 2023 to December 31, 2023. The County Sheriff ordered body-worn cameras and other equipment on April 26, 2023. A Reimbursement Claim Form (Form) was submitted for the cameras and other equipment on September 11, 2023. The Form shows the County Sheriff requested the full $31,920; however, the County had only spent $9,581 from the grant fund towards the purchase. The reimbursement of $31,920 from the Indiana Department of Homeland Security was received on September 27, 2023. The fund had a balance of $22,339 as of December 31, 2023. As there are no grant expenditures for the remaining reimbursements received and the period of performance had ended, the County should have reimbursed the Indiana Department of Homeland Security $22,339. On May 9, 2023, the County Sheriff's grant administrator submitted a Program Report for the ILBC grant. The report was completed and submitted by the County Sheriff's grant administrator without a documented oversight or review process to ensure the completeness and accuracy of the report. The report incorrectly indicated that all expenditures had been completed. However, as of the date of the submission, the County had not purchased the body-worn cameras, and all federal funds had not been expended. 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.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." INDIANA STATE BOARD OF ACCOUNTS 14 KOSCIUSKO COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.344(d) states in part: "The non-Federal entity must promptly refund any balances of unobligated cash that the Federal awarding agency or pass-through entity paid in advance or paid and that are not authorized to be retained by the non-Federal entity for use in other projects. . . ." Cause A proper system of internal controls, which would include segregation of key functions, was not designed by management of the County to ensure the accuracy of the reimbursement invoice and the Program Report. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the County's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As such, federal reimbursement was requested in excess of the amount spent. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the County establish a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place to ensure reimbursement invoices are complete and accurate prior to submission. Furthermore, we recommended the County contact the awarding agency to discuss the funds remaining. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Item 2023-001 – Financial Reporting: Federal Financial Report (SF425) Awarding Agency: U.S. Department of Defense Federal Program: 12.431 – U.S. Army Research Laboratory - Basic Scientific Research; 12.800 - U.S. Air Force Research Laboratory - Air Force Defense - Research Sciences Program Federal Award Identification Number: W911NF-22-2-0050, FA8650-13-2-5402 Grant Period: July 2022 to June 2025; September 2018 to December 2025 Criteria: During the course of the 2023 audit, it was noted during a discussion with management that the financial reports for the above-mentioned awards were not submitted timely. 2 CFR 200.328 requires the reporting of financial information by the auditee according to 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. The Cooperative Agreements note that reporting period end dates fall on the end of the calendar year for annual reports (12/31) and the end date of the award for the final report. Annual reports are due 30 days after the reporting end date, and the final report is due 90 days after the end date. Condition: We determined that the required annual SF425 for federal award W911NF-22-2-0050 was due by January 31, 2024, and was not submitted as of June 2024. In addition, we determined that the annual SF425 for federal award FA8650-13-2-5402 was due on January 31, 2024, and was submitted on March 25, 2024. Cause: SEMI details the occurrence was due to an administrative oversight. Effect: The SF425 for federal awards W911NF-22-2-0050 and FA8650-13-2-5402 were not submitted timely. Questioned Cost: None Context: This is the first time that it was determined that a financial reporting form for one of their five awards was not submitted according to the required due date. Repeat Finding: No Recommendation: We recommend for management to implement process improvements to ensure financial reports are submitted by their required due dates. Views of Responsible Official: SEMI concurs with the finding and will evaluate process improvements to ensure financial reports are submitted by their required due dates or filing extensions are received in writing on a go-forward basis.
Item 2023-001 – Financial Reporting: Federal Financial Report (SF425) Awarding Agency: U.S. Department of Defense Federal Program: 12.431 – U.S. Army Research Laboratory - Basic Scientific Research; 12.800 - U.S. Air Force Research Laboratory - Air Force Defense - Research Sciences Program Federal Award Identification Number: W911NF-22-2-0050, FA8650-13-2-5402 Grant Period: July 2022 to June 2025; September 2018 to December 2025 Criteria: During the course of the 2023 audit, it was noted during a discussion with management that the financial reports for the above-mentioned awards were not submitted timely. 2 CFR 200.328 requires the reporting of financial information by the auditee according to 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. The Cooperative Agreements note that reporting period end dates fall on the end of the calendar year for annual reports (12/31) and the end date of the award for the final report. Annual reports are due 30 days after the reporting end date, and the final report is due 90 days after the end date. Condition: We determined that the required annual SF425 for federal award W911NF-22-2-0050 was due by January 31, 2024, and was not submitted as of June 2024. In addition, we determined that the annual SF425 for federal award FA8650-13-2-5402 was due on January 31, 2024, and was submitted on March 25, 2024. Cause: SEMI details the occurrence was due to an administrative oversight. Effect: The SF425 for federal awards W911NF-22-2-0050 and FA8650-13-2-5402 were not submitted timely. Questioned Cost: None Context: This is the first time that it was determined that a financial reporting form for one of their five awards was not submitted according to the required due date. Repeat Finding: No Recommendation: We recommend for management to implement process improvements to ensure financial reports are submitted by their required due dates. Views of Responsible Official: SEMI concurs with the finding and will evaluate process improvements to ensure financial reports are submitted by their required due dates or filing extensions are received in writing on a go-forward basis.
2 CFR 1000.10 gives regulatory effect to the Department of Treasury for 2 CFR 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. The following have been determined to be Key Line Items for the State and Local Fiscal Recovery Fund Program (SLFRF) 1. Obligations and Expenditures - Quantificable Objective Criteria: Reported obligations and expenditures. a. Current period obligation b. Cumulative obligation c. Current period expenditure d. Cumulative expenditure. The County submitted the annual SLFRF Compliance Report for March 2023, however cumulative obligations, cumulative expenditures, current period obligations and current period expenditures, eaching totaling $5,227,729 were not reported. By not reporting obligation and expenditures, the County is underreporting its obligations and expenditures for the program and the report is not an accurate reflection of the County's SLFRF activity.