Finding 383845 (2023-001)

Material Weakness
Requirement
C
Questioned Costs
$1
Year
2023
Accepted
2024-03-22
Audit: 296866
Organization: Indigenous Peoples Task Force (MN)
Auditor: Mahoney

AI Summary

  • Overspending Issue: IPTF recorded $5,821 more revenue than eligible expenditures for the SAMSHA grant, violating grant terms.
  • Compliance Requirement: 2 CFR § 200.302(b) mandates written policies for tracking grant accounting and earning revenue on a reimbursement basis.
  • Next Steps: Management should review financials monthly for accuracy and discuss repayment of the $5,821 with the grantor.

Finding Text

2023-001: Overspent Grant Federal Departments: Department of Health and Human Services Assistance Listing #: 93.243 Compliance and Internal Controls Material Weakness Category of Finding – Cash Management Criteria – 2 CFR § 200.302(b), requires entities to have written policies and procedures to accurately track grant accounting. Per the grant agreement, the grant must be earned on a reimbursement basis, which requires eligible expenditures to be incurred in order to earn the grant revenue. Condition – During fiscal year 2023, IPTF recorded $5,821 more revenue on the SAMSHA grant than the related eligible expenditures. Cause – IPTF had turnover in the contract accounting function/position. Multiple adjustments were made in the accounting software by the former contract accounting prior to the transition, which were difficult to trace back to and ultimately, actual costs incurred under the grant were miscalculated and overstated. Effect – As a result of this condition, IPTF was noncompliant with the grant and recognized more revenue than allowed based on eligible costs. Questioned Costs – $5,821 Recommendation – We recommend that management ensure internal financials are reviewed on a monthly basis to ensure completeness and accuracy, which includes having grant specific financials reviewed by the program managers. Also, we recommend contacting the grantor to discuss the need to repay the $5,821. Auditee’s comments and response – IPTF hired a new contract accountant in October 2022 and have since implemented processes to ensure accurate internal financial statements are prepared and reviewed by program managers on a monthly basis as required by their written financial policies. Responsible party for corrective action – Sharon Day, Executive Director Repeat finding – No

Corrective Action Plan

2023-001: Overspent Grant Federal Departments: Department of Health and Human Services Assistance Listing #: 93.243 Compliance and Internal Controls Material Weakness Category of Finding – Cash Management Name of contact person – Sharon Day, Executive Director Corrective action – IPTF hired a new contract accountant in October 2022 and have since implemented processes to ensure accurate internal financial statements are prepared and reviewed by program managers on a monthly basis as required by their written financial policies. Completion date – Management and the Board of Directors implemented the above as of January 2024.

Categories

Questioned Costs Cash Management Material Weakness

Other Findings in this Audit

  • 383842 2023-003
    Significant Deficiency Repeat
  • 383843 2023-003
    Significant Deficiency Repeat
  • 383844 2023-002
    Material Weakness
  • 383846 2023-004
    Significant Deficiency
  • 383847 2023-004
    Significant Deficiency
  • 383848 2023-004
    Significant Deficiency
  • 383849 2023-005
    Significant Deficiency
  • 383850 2023-005
    Significant Deficiency
  • 383851 2023-005
    Significant Deficiency
  • 960284 2023-003
    Significant Deficiency Repeat
  • 960285 2023-003
    Significant Deficiency Repeat
  • 960286 2023-002
    Material Weakness
  • 960287 2023-001
    Material Weakness
  • 960288 2023-004
    Significant Deficiency
  • 960289 2023-004
    Significant Deficiency
  • 960290 2023-004
    Significant Deficiency
  • 960291 2023-005
    Significant Deficiency
  • 960292 2023-005
    Significant Deficiency
  • 960293 2023-005
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.939 Hiv Prevention Activities_non-Governmental Organization Based $414,118
93.612 Native American Programs $196,773
93.959 Block Grants for Prevention and Treatment of Substance Abuse $167,227
93.917 Hiv Care Formula Grants $112,288
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $58,612
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $19,529
10.170 Specialty Crop Block Grant Program - Farm Bill $14,830