Finding 600658 (2022-002)

Significant Deficiency
Requirement
L
Questioned Costs
$1
Year
2022
Accepted
2023-03-30
Audit: 20813
Organization: Community Resource Center (CA)
Auditor: Ysr CPA Group PC

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) was missing approximately $28,000 in expenditures for the Crime Victim Assistance program, affecting compliance with federal reporting requirements.
  • Impacted Requirements: Internal controls were inadequate, leading to incorrect compilation of federal expenditures, which are essential for determining major Type A and Type B programs.
  • Recommended Follow-Up: Improve SEFA compilation processes and internal controls to ensure all expenditures are accurately reported, including a review of new contracts and a final reconciliation of federal versus actual expenditures.

Finding Text

Reference Number: 2022-002 Prior Year Finding: N/A Federal Agency: U.S. Department of Justice State Agency: California Governor's Office of Emergency Services Federal Program: Crime Victim Assistance - COVID 19 Assistance Listing Number: 16.575 Award Number and Year: N/A Compliance Requirement: Reporting: Schedule of Expenditures of Federal Awards Type of Finding Deficiency Criteria or specific requirement: Questioned Costs: Undetermined COMMUNITY RESOURCE CENTER SCHEDULE OF FINDINGS AND QUESTIONED COSTS June 30, 2022 Control: Per 2 CFR section 200.303(a), a nonfederal entity must: Establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal 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 comply with the guidance in "Standards for Internal Control in the Federal Government" issued by the Comptroller General of the United States or the "Internal Control-Integrated Framework," issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Compliance: Per 2 CFR 200 Section 510(b), the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee?s financial statements which must include the total federal awards expended as determined in accordance with Section 200.502. The schedule must list individual federal programs by federal agency and 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. Condition: The Schedule of Expenditures of Federal Awards (SEFA) submitted to auditors for test work was missing expenditures for a program which was later determined to be part of major Type A program. Context: When reconciling the SEFA submitted to auditors during test work, it was discovered that approximately $28,000 in expenditures for assistance listing 16.575-Crime Victim Assistance - COVID had been omitted. After the error was detected, this program was determined to be part of major Type A program. Cause: Procedures and internal controls were not sufficient to ensure that expenditures were properly reported on the SEFA. Effect: Federal expenditures were incorrectly compiled and not reported on the SEFA which was used to determine Type A and Type B programs for the FY 2022 Single Audit. Recommendation: We recommend that Accounting and Grant Management improve its SEFA compilation process to ensure that program expenditures reported on the SEFA are complete and accurate. Procedures and controls should include a process to identify contracts that are new and ensure they are included on the SEFA. 38 Section III ? Findings and Questioned Costs ? Major Federal Programs COMMUNITY RESOURCE CENTER SCHEDULE OF FINDINGS AND QUESTIONED COSTS June 30, 2022 Views of Responsible Officials: The Organization acknowledges and accepts this finding. The Organization regards this finding as an isolated incident specific to COVID-19 contracts that were erroneously not designated as government contracts. The Organization has implemented a full review of the contracts at year end to make sure all expenses are assigned to a funder code in the accounting system. In additional, as a final control procedure, Accounting will run a final report for all contracts that have been identified as federal vs actual invoiced expenditures and further compared to what has been expensed per the financial statements and provide to the Chief Program Officer to compare and reconcile to the SEFA. 39

Categories

Questioned Costs Reporting

Other Findings in this Audit

  • 24215 2022-001
    Significant Deficiency
  • 24216 2022-002
    Significant Deficiency
  • 600657 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.267 Continuum of Care Program $248,331
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $65,000
14.218 Community Development Block Grants/entitlement Grants $58,522
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $38,114
16.575 Crime Victim Assistance $27,998