Finding 502167 (2020-004)

Significant Deficiency
Requirement
A
Questioned Costs
-
Year
2020
Accepted
2024-10-10

AI Summary

  • Core Issue: Payroll approvals are not consistently made by supervisors or knowledgeable individuals, leading to potential mismanagement of federal funds.
  • Impacted Requirements: This violates 2 CFR 200.303, which mandates effective internal controls for compliance with federal award management.
  • Recommended Follow-Up: AAPT should assign appropriate payroll approvers who are familiar with employee activities, with changes expected by 04/01/2024.

Finding Text

Finding 2020-004: Payroll Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1500529 (9/1/2015 – 8/31/2022), 1624185 (9/16/2016 – 8/31/2022), 1726113 (8/1/2017 – 9/30/2023) Significant Deficiency in Internal Controls Over Compliance, Other matters Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): As noted in 2 CFR 200.303 “The non-Federal entity must 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” Condition: Payroll approvals for individuals are not always made by individuals who are the employee’s supervisors or are otherwise knowledgeable about their level of effort during the payroll periods paid for. Of the 25 individual payroll payments tested to 5 separate individuals, totaling $40,904 charged to federal grants, we identified 16 total payments to 4 separate individuals, totaling $16,226, where the timesheet was approved by the CFO, who we do not consider to be knowledgeable of the employee’s activities during a given pay period. One of these four individuals was a full-time employee and the other three were part-time employees. Cause: AAPT did not appropriately assign or ensure approval by payroll approvers based on who supervised or was otherwise knowledgeable of employee activity on federal grants. Effect or Potential Effect: Without an individual knowledgeable of an individual employee’s level of effort approving the time charged there is a greater risk that payroll payments are applied to a federal grant improperly, or leave is otherwise improperly omitted or overapplied to the individual’s leave balance. Questioned Costs: None noted. Identification as a Repeat Finding, if Applicable: Not a repeat finding. Recommendation: We recommend that AAPT change the designated approver for certain employees for whom the designated approver is not the employee’s supervisor or is not otherwise aware of the employee’s work efforts. Views of Responsible Officials and Planned Corrective Actions: AAPT has made changes to correctly reflect the employee’s assigned supervisor based on the position and job duties of the employees. Anticipated Completion Date: 04/01/2024 Responsible Official: Michael Brosnan, CFO

Categories

Matching / Level of Effort / Earmarking Significant Deficiency

Other Findings in this Audit

  • 502144 2020-001
    Significant Deficiency
  • 502145 2020-002
    Material Weakness Repeat
  • 502146 2020-005
    Significant Deficiency Repeat
  • 502147 2020-001
    Significant Deficiency
  • 502148 2020-002
    Material Weakness Repeat
  • 502149 2020-005
    Significant Deficiency Repeat
  • 502150 2020-001
    Significant Deficiency
  • 502151 2020-002
    Material Weakness Repeat
  • 502152 2020-004
    Significant Deficiency
  • 502153 2020-005
    Significant Deficiency Repeat
  • 502154 2020-001
    Significant Deficiency
  • 502155 2020-002
    Material Weakness Repeat
  • 502156 2020-004
    Significant Deficiency
  • 502157 2020-005
    Significant Deficiency Repeat
  • 502158 2020-001
    Significant Deficiency
  • 502159 2020-002
    Material Weakness Repeat
  • 502160 2020-005
    Significant Deficiency Repeat
  • 502161 2020-006
    Significant Deficiency Repeat
  • 502162 2020-001
    Significant Deficiency
  • 502163 2020-002
    Material Weakness Repeat
  • 502164 2020-005
    Significant Deficiency Repeat
  • 502165 2020-001
    Significant Deficiency
  • 502166 2020-002
    Material Weakness Repeat
  • 502168 2020-005
    Significant Deficiency Repeat
  • 502169 2020-001
    Significant Deficiency
  • 502170 2020-002
    Material Weakness Repeat
  • 502171 2020-005
    Significant Deficiency Repeat
  • 502172 2020-001
    Significant Deficiency
  • 502173 2020-002
    Material Weakness Repeat
  • 502174 2020-005
    Significant Deficiency Repeat
  • 502175 2020-001
    Significant Deficiency
  • 502176 2020-002
    Material Weakness Repeat
  • 502177 2020-003
    Material Weakness Repeat
  • 502178 2020-005
    Significant Deficiency Repeat
  • 502179 2020-001
    Significant Deficiency
  • 502180 2020-002
    Material Weakness Repeat
  • 502181 2020-003
    Material Weakness Repeat
  • 502182 2020-005
    Significant Deficiency Repeat
  • 502183 2020-001
    Significant Deficiency
  • 502184 2020-002
    Material Weakness Repeat
  • 502185 2020-005
    Significant Deficiency Repeat
  • 502186 2020-001
    Significant Deficiency
  • 502187 2020-002
    Material Weakness Repeat
  • 502188 2020-005
    Significant Deficiency Repeat
  • 502189 2020-001
    Significant Deficiency
  • 502190 2020-002
    Material Weakness Repeat
  • 502191 2020-005
    Significant Deficiency Repeat
  • 502192 2020-001
    Significant Deficiency
  • 502193 2020-002
    Material Weakness Repeat
  • 502194 2020-005
    Significant Deficiency Repeat
  • 502195 2020-001
    Significant Deficiency
  • 502196 2020-002
    Material Weakness Repeat
  • 502197 2020-005
    Significant Deficiency Repeat
  • 502198 2020-001
    Significant Deficiency
  • 502199 2020-002
    Material Weakness Repeat
  • 502200 2020-005
    Significant Deficiency Repeat
  • 502201 2020-001
    Significant Deficiency
  • 502202 2020-002
    Material Weakness Repeat
  • 502203 2020-005
    Significant Deficiency Repeat
  • 1078586 2020-001
    Significant Deficiency
  • 1078587 2020-002
    Material Weakness Repeat
  • 1078588 2020-005
    Significant Deficiency Repeat
  • 1078589 2020-001
    Significant Deficiency
  • 1078590 2020-002
    Material Weakness Repeat
  • 1078591 2020-005
    Significant Deficiency Repeat
  • 1078592 2020-001
    Significant Deficiency
  • 1078593 2020-002
    Material Weakness Repeat
  • 1078594 2020-004
    Significant Deficiency
  • 1078595 2020-005
    Significant Deficiency Repeat
  • 1078596 2020-001
    Significant Deficiency
  • 1078597 2020-002
    Material Weakness Repeat
  • 1078598 2020-004
    Significant Deficiency
  • 1078599 2020-005
    Significant Deficiency Repeat
  • 1078600 2020-001
    Significant Deficiency
  • 1078601 2020-002
    Material Weakness Repeat
  • 1078602 2020-005
    Significant Deficiency Repeat
  • 1078603 2020-006
    Significant Deficiency Repeat
  • 1078604 2020-001
    Significant Deficiency
  • 1078605 2020-002
    Material Weakness Repeat
  • 1078606 2020-005
    Significant Deficiency Repeat
  • 1078607 2020-001
    Significant Deficiency
  • 1078608 2020-002
    Material Weakness Repeat
  • 1078609 2020-004
    Significant Deficiency
  • 1078610 2020-005
    Significant Deficiency Repeat
  • 1078611 2020-001
    Significant Deficiency
  • 1078612 2020-002
    Material Weakness Repeat
  • 1078613 2020-005
    Significant Deficiency Repeat
  • 1078614 2020-001
    Significant Deficiency
  • 1078615 2020-002
    Material Weakness Repeat
  • 1078616 2020-005
    Significant Deficiency Repeat
  • 1078617 2020-001
    Significant Deficiency
  • 1078618 2020-002
    Material Weakness Repeat
  • 1078619 2020-003
    Material Weakness Repeat
  • 1078620 2020-005
    Significant Deficiency Repeat
  • 1078621 2020-001
    Significant Deficiency
  • 1078622 2020-002
    Material Weakness Repeat
  • 1078623 2020-003
    Material Weakness Repeat
  • 1078624 2020-005
    Significant Deficiency Repeat
  • 1078625 2020-001
    Significant Deficiency
  • 1078626 2020-002
    Material Weakness Repeat
  • 1078627 2020-005
    Significant Deficiency Repeat
  • 1078628 2020-001
    Significant Deficiency
  • 1078629 2020-002
    Material Weakness Repeat
  • 1078630 2020-005
    Significant Deficiency Repeat
  • 1078631 2020-001
    Significant Deficiency
  • 1078632 2020-002
    Material Weakness Repeat
  • 1078633 2020-005
    Significant Deficiency Repeat
  • 1078634 2020-001
    Significant Deficiency
  • 1078635 2020-002
    Material Weakness Repeat
  • 1078636 2020-005
    Significant Deficiency Repeat
  • 1078637 2020-001
    Significant Deficiency
  • 1078638 2020-002
    Material Weakness Repeat
  • 1078639 2020-005
    Significant Deficiency Repeat
  • 1078640 2020-001
    Significant Deficiency
  • 1078641 2020-002
    Material Weakness Repeat
  • 1078642 2020-005
    Significant Deficiency Repeat
  • 1078643 2020-001
    Significant Deficiency
  • 1078644 2020-002
    Material Weakness Repeat
  • 1078645 2020-005
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
47.049 Mathematical and Physical Sciences $10,562
47.076 Education and Human Resources $6,442
43.001 Science $4,172