2024-003 Internal Controls over Payroll – (Significant Deficiency) Federal Program Information: Funding Agency Title Federal Assistance Listing Number(s) Award Year and Number U.S. Department of Interior Indian School Equalization Program 15.042 2023; A23AV00801 U.S. Department of Interior Indian Schools Student Transportation 15.044 2023; A23AV00801 U.S. Department of Interior Administrative Cost Grants for Indian Schools 15.046 2023; A23AV00801 U.S. Department of Interior Indian Education Facilities, Operations, and Maintenance 15.047 2023; A23AV00801 Criteria or Specific Requirements: In accordance with 2 CFR § 200.302(b)(3) and § 200.430(i), recipients of federal funds must maintain documentation that supports the allowability and allocability of compensation costs. Personnel expenses must be supported by records that accurately reflect the work performed, and documentation must be maintained for each employee, including executed contracts, offer letters, pay rate approvals, timesheets, and separation documentation. Adequate support is necessary to demonstrate that federal funds were used in compliance with award conditions. Condition: During our review of internal controls over payroll processing, we selected 102 payroll transactions across four major programs. The School did not fully comply with its own adopted policies or applicable federal regulations concerning payroll documentation and processing. The following exceptions were identified: Termination letters were not provided for 5 samples. Adequate supporting document was not provided for 1 sample. Timesheet was not provided for 1 sample. Cause: The deficiencies appear to be due to a lack of consistent personnel file maintenance and insufficient internal controls over payroll documentation, record retention, and post-hiring compliance reviews. Effect: The lack of complete personnel documentation increases the risk of charging unallowable or unsupported costs to federal awards. It also affects the ability to verify employee eligibility, compensation accuracy, and the proper use of federal funds, potentially resulting in questioned costs and potential repayment obligations to granting agencies. Auditor's Recommendation: We recommend that the School implement enhanced internal controls and standardized procedures to ensure complete and accurate personnel records are maintained. This should include routine documentation checks to ensure that all required items, such as offer letters, contracts, paystubs, pay rate verifications, timesheets, and termination letters, are present and properly filed. Management should also provide training to relevant staff on federal compliance requirements related to payroll and personnel documentation.
2024-003 Internal Controls over Payroll – (Significant Deficiency) Federal Program Information: Funding Agency Title Federal Assistance Listing Number(s) Award Year and Number U.S. Department of Interior Indian School Equalization Program 15.042 2023; A23AV00801 U.S. Department of Interior Indian Schools Student Transportation 15.044 2023; A23AV00801 U.S. Department of Interior Administrative Cost Grants for Indian Schools 15.046 2023; A23AV00801 U.S. Department of Interior Indian Education Facilities, Operations, and Maintenance 15.047 2023; A23AV00801 Criteria or Specific Requirements: In accordance with 2 CFR § 200.302(b)(3) and § 200.430(i), recipients of federal funds must maintain documentation that supports the allowability and allocability of compensation costs. Personnel expenses must be supported by records that accurately reflect the work performed, and documentation must be maintained for each employee, including executed contracts, offer letters, pay rate approvals, timesheets, and separation documentation. Adequate support is necessary to demonstrate that federal funds were used in compliance with award conditions. Condition: During our review of internal controls over payroll processing, we selected 102 payroll transactions across four major programs. The School did not fully comply with its own adopted policies or applicable federal regulations concerning payroll documentation and processing. The following exceptions were identified: Termination letters were not provided for 5 samples. Adequate supporting document was not provided for 1 sample. Timesheet was not provided for 1 sample. Cause: The deficiencies appear to be due to a lack of consistent personnel file maintenance and insufficient internal controls over payroll documentation, record retention, and post-hiring compliance reviews. Effect: The lack of complete personnel documentation increases the risk of charging unallowable or unsupported costs to federal awards. It also affects the ability to verify employee eligibility, compensation accuracy, and the proper use of federal funds, potentially resulting in questioned costs and potential repayment obligations to granting agencies. Auditor's Recommendation: We recommend that the School implement enhanced internal controls and standardized procedures to ensure complete and accurate personnel records are maintained. This should include routine documentation checks to ensure that all required items, such as offer letters, contracts, paystubs, pay rate verifications, timesheets, and termination letters, are present and properly filed. Management should also provide training to relevant staff on federal compliance requirements related to payroll and personnel documentation.
2024-003 Internal Controls over Payroll – (Significant Deficiency) Federal Program Information: Funding Agency Title Federal Assistance Listing Number(s) Award Year and Number U.S. Department of Interior Indian School Equalization Program 15.042 2023; A23AV00801 U.S. Department of Interior Indian Schools Student Transportation 15.044 2023; A23AV00801 U.S. Department of Interior Administrative Cost Grants for Indian Schools 15.046 2023; A23AV00801 U.S. Department of Interior Indian Education Facilities, Operations, and Maintenance 15.047 2023; A23AV00801 Criteria or Specific Requirements: In accordance with 2 CFR § 200.302(b)(3) and § 200.430(i), recipients of federal funds must maintain documentation that supports the allowability and allocability of compensation costs. Personnel expenses must be supported by records that accurately reflect the work performed, and documentation must be maintained for each employee, including executed contracts, offer letters, pay rate approvals, timesheets, and separation documentation. Adequate support is necessary to demonstrate that federal funds were used in compliance with award conditions. Condition: During our review of internal controls over payroll processing, we selected 102 payroll transactions across four major programs. The School did not fully comply with its own adopted policies or applicable federal regulations concerning payroll documentation and processing. The following exceptions were identified: Termination letters were not provided for 5 samples. Adequate supporting document was not provided for 1 sample. Timesheet was not provided for 1 sample. Cause: The deficiencies appear to be due to a lack of consistent personnel file maintenance and insufficient internal controls over payroll documentation, record retention, and post-hiring compliance reviews. Effect: The lack of complete personnel documentation increases the risk of charging unallowable or unsupported costs to federal awards. It also affects the ability to verify employee eligibility, compensation accuracy, and the proper use of federal funds, potentially resulting in questioned costs and potential repayment obligations to granting agencies. Auditor's Recommendation: We recommend that the School implement enhanced internal controls and standardized procedures to ensure complete and accurate personnel records are maintained. This should include routine documentation checks to ensure that all required items, such as offer letters, contracts, paystubs, pay rate verifications, timesheets, and termination letters, are present and properly filed. Management should also provide training to relevant staff on federal compliance requirements related to payroll and personnel documentation.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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". Condition: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Criteria: 2 CFR 200.430(h)(8)(i) requires that amounts of personnel expenses are properly documented and include appropriate controls and documentation to support the distribution of the employee's wages among specific activities if the employee works on more than one award. Condition: Of the testing population of 120 payroll transactions tested, for 2 transactions the Organization was unable to provide a timesheet or other documentation to substantiate the application of the individual's time for that period. In addition for 59 transactions, the allocation on the time sheet provided does not agree to the allocation of the individual's wages to the program in the general ledger and voucher. Cause: Due to limited staffing resources, the Organization was not able to ensure maintenance of adequate documentation. Effect: The Organization is not able to demonstrate that the personnel expenses allocated to the grant was proper and ensure avoidance of duplication of funding requests for the same amounts. Questioned Costs: Unknown Recommendation: Management should review and refine its process of tracking payroll costs by grant to ensure that the costs are supported by a system of internal controls which provides reasonable assurance that the charges are accurate, are properly allocated, and reasonably reflect the total activity for which the employee is compensated. Views of Responsible Officials: Management agrees with the finding; see corrective action plan.
Finding 2024-010 - Material Weakness - Allowable Costs/Cost Principles Federal Assistance Listing Number: 84.010, 93.600 Federal Program Name: Title I Grants to Local Educational Agencies and Head Start Cluster Federal Agency Name: U.S. Department of Education and U.S. Department of Health and Human Services Pass-Through Entity Name: Wisconsin Department of Public Instruction Pass-Through Entity Identification Number: 2024-403619-DPI-TIA-141, 2024-403619-DPI-CSI-148 Criteria: In accordance with 2 CFR 200.303(a), the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.430(i), charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Additionally, 2 CFR 200.403(g) requires that costs are adequately documented to be allowable under Federal awards. Condition/Context: The District supports time charged to federal awards via semi-annual certifications which are approved by the grant administrator or the building principal. In order for a cost to be supported at the time of final reimbursement, the semi-annual certifications should be approved by the grant administrator or the building principal. Title I Grants to Local Educational Agencies (ALN 84.010) The final reimbursement claim for the Title I Grants to Local Educational Agencies (Title I) program were due to Wisconsin Department of Public Instruction (DPI) on September 30, 2024; however, the final reimbursement claim for the Part A award was not submitted to DPI until November 18, 2024, and the CSI award was not submitted to DPI until October 1, 2024, due to an extension. Five of the 40 individuals sampled had their semi-annual certifications not approved timely and were approved after the due date of the final reimbursement claim, but before the date of the actual submission of the final reimbursement claim. An additional two individuals of the 40 sampled had their semi-annual certifications approved after the final reimbursement claims were submitted. Upon further review of all the spring semi-annual certifications for the Title I awards, there were an additional 50 individuals that had their semi-annual certifications approved by the principal after the due date of the final reimbursement claim but before the submission of the final reimbursement. Additionally, nine individuals had their semi-annual certifications approved after the final reimbursement date of the Part A award and another 59 individuals from Part A did not have their semi-annual certifications approved at all. Head Start Cluster (ALN 93.600) The final reimbursement claim for the program was submitted to the Federal agency on November 22, 2024. Four of the 40 individuals sampled had their semi-annual certifications approved by the Head Start administrator after the submission date of the final reimbursement claims. Upon further review of the all the spring semi-annual certifications, there was an additional individual that had their semi-annual certifications approved by the principal after the due date of the final reimbursement claim and another four individuals that did not have their semi-annual certifications approved at all. The samples were not statistically valid. Cause: There was a lack of internal control over the timely approval of the semi-annual certifications. Effect or Potential Effect: By not having an approved semi-annual certification before the date of the final reimbursement claims, unallowable costs may be submitted for reimbursement. Questioned Costs: The payroll costs and related fringe benefits charged at a rate of 52.48% are unallowable. Title I Grants to Local Educational Agencies (ALN 84.010) • 2024-403619-DPI-CSI-148: The two sampled individuals’ payroll and fringe benefits for the particular transaction totaled $507. • 2024-403619-DPI-TIA-141: The additional individuals' payroll and fringe benefits for the spring semi-annual certifications reviewed that were approved after the final reimbursement submission date and those that were not approved at all totaled $2,077,880. Head Start Cluster (ALN 93.600) • 05CH010537: After the additional testing, the total payroll and related fringe benefits for the spring semi-annual certifications that were approved after the final reimbursement request submission date or not approved at all totaled $241,794. Recommendations: We recommend that controls be implemented that will allow costs to be reviewed and fully supported prior to the date the final reimbursement claims are due to DPI. Views of Responsible Official: Management concurs with the finding.
Finding 2024-010 - Material Weakness - Allowable Costs/Cost Principles Federal Assistance Listing Number: 84.010, 93.600 Federal Program Name: Title I Grants to Local Educational Agencies and Head Start Cluster Federal Agency Name: U.S. Department of Education and U.S. Department of Health and Human Services Pass-Through Entity Name: Wisconsin Department of Public Instruction Pass-Through Entity Identification Number: 2024-403619-DPI-TIA-141, 2024-403619-DPI-CSI-148 Criteria: In accordance with 2 CFR 200.303(a), the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.430(i), charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Additionally, 2 CFR 200.403(g) requires that costs are adequately documented to be allowable under Federal awards. Condition/Context: The District supports time charged to federal awards via semi-annual certifications which are approved by the grant administrator or the building principal. In order for a cost to be supported at the time of final reimbursement, the semi-annual certifications should be approved by the grant administrator or the building principal. Title I Grants to Local Educational Agencies (ALN 84.010) The final reimbursement claim for the Title I Grants to Local Educational Agencies (Title I) program were due to Wisconsin Department of Public Instruction (DPI) on September 30, 2024; however, the final reimbursement claim for the Part A award was not submitted to DPI until November 18, 2024, and the CSI award was not submitted to DPI until October 1, 2024, due to an extension. Five of the 40 individuals sampled had their semi-annual certifications not approved timely and were approved after the due date of the final reimbursement claim, but before the date of the actual submission of the final reimbursement claim. An additional two individuals of the 40 sampled had their semi-annual certifications approved after the final reimbursement claims were submitted. Upon further review of all the spring semi-annual certifications for the Title I awards, there were an additional 50 individuals that had their semi-annual certifications approved by the principal after the due date of the final reimbursement claim but before the submission of the final reimbursement. Additionally, nine individuals had their semi-annual certifications approved after the final reimbursement date of the Part A award and another 59 individuals from Part A did not have their semi-annual certifications approved at all. Head Start Cluster (ALN 93.600) The final reimbursement claim for the program was submitted to the Federal agency on November 22, 2024. Four of the 40 individuals sampled had their semi-annual certifications approved by the Head Start administrator after the submission date of the final reimbursement claims. Upon further review of the all the spring semi-annual certifications, there was an additional individual that had their semi-annual certifications approved by the principal after the due date of the final reimbursement claim and another four individuals that did not have their semi-annual certifications approved at all. The samples were not statistically valid. Cause: There was a lack of internal control over the timely approval of the semi-annual certifications. Effect or Potential Effect: By not having an approved semi-annual certification before the date of the final reimbursement claims, unallowable costs may be submitted for reimbursement. Questioned Costs: The payroll costs and related fringe benefits charged at a rate of 52.48% are unallowable. Title I Grants to Local Educational Agencies (ALN 84.010) • 2024-403619-DPI-CSI-148: The two sampled individuals’ payroll and fringe benefits for the particular transaction totaled $507. • 2024-403619-DPI-TIA-141: The additional individuals' payroll and fringe benefits for the spring semi-annual certifications reviewed that were approved after the final reimbursement submission date and those that were not approved at all totaled $2,077,880. Head Start Cluster (ALN 93.600) • 05CH010537: After the additional testing, the total payroll and related fringe benefits for the spring semi-annual certifications that were approved after the final reimbursement request submission date or not approved at all totaled $241,794. Recommendations: We recommend that controls be implemented that will allow costs to be reviewed and fully supported prior to the date the final reimbursement claims are due to DPI. Views of Responsible Official: Management concurs with the finding.
Finding 2024-010 - Material Weakness - Allowable Costs/Cost Principles Federal Assistance Listing Number: 84.010, 93.600 Federal Program Name: Title I Grants to Local Educational Agencies and Head Start Cluster Federal Agency Name: U.S. Department of Education and U.S. Department of Health and Human Services Pass-Through Entity Name: Wisconsin Department of Public Instruction Pass-Through Entity Identification Number: 2024-403619-DPI-TIA-141, 2024-403619-DPI-CSI-148 Criteria: In accordance with 2 CFR 200.303(a), the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.430(i), charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Additionally, 2 CFR 200.403(g) requires that costs are adequately documented to be allowable under Federal awards. Condition/Context: The District supports time charged to federal awards via semi-annual certifications which are approved by the grant administrator or the building principal. In order for a cost to be supported at the time of final reimbursement, the semi-annual certifications should be approved by the grant administrator or the building principal. Title I Grants to Local Educational Agencies (ALN 84.010) The final reimbursement claim for the Title I Grants to Local Educational Agencies (Title I) program were due to Wisconsin Department of Public Instruction (DPI) on September 30, 2024; however, the final reimbursement claim for the Part A award was not submitted to DPI until November 18, 2024, and the CSI award was not submitted to DPI until October 1, 2024, due to an extension. Five of the 40 individuals sampled had their semi-annual certifications not approved timely and were approved after the due date of the final reimbursement claim, but before the date of the actual submission of the final reimbursement claim. An additional two individuals of the 40 sampled had their semi-annual certifications approved after the final reimbursement claims were submitted. Upon further review of all the spring semi-annual certifications for the Title I awards, there were an additional 50 individuals that had their semi-annual certifications approved by the principal after the due date of the final reimbursement claim but before the submission of the final reimbursement. Additionally, nine individuals had their semi-annual certifications approved after the final reimbursement date of the Part A award and another 59 individuals from Part A did not have their semi-annual certifications approved at all. Head Start Cluster (ALN 93.600) The final reimbursement claim for the program was submitted to the Federal agency on November 22, 2024. Four of the 40 individuals sampled had their semi-annual certifications approved by the Head Start administrator after the submission date of the final reimbursement claims. Upon further review of the all the spring semi-annual certifications, there was an additional individual that had their semi-annual certifications approved by the principal after the due date of the final reimbursement claim and another four individuals that did not have their semi-annual certifications approved at all. The samples were not statistically valid. Cause: There was a lack of internal control over the timely approval of the semi-annual certifications. Effect or Potential Effect: By not having an approved semi-annual certification before the date of the final reimbursement claims, unallowable costs may be submitted for reimbursement. Questioned Costs: The payroll costs and related fringe benefits charged at a rate of 52.48% are unallowable. Title I Grants to Local Educational Agencies (ALN 84.010) • 2024-403619-DPI-CSI-148: The two sampled individuals’ payroll and fringe benefits for the particular transaction totaled $507. • 2024-403619-DPI-TIA-141: The additional individuals' payroll and fringe benefits for the spring semi-annual certifications reviewed that were approved after the final reimbursement submission date and those that were not approved at all totaled $2,077,880. Head Start Cluster (ALN 93.600) • 05CH010537: After the additional testing, the total payroll and related fringe benefits for the spring semi-annual certifications that were approved after the final reimbursement request submission date or not approved at all totaled $241,794. Recommendations: We recommend that controls be implemented that will allow costs to be reviewed and fully supported prior to the date the final reimbursement claims are due to DPI. Views of Responsible Official: Management concurs with the finding.