Audit 5871

FY End
2023-06-30
Total Expended
$868,131
Findings
14
Programs
10
Year: 2023 Accepted: 2023-12-08

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
3710 2023-002 Significant Deficiency - N
3711 2023-001 Significant Deficiency Yes P
3712 2023-001 Significant Deficiency Yes P
3713 2023-001 Significant Deficiency Yes P
3714 2023-001 Significant Deficiency Yes P
3715 2023-001 Significant Deficiency Yes P
3716 2023-001 Significant Deficiency Yes P
580152 2023-002 Significant Deficiency - N
580153 2023-001 Significant Deficiency Yes P
580154 2023-001 Significant Deficiency Yes P
580155 2023-001 Significant Deficiency Yes P
580156 2023-001 Significant Deficiency Yes P
580157 2023-001 Significant Deficiency Yes P
580158 2023-001 Significant Deficiency Yes P

Contacts

Name Title Type
FQYST99QJYC1 Doreen Treuden Auditee
6087645431 Tara Bast Auditor
No contacts on file

Notes to SEFA

Title: REPORTING ENTITY Accounting Policies: The accompanying Schedules of Expenditures of Federal and State Awards include the federal and state grant activity of the Deerfield Community School District and are presented on the modified accrual basis of accounting. Therefore, some amounts presented in these schedules may differ from amounts presented in, or used in the preparation of the basic financial statements. De Minimis Rate Used: N Rate Explanation: The District did not elect to use the 10% de minimis indirect cost rate. The accompanying schedules of expenditures of Federal and State Awards include the federal and state grant activity of the Deerfield Community School District.
Title: SPECIAL EDUCATION AND SCHOOL AGE PARENTS PROGRAM Accounting Policies: The accompanying Schedules of Expenditures of Federal and State Awards include the federal and state grant activity of the Deerfield Community School District and are presented on the modified accrual basis of accounting. Therefore, some amounts presented in these schedules may differ from amounts presented in, or used in the preparation of the basic financial statements. De Minimis Rate Used: N Rate Explanation: The District did not elect to use the 10% de minimis indirect cost rate. 2022-2023 eligible costs under the State Special Education Program are $1,758,286.
Title: MEDICAL ASSISTANCE Accounting Policies: The accompanying Schedules of Expenditures of Federal and State Awards include the federal and state grant activity of the Deerfield Community School District and are presented on the modified accrual basis of accounting. Therefore, some amounts presented in these schedules may differ from amounts presented in, or used in the preparation of the basic financial statements. De Minimis Rate Used: N Rate Explanation: The District did not elect to use the 10% de minimis indirect cost rate. Expenditures presented for the Medicaid SBS Benefit represent only the federal funds for the program that the District receives from DHS. District records should be consulted to determine the total amount expended for this program.
Title: FOOD DISTRIBUTION Accounting Policies: The accompanying Schedules of Expenditures of Federal and State Awards include the federal and state grant activity of the Deerfield Community School District and are presented on the modified accrual basis of accounting. Therefore, some amounts presented in these schedules may differ from amounts presented in, or used in the preparation of the basic financial statements. De Minimis Rate Used: N Rate Explanation: The District did not elect to use the 10% de minimis indirect cost rate. The District received commodities totaling $45,021 that is reflected as part of the activity in program Assistance Listing #10.555.
Title: SUBRECIPIENTS Accounting Policies: The accompanying Schedules of Expenditures of Federal and State Awards include the federal and state grant activity of the Deerfield Community School District and are presented on the modified accrual basis of accounting. Therefore, some amounts presented in these schedules may differ from amounts presented in, or used in the preparation of the basic financial statements. De Minimis Rate Used: N Rate Explanation: The District did not elect to use the 10% de minimis indirect cost rate. The District did not pass-through any federal awards to subrecipients.

Finding Details

Finding #2023-002 – #84.425D COVID-19 Elementary and Secondary School Emergency Relief Fund II Federal Grantor: U.S. Department of Education Pass-through Award Number: 2022-131309-DPI-ESSERFII-163 Pass-through Entity: Wisconsin Department of Public Instruction Criteria: Wage rate requirements apply to the Education Stabilization Fund when laborers and mechanics employed by contractors or subcontractors work on construction contracts more than $2,000. Laborer must be paid wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL). Nonfederal entities shall include in their contracts subject to wage rate requirements a provision that the contractor or subcontractor complies with those requirements and the DOL regulations. This includes a requirement for the contractor or subcontractor to submit to the District weekly payrolls and a statement of compliance (certified payrolls). Condition: There was one Education Stabilization Fund construction project performed by a subcontractor. Grant expenditures for the project paid by the Education Stabilization Fund totaled $34,828. There was not a prevailing wage clause in the contract and certified payrolls were not received. Cause: The District was not aware that wage rate requirements applied to the construction project until after it was completed. Effect: A reimbursement request was made for expenditures that did not comply with wage rate requirements. Questioned Costs: $34,828. Recommendation: Establish controls to comply with wage rate requirements related to the Education Stabilization Fund. Consider determining if the contractor performing the project in 2022-2023 paid prevailing wage rates for costs reimbursed by the grant. Otherwise, the District should replace the cost with other allowable costs. Response: The District replaced the cost with other allowable costs.
Finding #2023-001 – Lack of Segregation of Duties Criteria: Internal controls should be in place that provide adequate segregation of duties and reduce overlapping accounting functions, especially in cash receipts and disbursements. In addition, those functions should be segregated from those overseeing overall finances. Condition: The responsibility for the District’s bookkeeping and accounting functions is assumed by a limited number of individuals. The Business Manager enters and approves journal entries and reconciles all bank accounts. Cause: The District has determined that hiring additional staff to perform separate accounting duties would be too costly and not an effective use of resources. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: The District should be aware of the need for separation of duties and provide for as much separation of duties as feasible in the circumstances. Response: Management of the District is aware that the current number of accounting staff does not allow for full segregation of duties. Segregation of duties is enhanced whenever possible and the Board of Education and management assumes an active roll through monthly review of receipts and disbursements and monthly financial reports. The Superintendent and Business Manager are in constant communication regarding the District’s finances. The Superintendent is not involved in processing day to day financial transactions.
Finding #2023-001 – Lack of Segregation of Duties Criteria: Internal controls should be in place that provide adequate segregation of duties and reduce overlapping accounting functions, especially in cash receipts and disbursements. In addition, those functions should be segregated from those overseeing overall finances. Condition: The responsibility for the District’s bookkeeping and accounting functions is assumed by a limited number of individuals. The Business Manager enters and approves journal entries and reconciles all bank accounts. Cause: The District has determined that hiring additional staff to perform separate accounting duties would be too costly and not an effective use of resources. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: The District should be aware of the need for separation of duties and provide for as much separation of duties as feasible in the circumstances. Response: Management of the District is aware that the current number of accounting staff does not allow for full segregation of duties. Segregation of duties is enhanced whenever possible and the Board of Education and management assumes an active roll through monthly review of receipts and disbursements and monthly financial reports. The Superintendent and Business Manager are in constant communication regarding the District’s finances. The Superintendent is not involved in processing day to day financial transactions.
Finding #2023-001 – Lack of Segregation of Duties Criteria: Internal controls should be in place that provide adequate segregation of duties and reduce overlapping accounting functions, especially in cash receipts and disbursements. In addition, those functions should be segregated from those overseeing overall finances. Condition: The responsibility for the District’s bookkeeping and accounting functions is assumed by a limited number of individuals. The Business Manager enters and approves journal entries and reconciles all bank accounts. Cause: The District has determined that hiring additional staff to perform separate accounting duties would be too costly and not an effective use of resources. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: The District should be aware of the need for separation of duties and provide for as much separation of duties as feasible in the circumstances. Response: Management of the District is aware that the current number of accounting staff does not allow for full segregation of duties. Segregation of duties is enhanced whenever possible and the Board of Education and management assumes an active roll through monthly review of receipts and disbursements and monthly financial reports. The Superintendent and Business Manager are in constant communication regarding the District’s finances. The Superintendent is not involved in processing day to day financial transactions.
Finding #2023-001 – Lack of Segregation of Duties Criteria: Internal controls should be in place that provide adequate segregation of duties and reduce overlapping accounting functions, especially in cash receipts and disbursements. In addition, those functions should be segregated from those overseeing overall finances. Condition: The responsibility for the District’s bookkeeping and accounting functions is assumed by a limited number of individuals. The Business Manager enters and approves journal entries and reconciles all bank accounts. Cause: The District has determined that hiring additional staff to perform separate accounting duties would be too costly and not an effective use of resources. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: The District should be aware of the need for separation of duties and provide for as much separation of duties as feasible in the circumstances. Response: Management of the District is aware that the current number of accounting staff does not allow for full segregation of duties. Segregation of duties is enhanced whenever possible and the Board of Education and management assumes an active roll through monthly review of receipts and disbursements and monthly financial reports. The Superintendent and Business Manager are in constant communication regarding the District’s finances. The Superintendent is not involved in processing day to day financial transactions.
Finding #2023-001 – Lack of Segregation of Duties Criteria: Internal controls should be in place that provide adequate segregation of duties and reduce overlapping accounting functions, especially in cash receipts and disbursements. In addition, those functions should be segregated from those overseeing overall finances. Condition: The responsibility for the District’s bookkeeping and accounting functions is assumed by a limited number of individuals. The Business Manager enters and approves journal entries and reconciles all bank accounts. Cause: The District has determined that hiring additional staff to perform separate accounting duties would be too costly and not an effective use of resources. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: The District should be aware of the need for separation of duties and provide for as much separation of duties as feasible in the circumstances. Response: Management of the District is aware that the current number of accounting staff does not allow for full segregation of duties. Segregation of duties is enhanced whenever possible and the Board of Education and management assumes an active roll through monthly review of receipts and disbursements and monthly financial reports. The Superintendent and Business Manager are in constant communication regarding the District’s finances. The Superintendent is not involved in processing day to day financial transactions.
Finding #2023-001 – Lack of Segregation of Duties Criteria: Internal controls should be in place that provide adequate segregation of duties and reduce overlapping accounting functions, especially in cash receipts and disbursements. In addition, those functions should be segregated from those overseeing overall finances. Condition: The responsibility for the District’s bookkeeping and accounting functions is assumed by a limited number of individuals. The Business Manager enters and approves journal entries and reconciles all bank accounts. Cause: The District has determined that hiring additional staff to perform separate accounting duties would be too costly and not an effective use of resources. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: The District should be aware of the need for separation of duties and provide for as much separation of duties as feasible in the circumstances. Response: Management of the District is aware that the current number of accounting staff does not allow for full segregation of duties. Segregation of duties is enhanced whenever possible and the Board of Education and management assumes an active roll through monthly review of receipts and disbursements and monthly financial reports. The Superintendent and Business Manager are in constant communication regarding the District’s finances. The Superintendent is not involved in processing day to day financial transactions.
Finding #2023-002 – #84.425D COVID-19 Elementary and Secondary School Emergency Relief Fund II Federal Grantor: U.S. Department of Education Pass-through Award Number: 2022-131309-DPI-ESSERFII-163 Pass-through Entity: Wisconsin Department of Public Instruction Criteria: Wage rate requirements apply to the Education Stabilization Fund when laborers and mechanics employed by contractors or subcontractors work on construction contracts more than $2,000. Laborer must be paid wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL). Nonfederal entities shall include in their contracts subject to wage rate requirements a provision that the contractor or subcontractor complies with those requirements and the DOL regulations. This includes a requirement for the contractor or subcontractor to submit to the District weekly payrolls and a statement of compliance (certified payrolls). Condition: There was one Education Stabilization Fund construction project performed by a subcontractor. Grant expenditures for the project paid by the Education Stabilization Fund totaled $34,828. There was not a prevailing wage clause in the contract and certified payrolls were not received. Cause: The District was not aware that wage rate requirements applied to the construction project until after it was completed. Effect: A reimbursement request was made for expenditures that did not comply with wage rate requirements. Questioned Costs: $34,828. Recommendation: Establish controls to comply with wage rate requirements related to the Education Stabilization Fund. Consider determining if the contractor performing the project in 2022-2023 paid prevailing wage rates for costs reimbursed by the grant. Otherwise, the District should replace the cost with other allowable costs. Response: The District replaced the cost with other allowable costs.
Finding #2023-001 – Lack of Segregation of Duties Criteria: Internal controls should be in place that provide adequate segregation of duties and reduce overlapping accounting functions, especially in cash receipts and disbursements. In addition, those functions should be segregated from those overseeing overall finances. Condition: The responsibility for the District’s bookkeeping and accounting functions is assumed by a limited number of individuals. The Business Manager enters and approves journal entries and reconciles all bank accounts. Cause: The District has determined that hiring additional staff to perform separate accounting duties would be too costly and not an effective use of resources. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: The District should be aware of the need for separation of duties and provide for as much separation of duties as feasible in the circumstances. Response: Management of the District is aware that the current number of accounting staff does not allow for full segregation of duties. Segregation of duties is enhanced whenever possible and the Board of Education and management assumes an active roll through monthly review of receipts and disbursements and monthly financial reports. The Superintendent and Business Manager are in constant communication regarding the District’s finances. The Superintendent is not involved in processing day to day financial transactions.
Finding #2023-001 – Lack of Segregation of Duties Criteria: Internal controls should be in place that provide adequate segregation of duties and reduce overlapping accounting functions, especially in cash receipts and disbursements. In addition, those functions should be segregated from those overseeing overall finances. Condition: The responsibility for the District’s bookkeeping and accounting functions is assumed by a limited number of individuals. The Business Manager enters and approves journal entries and reconciles all bank accounts. Cause: The District has determined that hiring additional staff to perform separate accounting duties would be too costly and not an effective use of resources. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: The District should be aware of the need for separation of duties and provide for as much separation of duties as feasible in the circumstances. Response: Management of the District is aware that the current number of accounting staff does not allow for full segregation of duties. Segregation of duties is enhanced whenever possible and the Board of Education and management assumes an active roll through monthly review of receipts and disbursements and monthly financial reports. The Superintendent and Business Manager are in constant communication regarding the District’s finances. The Superintendent is not involved in processing day to day financial transactions.
Finding #2023-001 – Lack of Segregation of Duties Criteria: Internal controls should be in place that provide adequate segregation of duties and reduce overlapping accounting functions, especially in cash receipts and disbursements. In addition, those functions should be segregated from those overseeing overall finances. Condition: The responsibility for the District’s bookkeeping and accounting functions is assumed by a limited number of individuals. The Business Manager enters and approves journal entries and reconciles all bank accounts. Cause: The District has determined that hiring additional staff to perform separate accounting duties would be too costly and not an effective use of resources. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: The District should be aware of the need for separation of duties and provide for as much separation of duties as feasible in the circumstances. Response: Management of the District is aware that the current number of accounting staff does not allow for full segregation of duties. Segregation of duties is enhanced whenever possible and the Board of Education and management assumes an active roll through monthly review of receipts and disbursements and monthly financial reports. The Superintendent and Business Manager are in constant communication regarding the District’s finances. The Superintendent is not involved in processing day to day financial transactions.
Finding #2023-001 – Lack of Segregation of Duties Criteria: Internal controls should be in place that provide adequate segregation of duties and reduce overlapping accounting functions, especially in cash receipts and disbursements. In addition, those functions should be segregated from those overseeing overall finances. Condition: The responsibility for the District’s bookkeeping and accounting functions is assumed by a limited number of individuals. The Business Manager enters and approves journal entries and reconciles all bank accounts. Cause: The District has determined that hiring additional staff to perform separate accounting duties would be too costly and not an effective use of resources. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: The District should be aware of the need for separation of duties and provide for as much separation of duties as feasible in the circumstances. Response: Management of the District is aware that the current number of accounting staff does not allow for full segregation of duties. Segregation of duties is enhanced whenever possible and the Board of Education and management assumes an active roll through monthly review of receipts and disbursements and monthly financial reports. The Superintendent and Business Manager are in constant communication regarding the District’s finances. The Superintendent is not involved in processing day to day financial transactions.
Finding #2023-001 – Lack of Segregation of Duties Criteria: Internal controls should be in place that provide adequate segregation of duties and reduce overlapping accounting functions, especially in cash receipts and disbursements. In addition, those functions should be segregated from those overseeing overall finances. Condition: The responsibility for the District’s bookkeeping and accounting functions is assumed by a limited number of individuals. The Business Manager enters and approves journal entries and reconciles all bank accounts. Cause: The District has determined that hiring additional staff to perform separate accounting duties would be too costly and not an effective use of resources. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: The District should be aware of the need for separation of duties and provide for as much separation of duties as feasible in the circumstances. Response: Management of the District is aware that the current number of accounting staff does not allow for full segregation of duties. Segregation of duties is enhanced whenever possible and the Board of Education and management assumes an active roll through monthly review of receipts and disbursements and monthly financial reports. The Superintendent and Business Manager are in constant communication regarding the District’s finances. The Superintendent is not involved in processing day to day financial transactions.
Finding #2023-001 – Lack of Segregation of Duties Criteria: Internal controls should be in place that provide adequate segregation of duties and reduce overlapping accounting functions, especially in cash receipts and disbursements. In addition, those functions should be segregated from those overseeing overall finances. Condition: The responsibility for the District’s bookkeeping and accounting functions is assumed by a limited number of individuals. The Business Manager enters and approves journal entries and reconciles all bank accounts. Cause: The District has determined that hiring additional staff to perform separate accounting duties would be too costly and not an effective use of resources. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: The District should be aware of the need for separation of duties and provide for as much separation of duties as feasible in the circumstances. Response: Management of the District is aware that the current number of accounting staff does not allow for full segregation of duties. Segregation of duties is enhanced whenever possible and the Board of Education and management assumes an active roll through monthly review of receipts and disbursements and monthly financial reports. The Superintendent and Business Manager are in constant communication regarding the District’s finances. The Superintendent is not involved in processing day to day financial transactions.