Finding 22547 (2022-001)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-03-28

AI Summary

  • Core Issue: A clerical error led to a grant claim exceeding actual expenditures, resulting in incomplete claims for incurred costs.
  • Impacted Requirements: The lack of proper reconciliation processes and documentation for grant claims affected financial accuracy and compliance.
  • Recommended Follow-up: Establish a clear process for documenting adjustments and ensure all corrections are reflected in supporting documentation and financial records.

Finding Text

2022-001 Reconciling grant claims to general ledger Criteria: Processes and procedures should be in place to reconcile grant expenditures claimed to the financial records. Condition: WCASA has several grants that require tracking of actual costs charged and claimed against each grant. Spreadsheets are used to track grant budgets and actual expenditures claimed against the financial accounting system. During the year a clerical error was made, and a claim was submitted that was more than actual expenditures incurred for that period. To reconcile this, WCASA reduced future claims to make up for the error but ended up not claiming all of the expenditures incurred through the process. Cause: WCASA had turnover in the financial and accounting position. The original error was physically made by the previous accounting employee and was not fully discovered by the new accounting employee until the audit was in process. Effect: As a result of the reconciliation error, an additional claim needed to be submitted for the remaining contract balance to agree to actual expenditures incurred and an adjustment to record additional accounts receivable was necessary. Auditor?s Recommendation: While we know that the organization has a good process for reviewing and submitting claims, we recommend that a process be established for making sure any adjustments or corrections are documented. Additionally, that any such corrections be updated in all the supporting documentation to ensure that subsequent claims are supported by internal documentation and that the financial records are updated as necessary. Grantee Response: WCASA is aware of the importance of proper internal controls over financial and grant reporting. Unfortunately, a clerical error was made that was not fully reconciled before yearend. In addition, turnover in accounting personnel happened after the clerical error and the new staff was not aware that additional corrections were still necessary. WCASA will continue to review its procedures and ensure that the accounting records are reviewed and reconciled as necessary.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 22543 2022-001
    Significant Deficiency
  • 22544 2022-001
    Significant Deficiency
  • 22545 2022-001
    Significant Deficiency
  • 22546 2022-001
    Significant Deficiency
  • 22548 2022-001
    Significant Deficiency
  • 22549 2022-001
    Significant Deficiency
  • 22550 2022-001
    Significant Deficiency
  • 22551 2022-001
    Significant Deficiency
  • 22552 2022-001
    Significant Deficiency
  • 22553 2022-001
    Significant Deficiency
  • 22554 2022-001
    Significant Deficiency
  • 22555 2022-001
    Significant Deficiency
  • 598985 2022-001
    Significant Deficiency
  • 598986 2022-001
    Significant Deficiency
  • 598987 2022-001
    Significant Deficiency
  • 598988 2022-001
    Significant Deficiency
  • 598989 2022-001
    Significant Deficiency
  • 598990 2022-001
    Significant Deficiency
  • 598991 2022-001
    Significant Deficiency
  • 598992 2022-001
    Significant Deficiency
  • 598993 2022-001
    Significant Deficiency
  • 598994 2022-001
    Significant Deficiency
  • 598995 2022-001
    Significant Deficiency
  • 598996 2022-001
    Significant Deficiency
  • 598997 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
16.589 Rural Domestic Violence, Dating Violence, Sexual Assault, and Stalking Assistance Program $221,658
93.136 Injury Prevention and Control Research and State and Community Based Programs $208,346
16.588 Violence Against Women Formula Grants $183,786
16.556 State Domestic Violence and Sexual Assault Coalitions $167,356
93.991 Preventive Health and Health Services Block Grant $127,156
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $94,512
16.575 Crime Victim Assistance $53,387
16.017 Sexual Assault Services Formula Program $31,132
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $28,000
21.027 Coronavirus State and Local Fiscal Recovery Funds $9,099
16.889 Grants for Outreach and Services to Underserved Populations $508