Finding 526857 (2023-005)

Significant Deficiency
Requirement
AB
Questioned Costs
$1
Year
2023
Accepted
2025-03-13
Audit: 345960
Auditor: Sikich CPA LLC

AI Summary

  • Core Issue: The Organization lacks proper documentation and internal controls for payroll costs related to federal awards, leading to discrepancies in time and effort records.
  • Impacted Requirements: Noncompliance with Subpart E - Cost Principles and 2 CFR 200.303, which mandate accurate tracking and reporting of allowable costs.
  • Recommended Follow-Up: Management should enhance internal controls to ensure thorough review and reconciliation of time records with payroll expenditures for federal programs.

Finding Text

2023-005 - Significant Deficiency: Activities Allowed or Unallowable Costs/Cost Principles Criteria: The Organization is required to have procedures in place to ensure that federal awards are expended for allowable costs in accordance with Subpart E - Cost Principles of Uniform Guidance. The CFR section 200.303 (i) states that, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Additionally, 2 CFR.200.303 requires nonfederal entities to, among other things, establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Condition: During our testing of payroll costs, we noted that (1) the Organization’s documentation of time and effort related to the Federal programs did not agree to personnel costs charged to the Federal program (2) the Organization did not properly review and reconcile time and effort records to payroll costs charged to the Federal grant to ensure amounts charged to the grant were allowable costs. Cause: Internal controls surrounding the tracking and review of payroll expenditures charged to Federal programs were not properly implemented to detect and correct errors. Additionally, the grant related payroll tracking was a manual process during 2023, therefore increasing the possibility of error. Effect: The Organization did not properly review and reconcile time and effort records to payroll costs charged to the Federal grant to ensure amounts charged to the grant were allowable costs. Questioned Costs: ALN 84.287 - $3,905 ALN 84.215J - $8,130 Recommendation: We recommend that management of the Organization review internal controls and ensure they are properly designed and implemented to ensure that time records are reviewed and reconciled to payroll expenditures being charged to the Federal program. Views of Responsible Officials: Management agrees with this finding and their response is included in the corrective action plan.

Categories

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

Other Findings in this Audit

  • 526850 2023-002
    Material Weakness
  • 526851 2023-003
    Significant Deficiency
  • 526852 2023-004
    Significant Deficiency
  • 526853 2023-005
    Significant Deficiency
  • 526854 2023-002
    Material Weakness
  • 526855 2023-003
    Significant Deficiency
  • 526856 2023-004
    Significant Deficiency
  • 526858 2023-002
    Material Weakness
  • 526859 2023-003
    Significant Deficiency Repeat
  • 526860 2023-004
    Significant Deficiency
  • 526861 2023-005
    Significant Deficiency
  • 1103292 2023-002
    Material Weakness
  • 1103293 2023-003
    Significant Deficiency
  • 1103294 2023-004
    Significant Deficiency
  • 1103295 2023-005
    Significant Deficiency
  • 1103296 2023-002
    Material Weakness
  • 1103297 2023-003
    Significant Deficiency
  • 1103298 2023-004
    Significant Deficiency
  • 1103299 2023-005
    Significant Deficiency
  • 1103300 2023-002
    Material Weakness
  • 1103301 2023-003
    Significant Deficiency Repeat
  • 1103302 2023-004
    Significant Deficiency
  • 1103303 2023-005
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.215 Innovative Approaches to Literacy; Promise Neighborhoods; Full-Service Community Schools; and Congressionally Directed Spending for Elementary and Secondary Education Community Projects $461,161
84.287 Twenty-First Century Community Learning Centers $242,025
14.218 Community Development Block Grants/entitlement Grants $126,247
21.027 Coronavirus State and Local Fiscal Recovery Funds $101,706
97.024 Emergency Food and Shelter National Board Program $15,488
84.424 Student Support and Academic Enrichment Program $2,160