Finding 11011 (2019-001)

Material Weakness
Requirement
C
Questioned Costs
-
Year
2019
Accepted
2024-01-31

AI Summary

  • Core Issue: Transitioning from Dynamics 365 to Sage Intacct may have led to incomplete reconciliations in the older system.
  • Impacted Requirements: Compliance with 2 CFR 200 and NSF requirements is essential for maintaining an auditable grant management system.
  • Recommended Follow-Up: Ensure that monthly reconciliations are consistently performed and documented from 2022 onward under the new management's internal control systems.

Finding Text

Current management concurred with the conditions, criteria, causes, and recommendations cited by the auditors. Having to reconstruct the books and transitioning into a new Accounting System; Dynamics 365 was transitioned to Sage Intacct from 2019 forward in order to implement an auditable grant management system and an improved internal control system. In this process, the detailed reconciliations may have been abandoned in the older accounting system. The transition of new management in early 2023 has now implemented these internal control systems and monthly reconciliations from 2022 and forward in order to comply with 2 CFR 200 and NSF requirements.

Corrective Action Plan

Current management concurred with the conditions, criteria, causes, and recommendations cited by the auditors. Having to reconstruct the books and transitioning into a new Accounting System; Dynamics 365 was transitioned to Sage Intacct from 2019 forward in order to implement an auditable grant management system and an improved internal control system. In this process, the detailed reconciliations may have been abandoned in the older accounting system. The transition of new management in early 2023 has now implemented these internal control systems and monthly reconciliations from 2022 and forward in order to comply with 2 CFR 200 and NSF requirements.

Categories

Internal Control / Segregation of Duties

Other Findings in this Audit

  • 11012 2019-002
    Material Weakness
  • 11013 2019-003
    Material Weakness
  • 11014 2019-004
    Material Weakness
  • 11015 2019-005
    Material Weakness
  • 11016 2019-006
    Material Weakness
  • 11017 2019-007
    Material Weakness
  • 11018 2019-008
    Material Weakness
  • 11019 2019-009
    Material Weakness
  • 11020 2019-010
    Material Weakness
  • 11021 2019-011
    Material Weakness
  • 587453 2019-001
    Material Weakness
  • 587454 2019-002
    Material Weakness
  • 587455 2019-003
    Material Weakness
  • 587456 2019-004
    Material Weakness
  • 587457 2019-005
    Material Weakness
  • 587458 2019-006
    Material Weakness
  • 587459 2019-007
    Material Weakness
  • 587460 2019-008
    Material Weakness
  • 587461 2019-009
    Material Weakness
  • 587462 2019-010
    Material Weakness
  • 587463 2019-011
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
47.050 Geosciences $1.45M
47.080 Office of Cyberinfrastructure $80,192
47.083 Integrative Activities $28,517
47.079 Office of Internal Science and Engineering $13,688
47.070 Computer and Information Science Engineering $9,122
47.070 Computer and Information Science and Engineering $4,346