Audit 1570

FY End
2022-06-30
Total Expended
$3.66M
Findings
48
Programs
23
Year: 2022 Accepted: 2023-10-27
Auditor: Bdo USA PC

Organization Exclusion Status:

Checking exclusion status...

Findings

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

Programs

ALN Program Spent Major Findings
93.528 National Forum for State and Territorial Chief Executives: Hhs Oa, Yr 10 Adn Yr 11, National Forum $566,329 - 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health:suicide Opioids Misuse Prevention $520,834 Yes 3
93.421 Strengthening Public Health Systems and Services Through Lowering Opioid Overdose Risk for Justice-Involved Populations; Building State and Institutional Capacity $326,942 Yes 3
81.214 Environmental Monitoring/cleanup, Cultural and Resource Mgmt., Emergency Response Research, Outreach, Technical Analysis $233,528 Yes 3
81.122 Electricity Delivery and Energy Reliability, Research, Development and Analysis:programmatic Collaboration and Coordination with Governors, Cr $212,894 - 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health: Diabetes $189,298 Yes 3
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 Yes 3
81.122 Electricity Research, Development and Analysis:programmatic Collaboration and Coordination with State Governors, Oe $160,022 - 0
97.132 Financial Assistance for Countering Violent Extremism $150,829 - 0
81.122 Electricity Research, Development and Analysis: Infrastructure Security and Energy Restoration (iser) $148,975 - 0
81.122 Electricity Research, Development and Analysis: Transmission Permitting and Technical Assistance (tpta) $137,330 - 0
12.615 Research and Technical Assistance $134,060 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $126,222 - 0
97.007 Homeland Security Preparedness Technical Assistance Program $111,917 - 0
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 Yes 3
16.838 Comprehensive Opioid Abuse Site-Based Program $70,422 - 0
81.121 Office of Nuclear Energy Coordination with State Governors for Office of Nuclear Energy $67,120 - 0
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 Yes 3
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 Yes 3
17.U01 Expanding Community College Apprenticeships $53,127 - 0
17.268 H-1b Job Training Grants: Usdol Eta American Apprenticeship Initiative Recipient $12,552 - 0
16.827 Data Lead Governance $9,159 - 0
16.321 Crime Victim Assistance/discretionary Grants Continuation $793 - 0

Contacts

Name Title Type
T2B7XG7JGRM6 Jordan Kramer Auditee
2026247787 Andy Afuang Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The reimbursement of indirect costs reflected in the accompanying financial statements as federal grants revenue is subject to final approval by federal grantors and could be adjustment upon the results of these reviews. Management believes that the results of any such adjustment will not be material to the NGA Centers financial position or change in net assets. De Minimis Rate Used: N Rate Explanation: NGA Center has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of NGA Center under programs of the federal government for the year ended June 30, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of NGA Center, it is not intended to and does not present the financial position, changes in net assets, or cash flows of NGA Center. NGA receives no federal assistance; therefore, all information in the schedule relates to NGA Center. There were no funds subgranted to subrecipients during the year ended June 30, 2022.
Title: Reconciliation to the Consolidated Financial Statements Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The reimbursement of indirect costs reflected in the accompanying financial statements as federal grants revenue is subject to final approval by federal grantors and could be adjustment upon the results of these reviews. Management believes that the results of any such adjustment will not be material to the NGA Centers financial position or change in net assets. De Minimis Rate Used: N Rate Explanation: NGA Center has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. For the year ended June 30, 2022, NGA Center recognized $3,657,049 of revenue from federal/pass-through grants which is included in the federal grants and contracts and registration fees (for program income) in the consolidated statement of activities. NGA Center recognizes federal revenue based on allowable direct and indirect costs incurred. Federal expenditures are allocated on a functional basis within the consolidated statement of activities.

Finding Details

2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
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.
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.
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.
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.
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.
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.
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.
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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
2022-004 – Internal Control Over Compliance and Compliance - Activities Allowed or Unallowed and Allowable Costs/Cost Principles 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. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430(i): “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; (vi) [Reserved] (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition – During our payroll disbursement testing for major program ALN 81.214, we noted that for one (1) out of eight (8) samples for testing, there was no proper review on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. During our payroll disbursement testing for major program ALN 93.421, forty (40) samples were selected for testing. We noted the following: • For two (2) samples, the project codes used to record the payroll expense in the general ledger were not the same as the project codes entered by the employees in the timesheets. • For one (1) sample, the project code used to record the payroll expense in the general ledger was not found in the timesheet. • For one (1) sample, the hours used to record payroll expense in the general ledger did not agree with the hours entered by the employee in the timesheet. • For one (1) sample, there were two different salary rates used for regular hours worked by the employee. • For six (6) samples, there was no proper review process on the calculation of compensated absences and fringe benefits. In particular, the expense calculation was prepared, reviewed and approved by only one individual, the CFO. Questioned Costs – Not determinable. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample. Cause – NGA Center is not adhering to the internal control policies and procedures to ensure that payroll costs are in accordance with the time and effort reporting requirements. NGA Center does not have procedures in place to ensure adequate documentation that the hours entered in the timesheet are correctly charged to the project codes. Effect – NGA Center was unable to provide documentation to demonstrate that the payroll expenditures charged to the programs accurately reflected the actual time incurred on the programs and whether they were properly supported in accordance with 2 CFR Part 200.430 Compensation-personal service.These errors resulted in incorrect amounts charged to the Federal programs. Repeat Finding – This is not a repeat finding.   Recommendation – We recommend that NGA Center improve internal controls over the review of timesheets and hours charged to the grants, including the maintenance of adequate records and documentation. In addition, we recommend improvement on the preparation and review of compensated absences and fringe benefits. The preparation and review should be performed by different individuals to reduce the risk of both erroneous and inappropriate actions. 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.
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.
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.
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.
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.
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.
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.
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.
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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.
2022-006 - Internal Control Over Compliance and Compliance – Reporting 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. Per grant agreement for major program ALN 81.214, NGA Center is required to prepare and submit progress reports and financial reports (SF-425 Federal Financial Report) on a quarterly basis. Per grant agreement for major program 93.421, NGA Center is required to prepare and submit progress report (Performance Progress and Monitoring Report) and financial report (SF-425 Federal Financial Report) every year. Condition – During our reporting requirement testing for major program ALN 81.214, we noted the following: • For two (2) out of two (2) quarterly financial reports selected for testing, NGA Center was not able to provide the completed and final version of the Federal Financial Report (SF-425) with the submitted date information, thus, BDO was not able to verify the timely submission of the reports. Also, for one (1) of the quarterly SF-425, there was no evidence of submission to the Federal agency. • For one (1) out of two (2) quarterly progress report selected for testing, NGA Center was unable to provide a copy of the report, including the evidence of submission of the report to the Federal agency. During our reporting requirement testing for major program ALN 93.421, we noted the following: • There is no evidence of review and approval for both annual Federal Financial Report and annual Performance Progress and Monitoring Report prior to submission to the Federal agency. • Also, both annual Federal Financial Report and annual Performance Progress and Monitoring Report were submitted late to the Federal Agency. Questioned Costs – None. Context – This is a condition identified per review of NGA Center’s compliance with specified requirements using a statistically valid sample and with the provisions of the grant agreements. Cause – Management did not have proper internal controls and policies and procedures in place over the review, approval and submission of the required reporting requirements. Effect – Without proper internal controls and policies and procedures in place over the review and approval of the required quarterly and annual financial and progress reports, NGA Center was not able to demonstrate compliance to reporting requirements, including submission and review and approval of the reports. Repeat Finding – This is not a repeat finding. Recommendation - We recommend that NGA Center strengthen its policies, procedures and controls over the review and approval of the required quarterly and annual financial and progress reports, to ensure compliance with the grant requirements and ensure the amounts reported are accurate. We also recommend that the submitted reports and supporting documentation be maintained for a prescribed period. 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.