Finding 47664 (2022-002)

Significant Deficiency
Requirement
AB
Questioned Costs
$1
Year
2022
Accepted
2023-03-01
Audit: 52444
Organization: Morongo Basin Transit Authority (CA)
Auditor: Eide Bailly LLP

AI Summary

  • Core Issue: A programming error in the payroll system led to employees being overpaid for sick time, resulting in excess costs charged to the Federal program.
  • Impacted Requirements: Compliance with 2 CFR section 200.430, which mandates accurate records for salary and wage charges to Federal awards.
  • Recommended Follow-Up: Revise Federal grant management procedures to prevent unallowable costs from being included in reimbursement requests.

Finding Text

Program: Formula Grants for Rural Areas, COVID-19 Formula Grants for Rural Areas Federal Financial Assistance Number: 20.509 Federal Grantor: U.S. Department of Transportation ? Federal Transit Administration Passed-Through: State of California Department of Transportation Award No. and Year: 64RO21-01647 and 2022 Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control and Instance of Non-Compliance Criteria: 2 CFR section 200.430, Compensation ? personal services, states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. The records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition: During our testing of the program we noted instances in which employees were paid an additional amount of sick time during a pay period. Cause: Due to a programming error within ADP?s system, employee sick time hours that were coded on time-cards were doubled on MBTA?s payroll register. Effect: The programming error caused for excess costs to be incurred by MBTA. As payroll charges were fully allocated to the Federal program, the amount allocated also includes the excess amounts paid to employees. Questioned Costs: As a result of our procedures, we identified excess payments to employees in the amount of $527. However, the total amount caused by the data entry error was $756. Context/Sampling: A nonstatistical sample of 40 transactions out of approximately 988 transactions were selected for testing, which accounted for $77,983 of $2,251,472 of federal program expenditures. Repeat Finding from prior Year: No. Recommendation: We noted that MBTA revised its procedures to ensure system errors are identified prior to payroll being finalized and the programming error persisted for only a single pay period. However, we recommend that MBTA revise its Federal grant management procedures to ensure that costs incurred due to error or other types of unallowable costs are not included in subsequent reimbursement requests. View of Responsible Officials: Management agrees. See separately issued corrective action plan.

Corrective Action Plan

Finding 2022-002 Program: Formula Grants for Rural Areas, COVID-19 Formula Grants for Rural Areas Finding Summary: 2 CFR section 200.430, Compensation ? personal services, states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. The records must be support by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Responsible Individuals: Cheri Holsclaw, General Manager Corrective Action Plan: Basin Transit will review the Federal grants management procedures to ensure that costs incurred due to error or other types of unallowable costs are not included in subsequent reimbursement requests. Anticipated Completion Date: January 27, 2023 Cheri Holsclaw, General Manager

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 47665 2022-002
    Significant Deficiency
  • 624106 2022-002
    Significant Deficiency
  • 624107 2022-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.509 Formula Grants for Rural Areas and Tribal Transit Program $1.68M
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $73,629