Finding 567926 (2023-002)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2025-06-27

AI Summary

  • Core Issue: The Organization lacks a mapping schedule to verify that federal grant expenses match those in the general ledger.
  • Impacted Requirements: There are no controls ensuring all grant expenses are accurately recorded and reconciled with the general ledger.
  • Recommended Follow-Up: Implement a dedicated chart of accounts for federal grant expenses or enhance the grant spreadsheet for better reconciliation with the general ledger.

Finding Text

Condition: The Organization does not maintain a mapping schedule or other means to efficiently determine that expenses charged to the federal grant represent expenses incurred and paid as reflected in the general ledger. Criteria: Controls are not in place to ensure all expenses charged to the grant have been incurred and paid as reflected in the general ledger. Cause: The details of federal expenses are maintained outside of the general ledger and there is no efficient means to reconcile to the general ledger. Effect: Amounts reported as eligible grant expenses may be incorrect. Questioned Costs: N/A Recommendation: We recommend that the Organization consider incorporating a chart of accounts specifically used for federal grant expenditures. Alternatively, additional detail could be included in its grant spreadsheet to clearly indicate which expense account was charged in order to agree these amounts to the general ledger. This will allow the entity to ensure the accuracy of its grant reporting in a more efficient manner. Views of Responsible Officials and Planned Corrective Action: Management stated that they disagree with the audit finding. Management notes that all expenses are documented in spreadsheets, invoice form, and available for review. However, management indicates that it will begin reclassifying federal grant expenditures in the accounting software. Auditor notes that this is consistent with the auditor’s finding that the entity lacks a means to efficiently determine that expenses charged to the grant are included in the general ledger, and the auditor’s recommendation to consider incorporating a chart of accounts specifically used for federal grant expenditures.

Corrective Action Plan

Management stated that they disagree with the audit finding. Management notes that all expenses are documented in spreadsheets, invoice form, and available for review. However, management indicates that it will begin reclassifying federal grant expenditures in the accounting software. Auditor notes that this is consistent with the auditor’s finding that the entity lacks a means to efficiently determine that expenses charged to the grant are included in the general ledger, and the auditor’s recommendation to consider incorporating a chart of accounts specifically used for federal grant expenditures.

Categories

Reporting

Other Findings in this Audit

  • 567927 2023-003
    Significant Deficiency
  • 567928 2023-004
    - Repeat
  • 1144368 2023-002
    Significant Deficiency
  • 1144369 2023-003
    Significant Deficiency
  • 1144370 2023-004
    - Repeat

Programs in Audit

ALN Program Name Expenditures
10.001 Agricultural Research Basic and Applied Research $2.16M