Corrective Action Plans

Browse how organizations respond to audit findings

Total CAPs
61,436
In database
Filtered Results
684
Matching current filters
Showing Page
15 of 28
25 per page

Filters

Clear
Active filters: § 200.510
Finding 2023-003 - Material Weakness in Internal Control over Compliance and Material Noncompliance (Qualified Opinion) - Inadequate Tracking of Expenditures and Retention of Documentation: Activities Allowed or Unallowed: Allowable Costs/Cost Principles and Reporting (A/B/L) for Assistance Listing ...
Finding 2023-003 - Material Weakness in Internal Control over Compliance and Material Noncompliance (Qualified Opinion) - Inadequate Tracking of Expenditures and Retention of Documentation: Activities Allowed or Unallowed: Allowable Costs/Cost Principles and Reporting (A/B/L) for Assistance Listing Number 19.510 and 93.567 Criteria: The Code of Federal Regulations (CFR) Section 200.510(b) states in part, “The auditee must also prepare a schedule of federal expenditures for the period covered by the auditee’s consolidated financial statements which must include the total Federal awards expended as determined in accordance with 200.502.” Also, in accordance with CFR Section 200.302(b) - Financial Management, the auditees financial management system must provide 1) identification of all federal awards received and expended; 2) accurate, current, and complete disclosure of the financial results of each federal award or program; 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; 5) comparison of expenditures with budget amounts for each Federal award; 6) written procedures to implement the requirements of section 200.305 and; 7) written procedures for determining the allowability of costs in accordance with Subpart E and the terms and conditions of the Federal award. Recipients of federal awards must submit accurate, complete and timely financial and performance reports. The Organization should have internal controls designed to ensure compliance with those provisions. The Organization should retain sufficient documentation such as invoice and allocation support for expenditures to retain documentation for audit purposes. Condition: During detail testing of expenditures, it was noted that the Organization did not maintain adequate documentation to support how certain costs were allocated to the federal program. Several transactions lacked sufficient detail, such as invoice or expense reimbursement form. Several expenditures selected for testing did not obtain sufficient approval by an individual at the Organization. It was noted that quarterly reports provided to the federal program were not reviewed by an individual at the Organization prior to submission to ensure accurate report of expenditures. Cause: The Organization does not have an adequate system in place to ensure quarterly reports have sufficient supporting documentation, proper approval/review, and accurate reporting prior to submission. Responsibilities for expenditure tracking were not clearly assigned, and there was no formal review process in place. The Organization is not following their Document Retention Policy. Effect: The effect of this condition increases the possibility that quarterly financial reports are misstated or inaccurate and increase the risk of noncompliance with federal requirements. The effect of this condition also increases the risk that expenditures are unallowable per the grant, federal regulations, or cost principles due to the insufficient support of proper approval retained. Questioned costs: None Repeat Finding: Yes - 2022-004 Recommendation: Policies and procedures should be in place to ensure quarterly financial reports are properly supported, accurately reported, and adequately approved and reviewed. A formal review process should be established to ensure compliance. The Organization should following the Document Retention Policy that was put in place and required by law. Management Response: There is no disagreement with the audit finding. Management has taken steps to address these deficiencies in fiscal year 2025 including but not limited to: the implementation of a new accounting system that includes document retention and review/sign off logs, the engagement of a third-party CPA firm to provide client advisory and accounting services and the review and updating of accounting policies and procedures for best practices. Responsible Person for Corrective Action Plan: Marc Hall, Director of Operations Implementation Date for Corrective Action Plan: Fiscal year 2025
2023 – 004 Material Weakness in Internal Control Over Preparation, Reconciliation, and Retention of the Schedule of Expenditures of Federal Awards (SEFA) Recommendation: 4. Develop a Standardized SEFA Reconciliation Process – Implement formal policies and procedures requiring that SEFA expenditure...
2023 – 004 Material Weakness in Internal Control Over Preparation, Reconciliation, and Retention of the Schedule of Expenditures of Federal Awards (SEFA) Recommendation: 4. Develop a Standardized SEFA Reconciliation Process – Implement formal policies and procedures requiring that SEFA expenditures be reconciled to the general ledger on a monthly basis, with documentation maintained for audit purposes. 5. Enhance System Controls for Grant Expenditures – Modify the financial system to allow for the proper segregation of state and federal expenditures from non-grant funds, ensuring that expenditures are properly classified at the time of entry. 6. Require Monthly Documentation Reviews – Establish a control requiring management to review and approve SEFA reconciliation schedules on a monthly or quarterly basis to ensure accuracy and completeness. 7. Implement a Centralized Documentation Retention Policy – Require that all SEFA-related reconciliation records, including general ledger tie-outs and manual adjustments, be retained in a centralized, accessible location. 8. Provide Grants Management Training – Conduct training for grants management and accounting personnel on SEFA preparation requirements, including Uniform Guidance compliance and best practices for documentation and reconciliation. Management View: Management partially agrees with the finding. While we acknowledge that documentation supporting SEFA reconciliation was incomplete, we believe that federal expenditures were properly accounted for. We would like to address some of the auditors’ points individually: • “The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred.” Most grant awards do not fully fund the programs they support, most grant awards do not run concurrently with Prism Health North Texas’ fiscal year (i.e., with the Calendar Year), and most grant awards are not spent in equal monthly amounts. It is correct that the 2023 SEFA was based on grant-appropriate expenditures that occurred during Calendar Year 2023 and were submitted to those grant sponsors for reimbursement. This will not necessarily reach the full cost to Prism for each grant-supported program, nor is it likely to exactly match any annual grant award amount. • “Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program.” As we confirmed verbally with the audit partner on April 25, 2025, this statement is intended to provide information and context and is not a criticism or intended to point out any problem. As stated above, most grant awards do not fully fund the programs they support; therefore, the general ledger necessarily includes both expenses the sponsor will reimburse and expenses the sponsor will not reimburse. Nonetheless, we are enhancing our reconciliation procedures and documentation practices to fully meet audit requirements. Finding 2023-004 refers to the auditors’ assessment of the SEFA preparation and reconciliation processes that occurred in Calendar Year 2023. As of this writing, Prism Health North Texas has already changed its SEFA preparation and reconciliation processes and meets many of the recommendations above. Action Taken: 4. Documentation Retention – On April 25, 2025, management created a structured and easily accessible system for storing all relevant information for all grants management personnel. a. A logical naming system for files identifying the SEFA period, the funding agency and identified general ledger expenditures claimed on the SEFA. b. We are now documenting the difference between all GL transactions and those submitted for sponsor reimbursement (i.e., SEFA components) in a single document per fund code, arranged by fiscal year. Previously this documentation was kept by invoice and arranged by grant year. c. Management will continue to ensure all expenditure-related support, such as invoices and purchase orders, is saved electronically to all financial transactions. 5. SEFA Reconciliation – Management has decided to move from an annual to quarterly SEFA reconciliation process to enhance the frequency of management oversight in SEFA draft preparation. VP of Finance will prepare the SEFA for independent review by the CFO. This will be put into a written policy/procedure. 6. System Enhancements – Prism’s current accounting system does not accommodate this. However, Prism is already in the later stages of selecting a new Enterprise Resource Planning (ERP) solution, with this as one of our key selection criteria. Our new ERP should allow for expenditures within the same cost center to be identified as grant-reimbursable or non-grant-reimbursable at the time of entry. We have identified opportunities in new financial management software solutions that we are scheduled to demo May 12th and the 16th of 2025. Opportunities such as: a. The ability to tag grant-reimbursable transactions, to segment our award cost center into two important categories. i. The full cost to manage a specific program ii. Identified cost claimed on the SEFA b. Dedicated grant modules that will allow us to establish business rules and workflows to streamline and digitize critical aspects of grant management. 7. Staff Engagement – Cross department coordination meetings occur monthly between the Finance organization and the Grants Management team to continue to foster alignment and collaboration in our grant cycles. A general overview of SEFA, including how to prepare and organize the monthly reconciliations, has already occurred with some of the grants accountants. Anticipated Completion Date: We expect all but system enhancements to be in place by July 31st, 2025, to contribute significantly to the strength of our internal controls and stakeholder confidence in our SEFA reporting. Responsible Contact Person(s): • Name: General Laffitte • Title: Vice President of Finance and Accounting • Phone: 214-623-6896 • Address: 3900 Junius St. Ste. 300, Dallas, Texas 75246 • Name: Jana Voege • Title: Chief Financial Officer • Address: 3900 Junius St. Ste. 300, Dallas, Texas 75246
CORRECTIVE ACTION PLAN Name of auditee: Friends of the Mission Finding: 2023-003 Name of audit firm: Propp Christensen Caniglia LLP Period covered by the audit: January 1, 2023 through December 31, 2023 CAP prepared by: Scott Thurmond, Executive Director Telephone: (916) 416-0901 Comments: Managemen...
CORRECTIVE ACTION PLAN Name of auditee: Friends of the Mission Finding: 2023-003 Name of audit firm: Propp Christensen Caniglia LLP Period covered by the audit: January 1, 2023 through December 31, 2023 CAP prepared by: Scott Thurmond, Executive Director Telephone: (916) 416-0901 Comments: Management agrees with the finding. Actions: Management has taken steps to ensure the SEFA is prepared accurately and timely.
Views of responsible officials and planned corrective actions: Management acknowledges the omission of the federally contract from the auditee’s prepared SEFA. Management is committed to properly preparing the SEFA, and to address this oversight, management will identify trainings for accounting p...
Views of responsible officials and planned corrective actions: Management acknowledges the omission of the federally contract from the auditee’s prepared SEFA. Management is committed to properly preparing the SEFA, and to address this oversight, management will identify trainings for accounting personnel related to SEFA reporting and for those reviewing the schedule, to ensure its accuracy.
Finding Number: 2023-007 Condition: Controls in place were not adequate to ensure the schedule of federal expenditures was complete and accurate. Planned Corrective Action: Reports in Workday along with new reconciliation workpapers will be utilized to ensure a complete and accurate SEFA in FY2025. ...
Finding Number: 2023-007 Condition: Controls in place were not adequate to ensure the schedule of federal expenditures was complete and accurate. Planned Corrective Action: Reports in Workday along with new reconciliation workpapers will be utilized to ensure a complete and accurate SEFA in FY2025. Contact person responsible for corrective action: Laura Randall Anticipated Completion Date: 06/30/2025
Finding Number 2023-005 Condition: The FEMA expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and accurate. Planned Corrective Action: Seek training from our auditors on the proper recording of obligated expenditures. Contact person...
Finding Number 2023-005 Condition: The FEMA expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and accurate. Planned Corrective Action: Seek training from our auditors on the proper recording of obligated expenditures. Contact person responsible for corrective action: Laura Randall Anticipated Completion Date: 06/14/2024
Corrective Action Plan: The Authority will develop a new procedure to ensure compliance with these reporting requirements. All personnel involved in the administration of these programs for which federal funds are expended should receive adequate training about federal compliance and reporting requi...
Corrective Action Plan: The Authority will develop a new procedure to ensure compliance with these reporting requirements. All personnel involved in the administration of these programs for which federal funds are expended should receive adequate training about federal compliance and reporting requirements related to such programs. In addition, an individual should be assigned with the responsibility to monitor compliance with all related federal requirements. These procedures will also include a quarterly reconciliation of amounts reported between the Schedule of Federal Awards with the trial balance. Responsible: Mr. Angel M. Felix Cruz, Finance Office Auxiliary Director Ms. Maria Del R. Ramos Ocasio, Accounting and Finance Manager Status: In process. Expected to be completed on or before December 31, 2024.
Finding 564443 (2023-003)
Significant Deficiency 2023
Day One
RI
ALN Number and Name: Not applicable Significant deficiency Management’s Planned Corrective Action: Disagree: We have established a cost center or “Department” for each federal program that clearly identifies federal expenditures. Our funders request monthly copies of receipts and payment issued to v...
ALN Number and Name: Not applicable Significant deficiency Management’s Planned Corrective Action: Disagree: We have established a cost center or “Department” for each federal program that clearly identifies federal expenditures. Our funders request monthly copies of receipts and payment issued to verify expenses. Responsible Party: Beaulieu Accountancy Corporation, Accountant Completion Date: 9/25/2024
Finding 563782 (2023-009)
Significant Deficiency 2023
2023-009- Reporting Federal Agency: U.S. Department of the Treasury Federal Program Name: American Rescue Plan Act / Coronavirus State Fiscal Recovery Fund (ARPA) Assistance Listing Number: 23.027 Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of H...
2023-009- Reporting Federal Agency: U.S. Department of the Treasury Federal Program Name: American Rescue Plan Act / Coronavirus State Fiscal Recovery Fund (ARPA) Assistance Listing Number: 23.027 Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of Health and Human Services Pass-Through Number(s): Not Available Award Period: 1/1/2023 – 12/31/23 Type of Finding: Significant Deficiency in Internal Control Over Compliance Condition: Policies and controls in place regarding the completeness of the SEFA were not properly functioning. Within the supporting listing of expenses relating to ARPA expenditures, multiple transactions were identified as 2022 fiscal year expenditures that were included in the 2023 expenditure total. The County revised the 2023 SEFA to exclude the 2022 expenditures. Recommendation: We recommend management should review the process of recording federal expenditures to determine expenditures are being included in the appropriate fiscal year. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action planned and taken in response to finding: The reason for the finding’s recurrence is in part a result of the timing of when the finding was issued. For example, the 2022 Single Audit was issued in August 2024. At this point, the 2023 fiscal year was already complete. Additionally, the implementation of corrective actions are in progress, including providing training, oversight and guidance to departments administering the grants, but these efforts take time to complete and/or are ongoing. A Deputy Controller of Grant Accounting was hired in February 2023, and a Manager-Grant Accounting was hired in July 2024, after working in this capacity as a temporary staff member since mid-2023. The County approved an additional full-time grant accounting position in May 2025 and will begin recruiting for this position in June 2025. These positions are responsible for establishing accounting policies based on best practices for grant-related activities, developing and providing training and resources to grant- funded departments, reviewing grant-related accounting in the Infor system, preparation of the annual SEFA, and assisting in the facilitation and preparation of documents needed for the Single Audit. The work performed by these positions had been vacant since the departure of Internal Audit Staff who helped General Accounting prior to the 2021 audit as well as the SEFA. Several changes have been made since the grant accounting team was created including the following: The grant accounting team is developing streamlined and standardized SEFA templates for each department for SEFA preparation. The expenditures reported on each SEFA are being compared to the financial information in the GL where possible to ensure all appropriate expenditures are included. Additionally, we are incorporating tracking of lifetime grant expenditures into the SEFA process to ensure no expenditures are missed due to cut off or timing issues. In 2023, the grant accounting team created a Montgomery County Grant Repository. This repository is used to store all grant agreements awarded to the County. Departments submit grant information to the repository upon notification of grant award. The grant accounting team reviews the Grant Repository when preparing the SEFA to ensure no grant programs are inadvertently left off of the SEFA. Additionally, the availability of the Grant Repository enables members of the accounting, finance and grant departments to quickly access grant award information when needed for audits, reporting, or other requirements. The grant accounting team is continuing to review and update the County’s Grant Accounting policies and is working closely with departments to understand their utilization of Infor to account for grant- related activities. As these policies are formalized, we will continue to provide training and resources; in late 2023, the County hired an outside trainer to provide an in-depth training on the accrual method of accounting, grant accruals, and the treatment of grant revenue. The Grant Accountant provided training in April 2024 to explain and outline the SEFA and Single Audit processes. Grant-funded departments received a two-day training on utilization of the Grant Management components of Infor in February 2024. We are also providing guidance and education to departments on the differences in timing of various grant fiscal years and how these impact the financial audit, SEFA and Single Audit. For example, departments must understand how to report expenditures and receipts in the correct period regardless of the fiscal year associated to the contract (State: July-June; Federal: October-September; County: January-December) and understand how these amounts reconcile to the amounts reported to the funding agencies. The accounting department continues to work with departments to emphasize the importance of submitting financial documentation timely and reviewing what is in the General Ledger promptly at the end of each month. The Finance department is performing quarterly reviews with departments to go over financial status, including grant financials. Departments are continuing to utilize Project Codes and other components of Infor’s Grant Management System to ensure the proper accounting of grant-related expenses, receipts, and revenues in the GL. Name(s) of the contact person(s) responsible for corrective action: Thomas Landauer and Fonta Reilly Planned completion date for corrective action plan: September 2025
View Audit 357994 Questioned Costs: $1
Finding 563779 (2023-008)
Significant Deficiency 2023
2023-008 – Reporting Federal Agency: U.S. Department of the Treasury Federal Program Name: Emergency Rental Assistance Program (ERAP) Assistance Listing Number: 23.023 Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of Health and Human Services Pass...
2023-008 – Reporting Federal Agency: U.S. Department of the Treasury Federal Program Name: Emergency Rental Assistance Program (ERAP) Assistance Listing Number: 23.023 Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of Health and Human Services Pass-Through Number(s): Not Available Award Period: 1/1/2023 – 12/31/23 Type of Finding: Significant Deficiency in Internal Control Over Compliance Condition: Policies and controls in place regarding the completeness of the SEFA were not properly functioning. Within the supporting listing of expenses relating to ERAP expenditures, six transactions were identified as prior fiscal-year expenditures that were included in the unadjusted 2023 expenditure total. The County revised the 2023 SEFA to exclude the 2022 expenditures. Recommendation: We recommend management should review the process of recording federal expenditures to determine expenditures are being included in the appropriate fiscal year. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action planned and taken in response to finding: The reason for the finding’s recurrence is in part a result of the timing of when the finding was issued. For example, the 2022 Single Audit was issued in August 2024. At this point, the 2023 fiscal year was already complete. Additionally, the implementation of corrective actions are in progress, including providing training, oversight and guidance to departments administering the grants, but these efforts take time to complete and/or are ongoing. A Deputy Controller of Grant Accounting was hired in February 2023, and a Manager-Grant Accounting was hired in July 2024, after working in this capacity as a temporary staff member since mid-2023. The County approved an additional full-time grant accounting position in May 2025 and will begin recruiting for this position in June 2025. These positions are responsible for establishing accounting policies based on best practices for grant-related activities, developing and providing training and resources to grant- funded departments, reviewing grant-related accounting in the Infor system, preparation of the annual SEFA, and assisting in the facilitation and preparation of documents needed for the Single Audit. The work performed by these positions had been vacant since the departure of Internal Audit Staff who helped General Accounting prior to the 2021 audit as well as the SEFA. Several changes have been made since the grant accounting team was created including the following: The grant accounting team is developing streamlined and standardized SEFA templates for each department for SEFA preparation. The expenditures reported on each SEFA are being compared to the financial information in the GL where possible to ensure all appropriate expenditures are included. Additionally, we are incorporating tracking of lifetime grant expenditures into the SEFA process to ensure no expenditures are missed due to cut off or timing issues. In 2023, the grant accounting team created a Montgomery County Grant Repository. This repository is used to store all grant agreements awarded to the County. Departments submit grant information to the repository upon notification of grant award. The grant accounting team reviews the Grant Repository when preparing the SEFA to ensure no grant programs are inadvertently left off of the SEFA. Additionally, the availability of the Grant Repository enables members of the accounting, finance and grant departments to quickly access grant award information when needed for audits, reporting, or other requirements. The grant accounting team is continuing to review and update the County’s Grant Accounting policies and is working closely with departments to understand their utilization of Infor to account for grant- related activities. As these policies are formalized, we will continue to provide training and resources; in late 2023, the County hired an outside trainer to provide an in-depth training on the accrual method of accounting, grant accruals, and the treatment of grant revenue. The Grant Accountant provided training in April 2024 to explain and outline the SEFA and Single Audit processes. Grant-funded departments received a two-day training on utilization of the Grant Management components of Infor in February 2024. We are also providing guidance and education to departments on the differences in timing of various grant fiscal years and how these impact the financial audit, SEFA and Single Audit. For example, departments must understand how to report expenditures and receipts in the correct period regardless of the fiscal year associated to the contract (State: July-June; Federal: October-September; County: January-December) and understand how these amounts reconcile to the amounts reported to the funding agencies. The accounting department continues to work with departments to emphasize the importance of submitting financial documentation timely and reviewing what is in the General Ledger promptly at the end of each month. The Finance department is performing quarterly reviews with departments to go over financial status, including grant financials. Departments are continuing to utilize Project Codes and other components of Infor’s Grant Management System to ensure the proper accounting of grant-related expenses, receipts, and revenues in the GL. Name(s) of the contact person(s) responsible for corrective action: Thomas Landauer and Fonta Reilly Planned completion date for corrective action plan: September 2025
View Audit 357994 Questioned Costs: $1
COVID-1 9 Coronavirus State and Local Fiscal Recovery Funds — Assistance Listing No. 21 .027 Recommendation: We recommend the District design controls to ensure an adequate review process over the invoices recorded and presented on the schedule of expenditures of federal awards to determine complian...
COVID-1 9 Coronavirus State and Local Fiscal Recovery Funds — Assistance Listing No. 21 .027 Recommendation: We recommend the District design controls to ensure an adequate review process over the invoices recorded and presented on the schedule of expenditures of federal awards to determine compliance with the Uniform Guidance. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The District’s policies will be updated and approved if needed to conform to federal guidance. Name(s) of the contact person(s) responsible for corrective action: Ron McEachern, General Manager or Delia Stoor, Accounting Manger Planned completion date for corrective action plan: September 30, 2024
While PCRI does have systems in place to adequately track federal expenditures, the preparation of the schedule of federal expenditures was delayed in large part due to the deficiencies outlined in Finding 2023-001, which led to delays in accurately compiling the information required for the schedul...
While PCRI does have systems in place to adequately track federal expenditures, the preparation of the schedule of federal expenditures was delayed in large part due to the deficiencies outlined in Finding 2023-001, which led to delays in accurately compiling the information required for the schedule of federal expenditures, and that the transition of relevant accounting processes to the outsourced accounting firm will resolve this deficiency going forward. The timeline for full transition of relevant accounting processes to the outsourced accounting firm which started in January of 2025 is approximately seven months due to the complexities of PCRI’s operations. PCRI anticipates this transition being complete in July of 2025.
The University will review and enhance its procedures and internal controls to ensure the SEFA is complete and accurate.
The University will review and enhance its procedures and internal controls to ensure the SEFA is complete and accurate.
Sites Authority staff did not understand the requirements that expenditures included in the Schedule of Expenditures of Federal Awards (SEFA) be provided on an accrual basis. As such, the first SEFA submittal was based on actuals. Staff was informed by the auditor that the SEFA submittal should be b...
Sites Authority staff did not understand the requirements that expenditures included in the Schedule of Expenditures of Federal Awards (SEFA) be provided on an accrual basis. As such, the first SEFA submittal was based on actuals. Staff was informed by the auditor that the SEFA submittal should be based on an accrual basis. The team submitted a SEFA based on an accrual basis. Staff made a mistake of not including in the SEFA 25% of a $180,000 ($45,000) payment. This $45,000 omission was less than 0.4% of the total expenditures of $10,697,736 included in the SEFA. There were 634 invoices processed with thousands of expense items used to prepare the SEFA. Staff will document in its internal SEFA procedure the appropriate federal CFR sections for SEFAs to ensure such sections and requirements are met. The recommended training will occur before end of FY24 to avoid this recurring in the Dec 31, 2024 audit report.
Views of Responsible Officials: SAMU has identified the following actions point: 1. Implement a thorough review process for all funding streams to determine if they are federal, state, or private. 2. Establish clear guidelines for identifying and tracking federal awards. 3. Provide training to accou...
Views of Responsible Officials: SAMU has identified the following actions point: 1. Implement a thorough review process for all funding streams to determine if they are federal, state, or private. 2. Establish clear guidelines for identifying and tracking federal awards. 3. Provide training to accounting staff on the proper application of ASC 958, particularly regarding the recognition of conditional awards. 4. Develop a checklist for SEFA preparation to ensure all required elements are included and properly reported. 5. Consider seeking expert advice or additional training on federal award accounting and reporting. By implementing these measures, SAMU can improve the accuracy of its SEFA, ensure compliance with federal regulations, and provide a more reliable basis for audit procedures.
2023-001 Program: Highway Planning and Construction Federal Financial Assistance Listing No.: 20.205 Federal Agency: U.S. Department of Transportation Pass-through: Metropolitan Transportation Commission Award Year: 2023 Grant Award Number: MTC/STP Agreement Compliance Requirements: Other - Title 2 ...
2023-001 Program: Highway Planning and Construction Federal Financial Assistance Listing No.: 20.205 Federal Agency: U.S. Department of Transportation Pass-through: Metropolitan Transportation Commission Award Year: 2023 Grant Award Number: MTC/STP Agreement Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b)- Schedule of expenditures of Federal awards Recommendation: VTA should establish policies and implement internal controls to ensure all federal expenditures are accurately identified on the Schedule of Expenditures of Federal Awards (SEFA). Corrective Action: VTA will reinforce its system of internal control in communicating timely the Catalog of Federal Domestic Assistance (CFDA) number to the department preparing the SEFA. CFDA of direct and pass-through grants will be obtained from the Federal Transit Administration (FTA) and related grantors, respectively. If the CFDA number of a grant is not available at the time of preparation of SEFA, this will be identified accordingly. Responsible Party: The Fiscal Resources Manager and the Transportation Planners, Grants Implementation Date: March 31, 2025
Federal Program Child Nutrition Cluster - Passed through the Pennsylvania Department of Education and Pennsylvania Department of Agriculture ALNs 10.555 and 10.553 Education Stabilization Fund - Passed through the Pennsylvania Department of Education ALN 84.425 Criteria Per the Uniform Guidance 2 C...
Federal Program Child Nutrition Cluster - Passed through the Pennsylvania Department of Education and Pennsylvania Department of Agriculture ALNs 10.555 and 10.553 Education Stabilization Fund - Passed through the Pennsylvania Department of Education ALN 84.425 Criteria Per the Uniform Guidance 2 CFR 200.510, the auditee is required to prepare a schedule of expenditures of federal awards (SEFA). Condition The District prepared a SEFA and provided information relating to the federal programs including grant agreements and other supporting documentation. However, the SEFA prepared by the auditee required material adjustments as a result of audit procedures. Cause Certain account reconciliations were not performed prior to the audit, which impacted amounts reported on the SEFA. Effect Amounts reported on the SEFA provided by the auditee were not accurate. The SEFA was subsequently updated through audit procedures, including inquiry and review of grant documentation of awards received and amounts expended. Questioned Costs None. Context A SEFA was prepared by management; however, several adjustments were required in order for the schedule to accurately reflect the current year activity. Repeat Finding Yes. See finding 2022-003. Recommendation In order to meet Uniform Guidance requirements, the District should prepare the SEFA from the grant award documentation and any other relevant information including the assistance listing numbers, grant award amounts, grant amounts received, grant amounts expended, and grant revenue recorded. The amounts reported in the SEFA should reconcile to the general ledger. Management Response The new Assistant Business Manager has been trained in Uniform Guidance requirements as well as Federal program guidelines. This should not happen in the future.
Finding 553867 (2023-004)
Material Weakness 2023
Consortium’s Fiscal Agent will ensure that supporting documentation will be maintained for all expenditures to ensure that each expenditure charged to the program is for an allowable activity/cost.
Consortium’s Fiscal Agent will ensure that supporting documentation will be maintained for all expenditures to ensure that each expenditure charged to the program is for an allowable activity/cost.
The Village Treasurer will start preparing the Schedule of Expenditures of Federal Awards each year or contract with a CPA firm for assistance in preparing the Schedule of Expenditures of Federal Awards each year.
The Village Treasurer will start preparing the Schedule of Expenditures of Federal Awards each year or contract with a CPA firm for assistance in preparing the Schedule of Expenditures of Federal Awards each year.
A grant manager and grant-financial coordinator have been hired to work with the finance team to communicate the whole gamut of applicable elements of ASC 606. Also, we are purchasing a grant management system—not a manual Excel sheet- that can scan grants and identify conditions and restrictions.
A grant manager and grant-financial coordinator have been hired to work with the finance team to communicate the whole gamut of applicable elements of ASC 606. Also, we are purchasing a grant management system—not a manual Excel sheet- that can scan grants and identify conditions and restrictions.
Condition: The schedule of expenditures of federal awards (SEFA) was not accurate. Planned Corrective Action: The City will review its process for identifying and communicating Federal Grant expenditures to its auditors. Contact person responsible for corrective action: Robert McMahon, City Administ...
Condition: The schedule of expenditures of federal awards (SEFA) was not accurate. Planned Corrective Action: The City will review its process for identifying and communicating Federal Grant expenditures to its auditors. Contact person responsible for corrective action: Robert McMahon, City Administrator Anticipated Completion Date: 09/30/2025
Finding 2023-004 - Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Management (Material Weakness) CFDA Title and Number 84.425 Education Stabilization Fund Name of Federal Agency: U.S. Department of Education Criteria: CFR Part 200.508, CFR Part 200.510, Auditee R...
Finding 2023-004 - Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Management (Material Weakness) CFDA Title and Number 84.425 Education Stabilization Fund Name of Federal Agency: U.S. Department of Education Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Schedule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, including the total Federal awards expended, name of the pass-through entity, CFDA number, and total amount provided to subrecipients. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial statements. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was presented for audit with values that were not reconciled with the general ledger. Cause: The District relied on individuals with insufficient training or support to prepare the SEFA and ensure that it was reconciled with general ledger amounts. District management did not have sufficient training or monitoring policies to recognize and correct the deficiency. Effect or Potential Effect: Errors in recording and reporting of revenues and expenditures of federal awards may not be detected and/or corrected. Because the Auditee’s SEFA that was presented for audit was completed incorrectly, and not reconciled to the general ledger, the SEFA was materially misstated, prior to auditors’ correction recommendations. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting resulted in the following: • SEFA was originally presented for auditors with incorrect information. • Inadequate reconciliation between federal expenditures reported on the GL and the SEFA was presented. Repeat of a Prior-Year Finding: No Recommendation: We recommend that the District establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Internal controls should be designed to prevent, detect, or correct errors in a timely manner by performing periodic reconciliations of the SEFA information to the general ledger throughout the fiscal year. The District should provide appropriate training to staff who are assigned to prepare and review the SEFA. District’s Response: The District acknowledges the deficiencies. Corrective Action Plan: The District will establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Planned Implementation Date: November 1, 2024 Responsible Person: District Business Manager
All future federal expenditures will be reconciled to the disbursement ledger.
All future federal expenditures will be reconciled to the disbursement ledger.
The Organization experienced substantial growth of programmatic activities which required the department to focus on ongoing maintenance and tracking. The Organization completed a significant components of year end close in the fall of 2023 and final review and adjustments to the SEFA were conducted...
The Organization experienced substantial growth of programmatic activities which required the department to focus on ongoing maintenance and tracking. The Organization completed a significant components of year end close in the fall of 2023 and final review and adjustments to the SEFA were conducted in January 2025. The department is finalizing the year end close for the next year end close and will focus on the completeness and accuracy of the SEFA.
I was a newly elected official in 2023 with no prior training in the County Clerk’s office. I had no knowledge of how SEFA monies were to be reported. After this finding was brought to my attention, internal controls were implemented. A process/procedure was put into place where all grants received ...
I was a newly elected official in 2023 with no prior training in the County Clerk’s office. I had no knowledge of how SEFA monies were to be reported. After this finding was brought to my attention, internal controls were implemented. A process/procedure was put into place where all grants received are tracked, as are the expenditures for each grant. The clerk and deputy clerk are now involved in the grant tracking procedure as well as reviewing the SEFA report for accuracy after it is prepared. In January 2025 a Grant Policy was adopted by the Caldwell County Commission to make all county employees aware of the process for reporting and tracking grants received. The Grant Expenditures and Reimbursements Tracking Procedures were also revised. The procedure now involves not only the county clerk and deputy clerk, but also the grant applicant, accounts payable clerk, and the county Collector/Treasurer. The SEFA report will be reviewed by all involved to help ensure accuracy. Anticipated Completion Date: It is anticipated that the 2025 SEFA grant reporting will be much more accurate than in previous years. However, considering the new Grant Policy and the revised Grant Expenditures and Reimbursement Tracking Procedures were not in place until January 2025, it is anticipated that the date of completion will be January 2026.
« 1 13 14 16 17 28 »