Audit 63134

FY End
2022-06-30
Total Expended
$2.12M
Findings
14
Programs
12
Organization: Markesan District Schools (WI)
Year: 2022 Accepted: 2023-03-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
71635 2022-001 Significant Deficiency Yes P
71636 2022-001 Significant Deficiency Yes P
71637 2022-001 Significant Deficiency Yes P
71638 2022-001 Significant Deficiency Yes P
71639 2022-002 Significant Deficiency Yes N
71640 2022-001 Significant Deficiency Yes P
71641 2022-002 Significant Deficiency Yes N
648077 2022-001 Significant Deficiency Yes P
648078 2022-001 Significant Deficiency Yes P
648079 2022-001 Significant Deficiency Yes P
648080 2022-001 Significant Deficiency Yes P
648081 2022-002 Significant Deficiency Yes N
648082 2022-001 Significant Deficiency Yes P
648083 2022-002 Significant Deficiency Yes N

Programs

ALN Program Spent Major Findings
10.555 National School Lunch Program $435,675 Yes 1
84.010 Title I Grants to Local Educational Agencies $329,197 - 0
84.027 Special Education_grants to States $248,685 - 0
93.778 Medical Assistance Program $105,861 - 0
32.009 Emergency Connectivity Fund Program $67,275 - 0
10.553 School Breakfast Program $60,527 Yes 1
84.424 Student Support and Academic Enrichment Program $40,866 - 0
84.048 Career and Technical Education -- Basic Grants to States $8,952 - 0
84.173 Special Education_preschool Grants $8,872 - 0
84.358 Rural Education $6,301 - 0
84.425 Education Stabilization Fund $2,646 Yes 0
10.649 Pandemic Ebt Administrative Costs $614 - 0

Contacts

Name Title Type
SUHHBDNMM315 Jason Breaker Auditee
9203984302 Brent Nelson Auditor
No contacts on file

Notes to SEFA

Title: Sub recipients Accounting Policies: The accompanying schedules of expenditures of federal and state awards include the federal and state grant activity of the Markesan District Schools and are presented on the modified accrual basis of accounting. The information in these schedules are presented in accordance with the requirements of Title 2. U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) and the State Single Audit Guidelines, issued by the Wisconsin Department of Administration. 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 auditee did not use the de minimis cost rate. No grants were passed through to sub recipients.
Title: Special Education and School Age Parents Accounting Policies: The accompanying schedules of expenditures of federal and state awards include the federal and state grant activity of the Markesan District Schools and are presented on the modified accrual basis of accounting. The information in these schedules are presented in accordance with the requirements of Title 2. U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) and the State Single Audit Guidelines, issued by the Wisconsin Department of Administration. 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 auditee did not use the de minimis cost rate. 2021-2022 eligible costs under the State Special Education Program are $847,463. The 2022-2023 aid estimate is $228,815.
Title: Medical Assistance Program Accounting Policies: The accompanying schedules of expenditures of federal and state awards include the federal and state grant activity of the Markesan District Schools and are presented on the modified accrual basis of accounting. The information in these schedules are presented in accordance with the requirements of Title 2. U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) and the State Single Audit Guidelines, issued by the Wisconsin Department of Administration. 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 auditee did not use the de minimis cost rate. Expenditures presented for the Medical Assistance Program School Based Services represent only the federal funds received from the Wisconsin Department of Health Services. District records should be consulted to determine the total amount expended for this program.
Title: Food Distributions Accounting Policies: The accompanying schedules of expenditures of federal and state awards include the federal and state grant activity of the Markesan District Schools and are presented on the modified accrual basis of accounting. The information in these schedules are presented in accordance with the requirements of Title 2. U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) and the State Single Audit Guidelines, issued by the Wisconsin Department of Administration. 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 auditee did not use the de minimis cost rate. Nonmonetary assistance is reported in the schedule at the fair market value of the commodities received and disbursed.

Finding Details

Condition: The available office staff precludes a proper segregation of duties in the control areas reviewed. Criteria: Checks and balances should be in place to allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct any misstatements on a timely basis. Cause: A small number of individuals within the District?s administration perform substantially all accounting functions and have control over both records and assets. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: Procedures should be implemented segregating duties among different employees. Management should continue to maintain a working knowledge of matters relating to the district?s operations. Response: We agree and will continue to provide supervision and monitor accounting information and operations, obtain explanations for variances from unexpected results and work to increase segregation of duties. The Assistant to the Business Manager will continue to clear checks in Skyward as part of the bank reconciliation process. The District Administrator will review and initial all journal entries. The Assistant to the Business Manager will review payroll on a monthly basis, and the District Administrator will review payroll on a quarterly basis.
Condition: The available office staff precludes a proper segregation of duties in the control areas reviewed. Criteria: Checks and balances should be in place to allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct any misstatements on a timely basis. Cause: A small number of individuals within the District?s administration perform substantially all accounting functions and have control over both records and assets. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: Procedures should be implemented segregating duties among different employees. Management should continue to maintain a working knowledge of matters relating to the district?s operations. Response: We agree and will continue to provide supervision and monitor accounting information and operations, obtain explanations for variances from unexpected results and work to increase segregation of duties. The Assistant to the Business Manager will continue to clear checks in Skyward as part of the bank reconciliation process. The District Administrator will review and initial all journal entries. The Assistant to the Business Manager will review payroll on a monthly basis, and the District Administrator will review payroll on a quarterly basis.
Condition: The available office staff precludes a proper segregation of duties in the control areas reviewed. Criteria: Checks and balances should be in place to allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct any misstatements on a timely basis. Cause: A small number of individuals within the District?s administration perform substantially all accounting functions and have control over both records and assets. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: Procedures should be implemented segregating duties among different employees. Management should continue to maintain a working knowledge of matters relating to the district?s operations. Response: We agree and will continue to provide supervision and monitor accounting information and operations, obtain explanations for variances from unexpected results and work to increase segregation of duties. The Assistant to the Business Manager will continue to clear checks in Skyward as part of the bank reconciliation process. The District Administrator will review and initial all journal entries. The Assistant to the Business Manager will review payroll on a monthly basis, and the District Administrator will review payroll on a quarterly basis.
Condition: The available office staff precludes a proper segregation of duties in the control areas reviewed. Criteria: Checks and balances should be in place to allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct any misstatements on a timely basis. Cause: A small number of individuals within the District?s administration perform substantially all accounting functions and have control over both records and assets. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: Procedures should be implemented segregating duties among different employees. Management should continue to maintain a working knowledge of matters relating to the district?s operations. Response: We agree and will continue to provide supervision and monitor accounting information and operations, obtain explanations for variances from unexpected results and work to increase segregation of duties. The Assistant to the Business Manager will continue to clear checks in Skyward as part of the bank reconciliation process. The District Administrator will review and initial all journal entries. The Assistant to the Business Manager will review payroll on a monthly basis, and the District Administrator will review payroll on a quarterly basis.
Condition: There were Education Stabilization Fund construction projects performed by contractors. Grant expenditures for the projects totaled $770,436. (ESSER II - $401,545 and ESSER III $368,891). There was not a prevailing wage clause in the contracts and certified payrolls were not received. Questioned Costs: $770,436 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. Laborers 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 comply with those requirements and the DOL regulations. This includes a requirement of the contractor or subcontractor to submit to the District weekly payrolls and a statement of compliance (certified payrolls). Cause: The District was not aware that the wage requirement applied to these construction projects. Effect: Potential reimbursement for costs that did not follow the wage rate requirements. Context: The Public address system, HVAC, and water heater construction projects began in May, June, and September 2021, respectively, before the District was aware of wage rate requirements. After becoming aware of the requirement, there were no further construction projects. Recommendation: Establish controls to comply with wage rate requirements related to the Education Stabilization Fund. Response: The District became aware of wage rate requirements after finishing the project. Before bidding any future construction projects more than $2,000, the request for bid and contract will include a prevailing wage rate clause. Certified payrolls will be received for any such contracts.
Condition: The available office staff precludes a proper segregation of duties in the control areas reviewed. Criteria: Checks and balances should be in place to allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct any misstatements on a timely basis. Cause: A small number of individuals within the District?s administration perform substantially all accounting functions and have control over both records and assets. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: Procedures should be implemented segregating duties among different employees. Management should continue to maintain a working knowledge of matters relating to the district?s operations. Response: We agree and will continue to provide supervision and monitor accounting information and operations, obtain explanations for variances from unexpected results and work to increase segregation of duties. The Assistant to the Business Manager will continue to clear checks in Skyward as part of the bank reconciliation process. The District Administrator will review and initial all journal entries. The Assistant to the Business Manager will review payroll on a monthly basis, and the District Administrator will review payroll on a quarterly basis.
Condition: There were Education Stabilization Fund construction projects performed by contractors. Grant expenditures for the projects totaled $770,436. (ESSER II - $401,545 and ESSER III $368,891). There was not a prevailing wage clause in the contracts and certified payrolls were not received. Questioned Costs: $770,436 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. Laborers 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 comply with those requirements and the DOL regulations. This includes a requirement of the contractor or subcontractor to submit to the District weekly payrolls and a statement of compliance (certified payrolls). Cause: The District was not aware that the wage requirement applied to these construction projects. Effect: Potential reimbursement for costs that did not follow the wage rate requirements. Context: The Public address system, HVAC, and water heater construction projects began in May, June, and September 2021, respectively, before the District was aware of wage rate requirements. After becoming aware of the requirement, there were no further construction projects. Recommendation: Establish controls to comply with wage rate requirements related to the Education Stabilization Fund. Response: The District became aware of wage rate requirements after finishing the project. Before bidding any future construction projects more than $2,000, the request for bid and contract will include a prevailing wage rate clause. Certified payrolls will be received for any such contracts.
Condition: The available office staff precludes a proper segregation of duties in the control areas reviewed. Criteria: Checks and balances should be in place to allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct any misstatements on a timely basis. Cause: A small number of individuals within the District?s administration perform substantially all accounting functions and have control over both records and assets. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: Procedures should be implemented segregating duties among different employees. Management should continue to maintain a working knowledge of matters relating to the district?s operations. Response: We agree and will continue to provide supervision and monitor accounting information and operations, obtain explanations for variances from unexpected results and work to increase segregation of duties. The Assistant to the Business Manager will continue to clear checks in Skyward as part of the bank reconciliation process. The District Administrator will review and initial all journal entries. The Assistant to the Business Manager will review payroll on a monthly basis, and the District Administrator will review payroll on a quarterly basis.
Condition: The available office staff precludes a proper segregation of duties in the control areas reviewed. Criteria: Checks and balances should be in place to allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct any misstatements on a timely basis. Cause: A small number of individuals within the District?s administration perform substantially all accounting functions and have control over both records and assets. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: Procedures should be implemented segregating duties among different employees. Management should continue to maintain a working knowledge of matters relating to the district?s operations. Response: We agree and will continue to provide supervision and monitor accounting information and operations, obtain explanations for variances from unexpected results and work to increase segregation of duties. The Assistant to the Business Manager will continue to clear checks in Skyward as part of the bank reconciliation process. The District Administrator will review and initial all journal entries. The Assistant to the Business Manager will review payroll on a monthly basis, and the District Administrator will review payroll on a quarterly basis.
Condition: The available office staff precludes a proper segregation of duties in the control areas reviewed. Criteria: Checks and balances should be in place to allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct any misstatements on a timely basis. Cause: A small number of individuals within the District?s administration perform substantially all accounting functions and have control over both records and assets. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: Procedures should be implemented segregating duties among different employees. Management should continue to maintain a working knowledge of matters relating to the district?s operations. Response: We agree and will continue to provide supervision and monitor accounting information and operations, obtain explanations for variances from unexpected results and work to increase segregation of duties. The Assistant to the Business Manager will continue to clear checks in Skyward as part of the bank reconciliation process. The District Administrator will review and initial all journal entries. The Assistant to the Business Manager will review payroll on a monthly basis, and the District Administrator will review payroll on a quarterly basis.
Condition: The available office staff precludes a proper segregation of duties in the control areas reviewed. Criteria: Checks and balances should be in place to allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct any misstatements on a timely basis. Cause: A small number of individuals within the District?s administration perform substantially all accounting functions and have control over both records and assets. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: Procedures should be implemented segregating duties among different employees. Management should continue to maintain a working knowledge of matters relating to the district?s operations. Response: We agree and will continue to provide supervision and monitor accounting information and operations, obtain explanations for variances from unexpected results and work to increase segregation of duties. The Assistant to the Business Manager will continue to clear checks in Skyward as part of the bank reconciliation process. The District Administrator will review and initial all journal entries. The Assistant to the Business Manager will review payroll on a monthly basis, and the District Administrator will review payroll on a quarterly basis.
Condition: There were Education Stabilization Fund construction projects performed by contractors. Grant expenditures for the projects totaled $770,436. (ESSER II - $401,545 and ESSER III $368,891). There was not a prevailing wage clause in the contracts and certified payrolls were not received. Questioned Costs: $770,436 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. Laborers 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 comply with those requirements and the DOL regulations. This includes a requirement of the contractor or subcontractor to submit to the District weekly payrolls and a statement of compliance (certified payrolls). Cause: The District was not aware that the wage requirement applied to these construction projects. Effect: Potential reimbursement for costs that did not follow the wage rate requirements. Context: The Public address system, HVAC, and water heater construction projects began in May, June, and September 2021, respectively, before the District was aware of wage rate requirements. After becoming aware of the requirement, there were no further construction projects. Recommendation: Establish controls to comply with wage rate requirements related to the Education Stabilization Fund. Response: The District became aware of wage rate requirements after finishing the project. Before bidding any future construction projects more than $2,000, the request for bid and contract will include a prevailing wage rate clause. Certified payrolls will be received for any such contracts.
Condition: The available office staff precludes a proper segregation of duties in the control areas reviewed. Criteria: Checks and balances should be in place to allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct any misstatements on a timely basis. Cause: A small number of individuals within the District?s administration perform substantially all accounting functions and have control over both records and assets. Effect: Because of the lack of segregation of duties, errors or irregularities could occur and not be detected on a timely basis. Recommendation: Procedures should be implemented segregating duties among different employees. Management should continue to maintain a working knowledge of matters relating to the district?s operations. Response: We agree and will continue to provide supervision and monitor accounting information and operations, obtain explanations for variances from unexpected results and work to increase segregation of duties. The Assistant to the Business Manager will continue to clear checks in Skyward as part of the bank reconciliation process. The District Administrator will review and initial all journal entries. The Assistant to the Business Manager will review payroll on a monthly basis, and the District Administrator will review payroll on a quarterly basis.
Condition: There were Education Stabilization Fund construction projects performed by contractors. Grant expenditures for the projects totaled $770,436. (ESSER II - $401,545 and ESSER III $368,891). There was not a prevailing wage clause in the contracts and certified payrolls were not received. Questioned Costs: $770,436 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. Laborers 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 comply with those requirements and the DOL regulations. This includes a requirement of the contractor or subcontractor to submit to the District weekly payrolls and a statement of compliance (certified payrolls). Cause: The District was not aware that the wage requirement applied to these construction projects. Effect: Potential reimbursement for costs that did not follow the wage rate requirements. Context: The Public address system, HVAC, and water heater construction projects began in May, June, and September 2021, respectively, before the District was aware of wage rate requirements. After becoming aware of the requirement, there were no further construction projects. Recommendation: Establish controls to comply with wage rate requirements related to the Education Stabilization Fund. Response: The District became aware of wage rate requirements after finishing the project. Before bidding any future construction projects more than $2,000, the request for bid and contract will include a prevailing wage rate clause. Certified payrolls will be received for any such contracts.