Audit 7185

FY End
2023-06-30
Total Expended
$1.86M
Findings
2
Programs
12
Year: 2023 Accepted: 2023-12-18

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
4938 2023-003 Material Weakness - P
581380 2023-003 Material Weakness - P

Contacts

Name Title Type
DHLXHSL3WZ85 Kimberly Moede Auditee
7152532211 Amber Danielski, CPA Cma Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: Revenues and expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with revenues and expenditures reported in the District’s 2023 fund financial statements. Accrued revenue at year-end consists of federal and state program expenditures scheduled for reimbursement to the District in the succeeding year while unearned revenue represents advances for federal and state programs that exceed recorded District expenditures. Because of subsequent program adjustments, these amounts may differ from the prior year’s ending balances. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the schedules of expenditures of federal and state awards represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The District has not elected to charge a de minimis rate of 10% of modified total costs. The accompanying schedules of expenditures of federal and state awards for the District are 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 issued by the Wisconsin Department of Administration. The schedules of expenditures of federal and state awards include all federal and state awards of the District. Because the schedules present only a selected portion of the operations of the District, it is not intended to and does not present the financial position, changes in net position, or cash flows of the District.
Title: FOOD DISTRIBUTION Accounting Policies: Revenues and expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with revenues and expenditures reported in the District’s 2023 fund financial statements. Accrued revenue at year-end consists of federal and state program expenditures scheduled for reimbursement to the District in the succeeding year while unearned revenue represents advances for federal and state programs that exceed recorded District expenditures. Because of subsequent program adjustments, these amounts may differ from the prior year’s ending balances. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the schedules of expenditures of federal and state awards represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The District has not elected to charge a de minimis rate of 10% of modified total costs. Nonmonetary assistance is reported in the schedule of expenditures of federal awards at the fair market value of the commodities received and disbursed.
Title: OVERSIGHT AGENCIES Accounting Policies: Revenues and expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with revenues and expenditures reported in the District’s 2023 fund financial statements. Accrued revenue at year-end consists of federal and state program expenditures scheduled for reimbursement to the District in the succeeding year while unearned revenue represents advances for federal and state programs that exceed recorded District expenditures. Because of subsequent program adjustments, these amounts may differ from the prior year’s ending balances. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the schedules of expenditures of federal and state awards represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The District has not elected to charge a de minimis rate of 10% of modified total costs. The federal and state oversight agencies for the District are as follows: Federal – U.S. Department of Education State – Wisconsin Department of Public Instruction
Title: PASS-THROUGH ENTITIES Accounting Policies: Revenues and expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with revenues and expenditures reported in the District’s 2023 fund financial statements. Accrued revenue at year-end consists of federal and state program expenditures scheduled for reimbursement to the District in the succeeding year while unearned revenue represents advances for federal and state programs that exceed recorded District expenditures. Because of subsequent program adjustments, these amounts may differ from the prior year’s ending balances. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the schedules of expenditures of federal and state awards represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The District has not elected to charge a de minimis rate of 10% of modified total costs. Federal and state awards have been passed through the following entities: WI DHS – Wisconsin Department of Health Services WI DPI – Wisconsin Department of Public Instruction CESA #8 – Cooperative Educational Services Agency #8 CESA #2 – Cooperative Educational Services Agency #2

Finding Details

Segregation of Duties - ESSER Federal Agency: US Department of Education Federal Program Name: Elementary and Secondary School Emergency Relief Assistance Listing Number: 84.425U Federal Award Identification Number and Year: S425U210044 Pass-Through Agency: Wisconsin Department of Public Instruction Pass-Through Number(s): 2022-586692-DPI-ESSERFIII-165 Award Period: 3/13/2020-9/30/2024 Type of Finding: • Material Weakness in Internal Control over Compliance Criteria or Specific Requirement: Segregation of duties is an internal control intended to prevent or decrease the occurrence of errors or intentional fraud. Segregation of duties ensures that no single employee has control over all phases of a transaction. Condition: The District has one position that handles all payroll related transactions from setting up new employees and entering wage rates to processing time cards each pay period to preparing the direct deposit transfer for each pay period. The District Accountant and Superintendent collaborated in preparing the annual report but there was no review of the data entered into DPI's Wisegrants system by the accountant prior to submitting it. Accordingly, this does not allow for a proper segregation of duties for internal control purposes. Questioned Costs: None Context: When pulling documentation for our initial payroll sample for testing, the District found that it had the incorrect wage rate in the payroll system and had underpaid one employee for the entire school year. There were no exceptions noted in the rest of our payroll sample testing. When reviewing the annual report, it was noted that the District Accountant and Superintendent collaborated in preparing the report, but no one reviewed report before submitting the document to Wisconsin Department of Public Instruction. Cause: The lack of segregation of duties is due to the limited number of employees and the size of the District’s operations. In addition, the annual report was a new report for 2022-23 and the employee that normally reviews reports assisted the Accountant in preparing the report instead. Effect: Errors or intentional fraud could occur and not be detected timely by other employees in the normal course of their responsibilities as a result of the lack of segregation of duties. Repeat Finding: No. Recommendation: We recommend the District review its processes related to entering approved wage rates and salary amounts into the payroll system and implement a control where someone other than the payroll position review a report of all payroll rate changes and compare that to Board approved rates to help ensure the proper amount is used. We also recommend that the District implement a formal review process over the reporting requirement relating to ESSER annual reports. View of Responsible Officials: There is no disagreement with the audit finding.
Segregation of Duties - ESSER Federal Agency: US Department of Education Federal Program Name: Elementary and Secondary School Emergency Relief Assistance Listing Number: 84.425U Federal Award Identification Number and Year: S425U210044 Pass-Through Agency: Wisconsin Department of Public Instruction Pass-Through Number(s): 2022-586692-DPI-ESSERFIII-165 Award Period: 3/13/2020-9/30/2024 Type of Finding: • Material Weakness in Internal Control over Compliance Criteria or Specific Requirement: Segregation of duties is an internal control intended to prevent or decrease the occurrence of errors or intentional fraud. Segregation of duties ensures that no single employee has control over all phases of a transaction. Condition: The District has one position that handles all payroll related transactions from setting up new employees and entering wage rates to processing time cards each pay period to preparing the direct deposit transfer for each pay period. The District Accountant and Superintendent collaborated in preparing the annual report but there was no review of the data entered into DPI's Wisegrants system by the accountant prior to submitting it. Accordingly, this does not allow for a proper segregation of duties for internal control purposes. Questioned Costs: None Context: When pulling documentation for our initial payroll sample for testing, the District found that it had the incorrect wage rate in the payroll system and had underpaid one employee for the entire school year. There were no exceptions noted in the rest of our payroll sample testing. When reviewing the annual report, it was noted that the District Accountant and Superintendent collaborated in preparing the report, but no one reviewed report before submitting the document to Wisconsin Department of Public Instruction. Cause: The lack of segregation of duties is due to the limited number of employees and the size of the District’s operations. In addition, the annual report was a new report for 2022-23 and the employee that normally reviews reports assisted the Accountant in preparing the report instead. Effect: Errors or intentional fraud could occur and not be detected timely by other employees in the normal course of their responsibilities as a result of the lack of segregation of duties. Repeat Finding: No. Recommendation: We recommend the District review its processes related to entering approved wage rates and salary amounts into the payroll system and implement a control where someone other than the payroll position review a report of all payroll rate changes and compare that to Board approved rates to help ensure the proper amount is used. We also recommend that the District implement a formal review process over the reporting requirement relating to ESSER annual reports. View of Responsible Officials: There is no disagreement with the audit finding.