Audit 374845

FY End
2023-06-30
Total Expended
$5.89M
Findings
8
Programs
27
Organization: City of Berlin, New Hampshire (NH)
Year: 2023 Accepted: 2025-12-15

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1164896 2023-004 Material Weakness Yes B
1164897 2023-004 Material Weakness Yes B
1164898 2023-004 Material Weakness Yes B
1164899 2023-004 Material Weakness Yes B
1164900 2023-004 Material Weakness Yes B
1164901 2023-004 Material Weakness Yes B
1164902 2023-004 Material Weakness Yes B
1164903 2023-004 Material Weakness Yes B

Programs

ALN Program Spent Major Findings
20.205 HIGHWAY PLANNING AND CONSTRUCTION $978,162 Yes 0
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $796,540 Yes 1
10.555 NATIONAL SCHOOL LUNCH PROGRAM $420,547 Yes 0
90.601 NORTHERN BORDER REGIONAL DEVELOPMENT $353,785 Yes 0
84.027 SPECIAL EDUCATION GRANTS TO STATES $273,683 Yes 0
84.287 TWENTY-FIRST CENTURY COMMUNITY LEARNING CENTERS $233,501 Yes 0
10.553 SCHOOL BREAKFAST PROGRAM $85,521 Yes 0
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $78,322 Yes 0
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $60,679 Yes 0
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $53,697 Yes 0
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $41,870 Yes 0
10.558 CHILD AND ADULT CARE FOOD PROGRAM $41,796 Yes 0
10.582 FRESH FRUIT AND VEGETABLE PROGRAM $36,705 Yes 0
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $33,083 Yes 0
97.067 HOMELAND SECURITY GRANT PROGRAM $32,143 Yes 0
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $27,631 Yes 0
84.358 RURAL EDUCATION $22,899 Yes 0
16.609 PROJECT SAFE NEIGHBORHOODS $9,401 Yes 0
10.704 LAW ENFORCEMENT AGREEMENTS $8,757 Yes 0
16.838 COMPREHENSIVE OPIOID, STIMULANT, AND OTHER SUBSTANCES USE PROGRAM $8,524 Yes 0
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $6,609 Yes 0
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $5,000 Yes 0
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $4,724 Yes 0
97.047 BRIC: BUILDING RESILIENT INFRASTRUCTURE AND COMMUNITIES $4,400 Yes 0
16.922 EQUITABLE SHARING PROGRAM $3,132 Yes 0
84.425 EDUCATION STABILIZATION FUND $2,883 Yes 1
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $175 Yes 0

Contacts

Name Title Type
LSU1QVJAD997 Holly Larsen Auditee
6037526350 Jarad Vartanian Auditor
No contacts on file

Notes to SEFA

The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) includes the federal award activity of the City of Berlin, New Hampshire (the “City” under programs of the federal government for the year ended June 30, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City.
Expenditures reported on the Schedule are reported on the modified accrual basis of accounting for federal programs accounted for in the governmental funds, and on the accrual basis of accounting for federal programs accounted for in the proprietary funds, which are described in Note 1 to the City’s basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent a realignment or change in funding source made in the normal course of business to amounts reported as expenditures in the prior years.
The City of Berlin, New Hampshire has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

Criteria: Effective control over financial reporting includes documentation of review and approval of critical inputs, including rates of pay and hours worked to ensure employees are paid appropriate amounts for time worked. Federal cost principles over allowable costs require documentation of time and effort. Condition: During our testing of compliance with the federal programs, we identified multiple instances of individuals who did not have documented rates of pay on file including approval. Additionally, it was noted that the City School Department’s control activities lacked a process for documenting review and approval of employee timecards. Cause: Design of control activities over School Department payroll does not include formal approval of timecards completed by all employees. Additionally, personnel files were not properly reviewed or maintained, which led to incomplete and or missing documentation in regard to rates of employee pay.Effect or potential effect: Failure to document approved rates of pay and approval of time worked increases the risk that employees may be paid an incorrect amount, amounts charged to grant programs may be incorrect or inconsistent with actual time and effort. Increased risk of wage claims against the City from employees claiming underpayment. Questioned costs: None. Context: We noted the lack of approval of time worked was systemic to the design of payroll controls at the City’s School Department. Lack of documentation of rates of pay was noted for 3 individual employees over a total of 6 transactions in a sample size of 26. Recommendation: We recommend reviewing employee personnel files to ensure completeness, including documented approval of rates of pay. Additionally, we recommend the City School Department evaluate the design of its internal control activities over payroll to include documentation of the review and approval of time reported by hourly employees. Views of responsible officials: In agreement with the finding and will comply with the recommendation as outlined above. The City School Department has since implemented (July 1, 2024) a process to follow up with grant managers and file the required documentation in a designated location for each respective grant, and Business Administrator will follow up on certifications on a semi-annual basis.