Finding 563618 (2024-002)

-
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-06-03
Audit: 357905
Organization: Civil Air Patrol (AL)

AI Summary

  • Core Issue: CAP submitted an inventory report with items incorrectly listed as federally owned due to a funding code error in ORMS.
  • Impacted Requirements: Non-compliance with 2 CFR 200.312(a) regarding annual inventory reporting of federally owned property.
  • Recommended Follow-Up: Enhance grant reporting procedures with independent reviews of equipment management data and implement comparative reports for accuracy in title holder and funding source codes.

Finding Text

Information on the federal program: United States Airforce, Assistance listing # 12.840 Civil Air Patrol Program Criteria: 2 CFR 200.312(a) establishes that the recipient must submit an inventory listing of federally owned property in its custody to the federal agency on an annual basis. Condition: The Tangible Personal Property Report (SF-428) requires the recipient to submit an inventory listing of federally owned property in its custody to the federal agency annually. CAP provides the required listing from its ORMS database. Two of the items tested within the report were owned by CAP and not federally owned. Ownership was properly reflected in Navision and incorrectly reflected in ORMS. Cause: An incorrect source funding code was assigned in ORMS. This assignment was not subject to an effective review. Effect: CAP was not in compliance with all applicable reporting requirements. Questioned Costs: None reported. Recommendation: We recommend CAP strengthen its policies and procedures surrounding grant reporting to include a review of each component of CAP’s equipment management system for accuracy with respect to title holder and funding source code. All updates to a component of the system should be reviewed for accuracy by someone other than the preparer. Comparative reports between the components of the system for title holder and funding source code should be included in the annual reconciliation process. These reports should be generated before and after the reconciliation process to ensure the identified activity was posted correctly. All reports should be reviewed and approved by someone other than the preparer. Views of Responsible Officials: Management agrees with the finding. See Corrective Action Plan included at the end of the report.

Corrective Action Plan

We concur with the finding and are implementing procedures to address all issues. The SF-428 is completed by Logistics utilizing data from ORMS. The report is meant to include only federally owned assets. Assets purchased by CAP with federal funds are not federally owned and should not be included in the report. Items are entered into ORMS manually and the funding source is chosen from a drop-down menu. Two vehicles were entered in fiscal year 2024, and the incorrect funding source was chosen from the drop-down menu. The correct option was right below the option chosen. The items were corrected when found during the audit. FM will work with Logistics to ensure all capitalized assets added during the fiscal year are reviewed for the correct funding source. We will review this as part of the cost review throughout the year. We will also request that a pop up or some other messaging be added to ORMS to alert the individual entering items to double check that the correct fund source has been chosen. We will implement the reviews in May 2025.

Categories

Equipment & Real Property Management Reporting

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
12.840 Civil Air Patrol Program $87.22M