Finding 548623 (2024-102)

Material Weakness
Requirement
AB
Questioned Costs
$1
Year
2024
Accepted
2025-03-31

AI Summary

  • Core Issue: The District failed to keep necessary documentation for payroll costs related to the Adult Education and Higher Education programs, leading to unsupported expenses totaling $73,165.
  • Impacted Requirements: Compliance with federal regulations and District policies regarding documentation and approval of employee time sheets was not met, increasing the risk of improper fund usage.
  • Recommended Follow-Up: Implement stricter monitoring and documentation practices for payroll processes, ensuring all employee time sheets are reviewed and approved as required.

Finding Text

Assistance Listings number and name: 84.002 Adult Education—Basic Grants to States Award numbers and years: 24FABASC-412421-01A, July 1, 2023 through June 30, 2024; 24FIELCC-412421-01A, July 1, 2023 through June 30, 2024; 24FIETCO-412421-01A, July 1, 2023 through June 30, 2024; 24FPRLEC-412421-01A, July 1, 2023 through June 30, 2024; 24FIECTC-412421-01A, July 1, 2023 through June 30, 2024 Compliance requirements: Activities Allowed or Unallowed and Allowable Costs / Cost Principles Questioned costs: $52,754 Assistance Listings number and name: 84.031 Higher Education—Institutional Aid Award numbers and years: P031S160090, October 1, 2016 through September 30, 2023; P031S190167, October 1, 2019 through September 30, 2024; P031S200096, October 1, 2020 through September 30, 2025; P031S200281, October 1, 2020 through September 30, 2025; P031C210057, October 1, 2021 through September 30, 2026; P031C210077, October 1, 2021 through September 30, 2026; P031S220015, October 1, 2022 through September 30, 2027; P031S220179, October 1, 2022 through September 30, 2027; P031A230147, October 1, 2023 through September 30, 2028; P031S230158, October 1, 2023 through September 30, 2028 Compliance requirements: Activities allowed or unallowed Questioned costs: $20,411 Federal agency: U.S. Department of Education Total questioned costs: $73,165 Condition—Contrary to federal regulations, State law, and District policies, the District did not always retain documentation supporting the Adult Education—Basic Grants to States and Higher Education—Institutional Aid programs’ payroll costs or approve employee time sheets after the work was performed for these programs. Specifically, the District could not provide documentation to support employees’ pay rates and authorization to perform work for these programs, such as offer letters, contracts, and personnel action forms, or did not approve employee time sheets after the work was performed for 22 of 54 payroll transactions we tested totaling $73,165. See finding 2024-01 in our Report on Internal Controls and Compliance for a similar finding related to the District not reviewing or approving employee timesheets.1 Also, see Table 1 on the next page for further information. Table 1 Summary of the $73,165 of payroll costs the District did not properly support or approve Fiscal year 2024 84.002 Adult Education—Basic Grants to States 84.031 Higher Education—Institutional Aid Total for both programs Total employees tested 35 19 54 Total employees with unsupported pay rates and lack of authorization to perform work for the programs 7 1 8 Total unsupported payroll costs $52,366 $9,636 $62,002 Total employee time sheets lacking approval after the work was performed2 2 12 14 Total unapproved payroll costs $388 $10,775 $11,163 Total number of employees with unsupported or unapproved payroll costs 9 13 22 Total salaries not supported $52,754 $20,411 $73,165 Effect—The District’s failure to retain documentation supporting payroll costs and approve time sheets increased the risk that the $52,754 for the Adult Education—Basic Grants to States and $20,411 for the Higher Education—Institutional Aid programs may not have been spent in accordance with their award terms and conditions. Consequently, the District may be required to return these monies to the federal agency in accordance with federal requirements.3 Further, see Table 2 for information on the overall payroll costs per program during fiscal year 2024 that are at an increased risk of not being spent in accordance with the award terms and conditions. Finally, the District is at risk that this finding applies to other federal programs it administers. Table 2 Calculation of percent of payroll costs to total program expenditures Fiscal year 2024 84.002 Adult Education—Basic Grants to States 84.031 Higher Education—Institutional Aid Total number of employees 279 214 Total payroll costs $3,613,133 $1,984,462 Total program costs $5,026,228 $6,696,263 % of payroll costs to total program costs 72% 30% Cause—The District’s management reported that it did not retain documentation to support employees’ pay rates and authorization to perform work for the federal programs for employees hired prior to 2018 as they were archived and support was no longer available, and some offers for temporary employees were made verbally over the phone and never documented. The District’s policies and procedures lack requirements to document all employment offers, including temporary employment offers. Additionally, as discussed in finding 2024-01 in our Report on Internal Controls and Compliance, some supervisors did not follow District policies and procedures requiring employees’ time sheets to be reviewed and approved either before processing payroll or within 3 business days after receiving a payroll email notification that the employee’s time sheet needed approval.1 Finally, District management did not sufficiently monitor whether each college’s Human Resources Department was enforcing these policies and procedures or verifying that supervisors reviewed and approved employees’ time sheets, as required. Criteria—Federal regulation requires the District to maintain records for salaries and wages charged to federal awards that accurately reflect the work performed to ensure they are accurate, allowable, and properly allocated (2 CFR §200.430[g][1][i]). Also, federal regulation, similar to State law and the District’s record retention policies, requires the District to retain all public records, including those contained in personnel files, related to a federal program for a period of 3 years from the date the program’s final report was submitted to the federal awarding agency or pass-through grantor (2 CFR §200.334).4,5 Further, the District’s written procedures require each employee’s time sheet to be reviewed and approved by the employee’s supervisor either before processing payroll or within 3 business days from receiving a payroll email notification that the employee’s time sheet needs approval. Additionally, each college’s Human Resources Department is responsible for verifying that supervisors review and approve time sheets timely.6 Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations—The District should: 1. Retain documentation for all payroll costs, such as employment agreements or acceptance letters, to demonstrate employees’ salaries and wages are authorized to be charged to federal programs and spent in accordance with the programs’ award terms and conditions. 2. Review the fiscal year 2024 payroll costs for the Adult Education—Basic Grants to States and Higher Education—Institutional Aid programs to ensure they were properly supported and spent in accordance with the award terms and conditions and coordinate with the U.S. Department of Education, as necessary, to adjust future federal reimbursement requests or repay any unallowable costs the District charged to the programs. 3. Enforce and train employees on District written procedures and requirements to: a. Retain all public records, including those contained in personnel files, related to a federal program for a period of 3 years from the date the program’s final report was submitted to the federal awarding agency or pass-through grantor. b. Ensure supervisors review and approve employees’ time sheets, either before payroll is processed or within 3 business days from receiving the payroll email notification that a time sheet needs approval, to verify employees accurately reported their time worked. This review should be performed after the employee performed the work to ensure the payroll costs charged to the programs accurately reflect the work performed and are accurate, allowable, and properly allocated. 4. Update District written procedures to require documentation of all employment offers, including offers for temporary employees. The District’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy. 1 Arizona Auditor General. (2024). Report on Internal Control and Compliance, June 30, 2024. Phoenix, AZ. https://www.azauditor.gov/sites/default/files/2025-02/MaricopaCountyCommunityCollegeDistrictJune30_2024ReportOnInternalControlAndCompliance.pdf 2 The 14 employee time sheets lacking approval after the work was performed includes 5 time sheets totaling $6,917 for the Higher Education—Institutional Aid program that were never approved by a supervisor and 2 time sheets totaling $388 for the Adult Education—Basic Grants to States program and 7 time sheets totaling $3,858 for the Higher Education—Institutional Aid program that were approved by a supervisor between 1 and 7 days prior to the work being performed by the employee. 3 Federal Uniform Guidance requires federal awarding agencies to follow up on audit findings and issue a management decision to ensure the recipient, the District, takes appropriate and timely corrective action (2 CFR §200.513[c]). Further, it requires that federal awarding agencies’ management decisions clearly state whether or not the audit finding is sustained, the reasons for the decision, and the expected auditee action to repay disallowed costs, make financial adjustments, or take other action, as directed by the federal awarding agencies (2 CFR §200.521). 4 Maricopa County Community College District (MCCCD). (2023). Staff Policy Manual. 5 Arizona State Library, Archives and Public Records. (2023) General Retention Schedule Created for All Public Bodies. Retrieved 3/12/25 from https://apps.azlibrary.gov/files/docs/all_general_schedules_searchable.pdf 6 Maricopa County Community College District (MCCCD). Version 1.1 (2019). Monitoring Time Approvals: Monitoring Procedures.

Corrective Action Plan

The District is aware of the importance of maintaining documentation that demonstrates expenditures charged to a program are allocable and allowable. The District will review existing procedures related to the review of temporary workers to ensure that documentation is available to demonstrate charges to programs comply with federal guidelines and regulations. The District also recognizes the importance of timely approval of time and effort in compliance with federal regulations. While the District does perform regular reconciliations of expenses to ensure allowability, the District will review and update procedures, as necessary, to continue to improve and document timely supervisory approvals after each bi-weekly payroll is processed in relation to finding 2024-01 in the District’s Report on Internal Controls and Compliance.

Categories

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring

Other Findings in this Audit

  • 548624 2024-102
    Material Weakness
  • 548625 2024-101
    Significant Deficiency
  • 1125065 2024-102
    Material Weakness
  • 1125066 2024-102
    Material Weakness
  • 1125067 2024-101
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.063 Federal Pell Grant Program $99.46M
84.268 Federal Direct Student Loans $32.86M
84.031 Higher Education Instituational Aid $6.70M
84.002 Adult Education Basic Grants to States $5.03M
84.007 Federal Supplemental Educational Opportunity Grants $3.82M
93.575 Child Care and Development Block Grant $3.18M
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.82M
59.037 Small Business Development Centers $2.40M
47.076 Stem Education $1.85M
84.048 Career and Technical Education Basic Grants to States $1.80M
84.033 Federal Work-Study Program $1.76M
11.028 Connecting Minority Communities Pilot Program $1.27M
84.425P Education Stabilization Fund - Institutional Resilience and Expanded Postsecondary Opportunity $748,521
84.042 Trio Student Support Services $652,835
84.425V Emergency Assistance for Non-Public Schools $593,391
84.116 Fund for the Improvement of Postsecondary Education $546,546
84.047 Trio Upward Bound $483,296
84.425U Education Stabilization Fund - American Rescue Plan Elementary and Secondary School Emergency Relief Fund $443,007
19.009 Academic Exchange Programs - Undergraduate Programs $408,512
12.002 Procurement Technical Assistance for Business Firms $386,418
84.010A Title I Grants to Local Educational Agencies (title I, Part A of the Esea) $211,457
10.555 National School Lunch Program $152,237
84.335 Child Care Access Means Parents in School $112,593
17.277 Wioa National Dislocated Worker Grants/wia National Emergency Grants $88,069
84.027 Special Education Grants to States $75,186
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $63,088
84.038 Federal Perkins Loan (fpl) - Federal Capital Contributions $51,118
10.664 Cooperative Forestry Assistance $39,377
84.411 Education Innovation & Research $38,073
12.598 Centers for Academic Excellence $21,424
84.425W Education Stabilization Fund - Elementary and Secondary Education Emergency Relief - Homeless Children and Youth $20,335
43.001 Science $17,103
17.258 Wioa Adult Program $17,058
84.367A Supporting Effective Instruction State Grants, Title Ii, Part A $15,550
12.905 Cybersecurity Core Curriculum $13,603
84.424 Student Support and Academic Enrichment Program $9,435
47.070 Computer and Information Science and Engineering $2,418
45.310 Grants to States $1,928
47.049 Mathematical and Physical Sciences $1,000
84.325 Special Education - Personnel Development to Improve Services and Results for Children with Disabilities $725
17.259 Wioa Youth Activities $1