Audit 337672

FY End
2024-06-30
Total Expended
$864,358
Findings
6
Programs
7
Year: 2024 Accepted: 2025-01-14

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
519146 2024-002 Material Weakness - B
519147 2024-002 Material Weakness - B
519148 2024-002 Material Weakness - B
1095588 2024-002 Material Weakness - B
1095589 2024-002 Material Weakness - B
1095590 2024-002 Material Weakness - B

Contacts

Name Title Type
MRZNELVMKWN4 Courtney Rounds Auditee
6088223276 Brent Nelson Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedules of expenditures of federal and state awards include the federal and state grant activity of the Cooperative Educational Service Agency #3 and are presented on the modified accrual basis of accounting. The information in these schedules is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) and the State Single Audit Guidelines. Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the financial statements. De Minimis Rate Used: N Rate Explanation: The Cooperative Educational Service Agency #3 does not use the 10 percent de minimis indirect cost rate.

Finding Details

Finding #2024-002 Wage Allocations (Program Affected - Career and Technical Education – Basic Grants to States (Assistance Listing No. 84.048) and Youth Apprenticeship (State Program ID No. 445.107) Condition: Wages and benefits charged to the Career and Technical Education – Basic Grants to States and Youth Apprenticeship were based on projected staff time and not the actual activity of each employee from the Agency’s time management system. Criteria: When wages and benefits are allocated to multiple programs, the costs claimed for reimbursement should be based on the actual time spent. Supporting documentation must be maintained to support how each employee is allocated. When making grant claims, payroll costs coded to the grant project in the general ledger should be compared to the time management system. Cause: The Agency projected staff time at the beginning of the year. Actual hours worked by employees in the time management system did not match the projected staff time recorded to the grants in the general ledger. These grants were not adjusted to match actual staff time. Effect: The costs charged to the grant may not reflect the actual time and effort spent by the employees. Recommendation: We recommend the projected staff time charged to projects be adjusted to actual costs at least annually when there are significant differences between projected and actual time. Response: The Agency reviews time sheets in Harvest whenever grant claims are made to ensure proper work has been completed and proper work time is claimed under grants. The reports are submitted by each employee and reviewed by management.
Finding #2024-002 Wage Allocations (Program Affected - Career and Technical Education – Basic Grants to States (Assistance Listing No. 84.048) and Youth Apprenticeship (State Program ID No. 445.107) Condition: Wages and benefits charged to the Career and Technical Education – Basic Grants to States and Youth Apprenticeship were based on projected staff time and not the actual activity of each employee from the Agency’s time management system. Criteria: When wages and benefits are allocated to multiple programs, the costs claimed for reimbursement should be based on the actual time spent. Supporting documentation must be maintained to support how each employee is allocated. When making grant claims, payroll costs coded to the grant project in the general ledger should be compared to the time management system. Cause: The Agency projected staff time at the beginning of the year. Actual hours worked by employees in the time management system did not match the projected staff time recorded to the grants in the general ledger. These grants were not adjusted to match actual staff time. Effect: The costs charged to the grant may not reflect the actual time and effort spent by the employees. Recommendation: We recommend the projected staff time charged to projects be adjusted to actual costs at least annually when there are significant differences between projected and actual time. Response: The Agency reviews time sheets in Harvest whenever grant claims are made to ensure proper work has been completed and proper work time is claimed under grants. The reports are submitted by each employee and reviewed by management.
Finding #2024-002 Wage Allocations (Program Affected - Career and Technical Education – Basic Grants to States (Assistance Listing No. 84.048) and Youth Apprenticeship (State Program ID No. 445.107) Condition: Wages and benefits charged to the Career and Technical Education – Basic Grants to States and Youth Apprenticeship were based on projected staff time and not the actual activity of each employee from the Agency’s time management system. Criteria: When wages and benefits are allocated to multiple programs, the costs claimed for reimbursement should be based on the actual time spent. Supporting documentation must be maintained to support how each employee is allocated. When making grant claims, payroll costs coded to the grant project in the general ledger should be compared to the time management system. Cause: The Agency projected staff time at the beginning of the year. Actual hours worked by employees in the time management system did not match the projected staff time recorded to the grants in the general ledger. These grants were not adjusted to match actual staff time. Effect: The costs charged to the grant may not reflect the actual time and effort spent by the employees. Recommendation: We recommend the projected staff time charged to projects be adjusted to actual costs at least annually when there are significant differences between projected and actual time. Response: The Agency reviews time sheets in Harvest whenever grant claims are made to ensure proper work has been completed and proper work time is claimed under grants. The reports are submitted by each employee and reviewed by management.
Finding #2024-002 Wage Allocations (Program Affected - Career and Technical Education – Basic Grants to States (Assistance Listing No. 84.048) and Youth Apprenticeship (State Program ID No. 445.107) Condition: Wages and benefits charged to the Career and Technical Education – Basic Grants to States and Youth Apprenticeship were based on projected staff time and not the actual activity of each employee from the Agency’s time management system. Criteria: When wages and benefits are allocated to multiple programs, the costs claimed for reimbursement should be based on the actual time spent. Supporting documentation must be maintained to support how each employee is allocated. When making grant claims, payroll costs coded to the grant project in the general ledger should be compared to the time management system. Cause: The Agency projected staff time at the beginning of the year. Actual hours worked by employees in the time management system did not match the projected staff time recorded to the grants in the general ledger. These grants were not adjusted to match actual staff time. Effect: The costs charged to the grant may not reflect the actual time and effort spent by the employees. Recommendation: We recommend the projected staff time charged to projects be adjusted to actual costs at least annually when there are significant differences between projected and actual time. Response: The Agency reviews time sheets in Harvest whenever grant claims are made to ensure proper work has been completed and proper work time is claimed under grants. The reports are submitted by each employee and reviewed by management.
Finding #2024-002 Wage Allocations (Program Affected - Career and Technical Education – Basic Grants to States (Assistance Listing No. 84.048) and Youth Apprenticeship (State Program ID No. 445.107) Condition: Wages and benefits charged to the Career and Technical Education – Basic Grants to States and Youth Apprenticeship were based on projected staff time and not the actual activity of each employee from the Agency’s time management system. Criteria: When wages and benefits are allocated to multiple programs, the costs claimed for reimbursement should be based on the actual time spent. Supporting documentation must be maintained to support how each employee is allocated. When making grant claims, payroll costs coded to the grant project in the general ledger should be compared to the time management system. Cause: The Agency projected staff time at the beginning of the year. Actual hours worked by employees in the time management system did not match the projected staff time recorded to the grants in the general ledger. These grants were not adjusted to match actual staff time. Effect: The costs charged to the grant may not reflect the actual time and effort spent by the employees. Recommendation: We recommend the projected staff time charged to projects be adjusted to actual costs at least annually when there are significant differences between projected and actual time. Response: The Agency reviews time sheets in Harvest whenever grant claims are made to ensure proper work has been completed and proper work time is claimed under grants. The reports are submitted by each employee and reviewed by management.
Finding #2024-002 Wage Allocations (Program Affected - Career and Technical Education – Basic Grants to States (Assistance Listing No. 84.048) and Youth Apprenticeship (State Program ID No. 445.107) Condition: Wages and benefits charged to the Career and Technical Education – Basic Grants to States and Youth Apprenticeship were based on projected staff time and not the actual activity of each employee from the Agency’s time management system. Criteria: When wages and benefits are allocated to multiple programs, the costs claimed for reimbursement should be based on the actual time spent. Supporting documentation must be maintained to support how each employee is allocated. When making grant claims, payroll costs coded to the grant project in the general ledger should be compared to the time management system. Cause: The Agency projected staff time at the beginning of the year. Actual hours worked by employees in the time management system did not match the projected staff time recorded to the grants in the general ledger. These grants were not adjusted to match actual staff time. Effect: The costs charged to the grant may not reflect the actual time and effort spent by the employees. Recommendation: We recommend the projected staff time charged to projects be adjusted to actual costs at least annually when there are significant differences between projected and actual time. Response: The Agency reviews time sheets in Harvest whenever grant claims are made to ensure proper work has been completed and proper work time is claimed under grants. The reports are submitted by each employee and reviewed by management.