Finding 1176977 (2025-005)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2025
Accepted
2026-03-09
Audit: 390817
Organization: Domestic Violence Crisis Center (ND)
Auditor: BRADY MARTZ

AI Summary

  • Core Issue: The Center made errors in payroll transactions, leading to discrepancies between approved employee time distributions and the allocation spreadsheet.
  • Impacted Requirements: Compliance with internal controls and accurate reimbursement requests for allowable activities and costs is at risk.
  • Recommended Follow-Up: Ensure accurate data entry on the allocation spreadsheet and implement a review process for retirement contributions before submission.

Finding Text

Criteria: An appropriate system of internal controls requires that the Center comply with the requirements of the compliance supplement and request reimbursement only for allowable activities and costs. Condition: During our single audit payroll transaction testing of AL 16.575 Crime Victim Assistance, it was noted that there were two payroll transactions that had a difference between the approved employee time distribution and the allocation spreadsheet that is used to allocate expenses to the grant. Cause: The Center erroneously keyed amounts and percentages from approved employee time distributions on the allocation spreadsheet that is used to allocate expenses to the grant. The Center also keyed an employee's retirement withholdings erroneously when entering into Mutual of America's contribution portal which understated the employee's contributions to their retirement for that payroll. Questioned Costs: There were no questioned costs associated with this finding. Effect: Expenses could be improperly coded to the grant. Recommendation: We recommend that the correct amounts and percentages from approved employee time distributions be keyed on the allocation spreadsheet that is used to allocate expenses to the grant. We also recommend that someone other than the preparer review the retirement amounts input into Mutual of America before they are submitted. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding. See corrective action plan item 2025-005. Indication of repeat finding: This is not a repeat finding.

Corrective Action Plan

Contact Person Aaron Moss, Board President Corrective Action Plan The Center will review its process for keying amounts and percentages from employee time distributions into the allocation spreadsheet that is used to allocate expenses to the grant. The Center will also review its process for keying amounts into the Mutual of America contribution portal. Completion Date Ongoing

Categories

Allowable Costs / Cost Principles Cash Management Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1176976 2025-004
    Material Weakness Repeat
  • 1176978 2025-006
    Material Weakness Repeat
  • 1176979 2025-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.671 FAMILY VIOLENCE PREVENTION AND SERVICES/DOMESTIC VIOLENCE SHELTER AND SUPPORTIVE SERVICES $259,760
16.575 CRIME VICTIM ASSISTANCE $199,999
16.017 SEXUAL ASSAULT SERVICES FORMULA PROGRAM $102,827
93.497 FAMILY VIOLENCE PREVENTION AND SERVICES/ SEXUAL ASSAULT/RAPE CRISIS SERVICES AND SUPPORTS $99,487
16.589 RURAL DOMESTIC VIOLENCE, DATING VIOLENCE, SEXUAL ASSAULT, AND STALKING ASSISTANCE PROGRAM $69,860
16.588 VIOLENCE AGAINST WOMEN FORMULA GRANTS $53,928
93.591 FAMILY VIOLENCE PREVENTION AND SERVICES/STATE DOMESTIC VIOLENCE COALITIONS $25,994
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $25,743
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $15,579
97.024 EMERGENCY FOOD AND SHELTER NATIONAL BOARD PROGRAM $6,141