Finding 598755 (2022-001)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-06-07

AI Summary

  • Core Issue: Financial records were inaccurate due to unposted adjustments and lack of reconciliations, leading to significant errors in accounts.
  • Impacted Requirements: Policies for timely reconciliation and accurate recordkeeping were not followed, affecting decision-making based on flawed financials.
  • Recommended Follow-Up: Ensure regular reconciliations are conducted monthly and before presenting financials to management and the board.

Finding Text

2022-001 - Financial Statement Preparation and Reconciliation of Account Balances Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure proper recordkeeping and reporting. Condition: Adjustments to clinical billings were not posted to the general ledger during the year under audit. In addition, the reserve for doubtful accounts was not evaluated and the prior year reserve was liquidated, creating revenue. Further, grant and contract receivables, deferred revenue and associated revenue were not reconciled. Cause: Reconciliation of certain account balances did not take place consistently throughout the year or at year end. Effect: The lack of reconciliations led to material audit adjustments necessary to correct significant errors identified in the following areas: accounts receivable, deferred revenue, bad debt expense and associated revenue accounts. Further, financials were used for decision-making purposes during the year that contained material misstatements. Recommendation: We recommend management ensure reconciliations are performed on a timely basis throughout the year as part of the monthly financial reporting processes before financial records are presented to executive management and the board of directors for decision-making purposes. Views of Responsible Official and Planned Corrective Actions: Management has established a policy for timely and methodical management of clinical billings and reconciliation with the general ledger. In addition, management has established a policy and procedure to reflect receivables in the billing management system at an expected realizable rate to also be reflected in the general ledger at the time of billing. Further, transition in the fiscal manager position is taking place and management will ensure that receivables and associated balances are reconciled and analyzed timely and that revenue is recognized in accordance with Generally Accepted Accounting Principles.

Categories

Reporting

Other Findings in this Audit

  • 22304 2022-001
    Material Weakness Repeat
  • 22305 2022-002
    Material Weakness
  • 22306 2022-003
    Significant Deficiency Repeat
  • 22307 2022-001
    Material Weakness Repeat
  • 22308 2022-002
    Material Weakness
  • 22309 2022-003
    Significant Deficiency Repeat
  • 22310 2022-001
    Material Weakness Repeat
  • 22311 2022-002
    Material Weakness
  • 22312 2022-003
    Significant Deficiency Repeat
  • 22313 2022-001
    Material Weakness Repeat
  • 22314 2022-002
    Material Weakness
  • 22315 2022-003
    Significant Deficiency Repeat
  • 598746 2022-001
    Material Weakness Repeat
  • 598747 2022-002
    Material Weakness
  • 598748 2022-003
    Significant Deficiency Repeat
  • 598749 2022-001
    Material Weakness Repeat
  • 598750 2022-002
    Material Weakness
  • 598751 2022-003
    Significant Deficiency Repeat
  • 598752 2022-001
    Material Weakness Repeat
  • 598753 2022-002
    Material Weakness
  • 598754 2022-003
    Significant Deficiency Repeat
  • 598756 2022-002
    Material Weakness
  • 598757 2022-003
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $240,068
93.558 Temporary Assistance for Needy Families $185,104
16.543 Missing Children's Assistance $129,777
16.812 Second Chance Act Reentry Initiative $101,666
93.958 Block Grants for Community Mental Health Services $74,791
16.582 Crime Victim Assistance/discretionary Grants $69,981
16.588 Violence Against Women Formula Grants $48,147
16.758 Improving the Investigation and Prosecution of Child Abuse and the Regional and Local Children's Advocacy Centers $20,000
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $7,272