Finding 1163534 (2024-003)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-12-05

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards was incomplete and inaccurate, affecting compliance.
  • Impacted Requirements: Management must ensure accurate reconciliation of the Schedule to the general ledger.
  • Recommended Follow-Up: Implement better processes and controls to guarantee data accuracy in future reports.

Finding Text

Federal Program: Beginning Farmers and Ranchers Development Grant Assistance Listing No.: 10.311 Federal Agency: U.S. Department of Agriculture Pass-Through Entity: None Federal Award Identification Number: 2022-49400-38205 Repeat Finding: This is not a repeat finding Criteria – Management is responsible for preparing a complete and accurate Schedule of Expenditures of Federal Awards. Condition – During compliance testing, it was determined that the Schedule of Expenditures of Federal Awards provided to us to begin our audit was not complete and accurate. Context – Management was unable to fully reconcile the Schedule of Expenditures of Federal Awards to the general ledger. Cause – The information contained in the Schedule of Expenditures of Federal Awards was not accurate. Effect – As a result of the condition, management was unable to fully reconcile the Schedule of Expenditures of Federal Awards to the general ledger. Recommendation – In the future, management should ensure it implements appropriate processes and controls to ensure the Schedule of Expenditures of Federal Awards contains complete and accurate data. Views of Responsible Officials – Management acknowledges the finding and will implement appropriate processes and controls to ensure the Schedule of Expenditures of Federal Awards contains complete and accurate data.

Corrective Action Plan

Federal Program: Beginning Farmers and Ranchers Development Grant Assistance Listing No.: 10.311 Federal Agency: U.S. Department of Agriculture Pass-Through Entity: None Federal Award Identification Number: 2022-49400-38205 Repeat Finding: This is not a repeat finding Criteria – Management is responsible for preparing a complete and accurate Schedule of Expenditures of Federal Awards. Condition – During compliance testing, it was determined that the Schedule of Expenditures of Federal Awards provided to us to begin our audit was not complete and accurate. Context – Management was unable to fully reconcile the Schedule of Expenditures of Federal Awards to the general ledger. Cause – The information contained in the Schedule of Expenditures of Federal Awards was not accurate. Effect – As a result of the condition, management was unable to fully reconcile the Schedule of Expenditures of Federal Awards to the general ledger. Recommendation – In the future, management should ensure it implements appropriate processes and controls to ensure the Schedule of Expenditures of Federal Awards contains complete and accurate data. Views of Responsible Officials – Management acknowledges the finding and will implement appropriate processes and controls to ensure the Schedule of Expenditures of Federal Awards contains complete and accurate data. Corrective Actions Taken or Planned – MOFGA created a SEFA to capture grant funds by CFDA number during the compliance audit. Grants are spread out throughout various lines of our chart of accounts, with no quick designation in QuickBooks Online for identifying which ones are private, state or federal funds. This was done manually for each income source (and complimentary expense line), and a few corrections were identified during the audit. We have received guidance from external partners about using Customer/Job functionality or Funder functionality in QBO for tracking of federal grants. This is being evaluated to help with the accuracy and expediting of report creation directly from our accounting software. Responsible Parties – Angela Haiss, Director of Operations Anticipated Completion Date – December 31, 2025

Categories

Subrecipient Monitoring Reporting

Other Findings in this Audit

  • 1163530 2024-002
    Material Weakness Repeat
  • 1163531 2024-001
    Material Weakness Repeat
  • 1163532 2024-001
    Material Weakness Repeat
  • 1163533 2024-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.311 BEGINNING FARMER AND RANCHER DEVELOPMENT PROGRAM $203,078
10.163 MARKET PROTECTION AND PROMOTION $103,722
10.188 Organic Market Development Grant Program $69,038
10.937 Partnerships for Climate-Smart Commodities $49,408
10.175 FARMERS MARKET AND LOCAL FOOD PROMOTION PROGRAM (B) $41,063
10.520 AGRICULTURE RISK MANAGEMENT EDUCATION PARTNERSHIPS COMPETITIVE GRANTS PROGRAM $21,517
10.176 DAIRY BUSINESS INNOVATION INITIATIVES (B) $20,095
10.902 SOIL AND WATER CONSERVATION $19,901
10.331 FOOD INSECURITY NUTRITION INCENTIVE GRANTS PROGRAM $16,845
10.310 AGRICULTURE AND FOOD RESEARCH INITIATIVE (AFRI) $13,331
10.215 SUSTAINABLE AGRICULTURE RESEARCH AND EDUCATION $11,353
10.525 FARM AND RANCH STRESS ASSISTANCE NETWORK COMPETITIVE GRANTS PROGRAM (B) $9,000
10.181 AMS - PANDEMIC RESPONSE AND SAFETY GRANTS PROGRAM/ AMS - FARMWORKER AND MEATPACKING WORKER RELIEF GRANT PROGRAM $9,000
10.675 URBAN AND COMMUNITY FORESTRY PROGRAM $6,630
10.460 RISK MANAGEMENT EDUCATION PARTNERSHIPS $6,387
10.170 SPECIALTY CROP BLOCK GRANT PROGRAM - FARM BILL $1,534