Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Finding 2023-002 – SEFA Reporting Federal Program: Medicaid Assistance Program HIV Emergency Relief Project Grants ALNs: 93.778 93.914 Federal Agency: U.S. Department of Health and Human Services Federal Award Years: July 1, 2022 – June 30, 2024 (93.778) March 1, 2022 – February 28, 2024 (93.914) Criteria: 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees 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. Condition Found, Including Perspective: The Schedule of Expenditures of Federal Awards (SEFA) prepared by management contained certain differences between federal expenditures reported and the years in which the federal awards were expended totaling $174,977 related to the Medicaid Assistance Program and $250,808 relate to the HIV Emergency Relief Project Grants. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that certain amounts were properly reflected on the SEFA in the period in which they were expended. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: Yes – 2022-001 Recommendation We recommend that management implement appropriate controls and processes to ensure that expenditures are presented on the correct SEFA year. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Finding 2023-003 – SEFA Reporting Federal Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Disaster Grants – Public Assistance ALNs: 21.027 97.036 Federal Agency: U.S. Department of Treasury U.S. Department of Homeland Security Federal Award Years: October 1, 2022 – September 20, 2024 (21.027) January 1, 2023 – December 31, 2023 (97.036) Criteria: 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees 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. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designated to reasonably ensure compliance with Federal laws, regulations and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately and completely reported on the SEFA. Condition Found, Including Perspective: The System did not have adequate controls relating to the reporting of expenditures on the SEFA for the FEMA – Disaster Grants – Public Assistance and the Coronavirus State and Local Fiscal Recovery Funds programs. Specifically, the System did not have a control in place to ensure that all FEMA awards obligated during the year were recorded on the SEFA. Additionally, the System did not have a control in place to ensure that all incurred expenditures were properly accrued on the SEFA. As a result, the expenditures on the SEFA were understated as follows: • Expenditures of $2,038,362 for the FEMA – Disaster Grants – Public Assistance program were obligated and incurred as of December 31, 2023 but not recorded on the SEFA. • Expenditures of $2,790,267 for the Coronavirus State and Local Fiscal Recovery Funds program were incurred but not accrued for at year end. • Expenditures of $7,529,167 for the Coronavirus State and Local Fiscal Recovery Funds program which were incurred during 2023 and subsequently identified by management to be submitted for reimbursement under the federal award. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that amounts were properly recognized on the SEFA in the period in which they were expended. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the System from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: This is not a repeat finding. Recommendation We recommend that management implement appropriate controls and processes to ensure that the SEFA is complete and accurate. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Federal Agency: U.S. Department of the TreasuryFederal Program Name: Emergency Rental Assistance Program (ERAP) Assistance Listing Number: 21.023 Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of Health and Human Services Pass-Through Number(s): ERA-2101060067, ERA2-0391, ERAP2 Award Period: 1/1/2023 – 12/31/23 Type of Finding: Significant Deficiency in Internal Control Over Compliance Criteria or Specific RequirementUniform guidance requires the auditee to prepare a schedule of expenditures of federal awards (SEFA) which must include the total federal awards expended as determined in accordance with sub-section 200.502. 2 CFR 200.510. A non-federal entity must maintain effective internal control over the federal award (2 CFR 200.303).Condition and ContextPolicies and controls in place regarding the completeness of the SEFA were not properly functioning. Within the supporting listing of expenses relating to ERAP expenditures, six transactions were identified as prior fiscal-year expenditures that were included in the unadjusted 2023 expenditure total. The County revised the 2023 SEFA to exclude the 2022 expenditures. Questioned Costs$33,301 Cause Controls ensuring that only federal expenditures incurred in the period from January 1, 2023 to December 31, 2023 were not operating as designed.Effect Potential inaccurate expenditure reporting in the SEFA. Repeat Finding No.Recommendation We recommend management should review the process of recording federal expenditures to determine expenditures are being included in the appropriate fiscal year.Views of Responsible Officials There is no disagreement with the audit finding and the County is in the process of implementing corrective procedures.
Federal Agency: U.S. Department of the Treasury Federal Program Name: American Rescue Plan Act / Coronavirus State Fiscal Recovery Fund (ARPA) Assistance Listing Number: 21.027Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of Health and Human Services Pass-Through Number(s): 2022-CG-01-39297, SLFRP3241, C000084584, 4100095388 Award Period: 1/1/2023 – 12/31/23 Type of Finding: Significant Deficiency in Internal Control Over ComplianceCriteria or Specific Requirement Uniform guidance requires the auditee to prepare a schedule of expenditures of federal awards (SEFA) which must include the total federal awards expended as determined in accordance with sub-section 200.502. 2 CFR 200.510. A non-federal entity must maintain effective internal control over the federal award (2 CFR 200.303).Condition and Context Policies and controls in place regarding the completeness of the SEFA were not properly functioning. Within the supporting listing of expenses relating to ARPA expenditures, multiple transactions were identified as 2022 fiscal year expenditures that were included in the in 2023 expenditure total. The County revised the 2023 SEFA to exclude the 2022 expenditures. Questioned Costs$381,675 Cause Controls ensuring that only federal expenditures incurred in the period from January 1, 2023 to December 31, 2023 were not operating as designed. Effect Potential inaccurate expenditure reporting in the SEFA. Repeat Finding No.Recommendation We recommend management should review the process of recording federal expenditures to determine expenditures are being included in the appropriate fiscal year.Views of Responsible Officials There is no disagreement with the audit finding and the County is in the process of implementing corrective procedures.
Finding 2023-003: Material Weakness – SEFA reporting Federal grantor: All Federal Programs Condition: The SEFA was not complete and contained reporting errors. MBDA Supplemental grants were omitted, and the awards amounts, CDFI numbers for other grants in SEFA were inaccurate. Criteria: Per 2 CFR § 200.510(b), the SEFA must include a complete and accurate accounting of all federal awards expended during the fiscal year, including correct CDFI numbers, program names, and total expenditures. Cause: The issues appear to result from a lack of comprehensive review and reconciliation procedures during SEFA preparation. Effect: Incomplete and inaccurate SEFA reporting leads to noncompliance with Uniform Guidance and increases the risk of omitted federal programs, incorrect major program determination, and errors in reporting to federal oversight agencies. Recommendation: The Chamber needs to strengthen internal control over SEFA preparation by implementing a formal review process, verifying all CDFI numbers, and ensuring all federal awards are accurately included. Views of Responsible Officials and Planned Corrective Actions: The Chamber agrees with the finding and is in the process of implementing a better review process that will be effective in 2025.
Finding 2023-002: Material Weakness – Revised Schedule of Expenditures of Federal Awards Federal Grantor: U.S. Department of Treasury Passed-through: City and County of Sacramento Compliance Requirement: Reporting Condition: Expenditures reported on the SEFA were revised during the single audit. Criteria: Per 2 CFR § 200.510(b), the SEFA must include a complete and accurate accounting of all federal awards expended during the fiscal year, including correct CDFI numbers, program names, and total expenditures. Cause: The issues appear to result from a lack of comprehensive review and reconciliation procedures during SEFA preparation. Effect: Incomplete and inaccurate SEFA reporting leads to noncompliance with Uniform Guidance and increases the risk of omitted federal programs, incorrect major program determination, and errors in reporting to federal oversight agencies. Recommendation: The Chamber needs to strengthen internal control over SEFA preparation by implementing a formal review process, verifying expenditures are properly reported. Views of Responsible Officials and Planned Corrective Actions: The Chamber agrees with the finding and is in the process of implementing a better review process that will be effective in 2025.
Criteria: Per 2 CFR §200.510(b), the SEFA must include: - A list of individual federal programs by agency, including the Assistance Listing number. - The total federal awards expended for each program, including capital projects funded by federal grants. - Amounts passed through to subrecipients. - Outstanding balances for loan or loan guarantee programs. - Significant accounting policies used in preparing the SEFA. Condition: During our audit of the Schedule of Expenditures of Federal Awards (SEFA), we identified that the schedule was incomplete. Specifically, certain federal awards were either omitted or incorrectly reported, including a significant omission of During 2023, there was approximately $16.5 million in federal funds received for capital projects. These amounts should have been included in the SEFA as part of the entity's total federal expenditures. Cause: The omission of the capital project funds appears to have resulted from a misunderstanding of what constitutes an expenditure for SEFA reporting purposes. The entity may not have recognized that capital outlays funded by federal grants must be included, leading to an understated SEFA. Other errors in the SEFA appear to have resulted from inadequate reconciliation processes between the entity's accounting records and federal grant reports. Possible effect: An incomplete SEFA could result in noncompliance with the Uniform Guidance and an incomplete Single Audit. Questioned cost: N/A Recommendation: We recommend that management: - Implement a reconciliation process to ensure that all federal expenditures are accurately captured in the SEFA. - Provide additional training for accounting personnel on federal reporting requirements. - Review all local government awards to determine whether Federal funds are a component of the contracts. - Review SEFA data for completeness and accuracy before submission. Views of responsible officials: The Schedule of Expenditures of Federal Awards (SEFA) provided to the audit firm was incomplete due to two primary factors: (1) insufficient understanding by staff regarding the requirement to include federally funded capital expenditures, and (2) improper recording of property acquisitions. Management acknowledges this oversight, which occurred during the implementation of a new program and at a time when staff were not fully aware that such expenditures must be reflected on the SEFA. Furthermore, certain capital expenditures paid directly through escrow were not recorded in the organization's accounting records. To remediate these issues, management has taken the following corrective actions: - Delivered targeted training to staff on the proper treatment and reporting of federally funded capital expenditures; - Updated internal closing and reporting procedures to incorporate a formal review of balance sheet activity; and - Updated internal closing and reporting procedures to incorporate a reconciliation to settlement statements when recording new property acquisitions; and - Strengthened internal controls to ensure all federally funded capital items are accurately captured in future SEFA submissions. Management is committed to maintaining compliance with federal reporting requirements and ensuring the completeness and accuracy of future SEFAfilings.
Finding 2023-003 – Huerfano County - Internal controls over the preparation of the SEFA Criteria: In accordance with 2 CFR Part 200.510(b)(2), the auditee is responsible for preparing a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Part 200.303(a) and 2 CFR Part 200.502. Condition: The County does not have adequate internal controls to ensure the SEFA accurately reports all federal assistance the county receives. Cause: Grant management at the county is decentralized and departments are responsible for providing the required information to the County’s department of finance to facilitate the preparation of the SEFA. The department of finance was not provided accurate federal program expenditures. Effect: The SEFA did not correctly report all Federal expenditures. The Federal government relies on the SEFA information to be reported accurately. In addition, accurate SEFA information is relied upon by the auditors in order to perform the major program determinations utilized to select the Federal programs subject to Single Audit procedures. Questioned Costs: None reported. Repeat Finding: No. Recommendation: We recommend the County implement a countywide system to allow for a more automated system of tracking federal expenditures, that may include updated processes to be developed to set up new organization codes which would require grant managers to provide the required information needed for accurate SEFA preparation. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has implemented new process to ensure accurate preparation of their SEFA’s.
2023-003: Internal Control Over Schedule of Expenditures of Federal Awards Federal Grantor: U.S. Department of Agriculture (USDA), U.S. Department of the Interior (Interior), U.S. Department of Justice (DOJ), U.S. Department of Transportation (DOT), U.S. Department of the Treasury (Treasury), and U.S. Department of Health and Human Services (HHS) Pass-Through Grantor: Missouri Department of Health and Senior Services, Missouri Department of Public Safety, and Missouri Department of Transportation Federal Assistance Listing Number: 10.557, 10.665, 15.226, 16.738, 20.205, 21.027, 93.069, 93.323, 93.354, 93.767, 93.778, 93.967 and 93.994 Program Title: Special Supplemental Nutrition Program for Women, Infants, and Children; Schools and Roads – Grants to States; Payments in Lieu of Taxes; Edward Byrne Memorial Justice Assistance Grant Program; Highway Planning and Construction; Coronavirus State and Local Fiscal Recovery Funds; Public Health Emergency Preparedness; Epidemiology and Laboratory Capacity for Infectious Diseases; Public Health Emergency Response; Children’s Health Insurance Program; Grants to States for Medicaid; CDC Collaboration with Academia to Strengthen Public Health; Maternal and Child Health Services Block Grant Pass-through Entity Identifying Number: ERS04523109, BRO-B020(18), BRO-B020(19), SLFRP4542-CJMI005, DH220051995, DH2200517449, CK000546-01B, DH230051996, DH220051742, OE00007201A1, DH220051847 Award Year: 2022 and 2023 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. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The SEFA reported by the County in the 2023 and 2024 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Discrepancies in amounts reported on the 2023 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 reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2023 and 2022. 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.
2023-003 Federal Agencies: U.S. Department of Housing and Urban Development Federal Program Names: Community Development Block Grants Assistance Listing Numbers: 14.218 Pass-Through Agency: District of Columbia, Department of Housing and Community Development Pass-Through Number: 2012-009 Award Period: January 1, 2023 through December 31, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance Criteria: Federal funding arrangements may be subject to compliance requirements, schedule of expenditures of federal awards reporting, and single audit requirements when federal expenditures meet the applicable threshold. Under 2 CFR § 200.501(a), a nonfederal entity that expends federal awards at or above the applicable threshold during the fiscal year is required to have a single audit or program-specific audit conducted for that year. In addition, 2 CFR § 200.510(b) requires the auditee to prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements. Condition: The $200,000 predevelopment and $3,800,000 construction loans from the District of Columbia Department of Housing and Community Development were financed with federal funding. Management and the prior auditors were not previously aware of the federal funding source, and the loan had not been evaluated for applicable federal compliance requirements under OMB Circular A-133 or the Uniform Guidance since the inception of the agreement. Questioned Costs: None Context: Federal funding arrangements may be subject to compliance requirements, schedule of expenditures of federal awards reporting, and single audit requirements when federal expenditures meet the applicable threshold. The Uniform Guidance requires a single audit or program-specific audit when a nonfederal entity expends federal awards at or above the applicable threshold during the fiscal year. Cause: RAP, Inc. did not have a formal process to identify whether loans, grants, or financing agreements were funded through federal sources or subject to OMB Circular A-133 or Uniform Guidance requirements. As a result, the loan was not included in the entity’s federal award compliance review process. Effect: RAP, Inc. may be at risk of noncompliance with federal award requirements, including SEFA reporting, single audit, and pass-through agency requirements. Under 2 CFR § 200.516(a), these matters may need to be reported as audit findings when they involve significant deficiencies, material weaknesses, material noncompliance, or known or likely questioned costs above the reporting threshold. Under 2 CFR § 200.339, the federal agency or pass-through entity may also impose remedies for noncompliance, such as disallowing costs, withholding payments or funding, suspending or terminating the award, or taking other legally available actions. Recommendation: We recommend that management implement a formal process to review all loan, grant, and financing agreements to determine whether funding is derived from federal sources and whether the arrangement is subject to federal compliance or single audit requirements. This review should be performed at inception of each agreement and updated at least annually, with documentation maintained in the entity’s debt and contract repository and reviewed by personnel responsible for compliance and financial reporting. Views of Responsible Officers and Corrective Action Plan: Please refer to Regional Addiction Prevention, Inc.’s Corrective Action Plan.
Criteria: The Schedule of Expenditures of Federal Awards reported for the year under audit must reflect actual federal expenditures. Per 2 CFR 200.510(b) Schedule of expenditures of Federal awards, “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, Basis for determining Federal awards expended. 2 CFR 200.502(a) Determining Federal awards expended, states that “the determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” Condition: Federal expenditures were not correctly reported on the City of Blaine, Minnesota’s 2023 SEFA included in the original audit report dated September 12, 2024. Subsequent to the original audit report issuance dated September 12, 2024, it was determined that $935,584 of expenditures relating to a subrecipient grant from the State of Minnesota under the Highway Planning and Construction (Federal-Aid Highway Program) were not included on the SEFA. Cause: Sufficient internal controls were not in place to ensure proper recognition of contractor versus subrecipient relationships for federal funds received through pass-through entities. Questioned Costs: None. Effect: By not having proper controls over SEFA preparation, there is a risk that the SEFA will not reflect all the federal awards subject to the Uniform Guidance. The total change in federal expenditures reported on the SEFA was $935,584. Context: The City considered itself to have a contractor relationship with the State of Minnesota under Federal Project # HSIP 0223 (118), DCP Agreement #1050395, instead of a subrecipient relationship; therefore, these funds were excluded from the SEFA. However, per subsequent review of grant documentation and communications with the State, it was determined the City was a subrecipient of federal funds under this project. Recommendation: We recommend that the City of Blaine, Minnesota review procedures to ensure timely identification of federal funds, including the clear distinction between subrecipient and contractor relationships for all contract and grant agreements involving federal funds, and verify any changes are properly communicated. In situations where the relationship is unclear, we recommend City staff contact the pass-through entity for clarification. Views of Responsible Officials and Planned Corrective Actions: Management agrees with this finding and has developed internal controls to ensure timely identification of federal funds including identifying whether the City is a subrecipient and contractor when receiving funds. Additional details can be found in the City of Blaine, Minnesota’s Corrective Action Plan.
Reporting – SEFA Preparation Information of the federal program: Federal Grantor: U.S. Department of Health and Human Services Federal Cluster: None Assistance Listing No.: 93.918, Grants to Provide Outpatient Early Intervention Services with Respect to HIV Disease (Ryan White, Part C) Federal Award Numbers: H76HA31655, H76HA25775, H76HA00617, and P06HA9851 Federal Award Period: April 1, 2022 through March 31, 2025; May 1, 2022 through April 30, 2025; May 1, 2022 through April 30, 2025; and September 1, 2023 through August 31, 2024 Criteria or specific requirement (including statutory, regulatory or other citation): The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (the SEFA) 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.” Condition: Ryan White, Part C requires the use of program income under the additive method, which requires program income earned from a federally funded program is added to the federal award amount and used to further program objectives. Under the method, allowable expenditures of program income are included on the SEFA. UPMC’s SEFA did not include expenditures related to program income, which were allowable. Cause: UPMC’s SEFA included grant funds expended under the Ryan White, Part C program but did not include program income funds expended under the Ryan White, Part C program for the year ended December 31, 2023. Effect or potential effect: The expenditures in the SEFA for the Ryan White, Part C a program for the year ended December 31, 2023, were understated which resulted in the improper identification of major federal programs and, therefore, required the restatement of the previously issued Uniform Guidance report to include Ryan White, Part C as a major federal program. Questioned costs: None. Context: Expenditures for Ryan White, Part C were understated by $5,528,826 (as compared to total restated expenditures for Ryan White, Part C of $7,149,887), which resulted in Ryan White, Part C being identified as major federal program upon inclusion of the allowable expenditures from program income. Identification as a repeat finding, if applicable: This finding is not a repeat finding. Recommendation: UPMC should evaluate its internal controls over the SEFA process to ensure that reported federal expenditures include both grant expenditures and applicable program income expenditures, when required, to support the accurate reporting of federal expenditures. Views of responsible officials: Management concurs with this finding.
FINDING 2023-007 Subject: Scope Limitation Compliance Requirements: Schedule of Expenditures of Federal Awards Reporting, Major Program Determination, Auditor's Report on Compliance and Internal Control over Compliance Audit Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 20 TOWN OF WEST TERRE HAUTE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The Schedule of Expenditures of Federal Awards (SEFA) is required to be fairly stated in relation to the audited financial statements. However, as disclosed in the Independent Auditor's Report in the Financial Statement Audit Report of the Town, sufficient appropriate audit evidence could not be obtained to support the Town's financial statements, resulting in a disclaimer of opinion. Because the SEFA must be audited "in-relation-to" the financial statements, we were likewise unable to obtain sufficient appropriate evidence to determine whether the SEFA was fairly stated as outlined in Finding 2023-002. Due to the inability to audit the SEFA, we could not determine the Town's major federal programs in accordance with the risk-based major program selection requirements of 2 CFR 200.518. Consequently, major programs could not be identified, and thus we did not perform any compliance audit procedures under the Uniform Guidance. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control . . ." 2 CFR 200.1 states in part: ". . . Internal controls for non-Federal entities means: (1) Processes designed and implemented by non-Federal entities to provide reasonable assurance regarding the achievement of objectives in the following categories: (i) Effectiveness and efficiency of operations; (ii) Reliability of reporting for internal and external use; and . . ." 2 CFR 200.508 states in part: "The auditee must: . . . (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with § 200.510. . . ." 2 CFR 200.510(b) states: "Schedule of expenditures of Federal awards. 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 § 200.502. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: INDIANA STATE BOARD OF ACCOUNTS 21 TOWN OF WEST TERRE HAUTE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. (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 Assistance Listings Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in § 200.414." 2 CFR 200.515(c) states in part: "A report on compliance for each major program and a report on internal control over compliance. This report must describe the scope of testing of internal control over compliance, include an opinion or disclaimer of opinion as to whether the auditee complied with Federal statutes, regulations, and the terms and conditions of Federal awards which could have a direct and material effect on each major program and refer to the separate schedule of findings and questioned costs. . . ." 2 CFR 200.518(a) states: "The auditor must use a risk-based approach to determine which Federal programs are major programs. This risk-based approach must include consideration of: current and prior audit experience, oversight by Federal agencies and pass-through entities, and the inherent risk of the Federal program. The process in paragraphs (b) through (h) of this section must be followed." 2 CFR 200.516(a)(5) states in part: "The circumstances concerning why the auditor's report on compliance for each major program is other than an unmodified opinion. . . ." Cause The disclaimer of opinion on the financial statement did not allow for sufficient appropriate audit evidence to be obtained for the support of the amounts and disclosures in the Town's financial statement. This lack of evidentiary support prevented the performance of required in-relation-to procedures on the SEFA. INDIANA STATE BOARD OF ACCOUNTS 22 TOWN OF WEST TERRE HAUTE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Because the SEFA is unauditable, major programs could not be determined. Without major program identification, required compliance testing could not be performed. Accordingly, the auditor issued a disclaimer of opinion on compliance for federal awards. Questioned Costs Not applicable. No compliance testing was performed due to the scope limitation. Recommendation The Town should strengthen internal controls over financial reporting and federal award reporting to ensure all information included in the financial statement and the SEFA is complete, accurate, and supported by sufficient appropriate audit evidence. Only with auditable financial statement and an auditable SEFA can major program determination and required compliance testing be performed. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. INDIANA STATE BOARD OF ACCOUNTS 23
2023-004 SEFA REPORTING Federal Program Information: Federal Agency and Program Name Federal Assistance Listing Number National Endowment for the Humanities Promotion of the Humanities Federal/State Partnership Grant Number: SO-289836-23 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 2023 SEFA for the Promotion of the Humanities Federal/State Partnership program included expenditures from other fiscal years. Questioned Costs: $4,015 Context: Total federal expenditures for the Promotion of the Humanities Federal/State Partnership program were $1,019,055 for the year ended October 31, 2023. 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: This is not a repeat finding from the prior year. 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.
2023-004 SEFA REPORTING Federal Program Information: Federal Agency and Program Name Federal Assistance Listing Number National Endowment for the Humanities Promotion of the Humanities Federal/State Partnership Grant Number: SO-289836-23 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 2023 SEFA for the Promotion of the Humanities Federal/State Partnership program included expenditures from other fiscal years. Questioned Costs: $4,015 Context: Total federal expenditures for the Promotion of the Humanities Federal/State Partnership program were $1,019,055 for the year ended October 31, 2023. 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: This is not a repeat finding from the prior year. 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.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year 20.507, fiscal year 2023 Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b): 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 determined in accordance with §200.502. Condition The schedule of expenditures of federal awards (SEFA) was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2023, the Authority expended approximately $21.7 million of federal funding. The Authority accumulates the financial data and other required information to complete the SEFA. Due to lack of control on reviewing drawdowns after year end to ensure they are reported properly, an adjustment was identified by the auditors related to ALN 20.507 for approximately $1,500,000 that was improperly excluded from the original SEFA provided by the Authority to the auditors. Cause and Effect Controls in place to ensure the SEFA was complete and accurate were not effective. The error in the SEFA has been corrected. Recommendation The Authority should implement a process to ensure the SEFA is complete and accurate by thoroughly reviewing agreements for grants received and reconciling the SEFA to a final trial balance prior to the start of the audit. The Authority should also ensure completeness by reviewing drawdowns after year end to ensure that they are reported in the correct period on the SEFA. Views of Responsible Officials and Planned Corrective Actions Management would like to point out that this finding is related to Finding 2023 001. The accrual of additional grant invoices resulted in parallel updates to our SEFA schedule. Therefore, this finding is a direct result of Finding 2023 001. As an aside, our current process for SEFA reporting is manual. We are investing in a new accounting system, in which the SEFA information will not require manual intervention and, thus, will reduce any potential entry errors in the future.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year 20.507, fiscal year 2023 Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b): 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 determined in accordance with §200.502. Condition The schedule of expenditures of federal awards (SEFA) was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2023, the Authority expended approximately $21.7 million of federal funding. The Authority accumulates the financial data and other required information to complete the SEFA. Due to lack of control on reviewing drawdowns after year end to ensure they are reported properly, an adjustment was identified by the auditors related to ALN 20.507 for approximately $1,500,000 that was improperly excluded from the original SEFA provided by the Authority to the auditors. Cause and Effect Controls in place to ensure the SEFA was complete and accurate were not effective. The error in the SEFA has been corrected. Recommendation The Authority should implement a process to ensure the SEFA is complete and accurate by thoroughly reviewing agreements for grants received and reconciling the SEFA to a final trial balance prior to the start of the audit. The Authority should also ensure completeness by reviewing drawdowns after year end to ensure that they are reported in the correct period on the SEFA. Views of Responsible Officials and Planned Corrective Actions Management would like to point out that this finding is related to Finding 2023 001. The accrual of additional grant invoices resulted in parallel updates to our SEFA schedule. Therefore, this finding is a direct result of Finding 2023 001. As an aside, our current process for SEFA reporting is manual. We are investing in a new accounting system, in which the SEFA information will not require manual intervention and, thus, will reduce any potential entry errors in the future.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year 20.507, fiscal year 2023 Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b): 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 determined in accordance with §200.502. Condition The schedule of expenditures of federal awards (SEFA) was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2023, the Authority expended approximately $21.7 million of federal funding. The Authority accumulates the financial data and other required information to complete the SEFA. Due to lack of control on reviewing drawdowns after year end to ensure they are reported properly, an adjustment was identified by the auditors related to ALN 20.507 for approximately $1,500,000 that was improperly excluded from the original SEFA provided by the Authority to the auditors. Cause and Effect Controls in place to ensure the SEFA was complete and accurate were not effective. The error in the SEFA has been corrected. Recommendation The Authority should implement a process to ensure the SEFA is complete and accurate by thoroughly reviewing agreements for grants received and reconciling the SEFA to a final trial balance prior to the start of the audit. The Authority should also ensure completeness by reviewing drawdowns after year end to ensure that they are reported in the correct period on the SEFA. Views of Responsible Officials and Planned Corrective Actions Management would like to point out that this finding is related to Finding 2023 001. The accrual of additional grant invoices resulted in parallel updates to our SEFA schedule. Therefore, this finding is a direct result of Finding 2023 001. As an aside, our current process for SEFA reporting is manual. We are investing in a new accounting system, in which the SEFA information will not require manual intervention and, thus, will reduce any potential entry errors in the future.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year 20.507, fiscal year 2023 Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b): 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 determined in accordance with §200.502. Condition The schedule of expenditures of federal awards (SEFA) was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2023, the Authority expended approximately $21.7 million of federal funding. The Authority accumulates the financial data and other required information to complete the SEFA. Due to lack of control on reviewing drawdowns after year end to ensure they are reported properly, an adjustment was identified by the auditors related to ALN 20.507 for approximately $1,500,000 that was improperly excluded from the original SEFA provided by the Authority to the auditors. Cause and Effect Controls in place to ensure the SEFA was complete and accurate were not effective. The error in the SEFA has been corrected. Recommendation The Authority should implement a process to ensure the SEFA is complete and accurate by thoroughly reviewing agreements for grants received and reconciling the SEFA to a final trial balance prior to the start of the audit. The Authority should also ensure completeness by reviewing drawdowns after year end to ensure that they are reported in the correct period on the SEFA. Views of Responsible Officials and Planned Corrective Actions Management would like to point out that this finding is related to Finding 2023 001. The accrual of additional grant invoices resulted in parallel updates to our SEFA schedule. Therefore, this finding is a direct result of Finding 2023 001. As an aside, our current process for SEFA reporting is manual. We are investing in a new accounting system, in which the SEFA information will not require manual intervention and, thus, will reduce any potential entry errors in the future.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year 20.507, fiscal year 2023 Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b): 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 determined in accordance with §200.502. Condition The schedule of expenditures of federal awards (SEFA) was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2023, the Authority expended approximately $21.7 million of federal funding. The Authority accumulates the financial data and other required information to complete the SEFA. Due to lack of control on reviewing drawdowns after year end to ensure they are reported properly, an adjustment was identified by the auditors related to ALN 20.507 for approximately $1,500,000 that was improperly excluded from the original SEFA provided by the Authority to the auditors. Cause and Effect Controls in place to ensure the SEFA was complete and accurate were not effective. The error in the SEFA has been corrected. Recommendation The Authority should implement a process to ensure the SEFA is complete and accurate by thoroughly reviewing agreements for grants received and reconciling the SEFA to a final trial balance prior to the start of the audit. The Authority should also ensure completeness by reviewing drawdowns after year end to ensure that they are reported in the correct period on the SEFA. Views of Responsible Officials and Planned Corrective Actions Management would like to point out that this finding is related to Finding 2023 001. The accrual of additional grant invoices resulted in parallel updates to our SEFA schedule. Therefore, this finding is a direct result of Finding 2023 001. As an aside, our current process for SEFA reporting is manual. We are investing in a new accounting system, in which the SEFA information will not require manual intervention and, thus, will reduce any potential entry errors in the future.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year 20.507, fiscal year 2023 Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b): 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 determined in accordance with §200.502. Condition The schedule of expenditures of federal awards (SEFA) was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2023, the Authority expended approximately $21.7 million of federal funding. The Authority accumulates the financial data and other required information to complete the SEFA. Due to lack of control on reviewing drawdowns after year end to ensure they are reported properly, an adjustment was identified by the auditors related to ALN 20.507 for approximately $1,500,000 that was improperly excluded from the original SEFA provided by the Authority to the auditors. Cause and Effect Controls in place to ensure the SEFA was complete and accurate were not effective. The error in the SEFA has been corrected. Recommendation The Authority should implement a process to ensure the SEFA is complete and accurate by thoroughly reviewing agreements for grants received and reconciling the SEFA to a final trial balance prior to the start of the audit. The Authority should also ensure completeness by reviewing drawdowns after year end to ensure that they are reported in the correct period on the SEFA. Views of Responsible Officials and Planned Corrective Actions Management would like to point out that this finding is related to Finding 2023 001. The accrual of additional grant invoices resulted in parallel updates to our SEFA schedule. Therefore, this finding is a direct result of Finding 2023 001. As an aside, our current process for SEFA reporting is manual. We are investing in a new accounting system, in which the SEFA information will not require manual intervention and, thus, will reduce any potential entry errors in the future.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year 20.507, fiscal year 2023 Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b): 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 determined in accordance with §200.502. Condition The schedule of expenditures of federal awards (SEFA) was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2023, the Authority expended approximately $21.7 million of federal funding. The Authority accumulates the financial data and other required information to complete the SEFA. Due to lack of control on reviewing drawdowns after year end to ensure they are reported properly, an adjustment was identified by the auditors related to ALN 20.507 for approximately $1,500,000 that was improperly excluded from the original SEFA provided by the Authority to the auditors. Cause and Effect Controls in place to ensure the SEFA was complete and accurate were not effective. The error in the SEFA has been corrected. Recommendation The Authority should implement a process to ensure the SEFA is complete and accurate by thoroughly reviewing agreements for grants received and reconciling the SEFA to a final trial balance prior to the start of the audit. The Authority should also ensure completeness by reviewing drawdowns after year end to ensure that they are reported in the correct period on the SEFA. Views of Responsible Officials and Planned Corrective Actions Management would like to point out that this finding is related to Finding 2023 001. The accrual of additional grant invoices resulted in parallel updates to our SEFA schedule. Therefore, this finding is a direct result of Finding 2023 001. As an aside, our current process for SEFA reporting is manual. We are investing in a new accounting system, in which the SEFA information will not require manual intervention and, thus, will reduce any potential entry errors in the future.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year 20.507, fiscal year 2023 Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b): 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 determined in accordance with §200.502. Condition The schedule of expenditures of federal awards (SEFA) was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2023, the Authority expended approximately $21.7 million of federal funding. The Authority accumulates the financial data and other required information to complete the SEFA. Due to lack of control on reviewing drawdowns after year end to ensure they are reported properly, an adjustment was identified by the auditors related to ALN 20.507 for approximately $1,500,000 that was improperly excluded from the original SEFA provided by the Authority to the auditors. Cause and Effect Controls in place to ensure the SEFA was complete and accurate were not effective. The error in the SEFA has been corrected. Recommendation The Authority should implement a process to ensure the SEFA is complete and accurate by thoroughly reviewing agreements for grants received and reconciling the SEFA to a final trial balance prior to the start of the audit. The Authority should also ensure completeness by reviewing drawdowns after year end to ensure that they are reported in the correct period on the SEFA. Views of Responsible Officials and Planned Corrective Actions Management would like to point out that this finding is related to Finding 2023 001. The accrual of additional grant invoices resulted in parallel updates to our SEFA schedule. Therefore, this finding is a direct result of Finding 2023 001. As an aside, our current process for SEFA reporting is manual. We are investing in a new accounting system, in which the SEFA information will not require manual intervention and, thus, will reduce any potential entry errors in the future.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year 20.507, fiscal year 2023 Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b): 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 determined in accordance with §200.502. Condition The schedule of expenditures of federal awards (SEFA) was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2023, the Authority expended approximately $21.7 million of federal funding. The Authority accumulates the financial data and other required information to complete the SEFA. Due to lack of control on reviewing drawdowns after year end to ensure they are reported properly, an adjustment was identified by the auditors related to ALN 20.507 for approximately $1,500,000 that was improperly excluded from the original SEFA provided by the Authority to the auditors. Cause and Effect Controls in place to ensure the SEFA was complete and accurate were not effective. The error in the SEFA has been corrected. Recommendation The Authority should implement a process to ensure the SEFA is complete and accurate by thoroughly reviewing agreements for grants received and reconciling the SEFA to a final trial balance prior to the start of the audit. The Authority should also ensure completeness by reviewing drawdowns after year end to ensure that they are reported in the correct period on the SEFA. Views of Responsible Officials and Planned Corrective Actions Management would like to point out that this finding is related to Finding 2023 001. The accrual of additional grant invoices resulted in parallel updates to our SEFA schedule. Therefore, this finding is a direct result of Finding 2023 001. As an aside, our current process for SEFA reporting is manual. We are investing in a new accounting system, in which the SEFA information will not require manual intervention and, thus, will reduce any potential entry errors in the future.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year 20.507, fiscal year 2023 Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b): 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 determined in accordance with §200.502. Condition The schedule of expenditures of federal awards (SEFA) was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2023, the Authority expended approximately $21.7 million of federal funding. The Authority accumulates the financial data and other required information to complete the SEFA. Due to lack of control on reviewing drawdowns after year end to ensure they are reported properly, an adjustment was identified by the auditors related to ALN 20.507 for approximately $1,500,000 that was improperly excluded from the original SEFA provided by the Authority to the auditors. Cause and Effect Controls in place to ensure the SEFA was complete and accurate were not effective. The error in the SEFA has been corrected. Recommendation The Authority should implement a process to ensure the SEFA is complete and accurate by thoroughly reviewing agreements for grants received and reconciling the SEFA to a final trial balance prior to the start of the audit. The Authority should also ensure completeness by reviewing drawdowns after year end to ensure that they are reported in the correct period on the SEFA. Views of Responsible Officials and Planned Corrective Actions Management would like to point out that this finding is related to Finding 2023 001. The accrual of additional grant invoices resulted in parallel updates to our SEFA schedule. Therefore, this finding is a direct result of Finding 2023 001. As an aside, our current process for SEFA reporting is manual. We are investing in a new accounting system, in which the SEFA information will not require manual intervention and, thus, will reduce any potential entry errors in the future.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year 20.507, fiscal year 2023 Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b): 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 determined in accordance with §200.502. Condition The schedule of expenditures of federal awards (SEFA) was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2023, the Authority expended approximately $21.7 million of federal funding. The Authority accumulates the financial data and other required information to complete the SEFA. Due to lack of control on reviewing drawdowns after year end to ensure they are reported properly, an adjustment was identified by the auditors related to ALN 20.507 for approximately $1,500,000 that was improperly excluded from the original SEFA provided by the Authority to the auditors. Cause and Effect Controls in place to ensure the SEFA was complete and accurate were not effective. The error in the SEFA has been corrected. Recommendation The Authority should implement a process to ensure the SEFA is complete and accurate by thoroughly reviewing agreements for grants received and reconciling the SEFA to a final trial balance prior to the start of the audit. The Authority should also ensure completeness by reviewing drawdowns after year end to ensure that they are reported in the correct period on the SEFA. Views of Responsible Officials and Planned Corrective Actions Management would like to point out that this finding is related to Finding 2023 001. The accrual of additional grant invoices resulted in parallel updates to our SEFA schedule. Therefore, this finding is a direct result of Finding 2023 001. As an aside, our current process for SEFA reporting is manual. We are investing in a new accounting system, in which the SEFA information will not require manual intervention and, thus, will reduce any potential entry errors in the future.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year 20.507, fiscal year 2023 Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.510(b): 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 determined in accordance with §200.502. Condition The schedule of expenditures of federal awards (SEFA) was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context In fiscal year 2023, the Authority expended approximately $21.7 million of federal funding. The Authority accumulates the financial data and other required information to complete the SEFA. Due to lack of control on reviewing drawdowns after year end to ensure they are reported properly, an adjustment was identified by the auditors related to ALN 20.507 for approximately $1,500,000 that was improperly excluded from the original SEFA provided by the Authority to the auditors. Cause and Effect Controls in place to ensure the SEFA was complete and accurate were not effective. The error in the SEFA has been corrected. Recommendation The Authority should implement a process to ensure the SEFA is complete and accurate by thoroughly reviewing agreements for grants received and reconciling the SEFA to a final trial balance prior to the start of the audit. The Authority should also ensure completeness by reviewing drawdowns after year end to ensure that they are reported in the correct period on the SEFA. Views of Responsible Officials and Planned Corrective Actions Management would like to point out that this finding is related to Finding 2023 001. The accrual of additional grant invoices resulted in parallel updates to our SEFA schedule. Therefore, this finding is a direct result of Finding 2023 001. As an aside, our current process for SEFA reporting is manual. We are investing in a new accounting system, in which the SEFA information will not require manual intervention and, thus, will reduce any potential entry errors in the future.
2023-002 - Internal Controls Over Compliance and Compliance with Reporting - Preparation of the Schedule of Expenditures of Federal Awards Information on the Major Federal Program - Federal Agency: Department of Interior Program Name: National Park Service Second Century Endowment Assistance Listing Number: 15.U01 Award Number: H.R. 4680/P.L. 114-289 Award Period: October 1, 2022 to September 30, 2023 Criteria - The Uniform Guidance in 2 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 2 CFR Section 200.502 Basis for determining Federal awards expended.” The Schedule must provide total Federal awards expended for each individual Federal program. Condition – During the testing of the schedule of expenditures of federal awards (SEFA) for the National Park Service Second Century Endowment for the year-end September 30, 2023, we identified transactions totaling $1,848,493 which were improperly included in the SEFA. These expenditures were not incurred during the fiscal year and should not have been included in the SEFA. Cause - The internal controls established for the review and reconciliation of the SEFA to the underlying accounting records were not consistently followed to ensure accurate reporting of expenditures to the SEFA. Effect or Potential Effect - Failure to properly review and support expenditures reported in the SEFA can result in inaccurate reporting and non-compliance with laws and regulations. Questioned Costs - None. Context - We reviewed the SEFA and found the exception as noted in the condition. Repeat Finding - This is not a repeat finding. Recommendation - Internal controls should be designed to prevent, detect and correct errors and/or omissions in a timely manner. Without adequate controls, the Foundation cannot provide reasonable assurance that the SEFA is fairly presented. See management’s response for further details. Views of Responsible Officials - Management agrees with this finding and recommendation. The Foundation’s management agrees with the finding and recommendation. The planned corrective actions are presented in the Foundation’s management’s corrective action plan attached as Appendix C.
2023-002 – Internal Control over Compliance and Compliance with Period of Performance Information on the Major Federal Program - Federal Agency: United States Agency for International Development (USAID) Program Name: USAID Foreign Assistance for Program Overseas Assistance Listing Number: 98.001 Award Number: Various Award Period: Various Criteria – A non-Federal entity may charge to the Federal award only allowable costs incurred during the period of performance and any costs incurred before the Federal awarding agency or pass-through entity made the Federal award, only to the extent that they would have been allowable if incurred after the date of the Federal award and only with the written approval of the Federal awarding agency. Additionally, the Uniform Guidance in 2 CFR Section 200.344(b), states that unless the federal awarding agency or pass-through entity authorized an extension, a non-Federal entity must liquidate all financial obligations incurred under the Federal award not later than 120 calendar days after the end date of the period of performance as specified in the terms and conditions of the Federal award. Further, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires the non-federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonable ensure compliance with Federal statutes, regulations, and other terms and conditions of the Federal Award. The Uniform Guidance in 2 CFR Section 200.510 (b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Section 200.502 Basis for determining Federal awards expended.” The SEFA must provide total Federal awards expended for each individual Federal program. Condition – During our testing, we identified one (1) out of 40 sampled transactions was incurred outside the period of performance. Corus did not obtain written approval from the federal awarding agency for the specific project. As a result, total expenditure totaling $106,400 was improperly included in the SEFA. Cause - The internal controls established for the review and reconciliation of the SEFA to the underlying accounting records were not consistently followed to ensure accurate charging of expenditures to the SEFA in the correct period. Questioned Costs - None. Context – This is a condition identified per review of Corus’ compliance with the specified requirements. Total expenditures of the specific project charged to the program was $106,400. These charges were removed from the SEFA presented for the year ended September 30, 2023. Effect - Failure to properly review and support expenditures reported in the SEFA can result in inaccurate reporting and non-compliance with laws and regulations. Repeat Finding - This is not a repeat finding. Recommendation - Internal controls should be designed to prevent, detect and correct errors and/or omissions in a timely manner. Without adequate controls, Corus cannot provide reasonable assurance that the SEFA is fairly presented. We recommend management to strengthen its internal control to ensure complete and accurate SEFA. Views of Responsible Officials - Corus management agrees with the findings and recommendations. The planned corrective actions are presented in Corus management’s corrective action plan attached as Appendix B to the Single Audit Report.
2023-002 – Internal Control over Compliance and Compliance with Period of Performance Information on the Major Federal Program - Federal Agency: United States Agency for International Development (USAID) Program Name: USAID Foreign Assistance for Program Overseas Assistance Listing Number: 98.001 Award Number: Various Award Period: Various Criteria – A non-Federal entity may charge to the Federal award only allowable costs incurred during the period of performance and any costs incurred before the Federal awarding agency or pass-through entity made the Federal award, only to the extent that they would have been allowable if incurred after the date of the Federal award and only with the written approval of the Federal awarding agency. Additionally, the Uniform Guidance in 2 CFR Section 200.344(b), states that unless the federal awarding agency or pass-through entity authorized an extension, a non-Federal entity must liquidate all financial obligations incurred under the Federal award not later than 120 calendar days after the end date of the period of performance as specified in the terms and conditions of the Federal award. Further, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires the non-federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonable ensure compliance with Federal statutes, regulations, and other terms and conditions of the Federal Award. The Uniform Guidance in 2 CFR Section 200.510 (b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Section 200.502 Basis for determining Federal awards expended.” The SEFA must provide total Federal awards expended for each individual Federal program. Condition – During our testing, we identified one (1) out of 40 sampled transactions was incurred outside the period of performance. Corus did not obtain written approval from the federal awarding agency for the specific project. As a result, total expenditure totaling $106,400 was improperly included in the SEFA. Cause - The internal controls established for the review and reconciliation of the SEFA to the underlying accounting records were not consistently followed to ensure accurate charging of expenditures to the SEFA in the correct period. Questioned Costs - None. Context – This is a condition identified per review of Corus’ compliance with the specified requirements. Total expenditures of the specific project charged to the program was $106,400. These charges were removed from the SEFA presented for the year ended September 30, 2023. Effect - Failure to properly review and support expenditures reported in the SEFA can result in inaccurate reporting and non-compliance with laws and regulations. Repeat Finding - This is not a repeat finding. Recommendation - Internal controls should be designed to prevent, detect and correct errors and/or omissions in a timely manner. Without adequate controls, Corus cannot provide reasonable assurance that the SEFA is fairly presented. We recommend management to strengthen its internal control to ensure complete and accurate SEFA. Views of Responsible Officials - Corus management agrees with the findings and recommendations. The planned corrective actions are presented in Corus management’s corrective action plan attached as Appendix B to the Single Audit Report.
2023-002 – Internal Control over Compliance and Compliance with Period of Performance Information on the Major Federal Program - Federal Agency: United States Agency for International Development (USAID) Program Name: USAID Foreign Assistance for Program Overseas Assistance Listing Number: 98.001 Award Number: Various Award Period: Various Criteria – A non-Federal entity may charge to the Federal award only allowable costs incurred during the period of performance and any costs incurred before the Federal awarding agency or pass-through entity made the Federal award, only to the extent that they would have been allowable if incurred after the date of the Federal award and only with the written approval of the Federal awarding agency. Additionally, the Uniform Guidance in 2 CFR Section 200.344(b), states that unless the federal awarding agency or pass-through entity authorized an extension, a non-Federal entity must liquidate all financial obligations incurred under the Federal award not later than 120 calendar days after the end date of the period of performance as specified in the terms and conditions of the Federal award. Further, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires the non-federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonable ensure compliance with Federal statutes, regulations, and other terms and conditions of the Federal Award. The Uniform Guidance in 2 CFR Section 200.510 (b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Section 200.502 Basis for determining Federal awards expended.” The SEFA must provide total Federal awards expended for each individual Federal program. Condition – During our testing, we identified one (1) out of 40 sampled transactions was incurred outside the period of performance. Corus did not obtain written approval from the federal awarding agency for the specific project. As a result, total expenditure totaling $106,400 was improperly included in the SEFA. Cause - The internal controls established for the review and reconciliation of the SEFA to the underlying accounting records were not consistently followed to ensure accurate charging of expenditures to the SEFA in the correct period. Questioned Costs - None. Context – This is a condition identified per review of Corus’ compliance with the specified requirements. Total expenditures of the specific project charged to the program was $106,400. These charges were removed from the SEFA presented for the year ended September 30, 2023. Effect - Failure to properly review and support expenditures reported in the SEFA can result in inaccurate reporting and non-compliance with laws and regulations. Repeat Finding - This is not a repeat finding. Recommendation - Internal controls should be designed to prevent, detect and correct errors and/or omissions in a timely manner. Without adequate controls, Corus cannot provide reasonable assurance that the SEFA is fairly presented. We recommend management to strengthen its internal control to ensure complete and accurate SEFA. Views of Responsible Officials - Corus management agrees with the findings and recommendations. The planned corrective actions are presented in Corus management’s corrective action plan attached as Appendix B to the Single Audit Report.
2023-002 – Internal Control over Compliance and Compliance with Period of Performance Information on the Major Federal Program - Federal Agency: United States Agency for International Development (USAID) Program Name: USAID Foreign Assistance for Program Overseas Assistance Listing Number: 98.001 Award Number: Various Award Period: Various Criteria – A non-Federal entity may charge to the Federal award only allowable costs incurred during the period of performance and any costs incurred before the Federal awarding agency or pass-through entity made the Federal award, only to the extent that they would have been allowable if incurred after the date of the Federal award and only with the written approval of the Federal awarding agency. Additionally, the Uniform Guidance in 2 CFR Section 200.344(b), states that unless the federal awarding agency or pass-through entity authorized an extension, a non-Federal entity must liquidate all financial obligations incurred under the Federal award not later than 120 calendar days after the end date of the period of performance as specified in the terms and conditions of the Federal award. Further, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires the non-federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonable ensure compliance with Federal statutes, regulations, and other terms and conditions of the Federal Award. The Uniform Guidance in 2 CFR Section 200.510 (b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Section 200.502 Basis for determining Federal awards expended.” The SEFA must provide total Federal awards expended for each individual Federal program. Condition – During our testing, we identified one (1) out of 40 sampled transactions was incurred outside the period of performance. Corus did not obtain written approval from the federal awarding agency for the specific project. As a result, total expenditure totaling $106,400 was improperly included in the SEFA. Cause - The internal controls established for the review and reconciliation of the SEFA to the underlying accounting records were not consistently followed to ensure accurate charging of expenditures to the SEFA in the correct period. Questioned Costs - None. Context – This is a condition identified per review of Corus’ compliance with the specified requirements. Total expenditures of the specific project charged to the program was $106,400. These charges were removed from the SEFA presented for the year ended September 30, 2023. Effect - Failure to properly review and support expenditures reported in the SEFA can result in inaccurate reporting and non-compliance with laws and regulations. Repeat Finding - This is not a repeat finding. Recommendation - Internal controls should be designed to prevent, detect and correct errors and/or omissions in a timely manner. Without adequate controls, Corus cannot provide reasonable assurance that the SEFA is fairly presented. We recommend management to strengthen its internal control to ensure complete and accurate SEFA. Views of Responsible Officials - Corus management agrees with the findings and recommendations. The planned corrective actions are presented in Corus management’s corrective action plan attached as Appendix B to the Single Audit Report.