Finding 817 (2022-005)

Material Weakness
Requirement
C
Questioned Costs
-
Year
2022
Accepted
2023-10-27

AI Summary

  • Core Issue: NGA Center failed to provide necessary documentation for cash drawdown requests, leading to non-compliance with Federal requirements.
  • Impacted Requirements: Internal controls under 2 CFR Section 200.303 and documentation standards in 2 CFR Section 200.305(b)(3) were not met.
  • Recommended Follow-Up: NGA Center should enhance internal controls and ensure timely and accurate requests for Federal funds as per grant agreements.

Finding Text

2022-005 - Internal Control Over Compliance and Compliance – Cash Management Program- U.S. Department of Energy, Environmental Monitoring/Cleanup, Cultural and Resource Management Emergency Response Research, Outreach, Technical Analysis ALN: 81.214, Award #: DE-EM0005173, Award Year: 04/23/2018 – 06/30/2023 Program- U.S. Department of Health and Human Services, Strengthening Public Health Systems and Services through National Partnerships to Improve and Protect the Nation’s Health ALN: 93.421, Award #: Various, Award Year: 08/01/2018 – 07/31/2023 Criteria - The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR Section 200.305(b)(3), for non-Federal entities funded under the reimbursement method, reimbursement requests should be supported by documentation to verify that the entity paid for the costs for which reimbursement was requested prior to the date of the reimbursement request. Condition – During our cash management testing for major program ALN 81.214, we noted the following: • For three (3) out of four (4) samples selected for testing, NGA Center was unable to provide documentation showing review and approval of the cash drawdown requests. • For one (1) out of four (4) sample selected for testing, NGA Center was unable to provide the supporting calculation of the cash drawdown request. • In addition, expenditures reflected in the cash drawdown requests were not reconciled with the general ledger. For the first three quarters of fiscal year 2022, the compensated absences and fringe benefits were included in the cash drawdown requests, however, NGA Center did not record the transactions in the general ledger during those quarters. Also, certain contractual services recorded in the general ledger during the last quarter of fiscal year 2022 were excluded on the cash drawdown request. During our cash management testing for major program ALN 93.421, we noted the following: • For two (2) out of two (2) samples selected for testing, NGA Center was unable to provide documentation showing review and approval of the cash drawdown requests. • For one (1) out of two (2) samples selected for testing, NGA Center was unable to provide the supporting calculation of the cash drawdown request. • In addition, expenditures reflected in the cash drawdown requests are not reconciled with the general ledger. During the first half of fiscal year 2022, compensated absences and fringe benefits were included in the cash drawdown request, however, NGA Center did not record the transactions in the general ledger during that period. Also, certain contractual services recorded in the general ledger during the last three quarters were excluded on the cash drawdown requests. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with the provisions of the grant agreements and general compliance principles. Cause – NGA Center did not appear to exercise due diligence in requesting Federal funds consistent with the grant agreements and its actual cash needs. Effect – NGA Center is not in compliance with the stated provisions. The opportunity to use the money for other immediate cash needs is unnecessarily delayed when funds are not requested timely. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center comply with the provisions of the grant agreements and request Federal funds consistent with the grant agreement funding techniques and clearance patterns for these programs. Views of Responsible Officials – NGA Center agrees with the finding and recommendations of this finding set forth within and has developed a corrective action plan to address the lapse in the prescribed internal controls.

Corrective Action Plan

2022-005- Internal Control Over Compliance and Compliance – Cash Management Contact: Jordan Kramer Title: Chief Financial Officer Phone Number: 202-624-7787 Anticipated Completion Date: June 2024 Management’s Corrective Action Plan:NGA has developed procedures to capture all required documentation during the federal disbursement request process. Staff were informed in January 2023 of the requirements for federal drawdown documentation and the CFO proceeded with a desk audit of compliance for the first and second quarter of fiscal year 2023 in April 2023. The CFO will continue to monitor compliance and adequate document retention in the second half of the fiscal year and provide training to staff when documents are not available in shared drive folders. We will also implement a regular review of the SEFA beginning in September 2023 and use that review to ensure that revenue and cash transactions correspond to the expense reports they were based on.

Categories

Cash Management

Other Findings in this Audit

  • 809 2022-004
    Material Weakness
  • 810 2022-004
    Material Weakness
  • 811 2022-004
    Material Weakness
  • 812 2022-004
    Material Weakness
  • 813 2022-004
    Material Weakness
  • 814 2022-004
    Material Weakness
  • 815 2022-004
    Material Weakness
  • 816 2022-004
    Material Weakness
  • 818 2022-005
    Material Weakness
  • 819 2022-005
    Material Weakness
  • 820 2022-005
    Material Weakness
  • 821 2022-005
    Material Weakness
  • 822 2022-005
    Material Weakness
  • 823 2022-005
    Material Weakness
  • 824 2022-005
    Material Weakness
  • 825 2022-006
    Material Weakness
  • 826 2022-006
    Material Weakness
  • 827 2022-006
    Material Weakness
  • 828 2022-006
    Material Weakness
  • 829 2022-006
    Material Weakness
  • 830 2022-006
    Material Weakness
  • 831 2022-006
    Material Weakness
  • 832 2022-006
    Material Weakness
  • 577251 2022-004
    Material Weakness
  • 577252 2022-004
    Material Weakness
  • 577253 2022-004
    Material Weakness
  • 577254 2022-004
    Material Weakness
  • 577255 2022-004
    Material Weakness
  • 577256 2022-004
    Material Weakness
  • 577257 2022-004
    Material Weakness
  • 577258 2022-004
    Material Weakness
  • 577259 2022-005
    Material Weakness
  • 577260 2022-005
    Material Weakness
  • 577261 2022-005
    Material Weakness
  • 577262 2022-005
    Material Weakness
  • 577263 2022-005
    Material Weakness
  • 577264 2022-005
    Material Weakness
  • 577265 2022-005
    Material Weakness
  • 577266 2022-005
    Material Weakness
  • 577267 2022-006
    Material Weakness
  • 577268 2022-006
    Material Weakness
  • 577269 2022-006
    Material Weakness
  • 577270 2022-006
    Material Weakness
  • 577271 2022-006
    Material Weakness
  • 577272 2022-006
    Material Weakness
  • 577273 2022-006
    Material Weakness
  • 577274 2022-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.528 National Forum for State and Territorial Chief Executives: Hhs Oa, Yr 10 Adn Yr 11, National Forum $566,329
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health:suicide Opioids Misuse Prevention $520,834
93.421 Strengthening Public Health Systems and Services Through Lowering Opioid Overdose Risk for Justice-Involved Populations; Building State and Institutional Capacity $326,942
81.214 Environmental Monitoring/cleanup, Cultural and Resource Mgmt., Emergency Response Research, Outreach, Technical Analysis $233,528
81.122 Electricity Delivery and Energy Reliability, Research, Development and Analysis:programmatic Collaboration and Coordination with Governors, Cr $212,894
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health: Diabetes $189,298
93.421 Strengthening Public Health Systems and Services Through Informing State Leaders on Effective Policies and Systems Strategies for Enhancing Infectious Disease Surveillance $188,702
81.122 Electricity Research, Development and Analysis:programmatic Collaboration and Coordination with State Governors, Oe $160,022
97.132 Financial Assistance for Countering Violent Extremism $150,829
81.122 Electricity Research, Development and Analysis: Infrastructure Security and Energy Restoration (iser) $148,975
81.122 Electricity Research, Development and Analysis: Transmission Permitting and Technical Assistance (tpta) $137,330
12.615 Research and Technical Assistance $134,060
16.738 Edward Byrne Memorial Justice Assistance Grant Program $126,222
97.007 Homeland Security Preparedness Technical Assistance Program $111,917
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health:engaging Governors to Strengthen Vaccines Confidence $84,310
16.838 Comprehensive Opioid Abuse Site-Based Program $70,422
81.121 Office of Nuclear Energy Coordination with State Governors for Office of Nuclear Energy $67,120
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health: Public Health Emergency Preparedness and Response $62,017
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health: Engaging State Leadership and Entities to Address Unintentional Injury Topics $57,638
17.U01 Expanding Community College Apprenticeships $53,127
17.268 H-1b Job Training Grants: Usdol Eta American Apprenticeship Initiative Recipient $12,552
16.827 Data Lead Governance $9,159
16.321 Crime Victim Assistance/discretionary Grants Continuation $793