Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
Annual Report Card, High School Graduation Rate
An SEA and its LEAs must report graduation rate data for all public high schools at the school, LEA, and State levels using the 4-year adjusted cohort rate under 34 CFR section 200.19(b)(1)(i)-(iv). Additionally, SEAs and LEAs must include the 4-year adjusted cohort graduation rate (which may be combined with an extended-year adjusted cohort graduation rate or rates) in adequate yearly progress (AYP) determinations. Graduation rate data must be reported both in the aggregate and disaggregated by each subgroup described in 34 CFR section 200.13(b)(7)(ii) using a 4-year adjusted cohort graduation rate. Only students who earn a regular high school diploma may be counted as a graduate for purposes of calculating the 4-year adjusted cohort graduation rate. To remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a General Educational Development (GED) program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort (Title I, Sections 1111(b)(2) and (h) of ESEA (20 USC 6311(b)(2) and (h)); 34 CFR section 200.19(b)).
Section 8.3 of the LAUSD Attendance Manual states School staff shall document students who withdraw from the school. School staff shall follow Appendix J-2: Elementary School Withdrawal Symbols and Appendix J-3: Secondary School Withdrawal Symbols when recording withdrawal data.
Section XI.B of LAUSD REF-6554.4 states the Parent Assurance Letter (PAL) is the official form used to document withdrawal, transfer, and other student movement and that the form must be signed and submitted by the parent/guardian for student withdrawals.
Condition
We sampled a total of sixty (60) out of 78,036 students with leave codes in the school year 2021-22 My Integrated Student Information System (MiSiS) data file to verify that the leave code and reason code reported in MiSiS was properly supported. In our review of the documentation in comparison to the leave and reason code, we noted the following:
1. Six (6) schools provided documentation for seven (7) students that did not support the leave code entered into MiSiS:
2. One (1) school was unable to provide any documentation to support the leave code for one (1) student file.
Our sample was a statistically valid sample.
Cause and Effect
The discrepancy in the leave code was caused by the schools using the wrong leave code when they did not have enough information to substantiate that code. There seems to be a deficiency in the internal control system to properly train and monitor the personnel who are assigned to maintain the accuracy of student records and documentation.
Inaccurate leave codes in MiSiS may lead to inaccurate data collected by CDE, which could lead to errors in the calculation of the graduation rate.
Questioned Costs
Not applicable. This finding is considered a programmatic non-compliance issue.
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-002.
Recommendation
Given the recurring nature of this finding, we strongly recommend that the District take more robust measures to strengthen and improve its existing controls over enrollment/withdrawal status to ensure that student records on MiSiS are accurate and that necessary documents are maintained. Additionally, we recommend that the District continue to provide training on accurate enrollment/withdrawal codes and on the appropriate levels of written documentation required for various withdrawal situations under both ESSA and CDE guidance.
Criteria
Annual Report Card, High School Graduation Rate
An SEA and its LEAs must report graduation rate data for all public high schools at the school, LEA, and State levels using the 4-year adjusted cohort rate under 34 CFR section 200.19(b)(1)(i)-(iv). Additionally, SEAs and LEAs must include the 4-year adjusted cohort graduation rate (which may be combined with an extended-year adjusted cohort graduation rate or rates) in adequate yearly progress (AYP) determinations. Graduation rate data must be reported both in the aggregate and disaggregated by each subgroup described in 34 CFR section 200.13(b)(7)(ii) using a 4-year adjusted cohort graduation rate. Only students who earn a regular high school diploma may be counted as a graduate for purposes of calculating the 4-year adjusted cohort graduation rate. To remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a General Educational Development (GED) program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort (Title I, Sections 1111(b)(2) and (h) of ESEA (20 USC 6311(b)(2) and (h)); 34 CFR section 200.19(b)).
Section 8.3 of the LAUSD Attendance Manual states School staff shall document students who withdraw from the school. School staff shall follow Appendix J-2: Elementary School Withdrawal Symbols and Appendix J-3: Secondary School Withdrawal Symbols when recording withdrawal data.
Section XI.B of LAUSD REF-6554.4 states the Parent Assurance Letter (PAL) is the official form used to document withdrawal, transfer, and other student movement and that the form must be signed and submitted by the parent/guardian for student withdrawals.
Condition
We sampled a total of sixty (60) out of 78,036 students with leave codes in the school year 2021-22 My Integrated Student Information System (MiSiS) data file to verify that the leave code and reason code reported in MiSiS was properly supported. In our review of the documentation in comparison to the leave and reason code, we noted the following:
1. Six (6) schools provided documentation for seven (7) students that did not support the leave code entered into MiSiS:
2. One (1) school was unable to provide any documentation to support the leave code for one (1) student file.
Our sample was a statistically valid sample.
Cause and Effect
The discrepancy in the leave code was caused by the schools using the wrong leave code when they did not have enough information to substantiate that code. There seems to be a deficiency in the internal control system to properly train and monitor the personnel who are assigned to maintain the accuracy of student records and documentation.
Inaccurate leave codes in MiSiS may lead to inaccurate data collected by CDE, which could lead to errors in the calculation of the graduation rate.
Questioned Costs
Not applicable. This finding is considered a programmatic non-compliance issue.
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-002.
Recommendation
Given the recurring nature of this finding, we strongly recommend that the District take more robust measures to strengthen and improve its existing controls over enrollment/withdrawal status to ensure that student records on MiSiS are accurate and that necessary documents are maintained. Additionally, we recommend that the District continue to provide training on accurate enrollment/withdrawal codes and on the appropriate levels of written documentation required for various withdrawal situations under both ESSA and CDE guidance.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
20 U.S. Code § 7845 (a) (1), “A local educational agency receiving funds under more than one covered program may submit plans or applications to the State educational agency under those programs on a consolidated basis.” This Consolidated Application (ConApp) is used by the California Department of Education (CDE) to distribute categorical funds from various federal programs (e.g., Title I, Part A; Title II) to county offices, school districts, and direct funded charter schools throughout California.
Improving Teacher Quality State Grants (Title II, Part A) funds are allocated based on the following formula: (a) 20 percent based on the relative number of individuals age five through seventeen, and (b) 80 percent based on the relative numbers of individuals age five through seventeen from families with incomes below the poverty line, residing in the area the local educational agency (LEA) serves based on U.S. Census or state alternative poverty data.
Condition
We sampled a total of three (3) out of five (5) ConApp reports submitted in the fiscal year 2022-23. Our review identified discrepancies in the reported amount for Title II, Part A FY 2021-22 Expenditure Report, 12 Months as follows:
Our sample was a statistically valid sample.
Cause and Effect The discrepancies in the ConApp reporting can be attributed to a lack of adequate control measures within the reporting process, which has led to non-compliance with ConApp reporting requirement.
Questioned Costs
Not applicable - Title II, Part A funds are allocated based on a specific population and poverty-based formula, not based on expenditures.
Recommendation
We recommend that the District strengthen and improve its existing controls over the ConApp reporting process to ensure that all reported information is reconciled between the accounting records and the ConApp submissions.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
Annual Report Card, High School Graduation Rate
An SEA and its LEAs must report graduation rate data for all public high schools at the school, LEA, and State levels using the 4-year adjusted cohort rate under 34 CFR section 200.19(b)(1)(i)-(iv). Additionally, SEAs and LEAs must include the 4-year adjusted cohort graduation rate (which may be combined with an extended-year adjusted cohort graduation rate or rates) in adequate yearly progress (AYP) determinations. Graduation rate data must be reported both in the aggregate and disaggregated by each subgroup described in 34 CFR section 200.13(b)(7)(ii) using a 4-year adjusted cohort graduation rate. Only students who earn a regular high school diploma may be counted as a graduate for purposes of calculating the 4-year adjusted cohort graduation rate. To remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a General Educational Development (GED) program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort (Title I, Sections 1111(b)(2) and (h) of ESEA (20 USC 6311(b)(2) and (h)); 34 CFR section 200.19(b)).
Section 8.3 of the LAUSD Attendance Manual states School staff shall document students who withdraw from the school. School staff shall follow Appendix J-2: Elementary School Withdrawal Symbols and Appendix J-3: Secondary School Withdrawal Symbols when recording withdrawal data.
Section XI.B of LAUSD REF-6554.4 states the Parent Assurance Letter (PAL) is the official form used to document withdrawal, transfer, and other student movement and that the form must be signed and submitted by the parent/guardian for student withdrawals.
Condition
We sampled a total of sixty (60) out of 78,036 students with leave codes in the school year 2021-22 My Integrated Student Information System (MiSiS) data file to verify that the leave code and reason code reported in MiSiS was properly supported. In our review of the documentation in comparison to the leave and reason code, we noted the following:
1. Six (6) schools provided documentation for seven (7) students that did not support the leave code entered into MiSiS:
2. One (1) school was unable to provide any documentation to support the leave code for one (1) student file.
Our sample was a statistically valid sample.
Cause and Effect
The discrepancy in the leave code was caused by the schools using the wrong leave code when they did not have enough information to substantiate that code. There seems to be a deficiency in the internal control system to properly train and monitor the personnel who are assigned to maintain the accuracy of student records and documentation.
Inaccurate leave codes in MiSiS may lead to inaccurate data collected by CDE, which could lead to errors in the calculation of the graduation rate.
Questioned Costs
Not applicable. This finding is considered a programmatic non-compliance issue.
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-002.
Recommendation
Given the recurring nature of this finding, we strongly recommend that the District take more robust measures to strengthen and improve its existing controls over enrollment/withdrawal status to ensure that student records on MiSiS are accurate and that necessary documents are maintained. Additionally, we recommend that the District continue to provide training on accurate enrollment/withdrawal codes and on the appropriate levels of written documentation required for various withdrawal situations under both ESSA and CDE guidance.
Criteria
Annual Report Card, High School Graduation Rate
An SEA and its LEAs must report graduation rate data for all public high schools at the school, LEA, and State levels using the 4-year adjusted cohort rate under 34 CFR section 200.19(b)(1)(i)-(iv). Additionally, SEAs and LEAs must include the 4-year adjusted cohort graduation rate (which may be combined with an extended-year adjusted cohort graduation rate or rates) in adequate yearly progress (AYP) determinations. Graduation rate data must be reported both in the aggregate and disaggregated by each subgroup described in 34 CFR section 200.13(b)(7)(ii) using a 4-year adjusted cohort graduation rate. Only students who earn a regular high school diploma may be counted as a graduate for purposes of calculating the 4-year adjusted cohort graduation rate. To remove a student from the cohort, a school or LEA must confirm, in writing, that the student transferred out, emigrated to another country, or is deceased. To confirm that a student transferred out, the school or LEA must have official written documentation that the student enrolled in another school or in an educational program that culminates in the award of a regular high school diploma. A student who is retained in grade, enrolls in a General Educational Development (GED) program, or leaves school for any other reason may not be counted as having transferred out for the purpose of calculating graduation rate and must remain in the adjusted cohort (Title I, Sections 1111(b)(2) and (h) of ESEA (20 USC 6311(b)(2) and (h)); 34 CFR section 200.19(b)).
Section 8.3 of the LAUSD Attendance Manual states School staff shall document students who withdraw from the school. School staff shall follow Appendix J-2: Elementary School Withdrawal Symbols and Appendix J-3: Secondary School Withdrawal Symbols when recording withdrawal data.
Section XI.B of LAUSD REF-6554.4 states the Parent Assurance Letter (PAL) is the official form used to document withdrawal, transfer, and other student movement and that the form must be signed and submitted by the parent/guardian for student withdrawals.
Condition
We sampled a total of sixty (60) out of 78,036 students with leave codes in the school year 2021-22 My Integrated Student Information System (MiSiS) data file to verify that the leave code and reason code reported in MiSiS was properly supported. In our review of the documentation in comparison to the leave and reason code, we noted the following:
1. Six (6) schools provided documentation for seven (7) students that did not support the leave code entered into MiSiS:
2. One (1) school was unable to provide any documentation to support the leave code for one (1) student file.
Our sample was a statistically valid sample.
Cause and Effect
The discrepancy in the leave code was caused by the schools using the wrong leave code when they did not have enough information to substantiate that code. There seems to be a deficiency in the internal control system to properly train and monitor the personnel who are assigned to maintain the accuracy of student records and documentation.
Inaccurate leave codes in MiSiS may lead to inaccurate data collected by CDE, which could lead to errors in the calculation of the graduation rate.
Questioned Costs
Not applicable. This finding is considered a programmatic non-compliance issue.
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-002.
Recommendation
Given the recurring nature of this finding, we strongly recommend that the District take more robust measures to strengthen and improve its existing controls over enrollment/withdrawal status to ensure that student records on MiSiS are accurate and that necessary documents are maintained. Additionally, we recommend that the District continue to provide training on accurate enrollment/withdrawal codes and on the appropriate levels of written documentation required for various withdrawal situations under both ESSA and CDE guidance.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.
Criteria
20 U.S. Code § 7845 (a) (1), “A local educational agency receiving funds under more than one covered program may submit plans or applications to the State educational agency under those programs on a consolidated basis.” This Consolidated Application (ConApp) is used by the California Department of Education (CDE) to distribute categorical funds from various federal programs (e.g., Title I, Part A; Title II) to county offices, school districts, and direct funded charter schools throughout California.
Improving Teacher Quality State Grants (Title II, Part A) funds are allocated based on the following formula: (a) 20 percent based on the relative number of individuals age five through seventeen, and (b) 80 percent based on the relative numbers of individuals age five through seventeen from families with incomes below the poverty line, residing in the area the local educational agency (LEA) serves based on U.S. Census or state alternative poverty data.
Condition
We sampled a total of three (3) out of five (5) ConApp reports submitted in the fiscal year 2022-23. Our review identified discrepancies in the reported amount for Title II, Part A FY 2021-22 Expenditure Report, 12 Months as follows:
Our sample was a statistically valid sample.
Cause and Effect The discrepancies in the ConApp reporting can be attributed to a lack of adequate control measures within the reporting process, which has led to non-compliance with ConApp reporting requirement.
Questioned Costs
Not applicable - Title II, Part A funds are allocated based on a specific population and poverty-based formula, not based on expenditures.
Recommendation
We recommend that the District strengthen and improve its existing controls over the ConApp reporting process to ensure that all reported information is reconciled between the accounting records and the ConApp submissions.
Criteria
2 CFR section 200.430(i), Standards for Documentation of Personnel Expenses, requires:
(1) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:
(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated;
(ii) Be incorporated into the official records of the non-Federal entity;
(iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities;
(iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy;
(v) Comply with the established accounting policies and practices of the non-Federal entity;
(vi) [Reserved]
(vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity.”
In accordance with LAUSD Policy Bulletin 2643.13 and 2643.14 entitled, “Documentation for Employees Paid from Federal and State Categorical Programs,” the Periodic Certification (formerly referred to as Semi-Annual Certifications) must be completed each fiscal year for employees whose compensation is singularly sourced from federal funds. The first Periodic Certification covers the period between July 1st through December 31st, and the second Periodic Certification covers the period between January 1st through June 30th. These certifications should be completed no later than January 31st and July 31st, respectively. Employees whose compensation is sourced by a combination of Federal or State funds that are not a Single Cost Objective are required to complete and sign the Multi-Funded Time Report at the end of each month.
Condition
As part of our compliance review over payroll expenditures, we selected samples of payroll expenditures charged to the program and reviewed the supporting documents to ascertain if they were allowable per program regulations, accurately charged to the program, and appropriately supported in accordance with 2 CFR section 200.430(i) and LAUSD Policy Bulletin 2643.13 and 2643.14.
Title I Grants to Local Educational Agencies: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the timesheet hours submitted by two (2) employees when compared to the records in SAP. One (1) employee’s hours reported on the timesheet was less than the hours recorded in SAP, leading to an overstatement of program expenditures. Conversely, another employee’s hours reported on the timesheets were greater than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $132 and $726, respectively, of the $186,080 sampled from $278,384,872 of the total payroll expenditures.
Special Education-Grants to States (IDEA, Part B): In our sample of sixty (60) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, four (4) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $23,194.
English Language Acquisition State Grants: In our sample of sixty (60) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by three (3) employees compared to the hours recorded in SAP. Specifically, one (1) employee reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast, two (2) employees reported more hours on the Muti-Funded Time Reports than the hours recorded in SAP, leading to an understatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $49 and $1,280, respectively, of the $156,424 sampled from $8,984,427 of the total payroll expenditures.
Improving Teacher Quality State Grants: In our sample of sixty-one (61) payroll expenditures, we identified discrepancies in the Multi-Funded Time Reports submitted by seven (7) employees compared to the hours recorded in SAP. Specifically, five (5) employees reported hours on the Multi-Funded Time Reports that were less than the hours recorded in SAP, leading to an overstatement of program expenditures. In contrast two (2) employees reported hours on the Muti-Funded Time Report that were greater than the hours recorded in SAP, leading to an understatement of program expenditures. In addition, we found that one (1) employee’s hours recorded in SAP did not have a corresponding Muti-Funded Time Report at all, leading to an overstatement of program expenditures.
Total exceptions for overstatement and understatement amounted to $7,697 and $1,957, respectively, of the $284,882 sampled from $17,263,439 of the total payroll expenditures.
COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER): In our sample of sixty-one (61) payroll expenditures, we identified a compliance issue regarding signatures on Periodic Certifications. Specifically, two (2) employees signed their Periodic Certifications only in response to our audit request, indicating that these signatures were not obtained within the required timeframe.
Total exceptions for untimely certifications amounted to $9,260.
Our samples were statistically valid samples.
Cause and Effect
The untimely certifications appear to be incidents in which employees did not follow the District’s policies and procedures. The discrepancies between time reports/timesheets and SAP data appear to be due to clerical errors and lack of sufficient review processes.
Such oversights lead to instances of non-compliance and inaccuracies in financial reporting/SEFA, impacting the reliability of payroll expenditure documentation.
Questioned Costs
The total costs related to the conditions mentioned above amounted to the following:
Title I Grants to Local Educational Agencies (AL No. 84.010): $132 overstatement and $726 understatement due to unsupported hours charged.
English Language Acquisition State Grants, U.S. Department of Education (AL No. 84.365Z): $49 overstatement and $1,280 understatement due to unsupported hours charged.
Improving Teacher Quality State Grants (AL No. 84.367): $7,697 overstatement and $1,957 understatement due to unsupported hours charged.
There were no questioned costs arising from untimely completed/signed Periodic Certifications or Multi-Funded Time Reports, as the payroll costs incurred were still allowable costs, despite the timing issues, for the respective programs (i.e., IDEA and ESSER).
Repeat Finding
This finding is a repeat finding as indicated in the Status of Prior Audit Findings and Recommendation as finding number F-2022-001.
Recommendation
We recommend that the District enhance its internal controls over payroll expenditures and related compliance requirements by providing adequate and continuous training to school administrators, timekeepers, and supervisors on the necessary procedures to ensure ongoing compliance is effectively monitored. We also recommend that management responsible for each grant develop and reinforce controls for reviewing and approving Multi-Funded Time Reports or timesheets prior to submission to the funding agency, ensuring that the review and approval process is well-documented. In addition, the District should also conduct internal audits to assess the accuracy of timesheets or Multi-Funded Time Reports and the timeliness of signed Periodic Certification submissions to ensure compliance with the established requirements.