Finding 2022-007 Programs: All Significant Deficiency and Noncompliance Over Reporting Repeat Finding: Yes Condition: The City's single audit report and the data collection form were not completed within nine months after the end of the audit period. Criteria: In accordance with 2 CFR ? 200.512, the audit must be completed and the data collection form must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the schedule of expenditures of Federal awards. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the schedule of expenditures of Federal awards is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The City was not in compliance with Uniform Guidance. Questioned Costs: None. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Finding 2022-007 (continued) Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-007 Programs: All Significant Deficiency and Noncompliance Over Reporting Repeat Finding: Yes Condition: The City's single audit report and the data collection form were not completed within nine months after the end of the audit period. Criteria: In accordance with 2 CFR ? 200.512, the audit must be completed and the data collection form must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the schedule of expenditures of Federal awards. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the schedule of expenditures of Federal awards is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The City was not in compliance with Uniform Guidance. Questioned Costs: None. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Finding 2022-007 (continued) Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
2022-006 Late Audit Submission Programs: Impact Aid, Education Stabilization Fund (COVID-19) Federal Assistance #: 84.041, 84.425 Federal Agency: U.S. Department of Education Grantor Number: N/A Questioned Costs: N/A Type of Finding: Noncompliance Compliance Requirement: L. Reporting Condition: The District did not submit their audit for the fiscal year ending June 30, 2022, timely. The audit was submitted June 16, 2023, which was 77 days past the March 31, 2023 deadline. Criteria: 2 CFR ? 200.512(a) provides, in part: "The audit must be completed and the data collection form ... must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period." 2 CFR ? 200.520 provides, in part: "That to qualify as a low-risk auditee and be eligible for reduced audit coverage the following condition must be met: Single audits were performed on an annual basis in accordance with the provisions of this Subpart, including submitting the data collection form and the reporting package to the FAC within the timeframe specified in ? 200.512." Cause: The District was the victim of a ransomware attack in August 2022 which led to a delay in the audit process as records were being retrieved and reposted. Effect: Not making all audit documentation available in a timely manner resulted in the audit and data collection form submissions to be late and, therefore, not available to the public within the required timeframe. This late submission also excludes the District from qualifying as a low-risk auditee. Recommendation: The District should implement procedures to ensure that all audit documentation is available for auditing in a timely manner and the audit report is completed and submitted within the appropriate timeframe. View of Responsible Officials: There is no disagreement with this audit finding. The District has implemented policies and procedures to ensure that the audit is reported and submitted timely in subsequent periods. Repeat Finding: No. Contact person: Anna-Marie Perry, Business Manager
2022-006 Late Audit Submission Programs: Impact Aid, Education Stabilization Fund (COVID-19) Federal Assistance #: 84.041, 84.425 Federal Agency: U.S. Department of Education Grantor Number: N/A Questioned Costs: N/A Type of Finding: Noncompliance Compliance Requirement: L. Reporting Condition: The District did not submit their audit for the fiscal year ending June 30, 2022, timely. The audit was submitted June 16, 2023, which was 77 days past the March 31, 2023 deadline. Criteria: 2 CFR ? 200.512(a) provides, in part: "The audit must be completed and the data collection form ... must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period." 2 CFR ? 200.520 provides, in part: "That to qualify as a low-risk auditee and be eligible for reduced audit coverage the following condition must be met: Single audits were performed on an annual basis in accordance with the provisions of this Subpart, including submitting the data collection form and the reporting package to the FAC within the timeframe specified in ? 200.512." Cause: The District was the victim of a ransomware attack in August 2022 which led to a delay in the audit process as records were being retrieved and reposted. Effect: Not making all audit documentation available in a timely manner resulted in the audit and data collection form submissions to be late and, therefore, not available to the public within the required timeframe. This late submission also excludes the District from qualifying as a low-risk auditee. Recommendation: The District should implement procedures to ensure that all audit documentation is available for auditing in a timely manner and the audit report is completed and submitted within the appropriate timeframe. View of Responsible Officials: There is no disagreement with this audit finding. The District has implemented policies and procedures to ensure that the audit is reported and submitted timely in subsequent periods. Repeat Finding: No. Contact person: Anna-Marie Perry, Business Manager
2022-006 Late Audit Submission Programs: Impact Aid, Education Stabilization Fund (COVID-19) Federal Assistance #: 84.041, 84.425 Federal Agency: U.S. Department of Education Grantor Number: N/A Questioned Costs: N/A Type of Finding: Noncompliance Compliance Requirement: L. Reporting Condition: The District did not submit their audit for the fiscal year ending June 30, 2022, timely. The audit was submitted June 16, 2023, which was 77 days past the March 31, 2023 deadline. Criteria: 2 CFR ? 200.512(a) provides, in part: "The audit must be completed and the data collection form ... must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period." 2 CFR ? 200.520 provides, in part: "That to qualify as a low-risk auditee and be eligible for reduced audit coverage the following condition must be met: Single audits were performed on an annual basis in accordance with the provisions of this Subpart, including submitting the data collection form and the reporting package to the FAC within the timeframe specified in ? 200.512." Cause: The District was the victim of a ransomware attack in August 2022 which led to a delay in the audit process as records were being retrieved and reposted. Effect: Not making all audit documentation available in a timely manner resulted in the audit and data collection form submissions to be late and, therefore, not available to the public within the required timeframe. This late submission also excludes the District from qualifying as a low-risk auditee. Recommendation: The District should implement procedures to ensure that all audit documentation is available for auditing in a timely manner and the audit report is completed and submitted within the appropriate timeframe. View of Responsible Officials: There is no disagreement with this audit finding. The District has implemented policies and procedures to ensure that the audit is reported and submitted timely in subsequent periods. Repeat Finding: No. Contact person: Anna-Marie Perry, Business Manager
2022-006 Late Audit Submission Programs: Impact Aid, Education Stabilization Fund (COVID-19) Federal Assistance #: 84.041, 84.425 Federal Agency: U.S. Department of Education Grantor Number: N/A Questioned Costs: N/A Type of Finding: Noncompliance Compliance Requirement: L. Reporting Condition: The District did not submit their audit for the fiscal year ending June 30, 2022, timely. The audit was submitted June 16, 2023, which was 77 days past the March 31, 2023 deadline. Criteria: 2 CFR ? 200.512(a) provides, in part: "The audit must be completed and the data collection form ... must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period." 2 CFR ? 200.520 provides, in part: "That to qualify as a low-risk auditee and be eligible for reduced audit coverage the following condition must be met: Single audits were performed on an annual basis in accordance with the provisions of this Subpart, including submitting the data collection form and the reporting package to the FAC within the timeframe specified in ? 200.512." Cause: The District was the victim of a ransomware attack in August 2022 which led to a delay in the audit process as records were being retrieved and reposted. Effect: Not making all audit documentation available in a timely manner resulted in the audit and data collection form submissions to be late and, therefore, not available to the public within the required timeframe. This late submission also excludes the District from qualifying as a low-risk auditee. Recommendation: The District should implement procedures to ensure that all audit documentation is available for auditing in a timely manner and the audit report is completed and submitted within the appropriate timeframe. View of Responsible Officials: There is no disagreement with this audit finding. The District has implemented policies and procedures to ensure that the audit is reported and submitted timely in subsequent periods. Repeat Finding: No. Contact person: Anna-Marie Perry, Business Manager
2022-006 Late Audit Submission Programs: Impact Aid, Education Stabilization Fund (COVID-19) Federal Assistance #: 84.041, 84.425 Federal Agency: U.S. Department of Education Grantor Number: N/A Questioned Costs: N/A Type of Finding: Noncompliance Compliance Requirement: L. Reporting Condition: The District did not submit their audit for the fiscal year ending June 30, 2022, timely. The audit was submitted June 16, 2023, which was 77 days past the March 31, 2023 deadline. Criteria: 2 CFR ? 200.512(a) provides, in part: "The audit must be completed and the data collection form ... must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period." 2 CFR ? 200.520 provides, in part: "That to qualify as a low-risk auditee and be eligible for reduced audit coverage the following condition must be met: Single audits were performed on an annual basis in accordance with the provisions of this Subpart, including submitting the data collection form and the reporting package to the FAC within the timeframe specified in ? 200.512." Cause: The District was the victim of a ransomware attack in August 2022 which led to a delay in the audit process as records were being retrieved and reposted. Effect: Not making all audit documentation available in a timely manner resulted in the audit and data collection form submissions to be late and, therefore, not available to the public within the required timeframe. This late submission also excludes the District from qualifying as a low-risk auditee. Recommendation: The District should implement procedures to ensure that all audit documentation is available for auditing in a timely manner and the audit report is completed and submitted within the appropriate timeframe. View of Responsible Officials: There is no disagreement with this audit finding. The District has implemented policies and procedures to ensure that the audit is reported and submitted timely in subsequent periods. Repeat Finding: No. Contact person: Anna-Marie Perry, Business Manager
2022-002 (2021-004) LATE FILING OF THE SINGLE AUDIT REPORTING PACKAGE WITH THE FEDERAL AUDIT CLEARINGHOUSE - REPEATED Federal Program Information Title: All included on the Schedule of Expenditures of Federal Awards Agency: All included on the Schedule of Expenditures of Federal Awards Pass Through: All included on the Schedule of Expenditures of Federal Awards Assistance Listings Number: All included on the Schedule of Expenditures of Federal Awards Type of Finding: Significant Deficiency, Non-compliance Condition NMACD did not submit their Single Audit reporting package (financial statements, data collection form, and corrective action plan) within the required time period. Update for fiscal year 2022 vs. fiscal year 2021: Management was able to file the fiscal year data collection form approximately four months earlier than the previous year, however, it was still almost five months past the statutory deadline. Criteria 2 CFR 200.512 stipulates the requirement that the Single Audit reporting package must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period. Effect Late reporting could cause additional oversight or restriction by grantors. Cause Internal controls were not properly designed, executed, and monitored to ensure a timely preparation of reports and records for audit purposes. As a result, management did not comply with the submission requirements of 2 CFR 200.512.
2022-002 (2021-004) LATE FILING OF THE SINGLE AUDIT REPORTING PACKAGE WITH THE FEDERAL AUDIT CLEARINGHOUSE - REPEATED Federal Program Information Title: All included on the Schedule of Expenditures of Federal Awards Agency: All included on the Schedule of Expenditures of Federal Awards Pass Through: All included on the Schedule of Expenditures of Federal Awards Assistance Listings Number: All included on the Schedule of Expenditures of Federal Awards Type of Finding: Significant Deficiency, Non-compliance Condition NMACD did not submit their Single Audit reporting package (financial statements, data collection form, and corrective action plan) within the required time period. Update for fiscal year 2022 vs. fiscal year 2021: Management was able to file the fiscal year data collection form approximately four months earlier than the previous year, however, it was still almost five months past the statutory deadline. Criteria 2 CFR 200.512 stipulates the requirement that the Single Audit reporting package must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period. Effect Late reporting could cause additional oversight or restriction by grantors. Cause Internal controls were not properly designed, executed, and monitored to ensure a timely preparation of reports and records for audit purposes. As a result, management did not comply with the submission requirements of 2 CFR 200.512.
2022-002 (2021-004) LATE FILING OF THE SINGLE AUDIT REPORTING PACKAGE WITH THE FEDERAL AUDIT CLEARINGHOUSE - REPEATED Federal Program Information Title: All included on the Schedule of Expenditures of Federal Awards Agency: All included on the Schedule of Expenditures of Federal Awards Pass Through: All included on the Schedule of Expenditures of Federal Awards Assistance Listings Number: All included on the Schedule of Expenditures of Federal Awards Type of Finding: Significant Deficiency, Non-compliance Condition NMACD did not submit their Single Audit reporting package (financial statements, data collection form, and corrective action plan) within the required time period. Update for fiscal year 2022 vs. fiscal year 2021: Management was able to file the fiscal year data collection form approximately four months earlier than the previous year, however, it was still almost five months past the statutory deadline. Criteria 2 CFR 200.512 stipulates the requirement that the Single Audit reporting package must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period. Effect Late reporting could cause additional oversight or restriction by grantors. Cause Internal controls were not properly designed, executed, and monitored to ensure a timely preparation of reports and records for audit purposes. As a result, management did not comply with the submission requirements of 2 CFR 200.512.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
Finding 2022-004 ? Reporting (Compliance; Internal Control Over Compliance) Significant Deficiency Condition: The School District did not complete and submit their audit to the Federal Audit Clearinghouse by the due date of March 31, 2023. This affects all federal programs. Questioned Costs: None. Criteria: 2 CFR ?200.512 of the Uniform Guidance requires an entity expending more than $750,000 of federal funds within the calendar year to submit a data collection form by a due date that is the earlier of 30 calendar days after receipt of the auditor?s report(s) or nine months after the end of the audit period. Cause: The School District has a limited number of staff to perform financial functions. Effect: Late filing of the data collection form results in noncompliance with requirements of Uniform Guidance which could lead to sanctions by funding agencies. Recommendation: We recommend the School District become familiar with reporting requirements for each award and implement procedures to begin audit preparation work earlier in the fiscal year to ensure reports are filed within the nine-month reporting deadline set forth by Uniform Guidance. Views of Responsible Officials: Please refer to the Corrective Action Plan for management?s views and planned corrective action.
Finding 2022-004 ? Reporting (Compliance; Internal Control Over Compliance) Significant Deficiency Condition: The School District did not complete and submit their audit to the Federal Audit Clearinghouse by the due date of March 31, 2023. This affects all federal programs. Questioned Costs: None. Criteria: 2 CFR ?200.512 of the Uniform Guidance requires an entity expending more than $750,000 of federal funds within the calendar year to submit a data collection form by a due date that is the earlier of 30 calendar days after receipt of the auditor?s report(s) or nine months after the end of the audit period. Cause: The School District has a limited number of staff to perform financial functions. Effect: Late filing of the data collection form results in noncompliance with requirements of Uniform Guidance which could lead to sanctions by funding agencies. Recommendation: We recommend the School District become familiar with reporting requirements for each award and implement procedures to begin audit preparation work earlier in the fiscal year to ensure reports are filed within the nine-month reporting deadline set forth by Uniform Guidance. Views of Responsible Officials: Please refer to the Corrective Action Plan for management?s views and planned corrective action.
Criteria: 2 CFR section 200.512 requires that an non-federal entity?s single audit and data collection form must be submitted within the earlier of thirty days after the receipt of the auditor?s report or nine months after the end of the audit period. Condition: UCAP?s audited financial statements for the June 30, 2022 year-end were not submitted to the Federal Audit Clearing House within the stipulated nine months after year-end. Context: This is a condition identified based on review of Uniform Guidance requirements. Questioned Cost: $ 0 Cause: During FY2022, the pass-through entity agreed to allow UCAP to capture more costs under CSBG Cares supplemental funds, which resulted in heavy workload in reconciliations and consequently the report being submitted late. Effect: The program is not in compliance with reporting compliance of the Office of Management and Budget for non-profit, state and local government entities. Identification of a Repeat Finding: This is not a repeat finding in the immediately prior audit. Recommendation: We recommend that UCAP works to have reconciliations completed on a timely basis and have its audits completed timely in the upcoming year to comply with federal guidelines. Views of Responsible Officials and Planned Corrective Action Plan: During the year ended 6/30/22, UCAP received additional funding due to the Cares Act. As such, the organization had an obligation to spend all funds by 9/30/22. Each of the funding sources had different sunset dates. In an effort to recapture costs, the organization went back to March 2020, the date the grant first was granted in order to recapture costs that were not previously captured under the CARES program. The Fiscal Manager?s start date was August 2020, seven months after the grant was implemented. This was an effort to use all excess Cares funding. This affected the expenditures for the year, the amounts due from grantors and the deferred revenue accounts. In turn, this affected the timely closing of the books. Planned Corrective Action: UCAP has implemented measures to ensure that there is no delay in financial reporting in the future. Responsible Official: Maryland Hutchinson, Fiscal Manager. Anticipated Completion Date: This will be complete by 6/30/2023 and will be reflected in the upcoming year-end
Finding 2022-001: Late Reporting and Noncompliance with Reporting Requirements: Federal Agency: U.S. Department of Commerce Federal Program: 11.300 Investments for Public Works and Economic Development Facilities Grant Number: 07-01-07499 Award Year: 2022 Type of Finding: Significant Deficiency/Noncompliance Opinion: Unmodified Condition: The City did not adhere to the Uniform Guidance requirement of submitting the reporting package within the earlier of 30 days after receipt of the audit report, or nine months plus any extensions after the end of the audit period, (i.e. the FAC Report was not submitted timely.) Criteria: The Uniform Guidance requires that the reporting package be submitted within the earlier of nine months, plus any extensions, after year end or 30 days after the report issuance in accordance with the provisions of 2 CFR part 200, subpart F, section 200.512. Context: The FAC report was not submitted within the required time period. Cause: Due to delays in the audit of Nome Joint Utilities (Component Unit) the City was unable to complete the audit within the required reporting timeline. Effect: The City is not in compliance with Uniform Guidance reporting requirements. Questioned Costs: None. Recommendation: Nome Joint Utilities should complete their audit in a more timely manner so the City can comply with their reporting requirements. Management Response: Management concurs with this finding. See Corrective Action Plan.
Criteria: 2 CFR Section 200.512 (a)(1) states that Boise Bible College, Inc.?s single audit must be completed and the data collection form must be submitted nine months after the end of the audit period. Condition: The Organization did not complete and submit its single audit within nine months after the end of the audit period. Cause: The Organization does not have a proper internal control structure in place to complete its single audit requirement in a timely manner. Effect: Users of the financial statements do not have timely access to the Organization?s financial information. Questioned Costs: None. Recommendation: Management should develop a review process to ensure that the financial information is recorded appropriately in accordance with generally accepted accounting principles, is properly reconciled and recorded at year-end in a timely manner, and audits are completed in a timely manner in accordance with 2 CFR Section 200.512. Views of Responsible Officials: Management will work to develop the proper procedures to ensure that balances are appropriately reconciled at year-end and recorded in accordance with generally accepted accounting principles, so the reporting requirements in 2 CFR Section 200.512 are met.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
2022-001, Single Audit Data Collection Form Not Filed by Due Date Condition: The data collection form for the Single Audit ended June 30, 2022, was not submitted to the Federal Audit Clearinghouse by March 31, 2023. Criteria: 2 CFR section 200.512(b) provides for a form, referred to as the data collection form, to be prepared at the completion of each audit and submitted by the auditee to the Federal Audit Clearinghouse the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. Cause: The audit report was not issued prior to the March 31, 2023, submission date requirement. Therefore, the data collection form required at audit completion was not filed by this date. Effect: Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries has not met the reporting requirements related to timely submission of the data collection form required for Single Audit. Therefore, per 2 CFR section 200.520, Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries will not meet the low-risk criteria for future Single Audits that requires submission of the data collection form and reporting package by the due date for each of the two preceeding audit years. Recommendation: We recommend that Area Agency on Aging of Northwest Arkansas, Inc. and Subsidiaries develop specific procedures to ensure that the audit report is received prior to the March 31 reporting deadline. Management Response: The Data Collection Form will be filed when the audit is complete.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
Section III ? Federal Award Findings and Questioned Costs 2022-003 Data Collection Form Not Filed by Deadline - Compliance-Other Condition: The Data Collection Form was not submitted by the deadline of March 31st, which was nine months after the School?s year-end. Criteria: Per 2 CFR 200.512 related to report submission of the data collection form, ?The audit must be completed?and submitted within the earlier of 30 calendar days after receipt of the auditor?s report, or nine months after the end of the audit period.? Cause: The School?s audit report was not completed in time for the data collection form to be filed by March 31, 2023. Effect: Untimely filing of the data collection form can cause granting agencies to consider the School to be high-risk. Recommendation: We recommend that increased efforts are made to file the data collection form under Uniform Guidance timely in the future. Response: The School has and will continue to provide data to the audit firm in a timely manner. The audit firm will ensure that the audit report and data collection form are filed timely in the future.
2022-002 Youth Homelessness Demonstration Program, CFDA #14.276 Criteria: 2 CFR 200.512(a) requires that the reporting package (the single audit report) and the data collection form be submitted to the Federal Audit Clearinghouse the earlier of 30 calendar days after the reports are received or nine months (fifteen months with a COVID extension) after the end of the audit period. Condition: Northwest Compass, Inc.?s June 30, 2021 reporting package and data collection was due no later than June 11, 2022, which is 30 calendar days after the reports were received. The reporting package was filed in September 2022. Cause: The Organization had a significant increase in funding during fiscal year 2021 that resulted in a single audit being performed for the first time in a number of years. There were delays in the auditee certifying and submitting the reporting package to the Federal Audit Clearinghouse. Effect: This delay in reporting to the Federal Audit Clearinghouse and to pass-through entities will cause a delay in closing out grants and reporting results of the grants to various organizations. Auditor recommendation: We recommend that upon receiving the final reporting package, the Organization completes all requirements with the Federal Audit Clearinghouse. Management response: We have adopted this policy for fiscal year 2022 and moving forward.
Various Agencies Finding 2022 ? 014: ALN 10.553, 10.555, 10.556, 10.559, and 10.582 ? Child Nutrition Cluster (including COVID-19) ALN 10.557 ? WIC Special Supplemental Nutrition Program for Women, Infants, and Children (including COVID-19) ALN 10.558 ? Child and Adult Care Food Program (including COVID-19) ALN 15.252 ? Abandoned Mine Land Reclamation ALN 21.023 ? COVID-19 ? Emergency Rental Assistance Program ALN 84.010 ? Title I Grants to Local Educational Agencies ALN 84.027 and 84.173 ? ? Special Education Cluster (IDEA) (including COVID-19) ALN 84.425C ? COVID 19 ? Education Stabilization Fund - GEER Fund ALN 84.425D ? COVID 19 ? Education Stabilization Fund - ESSER Fund ALN 84.425R ? COVID 19 ? Education Stabilization Fund - CRRSA EANS ALN 84.425U ? COVID 19 ? Education Stabilization Fund - ARP ESSER ALN 84.425W ? COVID 19 ? Education Stabilization Fund - ARP ESSER HCY ALN 93.558 ? Temporary Assistance for Needy Families (including COVID-19) ALN 93.563 ? Child Support Enforcement ALN 93.575 and 93.596 ? Child Care and Development Fund (CCDF) Cluster (including COVID-19) ALN 93.658 ? Foster Care ? Title IV-E (including COVID-19) ALN 93.659 ? Adoption Assistance (including COVID-19) ALN 93.775, 93.777, and 93.778 ? Medicaid Cluster (including COVID-19) A Material Weakness and Material Noncompliance Exist in the Commonwealth?s Subrecipient Audit Resolution Process (A Similar Condition Was Noted in Prior Year Finding 2021-015) Federal Grant Number(s) and Year(s): 1PA300365 (1/01/2022 ? 9/30/2023), 1PA310305 (10/01/2021 ? 9/30/2022), 1PA310305 (10/01/2020 ? 9/30/2021), 1PA300305 (10/01/2021 ? 9/30/2022), 1PA300305 (10/01/2020 ? 9/30/2021), 1PA320305 (12/27/2020 ? 9/30/2021), Y22174 (10/01/2021 ? 9/30/2024), Y13194 (10/01/2020 ? 9/30/2023), Y03194 (10/01/2019 ? 9/30/2023), Y03191 (10/01/2019 ? 9/30/2020), Y22173 (10/01/2021 ? 9/30/2022), Y22172 (10/01/2021 ? 9/30/2022, Y13191 (10/01/2020 ? 9/30/2021), Y13061 (10/01/2020 ? 9/30/2021), S22AF00017 (1/01/2022 ? 12/31/2024), S21AF10050 (6/01/2021 ? 5/31/2024), S21AF10015 (1/01/2021 ? 12/31/2023), S20AF20092 (10/01/2020 ? 9/30/2023), S20AF20006 (1/01/2020 ? 12/31/2022), S19AF20006 (1/01/2019 ? 12/31/2021), S19AF20004 (12/01/2018 ? 11/30/2023), S18AF20004 (11/01/2017 ? 10/31/2023), ERAE0131 (1/19/2021 ? 12/29/2022), ERAE0333 (5/11/2021 ? 12/30/2025), S010A210038 (7/01/2021 ? 9/30/2022), S010A200038 (7/01/2020 ? 9/30/2021), H027A210093 (7/01/2021 ? 9/30/2022), H027A200093 (7/01/2020 ? 9/30/2021), S425D200028 (3/13/2020 ? 9/30/2022), S425D210028 (3/13/2020 ? 9/30/2022), 2201PATANF (10/01/2021 ? 9/30/2022), 2101PATANF (10/01/2020 ? 9/30/2021), 2001PATANF (10/01/2019 ? 9/30/2020), 2201PACSES (10/01/2021 ? 9/30/2022), 2101PACSES (10/01/2020 ? 9/30/2021), G2201PACCDF (10/01/2021 ? 9/30/2022), G2101PACCDF (10/01/2020 ? 9/30/2021), 2201PAFOST (10/01/2021 ? 9/30/2022), 2101PAFOST (10/01/2020 ? 9/30/2021), 2001PAFOST (10/01/2019 ? 9/30/2020), 2201PAADPT (10/01/2021 ? 9/30/2022), 2101PAADPT (10/01/2020 ? 9/30/2021), 2205PA5MAP (10/01/2021 ? 9/30/2022), 2105PA5MAP (10/01/2020 ? 9/30/2021) Finding 2022 ? 014: (continued) Type of Finding: Significant Deficiency, Noncompliance for Medicaid Cluster Material Weakness, Material Noncompliance for Other Programs Compliance Requirement: Subrecipient Monitoring Condition: Under the Commonwealth of Pennsylvania's (Commonwealth) implementation of the Single Audit Act, review and resolution of subrecipient Single Audit reports is split into two stages. The Office of the Budget?s Bureau of Accounting and Financial Management (OB-BAFM) ensures the reports meet technical standards through a centralized desk review process. The various funding agencies in the Commonwealth are responsible for making a management decision on each finding within six months of the Federal Audit Clearinghouse?s (FAC) Management Decision Letter (MDL) start date for audits subject to Uniform Guidance and to ensure appropriate corrective action is taken by the subrecipient (except for Uniform Guidance audits under U.S. Department of Labor programs which are permitted 12 months for management decisions in accordance with 2 CFR Section 2900.21). Each Commonwealth agency is also responsible for reviewing financial information in each audit report to determine whether the audit included all pass-through funding provided by the agency in order to ensure pass-through funds were subject to audit. Most agencies meet this requirement by performing Schedule of Expenditures of Federal Awards (SEFA) reconciliations. The agency is also required to adjust Commonwealth records, if necessary. Our fiscal year ended June 30, 2022 audit of the Commonwealth?s process for review and resolution of subrecipient Single Audits included an evaluation of the Commonwealth?s fiscal year ended June 30, 2021 subrecipient audit universe for audits due for submission to the FAC during the fiscal year ended June 30, 2022. We also evaluated the Commonwealth?s review of 44 subrecipient audit reports with findings in major programs/clusters which were identified on the Commonwealth agencies? tracking lists during the fiscal year ended June 30, 2022 and required management decisions by Commonwealth agencies. Our testing disclosed the following audit exceptions regarding the Commonwealth agencies? review of subrecipient audit reports: ? Department of Education (PDE): The time period for making a management decision on findings was approximately 6.5 to over 13 months after the FAC MDL start date for 14 out of 25 audit reports with findings. Three of the 14 audit reports were improperly classified on PDE?s audit tracking list as not having federal award findings. ? Department of Environmental Protection (DEP): The time period for making a management decision on findings was approximately 16.2 months after the FAC MDL start date for one out of three audit reports with findings. In addition, our review disclosed that DEP subgranted federal funds totaling $10,338,570 to one subrecipient during the fiscal year ended December 31, 2020, for which a Single Audit was not submitted to the FAC as of our January 2023 testing date. This was over 9.5 months after the March 31, 2022 due date, which had been extended due to the COVID-19 pandemic in accordance with the Office of Management and Budget?s (OMB) Memorandum M-21-20, Appendix 3. ? Department of Health (DOH): Our review disclosed that DOH subgranted federal funds totaling $8,103,407 to one subrecipient during the fiscal year ended September 30, 2020, for which a Single Audit was not submitted to the FAC as of our January 2023 testing date. This was over 12.5 months after the December 31, 2021 due date, which had been extended in accordance with OMB?s Memorandum M-21-20, Appendix 3. ? Department of Human Services (DHS): The time period for making a management decision on findings ranged from approximately 6.6 months to over 19.6 months after the FAC MDL start date for 12 out of 14 subrecipient audit reports with findings. There was also a delay in DHS?s procedures to ensure the subrecipient SEFAs were accurate so that major programs were properly determined and subjected to audit. Finding 2022 ? 014: (continued) As a follow-up to the prior year finding, we noted that the Commonwealth subgranted federal funds totaling $327,988,063 to the City of Philadelphia during the fiscal year ended June 30, 2021, for which a Single Audit was not submitted to the FAC as of our January 2023 testing date. This was over 3.5 months after the September 30, 2022 due date, which had been extended in accordance with OMB?s Memorandum M-21-20, Appendix 3. Our testing disclosed that DHS?s subgrants to the City of Philadelphia were material for five of the 16 major programs/clusters with material subgranted funds. Our follow-up on the prior year finding also disclosed that the Commonwealth subgranted federal funds totaling $28,725,212 to Bucks County during the fiscal year ended December 31, 2020, for which a Single Audit was not submitted to the FAC as of our January 2023 testing date. This was over 9.5 months after the March 31, 2022 due date, which had been extended in accordance with OMB?s Memorandum M-21-20, Appendix 3. DHS was the lead agency for the City of Philadelphia and Bucks County audits. Criteria: 2 CFR ?200.332, Requirements for pass-through entities, states in part: All pass-through entities must: (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward, and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: (2) Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. (3) Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by ?200.521 [Management decision]. (f) Verify that every subrecipient is audited as required by Subpart F [Audit Requirements] of this part when it is expected that the subrecipient?s Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in ?200.501 [Audit requirements]. (g) Consider whether the results of the subrecipient?s audit, on-site review, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity?s own records. (h) Consider taking enforcement action against noncompliant subrecipients as described in ?200.339 [Remedies for noncompliance] of this part and in program regulations. In order to carry out these responsibilities properly, good internal control dictates that state pass-through agencies ensure subrecipient Single Audit SEFAs are representative of state payment records each year, and that the related federal programs have been properly subjected to Single Audit procedures. 2 CFR ?200.512, Report submission, states in part: (a) General. (1) The audit must be completed and the data collection form described in paragraph (b) of this section and reporting package described in paragraph (c) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor?s report(s), or nine months after the end of the audit period. If the due date falls on a Saturday, Sunday, or Federal holiday, the reporting package is due the next business day. Finding 2022 ? 014: (continued) 2 CFR ?200.521, Management decision, states in part: (a) General. The management decision must clearly state whether or not the finding is sustained, the reasons for the decision, and the expected auditee action to repay disallowed costs, make financial adjustments, or take other action. (d) Time requirements. The Federal awarding agency or pass-through entity responsible for issuing a management decision must do so within six months of acceptance of the audit report by the FAC. The auditee must initiate and proceed with corrective action as rapidly as possible and corrective action should begin no later than upon receipt of the audit report. 2 CFR ?200.505, Sanctions, states: In cases of continued inability or unwillingness to have an audit conducted in accordance with this part, Federal agencies and pass-through entities must take appropriate action as provided in ?200.339 [Remedies for noncompliance]. 2 CFR ?200.339, Remedies for noncompliance, states in part: If a non-Federal entity fails to comply with the U.S. Constitution, Federal statutes, regulations or the terms and conditions of a Federal award, the Federal awarding agency or pass-through entity may impose additional conditions, as described in ?200.208 [Specific conditions]. If the Federal awarding agency or pass-through entity determines that noncompliance cannot be remedied by imposing additional conditions, the federal awarding agency or pass-through entity may take one or more of the following actions, as appropriate in the circumstances. (a) Temporarily withhold cash payments pending correction of the deficiency by the non-Federal entity or more severe enforcement action by the Federal awarding agency or pass-through entity. (b) Disallow (that is, deny both use of funds and any applicable matching credit for) all or part of the cost of the activity or action not in compliance. (c) Wholly or partly suspend or terminate the Federal award. (d) Initiate suspension or debarment proceedings as authorized under 2 CFR Part 180 and Federal awarding agency regulations (or in the case of a pass-through entity, recommend such a proceeding be initiated by a Federal awarding agency). (e) Withhold further Federal awards for the project or program. (f) Take other remedies that may be legally available. To ensure Commonwealth enforcement of federal regulations for subrecipient noncompliance with audit requirements, Commonwealth Management Directive 325.08, Amended ? Remedies for Recipient Noncompliance with Audit Requirements, Section 5 related to policy, states in part: (a) Agencies must develop and implement remedial action that reflects the unique requirements of each program? (b) The remedial action should be implemented within six months from the date the first remedial action is initiated. At the end of the six-month period, the recipient should take the appropriate corrective action or the final stage of remedial action should be imposed on the recipient. Examples of remedial action include, but are not limited to: Finding 2022 ? 014: (continued) (1) Meeting or calling the recipient to explain the importance and benefits of the audit and audit resolution processes, emphasizing the value of the audit as an administrative tool and the Commonwealth?s reliance on an acceptable audit and prompt resolution as evidence of the recipient?s ability to properly administer the program. (2) Encouraging the entity to establish an audit committee or designate an individual as the single point of contact to: (a) Communicate regarding the audit. (b) Arrange for and oversee the audit. (c) Direct and monitor audit resolution. (3) Providing technical assistance to the recipient in devising and implementing an appropriate plan to remedy the noncompliance. (4) Withholding a portion of assistance payments until the noncompliance is resolved. (5) Withholding or disallowing overhead costs until the noncompliance is resolved. (6) Suspending the assistance agreement until the noncompliance is resolved. (7) Terminating the assistance agreement with the recipient and, if necessary, seeking alternative entities to administer the program. Management Directive 325.09, Amended ? Processing Subrecipient Single Audits of Federal Pass-Through Funds, Section 7 related to procedures, states in part: c. Agencies. (1) Evaluate single audit report submissions received from BAFM to determine program purpose acceptability by verifying, at a minimum, that all agency-funded programs are properly included on the applicable financial schedules; that findings affecting the agency contain sufficient information to facilitate a management decision; and that the subrecipient has submitted an adequate corrective action plan. (6) Issue management decisions relative to audit findings and crosscutting findings assigned to the agency for resolution, as required by 2 CFR ?200.521. If responsible for the resolution of crosscutting findings, notify the affected agency or agencies upon resolution of such findings. (7) Impose or coordinate the imposition of remedial action in accordance with 2 CFR Part 200.339 and Management Directive 325.08 Amended, Remedies for Recipient Noncompliance with Audit Requirements, when subrecipients fail to comply with the provisions of Subpart F. Management Directive 325.12, Amended ? Standards for Enterprise Risk Management in Commonwealth Agencies, adopted the internal control framework outlined in the United States Government Accountability Office?s, Standards for Internal Control in the Federal Government (Green Book). The Green Book states in part: Management should establish and operate monitoring activities to monitor the internal control system and evaluate the results. Management should remediate identified internal control deficiencies on a timely basis. Cause: One reason provided by Commonwealth management for untimely audit resolution in the various agencies, including making management decisions, approving corrective action, and performing procedures to ensure the accuracy of subrecipient SEFAs, was either a change in staff or a lack of staff to follow up and process subrecipient audit reports more timely. The late management decision at DEP appeared to be the result of a subrecipient being treated as a contractor as described in current year Single Audit Finding #2022-005, despite having a subrecipient Single Audit requirement clause in its contract with DEP. Regarding late and outstanding audit report submissions, the Commonwealth agencies did not appear to be timely implementing remedial action steps in accordance with 2 CFR ?200.339 and Commonwealth Management Directive 325.8 in order to ensure compliance with federal audit submission requirements. Finding 2022 ? 014: (continued) Effect: Since required management decisions were not made within six months to ensure appropriate corrective action was taken on audits received from subrecipients, the Commonwealth did not comply with federal regulations, and subrecipients were not made aware of acceptance or rejection of corrective action plans in a timely manner. Further, noncompliance may recur in future periods if control deficiencies are not corrected on a timely basis, and there is an increased risk of unallowable charges being made to federal programs if corrective action and recovery of questioned costs is not timely. Regarding the SEFA reviews or alternate procedures which are not being performed timely and the late Single Audit report submissions, there is an increased risk that subrecipients could be misspending and/or inappropriately tracking and reporting federal funds over multiple year periods, and these discrepancies may not be properly monitored, detected, and corrected by agency personnel on a timely basis as required. Finally, additional federal pass-through funds may be unaudited in the future without timely and effective remedial action from Commonwealth agencies to enforce compliance. Recommendation: We recommend that the above weaknesses that cause untimely subrecipient Single Audit resolution, including untimely management decisions on findings, untimely review of the SEFA or alternate procedures, and late audit report submissions be corrected to ensure compliance with federal requirements and Commonwealth Management Directives, and to better ensure timelier subrecipient compliance with program requirements. Commonwealth agencies should promptly pursue outstanding audits and implement remedial action steps on a timely basis in accordance with 2 CFR ?200.339 and Commonwealth Management Directive 325.08. PDE Response: PDE agrees with the finding. DEP Response: DEP agrees with the finding. DOH Response: DOH agrees with the finding. DHS Response: While DHS agrees with this finding, we believe we are in compliance with 2 CFR ?200.339 and Commonwealth Management Directive 325.08 related to outstanding audits. We continue to work with counties and their independent auditors to obtain any late Single Audit reports, and albeit late, we do receive them which is the ultimate goal. Questioned Costs: The amount of questioned costs cannot be determined. The corrective action plan for this finding, if any, has not been reviewed by the auditors. See Corrective Action Plans located elsewhere in this Report.