Finding 1024041 (2022-001)

Material Weakness Repeat Finding
Requirement
AN
Questioned Costs
-
Year
2022
Accepted
2023-06-08

AI Summary

  • Core Issue: Account balances were not reconciled on time or properly, affecting financial accuracy.
  • Impacted Requirements: Key areas like accounts receivable and deferred revenue were misstated, leading to significant audit adjustments.
  • Recommended Follow-Up: Management should enhance reconciliation policies and ensure regular reviews before financial reports are finalized.

Finding Text

2022-001 - Timely and Frequent Reconciliation of Account BalancesCriteria: Effectively designed and executed policies and procedures of financial processes should exist to ensureproper recordkeeping and reporting.Condition: Certain balances were not timely or adequately reconciled throughout the year, including accountsreceivable, deferred revenue, accrued salaries payable/salary expense, fixed assets/depreciation, and consumerdeposit asset and liability balances.Cause: Reconciliation of certain account balances did not take place consistently throughout the year. Further,certain programs posted accounts receivable and deferred revenue transactions to the same balance sheetaccount potentially misstating assets and liabilities, as well as potentially misleading users of the financialstatements.Effect: The lack of reconciliations led to material audit adjustments necessary to correct significant errorsidentified in the following areas: accounts receivable, accrued liabilities/accrued salaries, depreciation/fixedassets, unemployment liabilities, deferred revenue and contract and grant revenues recognition /expenditures.Recommendation: We recommend the management review current policies and procedures to ensure thattimely reconciliations are prepared and reviewed throughout the year as part of the monthly financial reportingprocess before financial records are presented to executive management and the board for decision-makingpurposes.Views of Responsible Official and Planned Corrective Actions: The Executive Director and Senior Director ofFinance will continue to update procedures to provide additional clarity of objectives, and to ensure areconciliations are checked by a second individual as part of the process.

Categories

Reporting

Other Findings in this Audit

  • 447599 2022-001
    Material Weakness Repeat
  • 447600 2022-002
    Material Weakness Repeat
  • 447601 2022-003
    Material Weakness Repeat
  • 447602 2022-004
    - Repeat
  • 1024042 2022-002
    Material Weakness Repeat
  • 1024043 2022-003
    Material Weakness Repeat
  • 1024044 2022-004
    - Repeat

Programs in Audit

ALN Program Name Expenditures
93.600 Head Start $2.75M
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $1.92M
16.575 Crime Victim Assistance $587,839
93.569 Community Services Block Grant $372,019
93.575 Child Care and Development Block Grant $365,271
14.267 Continuum of Care Program $278,921
93.053 Nutrition Services Incentive Program $254,905
93.235 Affordable Care Act (aca) Abstinence Education Program $250,539
93.912 Rural Health Care Services Outreach, Rural Health Network Development and Small Health Care Provider Quality Improvement $229,282
93.623 Basic Center Grant $217,361
16.021 Justice Systems Response to Families $168,831
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 $153,517
16.589 Rural Domestic Violence, Dating Violence, Sexual Assault, and Stalking Assistance Program $144,893
16.736 Transitional Housing Assistance for Victims of Domestic Violence, Dating Violence, Stalking, Or Sexual Assault $143,212
10.558 Child and Adult Care Food Program $140,685
93.778 Medical Assistance Program $132,026
93.498 Provider Relief Fund $73,460
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $49,896
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $43,508
10.559 Summer Food Service Program for Children $38,947
93.558 Temporary Assistance for Needy Families $19,125
93.434 Every Student Succeeds Act/preschool Development Grants $14,485
93.991 Preventive Health and Health Services Block Grant $14,152
93.994 Maternal and Child Health Services Block Grant to the States $12,876
17.258 Wia Adult Program $7,118
93.550 Transitional Living for Homeless Youth $6,175
93.767 Children's Health Insurance Program $6,022
10.555 National School Lunch Program $5,239
16.017 Sexual Assault Services Formula Program $4,676
10.553 School Breakfast Program $3,279