Finding 977232 (2023-001)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-06-13

AI Summary

  • Core Issue: Transactions were not consistently recorded to the correct general ledger codes, leading to potential misstatements in financial reporting.
  • Impacted Requirements: Inadequate oversight and reconciliation processes failed to detect errors, complicating the accuracy of financial records.
  • Recommended Follow-Up: Management should enhance policies for proper posting and establish regular reconciliations before presenting financials to executives and the board.

Finding Text

2023‐001 ‐ Proper General Ledger Posting, Reconciliations and Adequate Oversight Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure accurate recording of transactions to proper general ledger codes. Reconciliations and oversight should be designed and executed to ensure proper posting and detect errors on a timely basis. Condition: Throughout the year, transactions were not consistently recorded to the correct general ledger code in accordance generally accepted accounting principles. Various receivables were recorded incorrectly as a reduction to deferred revenue and various liability transactions were recorded as a reduction to asset balances. Further, oversight did not detect such errors. Cause: An inconsistent application of generally accepted accounting principles resulted in the Agency posting accounts receivable and deferred revenue transactions to the same balance sheet account potentially misstating asset and liability balances. This complicates reconciliation processes and coupled with fact that books and records were not reconciled with the final audited financials, result in users of the financials not having complete and accurate financials available for decision-making purposes. Effect: The lack of accurate general ledger posting, reconciliations and adequate oversight led to material audit adjustments in the following areas: accounts receivable, accrued liabilities/accrued salaries, unemployment liabilities, deferred revenue, contract and grant revenues, and expenditures. Recommendation: We recommend the management review current policies and procedures to ensure that transactions are posted to the proper general ledger account and regular oversight and reconciliation processes be enhanced. Such reconciliations and oversight should be completed before financial records are presented to executive management and the board for decision-making purposes. Views of Responsible Official and Planned Corrective Actions: The Executive Director and Senior Director of Finance will engage with all team members whose responsibilities include posting to the OCO General Ledger; updates will be completed on the procedure to provide clarifications where needed. A general step by step process/guide for reviewing ledgers for common mistakes and methods of investigation will be incorporated into the procedure. Training will be completed for those who are authorized to post to the general ledgers and corrective actions will be issued as errors are identified. The Controller will continue to complete monthly reviews of the ledger in accordance with the updated procedures.

Categories

Internal Control / Segregation of Duties

Other Findings in this Audit

  • 400786 2023-001
    Material Weakness Repeat
  • 400787 2023-002
    Material Weakness Repeat
  • 400788 2023-001
    Material Weakness Repeat
  • 400789 2023-002
    Material Weakness Repeat
  • 400790 2023-001
    Material Weakness Repeat
  • 400791 2023-002
    Material Weakness Repeat
  • 977228 2023-001
    Material Weakness Repeat
  • 977229 2023-002
    Material Weakness Repeat
  • 977230 2023-001
    Material Weakness Repeat
  • 977231 2023-002
    Material Weakness Repeat
  • 977233 2023-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.600 Head Start $2.86M
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $2.38M
93.498 Provider Relief Fund $679,121
16.575 Crime Victim Assistance $589,018
93.912 Rural Health Care Services Outreach, Rural Health Network Development and Small Health Care Provider Quality Improvement $544,982
93.575 Child Care and Development Block Grant $523,518
14.267 Continuum of Care Program $412,458
93.053 Nutrition Services Incentive Program $293,726
14.218 Community Development Block Grants/entitlement Grants $282,576
93.569 Community Services Block Grant $251,741
16.589 Rural Domestic Violence, Dating Violence, Sexual Assault, and Stalking Assistance Program $249,980
93.550 Transitional Living for Homeless Youth $219,159
93.235 Affordable Care Act (aca) Abstinence Education Program $212,305
93.623 Basic Center Grant $210,614
93.211 Telehealth Programs $144,060
16.021 Justice Systems Response to Families $140,428
93.778 Medical Assistance Program $136,574
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $118,016
10.558 Child and Adult Care Food Program $102,817
16.736 Transitional Housing Assistance for Victims of Domestic Violence, Dating Violence, Stalking, Or Sexual Assault $93,796
16.888 Consolidated and Technical Assistance Grant Program to Address Children and Youth Experiencing Domestic and Sexual Violence and Engage Men and Boys As Allies $92,294
10.559 Summer Food Service Program for Children $49,563
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $48,342
93.434 Every Student Succeeds Act/preschool Development Grants $22,159
93.558 Temporary Assistance for Needy Families $19,421
93.991 Preventive Health and Health Services Block Grant $19,309
93.994 Maternal and Child Health Services Block Grant to the States $17,569
93.557 Education and Prevention Grants to Reduce Sexual Abuse of Runaway, Homeless and Street Youth $16,862
17.259 Wia Youth Activities $9,275
16.017 Sexual Assault Services Formula Program $8,362
10.555 National School Lunch Program $7,826
93.767 Children's Health Insurance Program $6,550
10.553 School Breakfast Program $1,964