Finding 1215471 (2025-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-05-26
Audit: 402110
Auditor: WIPFLI LLP

AI Summary

  • Core Issue: Community Council of Idaho has not reconciled its grant and contract revenue accounts, leading to a material weakness in internal controls over financial reporting.
  • Impacted Requirements: Failure to comply with timely reconciliation and reporting standards as outlined in Federal Regulations 2 CFR 200.302(4) and 2 CFR 200.512(a).
  • Recommended Follow-Up: Implement monthly account reconciliations and improve closing procedures to ensure accurate financial reporting and timely audits.

Finding Text

Reconciliations and Material Adjustments Condition: At the time of audit fieldwork, Community Council of Idaho had not reconciled and closed its grant and contract revenue accounts. As a result, Wipfli LLP proposed and management posted adjusting journal entries to grants receivabl and grant revenue. There were also entries to during the audit to correct property and equipment, pharmaceutical inventory, notes payable, depreciation expense, and interest expense. As Community Council of Idaho’s internal controls did not discover these adjustments prior to the audit, a material weakness exists in Community Council of Idaho’s internal controls over financial reporting. Community Council of Idaho also experienced delays in issuing the June 30, 2025, audited financial statements which were due March 31, 2026. Criteria: An accounting system should provide timely and accurate information for management. The reconciliation of account balances is an integral internal control activity to determine that stated account balances are accurately and fairly reported. Management should reconcile general ledger accounts to subsidiary ledgers and other supporting documents in a timely and effective manner. Federal Regulation 2 CFR 200.302(4) requires that an organization have…Effective control over, and accountability for, all funds, property, and other assets." Furthermore, Federal Regulation 2 CFR 200.512(a) requires audits be submitted nine months after the end of the audit period. Cause: During the audit year, Community Council of Idaho experienced turnover in its business office while preparing for the audit which contributed to the lack of adequate and timely closing procedures, account reconciliations, and review processes. Effect: A material weakness in internal control over financial reporting exists as a result of these matters. Auditor's Recommendations: Accounts should be reconciled monthly with the adjustments posted timely so that management is relying on accurate financial information to make decisions. We recommend management and those charged with governance evaluate the operation of the business office and implement adequate and timely closing procedures to ensure that financial statement amounts are being reconciled, reviewed, and adjusted in a timely manner. Clinic reporting systems and procedures should be evaluated and revised. View of Responsible Officials: Management agrees with the assessment and subsequent to year end, steps were taken to correct the matter.

Corrective Action Plan

Management’s Response Community Council of Idaho, Inc. acknowledges the finding related to untimely reconciliations, material audit adjustments, and delayed financial statement issuance. Management agrees that improvements are necessary to strengthen internal controls over financial reporting, ensure timely account reconciliations, and improve the overall financial close and audit preparation process. Management recognizes that turnover within the business office during the audit year significantly impacted continuity, institutional knowledge, and the timely completion of reconciliations and closing procedures. Subsequent to year end, management has initiated corrective actions designed to improve financial reporting accuracy, accountability, and timeliness. Corrective Actions to Be Implemented 1. Implementation of Formal Monthly Closing Procedures Management will implement a standardized monthly financial close process with defined timelines, responsibilities, and review procedures. The monthly close process will include: Completion of all balance sheet reconciliations, Review of grant and contract revenue accounts, Review of property and equipment activity, Reconciliation of debt schedules, Reconciliation of pharmaceutical inventory balances, Recording of depreciation and interest expense, and Verification that all material journal entries are posted timely. A monthly close checklist will be developed and maintained to ensure consistency and accountability. 2. Timely Reconciliation of Grant and Contract Accounts Management will strengthen procedures surrounding grant and contract accounting to ensure receivables and revenue are reconciled monthly and supported by appropriate documentation. Actions include: Reconciling grant receivable balances to supporting reimbursement requests and funding agency records, Reviewing deferred revenue and earned revenue calculations monthly, Investigating and resolving variances timely, and Implementing supervisory review of grant reconciliations. 3. Enhanced Review and Oversight Controls Management will implement additional review controls over financial reporting and account reconciliations. These controls will include: Documented supervisory review and approval of reconciliations, Review of significant or unusual journal entries, Periodic review of financial statements and supporting schedules by senior finance leadership, and Earlier audit preparation and interim review procedures to identify issues prior to year end. 4. Strengthening Staffing and Organizational Structure Management and executive leadership have evaluated the operational needs of the business office and have taken steps to improve staffing stability and oversight capacity. Actions include: Clarifying accounting roles and responsibilities, Enhancing cross-training within the finance department, Providing additional training related to grant accounting and reconciliations, Utilizing external resources or consultants, as needed, to support complex accounting areas and transition periods. 5. Improvement of Clinic Reporting Processes Management will continue evaluating clinic reporting systems and procedures to ensure operational growth is adequately supported by accounting and financial reporting processes. This includes: Improving coordination between clinic operations and accounting, Standardizing reporting procedures, Evaluating system-generated reports for accuracy and completeness, and Implementing additional reconciliation and review controls related to clinic financial activity. 6. Audit Readiness and Timeliness Improvements Management will establish an audit preparation timeline with interim deadlines to support timely completion of the annual audit and compliance with federal reporting deadlines. The organization will: Prepare schedules and reconciliations in advance of audit fieldwork, Conduct periodic internal reviews of audit support documentation, Improve coordination with external auditors throughout the year, and Monitor progress toward required reporting deadlines. Contact Person Responsible for Corrective Action: Implementation oversight will be shared among executive leadership, finance management, program leadership, and those charged with governance. Anticipated Completion Date: Corrective actions began subsequent to year end and are expected to be substantially implemented during fiscal year 2026, with ongoing monitoring and refinement thereafter.

Categories

Equipment & Real Property Management HUD Housing Programs Material Weakness Reporting

Programs in Audit

ALN Program Name Expenditures
93.600 HEAD START $21.96M
93.224 HEALTH CENTER PROGRAM (COMMUNITY HEALTH CENTERS, MIGRANT HEALTH CENTERS, HEALTH CARE FOR THE HOMELESS, AND PUBLIC HOUSING PRIMARY CARE) $1.74M
84.141 MIGRANT EDUCATION HIGH SCHOOL EQUIVALENCY PROGRAM $516,375
93.568 LOW-INCOME HOME ENERGY ASSISTANCE $495,978
17.274 YOUTHBUILD $479,740
10.558 CHILD AND ADULT CARE FOOD PROGRAM $465,996
10.427 RURAL RENTAL ASSISTANCE PAYMENTS $352,828
10.405 FARM LABOR HOUSING LOANS AND GRANTS $299,146
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $171,663
93.569 COMMUNITY SERVICES BLOCK GRANT $165,749
16.588 VIOLENCE AGAINST WOMEN FORMULA GRANTS $77,218
17.264 NATIONAL FARMWORKER JOBS PROGRAM $39,206
16.589 RURAL DOMESTIC VIOLENCE, DATING VIOLENCE, SEXUAL ASSAULT, AND STALKING ASSISTANCE PROGRAM $34,718