Finding 1164903 (2023-004)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2025-12-15

AI Summary

  • Core Issue: Lack of documented approval for employee pay rates and timecards increases the risk of incorrect payments and potential wage claims.
  • Impacted Requirements: Federal cost principles require proper documentation of time and effort, which is currently not being met by the City School Department.
  • Recommended Follow-Up: Review employee files for completeness and enhance payroll controls to ensure all timecards are formally approved.

Finding Text

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.

Corrective Action Plan

Corrective Action Plan: Accounts Payable Specialist will send a series of follow up emails to grant managers for, but not limited to IDEA, Title I, & 21 st Century Grants and will file in designated location for each respective grant. Business Administrator will follow up on a semi-annual basis. Name of Responsible Person: Business Administrator - Evan Arsenault Anticipated Implementation Date of Corrective Action: July I, 2024

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1164896 2023-004
    Material Weakness Repeat
  • 1164897 2023-004
    Material Weakness Repeat
  • 1164898 2023-004
    Material Weakness Repeat
  • 1164899 2023-004
    Material Weakness Repeat
  • 1164900 2023-004
    Material Weakness Repeat
  • 1164901 2023-004
    Material Weakness Repeat
  • 1164902 2023-004
    Material Weakness Repeat

Programs in Audit

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