Finding 578305 (2023-001)

Material Weakness
Requirement
CEGHLM
Questioned Costs
-
Year
2023
Accepted
2023-11-15

AI Summary

  • Issue: Accounts receivable and deferred revenue were overstated by $296,539 and $498,882, respectively.
  • Requirements: Monthly reconciliation of accounts to ensure accurate reporting on the Schedule of Expenditures of Federal Awards.
  • Follow-up: Implement regular reviews and reconciliations of the general ledger to maintain accurate financial reporting.

Finding Text

Condition The beginning balances of accounts receivable were overstated in the amount of $296,539 and the deferred revenue was overstated in the amount of $498,882 on the Schedule of Expenditures of Federal Awards for the year ended June 30, 2022. Criteria The accounts receivable and deferred revenue accounts should be reconciled to their proper balance in the general ledger on a monthly basis and reported properly on the Schedule of Expenditures of Federal Awards. Cause The finance director was relying on guidance from the prior year auditor and did not verify the recommended adjusting entries. Effect There was a substantial overstatement of accounts receivable and deferred revenue recorded in the general ledger which caused a substantial overstatement on the Schedule of Expenditures of Federal Awards. Recommendation We recommend that all accounts in the general ledger be reviewed and reconciled to their proper balance in the general ledger on a monthly basis and be reported property on the Schedule of Expenditures of Federal Awards.

Categories

Reporting

Other Findings in this Audit

  • 1860 2023-001
    Material Weakness
  • 1861 2023-002
    Significant Deficiency
  • 1862 2023-003
    Significant Deficiency
  • 1863 2023-001
    Material Weakness
  • 1864 2023-002
    Significant Deficiency
  • 578302 2023-001
    Material Weakness
  • 578303 2023-002
    Significant Deficiency
  • 578304 2023-003
    Significant Deficiency
  • 578306 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.568 Low-Income Home Energy Assistance $1.57M
14.231 Emergency Solutions Grant Program $1.48M
14.267 Continuum of Care Program $477,827
93.569 Community Services Block Grant $450,713
21.027 Coronavirus State and Local Fiscal Recovery Funds $431,495
81.042 Weatherization Assistance for Low-Income Persons $311,937
14.218 Community Development Block Grants/entitlement Grants $199,178