Corrective Action Plans

Browse how organizations respond to audit findings

Total CAPs
51,573
In database
Filtered Results
539
Matching current filters
Showing Page
18 of 22
25 per page

Filters

Clear
Active filters: § 200.510
Finding 59399 (2022-002)
Significant Deficiency 2022
Views of Responsible Officials The Department of Administrative Services (DAS) concurs. Financial management of individual federal awards is decentralized throughout state agencies which centralizes annually in the culmination of the State?s SEFA. During this process, each agency is required to com...
Views of Responsible Officials The Department of Administrative Services (DAS) concurs. Financial management of individual federal awards is decentralized throughout state agencies which centralizes annually in the culmination of the State?s SEFA. During this process, each agency is required to complete a standardized SEFA analysis and reconciliation tool for review by the DAS prior to the incorporation of the data into the State?s SEFA. This process also includes an annual Single Audit training and update session organized by the DAS. Additionally, the DAS notes all contracts, including subawards, entered by state agencies over a designated threshold are required to be authorized by the State?s Legislative Fiscal Committee and the Governor and Executive Council. The DAS will examine each of these processes to identify additional control activities to improve the accuracy and completeness of the pass through element of the SEFA. Anticipated Completion Date: April 30, 2024 Contact: Steven Giovinelli, Federal Grants and Cost Allocation Administrator, Department of Administrative Services
U.S. Department of Education Mississippi Valley State University (MVSU) respectfully submits the following corrective action plan for the year ended June 30, 2022. Audit period: July 1, 2021 ? June 30, 2022 The findings from the schedule of findings and questioned costs are discussed below. The find...
U.S. Department of Education Mississippi Valley State University (MVSU) respectfully submits the following corrective action plan for the year ended June 30, 2022. Audit period: July 1, 2021 ? June 30, 2022 The findings from the schedule of findings and questioned costs are discussed below. The findings are numbered consistently with the numbers assigned in the schedule. FINDINGS?FEDERAL AWARD PROGRAMS AUDITS 2022-006: SEFA Reporting (MVSU) Education Stabilization Fund - Assistance Listing No. 84.425F Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The Student Accounts Supervisor will make sure that all mandatory reports are provided and posted correctly. If adjustments are required to be made to the initial submission, the Student Accounts Supervisor will submit all adjustments after specifying any changes or updates, noting the date of the change, and post adjustments after the approval of the Vice President of Business and Finance in a timely manner for review and verification prior to the deadline for submission. Name of contact person responsible for corrective action: Brittney Manuel Planned completion date for corrective action plan is July 15, 2023. If the Department of Education has questions regarding this plan, please call Brittney Manuel at 662-254-3914.
View Audit 49406 Questioned Costs: $1
U.S. Department of Agriculture Alcorn State University (ASU) and Mississippi State University (MSU) respectfully submit the following corrective action plans for the year ended June 30, 2022. Audit period: July 1, 2021 ? June 30, 2022 The findings from the schedule of findings and questioned costs a...
U.S. Department of Agriculture Alcorn State University (ASU) and Mississippi State University (MSU) respectfully submit the following corrective action plans for the year ended June 30, 2022. Audit period: July 1, 2021 ? June 30, 2022 The findings from the schedule of findings and questioned costs are discussed below. The findings are numbered consistently with the numbers assigned in the schedule. FINDINGS?FEDERAL AWARD PROGRAMS AUDITS 2022-002: SEFA Reporting (ASU) Cooperative Extension - Assistance Listing No. 10.500 Recommendation: We recommend the institutions review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The Office of Grants and Contracts staff reviewed the federal awards support documentation and updated the ALN numbers in Ellucian Banner system, as needed. This preventative measure will enable us to properly identify and classify all federal expenditures. Name of contact person responsible for corrective action: Sabrena Johnson Planned completion date for corrective action plan is May 31, 2023. If the Department of Agriculture has questions regarding this plan, please call Sabrena Johnson at 601-877-4711. 2022-002: SEFA Reporting (MSU) Cooperative Extension - Assistance Listing No. 10.500 Recommendation: We recommend the institutions review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: Mississippi State University will review and revise current reporting procedures to ensure that federal expenditures are properly identified and classified. Name of contact person responsible for corrective action: Jonathan Tucker, Director of Sponsored Programs Planned completion date for corrective action plan is June 30, 2023. If the Department of Agriculture has questions regarding this plan, please call Jonathan Tucker at jtucker@controller.msstate.edu or 662-325-1930. ____________________________________________________________________________________________ U.S. Department of Health and Human Services The University of Mississippi Medical Center (UMMC) respectfully submits the following corrective action plan for the year ended June 30, 2022. Audit period: July 1, 2021 ? June 30, 2022 The findings from the schedule of findings and questioned costs are discussed below. The findings are numbered consistently with the numbers assigned in the schedule. FINDINGS?FEDERAL AWARD PROGRAMS AUDITS 2022-002: SEFA Reporting (UMMC) Maternal and Child Health Federal Consolidated Programs - Assistance Listing No. 93.110 Recommendation: We recommend the institutions review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: In December 2022, UMMC filled the vacant role of Director, Post-Award. The new Director, Julie Schwindt, a competent professional with the right education and experience, has been hired to step directly into the role and maintain appropriate oversight and responsibility. Julie has 28 years of previous professional experience in this role and related roles. Prior to the implementation of this corrective action, the Director completed a full review of the reports built in Workday to generate SEFA reporting documents with the assistance of the UMMC Department of Information Systems (DIS). The Director has requested removal or renaming of versions that exist relevant to internal purposes, leaving only the version built for financial reporting named as the SEFA or anything similar. The Director has also asked that SEFA report nomenclature have a beginning prefix or name of ?Post Award? affixed to it. In the event future attrition ever causes similar circumstances and a vacancy in a key role, these updates will minimize the possibility that someone unfamiliar with the process will generate the wrong report in Workday, UMMC?s financial reporting system. These recommendations are being fully implemented as an ongoing review and analysis of the Workday SEFA report. Prior to the issuance of this letter, the Director has reviewed operational procedures and has initiated development of written policies and procedures to both the generation and post-generation quality review of the SEFA. The Director has designed operational procedures (detailed below) related to generation of, and post-generation quality review of, the SEFA report to be completed prior to annual submission to MIHL. These updates ensure the balance of expenditures reported on the SEFA are complete and accurate, as well as, reconcile with the Federal revenues identified on the Statement of Retained Earnings and Changes in Net Position. These updates will be added to the UMMC Office of Research and Sponsored Programs Post Award handbook as written policies and/or procedures. SEFA generation and quality review updates: Any reports previously built within Workday utilizing SEFA in the nomenclature that are not intended to function as the external financial reporting template have been renamed or removed; Additional columns have been built into the SEFA report template in Workday to assist post-generation quality review. Columns for Federal revenues by AWD and F&A rate by award have been added to the SEFA reporting template. Inclusion of these details allows Post Award quality reviewers to easily isolate significant differences between balances; and prior to SEFA completion, a Workday report of all project expenditures for the period by sponsor name will be generated and analyzed by Post Award to compare to programs listed on the SEFA. This comparison will assist in determining the completeness of the SEFA and identify programs or contracts lacking an assigned CFDA/ALN number in Workday. These additional Post Award levels of review will ensure appropriate internal controls are effectively in place to address and withstand internal and external audit review. Name of contact person responsible for corrective action: Julie Schwindt, Director Post-Award Planned completion date for corrective action plan: Corrective action plan has been completed prior to the issuance of this letter. Updates to written policy have been requested and are expected to be in place prior to the current fiscal year end, June 30, 2023. Updates as an operational policy are in place prior to the issuance of this letter. If the Department of Health and Human Services has questions regarding this plan, please email Angela Pesnell at apesnell@umc.edu.
Finding 2022-004: Preparation of the Schedule of Expenditures of Federal Awards. District staff are aware of this responsibility and will plan to prepare the SEFA annually in future years.
Finding 2022-004: Preparation of the Schedule of Expenditures of Federal Awards. District staff are aware of this responsibility and will plan to prepare the SEFA annually in future years.
Finding Number: 2022-002 Condition: The SEFA required adjustments related to expenditures that were both improperly included, resulting in revisions to correct the SEFA. Planned Corrective Action: JAA will strengthen our controls around the grant review process. In addition to the second-level rev...
Finding Number: 2022-002 Condition: The SEFA required adjustments related to expenditures that were both improperly included, resulting in revisions to correct the SEFA. Planned Corrective Action: JAA will strengthen our controls around the grant review process. In addition to the second-level review and approval process for grant revenue, JAA will implement a quarterly review to identify eligible expenditures for Federal and State Grant reimbursements to ensure revenue is recognized in the proper period. Contact person responsible for corrective action: Jose V. Lopez Anticipated Completion Date: 09/30/2023
Finding 51509 (2022-103)
Significant Deficiency 2022
CAP for Finding: 2022-103 Auditor Recommendation: Further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is adjusting expenditures for all prior-year transfers of expenditures in the current year. Pl...
CAP for Finding: 2022-103 Auditor Recommendation: Further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is adjusting expenditures for all prior-year transfers of expenditures in the current year. Planned Corrective Action: The Wisconsin Department of Administration (DOA or Department) Bureau of Financial Management (BFM) will evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards (SEFA) and ensure it is adjusting expenditures for material prior-year transfers of expenditures in the current year in a manner consistent with requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance or Guidance) and additional guidance, if any, provided by the Department?s State Controller?s Office (SCO). The Uniform Guidance requires the preparation of a SEFA for the period covered by the State's financial statements that includes total federal awards expended [ref. 2 CFR 200.510 (b)]; the determination of when a federal award is expended to be based on when the activity related to the federal award occurs [ref. 2 CFR 200.502]; and that the financial statements and SEFA are for the same audit period [ref. 2 CFR 200.514]. As the auditors noted, in preparing DOA?s SEFA, DOA BFM sought to reflect the amount of federal awards expended for DOA?s grant programs based on the amounts reported in the STAR general ledger. Together with reporting negative expenditures resulting from the transfers of FY 2019-20 and FY 2020-21 expenditures within the Notes to the SEFA, which are an integral part of the SEFA and required by 2 CFR 200.510 (b)(6), and absent OMB guidance that prescribes a uniform method for reporting a transfer of prior year grant expenditures, DOA BFM believed its approach was consistent with the requirements of 2 CFR 200.502 and 2 CFR 200.510 (b), more generally. DOA BFM later modified its SEFA to exclude negative expenditures resulting from the transfers of FY 2019-20 and FY 2020-21 expenditures consistent with the manner in which a prior period adjustment would be reflected within current-year activity in financial statements prepared in accordance with generally accepted accounting principles (GAAP), as described in the criteria and recommended by the auditors. The increased expenditures for the Coronavirus Relief Fund (Assistance Listing number 21.019) and Coronavirus State and Local Fiscal Recovery Funds (Assistance Listing number 21.027) in the SEFA of $241.3 million and $192.1 million, respectively, together with any future exclusions of negative expenditures resulting from the transfer of prior-year expenditures, will cause the lifetime expenditures on the SEFA schedule for these programs to reflect more expenditures than federal funding received. The Notes to the SEFA were also modified to indicate that the SEFA does not reflect a reduction for the prior year transferred expenditures. Anticipated Completion Date: Concurrent with the submission of the FY 2022-23 SEFA, which is anticipated to be November 2023 Auditor Recommendation: Carefully assess the transfer of prior-year expenditures in the current year to determine any potential effects on the total federal expenditures for the prior-year and the effect on the major program expenditures. Planned Corrective Action: DOA BFM will assess the transfer of prior-year expenditures in the current year to determine any potential effects on the total federal expenditures for the prior-year and the effect on the major program expenditures. It has been the practice of DOA BFM to assess the transfer of prior year expenditures in the current year and DOA BFM will continue to prioritize decisions with respect to the same to allow the Department to maximize the availability of federal funding for the purposes intended. Anticipated Completion Date: June 30, 2023 Person responsible for corrective action: Colleen Holtan, Director Bureau of Financial Management Division of Enterprise Operations colleen.holtan@wisconsin.gov
Finding 51504 (2022-302)
Significant Deficiency 2022
CAP for Finding: 2022-302 DATE: March 27, 2023 TO: Carolyn Stittleburg, Deputy State Auditor for Financial Audit Legislative Audit Bureau FROM: Barry Kasten, Director Bureau of Fiscal Services Department of Health Services SUBJECT: Corrective Action Plan ? Multiple Grants ? Reporting in the Schedule...
CAP for Finding: 2022-302 DATE: March 27, 2023 TO: Carolyn Stittleburg, Deputy State Auditor for Financial Audit Legislative Audit Bureau FROM: Barry Kasten, Director Bureau of Fiscal Services Department of Health Services SUBJECT: Corrective Action Plan ? Multiple Grants ? Reporting in the Schedule of Expenditures of Federal Awards Department staff has reviewed the Legislative Audit Bureau?s (LAB) interim audit memo for Finding 2022-302: Multiple Grants - Reporting in the Schedule of Expenditures of Federal Awards. This is the department?s Corrective Action Plan. ? Recommendation (2022-302): Multiple Grants ? Reporting in the Schedule of Expenditures of Federal Awards We recommend the Wisconsin Department of Health Services further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is: ? adjusting expenditures for prior-year transfers of expenditures in the current year. Wisconsin Department of Health Services Planned Corrective Action: DHS adjusted the expenditures for prior-year transfers of expenditures as recommended by LAB though DHS believes that there is no clearly defined direct authoritative guidance provided by OMB mandating a uniform method for reporting a transfer of prior year grant expenditures. Because of this, DHS believes it is prudent to seek confirmation of this treatment from the federal government going forward. LAB, in describing the effect, indicates that ?the State under-reported expenditures for the ELC grant by $55.9 million.? These expenditures were previously reported in prior fiscal years. Upon approval of the State?s FEMA project workbook, and in accordance with the compliance supplement, these previously reported expenditures were reported in FY 2021-22 under the Disaster Grants?Public Assistance (Presidentially Declared Disasters) (Assistance Listing number 97.036) grant. Without a matching reduction in expenditures to the ELC grant by $55.9 million, DHS is concerned that the lifetime expenditures on the SEFA schedule for these grant programs are going to reflect more expenditures than federal funding received. Additionally, because there is not direct authoritative guidance currently provided by OMB mandating a uniform method for reporting a transfer of prior year grant expenditures, DHS will work with DOA to seek clarification from the Federal Government on the proper treatment and reporting of transfers of prior year expenditures on the SEFA. Anticipated Completion Date: November 1, 2023 We recommend the Wisconsin Department of Health Services further evaluate federal grant expenditures reported in the STAR General Ledger as it prepares its schedule of expenditures of federal awards and ensure it is: ? properly identifying applicable COVID-19 expenditures; ? reporting all federal expenditures for each federal grant program, regardless of whether the agency has received reimbursement from the pass-through entity; and ? removing repayments of prior-year overpayments of expenditures from current-year expenditures. Wisconsin Department of Health Services Planned Corrective Action: DHS will ensure that it reviews the instructions that are received from DOA and present the proper amounts in the SEFA. This will include a review of adjustments made to grants open in prior state fiscal years and verification that they have not already been reported on the SEFA in a prior year, such as the WIC adjustment identified. Anticipated Completion Date: November 1, 2023 Person responsible for corrective action: Barry Kasten, Director Bureau of Fiscal Services, Division of Enterprise Services barry.kasten@dhs.wisconsin.gov
See Corrective Action Plan for chart/table
See Corrective Action Plan for chart/table
Finding Number: 2022-001 Program Name/Assistance Listing Titles: Crime Victim Assistance; Family Violence Prevention and Services/Domestic Violence Shelter and Supportive Services Assistance Listing Numbers: 16.575, 93.671 Contact Person: Jessica Bryson, Finance Administrator Anticipated Completion ...
Finding Number: 2022-001 Program Name/Assistance Listing Titles: Crime Victim Assistance; Family Violence Prevention and Services/Domestic Violence Shelter and Supportive Services Assistance Listing Numbers: 16.575, 93.671 Contact Person: Jessica Bryson, Finance Administrator Anticipated Completion Date: Completed effective October 2022 Planned Corrective Action: During the audited fiscal year, the organization experienced significant staff turnover in the Finance Department. As a result, the methodology of accounting relative to class/customer tracking changed part-way through the year. This resulted in the inability to immediately produce documentation from the financial reporting software that corroborated the grant billings. Although the organization is confident that expenses were billed to appropriate grants throughout the year (due to backup documentation in the grant billing portals), the organization?s financial software did not directly reflect this. To correct this problem, a new class/customer tracking system has been established to ensure that the financial reporting software more accurately tracks expenditures related to Federal Awards and organizational programs. Furthermore, grant billings are regularly reviewed by an independent accounting firm, the organizations Treasurer, and/or the Executive Director to ensure proper coding/tracking.
INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START PROGRAMS LOW-INCOME HOME ENERGY and WATER ASSISTANCE PROGRAM CFDA # 93.600, 93.568 and 93.499 (Questioned Costs -...
INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START PROGRAMS LOW-INCOME HOME ENERGY and WATER ASSISTANCE PROGRAM CFDA # 93.600, 93.568 and 93.499 (Questioned Costs - Undetermined) 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 Number: 2022-004 Condition: The schedule of expenditures of federal awards (SEFA) was not complete and accurate. Planned Corrective Action: Additional training for those individuals responsible for grant accounting has and will continue to be conducted, in addition to creating additional pol...
Finding Number: 2022-004 Condition: The schedule of expenditures of federal awards (SEFA) was not complete and accurate. Planned Corrective Action: Additional training for those individuals responsible for grant accounting has and will continue to be conducted, in addition to creating additional policies and procedures in FY23. Contact person responsible for corrective action: Kristen St. Peter Anticipated Completion Date: June 2023 Management Response: Management concurs with the finding and additional training for those individuals responsible for grant accounting has and will continue to be conducted as well as incorporating additional levels of review to ensure the SEFA is completed accurately and timely.
Lincoln Marti Charter Schools has taken immediate corrective action to ensure that all federal expenditures are reflected correctly in the Schedule of Expenditures of Federal Awards. Policies and procedures on grants and contract funding were reevaluated and the staff responsible for preparation of ...
Lincoln Marti Charter Schools has taken immediate corrective action to ensure that all federal expenditures are reflected correctly in the Schedule of Expenditures of Federal Awards. Policies and procedures on grants and contract funding were reevaluated and the staff responsible for preparation of the schedule have received additional instruction on how to accurately prepare and finalize the schedule. Additionally, there will be segregation of duties between the preparer and reviewer of the Schedule of Expenditures of Federal Awards.
Finding 48993 (2022-002)
Significant Deficiency 2022
Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
CORRECTIVE ACTION PLAN February 3, 2023 Crossroads Rehabilitation Center, Inc. respectfully submits the following corrective action plan for the year ended June 30, 2022. Name and address of independent public accounting firm: Greenwalt CPAs 5432 West Vermont Street Indianapolis, IN 46224 Audit Peri...
CORRECTIVE ACTION PLAN February 3, 2023 Crossroads Rehabilitation Center, Inc. respectfully submits the following corrective action plan for the year ended June 30, 2022. Name and address of independent public accounting firm: Greenwalt CPAs 5432 West Vermont Street Indianapolis, IN 46224 Audit Period: Year ending June 30, 2022 The findings from the June 30, 2022, Schedule of Findings and Questioned Costs are discussed below. The findings are numbered consistently with the numbers assigned in the schedule. MATERIAL WEAKNESS Finding 2022-001 Criteria: According to 2 CFR 200.508(a), the auditee must prepare appropriate financial statements, including the schedule of expenditures of Federal awards (SEFA) in accordance with 2 CFR 200.510. As instructed in the OMB Compliance Supplement, Provider Relief Funds (PRF) should be reported on the SEFA based on upon the PRF report that is required to be submitted to the HRSA reporting portal. For example, PRF funds received in period 2 (July 1, 2020, to December 31, 2020) should be reported on the SEFA for the fiscal year ends of December 31, 2021 through December 31, 2022. Condition: Federal awards totaling $332,841, including Provider Relief Funds received in period 2 of $178,159, were excluded from the SEFA. Cause: Crossroads had significant turnover within the accounting department and the new personnel had not been aware of the PRF funds received in a prior fiscal year. In addition, there was no overlap in the CFO position to provide for a smooth transition. Effect: An audit adjustment was made to report the three awards on the SEFA totaling $332,841. Recommendation: We recommend that Crossroads retain documentation regarding the information used to prepare the SEFA, along with notes for future years to assist with future personnel transitions. Planned Corrective Action: Crossroads will update policies, procedures and document retention plans to ensure that data is easily accessible. Instructions for completion of all audit related reports will be maintained and available to all finance personnel. Finding 2022-002 Criteria: Accounting reconciliations and supporting documentation should agree to the general ledger and be prepared and reviewed timely. Condition: Investment reconciliations, bad debt analysis and contributions receivable reconciliations had not been performed until requested during the audit. In addition, accounts receivable aging reports and depreciation reports did not agree to the general ledger. Cause: There was significant turnover within the accounting department during the year, including the Financial Accounting Manager and CFO positions. In addition, there was no overlap within the CFO position to provide for a smooth transition. This was the first-year end closing for both individuals in those positions. Effect: Audit adjustments were made resulting in a decrease of assets of approximately $4,700,000, a decrease in liabilities of approximately $400,000, and a decrease in net assets of approximately $4,300,000. Recommendation: We recommend that Crossroads create a schedule of all year-end reconciliations that need to be performed to ensure that required reconciliations are performed and reviewed timely. Planned Corrective Action: The lack of documentation and training of the Financial Accounting Manager for year-end closing processes prior to the former CFO?s departure left a significant knowledge gap. This also hindered the ability of the current CFO, who joined the organization 2 months prior to year-end, to be able to provide the required information or perform the necessary reconciliations. Going forward, all processes for month-end and year-end will be documented and followed. Accounts will be reconciled and reviewed on a monthly/quarterly/yearly basis as determined by the materiality of the account. If there are any questions regarding this plan, please contact Techia Brewer, CFO, at tbrewer@eastersealscrossroads.org.
Finding 47970 (2022-012)
Significant Deficiency 2022
Ucan
IL
Identifying Number: 2022-012 Finding: SEFA Reporting Corrective Actions Taken or Planned: UCAN agrees with this finding and agrees this was directly due to the turnover in the finance team and staffing challenges. The finance team will undergo additional training in federal grant requirements and ...
Identifying Number: 2022-012 Finding: SEFA Reporting Corrective Actions Taken or Planned: UCAN agrees with this finding and agrees this was directly due to the turnover in the finance team and staffing challenges. The finance team will undergo additional training in federal grant requirements and SEFA reporting. This is a repeat finding, with the original corrective action plan to be completed before March 31, 2023. We do believe that corrective actions that have been taken have resolved this issue. Contact person is Kimberly Parish, Chief Financial Officer and she can be reached at kim.parish@ucanchicago.org.
Finding 2022-0002 Criteria: According to 2 CFR Subpart F Section 200.Sl0b, the auditee must prepare a Schedule of Expenditures of Federal Awards {SEFA) for the period that includes all amounts spent on federal programs during the reporting period. Condition: The Schedule of Expenditures of Federal...
Finding 2022-0002 Criteria: According to 2 CFR Subpart F Section 200.Sl0b, the auditee must prepare a Schedule of Expenditures of Federal Awards {SEFA) for the period that includes all amounts spent on federal programs during the reporting period. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was materially understated by $33,592. Cause: This was the School's first single audit and the first time for the School's accountant to prepare the SEFA. The School does not have a process in place for School Administrative personnel who are familiar with the School's grants to review the SEFA for accuracy and completeness. Effect: An audit adjustment was made to increase the reported amount on the SEFA for the Rural Education Grant (84.358A) by $38,256 and reduce the reported amount on the SEFA for the Special Education Grants (84.027) by $8,288. The increase in expenditures resulted in the need to select a second federal award for testing. Recommendation: We recommend that the School's accountant work with administrative personnel to identify all awards from federal sources and implement a process whereby School administrative personnel review the SEFA prepared by the accountant. In addition, we recommend that the accountant reconcile federal award expenditures to the claims that were filed for the year. Action Taken: As of the date of the exit conference, we will institute an in-person quarterly review of each award with the responsible party to ensure costs are appropriately allocated and reimbursements requested. As part of this quarterly review, we will identify the source of the award, year-to-date expenses, grant budget and year-to-date reimbursement claims submitted. The accountant will reconcile federal award expenditures to the claims filed for the year. Furthermore, at year-end, the SEFA will be prepared by the accountant and reviewed by the appropriate administrative personnel for completeness and accuracy.
Finding Number: 2022-002 Condition: The SEFA was not accurate. Planned Corrective Action: Management has accepted ...
Finding Number: 2022-002 Condition: The SEFA was not accurate. Planned Corrective Action: Management has accepted the finding. Moving forward, internal conrols will be strengthened with regard to review and recording of revenue and expense recognition. Specifically, as it relates to this instance, review of documentation from the U.S. Department of Education (DOE) as it relates to HEERF grant funding will be more closely reviewed for understanding to include verification of understanding, guidelines and procedures from the DOE and other pertinent agencies for grant funding. Contact person responsible for corrective action: Deborah McKenzie, Director of Grants & Chief Financial Officer Anticipated Competion Date: November 30, 2022
Federal Schedule Audit Comment: County Response Emergency Rental Assistance Program Timely Reporting: The County made every attempt through communications with the Treasury to upload annual reports for ERA 1, without being able to do so by the due date. The County did submit the documents manual...
Federal Schedule Audit Comment: County Response Emergency Rental Assistance Program Timely Reporting: The County made every attempt through communications with the Treasury to upload annual reports for ERA 1, without being able to do so by the due date. The County did submit the documents manually by e-mail through dumps of the system. County staff worked with the US Treasury to address these issues. A resolution to the problem did not occur until second quarter of 2023. The Final report for ERA 1 has been submitted through the portal. Cumulative Expenditure/ Obligation Amounts: There was some misinterpretation on the part of County staff on whether the cumulative amounts to be reported was for the quarter or cumulatively for the grant program. It is to be noted that amounts in the County system were properly recorded and no exceptions were noted in the actual expenses/ obligations being for a valid grant purposes. Corrected on Final Report for ERA 1. State/ Local Federal Relief Funds Program Cumulative Expenditures/ Obligations Incorrectly Reported: There was some misinterpretation on the part of County staff on reporting the election of the $10,000,000.00 Revenue Replacement Funds for the SLFRF. It was thought that you could only show the $10,000,000.00 as obligated and expended once the election was made. This resulted in a net overstatement of obligations for any revenue replacements funds that were not yet obligated by resolution by the Board of Mahoning County Commissioners. The County tracked the individual projects by notes in the Treasury system to note the actual obligations. The County?s financial system tracks grants by fund, department and project codes. The funds in the County?s financial system were and are correctly obligated and tracked. The County will make the necessary corrections to the 2023 second quarter report to make sure the report agrees with the County?s financial system. It is to be noted that no exceptions were noted in funds being used for the stated purposes of the grant. Senior management will provide additional oversight to the reports prior to submitting to the US Treasury.
Finding 2022-002: Program: Various, including AL 97.036 ? Disaster Grants ? Public Assistance (Presidentially Declared Disasters); AL 10.923 Emergency Watershed Protection Program; and AL 93.563 ? Child Support Enforcement ? Reporting. Corrective Action Planned: The County will develop a Sched...
Finding 2022-002: Program: Various, including AL 97.036 ? Disaster Grants ? Public Assistance (Presidentially Declared Disasters); AL 10.923 Emergency Watershed Protection Program; and AL 93.563 ? Child Support Enforcement ? Reporting. Corrective Action Planned: The County will develop a Schedule of Expenditures of Federal Awards (SEFA) chart and designate the County Clerk to coordinate the collection of information from individual county offices on Federal awards expenditures. Anticipated Completion Date: March 30, 2023 Responsible Party: Carl Grotelueschen, County Board Chair
Views of Responsible Officials: As noted previously, management notes that expenditures of ongoing state and federal programs are internally reviewed and reconciled monthly, and required reporting to funding entities has been completed and submitted consistent with relevant reporting deadlines. Howe...
Views of Responsible Officials: As noted previously, management notes that expenditures of ongoing state and federal programs are internally reviewed and reconciled monthly, and required reporting to funding entities has been completed and submitted consistent with relevant reporting deadlines. However, transitions in systems and personnel as well as several large programs unique to the recent pandemic period challenged management to gather these details in the SEFA format early in the audit. In addition to continued monthly reconciliations, management will establish an additional more formal reconciliation quarterly during fiscal year 2023, and the more formalized grants reporting infrastructure we?re developing as well as upcoming additional staffing in finance and development will also strengthen our capacity for the timely preparations of the SEFA going forward.
FINDING ? FEDERAL AWARD PROGRAMS AUDIT 2022-002 ? Material Weakness ? Internal Control Material Weakness in Internal Control: The following errors were noted and corrected as a r...
FINDING ? FEDERAL AWARD PROGRAMS AUDIT 2022-002 ? Material Weakness ? Internal Control Material Weakness in Internal Control: 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. Recommendation: 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. Responsible Person for Corrective Action: Lindsay Mitchell, Director of Fiscal & Facilities Corrective Action to be Taken: To enroll new accounting team members in a GAAP training webinar through the CPE website. If there are no webinars provided that we can schedule, Management will look at Wipfli's training webinars to enroll in as a member. More professional development will be provided. There will be a checks and balance review of any schedule or report submitted to funding source and auditors. With initials of reviewer on the back up. Clear understanding of grant requirements and audit requirements will be the departments' goal. The anticipated completion date for this corrective action is September 30, 2023.
2022-002 Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Auditor Recommendation: We recommend management attend Federal award trainings and information to ensure the documented policies and procedures can be performed as de...
2022-002 Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Auditor 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. Corrective Action: The year ended August 31, 2022 was the first year in which the Center expended federal awards in excess of the limit that requires a Single Audit. Since receiving the EIDL loan, the Center maintained detailed tracking and documentation of all disbursements associated with the loan and understood such expenditures exceeded the $750,000 threshold for a Singe Audit during the fiscal year ended August 31, 2022. With the clarification of the specific rules surrounding the disclosure of EIDL loans on the SEFA, management will continue to review Federal Award guidance and requirements to ensure compliance with current and future federal awards. Name of Responsible Contacts: Larry Goodpaster, Director of Finance & Operations, and Kelly Martin, Accounting Manager Projected Implementation Date: May 1, 2023 and ongoing
Corrective Action Plan For the Year Ended December 31, 2022 Finding: 2022?001 Inaccurate SEFA reporting Responsible Official: Michelle Maddox, CFO Corrective Action Plan: Management will implement additional controls to ensure the completeness and accuracy of amounts reported for expenditures of th...
Corrective Action Plan For the Year Ended December 31, 2022 Finding: 2022?001 Inaccurate SEFA reporting Responsible Official: Michelle Maddox, CFO Corrective Action Plan: Management will implement additional controls to ensure the completeness and accuracy of amounts reported for expenditures of the Federal Transit Administration grants in the schedule of federal awards. These additional controls include the annual review of new implementation guides. Anticipated Completion Date: December 31, 2023
Finding Number: 2022-005 Condition: The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. ...
Finding Number: 2022-005 Condition: The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Planned Corrective Action: Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored. Contact person responsible for corrective action: Matt Zeilstra ? Financial Controller Anticipated Completion Date: 07/27/2023
Finding Number: 2022-007 Condition: For SEFA reporting, expenditures were overstated for one program and understated for another. In addition, an ALN listed for expenditures was inaccurate. Planned Corrective Action: Grant documents will be reviewed upon receipt to determine the proper ALN and the...
Finding Number: 2022-007 Condition: For SEFA reporting, expenditures were overstated for one program and understated for another. In addition, an ALN listed for expenditures was inaccurate. Planned Corrective Action: Grant documents will be reviewed upon receipt to determine the proper ALN and the federal portion of funding. All existing grants will also be reviewed. The ALN listed in each grant document will be used when completing the SEFA. A second staff member will verify the accuracy of the SEFA prior to submission. All ALN numbers will be reviewed upon receipt and verified with state analysts when applicable. The organization will ensure that the funding sources are verified to the most appropriate level at the state level to verify funds and funding sources. Contact person responsible for corrective action: Kelly Scott, Deputy CEO Anticipated Completion Date: 4/30/2023
« 1 16 17 19 20 22 »