Finding 980490 (2023-002)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-06-28
Audit: 310862
Organization: Sunrise County Economic Council (ME)
Auditor: One River CPAS

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) contained multiple errors, including mislabeling and missing information.
  • Impacted Requirements: Compliance with 2 CFR 200, which mandates accurate financial reporting for federal awards.
  • Recommended Follow-Up: Management should enhance training for staff on SEFA preparation and strengthen review processes, potentially hiring an accounting consultant for expertise.

Finding Text

f Expenditures of Federal Awards (Material Weakness – All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, £200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The NOAA Mission-Related Education Awards was mislabeled and the CFDA # was missing. • The Highway Planning and Construction CFDA # was incorrect. • The State and Local Fiscal Recovery Funds expenditures were overstated by $86,304. • The Highway Planning and Construction expenditures were overstated by $6,282. • The SEFA did not include the State Small Business Credit Initiative program of $310,000. • COVID-19 labels were missing from two programs. • Award term was not included for any agreements. Questioned Costs – None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Views of Responsible Officials and Planned Corrective Actions: We provided the NOAA Award label and CFDA# as soon as we were able to obtain it from the program manager. We corrected the CFDA# for the Highway Planning and Construction as soon as we were able to obtain them from the MEDOT. The contract documents did not include that information. We reported the revenue for the State and Local Recovery Funds in the award column. We now know to put the unspent revenue in deferred. We did not know the $310,000 was Federal Funds, we will know for the future. We will be sure to include Covid-19 labels and all the award dates in the future. We will for training to prepare a SEFA document, it will be on our professional development list in this year.

Categories

Reporting Material Weakness

Other Findings in this Audit

  • 404041 2023-002
    Material Weakness
  • 404042 2023-002
    Material Weakness
  • 404043 2023-002
    Material Weakness
  • 404044 2023-002
    Material Weakness
  • 404045 2023-002
    Material Weakness
  • 404046 2023-002
    Material Weakness
  • 404047 2023-002
    Material Weakness
  • 404048 2023-002
    Material Weakness
  • 404049 2023-002
    Material Weakness
  • 404050 2023-002
    Material Weakness
  • 404051 2023-002
    Material Weakness
  • 404052 2023-002
    Material Weakness
  • 404053 2023-002
    Material Weakness
  • 404054 2023-002
    Material Weakness
  • 404055 2023-002
    Material Weakness
  • 404056 2023-002
    Material Weakness
  • 404057 2023-002
    Material Weakness
  • 980483 2023-002
    Material Weakness
  • 980484 2023-002
    Material Weakness
  • 980485 2023-002
    Material Weakness
  • 980486 2023-002
    Material Weakness
  • 980487 2023-002
    Material Weakness
  • 980488 2023-002
    Material Weakness
  • 980489 2023-002
    Material Weakness
  • 980491 2023-002
    Material Weakness
  • 980492 2023-002
    Material Weakness
  • 980493 2023-002
    Material Weakness
  • 980494 2023-002
    Material Weakness
  • 980495 2023-002
    Material Weakness
  • 980496 2023-002
    Material Weakness
  • 980497 2023-002
    Material Weakness
  • 980498 2023-002
    Material Weakness
  • 980499 2023-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.558 Temporary Assistance for Needy Families $1.06M
21.031 State Small Business Credit Initiative Technical Assistance Grant Program $310,000
10.767 Intermediary Relending Program $199,139
21.027 Coronavirus State and Local Fiscal Recovery Funds $117,069
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $102,174
10.870 Rural Microentrepreneur Assistance Program $100,485
12.002 Procurement Technical Assistance for Business Firms $97,908
10.351 Rural Business Development Grant $97,293
90.601 Northern Border Regional Development $45,793
20.205 Highway Planning and Construction $25,126
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $11,676
11.008 Noaa Mission-Related Education Awards $8,287
32.011 Affordable Connectivity Outreach Grant Program $7,990
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $696