Finding 2024-003: Inaccurate Reporting of SLFRF Expenditures and Fiscal Year End Federal Program: Coronavirus State and Local Fiscal Recovery Funds (SLFRF) Assistance Listing Number (ALN): 21.027 Federal Agency: U.S. Department of the Treasury Type of Finding: Compliance and significant deficiency in internal control over compliance Criteria: Per Uniform Guidance (2 CFR 200.510(b) and 2 CFR 200.516), recipients must accurately report expenditures and obligations in required annual compliance reports. Reports must also reflect the correct fiscal year end date as required by federal and state reporting standards. Context: Morgan County is a recipient of SLFRF funding and is required to submit accurate annual compliance reports reflecting actual expenditures and the correct fiscal year end. For the reporting period ending March 31, 2025, the County elected the $10 million standard allowance for revenue loss and was required to report all SLFRF expenditures incurred during the year ended December 31, 2024. Condition: The County’s SLFRF compliance report for the year ended December 31, 2024 included several clerical errors including incorrectly reporting there were $0 in current period expenditures rather than the $1,660,202 included on the Schedule of Expenditures of Federal awards as well as incorrectly listing the fiscal year end date as December 31, 2023. Cause: The errors appear to be due to insufficient oversight in preparing the annual compliance report due to staffing issues within the County. Effect: The inaccurate reporting resulted in noncompliance with federal and state reporting requirements. This may impact the transparency and accountability of SLFRF fund usage. Questioned Costs: None Recommendation: Morgan County should implement procedures to ensure accurate reporting of expenditures and correct fiscal year end dates in all future SLFRF compliance reports. The County should ensure that all future reports are reconciled to actual activity and comply with SLFRF and Uniform Guidance requirements. Views of Responsible Officials: Management concurs with the finding and will address the issue as outlined in the corrective action plan included in this report
Internal Control over Compliance and Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards (SEFA)) ALN: 10.904, Milk River Project ALN: 10.923, Stream Restoration and Bridge Replacement for St. Mary Siphon Failure ALN: 15.U01, Replacement of St. Mary and Hallls Coulee Siphons on St. Mary Canal CRITERIA: The Code of Federal Regulations (CFR) Section §200.510(b) states in part: "The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended." The schedule must provide total Federal awards expended for each individual Federal program. CFR 200.302(b)(1) requires that the nonfederal entity must identify in its accounts and on the schedule of expenditures of federal awards all federal awards received and expended, as well as the federal programs under which they were received. Federal program and award identification must include, as applicable, the Assistance Listing program title and number, the federal award identification number and year, the name of the federal agency, and the name of the pass-through entity, if any. CONDITION: The ALN 10.923, Stream Restoration and Bridge Replacement for St. Mary Siphon Failure, was left off the prepared SEFA. Amounts reported for ALN 10.904 and ALN 15.U01 did not agree to the accounting records. CONTEXT: The SEFA was misstated as follows: • Understated for ALN 10.904 by $196,980; • Understated for ALN 10.923 by $105,977; and • Overstated for ALN 15.U01 by $1,978,224. The net effect was an overstatement of $1,675,267 for total federal expenditures. EFFECT: The SEFA provided was not complete and accurate. QUESTIONED COSTS: None CAUSE: The internal controls for the preparation of the SEFA and review of the SEFA were not present to ensure the SEFA was complete and accurate. RECOMMENDATION: We recommend the MRJBOC prepare written procedures on how to put together the SEFA and strengthen internal controls to ensure all federal awards are included on the SEFA. We also recommend that the SEFA be reviewed by someone other than the preparer for completeness and accuracy prior to providing to the auditor. MRJBOC RESPONSE: MRJBOC acknowledges the deficiencies identified in the preparation and review of the Schedule of Expenditures of Federal Awards (SEFA). During 2024, the organization experienced a significant increase in federal funding activity related to emergency response and infrastructure replacement projects. The rapid expansion of federal programs, addition of funds and reporting requirements exceeded existing internal documentation and review processes. To strengthen compliance controls and ensure SEFA accuracy in future reporting periods, MRJBOC will implement the following corrective actions: • Develop and formalize written SEFA preparation procedures, including grant identification, ALN verification, and reconciliation to general ledger balances. • Establish a dual-review process in which the SEFA is reviewed and approved by a party independent from the preparer prior to submission to auditors. • Maintain a centralized federal grant tracking log that includes award numbers, funding sources, drawdowns, and cumulative expenditures. These measures will improve internal control over federal reporting, enhance accuracy, and ensure compliance with federal audit requirements.
Criteria: 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Awards Requirements, Standards for Financial and Program Management, and §200.302 (b), Financial Management. The recipients financial management system must provide for identification, in its accounts, of all federal awards received and expended and the federal program under which they were received. Federal program and federal award identification must include, as applicable, the federal assistance listing title and number, federal award identification number, name of the federal agency, and name of the pass-through entity, if any. Additional Criteria: 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F – Audit Requirements, §200.510, Financial Statements. Schedule of Expenditures of Federal Awards – The auditee also must prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements, which must include the total federal awards expended, as determined in accordance with §200.502, Basis for Determining Federal Awards Expended. At a minimum, the schedule must provide total federal awards expended for each individual federal program and the federal assistance listing number or other identifying number when the federal assistance listing information is not available. For a cluster of programs, also provide the total for the cluster. Condition: PCRI did not maintain a complete schedule of expenditures of federal awards. Cause: PCRI did not adequately track which government grants were federally-funded, resulting in an incomplete schedule of expenditures of federal awards. Effect: Failure to prepare an accurate and complete schedule of expenditures of federal awards results in noncompliance with 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Awards Requirements, Standards for Financial and Program Management, §200.302, Financial Management, and Subpart F – Audit Requirements, §200.510, Financial Statements. Recommendation: We recommend that PCRI document and implement policies and procedures to ensure the schedule of expenditures of federal awards is accurate and complete in accordance with 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Awards Requirements, Standards for Financial and Program Management, §200.302, Financial Management, and Subpart F – Audit Requirements, §200.510, Financial Statements, in order to obtain accurate calculations of major federal programs for the Single Audit and to ensure that PCRI is in compliance with all of the reporting requirements as to identify the source and application of funds for federally-funded activities.
Improper Preparation of the Schedule of Expenditures of Federal Awards Condition: The Agency did not properly prepare the Schedule of Expenditures of Federal Awards ("SEFA") as required by 2 CFR 200.510(b). The Agency did not initially prepare a SEFA as it was unaware that it had expended $750,000 in federal awards, thereby triggering the requirement for a Single Audit. The Chief Financial Officer was unaware of which grants qualified as Federal awards, especially those passed through the State or County. The Chief Financial Officer was also unaware of how to prepare a SEFA once the federal awards had been determined. Criteria: Under 2 CFR 200.510(b), an auditee that expends the federal award threshold in a fiscal year must prepare a SEFA for the period covered by its financial statements, including each federal program's assistance listing number, federal agency, pass-through entity, if applicable, and total federal expenditures by program. The SEFA is required supplementary information used as the basis for planning and conducting the Single Audit, including the determination of major programs. Cause: The condition resulted from insufficient knowledge and training of accounting staff and management regarding SEFA requirements and the Single Audit process. Management had not established detailed procedures, including reconciliation of the SEFA to the general ledger and grant records, or a formal review process to ensure that all required elements and programs were included and properly presented. Effect: Because the SEFA was not initially completed, there was a risk that one or more federal programs would not be selected and tested as part of the Single Audit, potentially resulting in noncompliance with Uniform Guidance audit requirements. Inaccurate reporting of federal expenditures can affect the determination of major programs, potentially lead to questioned costs, and may cause federal agencies to or pass-through entities to view the auditee as noncompliant with Single Audit reporting requirements. The ARPA grant under Assistance Listing Number 21.027 (Coronavirus State and Local Fiscal Recovery Funds) was identified as the major program for testing. However, we later discovered an additional county-funded grant under the same Assistance Listing number that had not previously been communicated. This omission resulted in an initial testing sample from an incomplete population requiring additional procedures to correct the impact on the Single Audit. Questioned Cost: None noted as a result of audit procedures performed. Recommendation: Management should develop and implement written procedures for preparing the SEFA that: • Identify all active federal awards and related pass-through awards from grant agreements and award notices. • Reconcile SEFA amounts to the general ledger and the grant reporting records. • Ensure that required elements (federal agency, Assistance Listing number, pass-through entity, and total expenditures) are accurately presented for each program. • Provide for a secondary review by someone knowledgeable about federal grant requirements and Single Audit rules prior to finalizing the SEFA. Management Response: We agree with the findings in the audit report and have developed a Corrective Action Plan to address each item promptly. This has been a challenging year for the organization, including turnover in the Chief Financial Officer ("CFO") position and the fact that this was our first Single Audit due to increased federal funding related to COVID-19 programs. These factors contributed to delays in audit readiness, gaps in technical accounting for grants, and weaknesses in internal controls over financial reporting and federal award reporting. We have implemented a comprehensive plan to address these challenges and will be hiring a new CFO in the first quarter of 2026.
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the City’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL number information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The City’s internal control procedures identified and properly recorded $141,051 of Coronavirus relief funds and $577,081 of Highway Planning and Construction pass-through expenses for PID #113961 for recording in their Schedule of Federal Awards Expenditures (Schedule). The City did not identify $381,346 of pass-through expenses for PID #115721 in the Schedule related to the Highway Planning and Construction Funds. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
Finding 2024-003 – All Federal Programs – Significant Deficiency Deficiency in Internal Controls over the Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Criteria: 2 CFR section 200.510(b) requires recipients of federal awards to prepare a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. The Uniform Guidance also requires that management establish and maintain effective internal controls over the preparation of the SEFA to ensure its accuracy and completeness. Condition: During our audit, we noted that the Organization did not have adequate internal controls in place to ensure the accuracy of the SEFA. Specifically, there was no documented review process to verify that all federal expenditures were properly identified, classified, and reported under the correct Assistance Listing numbers. As a result, a material adjustment was required to correct the SEFA for balance that were not from federal sources as well as correct the amounts reported. There was also certain federal expenditures reported under an incorrect Assistance Listing number. Cause: The deficiency occurred because the Organization had not developed or implemented a formal review procedure for the preparation of the SEFA. Finance staff responsible for preparing the SEFA did not coordinate with grant reporting personnel to ensure the completeness and accuracy of the information included in the schedule. Effect: The lack of appropriate internal controls over the preparation of the SEFA resulted in the initial omission and misclassification of federal expenditures. This could lead to incomplete or inaccurate reporting of federal awards, potentially resulting in noncompliance with federal requirements and affecting the determination of major programs for audit purposes. Questioned Costs: None noted. Recommendation: We recommend that the Organization develop and implement formal internal control procedures over the preparation of the SEFA. This should include a documented review process to ensure that all federal expenditures are accurately identified, classified, and reported under the correct Assistance Listing numbers. Finance staff should coordinate with grant reporting personnel to verify the completeness and accuracy of the SEFA prior to its finalization.
ALN 21.027 Finding #2024‐002 Incomplete Schedule of Expenditures of Federal Awards Repeat Finding: No Condition: The auditee’s Schedule of Expenditures of Federal Awards (SEFA) for the year ended December 31, 2024 did not include all federal awards. Specifically, two federal pass‐through grants (ALN# 21.027) in the aggregate amount of $1,035,393 were omitted. Criteria: Per 2 CFR §200.510(b), auditees must prepare a SEFA that is complete and accurate for the period covered by the financial statements. The SEFA must list individual federal programs by Federal agency, identify pass‐through entities, and present total federal awards expended. Government Auditing Standards require auditors to assess whether internal controls over federal reporting are designed and implemented effectively to ensure completeness and accuracy. Cause: The omission occurred because the auditee did not have adequate internal control procedures to ensure all federal awards were identified and reconciled to supporting accounting records. Effect: The omission resulted in the SEFA being materially misstated prior to auditor detection. This could have impacted the determination of major programs and the scope of the audit. Failure to prepare a complete SEFA increases the risk that federal oversight agencies and pass‐through entities may not have reliable information for monitoring federal funds. Perspective Information: The omitted grants totaled $1,035,393 of the Organization’s total federal expenditures for the year ended December 31, 2024. This indicates a systemic deficiency in the Organization’s SEFA preparation process. Recommendation: We recommend that management strengthen its internal control process over SEFA preparation. Specifically, management should establish procedures to: · Reconcile the SEFA to the general ledger and grant agreements, · Review grant award schedules with program and finance staff to ensure completeness, and · Implement a secondary review of the SEFA prior to submission. Reporting Views of Responsible Officials: The Organization agrees with the finding. The Organization was unaware that passthrough funds from federal sources are required to be presented on the SEFA and has implemented procedures to ensure all grants are evaluated to ensure the SEFA is complete.
2024-001: Internal Control Over Schedule of Expenditures of Federal Awards Federal Grantor: U.S. Department of Transportation (DOT), U.S. Department of the Treasury (Treasury), Election Assistance Commission (EAC) Pass-Through Grantor: Missouri Department of Transportation, Missouri Secretary of State Federal Assistance Listing Number: 20.205, 21.027, 90.404 Program Title: Highway Planning and Construction, Coronavirus State and Local Fiscal Recovery Funds, HAVA Election Security Grants Pass-through Entity Identifying Number: BRO-R099(001), BRO-B099(23), RRP-000S(581) Award Year: 2024 Questioned Costs: None Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards (SEFA) which must report total federal awards expended during the audit period. At a minimum, the schedule must include: expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. Condition: The SEFA reported by the County in the 2025 annual budget document did not include all federal expenditures. Discrepancies in amounts reported on the 2024 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a review of underlying accounting records to ensure all federal expenditures have been included. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2024. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Finding: 2024-003 CFDA Number: 14.218 Program Name: Community Development Block Grants Federal Agency: U.S. Department of Housing and Urban Development Type of Finding: Federal Award Finding Compliance Requirement: Reporting Questioned Costs: N/A Criteria According to 2 CFR 200.510(b), the auditee must prepare a SEFA that includes all federal awards expended, listed by federal program and Assistance Listings Number, along with the total amount provided to subrecipients. The SEFA must also include notes that describe the significant accounting policies used in preparing the schedule. The expenditures must be reported on the same basis of accounting as the auditee’s financial statements. Condition During our audit of the Friends of the Mission's SEFA for the fiscal year ended December 31, 2024, we noted that the SEFA did not accurately report the total federal awards expended for the U.S. Department of Housing and Urban Development, Assistance Listings Number 14.218. The SEFA understated expenditures by $409,477 from the Community Development Block Grants passed through from The City of Woodland. Cause The auditee’s internal controls over the preparation of the SEFA were not sufficient to ensure all federal expenditures were accurately identified and reported. Additionally, staff responsible for SEFA preparation were not fully trained on the requirements of 2 CFR 200.510(b). Effect: The inaccurate reporting of federal expenditures in the SEFA could lead to noncompliance with federal award requirements, misstatements in the single audit report, and potential delays or errors in the submission of the data collection form to the Federal Audit Clearinghouse. This may also impact the auditee’s ability to demonstrate compliance with federal regulations. Recommendations: We recommend that Friends of the Mission implement the following corrective actions: 1. Develop and document a formal process for preparing the SEFA, including procedures to identify and track all federal awards. 2. Provide training to staff responsible for SEFA preparation on the requirements of 2 CFR 200.510(b). 3. Implement a review process to ensure the SEFA is complete, accurate, and consistent with the auditee’s financial statements prior to submission. 4. Reconcile the SEFA with the general ledger and federal award records to ensure all expenditures are properly reported. Management's Response Management is aware of the finding and has taken steps to rectify the finding so that it does not repeat in future years.
Federal agency: U.S. Department of the Treasury Federal program title: Coronavirus Capital Projects Fund Assistance Listing (ALN): 21.029 Pass-through agency: State of Delaware Period of performance: Through December 31, 2026 Finding Number: 2024-001 Type of finding: - Significant Deficiency in Internal Control over Compliance, and - Noncompliance with 2 CFR §200.510(b) (SEFA completeness) Criteria or Specific Requirement: - SEFA content and completeness. Under 2 CFR §200.510(b), the auditee must prepare a complete Schedule of Expenditures of Federal Awards (SEFA) listing each federal program by federal agency and ALN, and for subawards, the pass-through entity’s name and identifying number. - Auditor reporting. Audit findings must be reported under 2 CFR §200.516(a) when there is material noncompliance and/or significant deficiencies/material weaknesses related to federal programs. Condition: During the audit, we noted that the Organization’s initial SEFA did not include all federal pass-through awards, including certain U.S. Department of the Treasury – Coronavirus Capital Projects Fund (ALN 21.029) subawards administered by the state of Delaware. The additional federal awards were identified by the auditors and subsequently added to the SEFA prior to report issuance. Questioned Costs: None were identified as part of this finding. Context: The omission was identified during SEFA procedures and major program determination. Because the SEFA is the basis for planning and selecting major programs, initial incompleteness could have affected major program determination and compliance testing. (SEFA must include ALN, pass-through, and award IDs per 2 CFR §200.510(b); audit findings are required to be reported per §200.516(a).) Cause: Controls over SEFA preparation and federal award identification were not sufficient to ensure all pass-through federal awards (including ARPA CPF) were captured with required identifiers (federal agency, ALN 21.029, pass-through name/number) before year-end reporting. Effect: An initially incomplete SEFA increases the risk that: - major programs are not properly identified for testing (§200.518) - the auditor may need to modify the SEFA in-relation-to opinion or compliance opinion if not corrected before report issuance (§200.515). - cause a delay in the audit Repeat Finding: No Recommendation: We recommend management implement (and document) SEFA preparation controls to ensure completeness and accuracy, including: 1. Maintaining a central grant repository containing award documents with federal agency, ALN (21.029), FAIN/prime award, pass-through entity, pass-through ID(s), period of performance, and award amounts. 2. Performing a year-end SEFA reconciliation from the general ledger and grant subledger to the repository, confirming all pass-through awards are captured with required ALN and identifiers per §200.510(b). 3. Obtaining written ALN/FAIN confirmations from pass-through entities for any awards lacking federal identifiers and retaining those confirmations in the grant file. Views of Responsible Officials: Christina Cultural Center experienced a SEFA completeness finding during a year with bookkeeping turnover, which affected the initial compilation of federal award activity. In response, management worked closely with the audit team to confirm the complete listing of awards, validate pass-through entity details, and support accurate SEFA presentation. The organization has also identified cross-training as a key next step to strengthen continuity and reduce key-person dependency going forward.
Finding No. 2024-001 Implement System-Based Tracking of Federal Expenditures Assistance Listing Number: 93.566 Program Name: Refugee and Entrant Assistance State/Replacement Designee Administered Programs Federal Agency: Department of Health and Human Services (HHS) Passed Through Entities: 1. California Department of Social Services 2. University of California, San Diego 3. California Rural Legal Assistance Foundation 4. San Diego Refugee Communities Coalition/United Women of East Africa Support Team 5. Public Health Institute (PHI) Federal Award Numbers: ALSP22-0002-A1, ALSP23-0001, PUR00533092, ACS22-05-CAIR, 06568-AR76924 Federal Award Year: August 1, 2022 to June 30, 2026 Compliance Requirement: Activities Allowed or Unallowed Criteria: Management is responsible for designing, implementing, and maintaining an internal control system that ensures accurate financial reporting. Effective internal control over financial reporting provides reasonable assurance regarding the completeness and accuracy of accounting records, and compliance with grantor requirements. 2 CFR 200.510 Financial Statements require auditees to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements. This schedule must include the total Federal awards expended, as determined in accordance with 2 CFR 200.502. The information presented should be consistent with the accounting records (i.e., general ledger). In addition, Section 2 CFR 200.302(b)(1) provides that non-Federal entities must maintain effective control over and accountability for all funds, and must identify, in their accounts, all Federal awards received and expended. Condition: During our review of the SEFA, we noted that CAIR-CA utilizes workbooks outside of its accounting software to track federal expenditures. The workbooks do not reconcile directly with the general ledger (GL), so management performs a separate reconciliation to support the SEFA amounts. This approach was similarly observed in the prior year's audit. Cause: The prior year audit was completed in August 2025, after the close of the fiscal year 2024. As a result, management was still in the process of implementing a system-based tracking during the year 2024. CAIR-CA’s processes for tracking federal awards are continuing to develop, as this is only the second year under Single Audit. Effect: Using manual workbooks requires additional manual effort and may make reconciliation between SEFA and GL more time-consuming, and may result in inaccurate or incomplete reporting. Questioned Cost: None Recommendation: We recommend that CAIR-CA continue enhancing its accounting processes to track federal expenditures directly within its accounting software. This could include GL tracking codes or other similar identifiers for federal programs. System based tracking would simplify SEFA preparation, improve consistency with the general ledger, and strengthen monitoring of federal expenditures. Views of Responsible Officials and Corrective Action Plan: Management concurs with the finding and has already updated the accounting system to incorporate grant-specific tracking codes to further align with federal reporting standards. Because the organization’s first single audit in FY2023 was conducted concurrently with the FY2024 single audit, there was limited opportunity for these procedural improvements to be reflected in the FY2024 single audit testing cycle. As a result, the impact of these changes will be more fully reflected in the FY2025 single audit, which is scheduled to commence this year. As part of a layered approach to internal controls, excel worksheets will continue to be used as a supplementary monitoring tool, providing an additional cross-check to the system-generated reports. Responsible person: Jackie Ramirez, Operations & Finance Associate Director Implementation date: November 20, 2025
Information on Federal Programs: 93.083 – Centers for Disease Control and Prevention: Prevention of Disease, Disability, and Death through Immunization & Control of Respiratory & Related Diseases. Criteria or Specific Requirements: 2 CFR §200.510(b) requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee’s financial statements that includes Federal awards expended during that fiscal year. 2 CFR §500.502 provides that the determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs. Condition: During testing of the SEFA for the year ended December 31, 2024, we noted that certain Federal program expenditures related to activities incurred in fiscal year 2023 were reported in the 2024 SEFA instead of in the 2023 SEFA. Cause: Management’s procedures for preparing and reviewing the SEFA did not include sufficient controls to ensure that expenditures are reported in the correct fiscal year. Effect: The SEFA for the year ended December 31, 2023 was incomplete, and the SEFA for the year ended December 31, 2024 includes expenditures that related to activities incurred in fiscal year 2023. Although the expenditures were allowable costs of the Federal program, the timing misstatement affects the accuracy of SEFA presentation and could affect the usefulness of SEFA information to Federal agencies and pass-through entities in their monitoring and oversight. The error did not impact the major program selection process for 2023 or 2024.Perspective: This issue was identified during our testing of the SEFA for the year ended December 31, 2024, when we noted that ATS reported $114,984 of Federal award expenditures in 2024 that related to activities incurred in fiscal year 2023. These expenditures should have been reported in the SEFA for year ended December 31, 2023. Questioned Costs: None. Identification as a Repeat Finding: Not applicable. Recommendation: ATS should implement formal procedures for compiling the SEFA, including (1) reconciling SEFA amounts to the general ledger and other supporting records, (2) performing a year-end review to confirm that expenditures are reported in the correct fiscal year in accordance with 2 CFR §200.502 and 2 CFR §200.510(b), and (3) documenting supervisory review of the SEFA prior to finalization.
2024-001 - SEFA REPORTING Federal Program Information: Federal Agency and Program Name - National Endowment for the Humanities Promotion of the Humanities Federal/State Partnership Grant Number: SO-289836-23 Federal Assistance Listing Number 45.129 Criteria: 2 CFR 200.303 requires that a non-federal entity must “(a) establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non- Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.510(b) states that “the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502.” Condition: The Council’s internal controls are not adequate to ensure the Schedule of Expenditures of Federal Awards (SEFA) accurately reports Federal assistance. The Council’s fiscal year 2024 SEFA for the Promotion of the Humanities Federal/State Partnership program included expenditures from other fiscal years. Questioned Costs: Not applicable. Context: Total federal expenditures for the Promotion of the Humanities Federal/State Partnership program were $902,649 for the year ended October 31, 2024. Cause: The Council does not have adequate internal controls in place to ensure the accuracy of the SEFA. Effect: The Council is not reporting accurate financial information in its SEFA. Identification as a Repeat Finding: Prior Year Finding 2023-004 Recommendation: We recommend that the Council implement controls over financial reporting, including the SEFA, to ensure accuracy of financial data. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
2024-001 - SEFA REPORTING Federal Program Information: Federal Agency and Program Name - National Endowment for the Humanities Promotion of the Humanities Federal/State Partnership Grant Number: SO-289836-23 Federal Assistance Listing Number 45.129 Criteria: 2 CFR 200.303 requires that a non-federal entity must “(a) establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non- Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.510(b) states that “the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502.” Condition: The Council’s internal controls are not adequate to ensure the Schedule of Expenditures of Federal Awards (SEFA) accurately reports Federal assistance. The Council’s fiscal year 2024 SEFA for the Promotion of the Humanities Federal/State Partnership program included expenditures from other fiscal years. Questioned Costs: Not applicable. Context: Total federal expenditures for the Promotion of the Humanities Federal/State Partnership program were $902,649 for the year ended October 31, 2024. Cause: The Council does not have adequate internal controls in place to ensure the accuracy of the SEFA. Effect: The Council is not reporting accurate financial information in its SEFA. Identification as a Repeat Finding: Prior Year Finding 2023-004 Recommendation: We recommend that the Council implement controls over financial reporting, including the SEFA, to ensure accuracy of financial data. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
Finding Number: 2024-001 Federal Program: Community Development Block Grant (CDBG) – Assistance Listing 14.218 Condition: The City’s original Schedule of Expenditures of Federal Awards (SEFA) and supporting audit documentation for the year ended October 31, 2024, did not include expenditures related to the Community Development Block Grant (CDBG) program. The omission was identified during the audit process and the SEFA was subsequently revised to include the CDBG program. Criteria: 2 CFR 200.510(b) requires the auditee to prepare a SEFA that lists individual federal programs by federal agency, including the Assistance Listing number, and to report total federal awards expended for each program. 2 CFR 200.508(b) requires the auditee to identify in its accounts all federal awards received and expended and the federal programs under which they were received. Cause: The omission occurred due to inadequate internal controls over the identification and reporting of all federal programs and related expenditures in the SEFA. Effect: As a result, the CDBG program was not initially subject to audit procedures required by the Uniform Guidance, increasing the risk that material noncompliance with federal requirements could go undetected. Recommendation: We recommend that the City strengthen its internal controls over the preparation of the SEFA to ensure that all federal programs and related expenditures are identified, recorded, and reported accurately and completely. This should include a review and reconciliation process involving all departments responsible for federal program administration. Management’s Response: Management concurs with the finding and has implemented additional review procedures to ensure all federal programs are identified and included in the SEFA in future years.
Finding 2024-002: Schedule of Expenditures of Federal Awards (Significant Deficiency) Information on the Federal Program: Assistance Listing Number 19.518 See Finding 2024-001. Finding 2024-002 is a significant deficiency in internal control over compliance in addition to non-compliance related to the Reporting compliance area. There were no questioned costs as a result of the corrections to the SEFA.Criteria or Specific Requirement: Management is responsible for the complete and fair presentation of the financial statements, including any supplementary information that is presented in relation to the financial statements, such as the Schedule of Expenditures of Federal Awards (SEFA). Also, in accordance with 2 CFR Section 200.510 (b)(2), WRC is required to include all direct and pass-through Federal awards expended during the fiscal year in the SEFA. Condition: After the start of the audit, we noted that two pass-through federal awards had been excluded from the SEFA. As a result, the SEFA was understated by $329,598 for the year ended September 30, 2024. Management provided a revised SEFA to correct these items after the major program had been determined and audit testing had already completed. The corrections to the SEFA did not change the major program determination and no questioned costs were noted. Cause: One of the pass-through federal awards was a new source of funding for WRC, which is why the expenditures were not originally included on the SEFA. The other pass-through federal award was not classified correctly as federal, which is why the expenditures were not originally included on the SEFA. Effect or Potential Effect: The SEFA provided at the start of the audit was understated by $329,598 and, as a result, it did not accurately report WRC’s federal expenditures. When the SEFA is not accurately prepared, this could have an effect on the determination of the major programs. Identification as a Repeat Finding: Not applicable. Recommendation: We recommend that WRC enhance its procedures related to the preparation of the SEFA to ensure that all required amounts are included, depending upon the terms of the grant award.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Assistance Listing, Federal Agency, and Program Name - 66.818, U.S. Environmental Protection Agency, Brownfields Assessment and Cleanup Cooperative Agreements; 21.027, U.S. Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 21.027 SLFRP0127 Pass through Entity - ALN 21.027 - State of Michigan Finding Type - Material weakness Repeat Finding - Yes 2023-002 Criteria - The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program-specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of federal awards in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition - The schedule of expenditures of federal awards (SEFA) was not accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - During the fiscal year ended September 30, 2024, the City expended approximately $2,831,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 66.818 - The expenditures reported on the SEFA were understated by $148,474. ALN 21.027 - The expenditures reported on the SEFA were overstated by $2,078,221. The SEFA was also ovestated by $116,625 related to a non federal program. The errors noted above have been corrected on the SEFA as of September 30, 2024. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the overstatement of federal expenditures. Recommendation - We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - The City will review its process for identifying and communicating federal grant expenditures to its auditors.
Assistance Listing, Federal Agency, and Program Name - 66.818, U.S. Environmental Protection Agency, Brownfields Assessment and Cleanup Cooperative Agreements; 21.027, U.S. Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 21.027 SLFRP0127 Pass through Entity - ALN 21.027 - State of Michigan Finding Type - Material weakness Repeat Finding - Yes 2023-002 Criteria - The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program-specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of federal awards in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition - The schedule of expenditures of federal awards (SEFA) was not accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - During the fiscal year ended September 30, 2024, the City expended approximately $2,831,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 66.818 - The expenditures reported on the SEFA were understated by $148,474. ALN 21.027 - The expenditures reported on the SEFA were overstated by $2,078,221. The SEFA was also ovestated by $116,625 related to a non federal program. The errors noted above have been corrected on the SEFA as of September 30, 2024. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the overstatement of federal expenditures. Recommendation - We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - The City will review its process for identifying and communicating federal grant expenditures to its auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.
Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Significant Deficiency) Federal Award Program: All Awards Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The Intermediary Relending Program and Rural Microentrepreneur Assistance Relending Program awards loan expenditures were calculated incorrectly by including the repayments and excluding the loan service income. • The CFDA #11.037 and #11.419 were not grouped with the correct Federal Grantor. • The STEM Education award had 2 CFDA #’s provided on one line. • There were multiple Federal Grantor and Program Titles that were mislabeled. Questioned Costs: None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Management should also ensure that they obtain the complete and full agreements from grantors that are signed by all parties and that clearly identify the funding source. Views of Responsible Officials and Planned Corrective Actions: Management attempted to contract with multiple accounting consultants for creating the SEFA but they were already at full capacity and were not available to assist with the creation of the report. When the relevant contract or grant award did not include the necessary information, SCEC management and program staff reached out to our contracting agencies to confirm whether federal funds were part of each award and to find out CFDA numbers and other contract information necessary to complete the form. Nevertheless, there were several errors that in the SEFA submitted to our auditors for review. For the two IRP and RMAP lending programs, the prior year balances were carried over into the FY 24 SEFA through a clerical error. The errors in item 11.037 and 11.419 are related to information we received from the contracting agency. In particular, 11.037 was listed under US Economic Development Administration according to the contracting agency and we were given the description of Economic Adjustment Assistance. The description for 11.419 was given to SCEC by the contracting agency as CDS – Congressionally Directed Spending. Finally, we provided two CFDA’s for the STEM Education award with the submission of the SEFA as we were waiting for confirmation from Program Managers about the correct CDFA numbers. The auditors were informed that we were waiting for these numbers when the SEFA was submitted. In FY24, SCEC had 29 different federal funding sources, from 14 different agencies. We are working to improve our capacity to report these awards without error before the review of our auditors.