FAC Explorer

Audit 301669

FY End
2023-06-30
Total Expended
$3.02M
Findings
10
Programs
13
Organization: Cedarburg School District (WI)
Year: 2023 Accepted: 2024-04-01
Auditor: Johnson Block & Company INC

Organization Exclusion Status:

Findings

ID Ref Severity Repeat Requirement
391068 2023-001 Material Weakness Yes P
391069 2023-001 Material Weakness Yes P
391070 2023-001 Material Weakness Yes P
391071 2023-001 Material Weakness Yes P
391072 2023-001 Material Weakness Yes P
967510 2023-001 Material Weakness Yes P
967511 2023-001 Material Weakness Yes P
967512 2023-001 Material Weakness Yes P
967513 2023-001 Material Weakness Yes P
967514 2023-001 Material Weakness Yes P

Programs

ALN Program Spent Major Findings
84.027 Special Education_grants to States $760,189 Yes 1
84.425 Education Stabilization Fund $565,056 Yes 1
32.009 Emergency Connectivity Fund Program $301,340 - 0
10.555 National School Lunch Program $300,278 - 0
93.778 Medical Assistance Program $169,911 - 0
84.010 Title I Grants to Local Educational Agencies $68,829 - 0
84.367 Supporting Effective Instruction State Grants $43,982 - 0
10.553 School Breakfast Program $15,324 - 0
84.173 Special Education_preschool Grants $11,971 Yes 1
84.424 Student Support and Academic Enrichment Program $7,697 - 0
84.048 Career and Technical Education -- Basic Grants to States $7,641 - 0
84.365 English Language Acquisition State Grants $2,586 - 0
10.649 Pandemic Ebt Administrative Costs $628 - 0

Contacts

Name Title Type
LRRWLSRTCTN5 Ben Irwin Auditee
2623766114 Brent Nelson Auditor
No contacts on file

Notes to SEFA

Title: Subrecipients Accounting Policies: The accompanying schedules of expenditures of federal and state awards includes the federal and state grant activity of the Cedarburg School District and is presented on the 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 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 does not use the 10 percent de minimis indirect cost rate as allowed under the Uniform Guidance. There were no awards passed through to subrecipients.
Title: Special Education and School Age Program Accounting Policies: The accompanying schedules of expenditures of federal and state awards includes the federal and state grant activity of the Cedarburg School District and is presented on the 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 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 does not use the 10 percent de minimis indirect cost rate as allowed under the Uniform Guidance. 2022-2023 eligible costs under the Special Education and School Age Parents Program are $5,108,779. The 2023-2024 aid estimate is $1,609,265.
Title: Medical Assistance Program Accounting Policies: The accompanying schedules of expenditures of federal and state awards includes the federal and state grant activity of the Cedarburg School District and is presented on the 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 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 does not use the 10 percent de minimis indirect cost rate as allowed under the Uniform Guidance. 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. Medical Assistance Program – School Based Services, listed as a federal award, was considered a major state program.
Title: Food Distribution Accounting Policies: The accompanying schedules of expenditures of federal and state awards includes the federal and state grant activity of the Cedarburg School District and is presented on the 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 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 does not use the 10 percent de minimis indirect cost rate as allowed under the Uniform Guidance. Nonmonetary assistance is reported in the schedule at the fair market value of the commodities received and disbursed

Finding Details

Finding 2023-001
Finding #2023-001 – Material Adjustments (Prior year finding #2022-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District’s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding 2023-001
Finding #2023-001 – Material Adjustments (Prior year finding #2022-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District’s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding 2023-001
Finding #2023-001 – Material Adjustments (Prior year finding #2022-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District’s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding 2023-001
Finding #2023-001 – Material Adjustments (Prior year finding #2022-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District’s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding 2023-001
Finding #2023-001 – Material Adjustments (Prior year finding #2022-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District’s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding 2023-001
Finding #2023-001 – Material Adjustments (Prior year finding #2022-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District’s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding 2023-001
Finding #2023-001 – Material Adjustments (Prior year finding #2022-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District’s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding 2023-001
Finding #2023-001 – Material Adjustments (Prior year finding #2022-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District’s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding 2023-001
Finding #2023-001 – Material Adjustments (Prior year finding #2022-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District’s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.
Finding 2023-001
Finding #2023-001 – Material Adjustments (Prior year finding #2022-001) Condition: Material adjusting journal entries not prepared by the District before the audit were required to record and reconcile account balances. Effect: Financial reports generated by the accounting system may not provide an accurate reflection of the District’s financial position or activities. Not reconciling accounts on a timely basis could lead to errors or other problems not being recognized and resolved. Cause: Financial information was not recorded in a timely manner and material adjustments were needed in order to correct various transactions. Criteria: Material adjusting journal entries not prepared by the District before the audit are considered an internal control weakness. Recommendation: Policies and procedures should be implemented to ensure account balances are properly recorded in a timely manner. Response: The District will work to establish policies and procedures to reduce the materiality of adjusting journal entries proposed by the auditor.