Finding Number: 2022-001 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Data Collection Form Late Filing Major Programs: AL#10.557 - WIC Special Supplemental Nutrition Program for Women, Infants and Children ? Award numbers: CD3-21-4658A, CD3-21-4658B and CD3-22-4658 AL#21.023 ? COVID-19 - Emergency Rental Assistance Program ? Award numbers - None AL#93.568 - Low Income Home Energy Assistance Program ? Award numbers - None Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Requirement Condition: The Organization did not submit the data collection form and reporting package, for the year ended August 31, 2021, to the Federal Audit Clearinghouse in a timely manner. Criteria: The Report Submission that is codified in 2 CFR Part 200.512 requires the auditee must submit the applicable data elements of the data collection form to the Federal Audit Clearinghouse 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: Management did not certify the auditee section timely. Effect: The Organization was not in compliance with audit submission requirements, resulting in a non-material noncompliance and significant deficiency in internal controls over compliance. Recommendation: We recommend the Organization implement systems and procedures to ensure timely completion of its audit and submission of the audit package to the Federal Audit Clearinghouse. View of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
DEPARTMENT OF HEALTH AND HUMAN SERVICES HeadStart, CFDA # 93.600 2022 - 03: Criteria: 2 CFR 200.512(a) requires that (SF) 425 form must be submitted on a quarterly and semi-annual basis no later than 30 days after the end of each reporting period. Annual report shall be submitted no later than 90 days after the end of each report period. (SF) 429 form must be submitted on an annual basis no later than 90 days after the project or grant period end date. Condition: In gaining our understanding of control over (SF) 425 and (SF) 429 forms, we noted the following controls: (SF) 425 form must be submitted quarterly basis and (SF) 429 form must be submitted annually. We reviewed (SF) 425 forms for the 2nd quarter and 4th quarter noted that amounts did not agreed to the general ledger and quarterly reports were submitted late. Form (SF) 429 was not submitted in a timely manner at all. Cause: The Agency had significant turnover for the whole year of 2021 and 2022. This resulted in significant delays in getting ready or providing information and submitted the required forms to the funder agency. Effect: This delay and in accuracy in reporting to the governmental entity could cause some confusion by the governmental entity in exactly how much funds were spent during the quarter and prevents the Agency in tracking their grant funds spent and how much is remaining. This could result in overspending on the grant. Auditor?s Recommendation: We recommend that when there is a significant vacancy in the accounting department, the Agency finds some temporary help to keep the accounting records accurate and up to date. This will enable the Agency to have adequate and complete accounting records to meet reporting requirements. Management response: Due to significant employee turnover in the accounting department, SF-425 and SF-429 reports were not submitted in a timely manner or with information matching the general ledger. The new accounting team is in place and is in the process of correcting and resubmitting or submitting the reports. The accounting team will submit accurate SF-425 and SF-429 reports in a timely manner moving forward.
Section III – Findings and Questioned Costs for Federal Awards 2022-003 - Late Submission of Uniform Guidance Report Cluster: Not applicable Federal Granting Agency: All federal agencies represented on the Schedule of Expenditures of Federal Awards (“SEFA”) Award Name: All awards on the SEFA Award Year: All awards on the SEFA Assistance Listing #: All awards on the SEFA Assistance Listing Title: All awards on the SEFA Pass-through entity: All identified on the SEFA Criteria 2 CFR 200.512 Report Submission requires the audit be completed and the data collection form and Uniform Guidance reporting package submitted within the earlier of 30 calendar days after receipt of the auditor's reports), or nine months after the end of the audit period. Condition The LPCH Uniform Guidance reporting package was due to be submitted to the Federal Audit Clearinghouse by May 31, 2023. Given the report was not filed until December 6, 2023, the report is considered late. Cause The 2022 audit commenced in the Spring of 2023 with timely completion expected. However, additional time was needed to complete processes for certain financial statement presentation and disclosure matters that are unrelated to federal funding. Effect Not receiving the Uniform Guidance reporting package in a timely manner could impact the oversight and monitoring procedures performed by the federal government and other constituents. Questioned Costs None noted. Recommendation We recommend management ensure controls are in place to allow for subsequent audits to be completed in a timely manner, consistent with previous years. Management's Views and Correction Action Plan Management's views and corrective action plan is included at the end of this report after the summary schedule of prior audit findings and status.
Section III – Findings and Questioned Costs for Federal Awards 2022-003 - Late Submission of Uniform Guidance Report Cluster: Not applicable Federal Granting Agency: All federal agencies represented on the Schedule of Expenditures of Federal Awards (“SEFA”) Award Name: All awards on the SEFA Award Year: All awards on the SEFA Assistance Listing #: All awards on the SEFA Assistance Listing Title: All awards on the SEFA Pass-through entity: All identified on the SEFA Criteria 2 CFR 200.512 Report Submission requires the audit be completed and the data collection form and Uniform Guidance reporting package submitted within the earlier of 30 calendar days after receipt of the auditor's reports), or nine months after the end of the audit period. Condition The LPCH Uniform Guidance reporting package was due to be submitted to the Federal Audit Clearinghouse by May 31, 2023. Given the report was not filed until December 6, 2023, the report is considered late. Cause The 2022 audit commenced in the Spring of 2023 with timely completion expected. However, additional time was needed to complete processes for certain financial statement presentation and disclosure matters that are unrelated to federal funding. Effect Not receiving the Uniform Guidance reporting package in a timely manner could impact the oversight and monitoring procedures performed by the federal government and other constituents. Questioned Costs None noted. Recommendation We recommend management ensure controls are in place to allow for subsequent audits to be completed in a timely manner, consistent with previous years. Management's Views and Correction Action Plan Management's views and corrective action plan is included at the end of this report after the summary schedule of prior audit findings and status.
Finding Number: 2022-001 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Data Collection Form Late Filing Major Programs: AL#10.557 - WIC Special Supplemental Nutrition Program for Women, Infants and Children ? Award numbers: CD3-21-4658A, CD3-21-4658B and CD3-22-4658 AL#21.023 ? COVID-19 - Emergency Rental Assistance Program ? Award numbers - None AL#93.568 - Low Income Home Energy Assistance Program ? Award numbers - None Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Requirement Condition: The Organization did not submit the data collection form and reporting package, for the year ended August 31, 2021, to the Federal Audit Clearinghouse in a timely manner. Criteria: The Report Submission that is codified in 2 CFR Part 200.512 requires the auditee must submit the applicable data elements of the data collection form to the Federal Audit Clearinghouse 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: Management did not certify the auditee section timely. Effect: The Organization was not in compliance with audit submission requirements, resulting in a non-material noncompliance and significant deficiency in internal controls over compliance. Recommendation: We recommend the Organization implement systems and procedures to ensure timely completion of its audit and submission of the audit package to the Federal Audit Clearinghouse. View of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2022-001 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Data Collection Form Late Filing Major Programs: AL#10.557 - WIC Special Supplemental Nutrition Program for Women, Infants and Children ? Award numbers: CD3-21-4658A, CD3-21-4658B and CD3-22-4658 AL#21.023 ? COVID-19 - Emergency Rental Assistance Program ? Award numbers - None AL#93.568 - Low Income Home Energy Assistance Program ? Award numbers - None Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Requirement Condition: The Organization did not submit the data collection form and reporting package, for the year ended August 31, 2021, to the Federal Audit Clearinghouse in a timely manner. Criteria: The Report Submission that is codified in 2 CFR Part 200.512 requires the auditee must submit the applicable data elements of the data collection form to the Federal Audit Clearinghouse 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: Management did not certify the auditee section timely. Effect: The Organization was not in compliance with audit submission requirements, resulting in a non-material noncompliance and significant deficiency in internal controls over compliance. Recommendation: We recommend the Organization implement systems and procedures to ensure timely completion of its audit and submission of the audit package to the Federal Audit Clearinghouse. View of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2022-001 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Data Collection Form Late Filing Major Programs: AL#10.557 - WIC Special Supplemental Nutrition Program for Women, Infants and Children ? Award numbers: CD3-21-4658A, CD3-21-4658B and CD3-22-4658 AL#21.023 ? COVID-19 - Emergency Rental Assistance Program ? Award numbers - None AL#93.568 - Low Income Home Energy Assistance Program ? Award numbers - None Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Requirement Condition: The Organization did not submit the data collection form and reporting package, for the year ended August 31, 2021, to the Federal Audit Clearinghouse in a timely manner. Criteria: The Report Submission that is codified in 2 CFR Part 200.512 requires the auditee must submit the applicable data elements of the data collection form to the Federal Audit Clearinghouse 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: Management did not certify the auditee section timely. Effect: The Organization was not in compliance with audit submission requirements, resulting in a non-material noncompliance and significant deficiency in internal controls over compliance. Recommendation: We recommend the Organization implement systems and procedures to ensure timely completion of its audit and submission of the audit package to the Federal Audit Clearinghouse. View of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2022-001 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Data Collection Form Late Filing Major Programs: AL#10.557 - WIC Special Supplemental Nutrition Program for Women, Infants and Children ? Award numbers: CD3-21-4658A, CD3-21-4658B and CD3-22-4658 AL#21.023 ? COVID-19 - Emergency Rental Assistance Program ? Award numbers - None AL#93.568 - Low Income Home Energy Assistance Program ? Award numbers - None Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Requirement Condition: The Organization did not submit the data collection form and reporting package, for the year ended August 31, 2021, to the Federal Audit Clearinghouse in a timely manner. Criteria: The Report Submission that is codified in 2 CFR Part 200.512 requires the auditee must submit the applicable data elements of the data collection form to the Federal Audit Clearinghouse 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: Management did not certify the auditee section timely. Effect: The Organization was not in compliance with audit submission requirements, resulting in a non-material noncompliance and significant deficiency in internal controls over compliance. Recommendation: We recommend the Organization implement systems and procedures to ensure timely completion of its audit and submission of the audit package to the Federal Audit Clearinghouse. View of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2022-001 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Data Collection Form Late Filing Major Programs: AL#10.557 - WIC Special Supplemental Nutrition Program for Women, Infants and Children ? Award numbers: CD3-21-4658A, CD3-21-4658B and CD3-22-4658 AL#21.023 ? COVID-19 - Emergency Rental Assistance Program ? Award numbers - None AL#93.568 - Low Income Home Energy Assistance Program ? Award numbers - None Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Requirement Condition: The Organization did not submit the data collection form and reporting package, for the year ended August 31, 2021, to the Federal Audit Clearinghouse in a timely manner. Criteria: The Report Submission that is codified in 2 CFR Part 200.512 requires the auditee must submit the applicable data elements of the data collection form to the Federal Audit Clearinghouse 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: Management did not certify the auditee section timely. Effect: The Organization was not in compliance with audit submission requirements, resulting in a non-material noncompliance and significant deficiency in internal controls over compliance. Recommendation: We recommend the Organization implement systems and procedures to ensure timely completion of its audit and submission of the audit package to the Federal Audit Clearinghouse. View of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2022-001 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Data Collection Form Late Filing Major Programs: AL#10.557 - WIC Special Supplemental Nutrition Program for Women, Infants and Children ? Award numbers: CD3-21-4658A, CD3-21-4658B and CD3-22-4658 AL#21.023 ? COVID-19 - Emergency Rental Assistance Program ? Award numbers - None AL#93.568 - Low Income Home Energy Assistance Program ? Award numbers - None Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Requirement Condition: The Organization did not submit the data collection form and reporting package, for the year ended August 31, 2021, to the Federal Audit Clearinghouse in a timely manner. Criteria: The Report Submission that is codified in 2 CFR Part 200.512 requires the auditee must submit the applicable data elements of the data collection form to the Federal Audit Clearinghouse 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: Management did not certify the auditee section timely. Effect: The Organization was not in compliance with audit submission requirements, resulting in a non-material noncompliance and significant deficiency in internal controls over compliance. Recommendation: We recommend the Organization implement systems and procedures to ensure timely completion of its audit and submission of the audit package to the Federal Audit Clearinghouse. View of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
DEPARTMENT OF HEALTH AND HUMAN SERVICES HeadStart, CFDA # 93.600 2022 - 03: Criteria: 2 CFR 200.512(a) requires that (SF) 425 form must be submitted on a quarterly and semi-annual basis no later than 30 days after the end of each reporting period. Annual report shall be submitted no later than 90 days after the end of each report period. (SF) 429 form must be submitted on an annual basis no later than 90 days after the project or grant period end date. Condition: In gaining our understanding of control over (SF) 425 and (SF) 429 forms, we noted the following controls: (SF) 425 form must be submitted quarterly basis and (SF) 429 form must be submitted annually. We reviewed (SF) 425 forms for the 2nd quarter and 4th quarter noted that amounts did not agreed to the general ledger and quarterly reports were submitted late. Form (SF) 429 was not submitted in a timely manner at all. Cause: The Agency had significant turnover for the whole year of 2021 and 2022. This resulted in significant delays in getting ready or providing information and submitted the required forms to the funder agency. Effect: This delay and in accuracy in reporting to the governmental entity could cause some confusion by the governmental entity in exactly how much funds were spent during the quarter and prevents the Agency in tracking their grant funds spent and how much is remaining. This could result in overspending on the grant. Auditor?s Recommendation: We recommend that when there is a significant vacancy in the accounting department, the Agency finds some temporary help to keep the accounting records accurate and up to date. This will enable the Agency to have adequate and complete accounting records to meet reporting requirements. Management response: Due to significant employee turnover in the accounting department, SF-425 and SF-429 reports were not submitted in a timely manner or with information matching the general ledger. The new accounting team is in place and is in the process of correcting and resubmitting or submitting the reports. The accounting team will submit accurate SF-425 and SF-429 reports in a timely manner moving forward.
Condition: An audit of the financial statements of the District along with the required single audit, as required by the Uniform Guidance, was not filed within the required time frame. Criteria: 2 CFR 200.512. Cause of Condition: The District’s books and records were not prepared in time to perform the financial statement audit and single audit. Fiscal year 2022 financial statement audit and single audit was performed in 2025. Effect of Condition: Delinquent filing with the federal audit clearinghouse (FAC), potential for lost records and other information needed to perform and complete the financial statement audit and single audit. Questioned Cost: none. Recommendation: Draft and adopt policies and procedures to ensure the District’s financial records are ready for audit with sufficient time to timely file with the FAC. Corrective Action Plan: The District will implement procedures to ensure financial records are closed and ready for audit within 90 days of fiscal year-end. A calendar of key audit deadlines will be established, and staff will coordinate with the external auditor each quarter to maintain audit readiness and ensure timely FAC submission. Contact Person: Grant Accounting Specialist Anticipated Completion Date: 11/01/2026
Statement of condition #2022-001: The Corporation did not file the data collection form SF-SAC as of and for the year ended July 31, 2021 with the Federal Audit Clearinghouse by the required date of April 30, 2022. Criteria: Pursuant to Section 18 of the Regulatory Agreement, non-profit borrowers are to follow audit requirements specified in the OMB Compliance Supplement. The OMB Compliance Supplement requires the data collection form SF-SAC to be filed with the Federal Audit Clearinghouse in a timely manner, as required by 2 CFR 200.512. The required timeframe specified by 2 CFR 200.512 is the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. The deadline to file the data collection form SF-SAC was April 30, 2022. Effect: The Corporation was not in compliance with the Regulatory Agreement or the OMB Compliance Supplement. Cause: Due to administrative delays, the Corporation did not file the data collection form SF-SAC by April 30, 2022. Recommendation: The data collection form SF-SAC should be filed with the Federal Audit Clearinghouse in a timely manner pursuant to the time frame set forth by OMB. Completion date: June 1, 2022 Management's response: Management concurs with the finding and agrees with the recommendation. The data collection form SF-SAC as of and for the year ended July 31, 2021 has been filed with the Federal Audit Clearinghouse. No further action is required.
Statement of condition #2022-001: The Corporation did not file the data collection form SF-SAC as of and for the year ended July 31, 2021, with the Federal Audit Clearinghouse by the required date of April 30, 2022. Criteria: Pursuant to Section 18 of the Regulatory Agreement, non-profit borrowers are to follow audit requirements specified in the OMB Compliance Supplement. The OMB Compliance Supplement requires the data collection form SF-SAC to be filed with the Federal Audit Clearinghouse in a timely manner, as required by 2 CFR 200.512. The required timeframe specified by 2 CFR 200.512 is the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. The deadline to file the data collection form SF-SAC was April 30, 2022. Effect: The Corporation was not in compliance with the Regulatory Agreement or the OMB Compliance Supplement. Cause: Due to administrative delays, the Corporation did not file the data collection form SF-SAC by April 30, 2022. Recommendation: The data collection form SF-SAC should be filed with the Federal Audit Clearinghouse in a timely manner pursuant to the time frame set worth by OMB. Proposed completion date: May 4, 2022 Management's response: Management concurs with the finding and agrees with the recommendation. The data collection form SF-SAC as of and for the year ended July 31, 2021, was filed with the Federal Audit Clearinghouse on May 4, 2022. No further action is required.
Lack of Internal Control over Reporting, Health Resources and Services Administration, United States Department of Health and Human Services, Native Hawaiian Health Care 93.932 Criteria: 2 CFR § 200.512 Report submission (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. In addition, HRSA, the major fund grantor, required timely submission of the grants’ annual and quarterly Federal Financial Report (FFR) and Native Hawaiian Data System reports. Government Auditing Standards require adequate internal controls over accounting functions. These internal controls should reduce to a relatively low level of risk that noncompliance with applicable requirements of laws, regulations, contracts, and grants would be material in relation to a federal program being audited may occur and not be detected in a timely manner by employees in the normal course of performing their assigned functions. Conditions: We noted a lack of internal control over Reporting and noncompliance with the timely on-line submission of the annual audit report to the Federal Audit Clearinghouse. Also, during the fiscal year the HRSA grant’s required quarterly financial reports (QFRs) and UDS reports were not available. Cause: Management had turnover and financial data was not prepared accurately and timely to properly report the audited financial statements to the Federal Audit Clearinghouse. Potential Effect: A lack of internal controls over required compliance requirements could affect the Organization receiving future federal funding. Questioned Costs: None 2022-003, Lack of Internal Control over Reporting, Health Resources and Services Administration, United States Department of Health and Human Services, Native Hawaiian Health Care 93.932 (Continued) Recommendations: We recommend management complete all required reporting timely. Repeat Finding: Yes. See Summary Schedule of Prior Audit Finding, Finding 2021-003 Views of Responsible Officials of the Auditee: The Organization concurs with the finding and recommendation. See Management Responses and Corrective Action Plans.
Lack of Internal Control over Reporting, Health Resources and Services Administration, United States Department of Health and Human Services, Native Hawaiian Health Care 93.932 Criteria: 2 CFR § 200.512 Report submission (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. In addition, HRSA, the major fund grantor, required timely submission of the grants’ annual and quarterly Federal Financial Report (FFR) and Native Hawaiian Data System reports. Government Auditing Standards require adequate internal controls over accounting functions. These internal controls should reduce to a relatively low level of risk that noncompliance with applicable requirements of laws, regulations, contracts, and grants would be material in relation to a federal program being audited may occur and not be detected in a timely manner by employees in the normal course of performing their assigned functions. Conditions: We noted a lack of internal control over Reporting and noncompliance with the timely on-line submission of the annual audit report to the Federal Audit Clearinghouse. Also, during the fiscal year the HRSA grant’s required quarterly financial reports (QFRs) and UDS reports were not available. Cause: Management had turnover and financial data was not prepared accurately and timely to properly report the audited financial statements to the Federal Audit Clearinghouse. Potential Effect: A lack of internal controls over required compliance requirements could affect the Organization receiving future federal funding. Questioned Costs: None 2022-003, Lack of Internal Control over Reporting, Health Resources and Services Administration, United States Department of Health and Human Services, Native Hawaiian Health Care 93.932 (Continued) Recommendations: We recommend management complete all required reporting timely. Repeat Finding: Yes. See Summary Schedule of Prior Audit Finding, Finding 2021-003 Views of Responsible Officials of the Auditee: The Organization concurs with the finding and recommendation. See Management Responses and Corrective Action Plans.
Lack of Internal Control over Reporting, Health Resources and Services Administration, United States Department of Health and Human Services, Native Hawaiian Health Care 93.932 Criteria: 2 CFR § 200.512 Report submission (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. In addition, HRSA, the major fund grantor, required timely submission of the grants’ annual and quarterly Federal Financial Report (FFR) and Native Hawaiian Data System reports. Government Auditing Standards require adequate internal controls over accounting functions. These internal controls should reduce to a relatively low level of risk that noncompliance with applicable requirements of laws, regulations, contracts, and grants would be material in relation to a federal program being audited may occur and not be detected in a timely manner by employees in the normal course of performing their assigned functions. Conditions: We noted a lack of internal control over Reporting and noncompliance with the timely on-line submission of the annual audit report to the Federal Audit Clearinghouse. Also, during the fiscal year the HRSA grant’s required quarterly financial reports (QFRs) and UDS reports were not available. Cause: Management had turnover and financial data was not prepared accurately and timely to properly report the audited financial statements to the Federal Audit Clearinghouse. Potential Effect: A lack of internal controls over required compliance requirements could affect the Organization receiving future federal funding. Questioned Costs: None 2022-003, Lack of Internal Control over Reporting, Health Resources and Services Administration, United States Department of Health and Human Services, Native Hawaiian Health Care 93.932 (Continued) Recommendations: We recommend management complete all required reporting timely. Repeat Finding: Yes. See Summary Schedule of Prior Audit Finding, Finding 2021-003 Views of Responsible Officials of the Auditee: The Organization concurs with the finding and recommendation. See Management Responses and Corrective Action Plans.
Statement of condition #2022-001: The Corporation did not file the data collection form SF-SAC as of and for the year ended July 31, 2021 with the Federal Audit Clearinghouse by the required date of April 30, 2022. Criteria: Pursuant to Section 18 of the Regulatory Agreement, non-profit borrowers are to follow audit requirements specified in the OMB Compliance Supplement. The OMB Compliance Supplement requires the data collection form SF-SAC to be filed with the Federal Audit Clearinghouse in a timely manner, as required by 2 CFR 200.512. The required timeframe specified by 2 CFR 200.512 is the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. The deadline to file the data collection form SF-SAC was April 30, 2022. Effect: The Corporation was not in compliance with the Regulatory Agreement or the OMB Compliance Supplement. Cause: Due to administrative delays, the Corporation did not file the data collection form SF-SAC by April 30, 2022. Recommendation: The data collection form SF-SAC should be filed with the Federal Audit Clearinghouse in a timely manner pursuant to the time frame set forth by OMB. Completion date: June 1, 2022 Management's response: Management concurs with the finding and agrees with the recommendation. The data collection form SF-SAC as of and for the year ended July 31, 2021 has been filed with the Federal Audit Clearinghouse. No further action is required.
Statement of condition #2022-001: The Corporation did not file the data collection form SF-SAC as of and for the year ended July 31, 2021, with the Federal Audit Clearinghouse by the required date of April 30, 2022. Criteria: Pursuant to Section 18 of the Regulatory Agreement, non-profit borrowers are to follow audit requirements specified in the OMB Compliance Supplement. The OMB Compliance Supplement requires the data collection form SF-SAC to be filed with the Federal Audit Clearinghouse in a timely manner, as required by 2 CFR 200.512. The required timeframe specified by 2 CFR 200.512 is the earlier of 30 calendar days after receipt of the auditor's report or nine months after the end of the audit period. The deadline to file the data collection form SF-SAC was April 30, 2022. Effect: The Corporation was not in compliance with the Regulatory Agreement or the OMB Compliance Supplement. Cause: Due to administrative delays, the Corporation did not file the data collection form SF-SAC by April 30, 2022. Recommendation: The data collection form SF-SAC should be filed with the Federal Audit Clearinghouse in a timely manner pursuant to the time frame set worth by OMB. Proposed completion date: May 4, 2022 Management's response: Management concurs with the finding and agrees with the recommendation. The data collection form SF-SAC as of and for the year ended July 31, 2021, was filed with the Federal Audit Clearinghouse on May 4, 2022. No further action is required.
Lack of Internal Control over Reporting, Health Resources and Services Administration, United States Department of Health and Human Services, Native Hawaiian Health Care 93.932 Criteria: 2 CFR § 200.512 Report submission (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. In addition, HRSA, the major fund grantor, required timely submission of the grants’ annual and quarterly Federal Financial Report (FFR) and Native Hawaiian Data System reports. Government Auditing Standards require adequate internal controls over accounting functions. These internal controls should reduce to a relatively low level of risk that noncompliance with applicable requirements of laws, regulations, contracts, and grants would be material in relation to a federal program being audited may occur and not be detected in a timely manner by employees in the normal course of performing their assigned functions. Conditions: We noted a lack of internal control over Reporting and noncompliance with the timely on-line submission of the annual audit report to the Federal Audit Clearinghouse. Also, during the fiscal year the HRSA grant’s required quarterly financial reports (QFRs) and UDS reports were not available. Cause: Management had turnover and financial data was not prepared accurately and timely to properly report the audited financial statements to the Federal Audit Clearinghouse. Potential Effect: A lack of internal controls over required compliance requirements could affect the Organization receiving future federal funding. Questioned Costs: None 2022-003, Lack of Internal Control over Reporting, Health Resources and Services Administration, United States Department of Health and Human Services, Native Hawaiian Health Care 93.932 (Continued) Recommendations: We recommend management complete all required reporting timely. Repeat Finding: Yes. See Summary Schedule of Prior Audit Finding, Finding 2021-003 Views of Responsible Officials of the Auditee: The Organization concurs with the finding and recommendation. See Management Responses and Corrective Action Plans.
Lack of Internal Control over Reporting, Health Resources and Services Administration, United States Department of Health and Human Services, Native Hawaiian Health Care 93.932 Criteria: 2 CFR § 200.512 Report submission (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. In addition, HRSA, the major fund grantor, required timely submission of the grants’ annual and quarterly Federal Financial Report (FFR) and Native Hawaiian Data System reports. Government Auditing Standards require adequate internal controls over accounting functions. These internal controls should reduce to a relatively low level of risk that noncompliance with applicable requirements of laws, regulations, contracts, and grants would be material in relation to a federal program being audited may occur and not be detected in a timely manner by employees in the normal course of performing their assigned functions. Conditions: We noted a lack of internal control over Reporting and noncompliance with the timely on-line submission of the annual audit report to the Federal Audit Clearinghouse. Also, during the fiscal year the HRSA grant’s required quarterly financial reports (QFRs) and UDS reports were not available. Cause: Management had turnover and financial data was not prepared accurately and timely to properly report the audited financial statements to the Federal Audit Clearinghouse. Potential Effect: A lack of internal controls over required compliance requirements could affect the Organization receiving future federal funding. Questioned Costs: None 2022-003, Lack of Internal Control over Reporting, Health Resources and Services Administration, United States Department of Health and Human Services, Native Hawaiian Health Care 93.932 (Continued) Recommendations: We recommend management complete all required reporting timely. Repeat Finding: Yes. See Summary Schedule of Prior Audit Finding, Finding 2021-003 Views of Responsible Officials of the Auditee: The Organization concurs with the finding and recommendation. See Management Responses and Corrective Action Plans.
Lack of Internal Control over Reporting, Health Resources and Services Administration, United States Department of Health and Human Services, Native Hawaiian Health Care 93.932 Criteria: 2 CFR § 200.512 Report submission (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. In addition, HRSA, the major fund grantor, required timely submission of the grants’ annual and quarterly Federal Financial Report (FFR) and Native Hawaiian Data System reports. Government Auditing Standards require adequate internal controls over accounting functions. These internal controls should reduce to a relatively low level of risk that noncompliance with applicable requirements of laws, regulations, contracts, and grants would be material in relation to a federal program being audited may occur and not be detected in a timely manner by employees in the normal course of performing their assigned functions. Conditions: We noted a lack of internal control over Reporting and noncompliance with the timely on-line submission of the annual audit report to the Federal Audit Clearinghouse. Also, during the fiscal year the HRSA grant’s required quarterly financial reports (QFRs) and UDS reports were not available. Cause: Management had turnover and financial data was not prepared accurately and timely to properly report the audited financial statements to the Federal Audit Clearinghouse. Potential Effect: A lack of internal controls over required compliance requirements could affect the Organization receiving future federal funding. Questioned Costs: None 2022-003, Lack of Internal Control over Reporting, Health Resources and Services Administration, United States Department of Health and Human Services, Native Hawaiian Health Care 93.932 (Continued) Recommendations: We recommend management complete all required reporting timely. Repeat Finding: Yes. See Summary Schedule of Prior Audit Finding, Finding 2021-003 Views of Responsible Officials of the Auditee: The Organization concurs with the finding and recommendation. See Management Responses and Corrective Action Plans.
2022-002 - Reporting (Material Weakness) Federal program information: Federal agency: U.S. Department of Human Health and Services Pass-through agency:: PRC Title: Housing Opportunities for Persons with AIDS ALN number: 14.241 Criteria: The OMB Uniform Guidance and contract with federal funding agency require that non-federal entities receiving federal awards establish and maintain internal control designed to reasonably ensure compliance with federal laws, regulations and program compliance requirements as follows: Section 2 CFR 200.512 of the Uniform Guidance states: 1. 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. 2. Data Collection. The FAC is the repository of record for Subpart F-Audit Requirements of this Part reporting packages and the data collection form. All federal agencies, pass-through entities and others interested in a reporting package and data collection form must obtain it by accessing the FAC. Condition: The audit package and data collection form were not submitted to the Federal Audit Clearinghouse for the reporting year ended June 30, 2022, within 9 months after the audit period. Effect: Baker Places, Inc.n is deficient in its submission of the required audit reporting package and data collection form. As such, Baker Places, Inc. is noncompliant with the reporting requirements. Questioned Costs: None. Cause: Baker Places, Inc. does not have internal control procedures to ensure timely submission of a financial reports. Repeat finding: Yes Recommendation: We recommended that Baker Places, Inc. implement policies, procedures and controls to ensure compliance with the reporting requirements. Baker Places, Inc. should designate an individual that has thorough knowledge of both the program and the compliance requirements to monitor, review and approve all required reports including knowledge of reporting deadlines and ensure timely submission of all required reports to the funding agency. Evidence of submission should also be maintained as part of program documentation.
Finding 2022-004 Reporting - Timely Submission of Financial Reports – Material Weakness in Internal control over Financial Reporting and Material Noncompliance Agency U.S. Department of Treasury Program ALN: No. 21.027 Coronavirus State and Local Fiscal Recovery Funds - COVID-19 Award No. AK0137 Award Year 2022 Criteria or Specific Requirement 2 CFR subtitle A Chapter II part 200 subpart F section 200.512 states that “(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.” Condition The Federal data collection form and reporting package were not filed on time. Cause There were limited personnel resources at the City to assist in the timely completion of the City’s audit. Effect or potential effect Federal funds could potentially be expended on unallowable activities and for unallowed costs, and outside the period of performance. Questioned Costs None. Context The Form SF-SAC is due nine months after the fiscal year-end. The form for the fiscal year ended June 30, 2022 was filed late. Recommendation The City should prepare for its fiscal year audit before year end to ensure that it is able to assist in the execution of the audit. Views of responsible officials and planned corrective actions Management agrees with the finding. The City recently hired a Finance Director and is working to fill the Controller position. Being fully staffed will assist in the timely completion of the City’s audit.
Identification of the Federal Program: Assistance Listing Number 17.259 – WIOA Youth Activities Program – U.S. Department of Labor. Pass-through Entity: New York City Department of Youth and Community Development. Award Number: 90535A / 90536A / 90537A / 90538A. Compliance Requirement: Reporting Criteria: Requirements per section 2 CFR Part 200.512 of the Uniform Guidance states that the audit and data collection form must be 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. Condition: As a result of the timing of the audit, the applicable reporting deadline was not met. Cause: With personnel changes at most levels within the Organization and delays attributed to the additional findings above, the audit and data collection form were not able to be completed by the stated deadline. Effect or Potential Effect: The reporting deadline was not met which could lead to loss of federal awards. Questioned Costs: Not applicable. Context: Not applicable. Recommendation: We recommend the Organization addresses the additional findings listed above which will lead to the timely completion of the audit and timely submission of the data collection form. View of Responsible Officials: The Organization concurs with the finding and the related recommendation. The data collection form will be timely submitted for the year ended June 30, 2023.
Identification of the Federal Program: Assistance Listing Number 17.259 – WIOA Youth Activities Program – U.S. Department of Labor. Pass-through Entity: New York City Department of Youth and Community Development. Award Number: 90535A / 90536A / 90537A / 90538A. Compliance Requirement: Reporting Criteria: Requirements per section 2 CFR Part 200.512 of the Uniform Guidance states that the audit and data collection form must be 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. Condition: As a result of the timing of the audit, the applicable reporting deadline was not met. Cause: With personnel changes at most levels within the Organization and delays attributed to the additional findings above, the audit and data collection form were not able to be completed by the stated deadline. Effect or Potential Effect: The reporting deadline was not met which could lead to loss of federal awards. Questioned Costs: Not applicable. Context: Not applicable. Recommendation: We recommend the Organization addresses the additional findings listed above which will lead to the timely completion of the audit and timely submission of the data collection form. View of Responsible Officials: The Organization concurs with the finding and the related recommendation. The data collection form will be timely submitted for the year ended June 30, 2023.
Identification of the Federal Program: Assistance Listing Number 17.259 – WIOA Youth Activities Program – U.S. Department of Labor. Pass-through Entity: New York City Department of Youth and Community Development. Award Number: 90535A / 90536A / 90537A / 90538A. Compliance Requirement: Reporting Criteria: Requirements per section 2 CFR Part 200.512 of the Uniform Guidance states that the audit and data collection form must be 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. Condition: As a result of the timing of the audit, the applicable reporting deadline was not met. Cause: With personnel changes at most levels within the Organization and delays attributed to the additional findings above, the audit and data collection form were not able to be completed by the stated deadline. Effect or Potential Effect: The reporting deadline was not met which could lead to loss of federal awards. Questioned Costs: Not applicable. Context: Not applicable. Recommendation: We recommend the Organization addresses the additional findings listed above which will lead to the timely completion of the audit and timely submission of the data collection form. View of Responsible Officials: The Organization concurs with the finding and the related recommendation. The data collection form will be timely submitted for the year ended June 30, 2023.
Identification of the Federal Program: Assistance Listing Number 17.259 – WIOA Youth Activities Program – U.S. Department of Labor. Pass-through Entity: New York City Department of Youth and Community Development. Award Number: 90535A / 90536A / 90537A / 90538A. Compliance Requirement: Reporting Criteria: Requirements per section 2 CFR Part 200.512 of the Uniform Guidance states that the audit and data collection form must be 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. Condition: As a result of the timing of the audit, the applicable reporting deadline was not met. Cause: With personnel changes at most levels within the Organization and delays attributed to the additional findings above, the audit and data collection form were not able to be completed by the stated deadline. Effect or Potential Effect: The reporting deadline was not met which could lead to loss of federal awards. Questioned Costs: Not applicable. Context: Not applicable. Recommendation: We recommend the Organization addresses the additional findings listed above which will lead to the timely completion of the audit and timely submission of the data collection form. View of Responsible Officials: The Organization concurs with the finding and the related recommendation. The data collection form will be timely submitted for the year ended June 30, 2023.
Identification of the Federal Program: Assistance Listing Number 17.259 – WIOA Youth Activities Program – U.S. Department of Labor. Pass-through Entity: New York City Department of Youth and Community Development. Award Number: 90535A / 90536A / 90537A / 90538A. Compliance Requirement: Reporting Criteria: Requirements per section 2 CFR Part 200.512 of the Uniform Guidance states that the audit and data collection form must be 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. Condition: As a result of the timing of the audit, the applicable reporting deadline was not met. Cause: With personnel changes at most levels within the Organization and delays attributed to the additional findings above, the audit and data collection form were not able to be completed by the stated deadline. Effect or Potential Effect: The reporting deadline was not met which could lead to loss of federal awards. Questioned Costs: Not applicable. Context: Not applicable. Recommendation: We recommend the Organization addresses the additional findings listed above which will lead to the timely completion of the audit and timely submission of the data collection form. View of Responsible Officials: The Organization concurs with the finding and the related recommendation. The data collection form will be timely submitted for the year ended June 30, 2023.
Identification of the Federal Program: Assistance Listing Number 17.259 – WIOA Youth Activities Program – U.S. Department of Labor. Pass-through Entity: New York City Department of Youth and Community Development. Award Number: 90535A / 90536A / 90537A / 90538A. Compliance Requirement: Reporting Criteria: Requirements per section 2 CFR Part 200.512 of the Uniform Guidance states that the audit and data collection form must be 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. Condition: As a result of the timing of the audit, the applicable reporting deadline was not met. Cause: With personnel changes at most levels within the Organization and delays attributed to the additional findings above, the audit and data collection form were not able to be completed by the stated deadline. Effect or Potential Effect: The reporting deadline was not met which could lead to loss of federal awards. Questioned Costs: Not applicable. Context: Not applicable. Recommendation: We recommend the Organization addresses the additional findings listed above which will lead to the timely completion of the audit and timely submission of the data collection form. View of Responsible Officials: The Organization concurs with the finding and the related recommendation. The data collection form will be timely submitted for the year ended June 30, 2023.
Identification of the Federal Program: Assistance Listing Number 17.259 – WIOA Youth Activities Program – U.S. Department of Labor. Pass-through Entity: New York City Department of Youth and Community Development. Award Number: 90535A / 90536A / 90537A / 90538A. Compliance Requirement: Reporting Criteria: Requirements per section 2 CFR Part 200.512 of the Uniform Guidance states that the audit and data collection form must be 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. Condition: As a result of the timing of the audit, the applicable reporting deadline was not met. Cause: With personnel changes at most levels within the Organization and delays attributed to the additional findings above, the audit and data collection form were not able to be completed by the stated deadline. Effect or Potential Effect: The reporting deadline was not met which could lead to loss of federal awards. Questioned Costs: Not applicable. Context: Not applicable. Recommendation: We recommend the Organization addresses the additional findings listed above which will lead to the timely completion of the audit and timely submission of the data collection form. View of Responsible Officials: The Organization concurs with the finding and the related recommendation. The data collection form will be timely submitted for the year ended June 30, 2023.
Identification of the Federal Program: Assistance Listing Number 17.259 – WIOA Youth Activities Program – U.S. Department of Labor. Pass-through Entity: New York City Department of Youth and Community Development. Award Number: 90535A / 90536A / 90537A / 90538A. Compliance Requirement: Reporting Criteria: Requirements per section 2 CFR Part 200.512 of the Uniform Guidance states that the audit and data collection form must be 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. Condition: As a result of the timing of the audit, the applicable reporting deadline was not met. Cause: With personnel changes at most levels within the Organization and delays attributed to the additional findings above, the audit and data collection form were not able to be completed by the stated deadline. Effect or Potential Effect: The reporting deadline was not met which could lead to loss of federal awards. Questioned Costs: Not applicable. Context: Not applicable. Recommendation: We recommend the Organization addresses the additional findings listed above which will lead to the timely completion of the audit and timely submission of the data collection form. View of Responsible Officials: The Organization concurs with the finding and the related recommendation. The data collection form will be timely submitted for the year ended June 30, 2023.
2 CFR section 200.512(a) requires the reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 calendar days after the reports are received from the auditor or nine months after the end of the audit period. The June 30, 2022 Single Audit reporting package and data collection form was filed thirteen (13) months after the fiscal year-end. Four months late.
2022-001 Single Audit Submission Significant Deficiency Criteria: The Federal Office of Management and Budget (OMB) Circular 2 CFR 200.512(a) requires that a non-profit organization expending $750,000 or more in total cumulative Federal funds must have a Single Audit performed in accordance with the Single Audit Act. This audit reporting package must normally be submitted and received by the Federal Audit Clearinghouse (FAC) the earlier of 30 days after the report date or nine months after the fiscal year end. The due date for submission of WNCAP’s June 30, 2022, audit to the Clearinghouse was March 31, 2023. Condition: The WNCAP Single Audit was not submitted to the Federal Audit Clearinghouse within the prescribed period. Cause: Turnover in key finance positions along with COVID caused delays in the completion of the prior year audit which in turn affected the completion and timely filing of the current year Single Audit. Effect: Management was not in compliance with the requirement to timely submit the Single Audit to the FAC. Identification of a Repeat Finding: This is a repeat finding from the immediate previous audit, 2021-002. Recommendation: Management should implement procedures ensure that the financial statements are submitted to the FAC in accordance with filing requirements. Management’s View: We agree with this finding and have outlined our response in our Corrective Action Plan.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) 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.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.