Audit 41388

FY End
2022-09-30
Total Expended
$10.97M
Findings
8
Programs
10
Organization: Midcoast Maine Community Action (ME)
Year: 2022 Accepted: 2023-05-29
Auditor: One River CPAS

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
45431 2022-002 Material Weakness - L
45432 2022-002 Material Weakness - L
45433 2022-002 Material Weakness - L
45434 2022-002 Material Weakness - L
621873 2022-002 Material Weakness - L
621874 2022-002 Material Weakness - L
621875 2022-002 Material Weakness - L
621876 2022-002 Material Weakness - L

Contacts

Name Title Type
HK7HZ2ANUM95 Lindsay Mitchell Auditee
2074427963 Michael McKenney Auditor
No contacts on file

Notes to SEFA

Accounting Policies: PURPOSE OF THE SCHEDULE: The Uniform Guidance requires a Schedule of Expenditures of Federal Awards showing total expenditures for each federal award program as identified in the Catalog of Federal Domestic Assistance (CFDA). SIGNIFICANT ACCOUNTING POLICIES: A. Reporting Entity - The accompanying schedule includes all federal award programs of Midcoast Maine Community Action for the fiscal year ended September 30, 2022. The reporting entity is defined in the notes to financial statements of Midcoast Maine Community Action. B. Basis of Presentation - The information in the accompanying schedule of expenditures of federal awards is presented in accordance with the Uniform Guidance. 1. Pursuant to the Uniform Guidance, federal awards are defined as assistance provided by a federal agency, either directly or indirectly, in the form of grants, contracts, cooperative agreements, loans, loan guarantees, property, interest subsidies, insurance, or direct appropriations. 2. Major Programs - The Uniform Guidance establishes the level of expenditures or expenses to be used in defining major federal award programs. Major programs for the Midcoast Maine Community Action are identified in the summary of auditors results section of the Schedule of Findings and Questioned Costs. C. Basis of Accounting - The information presented in the Schedule of Expenditures of Federal Awards is presented on the accrual basis of accounting, which is consistent with the reporting in the Midcoast Maine Community Actions financial statements. The expenditures reported are recognized following the cost principals contained in the Uniform Guidance wherein certain types of expenditures are not allowable or are limited as to reimbursement. D. Indirect Cost Rate - The Organization has not elected to use the 10% de minimis indirect cost rate. E. Donated Personal Protective Equipment (PPE) - The Organization received no donations of federally funded PPE during the year ended September 30, 2022. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.