2024-004 – Reporting Required by the Uniform Grant Guidance Finding Type. Significant Deficiency in Internal Control over Compliance and Immaterial Noncompliance (Reporting) Program. COVID-19 State and Local Fiscal Recovery Funds Cluster (CFDA# 21.027); U.S. Department of Treasury; Passed through State of Oregon Department of Administrative Services. Criteria. Non-federal entities other than states, including those operating federal programs as subrecipients of states, must follow the procurement standards set out at 2 CFR sections 200.328 through 200.329. Condition. The District did not submit quarterly reports in compliance with 2 CFR sections 200.328 through 200.329. Cause. The District did not submit quarterly reports in compliance with grant requirements as no internal controls were in place to ensure compliance was maintained. Effect. As a result of this condition, the District did not fully comply with 2 CFR Part 200. Questioned Costs. No costs have been questioned as a result of this finding. Recommendation. We recommend that the District establish internal controls associated with grant reporting requirements to ensure compliance is maintained. View of Responsible Officials. We agree with the recommendation and will develop procedures to comply with the Uniform Guidance applicable to grants
Finding 2024-003 Improper Revenue Recognition (Material Weakness) Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: Management is responsible for establishing and maintaining effective internal control over financial report-ing. Internal controls should allow management or employees in the normal course of performing their assigned func-tions to prevent or detect material misstatements in the financial reporting of all district funds. 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: During our audit, it was noted that revenue from certain grant-funded programs was not accurately recog-nized between state and federal sources. Specifically: • Some payments of federal revenue was recorded as state revenue, and some payments of state revenue was rec-orded as federal revenue. • In some cases, revenue was not recognized in the correct reporting period. This caused under recognition of current year federal revenue, and grant reimbursement to be therefore to be claimed in duplicate. Cause: Lack of clear procedures for distinguishing and recording revenue streams for blended funding sources. Internal controls to prevent, detect and correct accounting entries for grant revenues were weak or nonexistent allowing errors in reporting of revenues, overclaiming of federal revenues, and distinguishing revenue between state and federal sources. The lack of timely recognition of revenues caused the overclaiming of Title I. The accounting records were retroactively revised during the audit, for federal award and other reporting purposes. Dis-trict management did not have sufficient training or monitoring policies to recognize and correct the deficiency during the fiscal year. Effect or Potential Effect: Not accurately recording transactions timely into the general ledger, may result in transac-tions not being properly reported in the district’s financial statements and the ability to rely on the general ledger for correct and timely information. This may cause misstatement of financial statements, and inappropriate reporting of federal awards. Questioned Cost: No Context: Due to improper recording of financial activity, Title I grant revenues were overclaimed, and general ledger required adjustment for proper state and federal presentation of grant revenues for National School Lunch Program. Repeat of a Prior-Year Finding: No. Recommendation: We recommend that Willamina School District implement accounting staff training programs, and implement a standardized revenue recognition policy that clearly distinguishes between state and federal funding sources. Additionally, we recommend that a reconciliation process be established to ensure all federal, state and matching funds are recorded timely and accurately. District's Response: The District concurs with the recommendation. Corrective Action Plan: The District will provide training for staff in order to devise and implement appropriate poli-cies and procedures for accurately recording all financial transactions, including federal award revenues and expendi-tures. Additional internal control policies will be adopted and procedures implemented as on-going improvement efforts are made. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager
Finding 2024-003 Improper Revenue Recognition (Material Weakness) Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: Management is responsible for establishing and maintaining effective internal control over financial report-ing. Internal controls should allow management or employees in the normal course of performing their assigned func-tions to prevent or detect material misstatements in the financial reporting of all district funds. 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: During our audit, it was noted that revenue from certain grant-funded programs was not accurately recog-nized between state and federal sources. Specifically: • Some payments of federal revenue was recorded as state revenue, and some payments of state revenue was rec-orded as federal revenue. • In some cases, revenue was not recognized in the correct reporting period. This caused under recognition of current year federal revenue, and grant reimbursement to be therefore to be claimed in duplicate. Cause: Lack of clear procedures for distinguishing and recording revenue streams for blended funding sources. Internal controls to prevent, detect and correct accounting entries for grant revenues were weak or nonexistent allowing errors in reporting of revenues, overclaiming of federal revenues, and distinguishing revenue between state and federal sources. The lack of timely recognition of revenues caused the overclaiming of Title I. The accounting records were retroactively revised during the audit, for federal award and other reporting purposes. Dis-trict management did not have sufficient training or monitoring policies to recognize and correct the deficiency during the fiscal year. Effect or Potential Effect: Not accurately recording transactions timely into the general ledger, may result in transac-tions not being properly reported in the district’s financial statements and the ability to rely on the general ledger for correct and timely information. This may cause misstatement of financial statements, and inappropriate reporting of federal awards. Questioned Cost: No Context: Due to improper recording of financial activity, Title I grant revenues were overclaimed, and general ledger required adjustment for proper state and federal presentation of grant revenues for National School Lunch Program. Repeat of a Prior-Year Finding: No. Recommendation: We recommend that Willamina School District implement accounting staff training programs, and implement a standardized revenue recognition policy that clearly distinguishes between state and federal funding sources. Additionally, we recommend that a reconciliation process be established to ensure all federal, state and matching funds are recorded timely and accurately. District's Response: The District concurs with the recommendation. Corrective Action Plan: The District will provide training for staff in order to devise and implement appropriate poli-cies and procedures for accurately recording all financial transactions, including federal award revenues and expendi-tures. Additional internal control policies will be adopted and procedures implemented as on-going improvement efforts are made. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager
Finding 2024-003 Improper Revenue Recognition (Material Weakness) Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: Management is responsible for establishing and maintaining effective internal control over financial report-ing. Internal controls should allow management or employees in the normal course of performing their assigned func-tions to prevent or detect material misstatements in the financial reporting of all district funds. 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: During our audit, it was noted that revenue from certain grant-funded programs was not accurately recog-nized between state and federal sources. Specifically: • Some payments of federal revenue was recorded as state revenue, and some payments of state revenue was rec-orded as federal revenue. • In some cases, revenue was not recognized in the correct reporting period. This caused under recognition of current year federal revenue, and grant reimbursement to be therefore to be claimed in duplicate. Cause: Lack of clear procedures for distinguishing and recording revenue streams for blended funding sources. Internal controls to prevent, detect and correct accounting entries for grant revenues were weak or nonexistent allowing errors in reporting of revenues, overclaiming of federal revenues, and distinguishing revenue between state and federal sources. The lack of timely recognition of revenues caused the overclaiming of Title I. The accounting records were retroactively revised during the audit, for federal award and other reporting purposes. Dis-trict management did not have sufficient training or monitoring policies to recognize and correct the deficiency during the fiscal year. Effect or Potential Effect: Not accurately recording transactions timely into the general ledger, may result in transac-tions not being properly reported in the district’s financial statements and the ability to rely on the general ledger for correct and timely information. This may cause misstatement of financial statements, and inappropriate reporting of federal awards. Questioned Cost: No Context: Due to improper recording of financial activity, Title I grant revenues were overclaimed, and general ledger required adjustment for proper state and federal presentation of grant revenues for National School Lunch Program. Repeat of a Prior-Year Finding: No. Recommendation: We recommend that Willamina School District implement accounting staff training programs, and implement a standardized revenue recognition policy that clearly distinguishes between state and federal funding sources. Additionally, we recommend that a reconciliation process be established to ensure all federal, state and matching funds are recorded timely and accurately. District's Response: The District concurs with the recommendation. Corrective Action Plan: The District will provide training for staff in order to devise and implement appropriate poli-cies and procedures for accurately recording all financial transactions, including federal award revenues and expendi-tures. Additional internal control policies will be adopted and procedures implemented as on-going improvement efforts are made. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager
Finding 2024-003 Improper Revenue Recognition (Material Weakness) Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: Management is responsible for establishing and maintaining effective internal control over financial report-ing. Internal controls should allow management or employees in the normal course of performing their assigned func-tions to prevent or detect material misstatements in the financial reporting of all district funds. 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: During our audit, it was noted that revenue from certain grant-funded programs was not accurately recog-nized between state and federal sources. Specifically: • Some payments of federal revenue was recorded as state revenue, and some payments of state revenue was rec-orded as federal revenue. • In some cases, revenue was not recognized in the correct reporting period. This caused under recognition of current year federal revenue, and grant reimbursement to be therefore to be claimed in duplicate. Cause: Lack of clear procedures for distinguishing and recording revenue streams for blended funding sources. Internal controls to prevent, detect and correct accounting entries for grant revenues were weak or nonexistent allowing errors in reporting of revenues, overclaiming of federal revenues, and distinguishing revenue between state and federal sources. The lack of timely recognition of revenues caused the overclaiming of Title I. The accounting records were retroactively revised during the audit, for federal award and other reporting purposes. Dis-trict management did not have sufficient training or monitoring policies to recognize and correct the deficiency during the fiscal year. Effect or Potential Effect: Not accurately recording transactions timely into the general ledger, may result in transac-tions not being properly reported in the district’s financial statements and the ability to rely on the general ledger for correct and timely information. This may cause misstatement of financial statements, and inappropriate reporting of federal awards. Questioned Cost: No Context: Due to improper recording of financial activity, Title I grant revenues were overclaimed, and general ledger required adjustment for proper state and federal presentation of grant revenues for National School Lunch Program. Repeat of a Prior-Year Finding: No. Recommendation: We recommend that Willamina School District implement accounting staff training programs, and implement a standardized revenue recognition policy that clearly distinguishes between state and federal funding sources. Additionally, we recommend that a reconciliation process be established to ensure all federal, state and matching funds are recorded timely and accurately. District's Response: The District concurs with the recommendation. Corrective Action Plan: The District will provide training for staff in order to devise and implement appropriate poli-cies and procedures for accurately recording all financial transactions, including federal award revenues and expendi-tures. Additional internal control policies will be adopted and procedures implemented as on-going improvement efforts are made. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager
Finding 2024-003 Improper Revenue Recognition (Material Weakness) Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: Management is responsible for establishing and maintaining effective internal control over financial report-ing. Internal controls should allow management or employees in the normal course of performing their assigned func-tions to prevent or detect material misstatements in the financial reporting of all district funds. 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: During our audit, it was noted that revenue from certain grant-funded programs was not accurately recog-nized between state and federal sources. Specifically: • Some payments of federal revenue was recorded as state revenue, and some payments of state revenue was rec-orded as federal revenue. • In some cases, revenue was not recognized in the correct reporting period. This caused under recognition of current year federal revenue, and grant reimbursement to be therefore to be claimed in duplicate. Cause: Lack of clear procedures for distinguishing and recording revenue streams for blended funding sources. Internal controls to prevent, detect and correct accounting entries for grant revenues were weak or nonexistent allowing errors in reporting of revenues, overclaiming of federal revenues, and distinguishing revenue between state and federal sources. The lack of timely recognition of revenues caused the overclaiming of Title I. The accounting records were retroactively revised during the audit, for federal award and other reporting purposes. Dis-trict management did not have sufficient training or monitoring policies to recognize and correct the deficiency during the fiscal year. Effect or Potential Effect: Not accurately recording transactions timely into the general ledger, may result in transac-tions not being properly reported in the district’s financial statements and the ability to rely on the general ledger for correct and timely information. This may cause misstatement of financial statements, and inappropriate reporting of federal awards. Questioned Cost: No Context: Due to improper recording of financial activity, Title I grant revenues were overclaimed, and general ledger required adjustment for proper state and federal presentation of grant revenues for National School Lunch Program. Repeat of a Prior-Year Finding: No. Recommendation: We recommend that Willamina School District implement accounting staff training programs, and implement a standardized revenue recognition policy that clearly distinguishes between state and federal funding sources. Additionally, we recommend that a reconciliation process be established to ensure all federal, state and matching funds are recorded timely and accurately. District's Response: The District concurs with the recommendation. Corrective Action Plan: The District will provide training for staff in order to devise and implement appropriate poli-cies and procedures for accurately recording all financial transactions, including federal award revenues and expendi-tures. Additional internal control policies will be adopted and procedures implemented as on-going improvement efforts are made. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager
Finding 2024-003 Improper Revenue Recognition (Material Weakness) Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: Management is responsible for establishing and maintaining effective internal control over financial report-ing. Internal controls should allow management or employees in the normal course of performing their assigned func-tions to prevent or detect material misstatements in the financial reporting of all district funds. 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: During our audit, it was noted that revenue from certain grant-funded programs was not accurately recog-nized between state and federal sources. Specifically: • Some payments of federal revenue was recorded as state revenue, and some payments of state revenue was rec-orded as federal revenue. • In some cases, revenue was not recognized in the correct reporting period. This caused under recognition of current year federal revenue, and grant reimbursement to be therefore to be claimed in duplicate. Cause: Lack of clear procedures for distinguishing and recording revenue streams for blended funding sources. Internal controls to prevent, detect and correct accounting entries for grant revenues were weak or nonexistent allowing errors in reporting of revenues, overclaiming of federal revenues, and distinguishing revenue between state and federal sources. The lack of timely recognition of revenues caused the overclaiming of Title I. The accounting records were retroactively revised during the audit, for federal award and other reporting purposes. Dis-trict management did not have sufficient training or monitoring policies to recognize and correct the deficiency during the fiscal year. Effect or Potential Effect: Not accurately recording transactions timely into the general ledger, may result in transac-tions not being properly reported in the district’s financial statements and the ability to rely on the general ledger for correct and timely information. This may cause misstatement of financial statements, and inappropriate reporting of federal awards. Questioned Cost: No Context: Due to improper recording of financial activity, Title I grant revenues were overclaimed, and general ledger required adjustment for proper state and federal presentation of grant revenues for National School Lunch Program. Repeat of a Prior-Year Finding: No. Recommendation: We recommend that Willamina School District implement accounting staff training programs, and implement a standardized revenue recognition policy that clearly distinguishes between state and federal funding sources. Additionally, we recommend that a reconciliation process be established to ensure all federal, state and matching funds are recorded timely and accurately. District's Response: The District concurs with the recommendation. Corrective Action Plan: The District will provide training for staff in order to devise and implement appropriate poli-cies and procedures for accurately recording all financial transactions, including federal award revenues and expendi-tures. Additional internal control policies will be adopted and procedures implemented as on-going improvement efforts are made. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager
2024-003 U.S. Department of the Treasury COVID-19 – Coronavirus State and Local Fiscal Recovery Funds - ALN 21.027 Significant Deficiency in Internal Controls Over Compliance Criteria: Per 2 CFR section 200.328 of the Uniform Guidance, each recipient must report program outlays and program income on a cash or accrual basis, as prescribed by the federal awarding agency. The compliance supplement identifies four Key Line Items required to be reported to the federal awarding agency which include (1) current period obligation, (2) cumulative obligation, (3) current period expenditure and (4) cumulative expenditure. An obligation is an order placed for property and services and entering into contracts, subawards, and similar transactions that require payment. Condition: As of the March 31, 2024, reporting date, the Town reported project amounts voted by the Select Board as obligated rather than purchases, contracts and agreements that met the Federal criteria of an obligation. Cause: The Town did not interpret the reporting requirements of the award properly. Effect: The Town’s reporting for obligations were overstated by approximately $520,000. Questioned Costs: None Repeat Finding from Prior Year: No Recommendation: The Town should implement procedures to reconcile the financial information in the Project and Expenditure reports to the Town’s contract and purchasing files before submission. Views of Responsible Official: Management agrees with the finding.
2024-003 U.S. Department of the Treasury COVID-19 – Coronavirus State and Local Fiscal Recovery Funds - ALN 21.027 Significant Deficiency in Internal Controls Over Compliance Criteria: Per 2 CFR section 200.328 of the Uniform Guidance, each recipient must report program outlays and program income on a cash or accrual basis, as prescribed by the federal awarding agency. The compliance supplement identifies four Key Line Items required to be reported to the federal awarding agency which include (1) current period obligation, (2) cumulative obligation, (3) current period expenditure and (4) cumulative expenditure. An obligation is an order placed for property and services and entering into contracts, subawards, and similar transactions that require payment. Condition: As of the March 31, 2024, reporting date, the Town reported project amounts voted by the Select Board as obligated rather than purchases, contracts and agreements that met the Federal criteria of an obligation. Cause: The Town did not interpret the reporting requirements of the award properly. Effect: The Town’s reporting for obligations were overstated by approximately $520,000. Questioned Costs: None Repeat Finding from Prior Year: No Recommendation: The Town should implement procedures to reconcile the financial information in the Project and Expenditure reports to the Town’s contract and purchasing files before submission. Views of Responsible Official: Management agrees with the finding.
2024-006 Improve Internal Controls and Compliance Over Reporting Federal Program(s) Information Federal Agency: Department of Transportation Award Name: National Infrastructure Investments Assistance Listing Number: 20.933 Award Year: 2024 Compliance Requirement: Reporting Federal Agency: Department of Housing and Urban Development Award Name: Lead Hazard Reduction Demonstration Grant Program Assistance Listing Number: 14.905 Award Year: 2024 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement 2 CFR 200.303 requires non-Federal entities to establish and maintain effective internal control over Federal awards to provide reasonable assurance that the City is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the award. Further, per 2 CFR 200.328 and program instructions, recipients must submit accurate, complete, and timely financial reports (such as the SF-425 Federal Financial Report) that reconcile to supporting accounting records, including the general ledger and Schedule of Expenditures of Federal Awards (SEFA). Condition and Context During our testing of two quarterly SF-425 Federal Financial Reports for both the National Infrastructure Investments program and the Lead Hazard Reduction Demonstration Grant program, we noted that the amounts reported on the reports did not agree to the amounts per the general ledger and ultimately the SEFA. The discrepancies were the result of inaccurate recording of expenditures in the general ledger based on timing as discussed in finding 2024-001, which led to inconsistent reporting on the SF-425 reports. Cause The City’s internal controls over financial reporting were not sufficient to ensure that expenditures were recorded accurately and consistently in the general ledger and SEFA and that reported amounts on the SF-425 matched the underlying accounting records. Effect or Potential Effect Inaccurate reporting of expenditures increases the risk of noncompliance with Federal reporting requirements and impairs the reliability of financial information reported to Federal agencies. No questioned costs are reported as the requirement is procedural in nature and costs reported were ultimately deemed allowable. Recommendation The City should strengthen its controls over financial reporting for Federal awards to ensure all expenditures are recorded accurately in the general ledger and SEFA and reconciled to amounts reported on the SF-425. Management should implement procedures for timely and thorough review and reconciliation of accounting records prior to the submission of required Federal reports. Views of Responsible Official Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
2024-006 Improve Internal Controls and Compliance Over Reporting Federal Program(s) Information Federal Agency: Department of Transportation Award Name: National Infrastructure Investments Assistance Listing Number: 20.933 Award Year: 2024 Compliance Requirement: Reporting Federal Agency: Department of Housing and Urban Development Award Name: Lead Hazard Reduction Demonstration Grant Program Assistance Listing Number: 14.905 Award Year: 2024 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement 2 CFR 200.303 requires non-Federal entities to establish and maintain effective internal control over Federal awards to provide reasonable assurance that the City is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the award. Further, per 2 CFR 200.328 and program instructions, recipients must submit accurate, complete, and timely financial reports (such as the SF-425 Federal Financial Report) that reconcile to supporting accounting records, including the general ledger and Schedule of Expenditures of Federal Awards (SEFA). Condition and Context During our testing of two quarterly SF-425 Federal Financial Reports for both the National Infrastructure Investments program and the Lead Hazard Reduction Demonstration Grant program, we noted that the amounts reported on the reports did not agree to the amounts per the general ledger and ultimately the SEFA. The discrepancies were the result of inaccurate recording of expenditures in the general ledger based on timing as discussed in finding 2024-001, which led to inconsistent reporting on the SF-425 reports. Cause The City’s internal controls over financial reporting were not sufficient to ensure that expenditures were recorded accurately and consistently in the general ledger and SEFA and that reported amounts on the SF-425 matched the underlying accounting records. Effect or Potential Effect Inaccurate reporting of expenditures increases the risk of noncompliance with Federal reporting requirements and impairs the reliability of financial information reported to Federal agencies. No questioned costs are reported as the requirement is procedural in nature and costs reported were ultimately deemed allowable. Recommendation The City should strengthen its controls over financial reporting for Federal awards to ensure all expenditures are recorded accurately in the general ledger and SEFA and reconciled to amounts reported on the SF-425. Management should implement procedures for timely and thorough review and reconciliation of accounting records prior to the submission of required Federal reports. Views of Responsible Official Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
Finding 2024-002 – U.S. Department of Education (USDE) Higher Education Emergency Relief Fund (HEERF) Programs (significant deficiency): Information on the Federal Programs – HEERF Historically Black Colleges and Universities (HBCU), 18004(a)(2), FAL No. 84.425J, June 30, 2024. Criteria – Federal regulations: CARES Act 18004(e), CRRSAA 314(e), 2 CFR 200.328, 2 CFR 200.329, 34 CFR 75.720(b). Condition – Non-compliance noted regarding untimely filing of quarterly and annual report. Questioned Costs – Noted within each finding below. Context – We noted the following in connection with our testing of compliance: a) Our review of the required quarterly and annual report submissions revealed the College failed to submit the annual performance report, and one (1) quarterly report was submitted untimely. Cause – Administrative oversight. Effect – Reporting deadlines were missed. Repeat Finding – No. Auditor’s Recommendation – The College should strengthen controls and oversight over grant reporting to assure that all reporting requirements are being met accurately and timely. Views of Responsible Officials – The HEERF department and reporting systems were closed, and Grants personnel were unable to retrieve a copy of the required reports from the ESF Data Collection System by the suggested deadline of May 19, 2025. A reporting calendar was implemented in August 2025 along with other policies and procedures outlined in the corrective action plan attached. All future reports will be submitted timely under this protocol.
Condition and Context Bebashi failed to maintain an accurate trial balance and general ledger to support certain account balances resulting in auditor journal entries at year-end which were material to the current year financial statements and audit delays due to support not reconciling and multiple versions of the trial balance being provided. Criteria Accounting principles generally accepted in the United States of America and Government Auditing Standards require that the design or operation of internal control over financial reporting should allow management or employees in the normal course of performing their assigned functions to prevent, or detect and correct, misstatements on a timely basis. 2 CFR 200.303 states, “The 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 statues, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance 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.” 2 CFR 200.302 states, “The financial management system of each non-Federal entity must provide for the following… accurate, current, and complete disclosure of each Federal award or program in accordance with the reporting requirements set forth in sections 200.328 and 200.329.” Cause As a result of financial constraints, and corresponding staffing challenges, the accounting and finance team at Bebashi was unable to prepare its accounting records on a timely and thorough basis. At the same time, the accounting and finance team was faced with other administrative and operational matters requiring immediate attention to help ensure Bebashi remained operational. The financial and staffing constraints resulted in lack of timely preparation and detailed review of accounting records and analysis which resulted in material audit adjustments. Effect or Potential Effect The accounting records of certain account balances and transactions provided to the auditors were inaccurate for a period of time during the fiscal year and for the year ended June 30, 2024. In certain instances, the related reconciliations and analysis were not performed on a timely basis. This caused adjustments proposed by the auditors that were material to the financial statements. Recommendation We recommend that management implements a more detailed and adequate review of the accounting records including strong processes and internal controls surrounding financial reporting. This process should identify the required accounting records and reconciliations, ensure the existence of preparer and reviewer requirements for the accounting records and reconciliations, and implement an appropriate time frame for the completion of accounting records and reconciliations. We recommend that management implements processes and procedures to identify the required financial reporting deadlines and controls to ensure compliance with the deadlines. Views of Responsible Officials Management agrees with the finding above. Management will review the existing accounting policies and procedures and implement additional steps and controls to incorporate the recommendations above. Subsequent to year-end, management of Bebashi hired a new Director of Finance. Management will review the operational resources available to further expand the finance team and do so accordingly.
2024-003 U.S. Department of the Treasury COVID-19 – Coronavirus State and Local Fiscal Recovery Funds - ALN 21.027 Material Weakness in Internal Controls Over Compliance and Compliance Finding Criteria: Per 2 CFR section 200.328 of the Uniform Guidance, each recipient must report program outlays and program income on a cash or accrual basis, as prescribed by the federal awarding agency. The compliance supplement identifies four Key Line Items required to be reported to the federal awarding agency which include (1) current period obligation, (2) cumulative obligation, (3) current period expenditure and (4) cumulative expenditure. An obligation is an order placed for property and services and entering into contracts, subawards, and similar transactions that require payment. Condition: As of the March 31, 2024, reporting date, the Town’s Project and Expenditure report had reported cumulative expenditures that were understated by approximately $148,000 and cumulative obligations were overstated by approximately $3,505,000. Additionally, the Project and Expenditure report for the period ending March 31, 2024, was not filed until March 25, 2025. Cause: The Town did not reconcile the Project and Expenditure report with the Town’s general ledger before submitting. Additionally, the Town had a lack of formal review process to make sure the report was filed in a timely manner. Effect: The Town did not properly report grant expenditures and obligations in the Project and Expenditure report that was filed nearly eleven months after the deadline. Questioned Costs: None Repeat Finding from Prior Year: No Recommendation: The Town should implement procedures to reconcile the financial information in the Project and Expenditure reports to the Town’s general ledger and contract files within a timely manner of reporting deadline. Views of Responsible Official: Management agrees with the finding.
2024-006 Performance Reporting Deadlines Compliance Requirement Reporting Category Significant Deficiency in Internal Control and Noncompliance ALN 12.607 Program Community Economic Adjustment of Establishment, Expansion, Realignment, or Closure of a Military Installation Federal Agency US Department of Defense Criteria Per 2 CFR § 200.328 and 2 CFR § 200.329, non-federal entities must submit performance and financial reports as required by the federal awarding agency or pass-through entity. These reports must be accurate, complete, and submitted timely, as outlined in the terms and conditions of the award. Condition The Authority failed to submit required federal reports in accordance with the deadlines established in the Notice of Award, with an average delay of approximately 146 days. Specifically, the Quarterly Performance Reports, Final Performance Report, and Federal Financial Report (FFR) were submitted after their respective due dates, resulting in noncompliance with federal reporting requirements. Cause The Authority did not implement adequate tracking and oversight mechanisms to ensure timely submission of required reports. This may reflect deficiencies in internal controls related to grant management and compliance monitoring. Effect Late submission of federally required reports hinders the ability of the awarding agency and pass-through entity to monitor project progress, assess financial accountability, and ensure compliance with grant terms. Continued noncompliance may result in administrative actions, including restrictions on future funding. Questioned Costs None Repeat Finding Disclosure This finding was reported in the prior year’s Single Audit and was marked as corrected. However, based on current audit procedures and documentation reviewed, the corrective action was not effectively implemented, and the condition persists. Therefore, this finding is considered repeated and unresolved. Refer to item 2022-001. Recommendation The Authority should strengthen its internal controls over grant reporting by assigning clear responsibilities for the preparation and timely submission of required reports. Additionally, relevant personnel should receive training on federal reporting requirements to ensure ongoing compliance. Views of Responsible Official (Unaudited) Refer to Corrective Action Plan
Finding 2024-003 – Internal Controls Over Reporting (Material Weakness) Condition: The City did not report accurate expenditures during the year in its Project and Expenditure Quarterly Reports for the uses of ARPA funding. The reports contained incorrect project amounts and expenditure classifications due to internal control deficiencies, including insufficient review by someone other than the preparer. Criteria: Per 2 CFR 200.302(b)(3) and 2 CFR 200.328, recipients of federal funds are required to maintain accurate financial records and report expenditures in accordance with federal award terms. Specifically, recipients of ARPA funding are required to submit accurate quarterly Project and Expenditure Reports to provide transparency and ensure funds are used in compliance with allowable purposes. Cause: The inaccuracies resulted from a lack of sufficient internal controls over the reporting process. Specifically: No independent review was performed to validate the accuracy and completeness of the quarterly reports. Documentation of the expenditure allocation process was not consistently maintained to support the reported amounts. The timing of the prior year audit limited the City’s ability to implement corrective measures before the FY2025 reports were due. Effect: The lack of accurate reporting undermines compliance with the reporting requirements of the federal award. Although no unallowable costs were identified, the inaccuracies may necessitate correction of reported amounts in the future. Recommendation: We recommend that the City strengthen its internal controls over the reporting process by: 1. Identify and correct previous reporting amounts and balances to ensure the lifetime project is properly reported. 2. Implementing a formal review process where quarterly reports are reviewed and approved by a designated individual other than the preparer. 3. Establishing a documented process for reconciling expenditures reported to the underlying accounting records and federal award guidelines. 4. Providing training to staff responsible for the preparation and review of federal compliance reports to ensure familiarity with reporting requirements. Management’s Response: See Corrective Action Plan.
Criteria or specific requirement: In accordance with 2 CFR 200.358 the recipient must submit financial reports as required by the Federal award. The grant requirements state that the recipient must submit form SF-425 on a semi-annual basis for the periods ending March 31 and September 30, or any portion thereof. 2 CFR 200.328(c) requires these semi-annual reports be submitted no later than 30 days after the reporting period. Per Uniform Guidance 2 CFR 200.303, non-federal entities receiving federal awards are required to establish and maintain internal controls designed to reasonably ensure compliance with federal laws, regulations, and program compliance requirements. Condition: The College did not submit the required SF-425 report for the period ending March 31, 2024. Questioned Costs: None. Context: During our testing of financial reports, the College was unable to provide the SF-425 report for the period ending March 31, 2024. Cause: The College was not aware that this report had not been submitted. Effect: The College was not in compliance with the Department of Commerce regulations for timely and accurate reporting of the SF-425 report. Repeat Finding: No. Recommendation: We recommend the College review its reporting procedures to ensure all reports are completed and submitted timely. Views of responsible officials: There is no disagreement with the finding.
Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: Unknown Pass-Through Agency: State of Rhode Island Department of Administration Pass-Through Number(s): Unknown Award Period: March 3, 2021 – December 31, 2026 Type of Finding: - Significant Deficiency in Internal Control over Compliance - Other Matters Criteria or specific requirement: In accordance with 2 CFR 200.328 and 31 CFR section 35.4(c), the City is required to submit quarterly “Project and Expenditure Reports” which are due 30 days after the end of each quarterly period. Condition: During our testing, we noted the City did not have adequate internal controls designed to ensure the quarterly reports were completed accurately. Questioned costs: None Context: During our testing, it was noted that the City did not accurately report the current period expenses and cumulative expenditures, or the revenue loss calculations for each of they quarterly reports. Cause: Lack of controls surrounding the preparation of quarterly reports. Effect: Failure to comply with Uniform Guidance and Treasury reporting requirements may result in questioned costs, audit findings, and potential recoupment of federal funds. Recommendation: We recommend the City implement procedures to ensure the accuracy of quarterly reporting and maintain supporting documentation for each of the amounts reported. Views of responsible officials: There is no disagreement with the audit finding.
Federal Agency: U.S. Department of Health and Human Services Federal Program Name: HIV Prevention Activities: Non-Governmental Organization Based Assistance Listing Number: 93.939 Federal Award Identification Number: NU65PS923746 Award Period: July 1, 2023 through June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance and Compliance – Reporting Criteria or specific requirement: Per 2 CFR §200.302 and §200.328, recipients of federal awards must provide accurate, current, and complete disclosure of financial results of each federally-sponsored project or program in accordance with the reporting requirements of the federal awarding agency. Condition: It was noted that the expenditures reported on the FFR matched the cash receipts for the period rather than the actual expenditures incurred. Questioned costs: $45,667 Context: During the testing of reporting compliance of the contract during the fiscal year ended 6/30/24, we identified errors in the interim Federal Financial Report (FFR) reporting during the period of 4/1/23-9/30/23 for the actual expenditures in the amount of $45,667. This overstatement in reporting of expenditures at the time of the report submission remained unspent for extended periods, contrary to federal requirements. Cause: The Organization lacked effective internal controls to reconcile actual expenditures incurred within reporting periods. The process relied on estimates and did not include timely reconciliation of actual costs. Effect: This deficiency resulted in noncompliance with federal reporting requirements. It also indicates a reasonable possibility that material noncompliance with federal requirements may not be prevented or detected and corrected on a timely basis. Repeat finding: No Recommendation: We recommend that management implement procedures to ensure that expenditures reported on the Federal Financial Report reflect actual costs incurred during the reporting period and are supported by appropriate documentation. Staff responsible for preparing the Federal Financial Report should be trained in federal reporting requirements to ensure compliance. Views of responsible officials: There is no disagreement with the audit finding. See Corrective Action Plan.
FINDING NO. 2024-005 PROGRAM REPORTS AND ACCOUNTING RECORDS Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Federal Financial Assistance Listing 14.228 Community Development Block Grants/State’s Program and Non- Entitlement Grants in Hawaii Federal Award No: B-18-DP-72-0001 Compliance Requirement: Reporting Questioned Costs: None Repeated Finding: Yes Criteria: The subrecipient agreement between the Bank and the Puerto Rico Department of Housing (PRDOH), establishes in the Terms and Conditions Part IV. Performance, Monitoring and Reporting, Section B. Reporting, that the Bank as Subrecipient shall submit regular monthly progress reports to the PRDOH, on the form and with the content to be specified and required by the PRDOH. Moreover, the subrecipient agreement between the Bank and the PRDOH, establishes in the Terms and Conditions Section Part III-Scope of Work, sub-section A. (2), that all services shall be made in accordance with PRDOH guidelines, HUD guidelines and regulations, and other applicable state and federal laws and regulations. The CDBG-DR Financial Policy of the Puerto Rico Department of Housing, (the Financial Policy), in its Part 7 Accounting Records and Systems, Section 7.1.2 Subrecipient Accounting Records, establishes that the Bank as subrecipient is responsible for ensuring that separate accounting are maintained for CDBG-DR funds in its internal accounting system and records. These records should, to the extend possible, be developed to be consistent with PRDOH CDBG-DR general accounting and recordkeeping policies. Also, the Financial Policy in its Part 13 Reconciliations, establishes that the Bank as subrecipient, must have procedures in place to reconcile accounts and reports by comparing revenues and expenditures against disbursements for CDBG- DR funded activities. The subrecipient must: Maintain in its accounting records the amounts budgeted for eligible activities. Compare actual obligations and expenditures to date against planned obligations and expenditures: and Report deviations from budget and program plans and request approval for budget and program plan revisions. The Code of Federal Regulations, 2 C.F.R., Part 200, Subpart D, Section 200.302 (b) (2), establishes that the financial management system of each non-Federal entity must provide for accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. Condition and Context: Monthly Reporting The Bank uses the Grant Compliance Portal (GCP) to submit Administrative and Performance Reports to the PRDOH. The GCP is a performance reporting system created for PRDOH to monitor regular monthly progress by the subrecipient for administrative and performance activities. The GCP is independent of other systems used for the underwriting, approval, closeout and billing of the grants to PRDOH. As such, requires the manual input of the information monthly. Once the Bank completes the information in the GCP, it is reviewed by PRDOH. Review notes related to the performance of the Bank are added before finalizing the report. The signed report by all the points of contact is kept by the Bank as evidence of compliance with the submission of the Administrative and Performance Reports by the due date. We compared the amount of grants awarded as per the Administrative and Performance Reports submitted to the PRDOH with the amount reported in the Schedule of Expenditures and Federal Awards as of June 30, 2024. We noted a difference of $25,766,191 due to grants awarded from January 2024 through June 2024 were not reflected in the Administrative and Performance Reports. This caused a discrepancy in the cumulative actual total amount of grants awarded for the year that impacts the results in the monitoring of performance by PRDOH. The Bank needs to reconcile the figures with the accounting system to confirm the information for the period is properly reflected in the Administrative and Performance Reports before the submission of the report to ensure the monitoring performed by PRDOH is based on correct and reliable information. Accounting Records and Reconciliations In relation to the CDBG-DR Fund, although disbursements are recorded in a separate fund, the Bank does not present, on a monthly basis, the revenues, expenses, assets, and liabilities in the Bank’s general ledger. Instead, the Bank is recording the transactions as revenues, expenses, assets, and liabilities related to the CDBG-DR fund at year end. The CDBG-DR fund activity is monitored in another system that is maintained parallel to the Bank’s general ledger. This additional system is used for the reporting process but is not monitored and reconciled jointly with the Bank’s general ledger. Entity level controls related to monthly approvals, reconciliations, actual versus budget comparisons, and other financial reporting controls are performed in another system that does not make automatic interface with the Bank’s general ledger. The trial balance maintained by management for internal and external reporting related to CDBG-DR funds had not been reconciled with the subsidiary records for grant expenditures, including both direct and indirect costs. Cause: The management of the Bank has not implemented effective internal control procedures that permit the proper reconciliation of the amount of grants awarded per accounting records with the amounts disclosed in the Administrative and Performance Reports. Effect: The absence of proper internal controls in the areas of program reports and accounting records causes the Bank to fall in noncompliance with federal reporting requirements and the terms and conditions as established in the subrecipient agreement. This matter may result in material differences or errors that could not be detected and resolved on a timely basis and consequently we consider that the above conditions are material weaknesses in internal control over compliance. Recommendation: The Bank should ensure, specifically to the CDBG-DR Fund, that adequate procedures and internal controls related to monthly review, reconciliation and approval are in place to ensure that proper monthly accounting is maintained and that the awarded grants per accounting records are reconciled and agreed to the balances as disclosed in the Administrative and Performance Reports. Evidence of such reconciliations must be maintained as support for the reconciliation procedures performed.
Criteria: In accordance with 2 CFR 200.328 and 32 CFR section 35.4(c), the Grantee is required to submit Project and Expenditure Reports that are to include the Total Cumulative Expenditures and Total Current Period Expenditures. Condition: The Town of Oakland reported an incorrect amount of Total Cumulative Expenditures and Total Current Period Expenditures on the March 2024 Project and Expenditure Report and the Town of Oakland, Tennessee also reported an incorrect amount of Total Current Period Expenditures on the March 2025 Project and Expenditure Report. Questioned Costs: None. Context: We reviewed the annual Project and Expenditure Reports for March 2024 and March 2025. Effect: Overstatement of total cumulative expenditures and total current period expenditures on the March 2024 annual Project and Expenditure Report and overstatement of total current period expenditures on the March 2025 annual Project and Expenditure Report. Identification of a repeat finding: N/A – not a repeat finding. Cause: Human error in entering amounts. Also, the Town of Oakland, Tennessee, does not have any procedures in place to verify that the correct amounts are reported. Recommendation: Checks and balances should be in place for any numeric calculations used in the reporting on the annual Project and Expenditure Reports. Views of responsible officials and planned corrective actions: Management agrees. See separately issued Corrective Action Plan.
Federal Agency: U.S. Department of Homeland Security Pass-Through Agency: Central Office of Recovery, Reconstruction and Resiliency of Puerto Rico (COR3) Program: Disaster Grants – Public Assistance (Presidentially-Declared Disaster) (ALN 97.036) Compliance Requirement: Reporting (L) Type of Finding: Significant Deficiency in Internal Control (SD), Instance of Noncompliance (NC) This finding is similar to prior year finding 2023-009. Statement of Condition In our Reporting Test, we evaluated the Quarterly Progress Reports of a total of nine (9) projects for two quarters of fiscal year 2023-2024. During our audit procedures, we noted that the reports did not agree with the accounting and project records. Criteria 2 CFR 200.302 (a) states that the states’ and other non-Federal entities’ financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Also, 2 CFR 200.302 (b) (2) states that the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. Cause of Condition The Municipality’s accounting controls and procedures fail to ensure accurate, current and complete disclosure of the financial results of federal assisted activities. Effect of Condition The expenses reported in the Quarterly Progress Reports do not agree with the accounting records. Recommendation We recommend the Program Administrators reconcile the differences between the quarterly report and the accounting records before the submission to the pass-through entity. Questioned Costs None Views of Responsible Officials and Planned Corrective Action We will give instructions to the accounting staff in charge of the preparation of the quarterly progress reports of the Program, in order to comply with the FEMA reporting requirements. Responsible Official: Mrs. Irma M. Vargas Aguirre, Finance and Budget Director Implementation Date: December 31, 2025
Federal agency: Federal Aviation Administration Federal program title: Airport Improvement Program Assistance Listing Number: 20.106 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Period: July 1, 2023 to June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria: Federal Aviation Administration (FAA) guidelines require Airport Improvement Program recipients to submit periodic financial reports, including SF-425 (Federal Financial Report), Form 5100- 127 (Operating and Financial Summary), Form 5100-126 (Financial Government Payment Report), Form 5370-1 (Construction Progress and Inspection Report), and Form SF-271 (Requests for Reimbursement) in accordance with 2 CFR §200.328 and §200.329. Condition: During our testing, we noted that for each of the County’s seven Airport Improvement Program grants, only Form SF-271 was submitted for the audit period, despite requirements to submit five distinct report types per grant. Questioned costs: None Context: We initially sampled 31 of 105 reports required to be submitted during the year by the granting agency. 11 of the 11 SF-271 reports were received from the county and tested without exception. The department explained that Forms SF-425, 5100-127, 5100-126, and 5370-1 had not been submitted for the year under audit and therefore could not be provided. Cause: The aviation department was previously not aware of the reporting requirements of the grant. When the department became aware of the requirements they began working with the FAA to ensure all required reports were submitted. The delay in becoming aware of these requirements resulted in a significant backlog to be submitted which was exacerbated by understaffing at the department. Effect: The County’s failure to submit four of the five required reports for each of its seven Airport Improvement Program grants resulted in noncompliance with FAA reporting requirements under 2 CFR §200.328 and §200.329. This lack of reporting may impact the County’s ability to demonstrate proper stewardship of federal funds, delay reimbursement processing, and potentially affect future grant eligibility or funding decisions. Repeat Finding: This is not a repeat finding. Recommendation: CLA recommends that the County provide staff with training related to identifying and complying with grant requirements. Additionally, CLA recommends that the County implement tracking procedures, such as a monitoring checklist, to ensure all required reports are submitted in a timely manner. Views of responsible officials: There is no disagreement with the audit finding.
Finding: 2024-003 Timely Financial and Programmatic Reporting (Significant Deficiency) Information on the Federal Programs: ALN #10.937 Partnerships for Climate-Smart Commodities Criteria or Specific Requirement (including Statutory, Regulatory, or Other Citation): Per 2 CFR 200.328(b)(1), recipients must submit financial reports at intervals required by the Federal awarding agency, but no less frequently than annually and no more frequently than quarterly. Reports must be submitted no later than 30 calendar days after the reporting period end date. Per 2 CFR 200.329(b), recipients are required to submit performance reports at intervals required by the Federal awarding agency, but no less frequently than annually and no more frequently than quarterly. Performance reports must also be submitted no later than 30 calendar days after the reporting period end date.Condition: During our testing of quarterly reporting requirements, we noted the following: Financial Reports: Four of four (100%) quarterly financial reports were submitted after the 30-day deadline. Performance Reports: Three of four (75%) quarterly performance reports were submitted after the 30-day deadline. Detailed Progress Reports: CIF was unable to provide evidence of submission (such as electronic confirmation or date-stamped copies). As a result, we were unable to determine whether these reports were submitted timely. Cause: These issues occurred due to delays in internal review processes and the absence of a robust tracking system for reporting deadlines. Additionally, documentation supporting the submission of the detailed progress reports was not retained. Effect or Potential Effect: Untimely submission of required reports limits the Federal awarding agency’s ability to evaluate financial and program performance in a timely manner. The lack of submission documentation for detailed progress reports also creates a risk that required reports may not be submitted at all, which could impact continued funding, create compliance findings, and impair the Federal awarding agency’s oversight responsibilities. Questioned Costs: N/A Context: Our testing included 100% of required quarterly reports for the audit period. We identified late submission for 100% of financial reports and 75% of performance reports. For detailed progress reports, no documentation was available to confirm submission for the entire period reviewed. Identification as a Repeat Finding, if Applicable: N/A Recommendation: We recommend that management: 1. Implement controls, such as a reporting calendar with automated reminders, to ensure that financial and performance reports are prepared, reviewed, and submitted within 30 days of the quarter-end, in compliance with 2 CFR 200.328(b)(1) and 2 CFR 200.329(b). 2. Retain submission confirmations for all reports, including detailed progress reports, to provide an audit trail and evidence of compliance with Federal requirements.
2024-007 U.S. Department of Treasury COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 Significant Deficiency in Internal Controls over Compliance and Compliance Finding Criteria: Per 2 CFR section 200.328 of the Uniform Guidance, each recipient must report program outlays and program income on a cash or accrual basis, as prescribed by the federal agency. The compliance supplement identified four Key Line Items required to be reported to the federal awarding agency which include (1) current period obligation, (2) cumulative obligation, (3) current period expenditure and (4) cumulative expenditure. Condition: As of the March 31, 2024 reporting date, the Town’s Project and Expenditure report had reported cumulative expenditures that were approximately $29,900 less than what was recorded in the grant fund on the general ledger. Cause: The Town did not reconcile the Project and Expenditure report with the Town’s general ledger before submitting. Effect: The Town did not properly report grant expenditures in the Project and Expenditure reporting. Questioned Costs: None Repeat Finding from Prior Year: Yes; Finding 2023-008 Recommendation: The Town should implement procedures to reconcile the financial information in the Project and Expenditure reports to the Town’s general ledger before submission. Views of Responsible Official: Management agrees with the finding.
FINDING 2024-014 Subject: Title I Grants to Local Educational Agencies - Reporting Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A210014, S010A220014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-014. Condition and Context The system of internal controls over the applicable reports, as established by the School Corporation, was not properly implemented nor was it operating effectively to ensure that sufficient audit evidence was maintained to support the requests for reimbursement, as well as the Final Expenditure Reports submitted by the School Corporation. The Title I Director approved the requests for reimbursement and the Final Expenditure Reports prior to submission; however, this review was not effective. The fiscal years 2021-2022 and 2022-2023 Final Expenditure Reports and the six reimbursement requests were selected for testing. The School Corporation was unable to provide for audit documentation to support the underlying data accumulated and summarized in each of the Financial Expenditure Reports or the six reimbursement requests. The reported data could not be traced to records that accumulate or summarize the data; therefore, the accuracy and completeness of the reports could not be verified. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) 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 be in compliance 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 47 NORTH LAWRENCE COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Due to turnover of staffing in the School Corporation's administrative office, the School Corporation's management had not designed nor implemented a system of internal controls that would have ensured compliance or that supporting documentation would have been maintained and available for audit related to the Reporting compliance requirement. Effect Without a proper system of internal controls in place that operated effectively, the School Corporation did not retain and provide appropriate supporting documentation. This prevented the determination of the School Corporation's compliance with the Reporting compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish an effective system of internal controls to ensure documentation will be maintained and made available for audit as related to the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Federal Program American Rescue Plan Act, Assistance Listing No. 21.027 Criteria Per U.S. Treasury American Rescue Plan Act reporting requirements and 2 CFR §200.328, recipients are required to submit complete and accurate Project and Expenditure reports in a timely manner as prescribed by the grantor. Condition The entity did not submit the required Project and Expenditure report for the American Rescue Plan Act program by the applicable federal due date. Cause The entity did not have a formal process or monitoring control in place to ensure American Rescue Plan Act Project and Expenditure reporting deadlines were identified, tracked, and met. Effect Failure to submit Project and Expenditure reports timely may result in delayed reimbursements, increased risk of noncompliance with federal requirements, potential questioned costs, and could negatively impact future ARPA funding or other federal grant awards. Questioned Costs None. Recommendation We recommend the City implement internal controls to perform a timely closing of the audit, which would include the preparation of the schedule of expenditures of federal awards. This would allow for the timely submission of required report to the federal government. Repeat Finding Not repeating. Managements Response See Corrective Action Plan.
2024-008 Federal Agencies: U.S. Department of Agriculture Federal Program Names: The Child Nutrition Cluster: National School Lunch Program Summer Food Service Program Assistance Listing Numbers: 10.555 10.559 Pass-Through Agency: Commonwealth of Pennsylvania, Department of Education Pass-Through Number: 359-46-477-8 Award Period: July 1, 2023 through June 30, 2024 Type of Finding: • Material Weakness in Internal Control over Compliance Criteria: Uniform Guidance requires recipients to submit accurate, complete, and timely financial and performance reports for federal awards (2 CFR 200.327 and 200.328). Program specific reporting instructions for the Child Nutrition Cluster require the FNS 10 and FNS 418 to be filed within 30 days after month end. Condition: As part of the reporting requirements for the CBS Food Program under the National School Lunch Program (NSLP) and Summer Food Service Program (SFSP), management is responsible for submitting the FNS 10 (NSLP) and FNS 418 (SFSP) reports within 30 days after month-end. However, management was unable to provide five (5) monthly NSLP reports and one (1) monthly SFSP report requested for audit testing. Questioned Costs: None Cause: Management did not maintain adequate internal controls to ensure that required monthly program reports were properly completed, retained, and available for audit. This may include weaknesses in recordkeeping processes, staff turnover, or insufficient monitoring of reporting deadlines. Effect: Failure to maintain and provide required federal reports results in noncompliance with federal reporting requirements. Because key source documents were unavailable, auditors were unable to verify the accuracy, completeness, and timeliness of reported program activity for those months. This increases the risk of misreporting or unsupported claims being submitted to the federal government. Recommendation: The Organization should establish and enforce strengthened internal controls over federal reporting to ensure that all required monthly reports (FNS 10 and FNS 418) are: (a) completed accurately, (b) submitted on time, and (c) retained in accordance with federal record retention requirements (2 CFR 200.334). Management should designate responsible personnel and implement a monitoring process to ensure compliance. Views of Responsible Officers and Corrective Action Plan: Please refer to Community Benefit Solutions dba CBS Food Program’s Corrective Action Plan
Finding 2024-006 – Compliance; Internal Control over Compliance, Reporting (Material Weakness) Name of Federal Agency: U.S. Environmental Protection Agency Federal Program Name: Nonpoint Source Implementation Grants Assistance Listing Numbers: 66.460 Pass-Through Entity: Oregon Department of Environmental Quality Name of Federal Agency: U.S. Department of Commerce – National Oceanic and Atmospheric Administration Federal Program Name: Pacific Coast Salmon Recovery Program Assistance Listing Numbers: 11.438, 15.015, 15.244 Pass-Through Entity: State of Oregon – Oregon Watershed Enhancement Board (OWEB) Name of Federal Agency: U.S. Department of Agriculture Federal Program Name: National Fish and Wildlife Foundation Assistance Listing Numbers: 10.665 Pass-Through Entity: U.S. Forest Service Name of Federal Agency: U.S. Department of AgricultureFederal Program Name: Natural Resources Conservation Service Assistance Listing Numbers: 10.905 Pass-Through Entity: U.S. Forest Service Name of Federal Agency: U.S. Department of the Interior Federal Program Name: Wildlife, Sport Fish and Restoration Program Assistance Listing Numbers: 15.244 Pass-Through Entity: Bureau of Land Management Name of Federal Agency: U.S. Department of the Interior Federal Program Name: Secure Rural Schools and community Self-Determination – Watershed and water-quality improvements Assistance Listing Numbers: 15.234 Pass-Through Entity: Bureau of Land Management Criteria: Under 2 CFR 200, recipients must submit performance and financial reports as required by the terms and conditions of the award and must retain records sufficient to demonstrate compliance (see (§200.301Monitoring and reporting program performance, and §200.328 Financial reporting, §200.329 Monitoring and reporting program performance, and §200.334 Retention requirements for records). The grant agreements for awards above require timely submission of performance / progress reports by specified due dates, with documentation maintained to support the submitted information. Condition: For the fiscal year ended June 30, 2024, the auditee could not provide sufficient evidence that required reports for the programs listed were prepared, reviewed, and submitted in accordance with grant terms. Specifically: No provided required financial reports, and Partnership for the Umpqua Rivers lacked copies or evidence of submission, and support for reported amounts requested. Auditors were not provided with performance/progress reports and were instructed that Partnership for the Umpqua Rivers had no retained copies, review sign-offs, or submission confirmation. Where payments were received, support for the required reports or metrics were not retained and could not be supplied to auditors for reconciling to underlying records. Cause: Management has not implemented formal reporting controls, including: A documented reporting calendar with due dates and responsible staff, Reconciliation of report amounts to the accounting records, Retention procedures for report copies, underlying support, and submission confirmations, and Supervisory review evidenced by signatures or workflow approvals. Effect or Potential Effect: Absent evidence of timely, accurate reporting and adequate record retention: The organization is at risk of noncompliance with federal award conditions, Inaccurate financial or performance information may be reported to the funding agency, and The entity may be subject to remedial actions, including heightened monitoring, repayment of questioned amounts, or potential suspension of funding. Questioned Cost: None directly noted, but potential risk if reports were incomplete or inaccurate.Context: During our audit, it was found that the Partnership for the Umpqua Rivers experienced complete staff turnover in Financial Management for the year being audited. No current finance employees had worked for the organization during the year being audited. Award files provided to auditors did not contain information related to reporting of activity, expenditures, or progress of the awards. Repeat of a Prior-Year Finding: No, Prior- year did not require a Single Audit. Recommendation: We recommend that Partnership for the Umpqua Rivers: Establish a formal reporting and retention policy aligned with 2 CFR 200 and grant terms. Implement a centralized reporting calendar that tracks due dates, preparers, reviewers, and submission methods. Require reconciliations of financial reports to the general ledger and supporting schedules, retain the reconciliation with the reporting package. Create standard workpapers for performance metrics for each award. Configure the grant portal or document management system to retain submission confirmations, reports, receipts, and version -controlled copies of all reports for awards. Document supervisory review through sign-offs prior to submission and with evidence retained. Provide training to staff on Uniform Guidance requirements and record retention (§200.334). District Response: Partnership for the Umpqua Rivers acknowledges the deficiencies. Corrective Action Plan: ____________ (To be completed by Partnership for the Umpqua Rivers) Planned Implementation Date: _____________ Responsible Person: Partnership for the Umpqua Rivers Finance Manager
Federal Agency: U.S. Department of the Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Pass-through Agency: Northampton County Pass-Through Number: N/A Award Period: May 18, 2022 - December 31, 2025; October 1, 2022 - December 31, 2025 May 18, 2023 - December 31, 2025 Type of Finding: • Material Weakness in Internal Control over Compliance • Other Matters Criteria: Uniform Guidance requires recipients to prepare, submit, and retain accurate, complete, and timely financial reports for federal awards in accordance with 2 CFR §§ 200.327 and 200.328. Additionally, federal record retention requirements (2 CFR § 200.334) require organizations to maintain supporting documentation sufficient to substantiate reported program activity. Condition: During audit testing of financial reporting for the Coronavirus State and Local Fiscal Recovery Funds program, the Organization was unable to locate three of ten financial reports requested for review. As a result, auditors were unable to verify the accuracy, completeness, or timeliness of the reported financial information for those reporting periods. Questioned Costs: None. Context: Ten reports were requested for audit testing and management was unable to provide three of the requested reports. Cause: The Organization experienced turnover within the finance department, which contributed to inadequate document retention and weaknesses in controls over the preparation and maintenance of required financial reports. Effect: Failure to maintain and provide required financial reports constitutes noncompliance with federal reporting and record retention requirements. The absence of key source documentation limits assurance that reported program activity is accurate and supported and increases the risk of misreporting or unsupported claims being submitted to the federal government. Repeat Finding: N/A: Not a repeat finding Recommendation: The Organization should strengthen internal controls over financial reporting and record retention by establishing clear procedures to ensure that all required reports are accurately prepared, timely submitted, and retained in accordance with federal requirements. Management should designate responsible personnel and implement monitoring procedures to verify compliance with reporting and documentation standards. View of Responsible Officials and Planned Corrective Action: Please refer to Community Action Committee of the Lehigh Valley, Inc. and Subsidiaries’ Corrective Action Plan.
U.S. Department of Environmental Protection Agency Passed through State Department of Natural Resources and Conservation FFAL# 21.027 COVID-19 Coronavirus State and Local Fiscal Recovery Funds Reporting Material Non-compliance Material Weakness in Internal Control Criteria: • 2 CFR §200.303 requires non-federal entities to establish and maintain effective internal control over federal awards. • 2 CFR §200.328 requires recipients to submit accurate financial reports and maintain records that support the data reported. Condition: The District does not have documented internal controls over the preparation and review of federal financial reports. During our testing, we noted: • For one quarterly report, the District used an incorrect reporting period. • For both sampled reports, the District did not maintain the required supporting documentation in the reporting package to substantiate the amounts reported to the cognizant agency. Cause: The District has not implemented documented internal controls over the reporting process and did not ensure that supporting documentation was retained for amounts reported. Effect: Failure to maintain accurate reporting and supporting documentation increases the risk of noncompliance with Uniform Guidance and may result in questioned costs or misreporting to the cognizant agency. Questioned Costs: None to report. Context/Sampling: A nonstatistical sample of two reports were selected for testing. Repeat Finding from Prior Years: No. Recommendation: We recommend the District: • Develop and implement documented internal controls over the reporting process, including review procedures to ensure accuracy of reporting periods. • Maintain complete supporting documentation in the reporting package for all amounts reported to the cognizant agency. • Provide training to staff responsible for preparing and reviewing reports to ensure compliance with Uniform Guidance requirements. Views of Responsible Officials: Agree.
FINDING NUMBER 2024-002 REQUIREMENT REPORTING TYPE OF FINDING MATERIAL WEAKNESS FEDERAL PROGRAM 14.871 – SECTION 8 HOUSING CHOICE VOUCHERS CONDITION The Municipality did not submit or file the required FASS PH financial report for the fiscal year ended June 30, 2024. At the completion of the audit, the report remained outstanding and had not been uploaded to the FASS PH system, resulting in noncompliance with HUD’s reporting requirements. CRITERIA Entities administering the Section 8 Housing Choice Voucher Program (AL 14.871) must submit annual financial information to the U.S. Department of Housing and Urban Development (HUD) through the Financial Assessment Subsystem – Public Housing (FASS PH). This requirement is established under: • 2 CFR 200.327–200.328 (Uniform Guidance reporting requirements) • HUD Uniform Financial Reporting Standards (UFRS) • HUD Public Housing Assessment System (PHAS) – FASS PH requirements • Applicable HUD notices and guidance for FY 2024 These regulations require timely submission of complete and accurate financial data to allow HUD to evaluate the financial condition and compliance performance of the Municipality’s Housing Choice Voucher Program. CAUSE The failure to submit the FASS PH report resulted from insufficient internal controls over the financial reporting process. Contributing factors included: • Lack of a formal monitoring process to track HUD reporting deadlines • Inadequate supervisory review of required submissions • Limited staff knowledge of HUD’s UFRS and FASS PH reporting procedures EFFECT Non-compliance may result in HUD administrative actions, negative impact on the municipality’s financial assessment score, delays or interruptions in federal funding and potential for increased oversight or monitoring by HUD. QUESTIONED COST None RECOMMENDATION The municipality should establish and document formal internal controls to ensure timely preparation and submission of the FASS PH report. Assign responsibility to specific personnel and implement a compliance calendar for HUD reporting deadlines. Provide training to financial staff on HUD reporting requirements, UFRS, and the FASS PH system. Implement a supervisory review process to verify completeness and accuracy before submission. Submit the outstanding FASS PH report as soon as possible, if HUD still permits late filing. PRIOR YEAR FINDING None VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTION The Municipality of Comerío made a contract with an auditing firm to work on the reports and submission of the FASS-PH financial report compliance for the years in which the reports were not submitted. Furthermore, instructions were given for the HUD Coordinator to monitor the delivery of reports by the contracted auditing firm and to ensure that the contract for this service is finalized. Personnel in charge: Brenda L. Reyes Rivera, HUD Coordinator Compliance period: April 30, 2026
State Agency: Illinois Governor’s Office of Management and Budget (GOMB) Federal Agency: U.S. Department of the Treasury (TREAS) Program Name: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds ALN and Program Expenditures: 21.027 ($230,448,761) Award Numbers: Various - see table of award numbers Federal Award Year: Various - see table of award numbers Questioned Costs: None Compliance Requirement: Reporting Finding 2024-003: Failure to Accurately Prepare Performance Reports for the COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Program Condition Found: GOMB did not prepare accurate federal project and expenditure reports (Paperwork Reduction Act (PRA) 1505-0271) for the COVID-19 – Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) program. The State was required to prepare quarterly federal project and expenditure reports (PRA 1505-0271) for the CSLFRF program. To assist the State agencies, GOMB prepared these reports. According to the U.S. Treasury’s SLFRF Compliance and Reporting Guidance, expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. During our testing of two quarterly PRA 1505-0271 reports submitted during State fiscal year ended June 30, 2024, we noted that GOMB did not consistently apply cash or accrual basis for reporting and noted the following errors on the cash basis: "See Table in the Audit Report" Supervisory review procedures of the PRA 1505-0271 reports have not been designed to operate at an appropriate level of precision to ensure the financial reports are accurately prepared. Criteria or Requirement: 2 CFR 200.328 requires grantees to submit PRA 1505-0271 reports with the frequency required by the terms and conditions of the federal award. The State and Local Fiscal Recovery Funds: Project and Expenditure Report User Guide requires grantees to submit quarterly reports with current financial information, including current period and cumulative obligations and expenditures. In addition, 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 compliance requirements. Effective internal controls should include procedures to ensure financial information reported in required financial reports is complete and accurate prior to submission. Cause: In discussing these conditions with GOMB officials, management stated the reporting errors were a result of inaccurate information submitted to GOMB by other State agencies which were not detected. Possible Asserted Effect: Failure to prepare complete and accurate financial reports prevents the U.S. Treasury from effectively monitoring the CSLFRF program. Repeat Finding: A similar finding was reported in the prior year audit as finding code 2023-003. (Finding Code 2024-003, 2023-003) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend GOMB implement more precise review procedures to ensure the reports submitted to the U.S. Treasury are complete, accurate, and agree or reconcile to its financial records. Views of GOMB Officials: GOMB agrees with the recommendation. GOMB will continue to work with the State agencies to produce accurate financial reporting for the CSLFRF program.
State Agency: Illinois Department on Aging (IDOA) Federal Agency: U.S. Department of Health and Human Services (USDHHS) Program Name: Aging Cluster ALN and Program Expenditures: 93.044/93.045/93.053 ($68,210,944) Award Numbers: Various – see table of award numbers Federal Award Year: Various – see table of award numbers Questioned Costs: None Compliance Requirement: Reporting Finding 2024-050: Failure to Accurately Prepare Financial Reports for the Aging Cluster Condition Found: IDOA did not prepare accurate federal financial status reports for the Aging Cluster (Aging) program. IDOA is required to prepare semi-annual federal financial status reports (SF-425) for each open grant of the Aging program. During our testing of seven SF-425 reports submitted during state fiscal year 2024, we noted the following errors in the Older Americans Act Title III FFY21 grant (#2101ILOACM) SF-425 report for the semi-annual period ended September 30, 2023: "See Table in the Audit Report" We further noted the supervisory review procedures performed for this report were not designed to operate at an appropriate level of precision to ensure financial reports are accurately prepared. Additionally, IDOA does not perform analytical procedures to identify potential errors or unusual fluctuations in reported amounts. Criteria or Requirement: According to 2 CFR 200.328, Aging Cluster program grantees are required to submit SF-425 and Administration on Aging (AoA) Title III supplemental forms on a semi-annual basis. Reports are due within 30 days for the periods ending March 31 and September 30 and are based on the accrual basis. In addition, 2 CFR 200.303 requires non-Federal entities to, among other things, establish and maintain 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. Effective internal controls should include procedures to ensure information reported in required financial reports is accurate. Cause: In discussing these conditions with IDOA officials, they stated IDOA’s records were not updated for an error identified during the preparation and supervisory review of the report. Possible Asserted Effect: Failure to accurately prepare financial reports prevents the USDHHS from effectively monitoring the Aging program. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2024-050) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDOA review the process and procedures in place to prepare financial status reports required for the Aging program and implement the additional procedures necessary to ensure the reports are complete, accurate, and agree or reconcile to its financial records. Views of IDOA Officials: The Department agrees with this finding. The SF-425 reports are prepared by Department staff, reviewed by an outside contractor, entered into the payment management system, submitted and reviewed again before being certified. Although the adjustment has now been made and staff have been reminded to promptly enter and save adjustments or corrections in the working files at the time of the auditors’ review the spreadsheet was incorrect.
Finding 2024-011: Material Weakness and Material Noncompliance Finding, Reporting – Special Reporting Assistance Listing Program Title and Number: Coronavirus State and Local Fiscal Recovery Funds (ALN# 21.027) Federal Agency: U.S. Department of Treasury Pass-through Entity: N/A Award year: 2023-2024 Criteria or specific requirement: Generally, recipients must submit one initial Interim Report, quarterly or annual Project and Expenditure reports which include subaward reporting, and in some cases annual Recovery Plan reports. The Project and Expenditure Reports are due quarterly and/or annually based on 2 CFR 200.328 and 31 CFR section 35.4(c) Reporting and requests for other information. Cities were required to submit quarterly Project and Expenditure Reports which cover one calendar quarter and must be submitted to Treasury by the last day of the month following the end of the period covered. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Condition: None of the quarterly Project and Expenditure Reports were submitted as required, and instead the City elected to submit an annual Project and Expenditure Report that was submitted past the deadline for the fourth quarterly report. Cause: Grant management and reporting is not fully centralized within the City and there was turnover in the grant administrator position. The City did not have sufficient internal controls in place to ensure the reports were filed. Effect: Failure to file timely reports resulted in non-compliance with the Reporting requirements of the program. This could also result in the Federal government cancelling funding of the program or denying eligible expenditures. Context: There were four Project and Expenditure Reports required to be submitted during the audit period. Of the four quarterly Project and Expenditure reports required, none were submitted. The City elected to submit an annual Project and Expenditure Report, which was submitted 13 days after the deadline for the fourth quarterly report. Questioned Cost: None Repeating Finding: 2023-006 Recommendation We recommend that the City implement controls to ensure all reports are prepared, reviewed and submitted by the due date to the requisite agency, as well as contact the grantor about whether or not the delinquent reports should still be filed. Views of Responsible Officials: Management agrees with the finding.
The Department of Emergency and Military Affairs’ Emergency Management Division (Division) did not retain adequate documentation supporting reimbursement requests, matching requirements, and financial reports, risking the Division receiving monies it was not entitled to Assistance Listings number(s) and name(s): 97.042 Emergency Management Performance Grants Award number(s) and year(s): EMF-2021-EP-0016-S01 October 1, 2020 through September 30, 2023 EMF-2021-EP-0018-S01 October 1, 2020 through June 30, 2025 EMF-2022-EP-0009-S01 October 1, 2021 through September 30, 2025 EMF-2023-EP-0008-S01 October 1, 2022 through September 30, 2025 Federal agency: U.S. Department of Homeland Security Compliance requirement(s): Cash management, matching, and reporting Questioned costs: Unknown Condition Contrary to federal regulations, the Division did not retain adequate documentation supporting reimbursement requests, matching requirements, and financial reports as follows: X Cash management For 4 of 5 requests for reimbursement we tested, the Division did not retain adequate documentation to support the amounts requested for reimbursement from the federal agency. The Division used documentation provided by its subrecipients to calculate the amount to both reimburse the subrecipient and request from the federal government. However, while the Division provided documentation of the invoices paid under their requests for reimbursement, they were unable to indicate which invoice applied to the respective request for reimbursement. X Matching The Division was unable to demonstrate through its reimbursement requests or other supporting documentation how it used nonfederal funds for at least 50% of the total project cost. X Reporting The Division did not retain documentation supporting 3 of 3 Federal Financial Reports (FFR) we tested, as follows: y For the 2023 quarter 4 FFR, the Division could only provide an unapproved draft copy and could not demonstrate that it submitted the FFR to the federal agency. y For the 2024 quarter 1 FFR and the annual FFR, the Division did not retain underlying general ledger data or other records to support costs reported, including indirect costs calculated from an approved indirect cost rate agreement. Effect The Division’s failure to retain adequate documentation supporting reimbursement requests, matching requirements, and financial reports resulted in our being unable to determine whether the reimbursements were appropriate, matching requirements were met, and the reports were complete and accurate. There is also an increased risk that Division could receive federal monies to which it is not entitled. Also, if matching requirements are not met, the Division may be required to return program monies to the federal agency in accordance with federal requirements.1 Further, the federal agency is unable to rely on the financial reports to monitor the Division’s program administration, including its compliance with program requirements and ability to prevent and detect fraud, and evaluate the program’s success. Finally, the Division is at risk that this finding applies to other federal programs it administers. Cause The Division reported that turnover of staff who previously prepared documentation to support reimbursement requests, matching requirements, and financial reports and submitted the reimbursement requests and financial reports resulted in the Division’s inability to locate the supporting documentation for the reports, including the applicable indirect cost agreement, or explain how to reconcile a large number of invoices that were provided to the reimbursement requests tested. The Division also did not have formal policies and procedures requiring an independent review to ensure the accuracy and completeness of the information included in the reports, and the retention of all documentation supporting data included in its reports. Consequently, only 2 of the 3 reports we tested were reviewed and approved prior to submitting the reports to the federal agency. 1 Federal Uniform Guidance requires federal awarding agencies to follow up on audit findings and issue a management decision to ensure the recipient takes appropriate and timely corrective action (2 CFR §200.513(c)). Further, it requires that federal awarding agencies’ management decisions clearly state whether or not the audit finding is sustained, the reasons for the decision, and the expected auditee action to repay disallowed costs, make financial adjustments, or take other action, as directed by the federal awarding agencies (2 CFR §200.521). Criteria Federal regulation requires the Division to retain all public records, including financial records and supporting documentation, related to a federal program for a period of 3 years from the date the program’s final report was submitted to the federal awarding agency or pass-through grantor (2 CFR §200.334). In addition, federal regulation requires the Division to submit its quarterly reports no later than 30 days after the reporting period (2 CFR §200.328). Federal regulation also requires the Division to use the reimbursement method to administer the program, whereby the Division is reimbursed with federal program monies only after it spends its own monies for authorized program purposes and requests reimbursement from the federal grantor (2 CFR §200.305[B][3]). Also, the program’s grant agreement requires the Division to match 50% of the approved project costs from nonfederal sources. Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations to the Division 1. Retain documentation for all reimbursement requests, matching requirements, and financial reports, such as the underlying general ledger data, approved indirect cost rate agreements, or information provided by its subrecipients for a period of 3 years from the date the program’s final report is submitted to the federal agency. 2. Review the reports identified above to ensure they were accurate. If any inaccuracies are identified, work with the federal grantor to correct these reports. 3. Develop and implement written policies and procedures over the preparation of reimbursement requests and financial reports, and the monitoring of the Division’s matching requirements as well as the retention of these records. The Division should train responsible staff on these policies and to perform an independent review of these documents to ensure accuracy and completeness prior to submission to the federal agency. 4. Allocate sufficient resources, such as staffing, to comply with the award terms and program requirements over reimbursement requests, matching requirements, and financial reports. Views of responsible officials State management concurs with this finding. The State’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials regarding these recommendations. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
SIGNIFICANT DEFICIENCY 2024-002 - Reporting Federal Program Information: Department of Education ALN 84.425 – Elementary and Secondary School Emergency Relief ALN 21.027 – Coronavirus Local Fiscal Recovery Fund Criteria: The following CFRs apply to this finding: 2 CFR section 200.328 and 2 CFR section 200.329 Condition: During audit procedures, it was identified that the School could not provide copies of the Annual Performance Report/Annual Performance and Expenditure Report filed for the period under audit. Cause: The School did not have the necessary internal controls over reporting and did not complete and submit or did not appropriately maintain copies of the reports submitted. Effect: Reports may not have been completed and submitted within the 90 day allotted time after the end of the reporting period. Identification of Questioned Costs: None identified Context: The ESSER Performance report was due on April 12, 2024 for the period ending 6/30/23. Information was gathered and notes were made on the report form. No copy of the submitted report was maintained in the client file and client was unable to obtain a copy from the online submission program. A copy of the Coronavirus annual performance report was not maintained in the client files and client was unable to access the a copy of the report online. Repeat Finding: This is not a repeat finding. Recommendation: It is recommended that the School familiarize themselves with federal Reporting Requirements and implement internal control processes and procedures to ensure that they are following the criteria above. Views of Responsible Officials and Corrective Action Plan: Please see the Corrective Action Plan issued by the Limestone Community School and the Town of Limestone, Maine.
Finding Number: 2024-010 Assistance Listing Number and Title: AL # 84.425 Education Stabilization Fund Federal Award Identification Number / Year: 2024 Federal Agency: U.S. Department of Education Compliance Requirement: Reporting Pass-Through Entity: Ohio Department of Education and Workforce Repeat Finding from Prior Audit? Yes Prior Audit Finding Number: 2023-010 Noncompliance and Material Weakness- Final Expenditure Reporting 2 CFR § 3474.1 gives regulatory effect to the Department of Education for 2 CFR § 200.328 which provides the Federal awarding agency may solicit only the standard, OMB-approved government wide data elements for collection of financial information. This information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes, and preferably in coordination with performance reporting. The Ohio Department of Education Grants Manual requires, at the end of the grant period, that entities submit a final expenditure report (FER). A FER must be submitted to show how grant funds were expended during the grant period. The amounts by object code submitted by the District in the Final Expenditure Report for the American Rescue Plan Elementary and Secondary School Emergency Relief (ARP ESSER, AL # 84.425U), grant year 2024, varied from the underlying system data. Expenditures on the Final Expenditure report, object code 500 were under-reported $9,080, and object code 600 were under-reported $29,346. This variance was due to improper monitoring. The failure to properly report expenditures to the grantor can result in corrective action taken by the grantor and obfuscates the true nature of the grant’s use. The Treasurer should review the annual Final Expenditure Reports and verify the correct information is provided to the grantor. This information should be reconciled to the underlying system reports. Material Weakness and Noncompliance documented in Federal Finding 2024-008 in Section 3 above pertaining to ESSER funding contributed to the reporting error.
FINDING REFERENCE NUMBER 2024-022 (See Finding Reference Number 2024-003) FEDERAL PROGRAM (ALN – 10.542) PANDEMIC EBT FOOD BENEFITS (P-EBT) U.S. DEPARTMENT OF AGRICULTURE AWARD NUMBERS 2301PR456S9032 (Federal Award Years: 10/1/2022 through 3/31/2024) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ACTIVITIES ALLOWED OR UNALLOWED // ELIGIBILITY // REPORTING TYPE OF FINDING INTERNAL CONTROL AND COMPLIANCE – MATERIAL WEAKNESS AND MATERIAL NONCOMPLIANCE CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. In accordance with the approved State Plan, no summer 2023 P-EBT benefits may be issued to children who did not attend an NSLP-participating school at the end of the school year immediately preceding the summer. STATEMENT OF CONDITION As part of our internal control procedures for the financial management system regarding reporting requirements, we found the following deficiencies regarding the only report submitted during the fiscal year of September 30, 2023: • The amount reported as total Federal share of outlays (line 10.g.), was $35,356,789, and the amount of $879,121 (line 10.h) as total unliquidated obligations. The accounting system (PRIFA) reported total expenditures in the amount of $36,235,910, which is the sum of lines 10.g and 10.h. No unliquidated obligations are included in the database of PRIFA. • In addition, we noted an expenditure dated October 31, 2023, in the database for $92,157 that was not reported. This amount was not included as unliquidated obligation in the report of September and no other report was submitted that included this expenditure. • We have no administrative expenses recorded in the database; however, the reports provided listed $307,733 as administrative expenses. In relation to the allowable activities, we obtained a list of all participants that received the benefits. We noted that the information provided from SAIC system does not agree with the reports provided by Service EBT Provider. We noted that the lists of emissions from June 2023 through October 2023 totalized $36,181,839, in accordance with a list from SAIC. Emissions from the Service EBT Provider and accounting records presented expenditures in the amount of $36,328,067, a total difference of $146,228. This difference represents 1,052 participants that are not in the list provided from SAIC, but whose benefits were issued according to the reports from the Service EBT Provider. In relation to the evaluation of the eligibility requirements, we noted that 27 participants were duplicated in the lists from SAIC. In addition, we were unable to verify if the participant attended a private school that participated in the NSLP, because no evidence of the lists from the Puerto Rico Department of Education was provided. QUESTIONED COSTS $146,228. This amount is the total amount of benefits issued for 1,052 participants whose information was not provided. PERSPECTIVE INFORMATION These deficiencies are a systemic problem that is related to lack of proper training and segregation of duties when reporting (preparer and reviewer not being the same person). No proper internal controls are in place to ensure that all data used to issue the benefits is safeguarded and properly reconciled with accounting records. STATEMENT OF CAUSE ADSEF did not establish and implement adequate internal controls to ensure the accuracy, completeness, and supervisory review of financial information used in the preparation of Federal reports. In addition, financial data reported to the Federal agency was not consistently reconciled to the supporting accounting records and database prior to submission. Furthermore, no proper records are maintained of the data used to issue the benefits and how the reconciliation process from the SAIC system and benefits processed by the Service EBT Provider is made. POSSIBLE ASSERTED EFFECT The discrepancies between reported amounts and supporting records, along with lack of supervisory review, create a risk that Federal reports are inaccurate, incomplete, or unsupported, resulting in noncompliance with Federal reporting requirements. We were unable to verify the complete lists of beneficiaries of the P-EBT. IDENTIFICATION OF REPEAT FINDING This is a repeat of a finding reported in the prior audit as Finding Numbers 2023-001/2023-029. RECOMMENDATIONS We recommend that management establish an internal control process that includes having more than one person review the reports submitted to the Federal government. In addition, we recommend proper internal controls that require a structured process of compiling, reviewing and safeguarding all required data for benefits issued.
FINDING REFERENCE NUMBER 2024-023 (See Finding Reference Number 2024-004) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 231PR426S7003/4; 241PR426S7003/4 (Federal Award Years: 10/1/2022 through 9/30/2024) 2022G996117; 2023996117 (Federal Award Years: 10/1/2021 through 9/30/2023) 2401PRTANF1 (Federal Award Years: 10/1/2023 through 9/30/2026) 2301PRTABD; 2401PRTABD (Federal Award Years: 10/1/2022 through 9/30/2026) 2201PRLIEA; 2301PRLIEA; 2401PRLIEA (Federal Award Years: 10/1/2021 through 9/30/2025) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING INTERNAL CONTROL AND COMPLIANCE – MATERIAL WEAKNESS AND MATERIAL NONCOMPLIANCE CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award.” STATEMENT OF CONDITION As part of our audit procedures, we conducted an analysis of the process used to distribute administrative costs among the various programs administered by ADSEF. Administrative expenses are distributed based on a methodology called "Random Moment Sampling" (RMS). We identified the following deficiencies in the implementation and execution of this process: i. There is no written procedure that outlines the process for applying this formula for distributing administrative expenses. ii. There is no standardized monitoring or communication to ensure that employees who are required to complete this form are fully assigned to the roles subject to this process. In other words, the Human Resources Department or the Appointments Office do not communicate periodically or whenever a staff change occurs, in order to adjust the population subject to this questionnaire. iii. Among the options provided for responding to the RMS survey, three options are not assigned to a Federal program. These options include licenses; other types of work not directly tied to a Federal program function for which administrative expenses can be allocated. According to the State Plan, 3,300 questionnaires will be administered for functions performed by employees who are not at the central level, and 300 for employees who are at the central level. Two quarters of the Fiscal Year 2023-2024 fiscal year were observed, in which these three options represented between 25% and 18% for local offices and 38% at the central level. Because these options are not tied to a Federal program function, they reduce the percentage to zero and redistribute the percentage among Federal programs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. This allocation of administrative expenses is made quarterly; however, the adjustment in the accounting system (PRIFAS) is not necessarily made in the same period. The administrative expenses of each program contain the redistribution of expenses not assigned to a Federal program. STATEMENT OF CAUSE ADSEF does not have a written procedure establishing the process for implementing and monitoring the execution of this methodology. Additionally, among the responses regarding functions performed, time may be allocated to functions not related to Federal programs. POSSIBLE ASSERTED EFFECT They lack a standardized process that ensures that the methodology used allocates reasonable administrative costs among Federal programs, ensures that the distribution base is complete, and is periodically monitored. Furthermore, by redistributing the percentage of responses not directly related to a Federal program function, administrative costs could be claimed from Federal programs that should likely be allocated to state funds. IDENTIFICATION OF REPEAT FINDING This is a repeat of a finding reported in the prior audit as Finding Numbers 2023-004/2023-032. RECOMMENDATIONS We recommend that management establish a written internal control procedure that provides certainty, monitoring frequency, data validation, and responsibilities for those responsible for executing this process. Additionally, it should be considered that there are functions performed by the personnel in charge of answering the RMS that are not directly linked to a Federal program and should be assigned to state funds.
FINDING REFERENCE NUMBER 2024-024 (See Finding Reference Number 2024-005) FEDERAL PROGRAMS (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 231PR426S7003/4 (Federal Award Years: 10/01/2022 through 09/30/2023); 241PR426S7003/4 (Federal Award Years: 10/01/2023 through 09/30/2024) 2023996117 (Federal Award Years: 10/01/2022 through 09/30/2023) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING INTERNAL CONTROL AND COMPLIANCE – MATERIAL WEAKNESS AND MATERIAL NONCOMPLIANCE CRITERIA Uniform Guidance at 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450). (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. … (6) Written procedures to implement the requirements of § 200.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award.” STATEMENT OF CONDITION As part of our audit procedures, we requested evidence of the indirect costs transactions. ADSEF is allowed to claim 16.80% of indirect costs. As part of our audit procedures over the Nutrition Assistance for Puerto Rico and TANF program, we selected some transactions to evaluate the compliance with the indirect cost’s claims. The TANF program reported three (3) transactions related to indirect costs in the amount of $569,998.55, and for the Nutrition Assistance for Puerto Rico three (3) transactions were reported in the amount of $4,815,418.41. We requested evidence of one (1) transaction for the TANF program and one (1) for the Nutrition Assistance for Puerto Rico, no evidence of class object was provided in order to ascertain that only allowable expenditure transactions were considered in the calculation and claim of indirect costs. QUESTIONED COSTS None. PERSPECTIVE INFORMATION We consider this deficiency a systemic problem. ADSEF does not have an internal control process that allows for proper authorization and monitoring of the claims made for indirect costs. STATEMENT OF CAUSE ADSEF does not have a written procedure establishing the process for claiming and documenting indirect costs claims. The process of recording indirect costs is based on an excel spreadsheet, no detail of costs indicating the class object and transactions considered are maintained. POSSIBLE ASSERTED EFFECT Indirect costs calculation may include unallowable costs and not be detected timely. ADSEF cannot provide proper audit evidence of the amounts claimed as indirect costs. IDENTIFICATION OF REPEAT FINDING This is a repeat of a finding reported in the prior audit as Finding Numbers 2023-005/2023-033. RECOMMENDATIONS We recommend that management establish internal control processes to reconcile PRIFAS and the various sources of information used for reporting. Additionally, maintain clear records of indirect costs claimed and awarded.
FINDING REFERENCE NUMBER 2024-041 FEDERAL PROGRAM (ALN – 93.568) LOW-INCOME HOME ENERGY ASSISTANCE U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2301PRLIEA (Federal Award Year: 10/1/2022 – 9/30/2024) 2401PRLIEA (Federal Award Year: 10/1/2023 – 9/30/2025) 2301PRLIEE (Federal Award Year: 10/1/2022 – 9/30/2024) 2301PRLIEI (Federal Award Year: 10/1/2022 – 9/30/2024) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING – PERFORMANCE TYPE OF FINDING INTERNAL CONTROL AND COMPLIANCE – MATERIAL WEAKNESS AND MATERIAL NONCOMPLIANCE CRITERIA Uniform Guidance at 2 CFR § 200.302, Financial Management, establishes that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (See § 200.450.) (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. … (6) Written procedures to implement the requirements of § 200.305 and (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. LlHEAP Performance Data Form (OMB No 0970-0449) – State grant recipients must submit this report by January 3lst regarding the prior Federal fiscal year. The first section of the report is the Grant recipient Survey that collects and reports data on sources and uses of LIHEAP funds. The Grant recipient Survey includes Section III: Estimated Sources of Funds and Section IV: Estimated Use of LIHEAP Funds. Note: that these are referencing obligated not expended funding. The rest of the report is regarding performance metrics, mostly related to home energy burden targeting and reduction, as well as the continuity of home energy service. The Grantee Survey obligation amounts should be compared with the Carryover and Reallotment and FFR-425 reports. This reconciliation is needed to make sure the obligated balances for the program year being tested are accurate. Annual Report on Households Assisted by LIHEAP (OMB No. 0970-0060) https://omb.report/icr/202211-0970-005 – As part of the application for block grant funds each year, a report is required for the preceding fiscal year of (1) the number and income levels of the households assisted for each component and any type of LHEAP assistance (heating, cooling, crisis, and weatherization); and (2) the number of households served that contained young children, elderly, or persons with disabilities, or any vulnerable household for each component. Quarterly Performance and Management Report (OMB No. 0970-0589) https://omb.report/icr/202205-0970-017/doc/121847100 – Grant recipients must submit data and information about LIHEAP during the current FY, including success, challenges, needs and innovations. The quarterly reports focus on assisted households, performance management, obligation of funding, changes made due to anticipated increase in energy bills, collaboration with other utility programs, training and technical assistance needs. STATEMENT OF CONDITION As part of our audit procedures over the financial reporting requirements for LIHEAP program, we selected three reports submitted during our fiscal year. We noted that the administrative expenditures do not reconcile with the accounting information from PRIFAS. In addition, there are no written procedures describing internal controls over this requirement. We requested the LIHEAP Performance Data (OMB No 0970-0449), but no evidence of the report was provided. We obtained a copy of the Annual Report on Households Assisted by LlHEAP (OMB No. 0970-0060), but no supporting documentation regarding the information reported was provided. We requested two quarterly reports for the Quarterly Performance and Management Report (OMB No. 0970-0589) for the 2301LIEA grant, but no documentation was provided. QUESTIONED COSTS None. PERSPECTIVE INFORMATION This is a systematic deficiency. Procedures and internal controls manuals should provide for and ensure the segregation of duties, and the reconciliation of financial information reported to federal agencies against the accounting records used to prepare financial statements and SEFA. ADSEF failure to support reported amounts with verifiable documentation and the absence of independent review increases the risk of inaccurate or misstated financial data being reported to the Federal awarding agency. In relation to Special and Performance Reports, there are no proper controls over the data reported and the supporting information. STATEMENT OF CAUSE During our interviews and understanding of the internal controls over financial reporting, we noted that only one person prepares, submits and certifies the SF– 425 reports. No proper segregation of duties exists, that allows for validation of all accounting data before submitting the reports. In addition, the procedures manual for preparing reports does not establish a clear process for obtaining information, validating it, recording it, preparing it, and reporting it, as well as the responsibilities and segregation of duties to ensure that the reported information is consistent with ADSEF's accounting records. ADSEF lacks internal controls that allow for the timely validation and reconciliation of financial information. Furthermore, they lack a written procedures manual detailing the processes to follow in obtaining accounting data and reporting it to the Federal government, ensuring that the responsibility does not fall on a single individual. In relation to the Special and Performance Reports, the lack of written procedures and proper safeguarding of documentation does not allow for demonstrating compliance with the requirements of these reports. POSSIBLE ASSERTED EFFECT ADSEF does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports to the Federal Agencies and their financial statement. We were unable to evaluate internal controls and compliance over the Special and Performance Reports. ADSEF might not comply with the requirements of the program and not report it on time to the regulatory agencies. IDENTIFICATION OF REPEAT FINDING This is a repeat of a finding reported in the prior audit as Finding Numbers 2023-021/2023-051. RECOMMENDATIONS We recommend ADSEF to establish written procedures and internal controls manuals to provide and document the segregation of duties related to the reporting compliance requirement. In addition, in relation to the Special and Performance Reports create internal controls that provide for obtaining information, preparing reports, and filing evidence of reports.
FINDING REFERENCE NUMBER 2024-044 (See Finding Reference Number 2024-016) FEDERAL PROGRAMS (ALN – 93.556) MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES (ALN – 93.667) SOCIAL SERVICES BLOCK GRANT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBER 2203PRFPSS (Federal Award Years: 10/1/2021 through 9/30/2023); 2202PRFPCV (Federal Award Years: 10/1/2021 through 9/30/2023) 2211PRSOSR (Federal Award Years: 10/1/2021 through 9/30/2023) ADMINISTRATION ADMINISTRATION FOR FAMILIES AND CHILDREN (ADFAN, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING TYPE OF FINDING INTERNAL CONTROL AND COMPLIANCE – MATERIAL WEAKNESS AND MATERIAL NONCOMPLIANCE CRITERIA Uniform Guidance at 2 CFR § 200.302 (a) establishes that each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. See § 200.450. In addition, the SF-425 Federal Financial Report requires the reporting of financial activities related to Federal awards. The accounting basis used for reporting expenditures (whether cash or accrual) must align with the accounting system employed by the recipient organization. The 2 CFR § 200.302 (b), establish that the recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): … (6) written procedures to implement the requirements of § 200.305 and (7) written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. The 2 CFR section 200.328(c) establishes that the recipient or subrecipient must submit financial reports as required by the Federal award. Reports submitted annually by the recipient or subrecipient must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. The 2 CFR §200.303 (a) establishes that the recipient and subrecipient must: 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. These internal controls should align with the 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). STATEMENT OF CONDITION As part of our audit procedures over internal controls and compliance for reporting requirements, we selected the Grant Awards 2203PRFPSS and 2202PRFPCV, which closes in the audit period from July 2023 to June 2024, to validate the recorded amounts. Upon evaluating the report for the Grant Award 2203PRFPSS, we found the following deficiencies: 1) The accounting basis should be Cash Basis instead of Accrual Basis, according to the accounting system used. Additionally, they provided a Procedures Manual for the Finance and Budget Divisions, approved in 2009 and delivered in Word format, which states that the accounting basis is “accrual”, even though their current system operates on a cash basis and no conversion to accrual basis was made. 2) The total Federal expenditure reported on line (e) does not match the database provided by the PRDF. 3) The matching expenditure on line (j) does not match the database provided by the PRDF. 4) The report was not submitted within the established deadline, December 31, 2023 and they submitted the report on July 8, 2024. 5) During the internal control’s interviews, we found that there is no designated person responsible for reviewing the information entered by the preparer. As part of our audit procedures over internal controls and compliance for reporting requirements, we selected the Grant Award 2211PRSOSR, which closes in the audit period from July 1, 2023 to June 30, 2024, to validate the recorded amounts. Upon evaluating the report, we found the following deficiencies: 1) The accounting basis should be Cash Basis instead of Accrual Basis, according to the accounting system used. Additionally, they provided a Procedures Manual for the Finance and Budget Divisions, approved in 2009 and delivered in Word format, which states that the accounting basis is “accrual”, even though their current system operates on a cash basis and no conversion to accrual basis was made. 2) The total Federal expenditure reported on line (e) does not match the database provided by the PRDF. 3) The report was not submitted within the established deadline, December 31, 2023 and they submitted the report on June 10, 2024. 4) During the internal control’s interviews, we found that there is no designated person responsible for reviewing the information entered by the preparer. QUESTIONED COSTS None. PERSPECTIVE INFORMATION This deficiency is a systemic problem. Procedures and internal controls manuals should provide for and ensure the segregation of duties, training, and the reconciliation of financial information reported to Federal agencies against the accounting records used to prepare financial statement and SEFA. STATEMENT OF CAUSE ADFAN does not have internal controls to effectively review the process and comply with the reporting requirements. The absence of effective internal controls at ADFAN to review processes and ensure compliance with reporting requirements can be attributed to inadequate organizational structure and insufficiently defined roles and responsibilities. There is no designated individual or team responsible for overseeing the accuracy and completeness of financial data entered reports. As mentioned above in the condition, this responsibility falls under one person and does not have segregation of duties. This gap in accountability stems from a lack of internal review and insufficient oversight mechanisms, which restrains the organization's ability to ensure that reports are fully aligned with the required compliance standards. Additionally, there is a lack of training or resources dedicated to maintaining and monitoring compliance which contributes to the failure in reporting requirements. POSSIBLE ASSERTED EFFECT ADFAN does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports for the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING This is a repeat of a finding reported in the prior audit as Finding Numbers is 2023-023/2023-054. RECOMMENDATIONS We recommend that ADFAN ensures the SF-425 is completed using the appropriate accounting basis consistent with the organization’s financial system. Additionally, ADFAN should establish and implement internal control procedures that include formal review process to verify the accuracy and completeness of the reported information and designate responsible personnel for the review and approval of reports prior to submission to ensure compliance with Federal reporting requirements.
FINDING REFERENCE NUMBER 2024-046 (See Finding Reference Number 2024-018) FEDERAL PROGRAMS (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2022G996117 (Federal Award Year: 10/1/2021 – 9/30/2022) 2023G996117 (Federal Award Year: 10/1/2022 – 9/30/2023) 2022G9922PT (Federal Award Years: 10/1/2022 through 9/30/2025) 2301PRTABD (Federal Award Years: 10/1/2023 through 9/30/2026) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING – FINANCIAL REPORTING TYPE OF FINDING INTERNAL CONTROL AND COMPLIANCE – MATERIAL WEAKNESS AND MATERIAL NONCOMPLIANCE CRITERIA The 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. See § 200.450. (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. … (6) Written procedures to implement the requirements of § 200.305 and (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION As part of our audit procedures over the reporting requirements for the Temporary Assistance for Needy Families (TANF) and Payment to Territories – Adult (PTTA) programs, we reviewed two ACF-196TR reports submitted during the fiscal year under audit. Our review disclosed deficiencies related to the accuracy, support, reconciliation, and timeliness of reported expenditures. Specifically, we noted the following: • Administrative expenditures for both TANF and PTTA are recorded under the same accounting account number and Assistance Listing Number associated with TANF. As a result, the PRIFA accounting system does not segregate administrative expenditures by federal award or Assistance Listing Number, limiting the ability to identify and track expenditures attributable to each program. • Amounts reported in the ACF-196TR reports could not be reconciled to the PRIFA accounting records, particularly for administrative expenditures. Upon request, management was unable to provide supporting schedules, reconciliations, or documentation demonstrating how the reported amounts were derived. Supporting information was prepared only after it was requested during the audit. • For grant award 2023G996117, reported expenditures in the quarterly report of September 30, 2023, that did not agree with the underlying accounting records. We identified differences of $7,266.40 in Line 6A (Work-Related Activities and Expenses), $1,745,668.00 in Line 5A (Basic Assistance), $1,645,366.55 in Line 6J (Administration), $2,007,611.62 in Line 3 (Transfer to SSBG), and $103,052.41 in Line 10 (Total Expenditures). In addition, the report was submitted after the applicable due date. • For grant award 2401PRTANF, reported expenditures in the June 30, 2024 quarterly report that also differed from the accounting records. We identified differences of $12,312.07 in Line 6A (Work-Related Activities and Expenses), $1,898,639.95 in Line 6J (Administration), $3,786,696.14 in Line 3 (Transfer to SSBG), and $1,902,297.08 in Line 10 (Total Expenditures). Furthermore, the report maintained by ADSEF did not contain evidence of the submission date; therefore, we were unable to determine whether the report was submitted within the required timeframe. QUESTIONED COSTS None. PERSPECTIVE INFORMATION This is a systematic deficiency. Procedures and internal controls manuals should provide for and ensure the segregation of duties, and the reconciliation of financial information reported to Federal agencies against the accounting records used to prepare financial statements and SEFA. In addition, the financial management system should provide to account separately the administrative expenditures incurred among all Federal programs administered. ADSEF failure to support reported amounts with verifiable documentation and the absence of independent review increases the risk of inaccurate or misstated financial data being reported to the Federal awarding agency. STATEMENT OF CAUSE During our interviews and understanding of the internal controls over financial reporting, we noted that only one person prepares, submits and certifies the ACF-196TR reports. No proper segregation of duties exists, that allows for validation of all accounting data before submitting the reports. In addition, the procedures manual for preparing reports does not establish a clear process for obtaining information, validating it, recording it, preparing it, and reporting it, as well as the responsibilities and segregation of duties to ensure that the reported information is consistent with ADSEF's accounting records. PRIFAS accounting data base as configured, does not provide for the administrative expenditures incurred from the TANF and Payment to Territories – Adult programs to be segregated. ADSEF lacks internal controls that allow for the timely validation and reconciliation of financial information. Furthermore, they lack a written procedures manual detailing the processes to follow in obtaining accounting data and reporting it to the Federal government, ensuring that the responsibility does not fall on a single individual. POSSIBLE ASSERTED EFFECT ADSEF does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports to the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING This is a repeat of a finding reported in the prior audit as Finding Numbers is 2023-025/2023-056. RECOMMENDATIONS We recommend ADSEF to establish written procedures and internal controls manuals to provide and document the segregation of duties related to the reporting compliance requirement. Additionally, work with the Puerto Rico Department of the Treasury to provide accounting records to segregate the administrative expenditures of both programs.
Assistance Listing Number: 93.558 Name of Federal Program or Cluster: Temporary Assistance for Needy Families (TANF) Name of Federal Agency: Department of Health and Human Services Name of Pass-Through Entity: Virginia Department of Social Services Pass-Through Entity Identifying Number: BEN-21-029 Award Period: July 1, 2023 through June 30, 2024 Criteria or Specific Requirement: Title 2 CFR §200.302(b) requires non-federal entities to maintain effective control and accountability over all funds and to provide accurate, current, and complete disclosure of the financial results of each federally sponsored project or program. In addition, 2 CFR §200.328 requires financial reports to be supported by the entity’s accounting records and to be accurate and complete. Condition: The organization prepared various required financial reporting line items using budgeted amounts rather than actual expenditures recorded in the underlying accounting records. As a result, reported amounts did not agree to the general ledger and supporting accounting documentation. The variances were identified across multiple reporting line items and were not supported by reconciliations to actual expenditures. Cause: The condition occurred due to deficiencies in internal controls over financial reporting. Specifically, UCM relied on budgeted amounts rather than actual expenditures recorded in the accounting system when preparing required financial reports. In addition, formal written procedures do not clearly require that reported amounts be reconciled to the underlying accounting records prior to submission, and there was insufficient review and oversight to ensure that financial reports were prepared using actual data from the general ledger. Effect or Potential Effect: Because financial reports were not prepared using actual expenditures recorded in the accounting records, reported amounts may be inaccurate or incomplete. The use of budgeted amounts rather than actual financial data increases the risk that expenditures reported to the federal awarding agency or pass-through entity are misstated and not supported by the organization’s accounting records. As a result, UCM may be out of compliance with federal reporting requirements and federal agencies may rely on inaccurate financial information for monitoring and funding decisions. Recommendation: UCM should strengthen its internal controls over federal financial reporting by establishing and documenting procedures requiring that all reports submitted to federal awarding agencies or pass-through entities be prepared using actual expenditures recorded in the accounting system. These procedures should include a reconciliation of reported amounts to the general ledger and supporting documentation prior to submission, as well as an independent review process to ensure reported information is accurate, complete, and compliant with Uniform Guidance requirements. Views of Responsible Officials: Management acknowledges the finding and will work to implement appropriate corrective actions to address the deficiency and improve compliance going forward.
FINDING 2024-006 Subject: Title I Grants to Local Educational Agencies Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A210014, S010A220014, S010A230014 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Cash Management; Matching, Level of Effort, Earmarking; Reporting; Special Tests and Provisions - Participation of Private School Children; Special Tests and Provisions - Annual Report Card, High School Graduation Rate; Special Tests and Provisions - Assessment Testing Audit Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 39 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Repeat Finding This is a repeat finding from the immediately prior audit report for control activities - activities allowed or unallowed; allowable costs/cost principles; cash management; reporting; matching, level of effort, earmarking; and special tests and provisions - participation in private school children. The prior audit finding numbers were 2022-005, 2022-006, 2022-008, and 2022-009. Condition and Context Internal control is generally defined as a process affected by an entity's oversight body, management, and other personnel that provides reasonable assurance that the entity will achieve its objectives. For federal awards, nonfederal entities, such as the School Corporation, are required to establish and maintain internal control over federal awards to provide reasonable assurance that the entity will comply with applicable federal statutes, regulations, and the terms and conditions of its awards. Internal control is not a single event but an ongoing process that operates through five integrated components: Control Environment, Risk Assessment, Control Activities, Information and Communication, and Monitoring. Each component must function effectively, and the components must operate together in an integrated manner, for an internal control system to be effective. Deficiencies in the internal control system were identified across the five components and are described below. Control Environment - Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Cash Management; Matching, Level of Effort, Earmarking; Reporting; Special Tests and Provisions - Participation of Private School Children; Special Tests and Provisions - Annual Report Card, High School Graduation Rate; Special Tests and Provisions - Assessment Testing The School Corporation had not established a strong foundation for an effective internal control system. There was no demonstrated emphasis on the importance of internal controls or on compliance with federal program requirements. Risk Assessment - Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Cash Management; Matching, Level of Effort, Earmarking; Reporting; Special Tests and Provisions - Participation of Private School Children; Special Tests and Provisions - Annual Report Card, High School Graduation Rate; Special Tests and Provisions - Assessment Testing The School Corporation had not defined objectives necessary to identify risks or determine risk tolerances. Management did not identify, analyze, or respond to risks that could affect the achievement of objectives, including risks arising from significant changes to operations or the potential for fraud. Control Activities The School Corporation did not maintain sufficient financial records for its Title I programs. Although separate funds were established, expenditures were not accurately recorded, preventing the auditors from properly testing compliance with the federal requirements for the Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Cash Management; Matching, Level of Effort, Earmarking; Reporting; Special Tests and Provisions - Participation of Private School Children compliance requirements. Notable errors included payroll mapping errors, as well as unsupported reimbursement requests. INDIANA STATE BOARD OF ACCOUNTS 40 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Expenditures as reported on the Schedule of Expenditures of Federal Awards are based on reimbursements received during the audit period. To determine the specific expenditures associated with each reimbursement request the corresponding ledger activity or other applicable supporting documentation was requested. Based on the documentation provided, or lack thereof, it was determined that reimbursement requests were not prepared using expenditures recorded in the Title I funds. Instead, other undocumented or inconsistently retained records were used, and the amounts in those records did not align with the reimbursement requests submitted or the related fund activity. Of the 13 reimbursement claims submitted: There were 5 reimbursement requests totaling $854,889 filed in fiscal year 2022-2023 that had no supporting documentation, and the amounts requested did not agree with the disbursement activity recorded in the grant program funds. There were 8 reimbursement requests totaling $496,155 and received in 2023-2024 that had supporting documentation; however, the documentation agreed with reimbursement request amount in only 4 instances. For the other 4 reimbursement requests where documentation was provided, discrepancies totaling $15,982 were identified between the documentation and the amounts requested. Additionally, the documentation used to support 2023-2024 reimbursement requests did not correspond to the ledger activity recorded in the Title I program funds; instead, the School Corporation relied on separate individual payroll reports that were not tied to the program's financial records. Due to the lack of adequate documentation, we were unable to determine the validity of expenditures claimed for reimbursement, and, therefore, could not determine a population of expenditures to verify for compliance testing. This resulted in questioned costs totaling $1,351,044. Additional issues included: The former Chief Financial Officer did not direct the payroll clerk to allocate salaries and benefits for Title I personnel to the appropriate funds. As a result, salary and benefit costs were charged to the Title I funds for employees who did not work on the program, while costs for employees who did work on the program were charged to non-Title I funds. Receipt activity recorded in the Title I program funds did not always reflect actual Title I grant receipts. For example, receipts totaling $63,901 for the Supportive Effective Instruction State Grants program (formerly Improving Teacher Quality State Grants), Assistance Listings Number 84.367, were incorrectly recorded in the Title I fund. A separate fund was not created for the 2022-2023 grant project year as required by the pass-through entity; instead, an existing project year fund was used. Transfers totaling $993,763 in 2022-2023 and $73,107 in 2023-2024 were made into the Title I program funds from other funds or between Title I project years without adequate supporting documentation explaining the composition of the transfer amounts. Transfers totaling $650,150 in 2022-2023 were made out of the Title I program funds to other funds or other Title I project years, without sufficient supporting documentation identifying the nature of the transferred amounts. INDIANA STATE BOARD OF ACCOUNTS 41 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Information and Communication - Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Cash Management; Matching, Level of Effort, Earmarking; Reporting; Special Tests and Provisions - Participation of Private School Children; Special Tests and Provisions - Annual Report Card, High School Graduation Rate; Special Tests and Provisions - Assessment Testing The School Corporation had not established adequate communication methods or practices to ensure that reliable information was identified, captured, and communicated to the appropriate internal and external parties. Monitoring - Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Cash Management; Matching, Level of Effort, Earmarking; Reporting; Special Tests and Provisions - Participation of Private School Children; Special Tests and Provisions - Annual Report Card, High School Graduation Rate; Special Tests and Provisions - Assessment Testing The School Corporation did not perform ongoing or periodic evaluations to determine whether internal controls were operating effectively or to identify needed improvement. In addition, the School Corporation did not have a process in place to track or to follow-up on corrective actions written in response to audit findings. Due to the number and severity of the issues identified with the program's financial records and supporting documentation, we were unable to perform the procedures necessary to test the program for compliance. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) 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 be in compliance 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). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following (see also §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . INDIANA STATE BOARD OF ACCOUNTS 42 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. (4) Effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. See § 200.303. . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." Cause The School Corporation had not implemented an effective system of internal controls. Changes in key financial personnel, along with insufficient employee training, contributed to processes and procedures not being properly developed or consistently followed. Additionally, employees' salaries and benefits associated with the Title I programs were not mapped to the proper funds in the accounting software. Finally, reimbursement requests were completed based upon documentation, other than the ledger, that was not always retained or when retained did not agree with the amounts requested. Transfers in and out of Title I program funds did not contain sufficient supporting documentation to determine the specific purposes of the transfers Effect Because the five components of internal control were not properly designed or implemented, the School Corporation's internal control system could not be effective. As a result, general and fraud-related risks, as well as risks arising from significant operational changes, could negatively impact the School Corporation. Existing internal control deficiencies may continue undetected, and additional weaknesses may exist without being identified. Additionally, because the School Corporation did not establish an effective system of internal controls to ensure that the required documentation was obtained and retained, we were unable to obtain sufficient appropriate audit evidence to determine whether the School Corporation complied with the applicable federal program compliance requirements. This lack of documentation created a scope limitation for the audit and increased the risk that noncompliance, if present, may not have been detected. The inability to demonstrate compliance with federal requirements may affect the School Corporation's ability to support current program expenditures and may place eligibility for future federal funding at risk. Finally, salary and benefit expenditures were recorded to the Title I grant program funds for employees who were not involved with the program and expenditures for those involved with the program were recorded to non-Title I funds. Reimbursement requests could not be reconciled to the detailed ledger of expenditures. As such, a complete and accurate population of expenditures, that reconciled to the Schedule of Expenditures of Federal Awards or the financial statement could not be determined. INDIANA STATE BOARD OF ACCOUNTS 43 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs Questioned costs in the amount of $1,351,044 were identified as detailed in the Condition and Context. Recommendation We recommended the School Corporation design and implement a system of internal controls, which would include policies and procedures related to the five components of internal control. Management should define clear objectives, identify and assess risks, and develop policies and procedures to address those risks. Regular monitoring should be conducted to ensure internal controls are operating effectively and deficiencies are addressed promptly. We also recommended that the School Corporation ensure employees' salaries and benefits are properly mapped within the accounting system. Additionally, we recommended that all documentation to support a reimbursement request be attached to the reimbursement request and reconciled to the ledger at the time of request. We also recommended that any necessary transfers contain sufficient supporting documentation. Finally, we recommended that the School Corporation maintain complete and accurate records for all grant funds and project years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-008 Subject: Special Education Cluster (IDEA) Federal Agency: Department of Education Federal Programs: Special Education Grants to States, COVID-19 - Special Education Grants to States, Special Education Preschool Grants, COVID-19 - Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.027X, 84.173, 84.173X Federal Award Numbers and Years (or Other Identifying Numbers): 22611-138-PN01, 23611-138-PN01, 24611-138-PN01, 22611-138-ARP, 22619-138-PN01, 23619-138-PN01, 24619-138-PN01, 22619-138-ARP Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Cash Management; Matching, Level of Effort, Earmarking; Period of Performance; Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding numbers were 2022-010, 2022-011, and 2022-012. Condition and Context Internal control is generally defined as a process affected by an entity's oversight body, management, and other personnel that provides reasonable assurance that the entity will achieve its objectives. For federal awards, nonfederal entities, such as the School Corporation, are required to establish and maintain internal control over federal awards to provide reasonable assurance that the entity will comply with applicable federal statutes, regulations, and the terms and conditions of its awards. INDIANA STATE BOARD OF ACCOUNTS 47 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Internal control is not a single event but an ongoing process that operates through five integrated components: Control Environment, Risk Assessment, Control Activities, Information and Communication, and Monitoring. Each component must function effectively, and the components must operate together in an integrated manner, for an internal control system to be effective. Deficiencies in the internal control system were identified across the five components and are described below. Control Environment The School Corporation had not established a strong foundation for an effective internal control system. There was no demonstrated emphasis on the importance of internal controls or on compliance with federal program requirements. Risk Assessment The School Corporation had not defined objectives necessary to identify risks or determine risk tolerances. Management did not identify, analyze, or respond to risks that could affect the achievement of objectives, including risks arising from significant changes to operations or the potential for fraud. Control Activities The School Corporation receives federal funding through the Special Education Cluster (IDEA), including the Special Education Grants to States and Special Education Preschool Grants programs, administered by the Indiana Department of Education. These funds are subject to federal requirements regarding activities allowed or unallowed; allowable costs/cost principles; cash management; matching, level of effort, earmarking; period of performance; reporting; and financial documentation. The School Corporation did not maintain sufficient financial records for its special education programs. Although separate funds were established expenditures were not accurately recorded, preventing the auditors from properly testing compliance with the federal requirements for the Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Cash Management; Matching, Level of Effort, Earmarking; Period of Performance; and Reporting compliance requirements. Notable errors included payroll and fund mapping errors, as well as unsupported reimbursement requests. Salaries and benefits for special education staff were incorrectly mapped, resulting in expenditures being charged to the wrong funds. Additionally, program reimbursement requests were not based upon ledger expenditures and relied on documentation that was either missing or inconsistent with the amounts claimed. Due to insufficient documentation, most expenditures claimed for reimbursement could not be verified, resulting in questioned costs totaling $1,694,906. Of the 23 claims for reimbursement filed: There were 11 reimbursements totaling $1,289,892 that lacked supporting documentation and the amount claimed did not agree with the ledger disbursement activity. There were 11 reimbursements totaling $404,904 that either agreed with the grant fund ledger activity or documentation was retained to support the amount claimed for reimbursement. INDIANA STATE BOARD OF ACCOUNTS 48 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) There was 1 reimbursement totaling $110 that differed from the amount claimed by $1,837, with the amount claimed being less than the supporting documentation. Additional issues included: Receipt activity within the funds was not always reflective of the program grant money received. Special education program receipts totaling $47,913 were receipted to nonspecial education grant funds. A separate fund was not created to identify and record financial activity for each grant project year as required by the pass-through entity. Specifically, separate funds were not created for the Special Education Preschool grant for project years 2022 and 2023. Transfers between funds were made to address deficit fund balances, either due to financial activity being misallocated or errors discovered in transaction recording. However, supporting documentation for these corrections was not kept. In fiscal year 2022-2023, a total of $222,602 was moved into program funds from other sources or between various special education grant project year funds, while $6,653 was transferred in during 2023-2024. Conversely, funds totaling $699,655 in 2022-2023 and $722,283 in 2023-2024 were transferred out of program grant funds to other accounts or between special education grant project year funds. Information and Communication The School Corporation had not established adequate communication methods or practices to ensure that reliable information was identified, captured, and communicated to the appropriate internal and external parties. Monitoring The School Corporation did not perform ongoing or periodic evaluations to determine whether internal controls were operating effectively or to identify needed improvement. In addition, the School Corporation did not have a process in place to track or to follow-up on corrective actions written in response to audit findings. Due to the number and severity of the issues identified with the program's financial records and supporting documentation, we were unable to perform the procedures necessary to test the program for compliance. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) 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 be in compliance 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 49 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following (see also §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. (4) Effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. See § 200.303. . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." Cause The School Corporation had not implemented an effective system of internal controls. Changes in key financial personnel, along with insufficient employee training, contributed to processes and procedures not being properly developed or consistently followed. Additionally, employees' salaries and benefits associated with the special education programs were not mapped to the proper funds in the accounting software. Finally, reimbursement requests were completed based on documentation, other than the ledger, that was not always retained or when retained did not agree with the amounts being requested. Effect Because the five components of internal control were not properly designed or implemented, the School Corporation's internal control system could not be effective. As a result, general and fraud-related risks, as well as risks arising from significant operational changes, could negatively impact the School Corporation. Existing internal control deficiencies may continue undetected, and additional weaknesses may exist without being identified. INDIANA STATE BOARD OF ACCOUNTS 50 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, because the School Corporation did not establish an effective system of internal controls to ensure that the required documentation was obtained and retained, we were unable to obtain sufficient appropriate audit evidence to determine whether the School Corporation complied with the applicable federal program compliance requirements. This lack of documentation created a scope limitation for the audit and increased the risk that noncompliance, if present, may not have been detected. The inability to demonstrate compliance with federal requirements may affect the School Corporation's ability to support current program expenditures and may place eligibility for future federal funding at risk. Finally, salary and benefit expenditures were recorded to the special education grant program funds for employees who were not involved with the program and expenditures for those involved with the program were recorded to nonspecial education funds. Reimbursement requests could not be reconciled to the detailed ledger of expenditures. As such, a complete and accurate population of expenditures, that reconciled to the Schedule of Expenditures of Federal Awards or the financial statement could not be determined. Questioned Costs Questioned costs in the amount of $1,694,906 were identified as detailed in the Condition and Context. Recommendation We recommended the School Corporation design and implement a system of internal controls, which would include policies and procedures related to the five components of internal control. Management should define clear objectives, identify and assess risks, and develop policies and procedures to address those risks. Regular monitoring should be conducted to ensure internal controls are operating effectively and deficiencies are addressed promptly. We also recommended that the School Corporation ensure employees' salaries and benefits are properly mapped within the accounting system. Additionally, we recommended that all documentation to support a reimbursement request be attached to the reimbursement request and reconciled to the ledger at the time of request. We also recommended that any necessary transfers contain sufficient supporting documentation. Finally, we recommended that the School Corporation maintain complete and accurate records for all grant funds and project years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-009 Subject: COVID-19 - Education Stabilization Fund Federal Agency: Department of Education Federal Programs: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Cash Management; Equipment and Real Property Management; Matching, Level of Effort, Earmarking; Reporting; Special Tests and Provisions - Wage Rate Requirements; Special Tests and Provisions - Participation of Private School Children Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report for activities allowed or unallowed, allowable costs/cost principles, cash management, equipment and real property management, and reporting. The prior audit finding numbers were 2022-013, 2022-014, 2022-015, and 2022-016. Condition and Context Internal control is generally defined as a process affected by an entity's oversight body, management, and other personnel that provides reasonable assurance that the entity will achieve its objectives. For federal awards, nonfederal entities, such as the School Corporation, are required to establish and maintain internal control over federal awards to provide reasonable assurance that the entity will comply with applicable federal statutes, regulations, and the terms and conditions of its awards. Internal control is not a single event but an ongoing process that operates through five integrated components: Control Environment, Risk Assessment, Control Activities, Information and Communication, and Monitoring. Each component must function effectively, and the components must operate together in an integrated manner, for an internal control system to be effective. Deficiencies in the internal control system were identified across the five components and are described below. Control Environment The School Corporation had not established a strong foundation for an effective internal control system. There was no demonstrated emphasis on the importance of internal controls or on compliance with federal program requirements. Risk Assessment The School Corporation had not defined objectives necessary to identify risks or determine risk tolerances. Management did not identify, analyze, or respond to risks that could affect the achievement of objectives, including risks arising from significant changes to operations or the potential for fraud. INDIANA STATE BOARD OF ACCOUNTS 52 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Control Activities The School Corporation did not maintain sufficient financial records for its COVID-19 - Education Stabilization Fund program. Although separate funds were established, expenditures were not accurately recorded, preventing the auditors from properly testing compliance with the federal requirements for Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Cash Management; Equipment and Real Property Management; Matching, Level of Effort, Earmarking; Reporting; Special Tests and Provisions - Wage Rate Requirements; and Special Tests and Provision - Participation of Private School Children compliance requirements. Notable errors included expenditures recorded to the grant funds in the amount of $1,623,704 more than the grant amount awarded, as well as unsupported reimbursement requests. The School Corporation attempted to identify expenditures that they no longer wanted to be considered costs under the grant program to correct the overspending. However, instead of reclassifying the expenditures to the proper funds, monies were transferred into the grant funds from other School Corporation funds. The documentation to support the expenditures to be reallocated was not complete as $296,202 of the transfer amount could not be associated with specific expenditure transactions. Additionally, $839,096 in transactions identified to be reclassified were associated with the prior fiscal year 2021-2022 financial activity. After considering transactions recorded in the fund during 2022-2023 and 2023-2024 that were reallocated to other funds the remaining expenditures in the grant program funds were $138,134 less than the total grant funds claimed for reimbursement during the audit period. Due to insufficient documentation, expenditures claimed for reimbursement could not be verified, resulting in questioned costs totaling $1,654,481. Information and Communication The School Corporation had not established adequate communication methods or practices to ensure that reliable information was identified, captured, and communicated to the appropriate internal and external parties. Monitoring The School Corporation did not perform ongoing or periodic evaluations to determine whether internal controls were operating effectively or to identify needed improvement. In addition, the School Corporation did not have a process in place to track or to follow-up on corrective actions written in response to audit findings. Due to the number and severity of the issues identified with the program's financial records and supporting documentation, we were unable to perform the procedures necessary to test the program for compliance. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 53 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) 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 be in compliance 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). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following (see also §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. (4) Effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. See § 200.303. . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." Cause The School Corporation had not implemented an effective system of internal controls. Changes in key financial personnel, along with insufficient employee training, contributed to processes and procedures not being properly developed or consistently followed. Additionally, expenditures were not properly reviewed to determine if costs were properly recorded to grant funds. Finally, reimbursement requests were completed based on documentation, other than the ledger, that was not always retained or when retained did not agree with the amounts being requested. INDIANA STATE BOARD OF ACCOUNTS 54 SCOTT COUNTY SCHOOL DISTRICT 2 SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Because the five components of internal control were not properly designed or implemented, the School Corporation's internal control system could not be effective. As a result, general and fraud-related risks, as well as risks arising from significant operational changes, could negatively impact the School Corporation. Existing internal control deficiencies may continue undetected, and additional weaknesses may exist without being identified. Additionally, because the School Corporation did not establish an effective system of internal controls to ensure that the required documentation was obtained and retained, we were unable to obtain sufficient appropriate audit evidence to determine whether the School Corporation complied with the applicable federal program compliance requirements. This lack of documentation created a scope limitation for the audit and increased the risk that noncompliance, if present, may not have been detected. The inability to demonstrate compliance with federal requirements may affect the School Corporation's ability to support current program expenditures and may place eligibility for future federal funding at risk. Finally, reimbursement requests could not be reconciled to the detailed ledger of expenditures. As such, a complete and accurate population of expenditures, that reconciled to the Schedule of Expenditures of Federal Awards or the financial statement could not be determined. Questioned Costs Questioned costs in the amount of $1,654,481 were identified as detailed in the Condition and Context. Recommendation We recommended the School Corporation design and implement a system of internal controls, which would include policies and procedures related to the five components of internal control. Management should define clear objectives, identify and assess risks, and develop policies and procedures to address those risks. Regular monitoring should be conducted to ensure internal controls are operating effectively and deficiencies are addressed promptly. We also recommended that the School Corporation review expenditures and financial ledger reports to ensure activity is recorded to the correct fund. Additionally, we recommended that all documentation to support a reimbursement request be attached to the reimbursement request and reconciled to the ledger at the time of request. Finally, we recommended that the School Corporation maintain complete and accurate records for all grant funds and project years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
U.S. Department of the Treasury COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Award Year: 2022 Assistance Listing Number: 21.027 Criteria or Specific Requirement - Reporting In accordance with the award requirements and 2 CFR 200.328(c), recipients are required to submit accurate, complete, and timely performance reports. Additionally, 2 CFR 200.303 requires the County to establish and maintain effective internal control over Federal awards, including controls designed to ensure reports are complete, accurate, and submitted by required deadlines. Condition: The County did not submit the required annual performance report by the established deadline of April 30, 2024. The report was submitted on May 6, 2024. In addition, the report understated expenditures by $29,721 due to certain eligible expenditures being omitted from the report. Cause: Controls designed to ensure performance reports were reviewed for accuracy and reconciled to supporting accounting records prior to submission did not operate effectively. In addition, controls over monitoring reporting deadlines did not operate effectively. Effect or Potential Effect: As a result, the annual performance report was not submitted timely and did not accurately report program expenditures. Federal awarding agencies may rely on information contained in performance reports to monitor grant activity and program performance. Questioned Costs: None Context: The County was required to submit one annual performance report during the audit period. The report tested was submitted after the required deadline and understated program expenditures by $29,721. Identification of Prior Year Finding: N/A Recommendation: The County should strengthen internal controls over Federal reporting to ensure required reports are submitted timely and that information reported to the Federal awarding agency is complete and accurate. Such controls should include monitoring submission deadlines, reconciling reported amounts to supporting accounting records, and documenting a review of reports prior to submission. Views of Responsible Official and Planned Corrective Action: We will build a SEFA plan as well as establish a standard work for how federal grants should be handled when setting up accounts in our ERP system. This will help ensure the Auditor’s Office has proper tracking of federal funds and their guidelines.
2024-005: U.S. Department of Health and Human Services Health Center Program Cluster- Health Center Program, Assistance Listing No. 93.224 Compliance Requirements: Reporting Type of Finding - Significant Deficiency in Internal Control over Compliance Condition - Federal Financial Reports (SF-425) were submitted after the required 90 day reporting deadline, indicating that controls over the timely submission of required federal reports were not operating effectively. Criteria - Title 2 CFR §200.328 requires non-Federal entities to submit required financial reports no later than 90 calendar days after the end of the reporting period, unless otherwise specified in the terms and conditions of the federal award. Cause - Controls and procedures designed to ensure timely preparation, review, and submission of required federal financial reports were not consistently followed, resulting in delayed submission of SF-425 reports. Effect - Failure to submit SF-425 reports timely increases the risk of noncompliance with federal reporting requirements and may result in delayed monitoring, enforcement actions, or other adverse consequences by the awarding agency. Context - In our sample of the yearly report needing to be filed, the submission was submitted 41 days late. Recommendation - We recommend that the Center strengthen internal controls over federal financial reporting by implementing procedures to monitor reporting deadlines, including maintaining a formal tracking mechanism or compliance calendar for SF-425 due dates, assigning clear responsibility for report preparation and submission, and performing supervisory review to ensure SF-425 reports are submitted in accordance with federal requirements. Management Response to Findings - Management concurs with the finding.