2 CFR 200 § 200.502

Findings Citing § 200.502

Basis for determining Federal awards expended.

Total Findings
5,799
Across all audits in database
Showing Page
1 of 116
50 findings per page
About this section
Section 200.502 outlines how to determine when Federal awards are considered expended, focusing on activities that require compliance with Federal rules, such as grant transactions, fund disbursements, and loan usage. It affects non-Federal entities, including institutions of higher education, by specifying how to calculate the value of Federal awards, particularly in relation to loans and their compliance requirements.
View full section details →
FY End: 2025-08-30
Clarendon College
Compliance Requirement: P
Criteria: In accordance with 2 CFR section 200.510(b) (Uniform Guidance), “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.” Condition: The College did not have controls in place to ensure the Schedule of Expenditures of Federal Awards (SEFA) was accurately reconciled with the general ledger. As a result, t...

Criteria: In accordance with 2 CFR section 200.510(b) (Uniform Guidance), “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.” Condition: The College did not have controls in place to ensure the Schedule of Expenditures of Federal Awards (SEFA) was accurately reconciled with the general ledger. As a result, there were discrepancies between the amounts reported on the SEFA and the actual expenditures in the College’s accounting records. Cause: The College does not have a process in place to reconcile the SEFA to the general ledger to ensure accurate records. Expense entries (expenditures) are posted by several people across the campus when funds are spent. Revenue entries (drawdowns) are posted by the business office, however there is no process to ensure these drawdowns are the same as the amounts expended. Revenue is also not deferred to the appropriate period when necessary as part of a SEFA reconciliation process. Effect: Without proper reconciliation procedures, there is an increased risk that the SEFA may be materially misstated. The current year SEFA contained net adjustments of $209,443 made by the auditors to reconcile to the general ledger and award letters. Repeat Finding from Prior Year: Yes Recommendation: We recommend management establish an informal procedure to reconcile grant funds received with funds expended on a regular basis. We also recommend management implement a formal procedure to reconcile the SEFA with the general ledger at year end. Views of Responsible Officials: The Comptroller will reconcile this report on a monthly basis making sure that all grants and other Federal / State expenditures are on the SEFA and that the two numbers reconcile with the general ledger. This will be kept in a notebook and the calendar kept in the Comptroller’s desk. The Comptroller will also create a folder in the business office folder on the server and input the current SEFA in this folder and show any discrepancies on a monthly basis and every time this report is run for drawdowns. This process will start immediately. The Comptroller will also make sure at year end that all items are on this report and they have been reconciled with the general ledger. This process will also be in the notebook and calendar within the desk of the Comptroller

FY End: 2025-06-30
Unified School District No. 397
Compliance Requirement: L
Federal Agency: U.S. Department of Homeland Security Pass Through Entity: Kansas Division of Emergency Management Program Name: Building Resilient Infrastructure and Communities Assistance Listing Number: 97.047 Award Period: June 30, 2025 Criteria: According to 2 CFR 200, Subpart F, the District is required to prepare a schedule of federal expenditures, which must include the total federal awards expended as determined in accordance with §200.502. An effective internal control system exists if ...

Federal Agency: U.S. Department of Homeland Security Pass Through Entity: Kansas Division of Emergency Management Program Name: Building Resilient Infrastructure and Communities Assistance Listing Number: 97.047 Award Period: June 30, 2025 Criteria: According to 2 CFR 200, Subpart F, the District is required to prepare a schedule of federal expenditures, which must include the total federal awards expended as determined in accordance with §200.502. An effective internal control system exists if controls are effective in preventing or detecting material misstatements in the preparation of the schedule of federal expenditures of federal awards (the schedule). It provides reasonable assurance for the reliability of financial information and compliance with laws and regulations. Condition: We have determined that there was an inadequate design of internal control over the preparation of the schedule during the fiscal year ended June 30, 2025. The current financial reporting process does not ensure accuracy and completeness in the preparation of the schedule by the District, as required by Uniform Guidance. Cause: The District’s staff lacked the knowledge to ensure the schedule is complete and accurate. Effect: The District did not prepare the schedule in conformity with Uniform Guidance. This increases the likelihood of a material misstatement and noncompliance with laws and regulations. Context: The District was unable to provide a schedule of Expenditures of Federal Awards that was materially correct. The District is not typically subject to a Single Audit. Recommendation: We recommend the Board of Education and management review the financial reporting process. Once this review is complete, the District should then perform a risk assessment to determine the best way to implement appropriate internal controls over financial reporting to ensure that the District prepares the schedule conformity with Uniform Guidance. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and plans to develop proper written policies and procedures for the internal control over compliance to ensure accuracy and completeness in the District’s preparation of the schedule as required by Uniform Guidance.

FY End: 2025-06-30
Lakefront Management Authority
Compliance Requirement: P
Criteria: According to 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. Generally, the activity related to the federal award pertains to events that require the nonfederal entity to comply with federal statutes, regulations, and the terms and conditions of Federal awards, such as expenditure/expense transactions associated with grants. For FEMA grants, non-federal entities must record expenditures on the ...

Criteria: According to 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. Generally, the activity related to the federal award pertains to events that require the nonfederal entity to comply with federal statutes, regulations, and the terms and conditions of Federal awards, such as expenditure/expense transactions associated with grants. For FEMA grants, non-federal entities must record expenditures on the SEFA when (1) FEMA has approved the nonfederal entity’s project, and (2) the non-federal entity has incurred the eligible expenditures. FEMA’s approval of a subaward is indicated when FEMA obligates the federal share of the eligible project cost to the recipient Federal awards expended in years subsequent to the fiscal year in which the project is approved are to be recorded on the non-federal entity’s SEFA in those subsequent years. Condition: The Authority's expenditures relating to FEMA awards obligated during the current fiscal year did not include expenditures incurred during previous fiscal years. Effect: The Authority's expenditures were understated which could have impaired proper major program determination for testing and caused a misstatement of the SEFA. Cause: The Authority experienced turnover in its grants administrator position, which led to a loss of institutional knowledge and reduced continuity in its grant management processes. As a result, the Authority faced increased difficulty complying with the unique reporting requirements applicable to FEMA awards. Recommendation: We recommend that the Authority enhance its grants administration processes by establishing formal, written procedures that address the unique reporting requirements of FEMA awards. The Authority should ensure that staff responsible for grant management receive sufficient training and that cross-training is in place to mitigate the effects of future turnover. These steps will help preserve institutional knowledge, promote consistent application of required procedures, and improve compliance with FEMA reporting standards. Views of Responsible Officials: Management agrees with the finding and will implement controls to ensure all awards are included, as well as correct going forward. See Management’s Corrective Action Plan for further details.

FY End: 2025-06-30
Lake County Community College District
Compliance Requirement: P
Assistance Listing Number, Federal Agency, and Program Name - N/A, Schedule of Expenditures of Federal Awards (SEFA) Reporting Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - Uniform Guidance (2 CFR 200.510(b)) requires a schedule of expenditures of federal awards (SEFA) that must provide total federal awards expended for the period covered by the auditee's financial statements. Federal awards expen...

Assistance Listing Number, Federal Agency, and Program Name - N/A, Schedule of Expenditures of Federal Awards (SEFA) Reporting Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - Uniform Guidance (2 CFR 200.510(b)) requires a schedule of expenditures of federal awards (SEFA) that must provide total federal awards expended for the period covered by the auditee's financial statements. Federal awards expended in accordance with §200.502 should be based on when the underlying activity related to the federal award occurs. Condition - During our review of the schedule of expenditures of federal awards, we noted that certain federal program expenditures were included in the SEFA for the fiscal year ended June 30, 2025 even though the underlying activity occurred in 2024. The College did not have adequate controls in place to ensure the SEFA was prepared to include appropriate expenditures for the Economic Development Cluster in the proper period. Questioned Costs - N/A Identification of How Questioned Costs Were Computed - N/A Context - During our review of the College's SEFA, we noted expenditures of $318,814 that were improperly included within the Economic Development Cluster in 2025. Based on review of underlying expenditures on vendor pay applications, expenditures should have been included on the SEFA in 2024. Cause and Effect - The College did not have adequate processes and internal control structure in place to ensure SEFA expenditures were recorded in the appropriate period. As a result, the SEFA is overstated by $318,814 in 2025. If the SEFA does not accurately reflect federal expenditures for the audit period, this could lead to misinterpretation of compliance requirements and inaccurate reporting to federal agencies. Recommendation - We recommend management implement procedures to ensure the SEFA preparation is based on the timing of the underlying activity rather than payment dates. Views of Responsible Officials and Planned Corrective Actions - The College will establish the proper controls to ensure that the SEFA is prepared based on the timing of the underlying activity rather than payment dates.

FY End: 2025-06-30
Central Texas Food Bank
Compliance Requirement: N
U.S. Department of Agriculture/Passed-through Texas Department of Agriculture Food Distribution Cluster Federal Assistance Listing Number 10.565 – Commodity Supplemental Food Program (Food Commodities), 10.569 – Emergency Food Assistance Program (Food Commodities) Award Number: 01576 Criteria or Specific Requirement: Special Test and Provisions – Accountability for USDA Foods – Non-cash assistance must be valued at USDA‑approved valuation methods which include cost‑per‑pound, WBCSXI catalog pric...

U.S. Department of Agriculture/Passed-through Texas Department of Agriculture Food Distribution Cluster Federal Assistance Listing Number 10.565 – Commodity Supplemental Food Program (Food Commodities), 10.569 – Emergency Food Assistance Program (Food Commodities) Award Number: 01576 Criteria or Specific Requirement: Special Test and Provisions – Accountability for USDA Foods – Non-cash assistance must be valued at USDA‑approved valuation methods which include cost‑per‑pound, WBCSXI catalog price, or rolling average (7 CFR §250.58(e) and U.G. §200.502(a)). Condition: USDA donated foods are recorded in the accounting system at standard cost based on the first product received, rather than using an approved valuation method (Fair Market Value at receipt or USDA‑determined values such as cost‑per‑pound, WBCSXI catalog price, or rolling average per 7 CFR §250.58(e) and U.G. §200.502(a)). The entity has not formally selected or documented an approved method. The Food Bank does not maintain written procedures for conducting the required annual physical inventory and reconciliation to USDA Foods records. Procedures are communicated verbally before the count. Cause: The organization had not fully implemented USDA valuation requirements due to the absence of a documented policy. Inventory practices developed informally over time, and standard operating procedures were never formalized or approved. Effect or Potential Effect: Potential misstatement of USDA Foods value for Schedule of Expenditures of Federal Awards and inconsistent valuation across periods. Inventory risk increased likelihood of count errors, timing differences, or unexplained adjustments; exposure to liability for unreconciled differences. Questioned Costs: None Context: The methodology used to value food commodities was not a USDA‑approved valuation method. Repeat Finding: No Recommendation: Select and document an approved USDA valuation method and apply it consistently. Develop and implement formal written standard operating procedures for annual physical inventory and reconciliation, including: 1. Pre‑count preparation and cut‑off 2. Tag control and independent recounts 3. Reconciliation steps and documentation of adjustments, and 4. Record retention per 7 CFR §250.19 Views of Responsible Officials and Corrective Action: Management concurs with the finding and recommendation. See further information on the corrective action plan provided by management.

FY End: 2025-06-30
Village of Milford, Michigan
Compliance Requirement: P
Assistance Listing Number, Federal Agency, and Program Name - ALN 66.202, U.S. Environmental Protection Agency - Congressionally Mandated Projects Federal Award Identification Number and Year - CG-00E03697-0, 2024 Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.510(b), 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 award...

Assistance Listing Number, Federal Agency, and Program Name - ALN 66.202, U.S. Environmental Protection Agency - Congressionally Mandated Projects Federal Award Identification Number and Year - CG-00E03697-0, 2024 Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.510(b), 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. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition - Controls were not in place to ensure that the schedule of expenditures of federal awards (SEFA) was complete and accurate. 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 - In fiscal year 2025, the Village expended approximately $935,000 of federal funding from various federal agencies. The Village accumulates the financial data and other required information to complete the SEFA. Expenditures under grant ALN 66.202, Congressionally Mandated Projects, were originally overstated by $40,088 due to duplication of costs. No controls were in place to identify incompleteness or inaccuracy of the SEFA. Cause and Effect - No review or other control was in place to ensure the SEFA was complete and accurate. As a result, ALN 66.202, Congressionally Mandated Projects, expenditures were overstated by $40,088. This error has been corrected on the SEFA as of June 30, 2025. Recommendation - The Village should implement controls to ensure the SEFA is reviewed for completeness and accuracy. Views of Responsible Officials and Planned Corrective Actions - The Village has hired an outside contractor to assist with review of audit documents.

FY End: 2025-06-30
California State University
Compliance Requirement: P
Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Campus: Sacramento, Sonoma Cluster name/program: Supplemental Nutrition Assistance Program Cluster and Reserach and Development Programs Cluster Listing Numbers: 10.561, 47.076, and 84.411 Federal Agency: U.S. Department of Agriculture National Science Foundation U.S. Department of Education Passed through Entity: 10.561 - State of California Department of Social Services Federal Award Identifi...

Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Campus: Sacramento, Sonoma Cluster name/program: Supplemental Nutrition Assistance Program Cluster and Reserach and Development Programs Cluster Listing Numbers: 10.561, 47.076, and 84.411 Federal Agency: U.S. Department of Agriculture National Science Foundation U.S. Department of Education Passed through Entity: 10.561 - State of California Department of Social Services Federal Award Identification Numbers: 10.561: 21-3068 and 24-3069, 47.076: 1953472, and 84.411: S411B230042 Award Year: July 1, 2024 – June 30, 2025 Criteria: According to 2 CFR 200.502(a), the determination 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: (1) Expenditure/expense transactions associated with grants, cooperative agreements, cost-reimbursement contracts under the FAR, compacts with Indian Tribes, and direct appropriations; (2) The disbursement of funds to subrecipients; Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designated to reasonably ensure compliance with Federal laws and regulations. Effective internal controls should include procedures to ensure federal expenditures are accurately and completely reported on the Schedule of Expenditures of Federal Awards (SEFA). Condition and Context: ALN 10.561: We noted the Sacramento campus incorrectly recorded $712,979 of subrecipient expenditures which were not disbursed during FY2025. This resulted in an overstatement of expenditures on the FY2025 SEFA which management adjusted the SEFA accordingly. ALN 10.561: During our testing of nonpayroll expenditures for the Sacramento campus, we noted $25,605 related to a period outside of FY2025. The total out of period expense including the indirect cost was $32,006. This resulted in an overstatement of expenditures on the SEFA for FY2025. ALN 84.411: During our testing of indirect cost for the Sonoma campus, we noted $29,495 of expenditures related to a period outside of FY2025 resulting from management correcting the indirect cost rate for a grant that began in the prior year and recording all of the adjustment in FY2025. This resulted in an overstatement of expenditures on the FY2025 SEFA. ALN 47.076: During our payroll testing for the Sonoma campus, we noted $13,980 of expenditures related to a period outside of FY2025. The total out of period expense including the indirect cost was $21,110. This results in an overstatement of FY2025 Schedule of Expenditures of Federal Awards (SEFA). Cause and Effect: While the University’s policy is to record subrecipient expenditures on the SEFA upon the disbursement of funds to recipients, the Sacramento campus’ SEFA preparation process did not adequately consider whether amounts recorded in the SEFA had been disbursed to the subrecipient. At the Sonoma campus, the error was the results of an indirect cost rate being utilized from a previous grant versus the updated rate in the new grant. There was also a lack of internal controls over the accruals of summer payroll impacting federal awards. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA resulted in an overstatement of expenditures. Questioned Costs: Not applicable Statistical Sampling: Not applicable Repeat Finding: Yes for 10.561 and No for 47.076 and 84.411 Recommendation: We recommend the University implement a system of internal control that is designed and operating effectively to ensure the SEFA is complete and accurate. Views of Responsible Officials: The University concurs with the recommendation. The University will review and enhance its procedures and internal controls to ensure the SEFA is complete and accurate.

FY End: 2025-06-30
Northeastern Local School District
Compliance Requirement: L
Management acknowledged its responsibility to establish and maintain effective internal controls to reasonably assure compliance with federal statutes, regulations and terms and conditions of federal awards and controls relating to preparing the Schedule of Expenditures of Federal Awards (the Schedule), as required by Uniform Guidance (2 CFR § 200.303(a)), in the audit engagement letter. Furthermore, Uniform Guidance (2 CFR Subpart F § 200.510(b)) requires the auditee prepare the Schedule for th...

Management acknowledged its responsibility to establish and maintain effective internal controls to reasonably assure compliance with federal statutes, regulations and terms and conditions of federal awards and controls relating to preparing the Schedule of Expenditures of Federal Awards (the Schedule), as required by Uniform Guidance (2 CFR § 200.303(a)), in the audit engagement letter. Furthermore, Uniform Guidance (2 CFR Subpart F § 200.510(b)) requires the auditee prepare the Schedule for the period covered by the District’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. Due to insufficient controls over the monitoring of grant activity, the District did not retain appropriate support on the dates of the determination to charge prior year costs to the American Rescue Plan Elementary and Secondary School Emergency Relief Fund (ARP ESSER) grant in the amount of $678,544. The grant award was for $1,019,060, which had a grant period spanning calendar years 2020 through 2024. Lack of maintaining such documentation could result in expenditures determined to be unallowable under grant guidelines and funds required to be returned. Ineffective internal controls related to federal grants could lead to noncompliance with program requirements. Additionally, the determination of unallowable costs could have an adverse effect on future grant awards by the awarding agency or agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit. District management should implement a system to review the Schedule for errors and omissions as well as a method to monitor the related internal controls over compliance with federal grant requirements. This will help ensure the Schedule is complete and accurate, major federal programs are accurately identified for audit, and internal controls over compliance requirements are implemented and operating effectively.

FY End: 2025-06-30
Grant County
Compliance Requirement: P
2025-003 (2023-002) – INACCURATE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Type of Finding: (F) Significant Deficiency in Internal Control Over Compliance of Federal Awards Funding Agency: All (see Schedule of Expenditures of Federal Awards) Title: All (see Schedule of Expenditures of Federal Awards) AL #: All (see Schedule of Expenditures of Federal Awards) Award #: All (see Schedule of Expenditures of Federal Awards) Award Period: All (see Schedule of Expenditures of Federal Awards) Questione...

2025-003 (2023-002) – INACCURATE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Type of Finding: (F) Significant Deficiency in Internal Control Over Compliance of Federal Awards Funding Agency: All (see Schedule of Expenditures of Federal Awards) Title: All (see Schedule of Expenditures of Federal Awards) AL #: All (see Schedule of Expenditures of Federal Awards) Award #: All (see Schedule of Expenditures of Federal Awards) Award Period: All (see Schedule of Expenditures of Federal Awards) Questioned Costs: None Statement of Condition The Schedule of Expenditures of Federal Awards (SEFA) was provided timely to the auditors; however, several adjustments were identified during the audit process: • The SEFA incorrectly included match expenditures, requiring an reduction to the federal expenses of $324,936. Without accurate recording of federal award expenditures, auditors cannot appropriately assess and select federal programs for testing as mandated by the Single Audit Act. Management’s Progress Toward Prior Year Corrective Action Plan: The County has made progress toward addressing the prior year’s SEFA accuracy finding; however, additional corrections remain necessary, as noted above. Criteria 2 CFR § 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with federal laws, regulations, and program requirements. Good internal control practices require the entity to have documented procedures for: • Properly identifying federal, state, and other funding sources. • Classifying expenditures accurately under the correct federal assistance listing numbers. • Ensuring expenditures reported on the SEFA are accurate and presented according to requirements. Additionally, 2 CFR 200.510(b) mandates the preparation of an accurate and complete SEFA for the audit period, including federal expenditures as determined in accordance with 2 CFR 200.502. Cause The County did not have comprehensive controls to ensure that all federal expenditures are correctly tracked, accurately classified, and properly reported on the SEFA. Effect Without accurate, timely tracking and reporting of federal expenditures, the County is at risk of improperly accounting for federal awards, potentially leading to noncompliance, questioned costs, or repayment obligations. Recommendation We recommend that the County establish, document, and implement a comprehensive internal control structure specifically designed to: • Clearly identify, track, and report grant expenditures. • Accurately distinguish between federal and non-federal expenditures. • Prepare and review the SEFA regularly to ensure completeness, accuracy, and compliance with the Uniform Guidance (2 CFR 200.502 and .510) accrual-basis requirements.

FY End: 2025-06-30
City of Manhattan Beach
Compliance Requirement: L
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 incu...

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.

FY End: 2025-06-30
Commonwealth of Virginia
Compliance Requirement: B
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): ...

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.

FY End: 2025-06-30
Washington Metropolitan Area Transit Authority
Compliance Requirement: P
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 ...

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.

FY End: 2025-06-30
Second Judicial District Court
Compliance Requirement: L
PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (SEFA) Type of Finding (F) Significant Deficiency in Internal Control Over Compliance of Federal Awards Programs Affected Federal Agencies: 1) U.S. Department of Homeland Security and 2) U.S. General Services Administration. Title: 1) Disaster Grants - Public Assistance (Presidentially Declared Disasters) 2) Donation of Federal Surplus Personal Property ALNs: 1) 97.036 and 2) 39.003 (Not Major Federal Programs) Award #s: 1) DPS24FEMASFSP,...

PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (SEFA) Type of Finding (F) Significant Deficiency in Internal Control Over Compliance of Federal Awards Programs Affected Federal Agencies: 1) U.S. Department of Homeland Security and 2) U.S. General Services Administration. Title: 1) Disaster Grants - Public Assistance (Presidentially Declared Disasters) 2) Donation of Federal Surplus Personal Property ALNs: 1) 97.036 and 2) 39.003 (Not Major Federal Programs) Award #s: 1) DPS24FEMASFSP, DPS25FMAROSFL, 2) Robots Compliance Requirement: Reporting Award Period: Various Questioned Costs: None Noted Condition The Department prepares its Schedule of Expenditures of Federal Awards (SEFA) using a quarterly reconciliation process in SHARE that focuses on reviewing grant-related transactions for invoicing and monitoring purposes. This process provides a strong foundation for grant oversight and expense allowability. The SEFA originally provided for audit totaled $15,677,562 and was subsequently corrected to $16,736,829, resulting in an understatement of $1,059,269 (6.33%). The adjustments primarily consisted of: • $583,271 related to AL 97.036 Disaster Grants - Public Assistance (Presidentially Declared Disasters), • $450,000 of federal noncash surplus property (equipment/robots) related to AL 39.003, and • $25,998 of other net adjustments These differences occurred because certain federal award activity was not fully captured or reported through the quarterly expense-focused reconciliation process. Specifically: • Noncash federal assistance was not identified and valued for inclusion in the SEFA, and • Federal award activity associated with a presidentially declared disaster was not fully reflected in the original SEFA, in part due to the timing and complexity of the declaration and award identification. The audit team worked collaboratively with key members of the Department’s grant management and finance teams to identify these items, evaluate applicable guidance, and confirm the accuracy and completeness of the final SEFA. Criteria The auditee is required to prepare a Schedule of Expenditures of Federal Awards for the period covered by the financial statements in accordance with 2 CFR 200.502. Federal awards expended include cash and noncash assistance, including the receipt of property (such as surplus property), which must be valued at fair market value at the time of receipt (or at the assessed value provided by the federal agency) and included in the SEFA. Effect If SEFA amounts are incomplete or inaccurate, errors may not be prevented or detected in a timely manner and could affect major federal program determination and Single Audit planning and execution, which may adversely impact compliance oversight and future funding decisions. Cause While the Department’s quarterly SHARE reconciliation process is effective for reviewing expense allowability and supporting reimbursement requests, it was not designed to fully address SEFAspecific completeness requirements. In particular: • The process did not include a formal reconciliation of SEFA totals by AL/award to federal revenue recorded in the general ledger and grant support, and • Procedures were not in place to consistently identify, value, and document noncash federal assistance and certain complex or timing-sensitive award activity for SEFA purposes. As a result, differences between expenses reviewed for reimbursement and federal revenue recorded in the accounting records were not identified during SEFA preparation. Recommendation We recommend the Department enhance its SEFA preparation documentation and review procedures. The procedures should include the following: • Reconciliation of SEFA totals – Performing and documenting a reconciliation of SEFA totals by AL/award to the general ledger, grant subledger, and other supporting documentation. • Noncash and complex award identification – Implementing procedures to identify, value, and document noncash federal assistance and other complex or timing-sensitive award activity (such as disaster-related awards) for inclusion in the SEFA. • Revenue-based SEFA completeness review – In addition to the Department’s existing expense-level review of allowability (which should continue), performing a SEFA-specific review from a revenue perspective to confirm that federal revenue recorded in the general ledger and requests for reimbursement are complete and consistent with grant-related expenses. This review would help identify situations where expenses are evaluated or adjusted for reimbursement purposes but remain recorded within grant activity in the accounting records. • Independent supervisory review – Documenting independent supervisory review and approval of the SEFA prior to submission, evidenced by sign-off.

FY End: 2025-06-30
State of Vermont
Compliance Requirement: L
Reference Number: 2025-010 Prior Year Finding: No Federal Agency: U.S. Department of Transportation State Agency: Agency of Transportation Federal Program: National Infrastructure Investments Assistance Listing Number: 20.933 Award Number and Year: 69A36520401930BLDVT (8/1/2020 – 10/31/2026) CA0714 (4/29/2022 – 4/29/2032) CA0751 (5/1/2023 – 10/1/2028) CA0906 (1/24/2025 – 11/1/2030) Compliance Requirement: Reporting – Schedule of Expenditure of Federal Awards Type of Finding: Material Weakness in...

Reference Number: 2025-010 Prior Year Finding: No Federal Agency: U.S. Department of Transportation State Agency: Agency of Transportation Federal Program: National Infrastructure Investments Assistance Listing Number: 20.933 Award Number and Year: 69A36520401930BLDVT (8/1/2020 – 10/31/2026) CA0714 (4/29/2022 – 4/29/2032) CA0751 (5/1/2023 – 10/1/2028) CA0906 (1/24/2025 – 11/1/2030) Compliance Requirement: Reporting – Schedule of Expenditure of Federal Awards Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance Criteria or specific requirement: Compliance: The auditee must prepare a schedule of expenditures of Federal awards (SEFA) 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. Information reported on the SEFA must include a list of individual Federal programs by Federal agency and the applicable Assistance Listing number(s), and a total of the amount expended for each individual Federal program. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Agency of Transportation (Agency) reported federal program expenditures on the SEFA under the wrong Assistance Listing Numbers (ALN). Context: When the Agency compiled its SEFA, it reported $11 million under ALN 20.314-Railroad Development. During the audit, it was determined that expenditures reported under ALN 20.314 should have been $0 and $10.7 million of this amount should have been reported under ALN 20.933-National Infrastructure Investment. Additionally, $312,460 should have been reported under ALN 20.326-Federal-State Partnership for Intercity Passenger Rail, and $6,739 should have been reported under ALN 20.325-Consolidated Rail Infrastructure and Safety Improvements. Cause: The Agency’s procedures were not sufficient to ensure that the SEFA was accurate and that program expenditures were reported under the correct ALNs. The Agency assigned an incorrect ALN to the Expenditure Account associated with these payments in the accounting system which led to the SEFA reporting error. Neither payment processing nor SEFA preparation controls prevented or detected the errors. Effect: The Department’s SEFA did not agree with supporting documentation. The Department understated total expenditures under ALN 20.933 by 51%, under ALN 20.325 by 1%, under ALN 20.326 by 100%, and overstated total expenditures under ALN 20.314 by 100%. Questioned costs: Undetermined. Recommendation: We recommend the Agency review and enhance internal controls and procedures for payment processing and SEFA preparation to ensure that payments are properly coded in the accounting system and that expenditures are reported accurately on the SEFA. Views of responsible officials: Management agrees with the finding.

FY End: 2025-06-30
State of Vermont
Compliance Requirement: L
Reference Number: 2025-014 Prior Year Finding: No Federal Agency: U.S. Environmental Protection Agency State Agency: Department of Environmental Conservation Federal Program: Drinking Water Sate Revolving Fund Assistance Listing Number: 66.468 Award Number and Year: 99121S23 (10/1/2023 – 9/30/2030) 99121E23 (10/1/2023 – 9/30/2030) Compliance Requirement: Reporting – Schedule of Expenditure of Federal Awards Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompl...

Reference Number: 2025-014 Prior Year Finding: No Federal Agency: U.S. Environmental Protection Agency State Agency: Department of Environmental Conservation Federal Program: Drinking Water Sate Revolving Fund Assistance Listing Number: 66.468 Award Number and Year: 99121S23 (10/1/2023 – 9/30/2030) 99121E23 (10/1/2023 – 9/30/2030) Compliance Requirement: Reporting – Schedule of Expenditure of Federal Awards Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance Criteria or specific requirement: Compliance: The auditee must prepare a schedule of expenditures of Federal awards (SEFA) 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. Information reported on the SEFA must include a list of individual Federal programs by Federal agency and the applicable Assistance Listing number(s), and a total of the amount expended for each individual Federal program. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Department of Environmental Conservation (Department) reported federal program expenditures on the SEFA under the wrong Assistance Listing Number (ALN). Context: During audit test work, auditors determined that $3.8 million reported on the SEFA under ALN 66.468-Drinking Water State Revolving Fund should have been reported under 66.458-Clean Water State Revolving Fund. This error was made in both total expenditures and the amount passed through to subrecipients. Correction of the reporting error increased total expenditures reported in ALN 66.458 by 32% and decreased total expenditures reported in ALN 66.468 by 7%. Cause: The Department’s procedures were not sufficient to ensure that the SEFA was accurate and that program expenditures were reported under the correct ALNs. Internal controls did not prevent or detected the errors. Effect: The Department’s SEFA did not agree with supporting documentation. The Department overstated total expenditures under ALN 66.468 by 7% and underreported total expenditures under ALN 66.458 by 32%. Questioned costs: None noted. Recommendation: We recommend the Department review and enhance internal controls and procedures for SEFA preparation to ensure that expenditures are reported accurately on the SEFA. Views of responsible officials: Management agrees with the finding.

FY End: 2025-06-30
University of California
Compliance Requirement: L
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 Co...

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.

FY End: 2025-06-30
Unified School District No. 321
Compliance Requirement: ABL
2025-003 Internal controls over Schedule of Expenditures of Federal Awards Preparation (Material Weakness) Federal Agency: U.S Department of Education Pass through entity: Kansas Department of Education Program Name: Child Nutrition Cluster; Education Stabilization Fund Assistance Listing Numbers: 10.553, 10.555 and 10.559; 84.425 Award Period: June 30, 2025 Criteria: According to 2 CFR 200, Subpart F, the District is required to prepare a schedule of federal expenditures, which must include the...

2025-003 Internal controls over Schedule of Expenditures of Federal Awards Preparation (Material Weakness) Federal Agency: U.S Department of Education Pass through entity: Kansas Department of Education Program Name: Child Nutrition Cluster; Education Stabilization Fund Assistance Listing Numbers: 10.553, 10.555 and 10.559; 84.425 Award Period: June 30, 2025 Criteria: According to 2 CFR 200, Subpart F, the District is required to prepare a schedule of federal expenditures, which must include the total federal awards expended as determined in accordance with §200.502. An effective internal control system exists if controls are effective in preventing or detecting material misstatements in the preparation of the schedule of federal expenditures of federal awards (the schedule). It provides reasonable assurance for the reliability of financial information and compliance with laws and regulations. Condition: We have determined that there was an inadequate design of internal control over the preparation of the schedule during the fiscal year ended June 30, 2025. The current financial reporting process does not ensure accuracy and completeness in the preparation of the schedule by the District, as required by Uniform Guidance. Context: During our audit of the federal programs for the fiscal year ended June 30, 2025, we performed procedures to verify the accuracy and completeness of the Schedule of Expenditures of Federal Awards (SEFA). Our testing identified material misstatements in the initial SEFA provided by management, indicating that the District’s reporting process did not accurately capture all federal award activity. Cause: The District’s policies and procedures were not designed to ensure the District’s preparation of the schedule in conformity with Uniform Guidance. Effect: The District did not prepare a complete and accurate schedule in conformity with Uniform Guidance as significant modifications were required. This increases the likelihood of a material misstatement and noncompliance with laws and regulations. Recommendation: We recommend the Board of Education and management review the financial reporting process. Once this review is complete, the District should then perform a risk assessment to determine the best way to implement appropriate internal controls over financial reporting to ensure that the District prepares the schedule conformity with Uniform Guidance. Questioned Costs: None. Repeat Finding: Yes, 2024-003. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and plans to develop proper written policies and procedures for the internal control over compliance to ensure accuracy and completeness in the District’s preparation of the schedule as required by Uniform Guidance.

FY End: 2025-06-30
Oregon State University
Compliance Requirement: AB
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 ...

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.

FY End: 2025-06-30
County of Orange, California
Compliance Requirement: P
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 –...

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.

FY End: 2025-06-30
Town of Batesburg-Leesville
Compliance Requirement: L
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 expenditure...

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.

FY End: 2025-06-30
Town of Batesburg-Leesville
Compliance Requirement: L
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 ...

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.

FY End: 2025-06-30
County of Ventura
Compliance Requirement: P
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) - Sched...

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.

FY End: 2025-06-30
National Church Residences
Compliance Requirement: L
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...

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.

FY End: 2025-06-30
County of San Joaquin
Compliance Requirement: M
2025-004-Subrecipient Monitoring Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Assistance Listing Number: 21.027 Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance (Modified Opinion) Criteria: Per 2 CFR sections 200.332(d) through (f), a pass-through entity must monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purpose...

2025-004-Subrecipient Monitoring Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Assistance Listing Number: 21.027 Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance (Modified Opinion) Criteria: Per 2 CFR sections 200.332(d) through (f), a pass-through entity must monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, complies with the terms and conditions of the subaward, and achieves the performance goals. Per 2 CFR section 200.502(a), the determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs which is generally expenditure/expense transactions associated with awards. Condition: During our testing over subrecipient monitoring, the County was unable to provide subrecipient monitoring support. Questioned Costs: None Context: We selected a sample of 7 subrecipients as part of our testing over Subrecipient Monitoring. Of the 7 subrecipients selected, the County was unable to provide adequate support for the subrecipients selected. Cause: The County has policies that require departments to conduct subrecipient monitoring to ensure compliance with grant requirements. However, the policy does not include documentation of these monitoring activities, such as site visits, financial reviews, or performance evaluations. This lack of documentation results in an inability to verify that subrecipient monitoring is being performed effectively and consistently. Effect: Without proper oversight, subrecipients may fail to achieve program goals and objectives, leading to poor performance and outcomes for the funded programs. Repeat Finding: Yes Recommendation: We recommend that the County implement procedures to ensure that federal guidance is followed related to subrecipient monitoring and provide training on these procedures, including maintaining documentation of the review performed by the County. View of Responsible Officials: There is no disagreement with the audit finding.

FY End: 2025-06-30
Ignacio School District 11JT
Compliance Requirement: L
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. Departmen...

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.

FY End: 2024-12-31
City of Fort Collins, Colorado
Compliance Requirement: L
Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.20...

Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.205: Colorado Department of Transportation - ALN 21.027: N/A Finding Type - Material weakness Repeat Finding - Yes 2023-003 Criteria - According to 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. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Condition - The fiscal year 2024 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal years 2023 and 2025. 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 - Within Highway Planning and Construction, the expenditures reported on the initial SEFA included $142,724 that related to expenditures incurred in fiscal year 2023. There was also $16,128 that related to expenditures incurred in fiscal year 2024 that was not reported on the initial SEFA. Within Coronavirus State and Local Fiscal Recovery Funds, the expenditures reported on the initial SEFA included $15,921 that related to expenditures incurred in fiscal year 2023 and $99,200 that related to expenditures incurred in fiscal year 2025. Cause and Effect - The City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Recommendation - The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan - The City of Fort Collins, Colorado has determined that two separate and identifiable root causes led to the inclusion of expenditures from fiscal years 2023 and 2025 in the initial fiscal year 2024 SEFA. 1. Improper Accrual of Prepayments: A small number of transactions involving partial prepayments were not properly accrued in accordance with accounting standards. To address this issue, the City will implement a formal review process where all reimbursement requests are reviewed by the grant accountant prior to submission. This review will include a targeted examination of expenditure listings to identify and ensure appropriate treatment of any transactions requiring accrual as prepayments. 2. Inconsistencies Between Reimbursement Packets and the General Ledger: For the Highway Planning and Construction Cluster, the SEFA preparation process previously relied on reimbursement request packets compiled by departmental staff. In some cases, these packets did not accurately reflect the timing of expenditures recorded in the general ledger. To enhance accuracy, the City will implement a reconciliation procedure requiring the grant accountant to cross-reference reimbursement packet data with the general ledger during SEFA preparation. This step will help ensure that all expenditures are properly reported in the appropriate fiscal year. The City is confident that these corrective actions will strengthen internal controls over SEFA preparation and prevent recurrence of similar issues in future reporting periods.

FY End: 2024-12-31
City of Fort Collins, Colorado
Compliance Requirement: L
Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.20...

Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.205: Colorado Department of Transportation - ALN 21.027: N/A Finding Type - Material weakness Repeat Finding - Yes 2023-003 Criteria - According to 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. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Condition - The fiscal year 2024 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal years 2023 and 2025. 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 - Within Highway Planning and Construction, the expenditures reported on the initial SEFA included $142,724 that related to expenditures incurred in fiscal year 2023. There was also $16,128 that related to expenditures incurred in fiscal year 2024 that was not reported on the initial SEFA. Within Coronavirus State and Local Fiscal Recovery Funds, the expenditures reported on the initial SEFA included $15,921 that related to expenditures incurred in fiscal year 2023 and $99,200 that related to expenditures incurred in fiscal year 2025. Cause and Effect - The City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Recommendation - The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan - The City of Fort Collins, Colorado has determined that two separate and identifiable root causes led to the inclusion of expenditures from fiscal years 2023 and 2025 in the initial fiscal year 2024 SEFA. 1. Improper Accrual of Prepayments: A small number of transactions involving partial prepayments were not properly accrued in accordance with accounting standards. To address this issue, the City will implement a formal review process where all reimbursement requests are reviewed by the grant accountant prior to submission. This review will include a targeted examination of expenditure listings to identify and ensure appropriate treatment of any transactions requiring accrual as prepayments. 2. Inconsistencies Between Reimbursement Packets and the General Ledger: For the Highway Planning and Construction Cluster, the SEFA preparation process previously relied on reimbursement request packets compiled by departmental staff. In some cases, these packets did not accurately reflect the timing of expenditures recorded in the general ledger. To enhance accuracy, the City will implement a reconciliation procedure requiring the grant accountant to cross-reference reimbursement packet data with the general ledger during SEFA preparation. This step will help ensure that all expenditures are properly reported in the appropriate fiscal year. The City is confident that these corrective actions will strengthen internal controls over SEFA preparation and prevent recurrence of similar issues in future reporting periods.

FY End: 2024-12-31
City of Fort Collins, Colorado
Compliance Requirement: L
Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.20...

Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.205: Colorado Department of Transportation - ALN 21.027: N/A Finding Type - Material weakness Repeat Finding - Yes 2023-003 Criteria - According to 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. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Condition - The fiscal year 2024 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal years 2023 and 2025. 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 - Within Highway Planning and Construction, the expenditures reported on the initial SEFA included $142,724 that related to expenditures incurred in fiscal year 2023. There was also $16,128 that related to expenditures incurred in fiscal year 2024 that was not reported on the initial SEFA. Within Coronavirus State and Local Fiscal Recovery Funds, the expenditures reported on the initial SEFA included $15,921 that related to expenditures incurred in fiscal year 2023 and $99,200 that related to expenditures incurred in fiscal year 2025. Cause and Effect - The City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Recommendation - The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan - The City of Fort Collins, Colorado has determined that two separate and identifiable root causes led to the inclusion of expenditures from fiscal years 2023 and 2025 in the initial fiscal year 2024 SEFA. 1. Improper Accrual of Prepayments: A small number of transactions involving partial prepayments were not properly accrued in accordance with accounting standards. To address this issue, the City will implement a formal review process where all reimbursement requests are reviewed by the grant accountant prior to submission. This review will include a targeted examination of expenditure listings to identify and ensure appropriate treatment of any transactions requiring accrual as prepayments. 2. Inconsistencies Between Reimbursement Packets and the General Ledger: For the Highway Planning and Construction Cluster, the SEFA preparation process previously relied on reimbursement request packets compiled by departmental staff. In some cases, these packets did not accurately reflect the timing of expenditures recorded in the general ledger. To enhance accuracy, the City will implement a reconciliation procedure requiring the grant accountant to cross-reference reimbursement packet data with the general ledger during SEFA preparation. This step will help ensure that all expenditures are properly reported in the appropriate fiscal year. The City is confident that these corrective actions will strengthen internal controls over SEFA preparation and prevent recurrence of similar issues in future reporting periods.

FY End: 2024-12-31
City of Fort Collins, Colorado
Compliance Requirement: L
Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.20...

Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.205: Colorado Department of Transportation - ALN 21.027: N/A Finding Type - Material weakness Repeat Finding - Yes 2023-003 Criteria - According to 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. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Condition - The fiscal year 2024 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal years 2023 and 2025. 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 - Within Highway Planning and Construction, the expenditures reported on the initial SEFA included $142,724 that related to expenditures incurred in fiscal year 2023. There was also $16,128 that related to expenditures incurred in fiscal year 2024 that was not reported on the initial SEFA. Within Coronavirus State and Local Fiscal Recovery Funds, the expenditures reported on the initial SEFA included $15,921 that related to expenditures incurred in fiscal year 2023 and $99,200 that related to expenditures incurred in fiscal year 2025. Cause and Effect - The City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Recommendation - The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan - The City of Fort Collins, Colorado has determined that two separate and identifiable root causes led to the inclusion of expenditures from fiscal years 2023 and 2025 in the initial fiscal year 2024 SEFA. 1. Improper Accrual of Prepayments: A small number of transactions involving partial prepayments were not properly accrued in accordance with accounting standards. To address this issue, the City will implement a formal review process where all reimbursement requests are reviewed by the grant accountant prior to submission. This review will include a targeted examination of expenditure listings to identify and ensure appropriate treatment of any transactions requiring accrual as prepayments. 2. Inconsistencies Between Reimbursement Packets and the General Ledger: For the Highway Planning and Construction Cluster, the SEFA preparation process previously relied on reimbursement request packets compiled by departmental staff. In some cases, these packets did not accurately reflect the timing of expenditures recorded in the general ledger. To enhance accuracy, the City will implement a reconciliation procedure requiring the grant accountant to cross-reference reimbursement packet data with the general ledger during SEFA preparation. This step will help ensure that all expenditures are properly reported in the appropriate fiscal year. The City is confident that these corrective actions will strengthen internal controls over SEFA preparation and prevent recurrence of similar issues in future reporting periods.

FY End: 2024-12-31
City of Fort Collins, Colorado
Compliance Requirement: L
Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.20...

Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.205: Colorado Department of Transportation - ALN 21.027: N/A Finding Type - Material weakness Repeat Finding - Yes 2023-003 Criteria - According to 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. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Condition - The fiscal year 2024 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal years 2023 and 2025. 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 - Within Highway Planning and Construction, the expenditures reported on the initial SEFA included $142,724 that related to expenditures incurred in fiscal year 2023. There was also $16,128 that related to expenditures incurred in fiscal year 2024 that was not reported on the initial SEFA. Within Coronavirus State and Local Fiscal Recovery Funds, the expenditures reported on the initial SEFA included $15,921 that related to expenditures incurred in fiscal year 2023 and $99,200 that related to expenditures incurred in fiscal year 2025. Cause and Effect - The City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Recommendation - The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan - The City of Fort Collins, Colorado has determined that two separate and identifiable root causes led to the inclusion of expenditures from fiscal years 2023 and 2025 in the initial fiscal year 2024 SEFA. 1. Improper Accrual of Prepayments: A small number of transactions involving partial prepayments were not properly accrued in accordance with accounting standards. To address this issue, the City will implement a formal review process where all reimbursement requests are reviewed by the grant accountant prior to submission. This review will include a targeted examination of expenditure listings to identify and ensure appropriate treatment of any transactions requiring accrual as prepayments. 2. Inconsistencies Between Reimbursement Packets and the General Ledger: For the Highway Planning and Construction Cluster, the SEFA preparation process previously relied on reimbursement request packets compiled by departmental staff. In some cases, these packets did not accurately reflect the timing of expenditures recorded in the general ledger. To enhance accuracy, the City will implement a reconciliation procedure requiring the grant accountant to cross-reference reimbursement packet data with the general ledger during SEFA preparation. This step will help ensure that all expenditures are properly reported in the appropriate fiscal year. The City is confident that these corrective actions will strengthen internal controls over SEFA preparation and prevent recurrence of similar issues in future reporting periods.

FY End: 2024-12-31
City of Fort Collins, Colorado
Compliance Requirement: L
Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.20...

Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.205: Colorado Department of Transportation - ALN 21.027: N/A Finding Type - Material weakness Repeat Finding - Yes 2023-003 Criteria - According to 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. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Condition - The fiscal year 2024 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal years 2023 and 2025. 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 - Within Highway Planning and Construction, the expenditures reported on the initial SEFA included $142,724 that related to expenditures incurred in fiscal year 2023. There was also $16,128 that related to expenditures incurred in fiscal year 2024 that was not reported on the initial SEFA. Within Coronavirus State and Local Fiscal Recovery Funds, the expenditures reported on the initial SEFA included $15,921 that related to expenditures incurred in fiscal year 2023 and $99,200 that related to expenditures incurred in fiscal year 2025. Cause and Effect - The City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Recommendation - The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan - The City of Fort Collins, Colorado has determined that two separate and identifiable root causes led to the inclusion of expenditures from fiscal years 2023 and 2025 in the initial fiscal year 2024 SEFA. 1. Improper Accrual of Prepayments: A small number of transactions involving partial prepayments were not properly accrued in accordance with accounting standards. To address this issue, the City will implement a formal review process where all reimbursement requests are reviewed by the grant accountant prior to submission. This review will include a targeted examination of expenditure listings to identify and ensure appropriate treatment of any transactions requiring accrual as prepayments. 2. Inconsistencies Between Reimbursement Packets and the General Ledger: For the Highway Planning and Construction Cluster, the SEFA preparation process previously relied on reimbursement request packets compiled by departmental staff. In some cases, these packets did not accurately reflect the timing of expenditures recorded in the general ledger. To enhance accuracy, the City will implement a reconciliation procedure requiring the grant accountant to cross-reference reimbursement packet data with the general ledger during SEFA preparation. This step will help ensure that all expenditures are properly reported in the appropriate fiscal year. The City is confident that these corrective actions will strengthen internal controls over SEFA preparation and prevent recurrence of similar issues in future reporting periods.

FY End: 2024-12-31
City of Loveland
Compliance Requirement: L
Assistance Listing, Federal Agency, and Program Name - 20.205, U.S. Department of Transportation, Highway Planning and Construction; 15.916, U.S. Department of the Interior, Outdoor Recreation, Acquisition, Development and Planning Federal Award Identification Number and Year - FAINs not available Pass through Entity - ALN 20.205 Colorado Department of Transportiation; ALN 15.916 Colorado Parks and Wildlife/Land and Water Conservation Fund Finding Type - Material weakness Repeat Finding ...

Assistance Listing, Federal Agency, and Program Name - 20.205, U.S. Department of Transportation, Highway Planning and Construction; 15.916, U.S. Department of the Interior, Outdoor Recreation, Acquisition, Development and Planning Federal Award Identification Number and Year - FAINs not available Pass through Entity - ALN 20.205 Colorado Department of Transportiation; ALN 15.916 Colorado Parks and Wildlife/Land and Water Conservation Fund Finding Type - Material weakness Repeat Finding - No Criteria - The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of federal awards, in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition - The schedule of expenditures of federal awards (the "SEFA") was not accurate. Questioned Costs - None If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported - Not applicable Identification of How Questioned Costs Were Computed - Not applicable Context - During the fiscal year ended December 31, 2024, the City expended approximately $22,617,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 20.205 The expenditures reported on the SEFA were overstated by $19,522 for one award and understated by $145,869 for another award. ALN 15.916 The expenditures reported on the SEFA were overstated by $45,915 The errors noted above have been corrected on the SEFA as of December 31, 2024. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the understatement of federal expenditures. Recommendation - We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - The City accepts this finding. As part of the revision to the City’s grant process and procedures, we will enhance our master grant tracking spreadsheet to ensure grant expenditures are reported correctly. We will collaborate with city departments to ensure costs are recorded correctly. See the corrective action plan.

FY End: 2024-12-31
City of Loveland
Compliance Requirement: L
Assistance Listing, Federal Agency, and Program Name - 20.205, U.S. Department of Transportation, Highway Planning and Construction; 15.916, U.S. Department of the Interior, Outdoor Recreation, Acquisition, Development and Planning Federal Award Identification Number and Year - FAINs not available Pass through Entity - ALN 20.205 Colorado Department of Transportiation; ALN 15.916 Colorado Parks and Wildlife/Land and Water Conservation Fund Finding Type - Material weakness Repeat Finding ...

Assistance Listing, Federal Agency, and Program Name - 20.205, U.S. Department of Transportation, Highway Planning and Construction; 15.916, U.S. Department of the Interior, Outdoor Recreation, Acquisition, Development and Planning Federal Award Identification Number and Year - FAINs not available Pass through Entity - ALN 20.205 Colorado Department of Transportiation; ALN 15.916 Colorado Parks and Wildlife/Land and Water Conservation Fund Finding Type - Material weakness Repeat Finding - No Criteria - The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of federal awards, in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition - The schedule of expenditures of federal awards (the "SEFA") was not accurate. Questioned Costs - None If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported - Not applicable Identification of How Questioned Costs Were Computed - Not applicable Context - During the fiscal year ended December 31, 2024, the City expended approximately $22,617,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 20.205 The expenditures reported on the SEFA were overstated by $19,522 for one award and understated by $145,869 for another award. ALN 15.916 The expenditures reported on the SEFA were overstated by $45,915 The errors noted above have been corrected on the SEFA as of December 31, 2024. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the understatement of federal expenditures. Recommendation - We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - The City accepts this finding. As part of the revision to the City’s grant process and procedures, we will enhance our master grant tracking spreadsheet to ensure grant expenditures are reported correctly. We will collaborate with city departments to ensure costs are recorded correctly. See the corrective action plan.

FY End: 2024-12-31
Council of Graduate Schools
Compliance Requirement: B
Finding 2024-001: Reportable Finding Considered a Significant Deficiency – Inclusion of Unallowable Costs in the SEFA Program Name: STEM Education Assistance Listing #: 47.076 Program Year: 2024 Federal Awarding Agency: National Science Foundation Compliance Requirement: SEFA Preparation Criteria: According to 2 CFR Part 200, Subpart F, §200.510(b), the auditee must prepare a SEFA for the period covered by the auditee's financial statements which must include the total Federal awards expen...

Finding 2024-001: Reportable Finding Considered a Significant Deficiency – Inclusion of Unallowable Costs in the SEFA Program Name: STEM Education Assistance Listing #: 47.076 Program Year: 2024 Federal Awarding Agency: National Science Foundation Compliance Requirement: SEFA Preparation Criteria: According to 2 CFR Part 200, Subpart F, §200.510(b), the auditee must prepare a 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. The SEFA must also include the CFDA number, the name of the Federal program, and the total amount expended. Condition: During our allowable cost testing, four exceptions were noted out of 15 selections. The first exception involved a transaction that included an estimated expense exceeding the actual cost incurred and falling outside the grant’s period of allowability. The other 3 exceptions pertained to an expense related to a future fiscal year, which had not yet been incurred at the time of recognition and was outside the grant’s period of performance. The client did not request reimbursement for these expenditures and subsequently removed them from the general ledger in 2024. However, the removal of these expenses was not properly reflected on the SEFA schedule. Cause: The improper preparation of the SEFA schedule was due to inadequate internal controls over financial reporting and lack of proper training for staff responsible for reporting the SEFA expenditures. Additionally, there was insufficient review and oversight of the SEFA preparation process. Effect: A total of $19,374 of expenses were incorrectly included in the SEFA. Failure to remove these expenses from the SEFA misrepresented the total amount of federal assistance expanded and may impair the usefulness of the SEFA for the oversight federal agency. Questioned Costs: None. Repeat finding: This is not a repeat finding. Recommendation: We recommend the Organization revise its SEFA preparation procedures to ensure that only allowable and reimbursable expenditures of federal awards are reported. Management should provide additional training to staff responsible for SEFA preparation and implement a formal review process to verify the accuracy of SEFA amounts. Views of Responsible Officials and Planned Corrective Action (unaudited): See Corrective Action Plan.

FY End: 2024-12-31
Council of Graduate Schools
Compliance Requirement: B
Finding 2024-001: Reportable Finding Considered a Significant Deficiency – Inclusion of Unallowable Costs in the SEFA Program Name: STEM Education Assistance Listing #: 47.076 Program Year: 2024 Federal Awarding Agency: National Science Foundation Compliance Requirement: SEFA Preparation Criteria: According to 2 CFR Part 200, Subpart F, §200.510(b), the auditee must prepare a SEFA for the period covered by the auditee's financial statements which must include the total Federal awards expen...

Finding 2024-001: Reportable Finding Considered a Significant Deficiency – Inclusion of Unallowable Costs in the SEFA Program Name: STEM Education Assistance Listing #: 47.076 Program Year: 2024 Federal Awarding Agency: National Science Foundation Compliance Requirement: SEFA Preparation Criteria: According to 2 CFR Part 200, Subpart F, §200.510(b), the auditee must prepare a 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. The SEFA must also include the CFDA number, the name of the Federal program, and the total amount expended. Condition: During our allowable cost testing, four exceptions were noted out of 15 selections. The first exception involved a transaction that included an estimated expense exceeding the actual cost incurred and falling outside the grant’s period of allowability. The other 3 exceptions pertained to an expense related to a future fiscal year, which had not yet been incurred at the time of recognition and was outside the grant’s period of performance. The client did not request reimbursement for these expenditures and subsequently removed them from the general ledger in 2024. However, the removal of these expenses was not properly reflected on the SEFA schedule. Cause: The improper preparation of the SEFA schedule was due to inadequate internal controls over financial reporting and lack of proper training for staff responsible for reporting the SEFA expenditures. Additionally, there was insufficient review and oversight of the SEFA preparation process. Effect: A total of $19,374 of expenses were incorrectly included in the SEFA. Failure to remove these expenses from the SEFA misrepresented the total amount of federal assistance expanded and may impair the usefulness of the SEFA for the oversight federal agency. Questioned Costs: None. Repeat finding: This is not a repeat finding. Recommendation: We recommend the Organization revise its SEFA preparation procedures to ensure that only allowable and reimbursable expenditures of federal awards are reported. Management should provide additional training to staff responsible for SEFA preparation and implement a formal review process to verify the accuracy of SEFA amounts. Views of Responsible Officials and Planned Corrective Action (unaudited): See Corrective Action Plan.

FY End: 2024-12-31
Council of Graduate Schools
Compliance Requirement: B
Finding 2024-001: Reportable Finding Considered a Significant Deficiency – Inclusion of Unallowable Costs in the SEFA Program Name: STEM Education Assistance Listing #: 47.076 Program Year: 2024 Federal Awarding Agency: National Science Foundation Compliance Requirement: SEFA Preparation Criteria: According to 2 CFR Part 200, Subpart F, §200.510(b), the auditee must prepare a SEFA for the period covered by the auditee's financial statements which must include the total Federal awards expen...

Finding 2024-001: Reportable Finding Considered a Significant Deficiency – Inclusion of Unallowable Costs in the SEFA Program Name: STEM Education Assistance Listing #: 47.076 Program Year: 2024 Federal Awarding Agency: National Science Foundation Compliance Requirement: SEFA Preparation Criteria: According to 2 CFR Part 200, Subpart F, §200.510(b), the auditee must prepare a 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. The SEFA must also include the CFDA number, the name of the Federal program, and the total amount expended. Condition: During our allowable cost testing, four exceptions were noted out of 15 selections. The first exception involved a transaction that included an estimated expense exceeding the actual cost incurred and falling outside the grant’s period of allowability. The other 3 exceptions pertained to an expense related to a future fiscal year, which had not yet been incurred at the time of recognition and was outside the grant’s period of performance. The client did not request reimbursement for these expenditures and subsequently removed them from the general ledger in 2024. However, the removal of these expenses was not properly reflected on the SEFA schedule. Cause: The improper preparation of the SEFA schedule was due to inadequate internal controls over financial reporting and lack of proper training for staff responsible for reporting the SEFA expenditures. Additionally, there was insufficient review and oversight of the SEFA preparation process. Effect: A total of $19,374 of expenses were incorrectly included in the SEFA. Failure to remove these expenses from the SEFA misrepresented the total amount of federal assistance expanded and may impair the usefulness of the SEFA for the oversight federal agency. Questioned Costs: None. Repeat finding: This is not a repeat finding. Recommendation: We recommend the Organization revise its SEFA preparation procedures to ensure that only allowable and reimbursable expenditures of federal awards are reported. Management should provide additional training to staff responsible for SEFA preparation and implement a formal review process to verify the accuracy of SEFA amounts. Views of Responsible Officials and Planned Corrective Action (unaudited): See Corrective Action Plan.

FY End: 2024-12-31
Council of Graduate Schools
Compliance Requirement: B
Finding 2024-001: Reportable Finding Considered a Significant Deficiency – Inclusion of Unallowable Costs in the SEFA Program Name: STEM Education Assistance Listing #: 47.076 Program Year: 2024 Federal Awarding Agency: National Science Foundation Compliance Requirement: SEFA Preparation Criteria: According to 2 CFR Part 200, Subpart F, §200.510(b), the auditee must prepare a SEFA for the period covered by the auditee's financial statements which must include the total Federal awards expen...

Finding 2024-001: Reportable Finding Considered a Significant Deficiency – Inclusion of Unallowable Costs in the SEFA Program Name: STEM Education Assistance Listing #: 47.076 Program Year: 2024 Federal Awarding Agency: National Science Foundation Compliance Requirement: SEFA Preparation Criteria: According to 2 CFR Part 200, Subpart F, §200.510(b), the auditee must prepare a 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. The SEFA must also include the CFDA number, the name of the Federal program, and the total amount expended. Condition: During our allowable cost testing, four exceptions were noted out of 15 selections. The first exception involved a transaction that included an estimated expense exceeding the actual cost incurred and falling outside the grant’s period of allowability. The other 3 exceptions pertained to an expense related to a future fiscal year, which had not yet been incurred at the time of recognition and was outside the grant’s period of performance. The client did not request reimbursement for these expenditures and subsequently removed them from the general ledger in 2024. However, the removal of these expenses was not properly reflected on the SEFA schedule. Cause: The improper preparation of the SEFA schedule was due to inadequate internal controls over financial reporting and lack of proper training for staff responsible for reporting the SEFA expenditures. Additionally, there was insufficient review and oversight of the SEFA preparation process. Effect: A total of $19,374 of expenses were incorrectly included in the SEFA. Failure to remove these expenses from the SEFA misrepresented the total amount of federal assistance expanded and may impair the usefulness of the SEFA for the oversight federal agency. Questioned Costs: None. Repeat finding: This is not a repeat finding. Recommendation: We recommend the Organization revise its SEFA preparation procedures to ensure that only allowable and reimbursable expenditures of federal awards are reported. Management should provide additional training to staff responsible for SEFA preparation and implement a formal review process to verify the accuracy of SEFA amounts. Views of Responsible Officials and Planned Corrective Action (unaudited): See Corrective Action Plan.

FY End: 2024-12-31
Council of Graduate Schools
Compliance Requirement: B
Finding 2024-001: Reportable Finding Considered a Significant Deficiency – Inclusion of Unallowable Costs in the SEFA Program Name: STEM Education Assistance Listing #: 47.076 Program Year: 2024 Federal Awarding Agency: National Science Foundation Compliance Requirement: SEFA Preparation Criteria: According to 2 CFR Part 200, Subpart F, §200.510(b), the auditee must prepare a SEFA for the period covered by the auditee's financial statements which must include the total Federal awards expen...

Finding 2024-001: Reportable Finding Considered a Significant Deficiency – Inclusion of Unallowable Costs in the SEFA Program Name: STEM Education Assistance Listing #: 47.076 Program Year: 2024 Federal Awarding Agency: National Science Foundation Compliance Requirement: SEFA Preparation Criteria: According to 2 CFR Part 200, Subpart F, §200.510(b), the auditee must prepare a 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. The SEFA must also include the CFDA number, the name of the Federal program, and the total amount expended. Condition: During our allowable cost testing, four exceptions were noted out of 15 selections. The first exception involved a transaction that included an estimated expense exceeding the actual cost incurred and falling outside the grant’s period of allowability. The other 3 exceptions pertained to an expense related to a future fiscal year, which had not yet been incurred at the time of recognition and was outside the grant’s period of performance. The client did not request reimbursement for these expenditures and subsequently removed them from the general ledger in 2024. However, the removal of these expenses was not properly reflected on the SEFA schedule. Cause: The improper preparation of the SEFA schedule was due to inadequate internal controls over financial reporting and lack of proper training for staff responsible for reporting the SEFA expenditures. Additionally, there was insufficient review and oversight of the SEFA preparation process. Effect: A total of $19,374 of expenses were incorrectly included in the SEFA. Failure to remove these expenses from the SEFA misrepresented the total amount of federal assistance expanded and may impair the usefulness of the SEFA for the oversight federal agency. Questioned Costs: None. Repeat finding: This is not a repeat finding. Recommendation: We recommend the Organization revise its SEFA preparation procedures to ensure that only allowable and reimbursable expenditures of federal awards are reported. Management should provide additional training to staff responsible for SEFA preparation and implement a formal review process to verify the accuracy of SEFA amounts. Views of Responsible Officials and Planned Corrective Action (unaudited): See Corrective Action Plan.

FY End: 2024-12-31
Council of Graduate Schools
Compliance Requirement: B
Finding 2024-001: Reportable Finding Considered a Significant Deficiency – Inclusion of Unallowable Costs in the SEFA Program Name: STEM Education Assistance Listing #: 47.076 Program Year: 2024 Federal Awarding Agency: National Science Foundation Compliance Requirement: SEFA Preparation Criteria: According to 2 CFR Part 200, Subpart F, §200.510(b), the auditee must prepare a SEFA for the period covered by the auditee's financial statements which must include the total Federal awards expen...

Finding 2024-001: Reportable Finding Considered a Significant Deficiency – Inclusion of Unallowable Costs in the SEFA Program Name: STEM Education Assistance Listing #: 47.076 Program Year: 2024 Federal Awarding Agency: National Science Foundation Compliance Requirement: SEFA Preparation Criteria: According to 2 CFR Part 200, Subpart F, §200.510(b), the auditee must prepare a 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. The SEFA must also include the CFDA number, the name of the Federal program, and the total amount expended. Condition: During our allowable cost testing, four exceptions were noted out of 15 selections. The first exception involved a transaction that included an estimated expense exceeding the actual cost incurred and falling outside the grant’s period of allowability. The other 3 exceptions pertained to an expense related to a future fiscal year, which had not yet been incurred at the time of recognition and was outside the grant’s period of performance. The client did not request reimbursement for these expenditures and subsequently removed them from the general ledger in 2024. However, the removal of these expenses was not properly reflected on the SEFA schedule. Cause: The improper preparation of the SEFA schedule was due to inadequate internal controls over financial reporting and lack of proper training for staff responsible for reporting the SEFA expenditures. Additionally, there was insufficient review and oversight of the SEFA preparation process. Effect: A total of $19,374 of expenses were incorrectly included in the SEFA. Failure to remove these expenses from the SEFA misrepresented the total amount of federal assistance expanded and may impair the usefulness of the SEFA for the oversight federal agency. Questioned Costs: None. Repeat finding: This is not a repeat finding. Recommendation: We recommend the Organization revise its SEFA preparation procedures to ensure that only allowable and reimbursable expenditures of federal awards are reported. Management should provide additional training to staff responsible for SEFA preparation and implement a formal review process to verify the accuracy of SEFA amounts. Views of Responsible Officials and Planned Corrective Action (unaudited): See Corrective Action Plan.

FY End: 2024-12-31
Central California Irrigation District
Compliance Requirement: P
Finding 2024-002 – Significant Deficiency Award No.: Assistance List No. 15.555 and No. 15.074 Federal Grantor: U.S. Department of the Interior, Bureau of Reclamation, AL No. 15.074 Passed- Through the Del Puerto Water District Compliance Requirement: Other compliance requirements. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was not complete, and expenditures reported on the SEFA were revised during the single audit. Criteria: 2 CFR Part 200, Subpart F (Uniform Guidan...

Finding 2024-002 – Significant Deficiency Award No.: Assistance List No. 15.555 and No. 15.074 Federal Grantor: U.S. Department of the Interior, Bureau of Reclamation, AL No. 15.074 Passed- Through the Del Puerto Water District Compliance Requirement: Other compliance requirements. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was not complete, and expenditures reported on the SEFA were revised during the single audit. Criteria: 2 CFR Part 200, Subpart F (Uniform Guidance) Section 200.502 states, “The auditee should prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee’s financial statements.” Internal controls over preparation of the SEFA should be in place to ensure accrual basis expenses incurred under each federal program are properly reported as expenses on the SEFA and are properly reported as revenue in the financial statements prior to the start of the single audit. Cause: SEFA was not fully reconciled and finalized until after the single audit began. Effect: Expenses were omitted from the SEFA that should have been included and other expenses were included on the SEFA that were not eligible. The SEFA had to be revised for multiple grants over the course of the audit. This delayed the audit testing and major program determination process and could have resulted in the wrong programs being tested as major programs and the single audit not complying with the Uniform Guidance. Context: The District’s Finance Department was not informed of grant amendments that changed the amount of federal funding available. The expenses reported on the SEFA were revised during the single audit as follows. • AL No. 15.555 San Joaquin River Restoration Program Poso Canal Bridge Replacement: The District estimated additional reimbursable costs of $30,335 existed for the Poso Canal Bridge Replacement grant under a potential new $990,000 grant amendment that was to be signed by the USBR in 2025. The amendment was not approved for the Poso Canal Bridge Replacement but the District included the additional reimbursable expenses on the SEFA. The expenses on the SEFA had to be reduced to reflect the eligible federal grant maximum reimbursable expenses under the approved grant agreement at year-end. • AL No. 15.704 Small Surface Water and Groundwater Storage Projects Orestimba Creek Recharge and Recovery Expansion: An additional grant amendment was identified during the single audit that authorized an additional $1,262,928 of federal funding. The District had eligible expenses during the period of performance to fully claim the additional funding, but did not include the expenses on the SEFA. Recommendation: We recommend additional review procedures be implemented to ensure the SEFA is complete and accurate when the single audit begins, which includes working with program managers to identify each grant awarded, obtain current executed grant agreements and amendments, reconciling all expenses incurred under each federal awards down to the invoice, payroll check and lowest level of any other costs claimed, cutting-off each expense at year-end and claiming the reconciled qualifying expenses within 45 days after quarter end. At year-end, programs should be reviewed for cost adjustments, extensions, and other changes that should be reflected on the SEFA when reconciling expenses for the SEFA. Separate general ledger program codes should be used for each grant on the SEFA that summarizes expenses down to the individual invoice level that should be provided to the auditor for the single audit. If overclaimed amounts are identified, the grantor and/or pass-through agency should be contacted to determine whether to return the funds or apply the overclaimed amounts to future claims. Views of Responsible Officials and Planned Corrective Actions: Management’s response and planned corrective action is included in the Corrective Action Plan included at the end of the report.

FY End: 2024-12-31
Central California Irrigation District
Compliance Requirement: P
Finding 2024-002 – Significant Deficiency Award No.: Assistance List No. 15.555 and No. 15.074 Federal Grantor: U.S. Department of the Interior, Bureau of Reclamation, AL No. 15.074 Passed- Through the Del Puerto Water District Compliance Requirement: Other compliance requirements. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was not complete, and expenditures reported on the SEFA were revised during the single audit. Criteria: 2 CFR Part 200, Subpart F (Uniform Guidan...

Finding 2024-002 – Significant Deficiency Award No.: Assistance List No. 15.555 and No. 15.074 Federal Grantor: U.S. Department of the Interior, Bureau of Reclamation, AL No. 15.074 Passed- Through the Del Puerto Water District Compliance Requirement: Other compliance requirements. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was not complete, and expenditures reported on the SEFA were revised during the single audit. Criteria: 2 CFR Part 200, Subpart F (Uniform Guidance) Section 200.502 states, “The auditee should prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee’s financial statements.” Internal controls over preparation of the SEFA should be in place to ensure accrual basis expenses incurred under each federal program are properly reported as expenses on the SEFA and are properly reported as revenue in the financial statements prior to the start of the single audit. Cause: SEFA was not fully reconciled and finalized until after the single audit began. Effect: Expenses were omitted from the SEFA that should have been included and other expenses were included on the SEFA that were not eligible. The SEFA had to be revised for multiple grants over the course of the audit. This delayed the audit testing and major program determination process and could have resulted in the wrong programs being tested as major programs and the single audit not complying with the Uniform Guidance. Context: The District’s Finance Department was not informed of grant amendments that changed the amount of federal funding available. The expenses reported on the SEFA were revised during the single audit as follows. • AL No. 15.555 San Joaquin River Restoration Program Poso Canal Bridge Replacement: The District estimated additional reimbursable costs of $30,335 existed for the Poso Canal Bridge Replacement grant under a potential new $990,000 grant amendment that was to be signed by the USBR in 2025. The amendment was not approved for the Poso Canal Bridge Replacement but the District included the additional reimbursable expenses on the SEFA. The expenses on the SEFA had to be reduced to reflect the eligible federal grant maximum reimbursable expenses under the approved grant agreement at year-end. • AL No. 15.704 Small Surface Water and Groundwater Storage Projects Orestimba Creek Recharge and Recovery Expansion: An additional grant amendment was identified during the single audit that authorized an additional $1,262,928 of federal funding. The District had eligible expenses during the period of performance to fully claim the additional funding, but did not include the expenses on the SEFA. Recommendation: We recommend additional review procedures be implemented to ensure the SEFA is complete and accurate when the single audit begins, which includes working with program managers to identify each grant awarded, obtain current executed grant agreements and amendments, reconciling all expenses incurred under each federal awards down to the invoice, payroll check and lowest level of any other costs claimed, cutting-off each expense at year-end and claiming the reconciled qualifying expenses within 45 days after quarter end. At year-end, programs should be reviewed for cost adjustments, extensions, and other changes that should be reflected on the SEFA when reconciling expenses for the SEFA. Separate general ledger program codes should be used for each grant on the SEFA that summarizes expenses down to the individual invoice level that should be provided to the auditor for the single audit. If overclaimed amounts are identified, the grantor and/or pass-through agency should be contacted to determine whether to return the funds or apply the overclaimed amounts to future claims. Views of Responsible Officials and Planned Corrective Actions: Management’s response and planned corrective action is included in the Corrective Action Plan included at the end of the report.

FY End: 2024-12-31
Parkview Services
Compliance Requirement: L
Identification as a Repeat Finding: No Finding: The Organization omitted the COVID-19 Economic Injury Disaster Assistance Loan (EIDL) from the initial draft of the SEFA presented to auditors. Criteria: 2 CFR 200.502 requires the auditee to report federal awards expended under loan programs including the balance of loans from previous years at the beginning of the audit period for which the Federal Government imposes continuing compliance requirements. The EIDL loan requires annual reporting to t...

Identification as a Repeat Finding: No Finding: The Organization omitted the COVID-19 Economic Injury Disaster Assistance Loan (EIDL) from the initial draft of the SEFA presented to auditors. Criteria: 2 CFR 200.502 requires the auditee to report federal awards expended under loan programs including the balance of loans from previous years at the beginning of the audit period for which the Federal Government imposes continuing compliance requirements. The EIDL loan requires annual reporting to the Small Business Administration (SBA) as noted in prior year Finding 2023-002. Sample Size and Population: Not applicable Condition and Context: The EIDL loan totaling $584,853 was omitted from the draft SEFA provided to auditors on May 15, 2025. Effect: Exclusion understated total federal awards by 8%, changing the preliminary major-program determination and potentially reducing audit coverage below the required 40% threshold. Cause: The Organization did not identify ongoing compliance requirements associated with the EIDL loan. Management relied on SBA guidance that addresses PPP loans and other SBA programs but do not mention COVID-19 Relief EIDL programs, indicating a training gap in award-specific requirements. Recommendations: We recommend the Organization review loan agreements and program specific guidance for continuing compliance requirements before removing federal loans from the SEFA. Questioned Costs: None Management Response: Management response is reported in the “Corrective Action Plan” at the end of this report. Contact Person: Marc Cote, Executive Director 206-542-6644

FY End: 2024-12-31
City of Fort Collins, Colorado
Compliance Requirement: L
Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.20...

Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.205: Colorado Department of Transportation - ALN 21.027: N/A Finding Type - Material weakness Repeat Finding - Yes 2023-003 Criteria - According to 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. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Condition - The fiscal year 2024 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal years 2023 and 2025. 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 - Within Highway Planning and Construction, the expenditures reported on the initial SEFA included $142,724 that related to expenditures incurred in fiscal year 2023. There was also $16,128 that related to expenditures incurred in fiscal year 2024 that was not reported on the initial SEFA. Within Coronavirus State and Local Fiscal Recovery Funds, the expenditures reported on the initial SEFA included $15,921 that related to expenditures incurred in fiscal year 2023 and $99,200 that related to expenditures incurred in fiscal year 2025. Cause and Effect - The City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Recommendation - The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan - The City of Fort Collins, Colorado has determined that two separate and identifiable root causes led to the inclusion of expenditures from fiscal years 2023 and 2025 in the initial fiscal year 2024 SEFA. 1. Improper Accrual of Prepayments: A small number of transactions involving partial prepayments were not properly accrued in accordance with accounting standards. To address this issue, the City will implement a formal review process where all reimbursement requests are reviewed by the grant accountant prior to submission. This review will include a targeted examination of expenditure listings to identify and ensure appropriate treatment of any transactions requiring accrual as prepayments. 2. Inconsistencies Between Reimbursement Packets and the General Ledger: For the Highway Planning and Construction Cluster, the SEFA preparation process previously relied on reimbursement request packets compiled by departmental staff. In some cases, these packets did not accurately reflect the timing of expenditures recorded in the general ledger. To enhance accuracy, the City will implement a reconciliation procedure requiring the grant accountant to cross-reference reimbursement packet data with the general ledger during SEFA preparation. This step will help ensure that all expenditures are properly reported in the appropriate fiscal year. The City is confident that these corrective actions will strengthen internal controls over SEFA preparation and prevent recurrence of similar issues in future reporting periods.

FY End: 2024-12-31
City of Fort Collins, Colorado
Compliance Requirement: L
Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.20...

Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.205: Colorado Department of Transportation - ALN 21.027: N/A Finding Type - Material weakness Repeat Finding - Yes 2023-003 Criteria - According to 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. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Condition - The fiscal year 2024 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal years 2023 and 2025. 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 - Within Highway Planning and Construction, the expenditures reported on the initial SEFA included $142,724 that related to expenditures incurred in fiscal year 2023. There was also $16,128 that related to expenditures incurred in fiscal year 2024 that was not reported on the initial SEFA. Within Coronavirus State and Local Fiscal Recovery Funds, the expenditures reported on the initial SEFA included $15,921 that related to expenditures incurred in fiscal year 2023 and $99,200 that related to expenditures incurred in fiscal year 2025. Cause and Effect - The City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Recommendation - The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan - The City of Fort Collins, Colorado has determined that two separate and identifiable root causes led to the inclusion of expenditures from fiscal years 2023 and 2025 in the initial fiscal year 2024 SEFA. 1. Improper Accrual of Prepayments: A small number of transactions involving partial prepayments were not properly accrued in accordance with accounting standards. To address this issue, the City will implement a formal review process where all reimbursement requests are reviewed by the grant accountant prior to submission. This review will include a targeted examination of expenditure listings to identify and ensure appropriate treatment of any transactions requiring accrual as prepayments. 2. Inconsistencies Between Reimbursement Packets and the General Ledger: For the Highway Planning and Construction Cluster, the SEFA preparation process previously relied on reimbursement request packets compiled by departmental staff. In some cases, these packets did not accurately reflect the timing of expenditures recorded in the general ledger. To enhance accuracy, the City will implement a reconciliation procedure requiring the grant accountant to cross-reference reimbursement packet data with the general ledger during SEFA preparation. This step will help ensure that all expenditures are properly reported in the appropriate fiscal year. The City is confident that these corrective actions will strengthen internal controls over SEFA preparation and prevent recurrence of similar issues in future reporting periods.

FY End: 2024-12-31
City of Fort Collins, Colorado
Compliance Requirement: L
Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.20...

Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.205: Colorado Department of Transportation - ALN 21.027: N/A Finding Type - Material weakness Repeat Finding - Yes 2023-003 Criteria - According to 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. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Condition - The fiscal year 2024 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal years 2023 and 2025. 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 - Within Highway Planning and Construction, the expenditures reported on the initial SEFA included $142,724 that related to expenditures incurred in fiscal year 2023. There was also $16,128 that related to expenditures incurred in fiscal year 2024 that was not reported on the initial SEFA. Within Coronavirus State and Local Fiscal Recovery Funds, the expenditures reported on the initial SEFA included $15,921 that related to expenditures incurred in fiscal year 2023 and $99,200 that related to expenditures incurred in fiscal year 2025. Cause and Effect - The City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Recommendation - The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan - The City of Fort Collins, Colorado has determined that two separate and identifiable root causes led to the inclusion of expenditures from fiscal years 2023 and 2025 in the initial fiscal year 2024 SEFA. 1. Improper Accrual of Prepayments: A small number of transactions involving partial prepayments were not properly accrued in accordance with accounting standards. To address this issue, the City will implement a formal review process where all reimbursement requests are reviewed by the grant accountant prior to submission. This review will include a targeted examination of expenditure listings to identify and ensure appropriate treatment of any transactions requiring accrual as prepayments. 2. Inconsistencies Between Reimbursement Packets and the General Ledger: For the Highway Planning and Construction Cluster, the SEFA preparation process previously relied on reimbursement request packets compiled by departmental staff. In some cases, these packets did not accurately reflect the timing of expenditures recorded in the general ledger. To enhance accuracy, the City will implement a reconciliation procedure requiring the grant accountant to cross-reference reimbursement packet data with the general ledger during SEFA preparation. This step will help ensure that all expenditures are properly reported in the appropriate fiscal year. The City is confident that these corrective actions will strengthen internal controls over SEFA preparation and prevent recurrence of similar issues in future reporting periods.

FY End: 2024-12-31
City of Fort Collins, Colorado
Compliance Requirement: L
Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.20...

Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.205: Colorado Department of Transportation - ALN 21.027: N/A Finding Type - Material weakness Repeat Finding - Yes 2023-003 Criteria - According to 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. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Condition - The fiscal year 2024 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal years 2023 and 2025. 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 - Within Highway Planning and Construction, the expenditures reported on the initial SEFA included $142,724 that related to expenditures incurred in fiscal year 2023. There was also $16,128 that related to expenditures incurred in fiscal year 2024 that was not reported on the initial SEFA. Within Coronavirus State and Local Fiscal Recovery Funds, the expenditures reported on the initial SEFA included $15,921 that related to expenditures incurred in fiscal year 2023 and $99,200 that related to expenditures incurred in fiscal year 2025. Cause and Effect - The City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Recommendation - The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan - The City of Fort Collins, Colorado has determined that two separate and identifiable root causes led to the inclusion of expenditures from fiscal years 2023 and 2025 in the initial fiscal year 2024 SEFA. 1. Improper Accrual of Prepayments: A small number of transactions involving partial prepayments were not properly accrued in accordance with accounting standards. To address this issue, the City will implement a formal review process where all reimbursement requests are reviewed by the grant accountant prior to submission. This review will include a targeted examination of expenditure listings to identify and ensure appropriate treatment of any transactions requiring accrual as prepayments. 2. Inconsistencies Between Reimbursement Packets and the General Ledger: For the Highway Planning and Construction Cluster, the SEFA preparation process previously relied on reimbursement request packets compiled by departmental staff. In some cases, these packets did not accurately reflect the timing of expenditures recorded in the general ledger. To enhance accuracy, the City will implement a reconciliation procedure requiring the grant accountant to cross-reference reimbursement packet data with the general ledger during SEFA preparation. This step will help ensure that all expenditures are properly reported in the appropriate fiscal year. The City is confident that these corrective actions will strengthen internal controls over SEFA preparation and prevent recurrence of similar issues in future reporting periods.

FY End: 2024-12-31
City of Fort Collins, Colorado
Compliance Requirement: L
Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.20...

Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.205: Colorado Department of Transportation - ALN 21.027: N/A Finding Type - Material weakness Repeat Finding - Yes 2023-003 Criteria - According to 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. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Condition - The fiscal year 2024 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal years 2023 and 2025. 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 - Within Highway Planning and Construction, the expenditures reported on the initial SEFA included $142,724 that related to expenditures incurred in fiscal year 2023. There was also $16,128 that related to expenditures incurred in fiscal year 2024 that was not reported on the initial SEFA. Within Coronavirus State and Local Fiscal Recovery Funds, the expenditures reported on the initial SEFA included $15,921 that related to expenditures incurred in fiscal year 2023 and $99,200 that related to expenditures incurred in fiscal year 2025. Cause and Effect - The City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Recommendation - The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan - The City of Fort Collins, Colorado has determined that two separate and identifiable root causes led to the inclusion of expenditures from fiscal years 2023 and 2025 in the initial fiscal year 2024 SEFA. 1. Improper Accrual of Prepayments: A small number of transactions involving partial prepayments were not properly accrued in accordance with accounting standards. To address this issue, the City will implement a formal review process where all reimbursement requests are reviewed by the grant accountant prior to submission. This review will include a targeted examination of expenditure listings to identify and ensure appropriate treatment of any transactions requiring accrual as prepayments. 2. Inconsistencies Between Reimbursement Packets and the General Ledger: For the Highway Planning and Construction Cluster, the SEFA preparation process previously relied on reimbursement request packets compiled by departmental staff. In some cases, these packets did not accurately reflect the timing of expenditures recorded in the general ledger. To enhance accuracy, the City will implement a reconciliation procedure requiring the grant accountant to cross-reference reimbursement packet data with the general ledger during SEFA preparation. This step will help ensure that all expenditures are properly reported in the appropriate fiscal year. The City is confident that these corrective actions will strengthen internal controls over SEFA preparation and prevent recurrence of similar issues in future reporting periods.

FY End: 2024-12-31
City of Fort Collins, Colorado
Compliance Requirement: L
Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.20...

Assistance Listing Number, Federal Agency, and Program Name - ALN 20.205, Department of Transportation, Highway Planning and Construction - ALN 21.027, Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 20.205: SHO M455- 136 (2024), STU M455-129 (2024), STU 2873-215 (2024), CRP M455-164 (2024), SHO M455-137 (2024), SHO M455-135 (2024), and STU M455-125 (2024) - ALN 21.027: N/A Pass-through Entity - ALN 20.205: Colorado Department of Transportation - ALN 21.027: N/A Finding Type - Material weakness Repeat Finding - Yes 2023-003 Criteria - According to 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. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Condition - The fiscal year 2024 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal years 2023 and 2025. 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 - Within Highway Planning and Construction, the expenditures reported on the initial SEFA included $142,724 that related to expenditures incurred in fiscal year 2023. There was also $16,128 that related to expenditures incurred in fiscal year 2024 that was not reported on the initial SEFA. Within Coronavirus State and Local Fiscal Recovery Funds, the expenditures reported on the initial SEFA included $15,921 that related to expenditures incurred in fiscal year 2023 and $99,200 that related to expenditures incurred in fiscal year 2025. Cause and Effect - The City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Recommendation - The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan - The City of Fort Collins, Colorado has determined that two separate and identifiable root causes led to the inclusion of expenditures from fiscal years 2023 and 2025 in the initial fiscal year 2024 SEFA. 1. Improper Accrual of Prepayments: A small number of transactions involving partial prepayments were not properly accrued in accordance with accounting standards. To address this issue, the City will implement a formal review process where all reimbursement requests are reviewed by the grant accountant prior to submission. This review will include a targeted examination of expenditure listings to identify and ensure appropriate treatment of any transactions requiring accrual as prepayments. 2. Inconsistencies Between Reimbursement Packets and the General Ledger: For the Highway Planning and Construction Cluster, the SEFA preparation process previously relied on reimbursement request packets compiled by departmental staff. In some cases, these packets did not accurately reflect the timing of expenditures recorded in the general ledger. To enhance accuracy, the City will implement a reconciliation procedure requiring the grant accountant to cross-reference reimbursement packet data with the general ledger during SEFA preparation. This step will help ensure that all expenditures are properly reported in the appropriate fiscal year. The City is confident that these corrective actions will strengthen internal controls over SEFA preparation and prevent recurrence of similar issues in future reporting periods.

FY End: 2024-12-31
City of Loveland
Compliance Requirement: L
Assistance Listing, Federal Agency, and Program Name - 20.205, U.S. Department of Transportation, Highway Planning and Construction; 15.916, U.S. Department of the Interior, Outdoor Recreation, Acquisition, Development and Planning Federal Award Identification Number and Year - FAINs not available Pass through Entity - ALN 20.205 Colorado Department of Transportiation; ALN 15.916 Colorado Parks and Wildlife/Land and Water Conservation Fund Finding Type - Material weakness Repeat Finding ...

Assistance Listing, Federal Agency, and Program Name - 20.205, U.S. Department of Transportation, Highway Planning and Construction; 15.916, U.S. Department of the Interior, Outdoor Recreation, Acquisition, Development and Planning Federal Award Identification Number and Year - FAINs not available Pass through Entity - ALN 20.205 Colorado Department of Transportiation; ALN 15.916 Colorado Parks and Wildlife/Land and Water Conservation Fund Finding Type - Material weakness Repeat Finding - No Criteria - The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of federal awards, in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition - The schedule of expenditures of federal awards (the "SEFA") was not accurate. Questioned Costs - None If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported - Not applicable Identification of How Questioned Costs Were Computed - Not applicable Context - During the fiscal year ended December 31, 2024, the City expended approximately $22,617,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 20.205 The expenditures reported on the SEFA were overstated by $19,522 for one award and understated by $145,869 for another award. ALN 15.916 The expenditures reported on the SEFA were overstated by $45,915 The errors noted above have been corrected on the SEFA as of December 31, 2024. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the understatement of federal expenditures. Recommendation - We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - The City accepts this finding. As part of the revision to the City’s grant process and procedures, we will enhance our master grant tracking spreadsheet to ensure grant expenditures are reported correctly. We will collaborate with city departments to ensure costs are recorded correctly. See the corrective action plan.

FY End: 2024-12-31
City of Loveland
Compliance Requirement: L
Assistance Listing, Federal Agency, and Program Name - 20.205, U.S. Department of Transportation, Highway Planning and Construction; 15.916, U.S. Department of the Interior, Outdoor Recreation, Acquisition, Development and Planning Federal Award Identification Number and Year - FAINs not available Pass through Entity - ALN 20.205 Colorado Department of Transportiation; ALN 15.916 Colorado Parks and Wildlife/Land and Water Conservation Fund Finding Type - Material weakness Repeat Finding ...

Assistance Listing, Federal Agency, and Program Name - 20.205, U.S. Department of Transportation, Highway Planning and Construction; 15.916, U.S. Department of the Interior, Outdoor Recreation, Acquisition, Development and Planning Federal Award Identification Number and Year - FAINs not available Pass through Entity - ALN 20.205 Colorado Department of Transportiation; ALN 15.916 Colorado Parks and Wildlife/Land and Water Conservation Fund Finding Type - Material weakness Repeat Finding - No Criteria - The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of federal awards, in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition - The schedule of expenditures of federal awards (the "SEFA") was not accurate. Questioned Costs - None If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported - Not applicable Identification of How Questioned Costs Were Computed - Not applicable Context - During the fiscal year ended December 31, 2024, the City expended approximately $22,617,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 20.205 The expenditures reported on the SEFA were overstated by $19,522 for one award and understated by $145,869 for another award. ALN 15.916 The expenditures reported on the SEFA were overstated by $45,915 The errors noted above have been corrected on the SEFA as of December 31, 2024. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the understatement of federal expenditures. Recommendation - We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - The City accepts this finding. As part of the revision to the City’s grant process and procedures, we will enhance our master grant tracking spreadsheet to ensure grant expenditures are reported correctly. We will collaborate with city departments to ensure costs are recorded correctly. See the corrective action plan.

2 3 116 »