Finding 1228953 (2025-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-09-04
Audit: 410475
Organization: FISH (WA)
Auditor: ALEGRIA ADVISORS

AI Summary

  • Core Issue: The financial management system lacks a reliable way to track federal awards, leading to incomplete and inaccurate reporting.
  • Impacted Requirements: Compliance with 2 CFR 200.302(b)(3) is compromised, affecting the preparation of the Schedule of Expenditures of Federal Awards.
  • Recommended Follow-Up: Implement a detailed chart of accounts, establish tracking procedures for expenditures, and perform regular reconciliations to improve accuracy and compliance.

Finding Text

Finding 2025-002:Significant Deficiency inFinancialManagementSystemAffectingFederalAward Tracking and SEFA Preparation Information on the Federal Program: Assistance Listing Number 10.766 – Community Facilities Loans and Grants, U.S. Department of Agriculture. Award Number: SFRMWQVG79M5. Compliance requirements: Reporting. Type of finding: Significant deficiency. Criteria: 2 CFR 200.302(b)(3) requires that financial management systems maintain records that sufficiently identify the amount,source,andexpenditureofFederalfundsandprovideinformationnecessarytopermit the preparation of required financial and program reports, including the Schedule of Expenditures of Federal Awards. In addition, the auditee is responsible forpreparationofacompleteandaccurateScheduleofExpenditures of Federal Awards for inclusion in the single audit reporting package. Condition and context: During our audit procedures, we noted that expenditures were not consistently recorded in the general ledger in a manner that identifies the applicable funding source or federal program. As aresult:  Federal expenditures could not be readily identified by program from the accounting records.  Supporting information necessary for preparation of the Schedule of Expenditures of Federal Awards was not accumulated within the financial managementsystem.  The Schedule of Expenditures of Federal Awards required substantial audit adjustment and reconstruction to achieve completeness and accuracy. These conditions indicate that FISH’s financial management system does not consistently provide information necessary to identify and track federal award activity. Cause: FISH did not implement or maintain a general ledger structure or supporting processes that identify expenditures by funding source at the transaction level, nor were procedures in place to reconcile or accumulate federal award expenditures during the reporting period. Effect or potential effect: The deficiencies increase the risk that:  The Schedule of Expenditures of Federal Awards may be incomplete orinaccurate.  The majorprogram(s)maynotbeproperlyidentifiedinaccordancewithUniform Guidance.  Populations used for audit testing may be incomplete or inaccurate  Federal expenditures may not be consistently identified or reported by funding source.  Financial informationusedforinternalandexternalreportingoffederalawardsmaynotbereliable without significant manual intervention. While this condition did not result in identified questioned costs, it reflects a weakness in the financial management system required to support federal awardreporting. Questioned Costs: none. Recommendation: Werecommend thatmanagement:  Implement a chart of accounts or coding structure that identifies funding source at the transaction level.  Establish procedures to track expenditures by federal program throughout theyear.  Perform periodic reconciliations of grant activity to the general ledger.  Develop and document a formal process for preparation and review of the Schedule of Expenditures of Federal Awards. Responsible official’s response: Management agrees with the finding and has prepared a corrective actionplan.

Corrective Action Plan

Finding 2025-002: Significant Deficiency in Financial Management System Affecting Federal Award Tracking and SEFA Preparation Recommendations: We recommend that management: 1. Implement a chart of accounts or coding structure that identifies funding source at the transaction level. 2. 3. 4. Establish procedures to track expenditures by federal program throughout the year. Perform periodic reconciliations of grant activity to the general ledger. Develop and document a formal process for preparation and review of the Schedule of Expenditures of Federal Awards. Corrective Action Plan: Management Response already Completed prior to June 22nd, 2026: 1. A coding structure already exists in the ‘Grant’ field within SAGE accounting suite to identify what Grant source funding and/or expenses are applicable for. This is being enhanced to also include a “-…” identifying whether the grant is “- Direct Federal Funding”, “- Federal Passthrough Funding”, “- WA State Funding”, or “- Private Funding” for each grant. This will then be exported and dumped into a data table with mapping to sum total funding by general funding type source. 2. This is and has been in existence at FISH for a significant period of time. The Finance Director will be including a monthly review in the document ‘End of Month Finance Checklist’ to ensure that an Income Statement by Grant Type is reviewed monthly, in addition to the Detailed General Ledger review that also occurs monthly. Procedures to ensure that Federal funds are correctly identified by the correct Grant Type identifier as listed in #1 will be created so that this process becomes standardized moving forward. 3. See #2 above related to ‘End of Month Finance Checklist’ task. Management Response to be Completed: 1. The Finance Director, in coordination with the Executive Director, will develop and document a formal process for preparation and review of the Schedule of Expenditures of Federal Awards. Items 1-3 above will ensure that data is accurately tracked, while the procedures and processes created in this item will ensure that dates and reporting requirements are met ahead of time and in accordance with required standards. Anticipated Completion Date: • Full and complete implementation of all Corrective Action Plan items to be in place by 10/31/2026 and all relevant completed work for FY26-27 to be reviewed for adherence to all applicable policies, procedures, and/or standard practices as compared to Corrective Action Plan requirements and standards with any unavoidable, previously completed items of non-adherence being noted and brought to the attention of the (i) Executive Director and Finance Committee and/or (ii) the Board of Directors based upon scale of item of non-adherence. Responsible Individuals: • Work to be completed by Finance Office Manager with real-time and/or frequent periodical oversight by Finance Director and/or completed directly by Finance Director. • Summary of work completed and/or summary status reports to be reviewed and/or approved by Executive Director and/or Finance Committee based upon importance and/or applicability of work. • Financial Statements, Outstanding Audit Responses, and/or any outstanding items of note or organization-level scale to be reviewed by Board of Directors on at least a monthly basis.

Categories

Reporting

Programs in Audit

ALN Program Name Expenditures
10.766 COMMUNITY FACILITIES LOANS AND GRANTS $533,619
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $193,256
10.331 GUS SCHUMACHER NUTRITION INCENTIVE PROGRAM $166,095
10.568 EMERGENCY FOOD ASSISTANCE PROGRAM (ADMINISTRATIVE COSTS) $83,396
10.551 SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $61,522
10.565 COMMODITY SUPPLEMENTAL FOOD PROGRAM $23,723
93.912 RURAL HEALTHCARE SERVICES PROGRAMS $23,038
10.182 PANDEMIC RELIEF ACTIVITIES: LOCAL FOOD PURCHASE AGREEMENTS WITH STATES, TRIBES, AND LOCAL GOVERNMENTS $7,783
10.194 COMMODITY CREDIT CORPORATION (CCC) FUNDING TO ALLEVIATE EMERGENCY SUPPLY CHAIN DISRUPTION IN THE COMMODITY SUPPLEMENTAL FOOD PROGRAM (CSFP) $6,254