Finding 1054603 (2023-002)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-07-10

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) was incomplete and inaccurate, missing the Specialty Crop Block Grant and containing discrepancies in reported amounts for other grants.
  • Impacted Requirements: Noncompliance with CFR §200.510(b) and §200.302(b)(1) due to failure to accurately report all federal awards and their expenditures.
  • Recommended Follow-up: Develop clear procedures for SEFA preparation, enhance internal controls, and ensure staff review the SEFA for accuracy before submission to auditors.

Finding Text

Internal Control over Compliance and Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards (SEFA)) ALN: 10.170, Specialty Crop Block Grant ALN: 15.228, National Fire Plan ALN 10.767: Intermediary Relending Program (IRP) ALN 66.818: Brownfields RLF ALN 11.307: Economic Development Assistance RLF Criteria: The Code of Federal Regulations (CFR) Section §200.510(b) states in part: "The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended." The schedule must provide total Federal awards expended for each individual Federal program. CFR 200.302(b)(1) requires that the nonfederal entity must identify in its accounts and on the schedule of expenditures of federal awards all federal awards received and expended, as well as the federal programs under which they were received. Federal program and award identification must include, as applicable, the Assistance Listing program title and number, the federal award identification number and year, the name of the federal agency, and the name of the pass-through entity, if any. Condition: The Specialty Crop Block Grant was left off of the prepared SEFA. Amounts reported for the National Fire Plan grant, IRP, and Brownfields RLF did not agree to the accounting records. The amount reported for the Economic Development Assistance RLF was not calculated in accordance with the compliance supplement calculation formula. Context: There SEFA was understated or overstated by ALN as follows: • Understated by $14,123 for the omission of the Specialty Crop Block Grant; • Overstated by $1,942 for National Fire Plan grant; • Understated by $10,748 for IRP; • Understated by $25,902 for Brownfields RLF; and • Overstated by $101,804 for Economic Development Assistance RLF. The net effect was an overstatement of $52,973. Effect: The SEFA provided was not complete and fully accurate. Questioned Costs: None. Cause: The internal controls for the preparation of the SEFA and review of the SEFA were not present to ensure the SEFA was complete and accurate. Auditor Recommendation: We recommend the Organization prepare procedures on how to put together the SEFA and strengthen internal controls to ensure all federal awards are included on the SEFA. We also recommend that staff who administer federal funds review the SEFA for completeness and accuracy before providing it to the auditor. Organization Response: The organization disagrees with the reported deficiency related to the SEFA preparation on the basis that the task was an agreed nonattest service contracted to Douglas Wilson & Company, P.C. The noted modifications are outcomes of these services and are not indicative of control deficiencies. With respect to the nonattest services, the Organization has fulfilled the responsibilities stated in the engagement letter to assume all management responsibilities for the services; to have those services overseen by an individual with appropriate skills, knowledge, and experience; evaluate the adequacy of the services; and to accept responsibility for them. Since its inception, the organization’s auditors have prepared the SEFA under the same engagement letters executed with the auditor. The organization’s outsourced accounting firm, JCCS, also provides these nonattest services for their auditees and were operating under the same understanding of this service arrangement. Management reports that this finding is a result of a misunderstanding between Management, JCCS, and Douglas Wilson & Company, P.C. regarding which party would complete the SEFA. Based on the signed engagement letter, Management understood that completing the SEFA was part of the auditors’ nonattest services. Their outsourced accounting firm, JCCS, provided a draft SEFA to the auditors with communication that it was a draft and would need to be finalized. JCCS worked directly with the auditor in making the necessary changes and finalizing the SEFA. Management nor JCCS were aware that the auditor would be identifying this collaboration as a material weakness. Management strongly disagrees that this finding has anything to do with a deficiency in internal controls as they understood they had engaged the auditor to provide this nonattest service. Management reports a discussion with the auditor that such a misunderstanding presented as an internal control deficiency carries significant consequences for the organization's future Federal awards. It is important that the organization's Federal grantors understand the full context of this finding.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 478161 2023-002
    Material Weakness
  • 478162 2023-003
    Significant Deficiency
  • 1054604 2023-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $990,592
10.767 Intermediary Relending Program $640,803
11.307 Economic Adjustment Assistance $214,525
12.002 Procurement Technical Assistance for Business Firms $108,968
11.302 Economic Development_support for Planning Organizations $70,000
15.228 Blm Fuels Management and Community Fire Assistance Program Activities $23,303
10.170 Specialty Crop Block Grant Program - Farm Bill $14,123