Finding 1221269 (2024-009)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2026-06-30

AI Summary

  • Core Issue: The Organization's grant expenses in the general ledger do not match those reported on monthly FSRs, leading to compliance issues with federal requirements.
  • Impacted Requirements: Incomplete accounting records and lack of timely, accurate reporting hinder compliance with federal regulations for allowable costs.
  • Recommended Follow-Up: Implement a system of controls to ensure FSRs are reconciled with the general ledger before submission, as planned by the chief finance officer.

Finding Text

2024-009 Material Weakness – Grant Expenses Criteria and Condition: In order to stay in compliance with federal requirements for allowable activities/allowable costs, the Organization must have complete accounting records, follow approved budgets, and file required reporting forms in a timely and accurate manner. The Organization has not complied with this requirement, as grant expenses reported in general ledger did not agree to grant expenses reported on monthly FSRs. Context: General ledger expense accounts for the federal grant did not agree with, or were not reconciled to, amounts reported on the FSRs, resulting in differences of balances and classifications from what was reported. Cause: Changes in personnel and accounting software, along with not having a system of controls in place to track and reconcile federal expenditures per the general ledger and support to amounts reported on the FSRs to ensure accurate reporting of amounts and classification of expenses. Effect: Accounting records could not be reconciled to amounts and classifications reported on FSRs. The largest variance in total expenses reported was from payroll ($171,199), and of which $74,814 can be attributed to audit finding 2024-008 in which 3 months were billed using net pay versus gross pay. The remaining difference of $96,385 in payroll could not be identified, however the general ledger balances were higher than what was reported on the FSRs. The remaining FSR categories of supplies and materials, travel, staff development, and media/communications/public affairs could not be reconciled to the general ledger individually, but in total reconciled within $3,531. Recommendation: Establish a system of controls to review and reconcile FSR submissions to support and the general ledger prior to submission. Views of Responsible Officials and Planned Corrective Action: The chief finance officer will reconcile FSR submission to document support and the general ledger before submission.

Corrective Action Plan

The chief finance officer will reconcile FSR submission to document support and the general ledger before submission.

Categories

Allowable Costs / Cost Principles Material Weakness Reporting

Other Findings in this Audit

  • 1221252 2024-004
    Material Weakness Repeat
  • 1221253 2024-005
    Material Weakness Repeat
  • 1221254 2024-006
    Material Weakness Repeat
  • 1221255 2024-007
    Material Weakness Repeat
  • 1221256 2024-008
    Material Weakness Repeat
  • 1221257 2024-009
    Material Weakness Repeat
  • 1221258 2024-004
    Material Weakness Repeat
  • 1221259 2024-005
    Material Weakness Repeat
  • 1221260 2024-006
    Material Weakness Repeat
  • 1221261 2024-007
    Material Weakness Repeat
  • 1221262 2024-008
    Material Weakness Repeat
  • 1221263 2024-009
    Material Weakness Repeat
  • 1221264 2024-004
    Material Weakness Repeat
  • 1221265 2024-005
    Material Weakness Repeat
  • 1221266 2024-006
    Material Weakness Repeat
  • 1221267 2024-007
    Material Weakness Repeat
  • 1221268 2024-008
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.959 Substance Abuse Prevention & Treatment Block Grant $106,407
93.959 Block Grants for Prevention and Treatment of Substance Abuse $92,707