Finding 21019 (2022-002)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2023-05-09
Audit: 22065
Auditor: Wipfli LLP

AI Summary

  • Core Issue: There is a significant deficiency in internal controls over payroll allocations for federal programs, leading to potential misstatements in financial reporting.
  • Impacted Requirements: Compliance with 2 CFR 200.430(i) is not being met, as payroll charges lack proper documentation and allocation based on actual work performed.
  • Recommended Follow-Up: Ensure payroll allocations are verified against time and effort records before posting to the general ledger, with documentation completed by a designated individual.

Finding Text

Finding Number: 2022-002 - Represents a significant deficiency in internal control over compliance with Maine Mathematics and Science Alliance?s major federal program. Repeat Finding: No Type of Finding: Significant Deficiency Description: Internal Control over Payroll Condition: The internal controls over compliance for allowable activities and allowable costs are substantially the same for AL #47.076 and #47.070. During our audit, we noted several instances in which payroll expenditures were incorrectly allocated to the programs. The allocations were not based on time and effort records. Criteria: 2 CFR 200.430(i) states that ?Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;?. Cause: During fiscal year 2022, there was turnover in the personnel handling payroll. The database that was used from July 1, 2021 through October 15, 2021 to allocate payroll expenditures to the appropriate programs was not properly calculating based on the approved time and effort records. Effect: Without ensuring the payroll allocation is supported by time and effort records, it is possible that grants could be overcharged, resulting in misstated financial statements and unallowable costs. Context: The situation noted in the audit did not result in reportable questioned costs. We noted the exception applied to payroll periods from July 1, 2021 through October 15, 2021. The sample was not intended, and was not, a statistically valid sample. Recommendation: We recommend that the database used in the allocation of payroll to the grants be compared to the time and effort records prior to posting into the general ledger and sending to Bangor Payroll for processing. This should be completed and documented by an appropriate individual. View of responsible officials: Management agrees with the finding and has committed to a corrective action plan.

Corrective Action Plan

Finding Number: 2022-002 ? Significant Deficiency ? Internal Control Over Payroll The Alliance hired an organization that specialized in helping non-profits with accounting services. This organization has reviewed the payroll process and made suggestions for improvements. These suggestions have been implemented and will continue to be refined to ensure that allocations are made correctly based on time and effort. Additionally, formal reviews of time and effort will be made prior to posting expenses to the ledger. Person(s) Responsible: Ruth Allen-Kermish Timing for Implementation: Complete

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 21020 2022-003
    Significant Deficiency
  • 21021 2022-002
    Significant Deficiency
  • 21022 2022-003
    Significant Deficiency
  • 597461 2022-002
    Significant Deficiency
  • 597462 2022-003
    Significant Deficiency
  • 597463 2022-002
    Significant Deficiency
  • 597464 2022-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
47.076 Education and Human Resources $1.98M
47.070 Computer and Information Science and Engineering $293,206
84.425 Education Stabilization Fund $113,549
84.027 Special Education_grants to States $100,000