Audit 52444

FY End
2022-06-30
Total Expended
$2.33M
Findings
4
Programs
2
Organization: Morongo Basin Transit Authority (CA)
Year: 2022 Accepted: 2023-03-01
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
47664 2022-002 Significant Deficiency - AB
47665 2022-002 Significant Deficiency - AB
624106 2022-002 Significant Deficiency - AB
624107 2022-002 Significant Deficiency - AB

Programs

Contacts

Name Title Type
C4B3PUWJEK47 Cheri Holsclaw Auditee
7603662986 Jessica Andersen Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of the Morongo Basin Transit Authority (MBTA) under programs of the federal government for the year ended June 30, 2022. The information is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulation 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 operation of the MBTA, it is not intended to and does not present the financial position, changes in net position, or cash flows of the MBTA. Expenditures reported in the schedule are reported on the full accrual basis of accounting. When applicable, 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. No federal financial assistance has been provided to a subrecipient. De Minimis Rate Used: N Rate Explanation: The MBTA has not elected to use the 10% de minimis cost rate.

Finding Details

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.
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.
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.
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.