Finding 1860 (2023-001)

Material Weakness
Requirement
ABFGIN
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.

Corrective Action Plan

Corrective Action All accounts in the general ledger will 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. Procedures will be put in place so that a designated finance employee will be assigned to complete by the last day of each month. The Finance staff will establish the duties and update the fiscal policies/procedures. The Board of Directors Finance Committee AND Executive Director will receive the updated fiscal policies/procedures to approve prior to implementation. Agency Response Does the agency agree with the finding? -x-Yes --No Additional Comments N/A Agency Contact Responsible for Correction Action Name: Lisa Hann - Board President Address: 2301 Beale Ave Altoona, PA 16601 Phone Number: (814) 944-3583 Email: Ihann@familyservicesinc.net

Categories

Reporting

Other Findings in this Audit

  • 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
  • 578305 2023-001
    Material Weakness
  • 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