Finding 477890 (2022-001)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2024-07-08

AI Summary

  • Core Issue: There was a material weakness in internal controls, leading to misclassification of $70,000 in contributions.
  • Impacted Requirements: Management must ensure compliance with GAAP in accounting records, particularly regarding donor restrictions.
  • Recommended Follow-Up: Implement a review process for all grant agreements to accurately record donor-restricted contributions.

Finding Text

Material weakness in internal control over financial reporting: Material audit adjustment Criteria: Management is responsible for maintaining its accounting records in accordance with generally accepted accounting principles (GAAP). Condition: Two contributions with donor restrictions were recorded as without donor restriction. Context: Identified by the auditor during testing of revenue in the financial statement audit. Cause: Internal controls did not identify all contributions which included donor restrictions. Effect or Potential Effect: As a result of this condition, $70,000 was reclassified from revenue and net assets without donor restrictions to revenue and net assets with donor restrictions. Recommendation: We recommend the Organization provide review for all grant agreements to ensure amounts restricted by the donor are recorded with donor restriction. Responsible Official’s Response: Agree. Corrective Action will be for the AIOA Controller to consult with and collaborate with the AIOA CFO on the determination of the revenue treatment of grants and contributions received from private foundations to ascertain the existence of conditions and/or donor imposed restrictions.

Corrective Action Plan

In 2022 two grant awards from private foundations were incorrectly classified as “without donor restrictions” in the accounting system. Our Financial Policies and Procedures specify in Part I, Section 6 that MIWSAC will recognize contributions based on any donor imposed purpose or time restrictions identified in the award notice or grant document. Further, our Financial Policies and Procedures specify in Part IV, Section 1 the following procedures be applied for all gifts, contributions and grants: 1. Finance Manager and AIOA Controller will review award documents, grant documents or other correspondence received from donor/funder to determine the type of donor restriction(s). 2. Finance Manager and Executive Director will establish any required tracking of donor restricted revenues and how/when restrictions will be satisfied and released. 3. The AIOA Controller will add new donor restricted revenues to the Net Assets workpaper and subtract donor restricted funds that have been released from restriction. 4. The Finance Manager or AIOA Controller will prepare a journal entry as part of the month-end procedures to reclass any new donor restricted revenue from Unrestricted Net Assets to Net Assets with Donor Restriction and to record satisfaction of restrictions by reclassing from Net Assets with Donor Restriction to Unrestricted Net Assets. In the case of the two grants identified by the auditors as mis-classified, the policies were followed but the conclusions reached were incorrect. In one case the error was a clear oversight of the AIOA Controller. In the second case, the language the donor used in the grant document for a general operations award was ambiguous and open to more than one interpretation. Our AIOA Controller determined the award to have no restrictions but in a discussion with auditors we have agreed the “2 year” language in the grant document, though not clearly defined, would necessitate placing a time restriction on 50% of the award. The corrections were made as part of the audit engagement by the AIOA Controller posting a reclassing entry to revenue and net assets with donor restrictions. This audit adjustment was reviewed and agreed upon by management. Further corrective action will be for the AIOA Controller to consult with and collaborate with the AIOA CFO on the determination of the revenue treatment of grants and contributions received from private foundations to ascertain the existence of conditions and/or donor imposed restrictions. This corrective action has been implemented as of 8/25/2023. Corrective Action contact/responsible party: Jerry Frick, Fractional CFO – All In One Accounting Jerry.frick@allinoneaccounting.com 651-347-4471 Corrective Action Contact: Nicole Matthews, Executive Director nmatthews@miwsac.org 651-646-4800

Categories

Material Weakness Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 477884 2022-002
    Significant Deficiency
  • 477885 2022-002
    Significant Deficiency
  • 477886 2022-002
    Significant Deficiency
  • 477887 2022-002
    Significant Deficiency
  • 477888 2022-002
    Significant Deficiency
  • 477889 2022-002
    Significant Deficiency
  • 477891 2022-001
    Material Weakness
  • 477892 2022-001
    Material Weakness
  • 477893 2022-001
    Material Weakness
  • 477894 2022-001
    Material Weakness
  • 477895 2022-001
    Material Weakness
  • 1054326 2022-002
    Significant Deficiency
  • 1054327 2022-002
    Significant Deficiency
  • 1054328 2022-002
    Significant Deficiency
  • 1054329 2022-002
    Significant Deficiency
  • 1054330 2022-002
    Significant Deficiency
  • 1054331 2022-002
    Significant Deficiency
  • 1054332 2022-001
    Material Weakness
  • 1054333 2022-001
    Material Weakness
  • 1054334 2022-001
    Material Weakness
  • 1054335 2022-001
    Material Weakness
  • 1054336 2022-001
    Material Weakness
  • 1054337 2022-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
16.557 Tribal Domestic Violence and Sexual Assault Coalitions Grant Program $186,839
16.841 Voca Tribal Victim Services Set-Aside Program $172,735
16.027 National Clearinghouse on Sexual Assault of American Indian and Alaska Native Women $106,716
16.575 Crime Victim Assistance $18,162
16.526 Ovw Technical Assistance Initiative $11,997
93.496 Family Violence Prevention and Services/culturally Specific Domestic Violence and Sexual Violence Services $1,047