Audit 40758

FY End
2022-06-30
Total Expended
$8.07M
Findings
2
Programs
26
Year: 2022 Accepted: 2023-05-15
Auditor: Melanson CPAS

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
46803 2022-001 Significant Deficiency Yes B
623245 2022-001 Significant Deficiency Yes B

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $600,000 Yes 0
10.553 School Breakfast Program $312,589 Yes 0
84.048 Career and Technical Education -- Basic Grants to States $145,915 - 0
10.555 National School Lunch Program $143,592 Yes 0
84.425 Education Stabilization Fund $130,736 - 0
84.424 Student Support and Academic Enrichment Program $101,708 - 0
10.582 Fresh Fruit and Vegetable Program $79,288 - 0
14.872 Public Housing Capital Fund $61,700 - 0
84.287 Twenty-First Century Community Learning Centers $59,680 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $59,226 - 0
84.367 Improving Teacher Quality State Grants $46,140 - 0
84.002 Adult Education - Basic Grants to States $45,817 - 0
84.173 Special Education_preschool Grants $35,604 - 0
16.575 Crime Victim Assistance $25,119 - 0
84.027 Special Education_grants to States $14,956 - 0
14.218 Community Development Block Grants/entitlement Grants $14,674 - 0
20.205 Highway Planning and Construction $14,359 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $14,017 - 0
84.010 Title I Grants to Local Educational Agencies $12,211 - 0
84.365 English Language Acquisition State Grants $8,209 - 0
16.607 Bulletproof Vest Partnership Program $6,102 - 0
45.310 Grants to States $4,419 - 0
16.751 Edward Byrne Memorial Competitive Grant Program $3,414 - 0
20.600 State and Community Highway Safety $3,073 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $605 - 0
10.556 Special Milk Program for Children $301 Yes 0

Contacts

Name Title Type
WVFLWPMVXXB1 Katie Ambrose Auditee
6033357609 Scott McIntire Auditor
No contacts on file

Notes to SEFA

Title: Note 3. Donated Personal Protective Equipment (PPE) (Unaudited) Accounting Policies: ?The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of the City of Rochester, New Hampshire (the City) under programs of the federal government for the year ended June 30, 2022. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City.?Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited to reimbursement.?The amounts reported for the National School Lunch Program NonCash Assistance represent the fair value of commodities received.?Expenditures awarded from the Federal Emergency Management Agency (FEMA), must be presented on the Schedule when; 1) FEMA has approved the Citys project worksheet (PW) and 2) the City has incurred the eligible expenditures. The $14,017 reported for Disaster Grants Public Assistance (Publicly Declared Disasters), AL 97.036, represents expenditures incurred in prior years that were approved by FEMA during fiscal year 2022. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. During fiscal year 2022 the City did not receive donated PPE from federal sources.

Finding Details

SECTION III - FEDERAL AWARDS FINDINGS AND QUESTIONED COSTS 2022-001 Improve Time and Effort Documentation Federal Program(s) Information Federal Agency: U.S. Department of Education Award Name: Title I Grants to Local Educational Agencies AL Number: 84.010 Award Year: 2020, 2021 and 2022 Compliance Requirement: Allowable Costs/ Cost Principles Type of Finding Compliance Internal Control over Compliance - Significant Deficiency Criteria or Specific Requirement Grantees must provide reasonable assurance that federal awards are expended only for allowable activities and that the costs of goods and services charged to federal awards are allowable and in accordance with the applicable cost principles. Management is also responsible for establishing and maintaining effective internal control over compliance with federal requirements that have a direct and material effect on a federal program. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with the type of compliance requirement of a federal program on a timely basis. Condition and Context A sample of disbursements charged to the grants were tested for proper supporting documentation in order to determine if in accordance with the federal Allowable Costs/Cost Principles. As a result of testing of payroll disbursements charged to grants, certain costs were found that did not meet the time and effort documentation requirements. Specifically, semi-annual certifications were not provided for salaried individuals charged to the grants. Cause Weaknesses in the design and operation of controls. Effect or Potential Effect Due to the weaknesses in internal controls noted above, there is a risk that amounts charged to federal awards may not be allowable or in accordance cost principles. Known and likely questioned costs are equal to all related costs charged to the grants and are as follows: AL Number: 81.010 Name of Federal Program or Cluster: Title I Grants to Local Educational Agencies Quesitoned Costs: $737,534Identification as Repeat Finding As identified in Section IV, the Schedule of Prior Year Findings, this is a repeat of finding 2021-001. The reason for this finding?s recurrence were due to the Prior Year Single Audit Report not being issued until September of 2022, which is in fiscal year 2023, so the City was not able to take the feedback and make changes for the year under audit, as the year was already over. Recommendation The weakness in internal controls noted above should be addressed in order to provide reasonable assurance that federal awards are expended only for allowable activities, and that the costs of goods and services charged to federal awards are allowable and in accordance with the applicable cost principles. Views of Responsible Official and Planned Corrective Action Plan Management?s corrective action plan is included at the end of this report after the schedule of prior year findings.
SECTION III - FEDERAL AWARDS FINDINGS AND QUESTIONED COSTS 2022-001 Improve Time and Effort Documentation Federal Program(s) Information Federal Agency: U.S. Department of Education Award Name: Title I Grants to Local Educational Agencies AL Number: 84.010 Award Year: 2020, 2021 and 2022 Compliance Requirement: Allowable Costs/ Cost Principles Type of Finding Compliance Internal Control over Compliance - Significant Deficiency Criteria or Specific Requirement Grantees must provide reasonable assurance that federal awards are expended only for allowable activities and that the costs of goods and services charged to federal awards are allowable and in accordance with the applicable cost principles. Management is also responsible for establishing and maintaining effective internal control over compliance with federal requirements that have a direct and material effect on a federal program. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with the type of compliance requirement of a federal program on a timely basis. Condition and Context A sample of disbursements charged to the grants were tested for proper supporting documentation in order to determine if in accordance with the federal Allowable Costs/Cost Principles. As a result of testing of payroll disbursements charged to grants, certain costs were found that did not meet the time and effort documentation requirements. Specifically, semi-annual certifications were not provided for salaried individuals charged to the grants. Cause Weaknesses in the design and operation of controls. Effect or Potential Effect Due to the weaknesses in internal controls noted above, there is a risk that amounts charged to federal awards may not be allowable or in accordance cost principles. Known and likely questioned costs are equal to all related costs charged to the grants and are as follows: AL Number: 81.010 Name of Federal Program or Cluster: Title I Grants to Local Educational Agencies Quesitoned Costs: $737,534Identification as Repeat Finding As identified in Section IV, the Schedule of Prior Year Findings, this is a repeat of finding 2021-001. The reason for this finding?s recurrence were due to the Prior Year Single Audit Report not being issued until September of 2022, which is in fiscal year 2023, so the City was not able to take the feedback and make changes for the year under audit, as the year was already over. Recommendation The weakness in internal controls noted above should be addressed in order to provide reasonable assurance that federal awards are expended only for allowable activities, and that the costs of goods and services charged to federal awards are allowable and in accordance with the applicable cost principles. Views of Responsible Official and Planned Corrective Action Plan Management?s corrective action plan is included at the end of this report after the schedule of prior year findings.