Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
2022-002 ? Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Information on the Federal Program: U.S. Small Business Administration Assistance Listing Number: 59.008 Assistance Listing Name: Economic Injury Disaster Loan Criteria ? The Code of Federal Regulation (CFR) Section ?200.510(b) states in part: ?The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section ?200.502 Basis for determining Federal awards expended.? The schedule must provide total Federal awards expended for each individual Federal program. In accordance with ?200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?200.328 Financial Reporting and ?200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition ? During the year ended August 31, 2022, the Center received additional EIDL funds. Prior to the COVID-19 pandemic, the Center did not receive and spend federal dollars in excess of the limit that required a single audit to be performed. Due to the lack of expertise surrounding the preparation of the SEFA and the non-recurring nature of the COVID-19 pandemic relief funding provided by the federal government, the Center was uncertain of some of the specifics on the SEFA statement. Cause ? The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect ? Management was unaware that the EIDL was a federal award requiring a single audit prior to discussion with the auditors. Questioned Costs: There are no questioned costs related to the items described above. Context: The conditions outlined above are based on our testing of the Center?s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Repeat Finding: This is not a repeat finding. Recommendation ? We recommend management attend Federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the Federal funds are reported accurately on the SEFA and that programs are reported under the correct assistance listing number. Views of Responsible Officials ? Beck Center for the Arts concurs with the finding and the recommendation. The Center will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. The Center?s corrective action plan is described in Managements Corrective Action Plan included at page 42 of this reporting package.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Preparation of Schedule of Expenditures of Federal Awards (All Federal Awards) Condition: The District did not prepare a Schedule of Expenditures of Federal Awards (SEFA). Criteria: 2CFR Section 200.510(b) of Uniform Guidance requires minimum data elements for preparation of the Schedule of Expenditures of Federal Awards. Effect of the Condition: Corrections were required to have accurate figures, determination of clusters, and listing by programs of federal agency. Cause of the Condition: The District separately lists federal expenditures using a specific grouping number for each grant separately and relies on this information for tracking federal revenue and expenditures. Recommendation: The District should document each federal program including the federal agency, clusters, and total federal expenditures. Auditee Response: Management will complete the SEFA annually in future years.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.
Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards state in summary that management should authorize, process, reconcile and close out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The close out process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff do not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to properly present the financial statements and disclosures of the Agency as of July 31, 2022. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.) Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e., SF-425, LIHEAP reporting, etc.). The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR ?200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ??200.327 Financial reporting and 200.328 Monitoring and reporting program performance [2 CFR ?200.302(b)(2)]. Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. The implementation of a new accounting system without an adequate close out of the old system was determined to be the systemic cause. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency is determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountants and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant?s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statement close out process is achieved each month and annually. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the agency?s financial funding sources, the agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst?s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and uniform guidance regulations. The new automated financial system, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2023.
Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards state in summary that management should authorize, process, reconcile and close out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The close out process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff do not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to properly present the financial statements and disclosures of the Agency as of July 31, 2022. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.) Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e., SF-425, LIHEAP reporting, etc.). The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR ?200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ??200.327 Financial reporting and 200.328 Monitoring and reporting program performance [2 CFR ?200.302(b)(2)]. Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. The implementation of a new accounting system without an adequate close out of the old system was determined to be the systemic cause. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency is determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountants and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant?s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statement close out process is achieved each month and annually. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the agency?s financial funding sources, the agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst?s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and uniform guidance regulations. The new automated financial system, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2023.
Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards state in summary that management should authorize, process, reconcile and close out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The close out process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff do not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to properly present the financial statements and disclosures of the Agency as of July 31, 2022. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.) Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e., SF-425, LIHEAP reporting, etc.). The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR ?200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ??200.327 Financial reporting and 200.328 Monitoring and reporting program performance [2 CFR ?200.302(b)(2)]. Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. The implementation of a new accounting system without an adequate close out of the old system was determined to be the systemic cause. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency is determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountants and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant?s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statement close out process is achieved each month and annually. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the agency?s financial funding sources, the agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst?s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and uniform guidance regulations. The new automated financial system, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2023.
Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards state in summary that management should authorize, process, reconcile and close out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The close out process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff do not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to properly present the financial statements and disclosures of the Agency as of July 31, 2022. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.) Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e., SF-425, LIHEAP reporting, etc.). The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR ?200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ??200.327 Financial reporting and 200.328 Monitoring and reporting program performance [2 CFR ?200.302(b)(2)]. Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. The implementation of a new accounting system without an adequate close out of the old system was determined to be the systemic cause. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency is determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountants and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant?s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statement close out process is achieved each month and annually. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the agency?s financial funding sources, the agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst?s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and uniform guidance regulations. The new automated financial system, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2023.
Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards state in summary that management should authorize, process, reconcile and close out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The close out process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff do not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to properly present the financial statements and disclosures of the Agency as of July 31, 2022. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.) Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e., SF-425, LIHEAP reporting, etc.). The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR ?200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ??200.327 Financial reporting and 200.328 Monitoring and reporting program performance [2 CFR ?200.302(b)(2)]. Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. The implementation of a new accounting system without an adequate close out of the old system was determined to be the systemic cause. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency is determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountants and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant?s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statement close out process is achieved each month and annually. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the agency?s financial funding sources, the agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst?s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and uniform guidance regulations. The new automated financial system, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2023.
Finding 2022-002: Inaccurate SEFA - Material Weakness Name of Federal Agency: U.S. Department of Health and Human Services Federal Program Name and Assistance Listing Number: CCDF Cluster, 93.575 Federal Award Identification Number and Year: 2101HICSC6, 2021 Name of Pass-through Entity: State of Hawaii Department of Human Services Criteria: In accordance with 2 CFR 200.302 (Financial Management), a grant recipient's financial management system must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. In addition, 2 CFR 200.510 (Financial Statements) states in part that the auditee must prepare a schedule of expenditures of Federal awards ("SEFA") for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. At a minimum, the schedule must include: • All individual Federal programs by Federal agency. • For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. • Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. • Include the total amount provided to subrecipients from each Federal program. Condition: The Organization had a significant revision to the SEFA and management's initial review and approval process did not detect the error. Cause: The Organization's internal controls over the preparation and review of the SEFA were not operating effectively. Effect or Potential Effect: Inadequate controls over the preparation of the SEFA could result in financial misstatements or potential noncompliance. Questioned Costs: N/A Context: Management's initial review and approval of the SEFA did not identify $2.5M of expenditures that should have been recorded in the subsequent fiscal year. Identification as a Repeat Finding: This finding is not a repeat finding. Recommendation: We recommend the Organization strengthen its policies, procedures, and controls for the identification of federal awards to ensure a complete and accurate SEFA is prepared in a timely manner. Views of Responsible Officials: Management concurs with the finding and will implement a proper expenditure reporting process, reconciled monthly, to avoid recurrence during future audits.
Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards state in summary that management should authorize, process, reconcile and close out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The close out process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff do not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to properly present the financial statements and disclosures of the Agency as of July 31, 2022. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.) Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e., SF-425, LIHEAP reporting, etc.). The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR ?200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ??200.327 Financial reporting and 200.328 Monitoring and reporting program performance [2 CFR ?200.302(b)(2)]. Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. The implementation of a new accounting system without an adequate close out of the old system was determined to be the systemic cause. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency is determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountants and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant?s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statement close out process is achieved each month and annually. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the agency?s financial funding sources, the agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst?s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and uniform guidance regulations. The new automated financial system, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2023.
Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards state in summary that management should authorize, process, reconcile and close out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The close out process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff do not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to properly present the financial statements and disclosures of the Agency as of July 31, 2022. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.) Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e., SF-425, LIHEAP reporting, etc.). The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR ?200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ??200.327 Financial reporting and 200.328 Monitoring and reporting program performance [2 CFR ?200.302(b)(2)]. Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. The implementation of a new accounting system without an adequate close out of the old system was determined to be the systemic cause. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency is determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountants and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant?s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statement close out process is achieved each month and annually. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the agency?s financial funding sources, the agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst?s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and uniform guidance regulations. The new automated financial system, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2023.
Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards state in summary that management should authorize, process, reconcile and close out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The close out process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff do not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to properly present the financial statements and disclosures of the Agency as of July 31, 2022. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.) Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e., SF-425, LIHEAP reporting, etc.). The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR ?200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ??200.327 Financial reporting and 200.328 Monitoring and reporting program performance [2 CFR ?200.302(b)(2)]. Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. The implementation of a new accounting system without an adequate close out of the old system was determined to be the systemic cause. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency is determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountants and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant?s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statement close out process is achieved each month and annually. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the agency?s financial funding sources, the agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst?s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and uniform guidance regulations. The new automated financial system, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2023.
Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards state in summary that management should authorize, process, reconcile and close out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The close out process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff do not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to properly present the financial statements and disclosures of the Agency as of July 31, 2022. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.) Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e., SF-425, LIHEAP reporting, etc.). The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR ?200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ??200.327 Financial reporting and 200.328 Monitoring and reporting program performance [2 CFR ?200.302(b)(2)]. Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. The implementation of a new accounting system without an adequate close out of the old system was determined to be the systemic cause. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency is determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountants and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant?s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statement close out process is achieved each month and annually. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the agency?s financial funding sources, the agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst?s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and uniform guidance regulations. The new automated financial system, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2023.
Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards state in summary that management should authorize, process, reconcile and close out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The close out process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff do not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to properly present the financial statements and disclosures of the Agency as of July 31, 2022. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.) Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e., SF-425, LIHEAP reporting, etc.). The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR ?200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ??200.327 Financial reporting and 200.328 Monitoring and reporting program performance [2 CFR ?200.302(b)(2)]. Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. The implementation of a new accounting system without an adequate close out of the old system was determined to be the systemic cause. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency is determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountants and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant?s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statement close out process is achieved each month and annually. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the agency?s financial funding sources, the agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst?s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and uniform guidance regulations. The new automated financial system, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2023.
Finding 2022-002: Inaccurate SEFA - Material Weakness Name of Federal Agency: U.S. Department of Health and Human Services Federal Program Name and Assistance Listing Number: CCDF Cluster, 93.575 Federal Award Identification Number and Year: 2101HICSC6, 2021 Name of Pass-through Entity: State of Hawaii Department of Human Services Criteria: In accordance with 2 CFR 200.302 (Financial Management), a grant recipient's financial management system must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. In addition, 2 CFR 200.510 (Financial Statements) states in part that the auditee must prepare a schedule of expenditures of Federal awards ("SEFA") for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. At a minimum, the schedule must include: • All individual Federal programs by Federal agency. • For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. • Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. • Include the total amount provided to subrecipients from each Federal program. Condition: The Organization had a significant revision to the SEFA and management's initial review and approval process did not detect the error. Cause: The Organization's internal controls over the preparation and review of the SEFA were not operating effectively. Effect or Potential Effect: Inadequate controls over the preparation of the SEFA could result in financial misstatements or potential noncompliance. Questioned Costs: N/A Context: Management's initial review and approval of the SEFA did not identify $2.5M of expenditures that should have been recorded in the subsequent fiscal year. Identification as a Repeat Finding: This finding is not a repeat finding. Recommendation: We recommend the Organization strengthen its policies, procedures, and controls for the identification of federal awards to ensure a complete and accurate SEFA is prepared in a timely manner. Views of Responsible Officials: Management concurs with the finding and will implement a proper expenditure reporting process, reconciled monthly, to avoid recurrence during future audits.
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.