Finding 391627 (2023-004)

Material Weakness
Requirement
ABGN
Questioned Costs
$1
Year
2023
Accepted
2024-04-01
Audit: 302075
Organization: Johnson C. Smith University (NC)
Auditor: Bdo USA PC

AI Summary

  • Core Issue: The University failed to prepare and review effort certifications for payroll costs charged to federal awards in a timely manner, leading to unsupported expenditures.
  • Impacted Requirements: Compliance with 2 CFR Part 220 and 2 CFR Part 200, including documentation for labor costs and timely effort certifications.
  • Recommended Follow-up: Enhance internal controls and procedures to ensure proper documentation and timely monitoring of effort reporting for federal expenditures.

Finding Text

Federal Program Information: Higher Education Institutional Aid: Strengthening Historically Black Colleges and Universities Program (“Title III”) (ALN: 84.031B and 84.031E) and TRIO Cluster (“TRIO”) (ALN: 84.047A, 84.042A and 84.217A) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): A. Activities Allowed or Unallowed/N. Special Tests and Provisions – Per 2 Code of Federal Regulation (“CFR”) Part 220, the method used for apportioning salaries must recognize the principle of after-the-fact confirmation or determination so that costs distributed represent actual costs, unless a mutually satisfactory alternative agreement is reached. Direct cost activities as well as facilities and administration (“F&A”) cost activities may be confirmed by responsible persons with suitable means of verification that the work was performed. Confirmation by the employee is not a requirement for either direct or F&A cost activities if other responsible persons make appropriate confirmations. For after-the-fact activity records: a) Activity reports will reflect the distribution of activity expended by employees covered by the system (compensation for incidental work as described in subsection a need not be included); (b) These reports will reflect an after-the-fact reporting of the percentage distribution of activity of employees. Charges may be made initially on the basis of estimates made before the services are performed, provided that such charges are promptly adjusted if significant differences are indicated by activity records. Labor costs charged to federal awards must reasonably reflect the actual labor effort contributed by the employee to meet the objectives of the award and that adequate documentation must be maintained to support labor costs charged to sponsored agreements. For professorial and professional staff, effort certifications will be prepared each academic term, but no less frequently than every six months. For other employees, unless alternate arrangements are agreed to, the reports will be prepared no less frequently than monthly and will coincide with one or more pay periods. B. Allowable Costs and Cost Principles - In order for costs to be allowable under federal awards, they must be necessary and reasonable for the performance of the federal award and be allocable thereto under the principles in 2 CFR Part 200, Subpart E, be consistent with policies and procedures that apply uniformly to both federally financed and other activities of the non-federal entity, be accorded consistent treatment, and be determined in accordance with generally accepted accounting principles. G. Level of Effort - Level of effort includes requirements for (a) a specified level of service to be provided from period to period and (b) a specified level of expenditures from nonfederal or federal sources for specified activities to be maintained from period to period. Only allowable categories of expenditures or other effort indicators (e.g., hours, number of people served) should be included in the computation and expenditures categories should be consistent from year to year. Condition: For certain payroll costs charged to federal awards, effort certifications were not prepared and/or reviewed timely during the fiscal year. Additionally, for certain payroll and non-payroll expenditures selected for testing, the University was unable to provide documentation supporting the amount charged to the federal award. Cause: Insufficient administrative oversight and internal controls with respect to the University’s administration of federal awards in accordance with certain compliance requirements. Effect or Potential Effect: The University was unable to support certain amounts charged to federal awards and effort certifications supporting certain payroll costs charged to federal awards were not completed timely and/or appropriately monitored during the year. Questioned Costs: Below reporting threshold. Context: We noted the following exceptions during our testing: • For 4 of 15 non-payroll Title III expenditures selected for testing, the University was unable to provide documentation supporting that the expenditure was appropriately approved prior to the disbursement of funds. • For 1 of 15 non-payroll Title III expenditures selected for testing, the University was unable to provide documentation supporting the amount charged to the federal award. • For 2 of 10 payroll Title III expenditures selected for testing, the University was unable to provide documentation supporting the amount charged to the federal award. • For 5 of 8 Title III employees selected for testing, time and effort reports certified by the employee could not be provided and/or did not support the amount charged to the federal award. • For 2 of 12 months selected for testing, the University did not obtain a level of effort certification for the Title III program director. • For 1 of 10 non-payroll TRIO expenditures selected for testing, the University was unable to provide documentation supporting that the expenditure was appropriately approved prior to the disbursement of funds. • For 1 of 15 payroll TRIO expenditures selected for testing, the University was unable to provide documentation supporting the amount charged to the federal award. • For 10 of 10 TRIO Program employees selected for testing, time and effort reports certified by the employee could not be provided and/or did not support the amount charged to the federal award. Identification as a Repeat Finding: No similar findings noted in the prior year. Recommendation: We recommend that the University enhance its internal controls and policies and procedures over the applicable compliance requirements to ensure that the University has appropriate and formal documentation to support federal expenditures as required, as well as appropriately monitoring time of effort reporting in a timely manner. Views of Responsible Officials: The University experienced turnover of key positions throughout campus, particularly in the Division of Finance, Government Sponsored Programs and various federally funds programs. The changes in staffing lead to a loss of institutional knowledge, and interrupted policy and process enforcement campus wide. The Office of Government Sponsored Programs (“GSPAR”) will enhance its internal controls, policies and procedures to ensure the appropriate documentation to support is maintained, and to ensure that level of effort is appropriately documented and reported. GSPAR will be working in conjunction with the Office of Human Resources, including Payroll, to ensure accuracy, or timely correction, of general ledger postings. In addition, the grant onboarding process will be revised to emphasize key federal regulations and emphasize the importance of compliance. Reminders will also be provided during GSPAR’s semi-annual grant compliance workshops.

Categories

Questioned Costs Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties Special Tests & Provisions

Other Findings in this Audit

  • 391625 2023-004
    Material Weakness
  • 391626 2023-004
    Material Weakness
  • 391628 2023-004
    Material Weakness
  • 391629 2023-004
    Material Weakness
  • 391630 2023-005
    Material Weakness
  • 391631 2023-005
    Material Weakness
  • 391632 2023-006
    Significant Deficiency
  • 391633 2023-006
    Significant Deficiency
  • 391634 2023-007
    Significant Deficiency
  • 391635 2023-007
    Significant Deficiency
  • 391636 2023-008
    Significant Deficiency
  • 391637 2023-008
    Significant Deficiency
  • 391638 2023-008
    Significant Deficiency
  • 391639 2023-010
    -
  • 968067 2023-004
    Material Weakness
  • 968068 2023-004
    Material Weakness
  • 968069 2023-004
    Material Weakness
  • 968070 2023-004
    Material Weakness
  • 968071 2023-004
    Material Weakness
  • 968072 2023-005
    Material Weakness
  • 968073 2023-005
    Material Weakness
  • 968074 2023-006
    Significant Deficiency
  • 968075 2023-006
    Significant Deficiency
  • 968076 2023-007
    Significant Deficiency
  • 968077 2023-007
    Significant Deficiency
  • 968078 2023-008
    Significant Deficiency
  • 968079 2023-008
    Significant Deficiency
  • 968080 2023-008
    Significant Deficiency
  • 968081 2023-010
    -

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $10.52M
84.063 Federal Pell Grant Program $4.17M
84.031 Higher Education_institutional Aid $804,354
84.007 Federal Supplemental Educational Opportunity Grants $516,103
84.047 Trio_upward Bound $512,136
84.033 Federal Work-Study Program $383,198
93.317 Emerging Infections Programs $335,646
84.042 Trio_student Support Services $299,220
84.120 Minority Science and Engineering Improvement $286,874
15.932 Preservation of Historic Structures on the Campuses of Historically Black Colleges and Universities (hbcus). $278,558
47.076 Education and Human Resources $241,588
84.425 Education Stabilization Fund $223,668
84.217 Trio_mcnair Post-Baccalaureate Achievement $187,534
45.313 Laura Bush 21st Century Librarian Program $81,812
84.335 Child Care Access Means Parents in School $79,262
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $49,093
89.003 National Historical Publications and Records Grants $40,027
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $36,767
17.268 H-1b Job Training Grants $36,165
97.061 Centers for Homeland Security $28,231
12.598 Centers for Academic Excellence $26,832
45.310 Grants to States $13,120
11.028 Connecting Minority Communities Pilot Program $6,306
45.162 Promotion of the Humanities_teaching and Learning Resources and Curriculum Development $5,272
93.859 Biomedical Research and Research Training $2,960
84.038 Federal Perkins Loan Program $0