Finding 1055107 (2022-003)

Material Weakness
Requirement
CN
Questioned Costs
$1
Year
2022
Accepted
2024-07-16

AI Summary

  • Core Issue: The Organization failed to properly segregate salaries in its accounting records, leading to potential misreporting of grant expenditures.
  • Impacted Requirements: Federal regulations require accurate tracking of grant expenditures to prevent double counting and ensure only allowable costs are charged.
  • Recommended Follow-Up: Restructure the chart of accounts for better segregation and implement routine time and effort reporting to ensure compliance with federal guidelines.

Finding Text

Finding 2022-003 – Compliance Deficiencies (Material Weakness) Information on the Federal Program – Block Grants for Community Mental Health Services FAL No. 93.958, December 31, 2022 Criteria – Federal regulations mandate that grantees maintain records of grant expenditures in their accounting systems to ensure segregation and accurate financial reporting. Condition – The Organization did not segregate salaries in its general ledger. Salaries were lumped into one general ledger account regardless of whether incurred for unrestricted or restricted purposes. Also, there were no time and effort reports completed during the year to ensure only allowable salaries and fringes were charged to the grant. Questioned Costs – Total salaries and fringes charged to the grant were $222,966. Context – The Organization runs the risks of double counting salaries on multiple grants or recording unallowable costs to grants by not tracking time and effort or segregating the expenditures. Effect – Total expenditures charged to the grant were not identifiable in the Organizations accounting records. Cause – Improperly designed account structure, lack of training, significant turnover and manual processes. Repeat Finding – No. Recommendation – The Organization must record expenditures in the general ledger in a manner that facilitates segregation according to its purpose. This can be achieved by restructuring the chart of accounts or affixing project codes to restricted transactions. Further, time and effort reports must be routinely completed to account for 100% of an employee’s time if charged to a federal program. This ensures only allowable costs are charged to the grant. Views of Responsible Officials – Management fully agrees and has transitioned from the old Abila system to the QuickBooks automated system. Additional measures will be identified in the Management Corrective Action Plan.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 478662 2022-002
    Material Weakness
  • 478663 2022-002
    Material Weakness
  • 478664 2022-002
    Material Weakness
  • 478665 2022-003
    Material Weakness
  • 1055104 2022-002
    Material Weakness
  • 1055105 2022-002
    Material Weakness
  • 1055106 2022-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.958 Block Grants for Community Mental Health Services $299,748
93.732 Mental and Behavioral Health Education and Training Grants $105,135