Finding 480780 (2020-003)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2020
Accepted
2024-08-09

AI Summary

  • Core Issue: Year-end schedules for federal grants were not reconciled, leading to inaccuracies in financial statements.
  • Impacted Requirements: Non-compliance with 2 CFR 200.508 and 2 CFR 200.510 regarding proper financial management and reporting of federal awards.
  • Recommended Follow-up: AAPT staff should prepare and review schedules for accuracy, with oversight from a supervisor to prevent future discrepancies.

Finding Text

Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO

Corrective Action Plan

Finding 2020-003: Reconciliation of Accounts Federal Program: Research and Development Cluster: 47.076 Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO

Categories

Material Weakness Reporting Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 480781 2020-005
    Significant Deficiency Repeat
  • 480782 2020-003
    Material Weakness Repeat
  • 480783 2020-005
    Significant Deficiency Repeat
  • 480784 2020-003
    Material Weakness Repeat
  • 480785 2020-004
    Significant Deficiency
  • 480786 2020-005
    Significant Deficiency Repeat
  • 480787 2020-003
    Material Weakness Repeat
  • 480788 2020-004
    Significant Deficiency
  • 480789 2020-005
    Significant Deficiency Repeat
  • 480790 2020-003
    Material Weakness Repeat
  • 480791 2020-005
    Significant Deficiency Repeat
  • 480792 2020-006
    Significant Deficiency Repeat
  • 480793 2020-003
    Material Weakness Repeat
  • 480794 2020-005
    Significant Deficiency Repeat
  • 480795 2020-003
    Material Weakness Repeat
  • 480796 2020-004
    Significant Deficiency
  • 480797 2020-005
    Significant Deficiency Repeat
  • 480798 2020-003
    Material Weakness Repeat
  • 480799 2020-005
    Significant Deficiency Repeat
  • 480800 2020-003
    Material Weakness Repeat
  • 480801 2020-005
    Significant Deficiency Repeat
  • 480802 2020-003
    Material Weakness Repeat
  • 480803 2020-005
    Significant Deficiency Repeat
  • 480804 2020-003
    Material Weakness Repeat
  • 480805 2020-005
    Significant Deficiency Repeat
  • 480806 2020-003
    Material Weakness Repeat
  • 480807 2020-005
    Significant Deficiency Repeat
  • 480808 2020-003
    Material Weakness Repeat
  • 480809 2020-005
    Significant Deficiency Repeat
  • 480810 2020-003
    Material Weakness Repeat
  • 480811 2020-005
    Significant Deficiency Repeat
  • 480812 2020-003
    Material Weakness Repeat
  • 480813 2020-005
    Significant Deficiency Repeat
  • 480814 2020-005
    Significant Deficiency Repeat
  • 480815 2020-005
    Significant Deficiency Repeat
  • 480816 2020-005
    Significant Deficiency Repeat
  • 1057222 2020-003
    Material Weakness Repeat
  • 1057223 2020-005
    Significant Deficiency Repeat
  • 1057224 2020-003
    Material Weakness Repeat
  • 1057225 2020-005
    Significant Deficiency Repeat
  • 1057226 2020-003
    Material Weakness Repeat
  • 1057227 2020-004
    Significant Deficiency
  • 1057228 2020-005
    Significant Deficiency Repeat
  • 1057229 2020-003
    Material Weakness Repeat
  • 1057230 2020-004
    Significant Deficiency
  • 1057231 2020-005
    Significant Deficiency Repeat
  • 1057232 2020-003
    Material Weakness Repeat
  • 1057233 2020-005
    Significant Deficiency Repeat
  • 1057234 2020-006
    Significant Deficiency Repeat
  • 1057235 2020-003
    Material Weakness Repeat
  • 1057236 2020-005
    Significant Deficiency Repeat
  • 1057237 2020-003
    Material Weakness Repeat
  • 1057238 2020-004
    Significant Deficiency
  • 1057239 2020-005
    Significant Deficiency Repeat
  • 1057240 2020-003
    Material Weakness Repeat
  • 1057241 2020-005
    Significant Deficiency Repeat
  • 1057242 2020-003
    Material Weakness Repeat
  • 1057243 2020-005
    Significant Deficiency Repeat
  • 1057244 2020-003
    Material Weakness Repeat
  • 1057245 2020-005
    Significant Deficiency Repeat
  • 1057246 2020-003
    Material Weakness Repeat
  • 1057247 2020-005
    Significant Deficiency Repeat
  • 1057248 2020-003
    Material Weakness Repeat
  • 1057249 2020-005
    Significant Deficiency Repeat
  • 1057250 2020-003
    Material Weakness Repeat
  • 1057251 2020-005
    Significant Deficiency Repeat
  • 1057252 2020-003
    Material Weakness Repeat
  • 1057253 2020-005
    Significant Deficiency Repeat
  • 1057254 2020-003
    Material Weakness Repeat
  • 1057255 2020-005
    Significant Deficiency Repeat
  • 1057256 2020-005
    Significant Deficiency Repeat
  • 1057257 2020-005
    Significant Deficiency Repeat
  • 1057258 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