Finding 400748 (2023-001)

Significant Deficiency
Requirement
A
Questioned Costs
-
Year
2023
Accepted
2024-06-13

AI Summary

  • Core Issue: BRIT used an incorrect indirect cost rate, leading to an overclaim of $645 on federal awards.
  • Impacted Requirements: Compliance with 2 CFR section 200.303(a) regarding effective internal controls over federal awards.
  • Recommended Follow-Up: Repay or credit the $645 to NSF and enhance internal controls to prevent future errors before invoicing.

Finding Text

2023-001 Activities Allowed or Unallowed, Allowable Costs/ Cost Principles – Indirect Costs Cluster: Research and Development Cluster Grantor: National Science Foundation Award Name: Various Award Year: Various Award Numbers: Various CFDA Numbers: Various Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States. Condition: BRIT applies its predetermined approved facilities and administrative rate when charging indirect costs to federal awards rather than the 10% de minimis indirect cost rate as allowed under Uniform Guidance. During our testing of 55 indirect costs, 2 transactions did not calculate the correct indirect cost. Questioned costs: None Context: See Condition. Cause: The exception was caused by management human error in typing in the indirect percentage or formula. Effect: Incorrect allocation caused two transactions to which the incorrect rate was applied caused to over claim $645 of indirect cost. Recommendation: We recommend that the money is repaid or credited back to NSF: 1. Provide documentation supporting that it has repaid or otherwise credited the $645 of overcharged indirect costs for which it has agreed to reimburse NSF. 2. We recommend BRIT strengthen its existing internal controls over the review of grant expense to ensure indirect cost rates change and to take appropriate steps to avoid claiming unallowable indirect costs on NSF awards. Once NSF determines that the recommendations have been adequately addressed and the $645 costs have been resolved, this finding should be closed. Views of responsible officials: Management agrees with the finding. Corrective action plan: Management will strengthen existing internal control over the review of monthly accounting worksheet to ensure the formulas and percentage for indirect cost are accurate before invoicing federal entity. Implementation date: March 31, 2024. Responsible Person(s): Keri Barfield, CFO.

Corrective Action Plan

2023-001Activities Allowed or Unallowed, Allowable Costs/ Cost Principles – Indirect Costs 1. When posting each month-end numbers in the accounting worksheet, the Controller or Chief Financial Officer will verify that the formulas are accurate and display the correct information. This check will be completed on all the formulas used to determine not only the indirect but also the direct costs in the grant. 2. After this review and verification step has been completed, the Accounting I AR and Grants Admin will create the invoice and journal entries into the accounting system, QuickBooks. 3. The grant workbook will be locked at that time to ensure that the information is not mistakenly adjusted. 4. Before requesting the funds from the federal entity (ex. National Science Foundation) or the Subaward institution, the Accounting I AR and Grants Admin will review the worksheet and verify once more that the formulas are correct and the total requested matches the invoice in QuickBooks. Steps to correct an error(s) 1. Identification of the error and correct the formula. Example, if an error is found in the indirect cost calculation, the formula will be corrected to determine the actual costs that should have been collected. 2. A new column will be created in the accounting worksheet to track changes that are made to the original invoice. a. A new invoice will be created if funds need to be requested from the entity. b. A credit memo will be created if funds are owed. This will be applied to the following months request. c. If the invoice has not been paid by the Federal entity, a revised invoice can be created and submitted for payment.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 400749 2023-001
    Significant Deficiency
  • 400750 2023-001
    Significant Deficiency
  • 400751 2023-001
    Significant Deficiency
  • 400752 2023-001
    Significant Deficiency
  • 400753 2023-001
    Significant Deficiency
  • 400754 2023-001
    Significant Deficiency
  • 400755 2023-001
    Significant Deficiency
  • 400756 2023-001
    Significant Deficiency
  • 400757 2023-001
    Significant Deficiency
  • 977190 2023-001
    Significant Deficiency
  • 977191 2023-001
    Significant Deficiency
  • 977192 2023-001
    Significant Deficiency
  • 977193 2023-001
    Significant Deficiency
  • 977194 2023-001
    Significant Deficiency
  • 977195 2023-001
    Significant Deficiency
  • 977196 2023-001
    Significant Deficiency
  • 977197 2023-001
    Significant Deficiency
  • 977198 2023-001
    Significant Deficiency
  • 977199 2023-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
47.RD Nsf Philippines Biosurvey $253,519
47.RD Nsf Torch $237,668
47.RD Nsf Blueberry $135,739
47.RD Nsf Ferns of Columbia $81,914
47.RD Nsf Carlquist $42,330
47.RD Nsf All Asian $39,970
47.RD Nsf Ironweeds $28,323
45.RD Imls $28,052
47.RD Nsf Sundue $18,926
15.657 Endangered Species Conservation Ð Recovery Implementation Funds $17,880
10.326 Capacity Building for Non-Land Grant Colleges of Agriculture (nlgca) $7,079
47.RD Nsf Ferns Tcn $-111
47.RD Nsf Endless Forms Tcn $-376