Finding 1186 (2022-002)

Material Weakness
Requirement
ABG
Questioned Costs
-
Year
2022
Accepted
2023-11-03

AI Summary

  • Core Issue: Lack of documentation for employee compensation distribution across multiple Federal awards.
  • Impacted Requirements: Non-compliance with 2 CFR Sections 200.303(a) and 200.430(i) regarding internal controls and compensation records.
  • Recommended Follow-Up: Implement policies and procedures to ensure proper documentation and distribution of compensation for Federal awards.

Finding Text

2022-002 Distribution of Compensation – Compliance and Internal Controls over Allowable Costs and Activities and Matching (Material Weakness) Federal Program Information: Funding Agency: U.S. Department of Agriculture FALN: 10.561 Federal Award Identification Numbers: 42700-040-0000104184 Pass Through Entity: State of Georgia Department of Human Services Award Year: 2021-2022 Federal Program Information: Funding Agency: U.S. Department of Housing and Urban Development FALN: 14.231 Federal Award Identification Numbers: All under this program. See Schedule of Expenditures of Federal Awards. Pass Through Entity: Gwinnett County, Dekalb County, Cobb County, Fulton County Award Year: 2021-2022 Criteria: Under 2 CFR Section 200.303(a), non-federal entities must establish and maintain effective internal controls to provide reasonable assurance that the entity is managing the federal awards in compliance with statues, regulations, and the terms and conditions of the award. Additionally, under 2 CFR Section 200.430(i) compensation records must support the distribution of the employee’s compensation among specific activities or costs objectives if the employee works on more than one Federal award and compensation of employees used in meeting cost sharing or matching requirements on Federal awards must be supported in the same manner. Condition: There are no compensation records to support the distribution of employees’ compensation who work on multiple Federal awards. Effect: The lack of documentation and controls around how employees’ compensation is distributed between multiple Federal awards could result in unallowable costs. Cause: The Association was not aware of the requirements to maintain this documentation. Known Questioned Costs: $11,649 for FALN 14.231 Likely Questioned Costs: $76,266 for FALN 14.231 Perspective: This finding represents a systemic problem as it affects both the allowable activities and costs requirement as well as the matching requirement. Repeat Finding: No Recommendation: We recommend the Association establish policies and procedures to ensure that compensation is properly documented and distributed between Federal awards.

Corrective Action Plan

Grantee Response and Corrective Action Plan: We concur with this finding and have implemented measures to mitigate the repetition of additional occurrences. In July 2023, a new policy was implemented that requires employees to record their time as a percentage across all grants in which they work. The employee records this allocation at least weekly within a time keeping software system. Employees and supervisors are now required to review and acknowledge payroll allocations across grants by signing weekly timesheets. Timesheets will be retained and used as backup by the Grants Department when invoicing the Grantor for expense reimbursement. In addition, we have updated our Policy and Procedures Manual to reflect this policy.

Categories

Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1187 2022-002
    Material Weakness
  • 1188 2022-002
    Material Weakness
  • 1189 2022-002
    Material Weakness
  • 1190 2022-002
    Material Weakness
  • 1191 2022-002
    Material Weakness
  • 1192 2022-002
    Material Weakness
  • 1193 2022-002
    Material Weakness
  • 1194 2022-002
    Material Weakness
  • 1195 2022-003
    Material Weakness
  • 1196 2022-003
    Material Weakness
  • 1197 2022-003
    Material Weakness
  • 1198 2022-003
    Material Weakness
  • 1199 2022-003
    Material Weakness
  • 1200 2022-003
    Material Weakness
  • 1201 2022-003
    Material Weakness
  • 1202 2022-003
    Material Weakness
  • 1203 2022-003
    Material Weakness
  • 577628 2022-002
    Material Weakness
  • 577629 2022-002
    Material Weakness
  • 577630 2022-002
    Material Weakness
  • 577631 2022-002
    Material Weakness
  • 577632 2022-002
    Material Weakness
  • 577633 2022-002
    Material Weakness
  • 577634 2022-002
    Material Weakness
  • 577635 2022-002
    Material Weakness
  • 577636 2022-002
    Material Weakness
  • 577637 2022-003
    Material Weakness
  • 577638 2022-003
    Material Weakness
  • 577639 2022-003
    Material Weakness
  • 577640 2022-003
    Material Weakness
  • 577641 2022-003
    Material Weakness
  • 577642 2022-003
    Material Weakness
  • 577643 2022-003
    Material Weakness
  • 577644 2022-003
    Material Weakness
  • 577645 2022-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $347,316
21.023 Emergency Rental Assistance Program $161,475
16.016 Culturally and Linguistically Specific Services Program $147,731
21.019 Coronavirus Relief Fund $45,000
16.575 Crime Victim Assistance $38,137
21.027 Coronavirus State and Local Fiscal Recovery Funds $30,000
14.231 Emergency Solutions Grant Program $28,040
59.077 Community Navigator Pilot Program $25,000
14.218 Community Development Block Grants/entitlement Grants $21,879
93.569 Community Services Block Grant $21,676
97.024 Emergency Food and Shelter National Board Program $17,000