Finding 1229677 (2023-013)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2026-09-11
Audit: 410871
Auditor: BDO USA PC

AI Summary

  • Core Issue: Internal controls failed to ensure compliance with federal requirements, leading to discrepancies in payroll reimbursement rates.
  • Impacted Requirements: Noncompliance with 2 CFR Section 200.303 regarding documentation and internal controls for federal awards.
  • Recommended Follow-up: Management should enhance payroll policies to ensure proper documentation is retained for all costs charged to the federal award.

Finding Text

Allowable Costs – Noncompliance and Significant Deficiency in Internal Control Over Compliance Agency/Pass-through Grantor Agency: U.S. Department of Homeland Security; Pass-through Grantor: State of Alaksa Department of Military and Veterans Affairs ALN and Program Name ALN: No. 97.036 Disaster Grants, Public Assistance Award Number Various Award Year 2020, 2021 Criteria or Specific Requirement The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. 2 CFR Subtitle A Chapter II Part 200 Subpart E states that a non-Federal entity must provide for adequate documentation to support costs charged to the Federal Award. Condition Testwork over a sample of payroll transactions identified five transactions, where the direct rate of pay utilized to request reimbursement for hours worked did not match the approved rate. Cause Internal controls did not ensure that proper supporting documentation was retained in accordance with 2 CFR. Effect or potential effect Direct payroll and fringe benefit costs that were submitted for reimbursement for five transactions were not accurately calculated. Questioned Costs None reported. Context BDO tested a sample of forty payroll transactions for a total of $36,849 of a population 2,832 payroll transactions totaling $2,059,757. Five employees were identified whose supporting documentation did not support the rate of pay, which resulted in $134 unsupported cost for the payroll transactions selected. For these five employees, this resulted in $1,923 in payroll charged to the program more than approved rates. Repeat Finding Not a repeat finding. Recommendation Management should ensure that payroll policies and procedures are properly implemented to ensure adequate documentation is retained to support costs charged. Views of responsible officials and planned corrective actions Management concurs with the finding and has begun implementing enhanced procedures to ensure the allowability of expenditures.

Corrective Action Plan

Allowable Costs – Noncompliance and Significant Deficiency in Internal Control Over Compliance Corrective Action Plan: The Municipality has begun implementing enhanced grant compliance review procedures to ensure expenditures are allowable, adequately supported, and incurred within the applicable period of performance. Standardized documentation, supervisory review, and monitoring procedures will be incorporated into routine grant administration. Management will evaluate the effectiveness of these controls through completion of a full audit cycle. Anticipated Completion Date June 30, 2027

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1229588 2023-009
    Material Weakness Repeat
  • 1229589 2023-009
    Material Weakness Repeat
  • 1229590 2023-009
    Material Weakness Repeat
  • 1229591 2023-009
    Material Weakness Repeat
  • 1229592 2023-009
    Material Weakness Repeat
  • 1229593 2023-009
    Material Weakness Repeat
  • 1229594 2023-010
    Material Weakness Repeat
  • 1229595 2023-010
    Material Weakness Repeat
  • 1229596 2023-010
    Material Weakness Repeat
  • 1229597 2023-010
    Material Weakness Repeat
  • 1229598 2023-010
    Material Weakness Repeat
  • 1229599 2023-010
    Material Weakness Repeat
  • 1229600 2023-010
    Material Weakness Repeat
  • 1229601 2023-010
    Material Weakness Repeat
  • 1229602 2023-010
    Material Weakness Repeat
  • 1229603 2023-010
    Material Weakness Repeat
  • 1229604 2023-010
    Material Weakness Repeat
  • 1229605 2023-010
    Material Weakness Repeat
  • 1229606 2023-010
    Material Weakness Repeat
  • 1229607 2023-010
    Material Weakness Repeat
  • 1229608 2023-010
    Material Weakness Repeat
  • 1229609 2023-010
    Material Weakness Repeat
  • 1229610 2023-010
    Material Weakness Repeat
  • 1229611 2023-010
    Material Weakness Repeat
  • 1229612 2023-010
    Material Weakness Repeat
  • 1229613 2023-010
    Material Weakness Repeat
  • 1229614 2023-010
    Material Weakness Repeat
  • 1229615 2023-010
    Material Weakness Repeat
  • 1229616 2023-010
    Material Weakness Repeat
  • 1229617 2023-010
    Material Weakness Repeat
  • 1229618 2023-010
    Material Weakness Repeat
  • 1229619 2023-010
    Material Weakness Repeat
  • 1229620 2023-010
    Material Weakness Repeat
  • 1229621 2023-011
    Material Weakness Repeat
  • 1229622 2023-012
    Material Weakness Repeat
  • 1229623 2023-012
    Material Weakness Repeat
  • 1229624 2023-012
    Material Weakness Repeat
  • 1229625 2023-012
    Material Weakness Repeat
  • 1229626 2023-012
    Material Weakness Repeat
  • 1229627 2023-012
    Material Weakness Repeat
  • 1229628 2023-012
    Material Weakness Repeat
  • 1229629 2023-012
    Material Weakness Repeat
  • 1229630 2023-012
    Material Weakness Repeat
  • 1229631 2023-012
    Material Weakness Repeat
  • 1229632 2023-012
    Material Weakness Repeat
  • 1229633 2023-012
    Material Weakness Repeat
  • 1229634 2023-012
    Material Weakness Repeat
  • 1229635 2023-012
    Material Weakness Repeat
  • 1229636 2023-012
    Material Weakness Repeat
  • 1229637 2023-012
    Material Weakness Repeat
  • 1229638 2023-012
    Material Weakness Repeat
  • 1229639 2023-012
    Material Weakness Repeat
  • 1229640 2023-012
    Material Weakness Repeat
  • 1229641 2023-012
    Material Weakness Repeat
  • 1229642 2023-012
    Material Weakness Repeat
  • 1229643 2023-012
    Material Weakness Repeat
  • 1229644 2023-012
    Material Weakness Repeat
  • 1229645 2023-012
    Material Weakness Repeat
  • 1229646 2023-012
    Material Weakness Repeat
  • 1229647 2023-012
    Material Weakness Repeat
  • 1229648 2023-012
    Material Weakness Repeat
  • 1229649 2023-012
    Material Weakness Repeat
  • 1229650 2023-012
    Material Weakness Repeat
  • 1229651 2023-012
    Material Weakness Repeat
  • 1229652 2023-012
    Material Weakness Repeat
  • 1229653 2023-012
    Material Weakness Repeat
  • 1229654 2023-012
    Material Weakness Repeat
  • 1229655 2023-012
    Material Weakness Repeat
  • 1229656 2023-012
    Material Weakness Repeat
  • 1229657 2023-012
    Material Weakness Repeat
  • 1229658 2023-012
    Material Weakness Repeat
  • 1229659 2023-012
    Material Weakness Repeat
  • 1229660 2023-012
    Material Weakness Repeat
  • 1229661 2023-012
    Material Weakness Repeat
  • 1229662 2023-012
    Material Weakness Repeat
  • 1229663 2023-012
    Material Weakness Repeat
  • 1229664 2023-012
    Material Weakness Repeat
  • 1229665 2023-012
    Material Weakness Repeat
  • 1229666 2023-012
    Material Weakness Repeat
  • 1229667 2023-012
    Material Weakness Repeat
  • 1229668 2023-012
    Material Weakness Repeat
  • 1229669 2023-012
    Material Weakness Repeat
  • 1229670 2023-012
    Material Weakness Repeat
  • 1229671 2023-012
    Material Weakness Repeat
  • 1229672 2023-012
    Material Weakness Repeat
  • 1229673 2023-012
    Material Weakness Repeat
  • 1229674 2023-012
    Material Weakness Repeat
  • 1229675 2023-013
    Material Weakness Repeat
  • 1229676 2023-013
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $46.33M
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $16.97M
97.083 STAFFING FOR ADEQUATE FIRE AND EMERGENCY RESPONSE (SAFER) $1.15M
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $1.04M
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $961,713
20.505 METROPOLITAN TRANSPORTATION PLANNING AND STATE AND NON-METROPOLITAN PLANNING AND RESEARCH $848,422
20.933 NATIONAL INFRASTRUCTURE INVESTMENTS $838,032
93.778 MEDICAL ASSISTANCE PROGRAM $800,550
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $772,339
21.023 EMERGENCY RENTAL ASSISTANCE PROGRAM $568,064
97.056 PORT SECURITY GRANT PROGRAM $456,876
16.835 BODY WORN CAMERA POLICY AND IMPLEMENTATION $446,980
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $419,266
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $303,242
93.044 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART B, GRANTS FOR SUPPORTIVE SERVICES AND SENIOR CENTERS $258,807
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $254,661
93.889 NATIONAL BIOTERRORISM HOSPITAL PREPAREDNESS PROGRAM $239,605
20.507 FEDERAL TRANSIT FORMULA GRANTS $227,145
97.044 ASSISTANCE TO FIREFIGHTERS GRANT $221,656
16.543 MISSING CHILDREN'S ASSISTANCE $216,529
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $189,001
16.922 EQUITABLE SHARING PROGRAM $186,706
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $178,229
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $151,829
14.881 MOVING TO WORK DEMONSTRATION PROGRAM $147,323
20.823 PORT INFRASTRUCTURE DEVELOPMENT PROGRAM $141,569
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $129,008
16.320 SERVICES FOR TRAFFICKING VICTIMS $120,779
66.818 BROWNFIELDS MULTIPURPOSE, ASSESSMENT, REVOLVING LOAN FUND, AND CLEANUP COOPERATIVE AGREEMENTS $118,243
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $103,268
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $74,291
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $71,974
97.067 HOMELAND SECURITY GRANT PROGRAM $49,941
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $49,411
20.513 ENHANCED MOBILITY OF SENIORS AND INDIVIDUALS WITH DISABILITIES $44,353
45.310 GRANTS TO STATES $38,116
14.275 HOUSING TRUST FUND $24,053
15.904 HISTORIC PRESERVATION FUND GRANTS-IN-AID $23,472
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $21,818
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $17,306
20.526 BUSES AND BUS FACILITIES FORMULA, COMPETITIVE, AND LOW OR NO EMISSIONS PROGRAMS $16,559
20.205 HIGHWAY PLANNING AND CONSTRUCTION $13,388
93.116 PROJECT GRANTS AND COOPERATIVE AGREEMENTS FOR TUBERCULOSIS CONTROL PROGRAMS $8,193
93.103 FOOD AND DRUG ADMINISTRATION RESEARCH $3,297
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $-4,305
97.039 HAZARD MITIGATION GRANT $-12,269
93.940 HIV PREVENTION ACTIVITIES HEALTH DEPARTMENT BASED $-14,956
10.664 COOPERATIVE FORESTRY ASSISTANCE $-22,369
15.916 OUTDOOR RECREATION ACQUISITION, DEVELOPMENT AND PLANNING $-157,461