Finding 12313 (2022-002)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-04-26

AI Summary

  • Core Issue: The Organization's Excel template for quarterly reporting is missing key elements required by the USDA's Form RD-442-2.
  • Impacted Requirements: Specific columns and rows from Schedule 1, as well as Board information from the Letter of Conditions, are not included.
  • Recommended Follow-Up: Management should update the Excel template to include all required elements for accurate annual reporting.

Finding Text

SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.

Categories

Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 12306 2022-001
    Significant Deficiency
  • 12307 2022-002
    Significant Deficiency
  • 12308 2022-001
    Significant Deficiency
  • 12309 2022-002
    Significant Deficiency
  • 12310 2022-001
    Significant Deficiency
  • 12311 2022-002
    Significant Deficiency
  • 12312 2022-001
    Significant Deficiency
  • 12314 2022-001
    Significant Deficiency
  • 12315 2022-002
    Significant Deficiency
  • 12316 2022-001
    Significant Deficiency
  • 12317 2022-002
    Significant Deficiency
  • 588748 2022-001
    Significant Deficiency
  • 588749 2022-002
    Significant Deficiency
  • 588750 2022-001
    Significant Deficiency
  • 588751 2022-002
    Significant Deficiency
  • 588752 2022-001
    Significant Deficiency
  • 588753 2022-002
    Significant Deficiency
  • 588754 2022-001
    Significant Deficiency
  • 588755 2022-002
    Significant Deficiency
  • 588756 2022-001
    Significant Deficiency
  • 588757 2022-002
    Significant Deficiency
  • 588758 2022-001
    Significant Deficiency
  • 588759 2022-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
10.766 Community Facilities Loans and Grants $4.46M