FAC Explorer

Audit 391077

FY End
2024-12-31
Total Expended
$1.10M
Findings
1
Programs
2
Organization: City of Vermilion (OH)
Year: 2024 Accepted: 2026-03-10
Auditor: CHARLES E HARRIS & ASSOCIATES INC

Organization Exclusion Status:

Findings

ID Ref Severity Repeat Requirement
1177654 2024-001 Material Weakness Yes L

Programs

ALN Program Spent Major Findings
20.205 HIGHWAY PLANNING AND CONSTRUCTION $381,346 Yes 1
21.019 CORONAVIRUS RELIEF FUND $66,294 Yes 0

Contacts

Name Title Type
HHQCX8NPHTV1 Amy Hendricks Auditee
4402042425 John Phillips Auditor
No contacts on file

Notes to SEFA

The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of the City of Vermilion, Erie County, (the City’s) under programs of the federal government for the year ended December 31, 2024. The information on this Schedule is prepared in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City.
Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement.
The City has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance.
Certain Federal programs require the City to contribute non-Federal funds (matching funds) to support the Federally-funded programs. The City has met its matching requirements. The Schedule does not include the expenditure of non-Federal matching funds.

Finding Details

Finding 2024-001
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the City’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL number information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The City’s internal control procedures identified and properly recorded $141,051 of Coronavirus relief funds and $577,081 of Highway Planning and Construction pass-through expenses for PID #113961 for recording in their Schedule of Federal Awards Expenditures (Schedule). The City did not identify $381,346 of pass-through expenses for PID #115721 in the Schedule related to the Highway Planning and Construction Funds. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.