Finding 420509 (2022-004)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2023-03-27

AI Summary

  • Core Issue: The College's time and effort reporting relies on annual estimates, lacking timely and accurate verification of actual work performed.
  • Impacted Requirements: This practice does not meet the standards set by 2 CFR 200.430 for documentation of personnel expenses, risking inaccurate allocation of federal award charges.
  • Recommended Follow-Up: Implement a more frequent certification process and establish a review system to ensure accuracy and compliance in time and effort reporting.

Finding Text

Criteria or specific requirement: Per guidance: 2 CFR 200.430, (i) Standards for Documentation of Personnel Expenses, (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated.Condition: We noted the College?s Time and Effort is originally based upon an estimate at the beginning of the year. While the employee does later certify the estimate is correct (or submits any adjustments), this certification is only completed once a year and it is not reviewed or approved by anyone other than the employee. There was no control in place to detect if the employee?s certification was incorrect.Questioned costs: None.Context: We tested 40 employees and noted for all tested, while the employee certified their time and effort, this certification occurred once a calendar year from one to four months after the calendar year end. In addition, there was no review control to ensure certification was accurate, allowable, and properly allocated.Cause: The College was not aware there should be a distinct internal control over time and effort reporting.Effect: The College?s system of time and effort reporting does not have internal controls to provide reasonable assurance that payroll charges are based upon actual time incurred. As such, it could inadvertently be allocating personnel expenses inaccurately and improperly to federal awards.Repeat finding: No.Recommendation: We recommend that the College increase the time and effort certification process to be more timely and implement a review process over the time and effort certification process.View of responsible official: The College agrees with the finding.

Categories

Allowable Costs / Cost Principles Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 420504 2022-002
    Significant Deficiency Repeat
  • 420505 2022-001
    Significant Deficiency Repeat
  • 420506 2022-002
    Significant Deficiency Repeat
  • 420507 2022-003
    Significant Deficiency Repeat
  • 420508 2022-004
    Significant Deficiency
  • 420510 2022-004
    Significant Deficiency
  • 420511 2022-004
    Significant Deficiency
  • 420512 2022-005
    Significant Deficiency
  • 420513 2022-004
    Significant Deficiency
  • 420514 2022-004
    Significant Deficiency
  • 420515 2022-004
    Significant Deficiency
  • 420516 2022-004
    Significant Deficiency
  • 420517 2022-004
    Significant Deficiency
  • 420518 2022-004
    Significant Deficiency
  • 420519 2022-004
    Significant Deficiency
  • 420520 2022-004
    Significant Deficiency
  • 420521 2022-004
    Significant Deficiency
  • 420522 2022-004
    Significant Deficiency
  • 420523 2022-004
    Significant Deficiency
  • 420524 2022-004
    Significant Deficiency
  • 996946 2022-002
    Significant Deficiency Repeat
  • 996947 2022-001
    Significant Deficiency Repeat
  • 996948 2022-002
    Significant Deficiency Repeat
  • 996949 2022-003
    Significant Deficiency Repeat
  • 996950 2022-004
    Significant Deficiency
  • 996951 2022-004
    Significant Deficiency
  • 996952 2022-004
    Significant Deficiency
  • 996953 2022-004
    Significant Deficiency
  • 996954 2022-005
    Significant Deficiency
  • 996955 2022-004
    Significant Deficiency
  • 996956 2022-004
    Significant Deficiency
  • 996957 2022-004
    Significant Deficiency
  • 996958 2022-004
    Significant Deficiency
  • 996959 2022-004
    Significant Deficiency
  • 996960 2022-004
    Significant Deficiency
  • 996961 2022-004
    Significant Deficiency
  • 996962 2022-004
    Significant Deficiency
  • 996963 2022-004
    Significant Deficiency
  • 996964 2022-004
    Significant Deficiency
  • 996965 2022-004
    Significant Deficiency
  • 996966 2022-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Loans $4.81M
84.063 Federal Pell Grant Program $1.65M
84.038 Federal Perkins Loans $1.64M
84.425 Covid-19-Education Stabilization Fund III - Institutional Portion $1.47M
84.425 Covid-19-Education Stabilization Fund III - Student Aid Portion $1.47M
59.075 Covid - 19 - Ussba Shuttered Venue Grant $408,143
84.033 Federal Work-Study Program $201,850
84.007 Federal Supplemental Educational Opportunity Grants $194,857
47.049 Nsf: Mri: Confocal Raman Spect $177,696
47.050 Nsf: Grtaz Mercury Oxid Pat $141,931
47.076 Nsf: Noyce Scholarship $126,661
47.074 Nsf: Barnes Career $69,807
47.050 Nsf: Testing Models-Sibumas $58,865
47.078 Nsf: Ici-Hot in West Antactica $57,089
47.050 Nsf: Schanz Bedrock Rivers $49,831
93.575 Child Care Operations Stablizations Grant $45,303
47.049 Nsf: Leaps Malmskog $33,085
47.076 Nsf: Advance Geosciences $21,615
47.076 Nsf: Progress; Barnes Iuse Mentoring $18,646
43.001 NASA Subaward Through Jpl California Institute of Technology, Cluster with K2, Research Support Agreement (rsa) $18,425
47.078 Nsf: Testing the Linchpin Wais $16,366
47.049 Nsf: Leaps Light $8,755
47.049 Nsf: Leaps2; Part Suppo Malmskog $2,527
47.074 Nsf: Barnes Soil & Wildfire $1,869
93.575 Child Care Workforce Sustainability Grant $1,600