Finding 576740 (2022-001)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-10-02

AI Summary

  • Core Issue: Timely account reconciliations were not completed, with some finalized as late as September 2023, leading to material adjustments during the audit.
  • Impacted Requirements: This situation violates Uniform Guidance 200.302(b)(4), which mandates effective control over funds and assets.
  • Recommended Follow-Up: Implement training and procedures to ensure timely and accurate reconciliations, with oversight by accounting staff or third-party professionals before audits.

Finding Text

Condition: The Organization reconciled significant accounts in the accounting system for December 31, 2022, with assistance by the auditing firm. The auditing firm’s assistance was overseen by an individual with the requisite skills, knowledge, and experience. However, reconciliations were not timely in that some reconciliations were not finalized until late September 2023. In addition, material adjustments were proposed and recorded by management during the audit to adjust accounts such as investments, grants and accounts receivable, accounts payable, and accrued expenses, and the related revenues and expenses, including adjustments of $80,942 to prior period balances and net assets. Additionally, errors in coding of transactions to the correct classes in the general ledger accounting software prevented the Organization from consistently implementing the control of comparing the grant draws and support to the general ledger detail. Criteria: Uniform Guidance 200.302(b)(4) states each non-federal entity must provide for “effective control over, and accountability for, all funds, property, and other assets.” Cause: Turnover in the CFO position twice during the year ended December 31, 2022, resulted in a time period where account reconciliations were not being maintained. The former CFO resigned effective March 2022, and her replacement resigned effective December 2022. This required extensive transition of knowledge that contributed to financial reporting delays. Effect: A material weakness in internal control over financial reporting and over compliance exists due to failure to properly code transactions and to timely reconcile and adjust accounts which led to material adjusting journal entries being identified during the audit process. Where the Organization maintained adequate documentation to support costs allowable for substantially the full amount of the budget for grant number HESG-CV-20-003 (CFDA 14.231), there was an isolated incident of errors in developing and communicating support for $78,932 of the draws. Recommendation: We recommend the Organization implement systems, procedures and training to ensure accounts are reconciled timely and accurately with the reconciliations completed entirely by the Organization’s accounting staff or by third party professionals prior to provision of the trial balance and supporting documentation to the auditor. Views of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has developed and begun implementation of a corrective action plan. To address this finding, the Organization has implemented processes whereby the CFO compares profit and loss detail statements from the general ledger for each grant to the draw requests and investigates any differences.

Categories

Reporting Material Weakness Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 298 2022-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
16.736 Transitional Housing Assistance for Victims of Domestic Violence, Dating Violence, Stalking, Or Sexual Assault $262,422
16.575 Crime Victim Assistance $202,303
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $91,684
14.231 Covid-19 Emergency Solutions Grant Program $88,481
93.671 Covid-19 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $54,672
14.231 Emergency Solutions Grant Program $40,000
16.588 Violence Against Women Formula Grants $36,100
93.558 Temporary Assistance for Needy Families $8,400
14.218 Community Development Block Grants/entitlement Grants $5,923