Finding 403044 (2023-001)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-06-26
Audit: 310186
Organization: United Planning Organization (DC)
Auditor: Sb & Company LLC

AI Summary

  • Core Issue: Certain asset and liability accounts were not reconciled before the audit, leading to potential inaccuracies in financial statements.
  • Impacted Requirements: Monthly and year-end reconciliations of all accounts are essential for strong internal controls.
  • Recommended Follow-Up: Implement a monthly financial close checklist and ensure management reviews all reconciliations to address discrepancies.

Finding Text

All Programs 2023-001: Significant Deficiency in Internal Controls Over Financial Reporting Repeat Finding: No Condition: Certain asset and liability accounts were not reconciled as of September 30, 2023 prior to the start of the audit. There were 3 cash accounts and 1 accounts payable account that were not reconciled on a timely basis or not reconciled at all. An audit adjustment was made to correct the cash accounts in the general ledger. Criteria: Strong internal controls require that all accounts on the statement of financial position be reviewed and reconciled monthly and at year end. Cause: Management in the finance department did not properly review cash account reconciliations and investigate unreconciled differences. Additionally, the year end accounts payable aging report was not properly reviewed by management of the finance department, which caused certain invoices to be improperly included in the aging reports. Effect: Financial statements generated throughout the year may not have been accurate and complete. Questioned Costs: Unknown Recommendation: We recommend that all general ledger accounts be reconciled on a monthly basis. A monthly financial close checklist should be utilized to identify and track all general ledger account reconciliations. This will reduce the occurrence of unreconciled general accounts and activity that may result in a material misstatement of the financial statements. We further recommend that management of the finance department review all reconciliations and investigate unreconciled differences. Lastly, we recommend that all system generated reports are reviewed for accuracy. Management’s Response and Corrective Action Plan See Schedule of Corrective Action Plan. Section III – Federal Award Findings None noted.

Categories

Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 403038 2023-001
    Significant Deficiency
  • 403039 2023-001
    Significant Deficiency
  • 403040 2023-001
    Significant Deficiency
  • 403041 2023-001
    Significant Deficiency
  • 403042 2023-001
    Significant Deficiency
  • 403043 2023-001
    Significant Deficiency
  • 403045 2023-001
    Significant Deficiency
  • 403046 2023-001
    Significant Deficiency
  • 403047 2023-001
    Significant Deficiency
  • 403048 2023-001
    Significant Deficiency
  • 403049 2023-001
    Significant Deficiency
  • 979480 2023-001
    Significant Deficiency
  • 979481 2023-001
    Significant Deficiency
  • 979482 2023-001
    Significant Deficiency
  • 979483 2023-001
    Significant Deficiency
  • 979484 2023-001
    Significant Deficiency
  • 979485 2023-001
    Significant Deficiency
  • 979486 2023-001
    Significant Deficiency
  • 979487 2023-001
    Significant Deficiency
  • 979488 2023-001
    Significant Deficiency
  • 979489 2023-001
    Significant Deficiency
  • 979490 2023-001
    Significant Deficiency
  • 979491 2023-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.569 Community Services Block Grant (csbg) $10.41M
93.600 Early Head Start (ehs) Fed Base $9.22M
93.600 Quality Improvement Network - Expansion & Federal Continuation $2.94M
93.600 Head Start (hs) Fed Expansion $2.68M
94.011 Foster Grandparent Program $699,391
93.600 American Rescue Plan Qin Hub $471,998
10.558 Nutrition Child and Adult Care Food Program $216,667
93.575 Child Care Stablization $167,491
84.287 21st Century Community Learning Centers $153,525
10.551 Supplemental Nutrition Assistance Program Employment and Training (snap) $142,067
14.238 Community Partnership/dcdhs/hud $95,728
93.788 Opiod/methdone Treatment Center/hca Fed (sor) $42,708