Finding 31413 (2022-002)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-09-28

AI Summary

  • Core Issue: PRCI has a material weakness in internal controls over the preparation of the Schedule of Expenditures of Federal Awards (SEFA), leading to inconsistent reporting of federal expenditures.
  • Impacted Requirements: The SEFA must adhere to Uniform Guidance, requiring accurate accrual accounting for federal expenditures, which PRCI failed to implement effectively.
  • Recommended Follow-Up: PRCI should strengthen internal controls by designating one person to prepare the SEFA and another to review it for accuracy and completeness.

Finding Text

Finding No. 2022-002 Internal Control over Preparation of Schedule of Expenditures of Federal Awards (?SEFA?) ? Material Weakness in Internal Control over Compliance; U.S. Department of Transportation; Research and Development Cluster: PHMSA Pipeline Safety Research and Development; ALN #20.723; Various federal awards (see Schedule of Expenditures of Federal Awards) Criteria Uniform Guidance prescribes the required Schedule of Expenditures of Federal Awards (SEFA) contents and delineates how or what is deemed to be expenditures for purposes of completing the SEFA, including that the accrual basis of accounting be used in the preparation of the SEFA. Condition Over the course of PRCI?s federal awards with cost-share requirements, management recorded inconsistent amounts related to federal expenditures for the year ended December 31, 2022. Context The requirements of PRCI?s federal awards are such that costs are required to be incurred by PRCI in order to meet the deliverables identified in the related fixed price contracts with PHMSA. Initial amounts reported by PRCI on the SEFA corresponded with PRCI?s share of expenditures over its cost share requirement associated with its performance towards meeting the deliverables identified, resulting in a SEFA expense recognition that did not necessarily align with the period the expenses were incurred, as required by the accrual basis of accounting. This resulted in timing differences as to when federal expenditures and cost sharing were being recognized in any given fiscal year in relation to SEFA reporting. However, at the end of the respective contract periods, cost share requirements were met in full, but not always within the period of performance (see finding 2022-003 below). Cause PRCI did not have a systematic process in place to allocate federal expenditures and cost sharing over the contract period and failed to understand the need account for federal expenditures on the accrual basis regardless of when deliverables are met and invoiced under the contract. Effect A difference noted between reported federal expenditures against the cost share requirement could lead to awards being over or under drawn and not in compliance with respective awards. Questioned Costs None. Recommendation To ensure adequate internal controls over the preparation of the SEFA, we recommend that PRCI enhance internal controls over the preparation of the SEFA to ensure that it is prepared by one individual with another individual reviewing the underlying support to ensure completeness and accuracy. Views of Responsible Officials and Planned Corrective Actions See Corrective Action Plan

Corrective Action Plan

2022-002 Internal Control over Preparation of Schedule of Expenditures of Federal Awards (SEFA) United States Department of Transportation (?USDOT?) Auditor?s Recommendation: To ensure adequate internal controls over the preparation of the SEFA, we recommend that PRCI enhance internal controls over the preparation of the SEFA to ensure that it is prepared by one individual with another individual reviewing the underlying support to ensure completeness and accuracy. Explanation of disagreement with audit finding: There is no disagreement with audit finding. Action taken in response to finding: PRCI has implemented a new accounting system in 2023, which tracks the expenses relating the federal awards and expenditures and automatically creates a SEFA. This will allow for a cleaner preparation and review of the SEFA.

Categories

Reporting Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 31414 2022-003
    Material Weakness
  • 607855 2022-002
    Material Weakness
  • 607856 2022-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
20.723 Phmsa Pipeline Safety Research and Development Oother Transaction Agreementso $1.27M