Condition: The SEFA was inaccurately prepared and did not fully reconcile to the general ledger. Cause: Insufficient reconciliation and review procedures over SEFA preparation. Effect: Federal expenditures may be misstated, resulting in noncompliance with reporting requirements. Criteria: 2 CFR 200.510(b) and 200.302 require the SEFA to be accurate and supported by underlying accounting records. Recommendation: Implement documented reconciliation and review procedures to ensure the SEFA agrees to the general ledger prior to issuance.
SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Reference Number: 2025-001 Schedule of Expenditures of Federal Awards Presentation Significant Deficiency and Noncompliance Condition The audit found that the City did not include a Federal Emergency Management Agency (FEMA) award, assistance listing number 97.036, totaling $101,355, on the Schedule of Expenditures of Federal Awards (SEFA). The FEMA funds were obligated during fiscal year 2025, after the related expenditures had been incurred and approved, so they should have been reported on the SEFA for the June 30, 2025 year-end audit according to the Office of Management and Budget Compliance Supplement. Consequently, the total federal expenditures were initially reported as less than the actual amount. Criteria All federal awards, including those provided by FEMA, must be reported on the SEFA. According to 2 CFR Section 200.510 (b) of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (“Uniform Guidance”), the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements. This schedule must include all federal awards expended as defined in 2 CFR section 200.502. Excluding federal awards from this reporting may result in noncompliance with federal regulations and audit requirements. Cause The exclusion of the FEMA award from the SEFA was due to a misrepresentation of the reporting requirements for federal disaster assistance. Effect or Potential Effect Omitting any federal awards from the SEFA can result in the failure to recognize when a single audit is required, potentially leading to the City missing this crucial audit. Without a complete SEFA and the associated single audit, there is a heightened risk of noncompliance with federal regulations, which may jeopardize the City’s eligibility for future federal funding. Additionally, the absence of a single audit increases the likelihood that mismanagement or misuse of federal funds remain undetected. Federal agencies may also respond by imposing sanctions or demanding repayment of any costs deemed questionable due to incomplete reporting and lack of proper oversight. Recommendation It is recommend that the City: Review and update policies and procedures for identifying, recording, and reporting all federal awards, including disaster assistance. Implement a formal review process to ensure completeness and accuracy of the SEFA prior to submission and annual audit engagement. Consult with external auditors or grant specialists when uncertainty exists regarding the inclusion of specific awards. Management’s Response The expenditure occurred in calendar year 2020 and 2021. Since these funds were emergency funds, no deferred revenue was accrued since staff was uncertain of whether costs would be eligible for reimbursement. Final revenues of $101,355 were received in FY2025, and staff recorded the revenue received on the SEFA, but not the expenditure. Going forward, staff will report expenditures on the SEFA when eligible expenditures are approved by FEMA.
2025-013: Improve Financial Management of Federal Grants Applicable to: Department of Wildlife Resources Assigned Topic: Federal Grants Management Prior Finding Number: N/A Finding Type: Internal Control and Compliance Finding Severity: Material Weakness Financial Statement Finding: No Federal Awards Finding: Yes ALPT - ALN: Sport Fish Restoration - 15.605; Wildlife Restoration and Basic Hunter Education and Safety - 15.611; Enhanced Hunter Education and Safety - 15.626 Federal Award ID (Year): F20AF10048 (2020); F20AF11897 (2020); F21AF02409 (2021); F22AF01121 (2022); F23AF00654 (2023); F23AF03173 (2023); F23AF03185 (2023); F24AF02770 (2024); F24AF02896 (2024); F24AF02903 (2024) Federal Agency: U.S. Department of the Interior Compliance Requirement: Allowable Costs/Cost Principles - 2 CFR § 200.302; 2 CFR § 200.303(a); 2 CFR § 200.305; 2 CFR § 200.510(b); 31 CFR § 205.33 Known Questioned Costs: $0 The Department of Wildlife Resources (Wildlife Resources) should improve its financial management of federal grants and documentation of internal controls to ensure compliance with state and federal requirements. Wildlife Resources has experienced recent turnover in its grants staff positions. Wildlife Resources has hired new staff; however, there was no transition period with the previous staff, and the previous grants staff did not sufficiently document internal controls over the federal programs. Staff have started documenting desk procedures, but agency-wide policies and procedures remain lacking. As such, grants staff did not appear to have sufficient knowledge of statewide policies and procedures to adequately perform the federal grants management processes in accordance with federal regulations and the Commonwealth Accounting Policies and Procedures (CAPP) Manual. We identified the following issues: Wildlife Resources should amend its procedures to comply with CAPP Manual requirements for cash management of federal funds. CAPP Manual Topic 20605 states that two methods of recording "split" funded expenses are acceptable. The method preferred by the State Comptroller is to establish procedures to "split code" the expenses by allocating the disbursement between a state fund and the federal fund at the matching ratio prescribed by the grant or contract. A second, and temporary, funding method allows the agency to charge the original expense to a state fund and subsequently, within seven business days, prepare and submit a general ledger journal in the Commonwealth’s accounting and financial reporting system to charge the federal fund for the federal portion of the original expense, referencing the original voucher in the journal reference line for transparency. If a state agency cannot comply, the agency must request approval from the State Comptroller. Wildlife Resources follows the temporary funding method to record its federal expenses. Wildlife Resources spends from state funds and then performs journal entries to move transactions to the federal fund in bulk with some journal entries representing hundreds of individual transactions, which does not allow for transparency regarding the nature of Wildlife Resources federal expenses. Further, our analysis found that Wildlife Resources enters journal entries for federal drawdowns up to three months after the original transaction date which is not consistent with the seven-day requirement in CAPP Manual Topic 20605. Per 2 Code of Federal Regulations (CFR) § 200.302, a recipient must comply with state laws and procedures for expending and accounting for the State's funds. Additionally, the untimely performance of these extensive journal entries may result in Wildlife Resources recording journal entries in the wrong fiscal year, which could result in inaccurate information within the Commonwealth’s Annual Comprehensive Financial Report. Wildlife Resources does not maintain adequate support for its journal entries. CAPP Manual Topic 20405 requires the agency to retain sufficient supporting documentation to provide auditable records containing evidence of required coding elements for journal entries. Wildlife Resources’ journal entries lack documentation related to changes in coding. Further, Wildlife Resources does not maintain supporting documentation for journal entries in one accessible location which would allow for sufficient supervisory review. Not maintaining adequate supporting documentation over journal entries increases the risk of inaccurate or fraudulent transactions. Wildlife Resources also does not have policies and procedures in place that detail how it creates the journal entries, what type of documentation to retain to support journal entries, or how Wildlife Resources ensures it only moves allowable costs to the federal fund. Title 2 CFR § 200.303(a) requires recipients to establish, document, and maintain effective internal control over the federal award that provides reasonable assurance that the recipient or subrecipient is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. During fiscal year 2025, in response to our Office’s 2024 Internal Control Questionnaire Review, Wildlife Resources established a bimonthly drawdown and journal entry schedule to ensure timely drawdown of federal funds to reimburse expenses originally incurred within state funds and to assist in remediation of its cash flow issues. Per 31 CFR § 205.33, a state must minimize the time between the drawdown of federal funds from the federal government and their disbursement for federal program purposes in accordance with the actual, immediate cash requirements of the state. The timing and amount of funds transfers must be as close as is administratively feasible to a state's actual cash outlay for direct program costs and the proportionate share of any allowable indirect costs. However, based on our analysis of drawdowns, while Wildlife Resources has made progress in the rate of drawdowns since the previous review, due to staff shortages, Wildlife Resources has not fully followed its drawdown schedule to ensure timely drawdowns of federal funds, which could exacerbate the agency’s cash flow issues. Specifically, the drawdown schedule included twenty planned drawdowns, however Wildlife Resources completed only eleven (55%) in accordance with that schedule. Furthermore, Wildlife Resources does not have policies and procedures in place over the completion of drawdowns as required by 2 CFR § 200.302, which requires a recipient to have written procedures to implement the requirements of 2 CFR § 200.305 regarding federal drawdowns. Wildlife Resources did not record program income revenue of approximately $2.3 million in the correct fiscal year for the Fish and Wildlife Cluster. Wildlife Resources recorded the program income received in fiscal year 2025 in a suspense account and did not distribute the income to the proper revenue account until fiscal year 2026. CAPP Manual Topic 20205 requires recording of all state receipts in the Commonwealth’s accounting and financial reporting system in a timely manner within three business days of the deposit. Additionally, the Department of Accounts (Accounts) Fiscal Year-End Closing Procedures require agencies to certify that they properly distributed balances to the correct accounts before final close of Commonwealth’s accounting and financial reporting system. By not properly recording program income, Wildlife Resources may misrepresent financial information to the federal government and report information that does not agree with its accounting records. Wildlife Resources reported federal expenses on its Schedule of Expenditures of Federal Awards (SEFA), a schedule that details Wildlife Resources’ federal expenses for fiscal year 2025, that did not agree to its underlying accounting records. Wildlife Resources reported federal expenses in the SEFA that it recorded as state funds in the Commonwealth’s accounting and financial reporting system due to considering journal entries that they did not record in the system until the next fiscal year. Due to these issues and preparation of the SEFA by a member of management on long-term leave who was not available during the audit, Wildlife Resources could not support amounts totaling over $660,000 in its SEFA. Additionally, Wildlife Resources does not have documented procedures outlining its process for preparing the SEFA in accordance with 2 CFR § 200.510(b), which states that the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR § 200.502. Accounts’ Office of the Comptroller’s Directive No. 1-25 (Comptroller’s Directive) also provides specific directions for compiling the SEFA and supporting schedules to support its preparation of the Commonwealth’s SEFA and related disclosures. Furthermore, the Comptroller’s Directive states that an agency must ensure that it has internal controls in place to avoid material misstatements and/or misclassifications in the attachments and other financial information submitted to Accounts for inclusion in the Commonwealth’s Single Audit. By not implementing adequate internal controls over financial reporting, Wildlife Resources cannot provide reasonable assurance that the financial information it submits to Accounts for inclusion in the Commonwealth’s Single Audit is free of material misstatements. Because of the scope of the matters and errors noted above, we consider this finding to be a material weakness in internal control. Wildlife Resources should improve its financial management of federal funds and documentation of internal controls to ensure compliance with state and federal requirements. The need for strong internal controls is especially important given that Wildlife Resources is exploring additional federal funding opportunities. Wildlife Resources should work with Accounts to develop and implement a federal grants management process that complies with the CAPP Manual. Wildlife Resources should improve its process and controls related to federal fund drawdowns to ensure timely reimbursement of expenses within federal limitations. Further, Wildlife Resources should also improve its controls and procedures related to journal entry processing to ensure it retains adequate support for all entries and enters the entries timely. Additionally, Wildlife Resources should perform a thorough review of its SEFA before submitting it to Accounts and retain supporting documentation to support the SEFA. Finally, Wildlife Resources should develop policies and procedures over all federal grants processes including all compliance requirements. These improvements combined are necessary to ensure accurate accounting and financial reporting in accordance with the CAPP Manual, the Code of Federal Regulations, the Comptroller’s Directives, and applicable accounting standards. Views of Responsible Officials: The views of responsible officials are included in the report related to their organization, which can be found at www.apa.virginia.gov and, in summary, do not express disagreement with the finding.
Finding 2025-003: Preparation of the Schedule of Expenditures of Federal Awards Material weakness/other matter noncompliance Federal Agency: U.S. Department of Homeland Security Program Name: Transit Security Grant Programs ALN Number: 97.075 Award Number: 97.075 Award Year: 2025 Criteria: The Uniform Guidance (2 CFR 200.510b) requires that the auditee (typically a non-federal entity receiving federal funds) must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by its financial statements which must include the total Federal Awards expended as determined in accordance with 2 CFR 200.502. Condition: The SEFA for the year ended June 30, 2025, included $2,385,715 in expenditures that were incurred in the year ended June 30, 2024, overstating the total expenditures reported for the federal awards for ALN 97.075 Rail and Transit Security Grant Program. Cause: The existing internal control procedures for processing funding source reclassifications are not structured to fully support the SEFA reporting cutoff deadline. While a process is in place, it does not fully incorporate all necessary stakeholders early enough in the cycle to ensure timely communication, coordinated review, and approval of reclassifications leading to expenditures being included in the incorrect reporting cycle Effect: Not in compliance with the Uniform Guidance (2 CFR 200.510b). There could be impacts on future funding. Questioned costs: None. Context: As a result of the inclusion of fiscal year ended 2024 expenditures, total federal awards for ALN 97.075, Rail and Transit Security Grant Program, were overstated by $2,385,715. Repeat Finding: Yes. This repeat finding designation results from the identification of the $2,385,715 timing difference, which affected SEFA reporting for both fiscal year 2024 and fiscal year 2025. Findings for both fiscal years were evaluated and communicated to management in 2026. Recommendation: We recommend that the Authority review the schedule of expenditures of federal awards prior to issuance. Views of responsible officials and planned corrective actions: Management agrees with the finding and acknowledges that internal control procedures should be strengthened to ensure adherence to the SEFA reporting cutoff deadline. To address this issue, the Authority will implement a verification checklist as required supporting documentation for all funding source reclassification journal entries, ensuring that all relevant departments have reviewed and approved the entries prior to being posted. The Authority will also establish a cutoff date for Program Offices to submit current-year reclassification requests, allowing adequate time for eligibility review and fiscal year-end reporting. In addition, Accounting Policies and Procedures Manual will be updated to include guidelines limiting reclassifications of expenditures incurred in prior fiscal years. The Authority will communicate policy updates incorporate these changes to ensure consistent application across departments.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, Department of Housing and Urban Development, Community Development Block Grants and ALN 21.027, Department of the Treasury, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - B24MC260070 2025 and CW 5912A 2026 2021 Pass through Entity - N/A Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - Per 2 CFR Section 200.510(b), cities and other non federal entities must create a Schedule of Expenditures of Federal Awards (SEFA) if they expend more than $1 million in federal awards during their fiscal year. Condition - The City did not accurately prepare a SEFA that included all federal expenditures in fiscal year 2025, which resulted in a increase of approximately $7.6 million. Questioned Costs - N/A If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported - N/A Identification of How Questioned Costs Were Computed - N/A Context - The City did not accurately prepare a SEFA based on the activity for the year ended June 30, 2025. Cause and Effect - Improper recognition of federal awards which includes the grant agreement periods and the amount of expenditures originally provided created issues with the amounts reported to the auditors and led to the correction of the SEFA by an amount of $7.6 million from the amounts that were originally provided. Recommendation - The City should assign an individual to prepare the SEFA, along with another individual to approve it to ensure that it is properly recorded. Views of Responsible Officials and Planned Corrective Actions - The City will ensure that all future expenditures of federal awards are included on the SEFA by assigned staff to prepare and review the SEFA and track the amounts throughout the year.
Program: Various, including 21.027 – COVID-19 Coronavirus State and Local Fiscal Recovery Funds; 10.555 – National School Lunch Program – Reporting Grant Number & Year: Various, including SLFRP1965, March 3, 2021, through December 31, 2024; 253NE308N1099, FFY 2025 Federal Grantor Agency: Various, including U.S. Department of the Treasury and U.S. Department of Agriculture Criteria: A good internal control plan requires adequate procedures to ensure the Schedule of Expenditures of Federal Awards (SEFA) is presented properly. 2 CFR § 200.510(b) (January 1, 2024, and January 1, 2025) states that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements that includes the total Federal awards expended, the total Federal awards expended for each individual Federal program, and the total amount provided to subrecipients from each Federal program. Neb. Rev. Stat. § 81-1111(1) (Reissue 2024) states, in part, the following: Subject to the supervision of the Director of Administrative Services, the Accounting Administrator shall have the authority to prescribe the system of accounts and accounting to be maintained by the state and its departments and agencies, develop necessary accounting policies and procedures, coordinate and approve all proposed financial systems, and manage all accounting matters of the state’s central system. EnterpriseOne is the official accounting system of the State. Condition: Several programs did not have expenditures or the amount provided to subrecipients reported accurately on the SEFA. We notified the Department of Administrative Services (Administrative Services) of the errors, and the SEFA was subsequently adjusted. A similar finding has been noted for several years. Repeat Finding: 2024-030 Questioned Costs: None Statistical Sample: No Context: Administrative Services is responsible for managing the accounting matters of the State and certifies the data collection form for the Statewide Single Audit. Administrative Services compiles the SEFA from information provided by the individual agencies and submits it to the auditor. During our review, we noted 12 programs for various State agencies needed correction. This included overreporting AL 21.027 by $4,254,865 and underreporting AL 10.555 by $4,757,669. Additionally, a program was originally included on the SEFA for over $16 million that was initially selected as a major program; however, it was determined subsequently that the program should not have been reported on the SEFA. The total expenditures and amounts provided to subrecipients, as both originally reported and per the final SEFA, were as follows: See Schedule of Findings and Questioned Costs for chart/table. Cause: Administrative Services did not have adequate procedures to ensure the accuracy of amounts not pulled directly from the accounting system. Administrative Services established a specific account code for aid to subrecipients, but not all agencies utilized this account code. Effect: Increased risk for the SEFA to be inaccurate, which could lead to Federal sanctions or programs not audited that should be. Recommendation: We recommend Administrative Services improve procedures to ensure the SEFA is complete and accurate. Management Response: We will continue agency training, review of chart of accounts setup, review of object account usage, and working with State employees to help ensure the SEFA is accurate and complete.
Finding 2025-003: Schedule of Expenditures of Federal Awards (Significant Deficiency) Information on the Federal Program: 93.243 - U.S. Department of Health and Human Services. See Finding 2025-002. Finding 2024-003 is a significant deficiency in internal control over compliance in addition to noncompliance related to the Reporting compliance area. There were no questioned costs related to the preparation of the SEFA. This is a repeat finding.Finding 2025-002: Schedule of Expenditures of Federal Awards (Significant Deficiency) Criteria or Specific Requirement: Management is responsible for the complete and fair presentation of the financial statements, including any supplementary information that is presented in relation to the financial statements, such as the Schedule of Expenditures of Federal Awards (SEFA). Also, in accordance with 2 CFR Section 200.510 (b)(2), the Council is required to include all direct and pass-through Federal awards expended during the fiscal year in the SEFA. Condition: During the audit, it was noted that pass-through awards from American Academy of Addiction Psychiatry totaling $240,938 for the year ended June 30, 2025, had not been included on the SEFA. In addition, certain adjustments were made to the initial SEFA that was provided. As a result, management provided a revised SEFA after audit testing had begun. Cause: Since this is a repeat finding, the omission of the pass-through awards appears to be an oversight due to the transition in the finance team. However, the adjustments made to the SEFA are related to Finding 2025-001. Effect or Potential Effect: The SEFA was missing Federal expenditures of $240,938 at the start of the audit. The expenditures in the SEFA were adjusted due to the issues with account reconciliations per Finding 2025-001. When the SEFA is not accurately prepared, it could have an effect on the auditor's determination of major programs and on the auditor's sample selections.Recommendation: We recommend that the Council enhance its procedures related to the preparation of the SEFA to ensure all required amounts are included. Repeat Finding: This is a repeat finding.
Material Weakness in Internal Control Over Compliance Information on the Federal Program: Assistance Listing Number 14.157 – Section 202 Supportive Housing for the Elderly, U.S. Department of Housing and Urban Development Criteria: The regulations in 2 CFR 200.510 requires the auditee to prepare a schedule of expenditures of Federal awards which includes the Federal awards expended for each individual Federal program and in total. Condition: For the year June 30, 2025, the unadjusted schedule of expenditures of Federal awards did not report the correct Federal awards expended for this Federal program. Cause: Management does not have internal control over preparation of the schedule of expenditures of Federal awards or reconciliation of the reported expenditures to source documentation. Effect or Potential Effect: Material misstatements of the schedule of expenditures of Federal awards could be undetected and determination of major program(s) could be based on inaccurate information. Questioned Costs: None Context: This finding relates to the schedule of expenditures of federal awards. It is a repeat finding, #2024-002 from the June 30, 2024 audit, which was not corrected by management. Recommendation: We recommend that management develop and implement internal controls over the preparation of the schedule of expenditures of Federal awards. At a minimum, they should require identification of Federal award source documentation and documentation of how the expenditure amount reported for each was calculated. Views of Responsible Official: The new policy was discussed during the fiscal year for identifying federal awards. The written memo detailing the new policy was updated on September 30, 2025. This is the policy in place to be followed when preparing the schedule of expenditures of federal awards.
Finding 2025-002: Significant Deficiency – Internal Control Over Federal Award Reporting (ESSER III) Type of Finding: Internal Control Federal Program: Education Stabilization Fund - ARP-ESSER ALN: 84.425U Federal Award Year: 2021 Federal Agency: Department of Education Pass-thru entity: PA Department of education Pass-thru nos: 223-21-0422 Questioned Costs: None Repeat Finding: No Type of Compliance Requirement: Reporting Criteria: 2 CFR 200.510(b) requires the Schedule of Expenditures of Federal Awards (SEFA) to fairly present total federal expenditures for each federal program in the period in which they are incurred. Condition: During testing of ESSER III, we noted that the District had unspent funds remaining after reconciling the grant expenditures to the Final Expenditure Report (FER). Upon further review of the FER and discussions with District staff, we determined that expenditures related to the Federal Set-Aside awards had been mistakenly included in the FER for ESSER III, despite the use of separate source codes for each. The District believed the Set-Aside funds were part of the ESSER III award, and therefore included the Set-Aside expenditures when preparing the FER for ESSER III. Because the District’s reports for ESSER III were including the Set-Aside expenditures, the District believe ESSER III had been fully expended when, in fact, allowable ESSER III expenditures remained unreported. During the current fiscal year, the District subsequently identified certain allowable ESSER III expenditures incurred during the 2023-24 fiscal year that were coded to non-federal sources and reclassified them as ESSER III expenditures for that year. These expenditures were not identified as ESSER III expenditures in the prior fiscal year and were not included in the SEFA until they were identified during the current fiscal year. As a result, the SEFA for the year ended June 30, 2024 understated ESSER III expenditures. Cause: The District misunderstood the structure of the ESSER III and Federal Set-Aside awards and believed that the Set-Aside funds were part of the ESSER III allocation. As a result of the misunderstanding, the District included the expenditures for the Set-Asides with the ESSER III expenditures when submitting the FER for ESSER III. Effect: Federal expenditures for ESSER III were understated on the District’s SEFA for the year ended June 30, 2024. A correction was made in the current fiscal year to properly report the expenditures in the period in which they were incurred. Context: The expenditures identified were allowable costs that were incurred during fiscal year 2023-24. The issue did not involve unallowable costs, eligibility violations, or misuse of federal funds. Rather, the finding resulted from misunderstanding the structure of ESSER III and the Federal Set-Aside awards, which led to miscoding and reporting errors. Once identified, the District worked with the auditors to correct the error and properly report the expenditures. Recommendation: We recommend the District provide additional training to staff responsible for federal grant accounting to ensure a clear understanding of grant award structures to facilitate proper grant tracking and reporting. View of Responsible Officials: The District agrees with the finding and the recommendation and will take steps to ensure the staff responsible are properly trained and educated on each grant received by the District.
Research and Development Cluster—Reporting in the Schedule of Expenditures of Federal Awards Background: The Department of Administration (DOA) State Controller’s Office (SCO) is responsible for coordinating with other state agencies to prepare the State of Wisconsin Schedule of Expenditures of Federal Awards (SEFA). The SEFA, which is required to be published in the State of Wisconsin single audit report, is a listing of all federal programs administered by an entity. The SEFA includes the total expenditures for the reporting period and identifies any amounts provided to subrecipients for each federal program. Each state agency prepares a SEFA for the federal programs it administers. For federal programs administered by UW System Administration and UW institutions, UW System Administration staff work with UW institution staff to compile the UW System SEFA. The UW System SEFA is provided to DOA, which compiles the agency-level SEFAs into the statewide SEFA. During our FY 2023-24 single audit (report 25-04), we found that UW System Administration did not have formal written procedures to accurately compile federal expenditures for submission to DOA. We recommended that UW System Administration develop written procedures to improve its SEFA reporting and accurately identify grant expenditures for reporting for the Research and Development Cluster, and provide training to UW institutions on the documented procedures (Finding 2024 712). Criteria: Under 2 CFR s. 200.510 (b), the State is required to prepare a SEFA for the period covered by the State’s financial statements, and the SEFA must include the total federal awards expended and include the total amount provided to subrecipients from each federal program. In addition, for federal awards received as a subrecipient, the name of the pass-through entity is required to be identified in the SEFA. Condition: In our review of the FY 2024 25 SEFA prepared by UW System Administration, we continued to identify multiple errors in the presentation of Research and Development Cluster expenditures. We found UW System Administration incorrectly included a total of $24.4 million in expenditures for 26 other grant programs as part of the Research and Development Cluster in the FY 2024 25 SEFA. For example, $1.2 million in funding provided by the Department of Health Services under the Epidemiology and Laboratory Capacity for Infectious Diseases grant program was reported incorrectly by UW System Administration as part of the Research and Development Cluster. We also identified a similar error in SEFA reporting for this same program in FY 2023-24. In addition, UW System Administration did not meet timelines established by SCO to provide a draft of the UW System SEFA. Context: UW System Administration reported $1.9 billion in federal financial assistance in FY 2024-25. We reviewed the UW System SEFA to assess the reported expenditures. We inquired of UW System Administration regarding its procedures for preparation of the SEFA, and we contacted UW institutions, as needed, to understand the recording of federal grant expenditures. Questioned Costs: None. Effect: UW System Administration is not assured that its SEFA reporting accurately reflects its expenditure of federal assistance. Errors such as those we identified are noncompliant with federal requirements. Cause: UW System Administration is responsible for the SEFA compilation, and it relies on some manual processes. Because UW institutions were permitted to record federal grants in multiple ways within UW System’s accounting system during FY 2024 25, UW System Administration was unable to perform queries of UW System’s accounting system to compile federal expenditure information in sufficient detail without obtaining assistance from UW institutions. The manual processes used introduced the potential for errors, inaccurate reporting, and required additional time to compile the SEFA information. UW System Administration did not develop formal written procedures for compiling the SEFA during FY 2024 25. UW System Administration’s procedures for preparing the SEFA were insufficient to detect and correct potential SEFA errors that related to grant funds passed through to UW institutions from state agencies, which resulted in UW System Administration incorrectly reporting certain expenditures in the Research and Development Cluster instead of reporting them correctly with the grant programs to which they were related. Although UW institutions classified activities under an agreement with other state agencies as research related in its accounting system, neither UW System Administration nor UW institutions adequately researched whether the federal grant program identified in the agreements with other state agencies should be reported in the SEFA as a grant program other than a Research and Development Cluster program. In February 2026, UW System Administration provided the written procedures it prepared after it compiled the SEFA for FY 2024-25. These procedures identify the division of responsibilities between UW System Administration and UW institutions and the need to assess whether certain research activities should be reported as other federal programs in the SEFA. However, it will be important for UW System Administration to provide training to UW institutions to ensure SEFA reporting requirements are understood and UW institutions can accurately differentiate federal expenditures between the Research and Development Cluster programs and other federal grant programs in a timely manner. In July 2025, UW System implemented a new accounting system that UW System Administration will use to compile the FY 2025-26 UW System SEFA. UW System Administration should ensure that grant activity is recorded in sufficient detail to accurately identify Research and Development Cluster expenditures and classify federal expenditures related to agreements with other state agencies for FY 2025-26. Finally, UW System Administration should ensure that its SEFA compilation process can be completed in a timely manner to meet SCO submission deadlines. Recommendation: We recommend the University of Wisconsin (UW) System Administration: -provide training to UW institutions on its new procedures and on its data requirements for preparing the Schedule of Expenditures of Federal Awards (SEFA) to ensure that UW institutions accurately record, identify, and classify Research and Development Cluster expenditures within the new accounting system; -implement procedures to review whether federal expenditures related to agreements with other state agencies that specify the relevant assistance listing number are properly classified in the SEFA; and -revise and document its procedures by June 30, 2026, to specify how federal grants activities will be compiled accurately and in a timely manner for the FY 2025 26 SEFA using the new accounting system. Finding 2025-702: Research and Development Cluster—Reporting in the Schedule of Expenditures of Federal Awards Research and Development Cluster (various Assistance Listing numbers) Award Numbers Award Years Various Various Questioned Costs: None Dairy Business Innovation Initiatives (Assistance Listing number 10.176) Award Numbers Award Years 21DBIWI1006 2021 AM21DBIWI1010 2022 AM22DBIWI1014 2022 23DBIWI1019 2023 Questioned Costs: None Disability Innovation Fund (Assistance Listing number 84.421) Award Numbers Award Years H421C210018 2021 H421F240107 2024 H421F240111 2024 H421F240139 2024 H421F240143 2024 Questioned Costs: None Type of Finding: Significant Deficiency, Noncompliance Response from the University of Wisconsin System Administration: UW System Administration agrees with the audit finding and recommendations.
(2025-030) Title: Internal control over Health Disparities program SEFA reporting needs improvement Prior Year Findings: None State Department: Administrative and Financial Services State Bureau: Health and Human Services Service Center Federal Agency: U.S. Department of Health and Human Services Assistance Listing Title: Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises Assistance Listing Number: 93.391 Federal Award Identification Number: See E-65 to E-66 Compliance Area: Reporting Type of Finding: Material weakness Material noncompliance Questioned Costs: None Criteria: 2 CFR 200.303; 2 CFR 200.510 The Department must establish, document, and maintain effective internal control over Federal awards that provides reasonable assurance that the Department is managing awards in compliance with Federal statutes, regulations, and the terms and conditions of awards. The Department must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the State’s financial statements which must include the total Federal awards expended. At a minimum, the SEFA must provide total Federal awards expended for each individual Federal program and the Assistance Listing Number and include the total amount provided to subrecipients from each Federal program. Condition: The Department of Health and Human Services’ Service Center must complete and submit exhibits and related schedules to the Office of the State Controller (OSC) at the close of each fiscal year to report Federal award information for inclusion on the State’s SEFA. OSC is responsible for compiling this information on behalf of the State. The Office of the State Auditor reviewed amounts reported on the SEFA for the Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises (Health Disparities) program and identified a $1.2 million revenue transfer incorrectly reported as a reduction to expenditures. As a result, the initial amount reported on the SEFA was understated by $1.2 million. Context: In fiscal year 2025, Health Disparities program expenditures totaled $6.7 million. Cause: • Lack of adequate policies and procedures • Lack of supervisory oversight Effect: • Inaccurate reporting of expenditure amounts on the SEFA, which is submitted to the Federal government, may result in inaccurate information used for programmatic, policy, or statistical purposes. • Noncompliance with Federal regulations Recommendation: We recommend that the Department implement policies and procedures to ensure expenditures are appropriately reported on the SEFA. Corrective Action Plan: See F-19 Management’s Response: The DHHS and the DHHS Financial Service Center agree with this finding. The Service Center will update policies and procedures to ensure expenditures are appropriately reported on the SEFA by August 2026. Contact: Sarah Gove, Director, DHHS Service Center, DAFS, 207-458-6626 (State Number: 25-1123-01)
(2025-037) Title: Internal control over PDG SEFA reporting needs improvement Prior Year Findings: None State Department: Health and Human Services Education Administrative and Financial Services State Bureau: Office of Child and Family Services Office of Teaching and Learning Health and Human Services Service Center Federal Agency: U.S. Department of Health and Human Services Assistance Listing Title: Every Student Succeeds Act/Preschool Development Grants Assistance Listing Number: 93.434 Federal Award Identification Number: See E-65 to E-66 Compliance Area: Reporting Type of Finding: Material weakness Material noncompliance Questioned Costs: None Criteria: 2 CFR.303; 2 CFR 200.510 The Department must establish, document, and maintain effective internal control over Federal awards that provides reasonable assurance that the Department is managing awards in compliance with Federal statutes, regulations, and the terms and conditions of awards. The Department must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the State’s financial statements which must include the total Federal awards expended. At a minimum, the SEFA must provide total Federal awards expended for each individual Federal program and the Assistance Listing Number and include the total amount provided to subrecipients from each Federal program. Condition: The Every Student Succeeds Act/Preschool Development Grants (PDG) program assists states in helping low-income and disadvantaged children enter kindergarten prepared and ready to succeed in school, and helps improve the transitions from the early care and education setting to elementary school. PDG is administered by the Department of Health and Human Services’ (DHHS) Office of Child and Family Services. DHHS has a memorandum of understanding in place with the Department of Education (DOE) to assist in administering PDG. The DHHS Service Center (SC) and DOE must complete and submit exhibits and related schedules to the Office of the State Controller (OSC) at the close of each fiscal year to report Federal award information for inclusion on the State’s SEFA. OSC is responsible for compiling this information on behalf of the State. The Office of the State Auditor (OSA) reviewed amounts reported on the SEFA for PDG and identified both DHHS SC and DOE incorrectly reported direct expenditures and amounts provided to subrecipients. As a result, the initial amount reported on the SEFA was overstated by $2.6 million. In addition, OSA identified $436,074 incorrectly reported as amounts provided to subrecipients that should have been reported as direct expenditures for the program. OSC subsequently corrected the SEFA for all errors identified by OSA. Context: In fiscal year 2025, PDG expenditures totaled $11.5 million. Cause: • Lack of supervisory oversight • Lack of adequate policies and procedures Effect: • Inaccurate reporting of expenditure amounts on the SEFA, which are submitted to the Federal government, may result in incorrect information used for programmatic, policy, or statistical purposes. • Noncompliance with Federal regulations Recommendation: We recommend that the Departments increase oversight and implement policies and procedures to ensure expenditures are appropriately classified and reported on the SEFA. Corrective Action Plan: See F-21 Management’s Response: The DHHS, the DOE and the DHHS Financial Service Center agree with this finding. The Departments will update policies and procedures to ensure expenditures are appropriately reported on the SEFA. Contact: Sarah Gove, Director, DHHS Service Center, DAFS, 207-458-6626 (State Number: 25-1122-01)
(2025-063) Title: Internal control over Medicaid SEFA reporting needs improvement Prior Year Findings: None State Department: Administrative and Financial Services State Bureau: Health and Human Services Service Center Federal Agency: U.S. Department of Health and Human Services Assistance Listing Title: Medicaid Cluster Assistance Listing Number: 93.775, 93.777, 93.778 Federal Award Identification Number: See E-65 to E-66 Compliance Area: Reporting Type of Finding: Significant deficiency Questioned Costs: None Criteria: 2 CFR 200.303; 2 CFR 200.510 The Department must establish, document, and maintain effective internal control over Federal awards that provides reasonable assurance that the Department is managing awards in compliance with Federal statutes, regulations, and the terms and conditions of awards. The Department must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the State’s financial statements which must include the total Federal awards expended. At a minimum, the SEFA must include the total amount provided to subrecipients from each Federal program. Condition: The Department of Health and Human Services’ Service Center must complete and submit exhibits and related schedules to the Office of the State Controller (OSC) at the close of each fiscal year to report Federal award information for inclusion on the State’s SEFA. OSC is responsible for compiling this information on behalf of the State. The Office of the State Auditor reviewed amounts reported on the SEFA and identified $11.8 million of Federal expenditures incorrectly reported as amounts provided to subrecipients that should have been reported as direct expenditures. OSC subsequently corrected the SEFA. Context: In fiscal year 2025, Federal Medicaid expenditures totaled $3.4 billion. Cause: • Lack of adequate policies and procedures • Lack of supervisory oversight Effect: Inaccurate reporting of expenditure amounts on the SEFA, which is submitted to the Federal government, may result in incorrect information used for programmatic, policy, or statistical purposes. Recommendation: We recommend that the Department implement policies and procedures to ensure expenditures are appropriately classified and reported on the SEFA. Corrective Action Plan: See F-31 Management’s Response: The DHHS and the DHHS Financial Service Center agree with this finding. The DHHS Financial Service Center will update policies and procedures to ensure expenditures are appropriately classified and reported on the SEFA by February 2026. Contact: Sarah Gove, Director, DHHS Service Center, DAFS, 207-458-6626 (State Number: 25-1106-03)
Finding 2025-006 – Internal Control Deficiency in Financial Reporting – Untimely Recording of Grant Program Expenditures Cluster: Not applicable Sponsoring Agency: United States Agency for International Development (USAID) Award Name: USAID Foreign Assistance for Programs Overseas Award Number: 7200AA19CA00018, 7200AA21LE00003 Assistance Listing Title: USAID Foreign Assistance for Programs Overseas Assistance Listing Number: ALN 98.001 Award Year: 2024-2025 Pass-through entity: Not applicable Compliance Requirement: Schedule of Expenditure of Federal Awards Reporting and Period of Performance Criteria or Specific Requirement Under 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the same reporting period as its audited financial statements. The SEFA must present the total federal awards expended during that period, as defined in 2 CFR 200.502. The auditee is responsible for ensuring that the SEFA is accurate, complete, and prepared in accordance with all applicable Uniform Guidance requirements. Identified Condition Across three campuses, we noted that one (1) campus converted to a new financial system effective January 1, 2024. As a result of the conversion, subaward advance balances were migrated into new system project codes using expenditure type 140200 – Subaward Advances, and recording the related advance liquidations (i.e., payment for certain expenditure invoices) were delayed. We noted delays in recording ranging from 4 to 12 months. As a result, certain fiscal year (FY) 2024 expenditures were not properly recorded in the FY 2024 SEFA, but instead recorded and reported in the FY 2025 SEFA as follows: Award Numbers: 7200AA19CA00018; 7200AA21LE00003 | Campus-FY2024 Expenditures: $3,498,905 | Campus-Portion Related to Subawardees: $3,477,528 | Campus-% of Total Program FY2025 Expenditures: 41% | % of Total Program FY2025 Expenditures: 32% Cause This condition resulted from delays in processing liquidations of migrated subaward advance balances in the new system until reconciliation of the individual projects set-up for each sub awardee was completed. As a result, there was a significant backlog in processing. Effect The delay in recording the expenditures and liquidating the advances resulted in FY2024 expenditures being incorrectly recorded in fiscal year 2025 for SEFA reporting purposes. Lack of timely recording increases the risk that that expenditures are charged beyond the awards’ authorized periods of performance. Questioned Costs None. Recommendation We recommend that the campus strengthen internal controls over financial reporting to ensure timely reconciliations of subaward account balances and recording such that amounts are allocated, liquidated, and reported in the proper period. This will help ensure timely and accurate financial reporting. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
Finding Reference 2025-02 Assistance Listing Number 21.027 Coronavirus State and Local Fiscal Recovery Funds Name of Federal Agency Department of Treasury Type of Finding Material Weakness on Internal Control and Noncompliance Condition During the audit, management initially provided a Schedule of Expenditures of Federal Awards (SEFA) that required revision because the total federal expenditures reported for Program 21.027, Coronavirus State and Local Fiscal Recovery Funds, were incomplete. Specifically, expenditures totaling $1,084,942 that had already been reported to the pass-through entity were omitted from the SEFA, resulting in an understatement of total federal awards expended under the program. A similar condition was reported in the prior year’s single audit as finding No. 2024-05. Criteria In accordance with 2 CFR § 200.510(b) (Financial Statements and SEFA Requirements), the auditee must: 1. Prepare an accurate SEFA that includes the total federal awards expended for the period under audit. 2. Ensure the SEFA is complete, accurate, and properly classified by fiscal year. 3. Provide sufficient information to allow auditors to test compliance with federal requirements. Cause The errors in the preparation of the SEFA indicate deficiencies in internal controls over the financial reporting process related to federal awards. Specifically, management did not implement sufficient oversight and reconciliation procedures to ensure that all federal expenditures were accurately identified, classified, and reported within the appropriate fiscal year. In addition, the review process over the SEFA prior to submission to the auditors was not adequately designed or executed to detect and correct reporting omissions and misstatements. Effect As a result of the deficiencies in internal controls over SEFA preparation, the Schedule of Expenditures of Federal Awards was initially misstated and required revision to properly reflect total federal awards expended under Assistance Listing No. 21.027. The omission of expenditures increased the risk of material misstatement in the SEFA and could have resulted in an inaccurate representation of federal funding expended by the Authority. Additionally, the failure to initially prepare a complete and accurate SEFA resulted in noncompliance with 2 CFR § 200.510(b), which requires the auditee to provide a full and accurate accounting of federal expenditures for the period under audit. Questioned Costs No questioned costs were identified, as the issue relates to the misclassification and misstatement of expenditures, rather than the allowability of costs. Recommendation To ensure compliance with 2 CFR § 200.510(b) and improve internal controls over SEFA preparation, we recommend that the Authority: 1. Implement a formal review and reconciliation process to ensure federal expenditures are accurately reported in the correct fiscal year. 2. Enhance communication between finance and grant administration personnel to improve accuracy in expenditure classification. 3. Provide additional training to staff responsible for SEFA preparation on Uniform Guidance requirements for federal reporting. 4. Require a final, documented supervisory review of the SEFA before submission for audit to prevent reporting inaccuracies. Views of Responsible Officials Refer to Management’s unaudited corrective action plan.
Criteria or Specific Requirement: Entities receiving federal awards must identify in its accounts all federal awards expended and report those amounts on the Schedule of Expenditures of Federal Awards for the period the federal award was expensed. Specifically, in accordance with Uniform Administrative Requirements outlined in 2 CFR 200, the guidance states: • Per 2 CFR 200.502, the determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs. • Per 2 CFR 200.303, entities must establish and maintain internal controls which provide reasonable assurance that federal award expenditures are in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. • In addition, per 2 CFR 200.510, the Schedule of Expenditures of Federal Awards (SEFA) must be prepared to reflect the awards for the period covered by the auditee’s financial statements. 2 CFR 200.510 also states that for costs to be allowable, they should be determined in accordance with generally accepted accounting principles (with exceptions provided in that part). Condition: The University’s year-end cutoff controls allowed for certain costs from Fiscal Year 2023 and Fiscal Year 2024 to be reported in the Fiscal Year 2025 SEFA. Context: During our testing of 40 payroll transactions, we found 1 instance of payroll related expenses that were incurred during Fiscal Year 2023 being charged to the federal program in Fiscal Year 2025 and 12 instances of payroll related expenses that were incurred during Fiscal Year 2024 being charged to the federal program in Fiscal Year 2025. Questioned Costs: Known amounts of Fiscal Year 2023 costs included in the Fiscal Year 2025 SEFA was $813 and known amounts of Fiscal Year 2024 costs included in the Fiscal Year 2025 SEFA was $23,838. Cause: Per the University, the cause for the 13 exceptions was due to the University improperly identifying the awards as State funded at inception. During Fiscal Year 2025, the University discovered that the award through the State of Oregon was Federally funded and re-indexed costs previously recorded on the State award indexes to Federal award indexes. During the re-indexing of these costs, the transaction dates of costs that were incurred during Fiscal Year 2023 and Fiscal Year 2024 were recorded with dates in Fiscal Year 2025 causing them to be included in the Fiscal Year 2025 SEFA. Effect: The University was out of compliance as it relates to identifying and reporting federal costs in the period incurred. Repeat Finding: No Recommendation: We recommend that the University evaluate its cutoff procedures to ensure that federal costs are identified and reported in the correct fiscal year. We also recommend that the University evaluate its internal controls to ensure that federal awards are properly identified as such at inception. Views of Responsible Officials: Management agrees with the finding and has developed a plan to correct the finding.
Criteria: Management is responsible for the preparation and fair presentation of the financial statements in accordance with U.S. generally accepted accounting principles (GAAP), including the proper timing of revenue recognition for costreimbursement grants in accordance with Accounting Standards Codification (ASC) 958. In addition, 2 CFR 200.303 – Internal Controls requires nonfederal entities to establish and maintain effective internal control over financial reporting and compliance to provide reasonable assurance that transactions are recorded in the proper accounting period. Further, 2 CFR 200.510(b) requires the auditee to prepare a Schedule of Expenditures of Federal Awards (SEFA) that accurately reflects federal expenditures for the fiscal year. Condition: During the audit, it was identified that cash received from federal granting agencies under cost-reimbursement grants prior to year-end were appropriately recorded as refundable advances; however, reimbursable expenditures incurred prior to year-end were not fully recognized as contribution revenue and federal expenditures in the appropriate fiscal year. As a result, audit adjustments were required to recognize contribution revenue and federal expenditures related to costs incurred prior to year-end and to update the SEFA to reflect the corrected expenditures. The updated SEFA resulted in an additional federal program being identified as a major program subject to audit. Cause: Internal controls were not sufficiently designed to ensure that reimbursement requests submitted to federal granting agencies were evaluated and incorporated into the revenue recognition and SEFA preparation process. Specifically, while cash received in advance was properly recorded as refundable advances, management did not have a control in place to identify reimbursable expenditures incurred prior to year-end and convert refundable advances to contribution revenue and federal expenditures in the appropriate fiscal period. Effect: Failure to recognize reimbursable grant revenue and federal expenditures in the proper fiscal year resulted in the understatement of contribution revenue and federal expenditures, including amounts reported on the SEFA, prior to audit adjustments. This condition affected the determination of major programs and increased the risk that federal awards may not be accurately reported for audit purposes. Questioned Costs: None. Recommendation: We recommend that management strengthen internal controls over cost-reimbursement grant accounting by implementing procedures to ensure that reimbursable expenditures are identified, reviewed, and recorded in the appropriate fiscal year. This should include reconciliation of reimbursement requests, refundable advances, recorded revenue, and amounts reported on the SEFA, along with documented supervisory review of year-end cutoff procedures. Views of Responsible Officials: Management acknowledges the above finding and will continue to enhance its year-end grant review and reconciliation procedures. During the year ended June 30, 2025, management implemented enhanced grant accounting practices, including engaging an outsourced accounting firm. Management also clarified roles and responsibilities related to federal reporting requirements and implemented additional oversight and training. Management remains committed to the ongoing improvement of internal controls over federal grant reporting and compliance.
Program: Congressionally Recommended Awards / HOME Investment Partnerships Program / Homeland Security Grant Program / Epidemiology and Laboratory Capacity for Infectious Disease Federal Financial Assistance Listing Number: 16.753 / 14.239 / 97.067 / 93.323 Federal Grantor: U.S. Department of Justice / U.S. Department of Housing and Urban Development / U.S. Department of Homeland Security / U.S. Department of Health and Human Services Award No. and Year: Multiple Compliance Requirements: Other – Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of Expenditures of Federal awards Type of Finding: Material Weakness in Internal Control Over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the County) must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total federal awards expended as determined in accordance with §200.502. §200.331 of the Uniform Guidance states the County is responsible for making case-by-case determinations to determine whether the entity receiving the Federal funds is a subrecipient. In addition, §200.303 of the Uniform Guidance states that the County must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA we noted the following: • The Sheriff-Coroner Department did not properly identify the amount expended for the Congressionally Recommended Awards, AL No. 16.753. The expenditures reported by the Department were overstated by $2,638,516. • The Orange County Community Resources Department did not properly identify the amount of Federal funding passed through to subrecipients for the HOME Investment Partnerships Program, AL No. 14.239. The amount passed through to subrecipients reported by the Department was overstated by $4,500,624. • The Sheriff-Coroner Department did not properly identify the amounts expended for the Homeland Security Grant Program, AL No. 97.067. The expenditures reported by the Department were overstated by $715,489. • The Orange County Health Care Agency (HCA) did not properly identify the amount expended for the Epidemiology and Laboratory Capacity for Infectious Disease program, AL No. 93.323. The expenditures reported by the Agency were overstated by $486,000. Cause: As a result, the County lacked adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the County’s processes for recording and tracking expenditures of Federal awards are not designed so that expenditures are identified when incurred. In addition, the County’s processes for identifying and reporting subrecipients are not designed to ensure appropriate reporting on the SEFA. Effect: Adjustments to the SEFA were required. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures and amounts passed through to subrecipients were reconciled to the supporting records. Repeat Finding from Prior Years: No. Recommendation: The County, including all its reporting departments, should follow existing policies, procedures and internal controls to ensure all expenditures and amounts passed through to subrecipients are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. Views of Responsible Officials: See separately issued Corrective Action Plan.
25-03(Reference per Financial Statements)Material Audit Adjustments Affecting the SEFA U.S. Treasury Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listings #: 21.027 FAIN: SLFRP5410 Federal Award Date: March 3, 2021 Pass-Through Grant #: A-23-R013 Period of Performance: 4/24/2023 – 6/01/2026 Compliance Requirement: Reporting Questioned Costs: $0 Criteria: According to 2 CFR 200.510 of the Code of Federal Regulations, the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 where it states, “The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity related to the Federal award pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as expenditure/expense transactions associated with grants.” Condition: As mentioned in finding 25-01 above, several audit adjustments were proposed and posted to the Town’s trial balance to correct material misstatements. The material adjustments were related to required expenditure/expense accruals for construction projects and related grant revenues/receivables. This directly impacted the amounts reported in the SEFA for ALN 21.027. Effect of Condition: Without the proposed audit adjustments, the Town’s financial statements would have been materially misstated, including the SEFA. Cause: There was a failure to accrue, as accounts payable, several construction invoices at year-end which were federal grant expenses. Related grant revenues and receivables were also not recorded. Recommendation: Care should be taken at each year-end to ensure that all revenues and expenditures/expenses are reported in the proper period, including accrual of all earned revenues and incurred expenditures/expenses. The adjustments should either be made to the ledger or information related to the accruals should be provided to the auditor before audit procedures commence. Views of Responsible Officials and Planned Corrective Action: Management agrees with the auditor’s recommendations. The Town will review each revenue and expenditure/expense account at year-end and ensure that all accruals of earned revenues and incurred expenses are made and reported in the proper period or that information is provided to the auditor before audit procedures commence.
25-04(Reference per Financial Statements) Material Audit Adjustments Affecting the SEFA Environmental Protection Agency Program Name: Drinking Water State Revolving Fund Assistance Listings #: 66.468 Federal Award Date: March 13, 2024 Pass-Through Grant #: CF3-23-3210002-04 Period of Performance: 3/13/2024 – 6/01/2026 Compliance Requirement: Reporting Questioned Costs: $0 Criteria: According to 2 CFR 200.510 of the Code of Federal Regulations, the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 where it states, “The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity related to the Federal award pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as expenditure/expense transactions associated with grants.” Condition: As mentioned in finding 25-01 above, several audit adjustments were proposed and posted to the Town’s trial balance to correct material misstatements. The material adjustments were related to required expenditure/expense accruals for construction projects and related grant revenues/receivables. This directly impacted the amounts reported in the SEFA for ALN 66.468. Effect of Condition: Without the proposed audit adjustments, the Town’s financial statements would have been materially misstated, including the SEFA. Cause: There was a failure to accrue, as accounts payable, several construction invoices at year-end which were federal grant expenses. Related grant revenues and receivables were also not recorded. Recommendation: Care should be taken at each year-end to ensure that all revenues and expenditures/expenses are reported in the proper period, including accrual of all earned revenues and incurred expenditures/expenses. The adjustments should either be made to the ledger or information related to the accruals should be provided to the auditor before audit procedures commence. Views of Responsible Officials and Planned Corrective Action: Management agrees with the auditor’s recommendations. The Town will review each revenue and expenditure/expense account at year-end and ensure that all accruals of earned revenues and incurred expenses are made and reported in the proper period or that information is provided to the auditor before audit procedures commence.
2025-001 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards and Reporting for Maine DHHS 93.044, 93.045, 93.053 Aging Cluster and Maine DHHS 93.778 Medical Assistance Program (Significant Deficiency in Internal Controls over Compliance and Noncompliance) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, £200.508(b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Federal reporting standards require the timely and accurate filing of reports as required by pass-through grantor agreements. Condition and Context: Agreement Closeout Report filed for the Agreement ADS-24-3355B (Medical Assistance Program) for the component period ended 9/30/24 was filed late by 3 days. Federal expenditures were understated for Agreement ADS-24-3355B (93.791 Money Follows the Person Rebalancing Demonstration) by $59,405 due to errors in reconciling grant reports to the SEFA. For the Agreement ADS-24-3004C reporting for the component period ended 9/30/24 contained inaccuracies resulting from budgeted percentage of expenses reimbursable by state and federal agreement funds. Cause: There is a gap in training and understanding of the instructions for the Maine DHHS Agreement Closeout Report and Quarterly Financial Report. There are insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: The Agreement Closeout Report was filed 3 days late. Agreement Cost Sharing percentages were incorrectly used on reporting forms. Key information was omitted which prevented the quarterly reports from calculating the amounts due to or from the Agency. Errors in reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. They could also lead to findings and corrective action with funders. Recommendation: Management should review their processes and procedures over preparation and review of reporting, and for tracking of reporting deadlines. Both the preparer and reviewer should have a clear understanding of the required elements and instructions. As part of the review, required elements should be vouched to original source documents including copies of awards, grant reports, and the trial balance profit and loss reports. Any inconsistencies should be resolved before submission. Management should consider training for staff tasked with completing, reviewing, and filing these reports. Views of Responsible Officials and Planned Corrective Actions: Management will review and update processes and procedures over reporting and additional training will be provided as needed to ensure accurate grant reporting and compliance.
Inadequate Internal Controls Over Compliance Related to Identification and Reporting of Assistance Listing Numbers (ALNs) in Schedule of Expenditures of Federal Awards Federal Program State Energy Program ALN 81.141 Energy Efficiency and Conservation Block Grant ALN 81.128 Name of Federal Agency U.S. Department of Energy Compliance Requirement Reporting Type of Finding Internal control over compliance/non-compliance Category Significant deficiency on internal controls over compliance and Other Matter. Criteria Title 2 CFR §200.303 requires non-Federal entities to establish and maintain effective internal control over Federal awards that provides reasonable assurance that the entity is managing the awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Additionally, 2 CFR §200.510(b) requires the Schedule of Expenditures of Federal Awards (SEFA) to include the correct Assistance Listing Number (ALN) for each Federal program. Proper identification of ALNs is essential, as different ALNs may be subject to different compliance requirements under the Uniform Guidance and program-specific terms and conditions. Condition During our review of the Schedule of Expenditures of Federal Awards (SEFA), we noted that Federal funds received under the U.S. Department of Energy were not consistently identified and documented under the correct Assistance Listing Numbers. Specifically, expenditures related to ALNs 81.141 and 81.128 were not clearly distinguished or were incorrectly classified. The entity did not have sufficient internal controls in place to ensure that Federal awards were properly identified by ALN at the time funds were received and subsequently recorded and reported on the SEFA. Cause The condition resulted from inadequate internal controls over compliance related to: •The identification of Federal awards upon receipt of funds; •The documentation and tracking of ALNs throughout the grant lifecycle; and •The preparation and review of the SEFA to ensure accurate classification by ALN. Management relied on informal processes and did not implement a formal review or reconciliation procedure to verify that Federal expenditures were recorded under the correct Assistance Listing Numbers. Effect Failure to correctly identify and document the applicable ALN may result in noncompliance with Federal requirements, as different ALNs can carry different compliance requirements, including but not limited to: •Allowable costs and activities. •Period of performance •Reporting requirements •Special tests and provisions; and •Subrecipient monitoring requirements. Misclassification of expenditures by ALN increases the risk that the entity may apply incorrect compliance requirements to a Federal award, potentially leading to unrecognized instances of noncompliance and inaccurate reporting on the SEFA. Additionally, incorrect ALN reporting may affect the determination of major programs and the scope of Single Audit testing. Context Two (2) out of a total of fifteen (15) Federal programs were not consistently identified and documented under the correct Assistance Listing Numbers. Questioned Costs None. Identification as a Repeated Finding This is not a repeat finding from the immediate previous audit. Recommendation We recommend that management strengthen internal controls over compliance by: 1. Implementing formal procedures to identify and document the correct ALN at the time Federal funds are received. 2. Maintaining detailed grant tracking records that clearly link expenditures to the appropriate ALN. 3. Establishing a supervisory review process over the preparation of the SEFA to verify the accuracy and completeness of ALN classifications prior to submission. Views of responsible officials and planned corrective actions Management of the Department agrees with this finding. Refer to the corrective action plan on pages 114-119.
Program: COVID-19 - Epidemiology and Laboratory Capacity for Infectious Disease (ELC) Assistance Listing No.: 93.323 Federal Grantor: U.S. Department of Health and Human Services Passed-through: California Department of Public Health Award No.: COVID-19ELC114 Award Year: 2021 Compliance Requirement: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of Expenditures of Federal Awards Type of Finding: Material Weakness in Internal Control Over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the County) must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total federal awards expended (including amounts provided to subrecipients) as determined in accordance with §200.502. In addition, section 200.303 of the Uniform Guidance states that recipients and subrecipients must establish effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the ELC program, we noted the County initially reported expenditures totaling $408,471 that should have been reported on the FY 2024 SEFA, as the County incurred the expenditures prior to June 30, 2024. The June 30, 2025 SEFA was corrected for this reporting error. Cause: The County did not have adequate internal controls to ensure the Schedule was prepared completely and accurately. Effect: Prior to the correction, expenditures for the ELC program were overstated by $408,471. We noted the FY 2024 expenditures incorrectly reported on the FY 2025 SEFA did not have a direct and material effect on the FY 2024 SEFA. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used; all program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from Prior Years: No. Recommendation: We the recommend the County enhance internal controls to ensure federal expenditures are reported accurately and completely on the SEFA in accordance with the Uniform Guidance. Views of Responsible Officials: Management agrees. See separately issued Corrective Action Plan.
Assistance Listing Number, Federal Agency, and Program Name 14.157 U.S. Department of Housing and Urban Development Supportive Housing for the Elderly (Section 202) Capital Advance Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness and material noncompliance with laws and regulations Repeat Finding No Criteria 2 CFR 200.508 states in part: "The auditee must:... (b) Prepare financial statements, including the schedule of expenditures of Federal awards in accordance with § 200.510." 2 CFR 200.510(b) states in part: The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with § 200.502. The schedule must... (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This requirement is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule." Condition During the years ended June 30, 2023, 2024, and 2025, National Church Residences entered into capital advance grant agreements (Section 202) with HUD, which were directly funded to affiliates of National Church Residences, and, in turn, National Church Residences entered into notes receivable from the related parties in the same amount as the capital advance. The loan expenditures and outstanding loan balances related to the ALN 14.157 U.S. Department of Housing and Urban Development Supportive Housing for the Elderly (Section 202) Capital Advance were not included on the SEFA for the years ended June 30, 2025, 2024, and 2023. Questioned Costs None If Questioned Costs are Not Determinable, Description of Why Known Questioned Costs Were Undetermined or Otherwise Could Not be Reported N/A Identification of How Questioned Costs Were Computed N/A Context Federal expenditures related to ALN 14.157 U.S. Department of Housing and Urban Development Supportive Housing for the Elderly (Section 202) Capital Advance were not included on the SEFA prior to audit entries for the years ended June 30, 2025, 2024, and 2023. Cause and Effect Management had not established a system of internal control that would have ensured proper reporting of the SEFA. Without a proper system of internal control in place that operated effectively, material misstatements of the SEFA remained undetected. Prior to audit entries being made, the SEFA was understated by $9,411,680, $8,049,840, and $3,111,409 at June 30, 2025, 2024, and 2023, respectively. Recommendation National Church Residences accounting and development should consider all relative accounting guidance and agreements for related party transactions and grant/debt agreements (including capital advances) to ensure all federal expenditures are properly included on the SEFA. Views of Responsible Officials and Corrective Action Plan National Church Residences is in the process of establishing additional layers of internal controls to help ensure that all new agreements and any subsequent modifications are captured timely, completely, and accurately within the special purpose financial statements and SEFA.
Federal Assistance Listing Number: 20.205, 20.513 Federal Program Name: Highway Planning and Construction, Transit Services Programs Cluster Federal Agency: U.S. Department of Transportation Pass-through Agency: State of California Department of Transportation, Los Angeles County Metropolitan Transportation Authority (LACMTA) Federal Award Number: N/A for ALN 20.205, CA-2023-236-00 for ALN 20.513 Criteria: Per 2 CFR 200.510(b), Financial statements, the auditee is required to prepare a complete and accurate SEFA that reflects actual federal expenditures incurred during the reporting period. In addition, 2 CFR 200.303, Internal controls, requires the auditee to establish and maintain effective internal control over compliance to provide reasonable assurance that federal program information, including SEFA reporting, is accurate, reliable, and free from material misstatement. Condition: During our audit, we identified that the expenditures reported for the Highway Planning and Construction Program in the SEFA included $431,605 in state-funded expenditures that were incorrectly reported as federal expenditures. This resulted in a material overstatement of federal expenditures for the program. A correction was subsequently made to remove the state-funded portion, materially reducing the total federal expenditures reported on the SEFA. We also identified an error within the Transit Services Programs Cluster involving an incorrect federal award identification number. One program was initially reported under federal award number CA-2020-167, which did not correspond to the related federal grant. The correct federal award number is CA-2023-236-00. The City has since updated the SEFA to reflect the accurate award number. Cause: The overstatement and incorrect reporting occurred because internal controls over the SEFA preparation and review process did not provide adequate assurance that expenditures and award information were accurately classified and reported. Review procedures were not designed or executed at a level sufficient to detect that state-funded costs had been commingled with federally reimbursable expenditures prior to SEFA compilation. The controls also did not ensure that grant identification details were verified against current federal award agreements, which allowed one program to be reported with an incorrect federal award identification number. Effect: Because non-federal expenditures were included in the SEFA, the federal expenditures reported for the Highway Planning and Construction Program were materially overstated. The incorrect federal award identification number in the Transit Services Programs Cluster also reduced the accuracy and clarity of the SEFA and created a risk of misidentifying the applicable federal grant award, which could affect federal monitoring or audit oversight. Taken together, these issues increase the likelihood of inaccurate reporting to federal and pass-through agencies, may influence the determination of major programs, and could affect the City’s compliance with federal reporting requirements. Questioned Costs: None. Recommendation: The City should strengthen its internal review procedures for preparing the SEFA to ensure that only federally eligible expenditures are reported and that all program information aligns with current federal award documents. This should include a more detailed reconciliation of project expenditures and award data to their underlying funding sources before amounts are compiled, along with a documented supervisory review to confirm accuracy. Staff responsible for SEFA preparation should receive additional guidance on distinguishing federal from non-federal costs and on verifying federal award identification numbers. Implementing a standardized SEFA preparation checklist and requiring formal sign-off at key review stages would help ensure that errors are identified and corrected before the SEFA is finalized. Views of Responsible Officials and Planned Corrective Action: The City is taking corrective action in response to this finding by strengthening its grant management procedures. The Director of Community Development and Public Works is responsible for overseeing these improvements, which include enhancing coordination among the Public Works Analyst, Grants Coordinator, and the City's contracted engineering firm to clearly distinguish between federally and state-funded Highway Safety Improvement Program (HSIP) activities and ensure that program information aligns with current federal award documents. Key measures include requiring identification of funding sources in Staff Reports submitted to City Council prior to grant application submission, assigning unique project numbers and classifications within the City's financial system (Incode), implementing a reconciliation process to accurately align project expenditures with their funding sources before inclusion in the Schedule of Expenditures of Federal Awards (SEFA), and providing targeted staff training along with a standardized SEFA preparation checklist. All corrective actions are set for implementation effective March 18, 2026. Personnel responsible for implementation: Gerardo Marquez Position of personnel responsible: Director of Community Development and Public Works Expected date of implementation: March 18, 2026
Finding No: 2025-002– Failure to Prepare the Schedule of Expenditures of Federal Awards (SEFA) Federal Programs ALN 21.027, Coronavirus State and Local Fiscal Recovery Funds - ARP Act ALN 97.036, Disaster Grants - Public Assistance (Presidentially Declared Disasters) Name of Federal Agency US Department of Treasury (Pass-through from the Puerto Rico Coronavirus Relief Fund Disbursement Oversight Committee) U.S. Department of Homeland Security (Pass-through program from The Central Office of Recovery, Reconstruction and Resiliency) Category Internal Control; Compliance. Compliance Requirement Reporting Criteria Title 2 U.S. Code of Federal Regulations (CFR) Part 200.510(b) requires the auditee to prepare a Schedule of Expenditures of Federal Awards that includes, at a minimum: • The total federal awards expended for each federal program and CFDA/Assistance Listing number; • The name of the federal agency and pass-through entity, if applicable; • The amount provided to subrecipients, if applicable. Condition The Administration did not prepare the Schedule of Expenditures of Federal Awards (SEFA) for the fiscal year ended June 30, 2025. As a result, the SEFA was not available at the time of the audit and had to be prepared with the assistance of the auditors. Cause Management lacks adequate procedures over the identification, accumulation, and reporting of federal award expenditures necessary to prepare the SEFA. Effect The failure to prepare the SEFA increases the risk that federal expenditures may be incomplete or inaccurate, which could result in noncompliance with Uniform Guidance requirements and improper determination of major programs. Context The Schedule of Expenditures and Federal Awards was not available at the time of the audit and had to be prepared with the assistance of the auditors. Identification of repeat finding None. Questioned costs None. Recommendation We recommend that management establish and maintain effective internal controls and procedures to ensure the SEFA is prepared, reviewed, and completed in accordance with 2 CFR 200.510(b) on a timely basis. Views of responsible officials and planned corrective actions We agreed with the auditors’ finding and recommendation. See further details regarding this matter within the Corrective Action Plan .
Failure to Identify Single Audit Requirement and Federal Awards (Significant Deficiency in Internal Control) Criteria: In accordance with 2 CFR §200.501, a non-federal entity that expends $750,000 or more in federal awards during the fiscal year is required to have a Single Audit conducted. Additionally, 2 CFR §200.510(b) requires the auditee to prepare a Schedule of Expenditures of Federal Awards (SEFA) that accurately identifies all federal awards expended, including Assistance Listing (ALN) numbers and pass-through entity information.Condition: The auditee did not identify that it met the threshold requiring a Single Audit. In addition, the auditee did not have adequate processes in place to identify and track all federal funds received and expended during the fiscal year. As a result, the initial SEFA prepared by the auditee was incomplete and did not include all federal awards.Context: The deficiency affected the auditee’s process for identifying and reporting federal expenditures across all applicable programs during the fiscal year.Cause: The deficiency is due to a lack of internal controls over identifying federal funding sources and monitoring cumulative federal expenditures, as well as insufficient understanding of Uniform Guidance requirements related to Single Audits and SEFA reporting.Effect: Failure to identify all federal awards and the requirement for a Single Audit resulted in incomplete financial reporting and increases the risk that compliance requirements applicable to federal programs may not be identified or followed. This condition could result in noncompliance with federal regulations and inaccurate reporting of federal expenditures.Recommendation: We recommend that the auditee implement and document procedures to: • Identify all sources of federal funding, including reviewing grant and contract agreements for federal involvement • Track federal expenditures by program and funding source throughout the year • Perform a year-end assessment to determine whether the Single Audit threshold has been met • Ensure the SEFA is complete and accurate, including all required elements • Provide training to relevant personnel on Uniform Guidance and Single Audit requirements Views of Responsible Officials: Management agrees with the finding and has developed a corrective action plan to address the deficiencies noted. The plan includes implementing procedures to identify and track federal awards and ensure compliance with Single Audit requirements, and will be implemented during the next fiscal year. Auditor’s Conclusion: This deficiency represents a significant deficiency in internal control over financial reporting and internal control over compliance, as the controls over identifying, tracking, and reporting federal awards were not sufficient to ensure a complete and accurate SEFA or timely identification of the need for a Single Audit.
2025-003: Noncompliance related to SEFA, FAC Reports, and Single Audits for fiscal years ended June 30, 2022, 2023, and 2024 Federal Assistance Listing Number: 10.553, 10.555, 10.559, 84.041, 84.010A, 84.060, 84.358B, 84.365, 84.367, 84.323, 84.424A, 84.425D, 84.425U, 84.048, 94.243, and others potentially unknown in prior years. Federal Award Year(s): Multiple Program Title(s): Multiple Name of Federal Agency(ies): U.S. Department of Agriculture, U.S. Department of Education, and U.S. Department of Health and Human Services Name of Pass-Through Entity(ies): Various, including the Colorado Department of Education, Colorado Community Colleges System, and Colorado Department of Human Services COVID-19 Program(s): Yes Criteria: Section 200.510b of the Code of Federal Regulations Title 2, Subtitle A, Chapter II, Part 200, Subpart F (also known as 2CFR200) states that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements. The schedule must include the total Federal awards expended as determined in accordance with section 200.502. In addition, in accordance with Section 200.501(a) and (b) of the 2CFR200, a non-Federal entity that expended $750,000 or more in Federal awards during the non-Federal entity’s fiscal year (2022, 2023, and 2024) must have a Single Audit conducted on major Federal programs in accordance with 200.514. The FAC report is required to be submitted the earlier of 30 calendar days after receipt of the auditor’s report, or nine months after the end of the audit period. Condition: The District has not prepared a schedule of expenditures of federal awards (SEFA), did not have an auditor conduct Single Audits on major Federal programs, and failed to submit the required report to the Federal Audit Clearinghouse (FAC.gov) for the fiscal years ended June 30, 2022, 2023, and 2024 (prior three fiscal years). The FAC report is required to be submitted the earlier of 30 calendar days after receipt of the auditor’s report, or nine months after the end of the audit period. Cause: The District lacked internal controls and awareness of the requirements noted above to prepare the SEFA, conduct an annual Single Audit, and submit an annual FAC.gov report in a timely manner. Effect: The District was noncompliant with multiple requirements of the 2CFR200 for fiscal years ended June 30, 2022, 2023, and 2024. This noncompliance impacts multiple federal grant programs and may impact future federal awards and require increased oversight, heightened risk classification, and/or special monitoring, if imposed by the grantor. The District had conversations with the Colorado Department of Education and obtain an understanding of the impacts of this noncompliance. Additional requirements may be imposed on the District by grantors as a result of this noncompliance and backlog of Single Audits on major Federal programs. Repeat Finding: No. Questioned Costs: Questioned costs are not known, because the Single Audits on major Federal programs for fiscal years ended June 30, 2022, 2023, and 2024, was not performed. However, there is likelihood and potential for questioned costs or fraud that has not been identified without the completion of the Single Audits on major Federal programs. Recommendation: The District must discuss with the grantors regarding this noncompliance and potential remedies, including the backlog of Single Audits on major Federal programs for fiscal years ended June 30, 2022, 2023, and 2024. In the future, we highly recommend that the District maintain proper internal controls and accurate grant records to prepare an accurate SEFA that will allow auditors to perform the Single Audits on major Federal programs, and submit the FAC report in a timely manner. We also recommend that the District evaluate the options to remedy the backlog of Single Audits and internally determine the best course of action for the District.
Internal Control over Preparation of the Schedule of Expenditures of Federal, State, and City Awards (SEFA), Assistance Listing Numbers (ALNs) - All Condition: Management’s SEFA did not include the ALNs for all of its federal awards with expenditures during the fiscal year. Criteria: “A non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of the Uniform Guidance Part 2 CFR section 200.50 (a). In order to accomplish this, “The auditee must also prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502” per Part 2 CFR section 200.510 (b) of the Uniform Guidance. This guidance includes the requirement that the SEFA include the ALN for each grant award included in the schedule. Cause: When awards are received during the year, management does not confirm the source of funding or the ALN with the awarding agency. Effect: The SEFA provided by management in advance of the audit was misstated because two (2) federal awards with expenditures totaling $1,695,881 were excluded. This had a direct and material effect on the audit of the major programs. Context: The Chief Financial Officer (CFO) relies on pass-through agencies to provide the funding sources, including the related ALN. Two of the award agreements did not include this information, and it was only identified that the programs were federally funded upon receipt of the audit confirmation responses. As a result, the SEFA initially provided by the CFO did not include these two programs. Recommendation: We recommend management implement policies and procedures in which the funding source of all awards (including ALN) be obtained from funders at the time that all awards are granted. View of responsible officials and Planned Corrective Actions: ECA agrees with this finding and has created a policy for identification and verification of funding sources for all contracts. This will ensure that all contracts are screened for federal funding regardless of what is listed in the contract/award/agreement. ECA will review its existing contracts to confirm all funding sources.
Section III – Federal Award Findings or Questioned Costs 2025-001 – Completeness of certain programs on the prior years’ Schedules of Expenditures of Federal Awards (SEFA) Cluster: Not applicable Sponsoring Agency: Federal Emergency Management Agency (FEMA) Award Names: Presidential Disaster Declaration for Severe Storms, Straight-line Winds, and Flooding May 3-4, 2020; Presidential Disaster Declaration for COVID-19 beginning January 2020; Presidential Disaster Declaration for Severe Storms, Tornados, Straight-Line Winds and Flooding March 3, 2020 Award Numbers: FEMA-4550-DR-TN; FEMA-4514-DR-TN; FEMA-4476-DR-TN Assistance Listing Titles: Disaster Grants – Public Assistance (Presidentially Declared Disasters) Assistance Listing Numbers: 97.036 Award Year: 2022, 2024 Pass-through entity: Not applicable Criteria 2 CFR 200.510 Financial statements requires auditees to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. The information presented should be consistent with accounting records and other federal guidance. Condition The following errors were identified related to funding that was improperly excluded from prior year SEFAs and is being included in the FY2025 SEFA: • FEMA funding obligated and expended in FY2022 totaling $11.9 thousand, which was incorrectly excluded from the FY2022 SEFA. Management has included this amount on the FY2025 SEFA. • FEMA funding obligated and expended in FY2024 totaling $1.7 million, which was incorrectly excluded from the FY2024 SEFA. Management has included this amount on the FY2025 SEFA. These errors did not impact the major program determination in the affected years. Cause The errors identified in the SEFA occurred because the organization did not have comprehensive and well-documented policies and procedures to ensure that all federal awards expended were consistently and accurately identified and reported. Additionally, there was insufficient communication with personnel responsible for compiling the SEFA. These factors collectively resulted in incomplete reporting and the exclusion of certain federal expenditures. Effect A SEFA that is not complete and accurate could impact the scoping of an entity’s major programs and result in incomplete information being provided to the federal government. Questioned Costs None noted. Recommendation We recommend NES review their policies and procedures to identify Federal awards expended in accordance with 2 CFR 200.502 and provide training to personnel. Additionally, we recommend updates on federal programs be periodically provided to the team that is responsible for the compilation of the SEFA. This will allow for a more comprehensive understanding of grant activity and the ability to better review and assess the completeness and accuracy reported for these programs on NES’s year-end SEFA. One means by which this might be accomplished is to develop a checklist of anticipated awards in advance of the year and also complete an interim SEFA to identify inconsistencies earlier in the fiscal year.
Type of finding: Federal Award Situation: Significant deficiency; compliance with federal regulations. Federal Program: All Programs Compliance Requirements: Reporting Prior-Year(s) Audit Finding(s): 2024-006, 2023-005, 2022-007, 2021-006 Questioned Costs: None Condition: The Single Audit reporting package, as defined and required in 2 CRF 200.512 for fiscal year ended June 30, 2025, was not submitted before the deadline established by the federal government. Context: The Municipality is required by law to design and implement procedures that support the preparation of its financial statements. The Municipality could not provide, on a timely basis, the information needed to complete the audit of their financial statements before the due date established by the federal government. Criteria: As per 2 CRF 200.12, the audit, data collection form, and reporting package must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report, or nine months after the end of the audit period. 2 CRF 200.508 states that it is the auditee's responsibility to (1) prepare financial statements, including the schedule of expenditures of federal awards in accordance with 2 CFR 200.510, (2) promptly follow up and take corrective action on audit findings, including preparing a summary schedule of prior audit findings and a corrective plan, and (3) provide the auditor access to personnel, accounts, books, records, supporting documentation, and any other information needed for the auditor to perform the audit required by this part, among other things. Cause: The Municipality’s accounting system does not provide the necessary information for the compilation of their financial statements. In order to address this situation, the Municipality has engaged a consultant to assist with the preparation, analysis, and necessary adjustments to prepare the Municipality’s financial statements. However, this procedure involves the participation of various municipal employees at different levels in the Municipality’s organizational structure which adds time to an already time-consuming task. The financial statements are finally available for audit after being approved by the Municipality. The Municipality issued their June 30, 2024 on July 2, 2025 and submitted their data collection form on July 21, 2025. This situation prevented the timely submission of the current fiscal year Single Audit reporting package. Effect: Because of the situation described above, the financial records needed for the preparation and subsequent audit of the financial statements were not obtained timely. The Municipality did not comply with the report submission requirement since the audit was not submitted within nine months after their fiscal period end date. Auditor’s recommendation: Management should continue to fulfill their auditee responsibilities as stated in 2 CRF 200.508, which among other things, require management to prepare appropriate financial statements and provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit to ensure that subsequent financial reporting packages are submitted timely. Views of Responsible officials and Corrective Actions: The Municipality shall establish procedures, training programs, and internal controls to ensure compliance with the preparation and timely submission of the Single Audit Report to the Federal Audit Clearinghouse, as required by the OMB Super Circular Uniform Guidance and in accordance with the nine-month deadline established therein. In addition, the Department of Finance will monitor the progress of the work, including the preparation of financial statements, as well as the external audit and the single audit, so that for the fiscal year ending June 30, 2026, the reports are submitted by the established deadline of no later than March 31, 2027. Audit Status: Unresolved
Reference Number 2025-004 Evaluation of Finding Material Weakness and Noncompliance: Incomplete Schedule of Expenditures of Federal Awards Condition The City failed to provide a complete schedule of expenditures of federal awards (SEFA) for the fiscal year, leading to inaccuracies pertaining to the ARPA program. This omission resulted in a direct impact on the determination of major programs. Criteria According to the Government Auditing Standards (Yellow Book) and the Uniform Guidance, 2 CFR Part 200, Subpart F—Audit Requirements, sections 200.508 and 200.510, entities receiving federal awards must prepare and submit a complete and accurate SEFA as part of their annual financial reporting. This schedule is crucial for auditors to determine major programs and conduct the necessary audits in compliance with federal regulations. Cause of Condition The incomplete SEFA was caused by a lack of oversight and insufficient internal controls within the City's financial management department. Effect or Potential Effect The failure to provide a complete SEFA has significant implications, including: • Inaccurate determination of major programs, which can affect the scope and quality of the audit process. • Increased risk of non-compliance with federal regulations, potentially leading to financial penalties and loss of federal funding. Recommendation To address this material weakness, the following actions are recommended: • Develop detailed procedures and timelines: Establish and enforce comprehensive procedures and timelines for the preparation and submission of the SEFA to ensure completeness and accuracy. • Enhance staffing and resources: Allocate adequate staffing and resources to the financial management department to support the accurate compilation and timely submission of the SEFA. • Provide comprehensive training: Offer training to financial management staff on the requirements and importance of the SEFA, including techniques for ensuring its accuracy and completeness.. • Regularly audit the SEFA preparation process: Conduct regular audits of the SEFA preparation process to ensure compliance with established policies and procedures and address any deficiencies promptly. This should be completed monthly and at a minimum quarterly. By implementing these recommendations, the City can strengthen its internal controls, improve the accuracy of its financial reporting, and ensure compliance with Government Auditing Standards and other regulatory requirements.
MATERIAL WEAKNESS; CRITERIA: Title 2 CFR §200.510(b) and the state single audit implementation act require auditees to prepare a Schedule of Expenditures of Federal and State Awards (SEFSA) for the period covered by the financial statements. 2 CFR §200.502(a) further emphasizes that the auditee is responsible for the accurate preparation and fair presentation of the SEFSA in accordance with federal requirements.; CONDITION: The Town of Spruce Pine did not prepare an accurate SEFSA for the fiscal year ended June 30, 2025. During the audit, we identified errors in reported federal expenditures, including the omission of federal program activity and incorrect amounts recorded as receivable under the federal program. As a result, material audit adjustments were required to properly state the SEFSA.; EFFECT: Because the SEFSA was not accurately prepared, there was an increased risk that federal expenditures were misstated and that federal programs subject to audit were not properly identified. This condition could result in noncompliance with federal reporting requirements and impair federal oversight. No questioned costs were identified as a result of this finding.; CAUSE: There were not adequate internal controls in place over the preparation and review of the SEFSA. Management did not maintain a complete and reconciled listing of federal awards expended during the fiscal year and did not perform a formal review of the SEFSA for completeness and accuracy prior to submission to the auditors. RECOMMENDATION: We recommend that the Town of Spruce Pine establish and document internal controls over the identification, tracking, and reporting of federal and state awards. This should include maintenance of a comprehensive schedule of known and potential awards throughout the fiscal year, reconciliation of grant expenditures to the general ledger, and performance of a supervisory review of the SEFSA prior to audit submission to ensure accuracy and completeness in accordance with federal and state requirements.; VIEWS OF RESPONSIBLE OFFICIALS AND CORRECTIVE ACTIONS: The Town of Spruce Pine agrees with this finding. Finance procedures will be updated to include a suspension and debarment requirements. Town staff will be trained on the updated policies and its implementation.
Schedule of Findings and Responses Financial Statements June 30, 2025 Comment #2025-001 CONTROLS OVER FINANCIAL STATEMENT PREPARATION SHOULD BE IMPROVED GENERAL Condition: As part of our auditing procedures, we assisted management in the preparation of the financial statements and related disclosures of the Organization in accordance with generally accepted accounting principles (GAAP) and related notes to the financial statements and the schedule of expenditures of federal awards and other financial assistance (SEFA). While we noted that management made significant efforts and improvement in its staffing, there was still a need for adjustments proposed by management during the audit process for the Organization to properly state various asset, liabilities, revenue and expense accounts. The current accounting information system, the design and programming to produce financial statements on an interim and annual basis are not adequate. The system appears to be designed to only account for grant and contract expenditures for the overall Organization and not for each type of funding and function of the Organization (i.e., federal, state, local, etc.). Currently, the Organization relies on an outside consultant to maintain and report to the board of directors the interim and annual financial statements. We further understand that the Organization has formalized an accounting policies and procedures manual; however, it does not adequately address certain key financial areas (i.e. inventory management and financial reporting, the allocation of expenses in an equitable manner to the various grants and contracts, study of bad debt for the medicaid program, reconciliation of purchased meals to those delivered during each month, formal approval of journal entries, etc.). Accurate and timely reporting of the financial information by sources are critical to the Organization. Backup procedures are performed by the third party with no backup maintained on site. Management should be thoroughly familiar with the accounting system and have controls in place to limit access to the system. Backup files should be verified and maintained by the CEO. Cyber attacks are on the rise for small entities. It is also essential for the Organization to properly track each federal, state and local program separately in the reporting system and ensure that the methodology used to allocate common direct and indirect cost is fair and equitable and follow generally accepted accounting principles and best practices. The required matching of federal funds should be adequately calculated, recorded and reporting in accordance with the applicable contractual agreement (s). Context: Review of the internal control structure of the Organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements which must include the total federal awards expended as determined in accordance with Section 200.502, basis for determining federal awards expended. [2 CFR §200.510(a) and (b)] Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes on a timely basis. Significant adjustments have to be made due to inaccurate programming and design. Whether the Organization is subject to a single audit pursuant to the Uniform Guidance is difficult to determine under the existing financial reporting model. (Continued) Cause: Significant turnover has been noted in key financial positions and a shortage of internal staff trained in accounting. An outside consultant with knowledge, skills, and experience in the preparation of financial statements was hired late into the fiscal year. The design of the accounting system (software utilized to process and maintain financial critical data in the general ledger and information system) is not adequate to report expenditures by source or funding type. Recommendation: The degree to which the auditors are assisting in preparation of the financial statements and related disclosures is a control deficiency and is determined by the knowledge and expertise of those in the Organization who are charged with the responsibility of its financial reporting. The accounting system should be designed to track and report revenue and expenditures by funding source and by type (federal, state, local, other, etc.). As a result, it is our recommendation that key personnel that have a role in assuring the accuracy of individual account balances obtain training to ensure that reporting, reconciliations (including cut-off procedures) and necessary supporting schedules are prepared accurately and in a timely manner. The general ledger should be maintained by departments (or by classes) to accurately report the revenue and expenditures in a manner consistent with that of the schedule of expenditures of federal awards (SEFA). The methodology used to allocated expenses should be studied to determine a more equitable means of allocating expenses (i.e. based on the number of units served for each program). Views of Responsible Officials and Planned Corrective Actions: We concur with this finding. The Organization has contracted with a seasoned outside accounting professional to assure that the financial system is designed to properly report financial activity by funding source and statements are completed and prepared timely. In addition, the Organization has committed to upgrading our accounting system software along with appropriate amendments to the formal accounting policy and procedures manual to cover the proper internal controls for accurately reporting financial activities for each grant and or contract. The Organization will maintain a backup copy of all financial data on-site. The software update process will be completed by June 30, 2026. The Organization is also engaged to have training on common software and cybersecurity awareness. Date to be implemented: On-going and completed by June 30, 2026. Persons responsible: CEO and financial consultant. Schedule of Findings and Responses Financial Statements June 30, 2025 Comment #2025-002 POLICIES AND PROCEDURES AND INTERNAL CONTROLS OVER DISBURSEMENTS AND PAYROLL PROCESSING SHOULD BE IMPROVED GENERAL Condition: We noted during our audit that the Organization’s purchasing policies and procedures and the internal controls over such procedures have not been updated to reflect the increase and diversity of funding and the compliance requirements that may affect the way the programs are carried out and accounted for. We also noted that the internal controls over the payroll processing should be improved. With the Organization receiving an increase in federal funding, management and the board of directors must be cognizant of the internal control requirements and the compliance requirement that are required when receiving such funds. The following are a summary of weaknesses and exceptions found during our audit procedures: 1. When meals are ordered for the various delivery sites, staff receives the meals each day with a corresponding ticket or voucher that identifies the type of meal and the quantities requested. The meals are purchased from one vendor. Each month, the vendor will submit an invoice for the meals delivered or sold to the Organization. We noted during our audit that there is no system in place to document the cumulative number of meals received each day and each month to authenticate the invoice (i.e., using Excel or some other accounting system). The risk exist that the number of meals invoiced may not agree with the number of meals received or delivered for the month and subsequently paid for. We also noted that there are no formal procedures in place to track and account for meals delivered by the various drivers and those not delivered (what happens to undelivered meals?). Consequently, the Organization is not able to adequately evaluate all accounts receivables by program and or properly record and value inventory at the end of each month (i.e. meals maintained in freezers). 2. The accounting for in-kind services and facilities are not properly evaluated and approved before entering into the general ledger as journal entries. Matching and in-kind are not reported by each grant as required by such grant agreements. 3. The payroll action forms are not always updated and used when there is a change in the pay rate (or salary amount) for employees. There were various reimbursements for miscellaneous expenses recorded in the payroll accounts ($10,722). Other payroll documents are either not in the file or not updated. The Organization’s has a 403 (b) Plan; however, it appears that this plan is not reviewed by the board of directors annually. Context: We reviewed and examined several transactions, based on our risk assessment and professional judgment, in each audit area for test of expenses to determine the Organization’s compliance with internal policies and procedures and other compliance requirements. Criteria: Generally accepted auditing standards and Governmental Auditing Standards. Internal controls should be designed to reduce the risk of transactions not being properly approved and executed in accordance with written policies and procedures that are approved by the board of directors. Such policies and procedures should be those determined to be best practices for not-for-profit organizations and are designed in a manner to meet the COSO framework. (Continued) Effect: Policies and procedures that are not properly designed and executed can result in the risk of assets not properly safe guarded and can lead to errors, misappropriation of assets and potentially abuse. Transactions not properly approved, could be an indirect violation of state and federal laws and other contractual requirements. Cause: Changes in senior management, the lost of staff due to the pandemic and lack of adequate monitoring activities. Also, the Organization has not established a committee or group of responsible individuals to oversee the polices and procedures and goals of the Organization. Recommendation: The Organization should immediately establish a committee of responsible individuals to author and oversee policies and procedures and internal controls over purchasing (procurement) and payroll processing procedures. Journal entries should be approved by a responsible person other than the person that initiated the journal entry. Supporting documentation should be attached to each journal entry that is not a recurring entry approved by the CEO. The 403 (b) Plan should be a regular agenda item for the board to discuss at least annually. Views of Responsible Officials and Planned Corrective Actions: We concur with this finding. The Organization will immediately assign a committee to take the lead in establishing policies and procedures and internal controls over the procurement process and the payroll procedures. The Organization has engaged a third party to help establish values of in-kind contributions. The board will discuss the 403 (b) Plan at least once annually reviewing the Plan document and the summary annual report. Date to be implemented: On-going and completed by June 30, 2026. Persons responsible: CEO and the board of directors with the outside consultant.
Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2024-007) Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Expenditures Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended June 30, 2025, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The Organization did not timely submit the audit reporting package and data collection form due to delays in completing the FY25 audit. The delayed completion of the FY24 audit caused a cascading impact on the timing of the FY25 audit. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: We recommend the Organization develop and monitor a formal audit timeline that accounts for the audit reporting package and data collection form submission deadlines to help ensure future filings are submitted in accordance with federal requirements. Questioned Costs: None Responsible Official's Response: CMJTS acknowledges the delay and has been making improvements to ensure that the Audit Reporting package and Data Collection Form are submitted timely and accurately. Accounting staff have been given additional training and internal procedures have been updated. Continued ongoing training and procedure updates will be done to ensure compliance.
2025-006 - Preparation of the Schedule of Expenditures of Federal Awards Finding Type: Material weakness in internal control over compliance. Criteria: The Uniform Guidance (2 CFR 200.302 and 2 CFR 200.510(b)) requires that non-Federal entities maintain records that adequately identify the source and application of Federal awards and prepare a Schedule of Expenditures of Federal Awards (SEFA) that is complete and accurate. Condition: The City did not prepare a Schedule of Expenditures of Federal Awards (SEFA) for the fiscal year ended June 30, 2025. A complete and accurate SEFA was prepared by the external auditor during the audit process. Cause: This condition is the result of the City’s lack of procedures and internal controls to identify, track, and report Federal award activity necessary to prepare the SEFA. Effect: As a result of this condition, the City did not maintain adequate internal control over compliance related to Federal reporting requirements and was not able to ensure that all Federal expenditures were identified and reported in accordance with Uniform Guidance. Recommendation: The City should implement procedures to identify and track Federal awards and expenditures and prepare a complete and accurate SEFA in accordance with Uniform Guidance requirements. Management Response: See Corrective Action Plan.
2025-001 16.575 Crime Victims Assistance Criteria: According to 2 CFR 200.510, the auditee is responsible for preparing a Schedule of Expenditures of Federal Awards (SEFA) that includes all federal awards received and expended, including the Assistance Listings Number (CFDA), grant numbers, and agency names. Condition: During the audit, management did not identify the total amount of federal funds received during the fiscal year. Context and Criteria: Entities that receive federal funds must have written policies, procedures, and standards of conduct (“policies”) as required by 2 CFR 200, Subparts D and E (2 CFR sections 200.300 and 200.400, respectively) for compliance with Uniform Guidance. Cause: Management did not include all grants with federal funding in their SEFA. Effect: The SEFA was inaccurate, leading to an incorrect determination that the Organization fell under the Single Audit requirement of $750,000. Recommendation: Management should review all grant agreements for Assistance Listing Numbers and pass-through identification information. Management should reconcile the SEFA to the general ledger periodically throughout the year. View of Responsible Officials and Planned Corrective Actions: Management will review the SEFA process and make changes as necessary.
Finding 2025-005 – Revenue Recognition Cutoff and Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat Finding – Prior Year 2024-002) Criteria or Specific Requirement: The Uniform Guidance, 2 CFR 200.510(b), requires the auditee to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the financial statements, which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.403 requires that costs charged to federal awards be allocable, allowable, and properly recorded in the period in which they are incurred. 27 Condition: During the audit of the fiscal year ended June 30, 2025, it was determined that revenue earned under the Indian Health Service Behavioral Health Programs grant (CFDA 93.654, Award No. BH22IHS0008) during the fiscal year ended June 30, 2024 was not recognized until the fiscal year ended June 30, 2025. The misapplication of the revenue recognition cutoff resulted in federal award revenue and expenditures being reported on the SEFA in the incorrect fiscal year, requiring a material post-close adjusting journal entry. This finding is a repeat of prior year Finding 2024-002. Cause and Effect: Controls over the period-end review of federal award revenue recognition and SEFA preparation were not operating effectively. The Organization did not perform a sufficient review of grant expenditure activity and award eligibility requirements relative to the June 30 fiscal year-end cutoff. The recurrence of this condition, despite being identified and reported in the prior year audit, indicates that corrective actions implemented were not sufficient to prevent the issue from recurring. Auditors' Recommendations: Management should implement a formal SEFA preparation and review process to ensure federal award expenditures are accurately reported for each fiscal year. A designated Finance staff member with sufficient knowledge of the Uniform Guidance requirements should be responsible for overseeing SEFA preparation for each fiscal year-end. A grant-by-grant SEFA reconciliation should be completed prior to year-end close. Management should engage its external accountants earlier in the year-end close process to allow sufficient time to identify and correct any SEFA discrepancies prior to fieldwork. Management's Response: Management has implemented a series of 3 checks and balance procedures for monthly review for SEFA procedures. A finance staff member with Uniform Guidance requirements will prepare the annual statement preparation at year end with review from Director of Finance and Board Treasurer before submission.
Finding 2025-007 – Failure to Provide Schedule of Expenditures of Federal and State Grant Awards (Material Weakness) Information on the Federal Program – HRSA Health Center Programs, FALN 93.224, June 30, 2025; U.S. Department of Labor Workforce Development Adult Program, FALN 17.258; Department of Labor Workforce Development Youth Program, FALN 17.259 Criteria – Uniform Guidance 2 CFR §200.302(b) requires financial management systems to provide accurate, current, and complete disclosure of financial results of each federally funded program. Additionally, 2 CFR §200.510(b) requires auditees to prepare a Schedule of Expenditures of Federal and State Grant Awards (SEFA) that properly presents federal expenditures by program and assistance listing, supported by the general ledger and accounting records. Condition – During our review of restricted funding programs, restricted program expenditures could not be readily identified in the general ledger. Additionally, OIC was unable to provide a Schedule of Expenditures of Federal and State Grant Awards (SEFA) for audit review. Cause – OIC has not established formal processes to track federal expenditures by program within the general ledger, nor procedures to compile and reconcile a SEFA annually. Management oversight controls related to federal reporting requirements were not adequately implemented. Effect – The absence of a SEFA and lack of identifiable federal expenditures impair OIC’s ability to demonstrate compliance with Single Audit requirements and federal grant terms. This condition increases the risk of inaccurate federal reporting, audit findings, and potential noncompliance with Uniform Guidance. Questioned Costs – $0 Perspective – Although no questioned costs were identified, the lack of a SEFA represents a fundamental compliance deficiency. The inability to readily identify federal expenditures increases audit risk and limits transparency over federal award activity. This finding affects compliance reporting rather than individual transactions. Recommendation – We recommend that the Board of Directors and Audit Committee require management to develop and execute a comprehensive, time-bound remediation plan to address this material weakness and restore effective internal control over revenue recognition and accounts receivable. The remediation plan should be formally reviewed and approved by the Audit Committee and include clearly defined milestones, responsible owners, and reporting protocols. Additionally, we recommend that the Audit Committee: • Maintain active oversight of remediation progress, including periodic updates from management on the design and implementation status of corrective actions. • Require validation that revised controls are not only designed appropriately but are operating effectively for a sustained period, supported by documentation and management certification. • Ensure adequate resourcing and system capability are in place—whether through process redesign, system integration, or external support—to achieve GAAP-compliant revenue recognition and reliable billing system reconciliations. • Evaluate ongoing compliance implications for federal programs, particularly HRSA Section 330, to confirm that corrective actions sufficiently address Uniform Guidance and Single Audit requirements. Timely and effective remediation of this material weakness is critical to restoring confidence in OIC’s financial reporting, strengthening stewardship of federal funds, and reducing the risk of continued adverse audit and compliance outcomes. View of Responsible Officials – Management concurs with the finding. OIC will formalize federal award tracking and SEFA preparation procedures to ensure federal expenditures are complete, accurate, and readily identifiable by program.
Assistance Listing Number, Federal Agency, and Program Name - 21.027 - U.S. Department of the Treasury - COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - N/A Pass through Entity - Cook County Health Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires the auditee to prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the financial statements that includes total federal awards expended. The SEFA must be complete and accurately reflect all federal expenditures. Condition - The Organization’s SEFA for the year ended June 30, 2024 was not complete. Specifically, certain federal expenditures were omitted from the SEFA. Questioned Costs - None If Questioned Costs are Not Determinable, Description of Why Known Questioned Costs Were Undetermined or Otherwise Could Not be Reported - No questioned costs were identified, as the issue relates to the completeness of SEFA reporting rather than the allowability, allocability, or reasonableness of the underlying expenditures. Identification of How Questioned Costs Were Computed - N/A Context - During our procedures, we noted that $668,038 of expenditures related to the Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) program was not included on the fiscal year 2024 SEFA, even though these expenditures were incurred in fiscal year 2024 and should have been reported. Management identified this omission during the preparation of the fiscal year 2025 SEFA. While additional procedures were performed to assess completeness, no other omitted federal expenditures were identified. Cause and Effect - Although the Organization has a formal SEFA preparation and review process, the control did not operate effectively to identify all sources of federal funding. Specifically, CSLFRF funding was not identified by management as federal assistance and, therefore, was not included in the population subject to SEFA reporting and review in fiscal year 2024. The fiscal year 2024 SEFA was understated by $668,038. Although the omission did not impact the determination of major programs for fiscal year 2024, an incomplete SEFA increases the risk that federal expenditures are not fully identified and could result in inaccurate reporting and potential noncompliance with the Uniform Guidance requirements. The fiscal year 2025 SEFA properly excludes these expenditures. Recommendation - We recommend that management strengthen procedures over SEFA completeness by enhancing the process used to identify federal funding sources. This may include: • Implementing a centralized and regularly updated listing of all funding sources that clearly identifies federal awards, including pass through funding • Establishing procedures to evaluate new or amended agreements for federal characteristics at the time of award • Enhancing the SEFA review process (e.g., CFO review) to include a formal reconciliation of federal expenditures to the general ledger and grant listings, with specific consideration of funding sources that may not be clearly labeled as federal These enhancements will help ensure all federal expenditures are identified and accurately reflected in the SEFA. Views of Responsible Officials and Corrective Action Plan - Management agrees it is important to have a SEFA preparation process that allows the identification of all sources of federal funding. In addition to current procedures, management will confirm with grantors directly when grant award agreements are silent on whether awards are sourced from federal funding and document the confirmations from grantors.
Finding 2025-003 Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Man-agement (Material Weakness) Assistance Listing Number and Title: 84.184H Title IV ESEA, School Based Mental Health Name of Federal Agency: U.S. Department of Education Criteria: Per 2 CFR §200.510(b), the auditee must prepare a complete and accurate Schedule of Federal Expenditures (SEFA) for the period covered by the auditee’s financial statements and submit it with the reporting package by the date required by auditors. The SEFA must include total federal awards expended by Assistance Listing (ALN, formerly CFDA), pass-through entity identifying numbers as applicable, the amount provided to subrecipients (if any), and other required disclosures. The SEFA must include all federal expenditures and awards for the year reported and be reconciled to the General Ledger. Condition: The District did not timely prepare an accurate Schedule of Expenditures of Federal Awards (SEFA). The SEFA provided for audit did not reconcile to the District’s general ledger and contained multiple inaccuracies, including reporting federal expenditures in excess of current-year general ledger activity and misclassification of awards, with certain state programs incorrectly reported as federal programs. Cause: The District lacked effective internal controls over the preparation and review of the Schedule of Expenditures of Federal Awards. Specifically, expenditures reported on the SEFA were not reconciled to the District’s general ledger, and there was no documented review process to verify program classification or reported amounts. Changes in finance staff and the incomplete status of the District’s general ledger at year-end further contributed to the errors and untimely completion of the SEFA. Effect or Potential Effect: Expenditures of federal awards may be reported incorrectly and not be detected and corrected. Because the Auditee’s SEFA was completed incorrectly and not reconciled to the general ledger the SEFA was materially misstated, prior to auditors’ correction recommendations. Questioned Cost: None noted Context: The Schedule of Expenditures of Federal Awards (SEFA) is a required supplementary schedule for Single Audit reporting and is intended to accurately reflect federal award activity in accordance with Uniform Guidance requirements. During the audit, the District provided an initial SEFA that was not timely and contained material inaccuracies. The re-ported expenditures did not reconcile to the District’s general ledger. Certain programs were incorrectly identified as feder-al rather than state awards, and some federal expenditures exceeded amounts recorded in the accounting records. Because the SEFA was neither complete nor accurate at the time of submission, auditors were required to perform addi-tional procedures to identify errors, investigate discrepancies, and propose audit adjustments. Thei extended the audit timeline and increased the risk of noncompliance with federal reporting requirements. Repeat of a Prior-Year Finding: No Recommendation: The District should strengthen internal controls over SEFA preparation by ensuring the general ledger is finalized prior to preparation, reconciling all reported expenditures to accounting records, and implementing a docu-mented review and approval process to verify accuracy and proper program classification. Strengthening procedures, cross training staff, and implementing supervisory review and approval process to verify accuracy, completeness and proper classification of federal versus state awards will enhance compliance with Uniform Guidance, and reduce the risk of future audit findings, and support a more efficient and timely audit process. District’s Response: The District agrees with the finding and recognizes that staffing changes and an incomplete year-end close contributed to the SEFA issues. The District is strengthening reconciliation, review, and oversight procedures to en-sure timely and accurate SEFA reporting in future years. Corrective Action Plan: The District transitioned to a new accounting software for the year ended June 30, 2026. The new system will allow for more clear tracking of individual federal awardS. that are required to be reported on the Schedule of Expenditures of Federal Awards. Additionally, the new business manager for the 2026-2027 fiscal year has multiple years' experience in preparing Schedules of Expenditures of Federal Awards. Planned Implementation Date: August 1, 2026 Responsible Person: District Finance Director
Finding Reference: 2025-004 (cross-referenced as 2025-001) Type of Finding: Material Weakness in Internal Control Over Compliance and Material Noncompliance • Federal Agency: U.S. Department of Housing and Urban Development / Department of Health and Human Services / Department of Treasury / Department of Homeland Security / Department of Agriculture / U.S. Federal Transportation Administration and U.S. Environmental Protection Agency • Federal Program Name: Housing Choice Voucher / Community Service Block Grant Program Recovery Grant / Housing Opportunities for People with Aids / State Block Grant Program / Community Service Block Grant Program / Title III, Part C, Nutrition Services / Coronavirus State and Local Recovery Funds / Coronavirus Relief Funds / Community Disaster Loan / Public Assistance Grant / Rural Housing Preservation Grant / Formula Grants for Rural Areas and Cleanup Cooperative Agreements. • Assistance Listing Number (ALN): 93.569 / 93.045 / 21.027 / 21.019 / 97.030 / 97.036 / 10.433 / 20.509 and 66.818 • Federal Award Number and Year: 21.019 – CRF-AFFAF Pass-Through Entity: 93.569 – Families and Children Administration and 20.509 – Department of Transportation and Public Works Criteria or Specific Requirement: Pursuant to Uniform Guidance (2 CFR 200.510(b)), the auditee must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements which must be accurate and reconciled. Furthermore, 2 CFR 200.302 requires non-federal entities to establish financial management systems that provide accurate, current, and complete disclosure of the financial results of each federally- sponsored project or program, and to maintain effective control over and accountability for all funds, property, and other assets. Condition (Cross-Reference): The Municipality’s core accounting system lacked the technical and functional capacity to accurately aggregate transactions and produce reliable financial records or balanced reports due to an un-reconciled migration of historical opening balances. (Cross-Reference): The complete details regarding the operational failure of the financial software system, the database corruption, and the timeline are fully described in Finding 2025-001 under Section II – Financial Statement Findings of this schedule. Effect or Potential Effect: Because the core accounting database cannot output accurate balances, the Municipality is unable to verify the completeness or accuracy of its Trial Balances by Funds or Accounts. Questioned Costs: $0.00 (None). Although the accounting system failed to produce reports, no specific unallowable transactions or questioned costs were identified during our compliance testing. Cause: See Finding 2025-001 for the root cause regarding inadequate data-validation protocols and poor system-migration oversight by management. Recommendation: We recommend that management implement the exact corrective action plan detailed in Finding 2025- 001. In addition, management must establish an interim manual ledger or spreadsheet tracking matrix to ensure that all federal expenditures for this major program are manually reconciled with federal drawdowns and physical invoices until the core accounting system
Material Weakness – Finding 2025-002: Schedule of Expenditures of Federal Awards Completeness Statement of Condition In connection with our audit, management initially represented that the schedule of expenditures of federal awards was complete and accurate. During the course of the audit, in response to auditor inquiry regarding another grant held by the Organization, management determined that the grant represented federal funds passed through the Housing Authority of Cook County, Illinois under State and Local Fiscal Recovery Funds, ALN 21.027, and that the related expenditures of $709,506 had not been included in the schedule of expenditures of federal awards as initially prepared. This indicates that the Organization's controls did not identify and accumulate all federal awards expended during the year, specifically federal awards received as pass-through funding from a local government unit. Criteria Title 2 U.S. Code of Federal Regulations Part 200 (Uniform Guidance) requires the auditee to prepare a schedule of expenditures of federal awards that includes the total federal awards expended for the period (2 CFR 200.508 and 200.510(b)). Federal awards expended include awards received indirectly from pass-through entities, including state and local governments such as counties. The non-Federal entity is also required to establish and maintain effective internal control over the federal award that provides reasonable assurance the entity is managing the award in compliance with federal statutes, regulations, and the terms and conditions of the award (2 CFR 200.303). A complete and accurate schedule of expenditures of federal awards is necessary for the proper determination of major programs and the scope of the single audit. Cause The Organization's process for identifying federal awards did not include adequate procedures to detect federal funds passed through local government entities. The grant was initially treated as a non-federal award because its federal source was not apparent on its face, and the grant agreement and related funder documentation were not evaluated for indicators of federal funding (such as an Assistance Listing Number, a federal award identification number, the identity of the originating federal agency, or references to the Uniform Guidance). Effect A federal award was omitted from the schedule of expenditures of federal awards as initially prepared, resulting in an understatement of reported federal expenditures of $709,506. An incomplete schedule could result in incorrect determination of major programs and audit scope and in noncompliance with the reporting requirements of the Uniform Guidance. The schedule was subsequently revised to include the program. Questioned Costs None noted. Perspective The finding relates to the identification of a single federal pass-through award received from a local government unit. While isolated to that award, it reflects a deficiency in the design of the Organization's controls over the identification of federal awards. Statistical Sample A statistical sample is not applicable to this finding. Repeat Finding This audit finding is not a repeat finding. Recommendation We recommend that the Organization implement procedures to identify all federal awards expended, including funds passed through state and local governments. For each grant and contract, management should review the executed agreement and related funder documentation for indicators of federal funding, including an Assistance Listing Number, a federal award identification number, the originating federal agency, the pass-through entity identifying number, and references to the Uniform Guidance, and should confirm the federal funding status with the pass-through entity when it is not clear. The Organization should maintain a centralized listing of awards that is reconciled to the general ledger and reviewed for completeness in preparing the schedule of expenditures of federal awards. View of Responsible Officials Management agrees with the finding. Management will implement procedures to identify all federal awards expended, including pass-through awards received from state and local government units, and to evaluate grant agreements and funder documentation for indicators of federal funding, so that the schedule of expenditures of federal awards is complete and accurate.
Finding 2025-005 – Revenue Recognition Cutoff and Schedule of Expenditures of Federal Awards – Material Weakness in Internal Control Over Compliance and Noncompliance (Repeat Finding – Prior Year 2024-002) Criteria or Specific Requirement: The Uniform Guidance, 2 CFR 200.510(b), requires the auditee to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the financial statements, which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.403 requires that costs charged to federal awards be allocable, allowable, and properly recorded in the period in which they are incurred. 27 Condition: During the audit of the fiscal year ended June 30, 2025, it was determined that revenue earned under the Indian Health Service Behavioral Health Programs grant (CFDA 93.654, Award No. BH22IHS0008) during the fiscal year ended June 30, 2024 was not recognized until the fiscal year ended June 30, 2025. The misapplication of the revenue recognition cutoff resulted in federal award revenue and expenditures being reported on the SEFA in the incorrect fiscal year, requiring a material post-close adjusting journal entry. This finding is a repeat of prior year Finding 2024-002. Cause and Effect: Controls over the period-end review of federal award revenue recognition and SEFA preparation were not operating effectively. The Organization did not perform a sufficient review of grant expenditure activity and award eligibility requirements relative to the June 30 fiscal year-end cutoff. The recurrence of this condition, despite being identified and reported in the prior year audit, indicates that corrective actions implemented were not sufficient to prevent the issue from recurring. Auditors' Recommendations: Management should implement a formal SEFA preparation and review process to ensure federal award expenditures are accurately reported for each fiscal year. A designated Finance staff member with sufficient knowledge of the Uniform Guidance requirements should be responsible for overseeing SEFA preparation for each fiscal year-end. A grant-by-grant SEFA reconciliation should be completed prior to year-end close. Management should engage its external accountants earlier in the year-end close process to allow sufficient time to identify and correct any SEFA discrepancies prior to fieldwork. Management's Response: Management has implemented a series of 3 checks and balance procedures for monthly review for SEFA procedures. A finance staff member with Uniform Guidance requirements will prepare the annual statement preparation at year end with review from Director of Finance and Board Treasurer before submission.
Finding 2025-002 – Material Weakness – Schedule of Expenditures of Federal Awards (SEFA) Federal Grantor: Corporation for National and Community Service Passed-through: Office of Planning Research California Volunteers Pass-through Grantor’s No.: 24ACIY31-C190 / 20AFHMN0010013-23 / 23AFEMN0010003-24 /22AFBMD0020011 / 22AFBMD0020018 / 22AFGMS001 / 22AFINV0010014 / 21AFEWI0010022 Compliance Requirement: Reporting Condition: During the course of the single audit, IYT provided three successive versions of the Schedule of Expenditures of Federal Awards (SEFA). The initial version included only the expenditures of grant funds received through California Volunteers and reflected an incorrect amount. The second version corrected the California Volunteers amount but omitted the other pass-through entities. The final version included expenditures from all passthrough entities. Earlier versions did not fully reconcile to the accounting system. Criteria: 2 CFR 200.508(b) and 2 CFR 200.510 require the auditee to prepare a complete and accurate SEFA that includes all federal awards received and expended, including correct pass-through entity information and expenditures. Effective internal controls must ensure the SEFA is accurate, supported by records, and prepared timely (OMB Compliance Supplement, Part 6). Effect: The submission of multiple inaccurate and incomplete versions of the SEFA during the audit delayed the engagement, increased the risk of misstatement, and could have affected major program determination and federal reporting. This constitutes a material weakness in internal control over compliance due to the significance of AmeriCorps funding. This finding relates to entity-wide reporting controls and did not have a direct and material effect on compliance with the requirements applicable to any individual major federal program. Cause: Inadequate processes existed for identifying, tracking, and reconciling federal award data from multiple passthrough entities, combined with insufficient management review and oversight. Recommendation: IYT needs to develop and implement a formal process for preparing the SEFA that includes identifying and tracking all federal awards, performing timely reconciliations to the accounting system and passthrough entity reports, conducting reviews and approvals, and providing training to staff on Uniform Guidance requirements. Views of Responsible Officials and Planned Corrective Actions: Management concurs with the finding. IYT implemented a formal, documented process for preparing the Schedule of Expenditures of Federal Awards (SEFA) that addresses completeness, accuracy, and reporting of pass-through information. IYT maintains a document that identifies all federal awards received and expended, including each pass-through entity, pass-through identifying number, and award period, so that every funding source is captured. Federal expenditures are reconciled to the general ledger and to each pass-through entity's reports on a scheduled basis throughout the year, and total SEFA expenditures are compared to federal revenue recognized in the financial statements. The SEFA is subject to a documented preparer-and-reviewer control, and IYT will not designate the SEFA as final until it is complete, fully reconciled to the accounting system and supporting records, and reviewed and approved by management. Finance staff received training on the SEFA preparation and reporting requirements of 2 CFR 200.508(b) and 200.510, including the identification and reporting of pass-through awards. A complete, fully reconciled, and reviewed SEFA is prepared prior to the start of the FY 2026 audit.
Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds / HOME Investment Partnership Program Federal Financial Assistance Listing Number.: 21.027 / 14.239 Federal Grantor: U.S. Department of the Treasury / U.S. Department of Housing and Urban Development Award Number and Year: Affects all grant awards included under assistance listing 14.239 and 21.027 on the Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of Expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total federal awards expended as determined in accordance with §200.502. §200.331 of the Uniform Guidance states the City is responsible for making case-by-case determinations to determine whether the entity receiving the Federal funds is a subrecipient. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA we noted the following: • The City did not properly identify the amount expended for the COVID-19 Coronavirus State and Local Fiscal Recovery Funds, AL No. 21.027. The expenditures reported by the City were understated by $176,324. • The City did not properly identify the amount of Federal funding passed through to subrecipients for the COVID-19 Coronavirus State and Local Fiscal Recovery Funds, AL No. 21.027. The amount passed through to subrecipients reported by the City was understated by $418,183. • The City did not properly identify the amount of Federal funding passed through to subrecipients for the Home Investment Partnerships Program, AL No. 14.239. The amount passed through to subrecipients reported by the City was overstated by $2,591,181. Cause: As a result, the City lacked adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of Federal awards are not designed so that expenditures are identified when incurred. In addition, the City’s processes for identifying and reporting subrecipients are not designed to ensure appropriate reporting on the SEFA. Effect: Adjustments to the SEFA were required. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures and amounts passed through to subrecipients were reconciled to the supporting records. Repeat Finding from Prior Year: No. Recommendation: The City, including all its reporting departments, should follow existing policies, procedures and internal controls to ensure all expenditures and amounts passed through to subrecipients are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. Views of Responsible Officials and Planned Corrective Action: See separate corrective action plan.
2025-001 — Failure to Identify All Federal Awards and Prepare a Complete Schedule of Expenditures of Federal Awards Type of Finding: Material weakness in internal control over compliance related to the identification and reporting of federal awards and preparation of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program and Specific Federal Award Information This finding relates to the Organization’s process for identifying and reporting federal awards received and expended during the year ended June 30, 2025. Criteria Under 2 CFR 200.302(b)(1), a nonfederal entity is required to identify in its accounts all federal awards received and expended, as well as the federal programs under which the awards were received. Federal award identification must include, as applicable, the Assistance Listing title and number, federal award identification number, year the federal award was issued, and the name of the federal agency or pass-through entity. Under 2 CFR 200.510, the auditee is required to prepare a SEFA for the period covered by the auditee’s financial statements. The SEFA must include total federal awards expended for each individual federal program, and federal programs must be listed by federal agency. For awards received as a subrecipient, the SEFA must include the name of the pass-through entity and the identifying number assigned by the pass-through entity. The SEFA must also include applicable Assistance Listing numbers or other identifying numbers, cluster totals, loan or loan guarantee amounts when applicable, and amounts provided to subrecipients when applicable. Condition During the audit of the Organization for the fiscal year ended June 30, 2025, the Organization did not identify all federal awards received and expended and did not prepare a complete Schedule of Expenditures of Federal Awards prior to the start of the audit. Additional federal awards and/or federal expenditures were identified through procedures performed during the audit. The Organization subsequently prepared or revised the SEFA with audit assistance and/or based on information identified during the audit. The awards or expenditures not initially identified are included in the table shown on the previous page and total $1,018,672. Total federal expenditures for the fiscal year ended June 30, 2025 were ultimately determined to be $1,716,735. The audit engagement was revised as a result of the Organization meeting the threshold for a Single Audit. Cause The Organization did not have adequate internal controls, policies, and procedures in place to ensure that all federal awards were identified, tracked, and reported in accordance with Uniform Guidance requirements. Specifically: • The Organization did not maintain a centralized grant listing or grant award register identifying all federal awards, including awards received directly from federal agencies and awards received as a subrecipient from pass-through entities. • Personnel in the finance department are relatively new to the Organization and federal award identification related to funds passed through by non-federal entities was not an area for which new personnel have received training. • Similarly, personnel have not received training in the preparation of the SEFA. Effect Because the Organization did not identify all federal awards and did not prepare a complete SEFA prior to the audit, there was a reasonable possibility that material misstatements of the SEFA and related disclosures would not be prevented, or detected and corrected, on a timely basis. The SEFA is the primary basis for determining whether a Single Audit is required and for identifying major programs subject to audit; therefore, incomplete identification of federal awards could result in an incorrect major program determination, incomplete audit coverage, untimely or inaccurate federal reporting. Questioned Costs The amount of questioned costs, if any, could not be determined because the finding relates to the Organization’s internal control process for identifying and reporting federal awards and preparing the SEFA, rather than to specific costs tested for allowability. No specific questioned costs were identified as a result of this finding. Recommendation We recommend that the Organization strengthen internal controls over the identification, accounting, and reporting of federal awards and the preparation of the SEFA. At a minimum, management should: 1) Capture required federal award information for each award, including Assistance Listing title and number, federal award identification number, award year, federal agency, pass-through entity, pass-through identifying number, award period, award amount, and applicable compliance requirements. 2) Configure the accounting system or supporting schedules to separately identify federal revenues and expenditures by program, award, funding source, and award year. 3) Develop written SEFA preparation procedures that identify responsible personnel, timing, required data sources, reconciliation steps, and review and approval requirements. 4) Provide training to accounting, finance, and program personnel responsible for grant management and federal award reporting. 5) Consult with federal awarding agencies or pass-through entities when award information is incomplete or unclear, including Assistance Listing numbers or pass-through identifying numbers. Views of Responsible Officials / Management Response Management agrees with the finding. The Organization acknowledges that it did not have adequate procedures in place during the fiscal year ended June 30, 2025 to identify all federal awards and prepare a complete SEFA prior to the audit. Management will implement corrective actions to strengthen controls over federal award identification, accounting, reconciliation, and SEFA preparation. (See separately issued corrective action plan.)
Internal Control over Preparation of the Schedule of Expenditures of Federal, State, and City Awards (SEFA), Assistance Listing Numbers (ALNs) - All Condition: Management’s SEFA did not include the ALNs for all of its federal awards with expenditures during the fiscal year. Criteria: “A non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single or program-specific audit conducted for that year in accordance with the provisions of the Uniform Guidance Part 2 CFR section 200.50 (a). In order to accomplish this, “The auditee must also prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502” per Part 2 CFR section 200.510 (b) of the Uniform Guidance. This guidance includes the requirement that the SEFA include the ALN for each grant award included in the schedule. Cause: When awards are received during the year, management does not confirm the source of funding or the ALN with the awarding agency. Effect: The SEFA provided by management in advance of the audit was misstated because two (2) federal awards with expenditures totaling $1,695,881 were excluded. This had a direct and material effect on the audit of the major programs. Context: The Chief Financial Officer (CFO) relies on pass-through agencies to provide the funding sources, including the related ALN. Two of the award agreements did not include this information, and it was only identified that the programs were federally funded upon receipt of the audit confirmation responses. As a result, the SEFA initially provided by the CFO did not include these two programs. Recommendation: We recommend management implement policies and procedures in which the funding source of all awards (including ALN) be obtained from funders at the time that all awards are granted. View of responsible officials and Planned Corrective Actions: ECA agrees with this finding and has created a policy for identification and verification of funding sources for all contracts. This will ensure that all contracts are screened for federal funding regardless of what is listed in the contract/award/agreement. ECA will review its existing contracts to confirm all funding sources.
Finding 2025-002: Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Statement of Condition The Organization. did not provide a properly completed Schedule of Expenditures of Federal Awards (SEFA). Certain programs administered by the Organization were funded through a combination of federal and non-federal sources. The Organization had not identified the portion of expenditures attributable to federal awards prior to the commencement of audit fieldwork. As a result, the identification of federal expenditures and the amounts to be included in the SEFA occurred during the audit process rather than prior to the start of the audit. This resulted in delays in determining the complete population of federal expenditures and the programs subject to audit under the Uniform Guidance. Criteria Under 2 CFR §200.510(b) of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), auditees are responsible for preparing a Schedule of Expenditures of Federal Awards for the period covered by the financial statements. The SEFA must accurately present total federal expenditures for each federal program, including the Assistance Listing number and pass-through identifying information, where applicable. Cause The Organization does not have a formalized process to identify and track the federal portion of expenditures for programs funded through multiple sources during the fiscal year. As a result, management had not compiled or finalized the SEFA prior to the start of the audit. Effect The absence of a completed SEFA at the commencement of the audit delayed the auditor’s ability to determine the population of federal expenditures and identify major programs for testing under the Uniform Guidance. This resulted in additional time required during fieldwork to determine the appropriate amounts to include in the SEFA. Recommendation We recommend that management implement procedures to identify and track federal expenditures by Assistance Listing number throughout the year, particularly for programs with mixed funding sources. Management should prepare and review a complete and accurate SEFA prior to the start of the audit, including identification of federal funding components within blended funding streams. Establishing formal procedures for the preparation and review of the SEFA will help ensure compliance with 2 CFR §200.510(b) and support timely completion of the annual Single Audit. Views of Responsible Officials and Planned Corrective Actions Management agrees with the finding and recognizes the importance of preparing a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) prior to the commencement of the annual audit in accordance with the requirements of 2 CFR §200.510(b). The finding resulted from the absence of a formalized process to consistently identify and document federal funding components within contracts funded through multiple revenue sources, including changes reflected in new and renewed County contracts. As a result, certain federal funding components were not identified during the initial preparation of the SEFA, requiring revisions during the audit. In response, management has implemented and will continue to enhance procedures to strengthen the preparation and review of the SEFA throughout the fiscal year. These corrective actions include: • Establishing forma procedures requiring the identification and documentation of Assistance Listing Numbers (ALNs) for all new contracts and contract renewals. • Tracking applicable federal funding and corresponding ALNs within the accounting system to support the accurate preparation and review of the SEFA. • Requiring the Controller to review all new and renewed contracts monthly to identify changes affecting federal funding and ensure the SEFA is updated accordingly. • Obtaining and maintaining timely ALN confirmations and supporting documentation for all applicable federal awards. • Preparing and reconciling the completed SEFA to supporting accounting records, funding documentation, and applicable federal and pass-through contracts prior to submission to the independent auditors. Management believes these corrective actions will strengthen internal controls over federal award reporting, improve the accuracy and completeness of the SEFA, and ensure future compliance with the requirements of 2 CFR §200.510(b).
Reference Number: 2025-002 (Material Weakness - Internal Control over Financial Reporting and Noncompliance – Preparation of the Schedule of Expenditure of Federal Awards) Background: The Organization is required to prepare a Schedule of Expenditures of Federal Awards (SEFA) in accordance with 2 CFR 200.510(b), which serves as the basis for determining major programs and calculating the percentage of coverage under 2 CFR 200.518. During our audit, we identified omitted federal expenditures totaling $157,189 that primarily related to ALN 93.566. Criteria: • 2 CFR 200.510(b): The auditee must prepare a SEFA that includes total federal awards expended for each federal program. • 2 CFR 200.518(f): The auditor must obtain sufficient coverage of total federal awards expended (generally at least 40% for low-risk auditees and 20% for high-risk auditees). • 2 CFR 200.303(a): The auditee must establish and maintain effective internal control over federal awards to provide reasonable assurance of compliance, including accurate financial reporting. Condition: The Organization’s SEFA did not include $157,189 of federal expenditures. As a result, total federal expenditures were understated, and the auditor’s initial major program determination and testing did not achieve the required percentage of coverage under Uniform Guidance. Cause: Management’s controls over SEFA preparation and review were not adequately designed or implemented to ensure completeness of federal award identification and reporting. Specifically: • There was no formal reconciliation of federal expenditures to the general ledger and grant activity. • The review control did not include procedures to validate completeness of all ALNs, particularly for pass-through or less prominent programs. Effect: • The SEFA was materially misstated due to federal expenditures that were not included. • The initial major program determination resulted in insufficient audit coverage relative to total federal expenditures. • Additional audit procedures were required to achieve compliance with 2 CFR 200.518. • There is an increased risk that other federal programs or compliance requirements could be improperly reported or tested. Questioned Costs: None. Recommendation: We recommend that management strengthen internal controls over SEFA preparation and review by: • Implementing a formal SEFA preparation checklist that includes reconciliation of total federal expenditures to the general ledger and grant records. • Establishing a control to identify all federal awards by ALN, including pass-through funding, prior to SEFA finalization. • Enhancing management review procedures to include verification of completeness and accuracy, with documented evidence of review. • Coordinating with program personnel to ensure all sources of federal funding are captured. Views of Responsible Officials: Management acknowledges the omission of federal expenditures from the SEFA and agrees with the finding. Corrective actions will include implementing enhanced reconciliation and review controls to ensure completeness of the SEFA in future reporting periods.